using LYFZ.ComponentLibrary; using System; using System.Collections; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; namespace LYFZ.Software.MainBusiness.FinancialManagement { public partial class FrmPayroll : LYFZ.Software.UI.FinancialManagement.FrmPayroll { LYFZ.BLL.BLL_ErpOrder orbll = new LYFZ.BLL.BLL_ErpOrder(); LYFZ.BLL.BLL_ErpPayment ptbll = new BLL.BLL_ErpPayment(); LYFZ.BLL.BLL_AllViewSet avsbll = new BLL.BLL_AllViewSet(); LYFZ.BLL.BLL_ErpWagesSet wsbll = new BLL.BLL_ErpWagesSet(); LYFZ.BLL.BLL_ErpSystemConfigure sgbll = new BLL.BLL_ErpSystemConfigure(); LYFZ.BLL.BLL_ErpOrdersPhotography opbll = new BLL.BLL_ErpOrdersPhotography(); LYFZ.BLL.BLL_ErpWageCommissionSet wcsbll = new BLL.BLL_ErpWageCommissionSet(); LYFZ.BLL.BLL_ErpCommissionPercentage cpbll = new BLL.BLL_ErpCommissionPercentage(); LYFZ.BLL.BLL_ErpWageCommissionRecords wcrbll = new BLL.BLL_ErpWageCommissionRecords(); LYFZ.BLL.BLL_ErpPieceCommissionRecords pcrbll = new BLL.BLL_ErpPieceCommissionRecords(); private delegate void UpdateControl(); public FrmPayroll() { this.dgv.RowsAdded += dgv_RowsAdded; this.txtTimeStart.Leave += txtTimeStart_Leave; this.Resize += FrmPayroll_Resize; } ///

/// 一级景点个数 ///

int OneLevelCount = 0; ///

/// 二级景点个数 ///

int TwoLevelCount = 0; ///

/// 三级景点个数 ///

int ThreeLevelCount = 0; //景点等级比重 ///

/// 一级景点比重 ///

decimal OneLevel = 0; ///

/// 二级景点比重 ///

decimal TwoLevel = 0; ///

/// 三级景点比重 ///

decimal ThreeLevel = 0; ///

/// 摄影比重 ///

decimal MainPhotography = 0; ///

/// 摄影助理比重 ///

decimal DeputyPhotography = 0; ///

/// 化妆比重 ///

decimal MainMake = 0; ///

/// 化妆助理比重 ///

decimal DeputyMake = 0; ///

/// 引导比重 ///

decimal MainBootDivision = 0; ///

/// 引导助理比重 ///

decimal DeputyBootDivision = 0; ///

/// ///

DataTable dt_SystemConfigure = new DataTable(); ///

/// ///

DataTable tblSystemCategory = new DataTable(); ///

/// 是否首次远行 ///

bool IsFirstRun = true; ///

/// 窗体加载事件 ///

/// /// protected override void FrmPayroll_Shown(object sender, EventArgs e) { this.tblSystemCategory = new LYFZ.BLL.BLL_ErpSystemCategory().GetAllList(filedOrder: "ID asc").Tables[0]; this.txtTimeStart.DateValue = SDateTime.Now.Year + "-" + SDateTime.Now.Month + "-01"; this.txtTimeEnd.DateValue = Convert.ToDateTime(this.txtTimeStart.DateValue).AddMonths(1).AddSeconds(-1).ToString("yyyy-MM-dd"); dt_SystemConfigure = sgbll.GetAllList().Tables[0]; // 部门人员绑定 LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_DepartmentAndEmployee(this.cmbEmployeeName, IsFirstNodeNull: true, IsFirstNodeName: "全部", IsShowResign: false, IsShowAdmin: true); //项目类别 LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboxTreeView(this.cmbItemCategory, StrBindData: "订单前期,服务前期,订单后期,服务后期,其它消费,会员充值,服务卡充值,计件提成,礼服租售", IsFirstNodeNull: true); //流程状态 LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboxTreeView(this.cmbProcessStatus, StrBindData: "拍照OK,选片OK,取件OK", IsFirstNodeNull: true); //客户来源 LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_SystemCategory("AAAAAAF", this.cmbCustomerSource, IsFirstNodeNull: true, tbl: tblSystemCategory); //套系类别 LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_SystemCategory("BFAGAHBFDGCABAJIH", this.CtvPak_Name, IsFirstNodeNull: true, tbl: tblSystemCategory); //计件提成 LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_SystemCategory("BEBBAFACDCCFBJFI", this.cmbCommissionScheme, IsFirstNodeNull: true, tbl: tblSystemCategory); ////景点类别 //LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboxTreeView(this.cmbtreevSightsCategory, "内景,外景", IsFirstNodeNull: true); // 查看 this.cmbEmployeeName.Enabled = LYFZ.BLL.BLL_ErpUser.GetRights(LYFZ.BLL.BLL_ErpUser.CurrentUserRights.StatisticalInquiryAllWagesCompetence, CustomAttributes.OperatingAuthority.ViewAll); if (LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_Account != LYFZ.AuthorizeUserName.AdministratorsName) { this.cmbEmployeeName.TagFindText(LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_EmployeeID); this.cmbEmployeeName_ComboBoxTree_NodeMouseClick(null, null); } // 录入 btnSave.Enabled = LYFZ.BLL.BLL_ErpUser.GetRights(LYFZ.BLL.BLL_ErpUser.CurrentUserRights.StatisticalInquiryAllWagesCompetence, CustomAttributes.OperatingAuthority.Add); // 导出 btnExPort.Enabled = LYFZ.BLL.BLL_ErpUser.GetRights(LYFZ.BLL.BLL_ErpUser.CurrentUserRights.StatisticalInquiryAllWagesCompetence, CustomAttributes.OperatingAuthority.DataExport); // 获取景点等级级别比重 if (cpbll.GetList("Cp_ProportionCode='BEBBBCADDEBFJDFFC'").Tables[0].Rows.Count > 0) { OneLevel = Convert.ToDecimal(cpbll.GetList("Cp_ProportionCode='BEBBBCADDEBFJDFFC'").Tables[0].Rows[0]["Cp_Proportion"]); } if (cpbll.GetList("Cp_ProportionCode='BEBBBCADEGBGAFFJC'").Tables[0].Rows.Count > 0) { TwoLevel = Convert.ToDecimal(cpbll.GetList("Cp_ProportionCode='BEBBBCADEGBGAFFJC'").Tables[0].Rows[0]["Cp_Proportion"]); } if (cpbll.GetList("Cp_ProportionCode='BEBBBCADAFBHBCHCI'").Tables[0].Rows.Count > 0) { ThreeLevel = Convert.ToDecimal(cpbll.GetList("Cp_ProportionCode='BEBBBCADAFBHBCHCI'").Tables[0].Rows[0]["Cp_Proportion"]); } // 获取摄影比重 if (cpbll.GetList("Cp_ProportionCode='MainPhotography'").Tables[0].Rows.Count > 0) { MainPhotography = Convert.ToDecimal(cpbll.GetList("Cp_ProportionCode='MainPhotography'").Tables[0].Rows[0]["Cp_Proportion"]); } if (cpbll.GetList("Cp_ProportionCode='DeputyPhotography'").Tables[0].Rows.Count > 0) { DeputyPhotography = Convert.ToDecimal(cpbll.GetList("Cp_ProportionCode='DeputyPhotography'").Tables[0].Rows[0]["Cp_Proportion"]); } // 获取化妆比重 if (cpbll.GetList("Cp_ProportionCode='MainMake'").Tables[0].Rows.Count > 0) { MainMake = Convert.ToDecimal(cpbll.GetList("Cp_ProportionCode='MainMake'").Tables[0].Rows[0]["Cp_Proportion"]); } if (cpbll.GetList("Cp_ProportionCode='DeputyMake'").Tables[0].Rows.Count > 0) { DeputyMake = Convert.ToDecimal(cpbll.GetList("Cp_ProportionCode='DeputyMake'").Tables[0].Rows[0]["Cp_Proportion"]); } // 获取引导比重 if (cpbll.GetList("Cp_ProportionCode='MainBootDivision'").Tables[0].Rows.Count > 0) { MainBootDivision = Convert.ToDecimal(cpbll.GetList("Cp_ProportionCode='MainBootDivision'").Tables[0].Rows[0]["Cp_Proportion"]); } if (cpbll.GetList("Cp_ProportionCode='DeputyBootDivision'").Tables[0].Rows.Count > 0) { DeputyBootDivision = Convert.ToDecimal(cpbll.GetList("Cp_ProportionCode='DeputyBootDivision'").Tables[0].Rows[0]["Cp_Proportion"]); } this.IsFirstRun = false; this.FrmPayroll_Resize(this, null); } ///

/// 获取儿童阶段金额 ///

/// 主订单号 /// 应该金额 /// 本次收款金额 /// 景点名称 /// public decimal GetChildrenAmount(string OrdNumber, decimal YsAmount, decimal BcAmount, string SightsName) { decimal Sum = 0; decimal ChildrenAmount = 0; decimal EveryAmount = 0; DataTable tbl = opbll.GetList("Ordpg_Number = '" + OrdNumber + "'", "Ordpg_ViceNumber ASC").Tables[0]; int Count = tbl.Rows.Count; //每次收款金额（平均分） if (Count > 0) { EveryAmount = YsAmount / Count; } //获取收款金额 DataTable dt = ptbll.GetSum("Pay_OrdNumber = '" + OrdNumber + "' and Pay_Category != '后期收款'").Tables[0]; if (!string.IsNullOrEmpty(dt.Rows[0]["Pay_AmountOf"].ToString())) { ChildrenAmount = Convert.ToDecimal(dt.Rows[0]["Pay_AmountOf"].ToString()); } //for (int i = 0; i < tbl.Rows.Count; i++) //{ // if (SightsName == tbl.Rows[i]["Ordpg_Sights"].ToString().Trim()) // { // ChildrenAmount = ChildrenAmount - EveryAmount; // if (ChildrenAmount > EveryAmount) // { Sum = EveryAmount; } // else // { Sum = ChildrenAmount; } // break; // } // else // { ChildrenAmount = ChildrenAmount - EveryAmount; } //} if ((ChildrenAmount / Count) == EveryAmount) { if (ptbll.GetList("Pay_OrdNumber = '" + OrdNumber + "' and Pay_Category != '后期收款'").Tables[0].Rows.Count == 1) { Sum = EveryAmount; } else { Sum = BcAmount / Count; } } else { if (ChildrenAmount < EveryAmount) { for (int i = 0; i < tbl.Rows.Count; i++) { string Ordpg_Sights = tbl.Rows[i]["Ordpg_Sights"].ToString(); if (SightsName == Ordpg_Sights) { if (i + 1 == 1) { Sum = ChildrenAmount / ptbll.GetList("Pay_OrdNumber='" + OrdNumber + "' and Pay_Category!='后期收款'").Tables[0].Rows.Count; } else { Sum = 0; } } } } if (ChildrenAmount >= EveryAmount) { for (int i = 0; i < tbl.Rows.Count; i++) { string Ordpg_Sights = tbl.Rows[i]["Ordpg_Sights"].ToString(); if (SightsName == Ordpg_Sights) { if (ChildrenAmount > (EveryAmount * (i + 1))) { if (ptbll.GetList("Pay_OrdNumber='" + OrdNumber + "' and Pay_Category!='后期收款'").Tables[0].Rows.Count == 1) { Sum = EveryAmount; } else { Sum = EveryAmount / ptbll.GetList("Pay_OrdNumber='" + OrdNumber + "' and Pay_Category!='后期收款'").Tables[0].Rows.Count; } } else { Sum = 0; } } } } } return Convert.ToDecimal(Sum.ToString("N2")); } ///

/// 获取所有业绩列表 ///

/// /// /// /// /// public decimal BindPerformance(string StartTime, string EndTime, string EmployeeName, BackgroundWorker backgroundWorker) { this.Invoke(new UpdateControl(delegate() { this.dgv.Rows.Clear(); })); string StrUserName = ""; if (!string.IsNullOrEmpty(EmployeeName)) { DataRow dtRow = LYFZ.DAL.DAL_ErpUser.SimpleUserDataTable.Rows.Find(EmployeeName); if (dtRow != null) { StrUserName = dtRow["User_Name"].ToString().Trim(); } } decimal Sum = 0; string s = ""; StringBuilder strBuilder = new StringBuilder(); #region 列表 if (string.IsNullOrEmpty(this.Str_ItemCategory.Trim()) || this.Str_ItemCategory.Trim() == "订单前期" || this.Str_ItemCategory.Trim() == "订单后期" || this.Str_ItemCategory.Trim() == "其它消费" || this.Str_ItemCategory.Trim() == "礼服租售") { #region 获取订单收款(前期收款，后期收款，其它消费)收款后即分提成 strBuilder.Append(" 1 = 1 "); string StrPaymentWhere = ""; if (string.IsNullOrEmpty(this.Str_ProcessStatus.Trim())) { strBuilder.Append("and 收款时间>='" + StartTime + "' and 收款时间<='" + EndTime + " 23:59:59.000' "); } //if (string.IsNullOrEmpty(this.Str_ProcessStatus.Trim())) //{ StrPaymentWhere = "and Pay_CreateDatetime >= '" + StartTime + "' and 收款时间<='" + EndTime + " 23:59:59.000' "; } else if (!string.IsNullOrEmpty(this.Str_ProcessStatus.Trim())) { if (this.Str_ProcessStatus.Trim() == "拍照OK") { strBuilder.Append("and 未拍个数 = 0 and (最后拍摄时间 >= '" + StartTime + "' and 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "选片OK") { strBuilder.Append("and 选片状态 = '1' and (选片时间 >= '" + StartTime + "' and 选片时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "取件OK") { strBuilder.Append("and 取件状态 = 'OK' and (取件日期 >= '" + StartTime + "' and 取件日期 <= '" + EndTime + " 23:59:59.000')"); } strBuilder.Append("and (收款类别 = '全款' or 收款类别 = '预约补款' or 收款类别 = '预约收款' or 二销类别编号 = 'BEBCABBAAHFCJBJGJ')"); } if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName)) { strBuilder.Append("and 接单人编号 like '%" + EmployeeName + "%'"); } if (!string.IsNullOrEmpty(this.Str_Scores1)) { strBuilder.Append("and (门市满意总分>=" + this.Str_Scores1 + " and 门市满意总分<=" + this.Str_Scores2 + ")"); } bool IsQuery = true; s = BindSelect1(ref IsQuery); if (IsQuery) { DataTable dtCount = orbll.GetView_Custom("Vw_StaffPerformance_OrdersPerson", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0]; //DataTable dtCount = LYFZ.BLL.BLL_ErpPaymentPayrollClass.GetPayrollOrderPerson(StrPaymentWhere, strBuilder.ToString() + s.ToString()); // orbll.GetView_Custom("Vw_StaffPerformance_OrdersPerson", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0]; if (dtCount.Rows.Count > 0) { if (Convert.ToInt32(dtCount.Rows[0]["CountID"]) > 0) { backgroundWorker.ReportProgress(0, "正在获取'门市接单' ..."); string StrColumnName = "订单号,接单人名称,主门市,客户名称,主门市金额,副门市金额,收款时间,收款类型,套系类别,套系名称,项目名称,应收金额,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,拍摄阶段,门市满意总分"; //DataTable dt_OrderPayment = avsbll.Vw_StaffPerformance_OrdersPerson(str.ToString() + s.ToString()).Tables[0]; DataTable dt_OrderPayment = orbll.GetView_Custom("Vw_StaffPerformance_OrdersPerson", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0]; for (int t = 0; t < dt_OrderPayment.Rows.Count; t++) { #region DataGridViewRow dgvr = new DataGridViewRow(); DataGridViewCell cell = null; //订单号 cell = new DataGridViewTextBoxCell(); cell.Value = dt_OrderPayment.Rows[t]["订单号"].ToString().Trim(); dgvr.Cells.Add(cell); //员工 cell = new DataGridViewTextBoxCell(); cell.Value = dt_OrderPayment.Rows[t]["接单人名称"].ToString().Trim(); dgvr.Cells.Add(cell); //职务 cell = new DataGridViewTextBoxCell(); #region 前期收款，后期收款 if (!string.IsNullOrEmpty(dt_OrderPayment.Rows[t]["主门市"].ToString())) { if (dt_OrderPayment.Rows[t]["主门市"].ToString() == EmployeeName) { cell.Value = "主接单人"; } else { cell.Value = "副接单人"; } } #endregion dgvr.Cells.Add(cell); //客户姓名 cell = new DataGridViewTextBoxCell(); cell.Value = dt_OrderPayment.Rows[t]["客户名称"].ToString().Trim(); dgvr.Cells.Add(cell); //收款金额 cell = new DataGridViewTextBoxCell(); #region 前期收款，后期收款 if (!string.IsNullOrEmpty(dt_OrderPayment.Rows[t]["主门市"].ToString())) { if (dt_OrderPayment.Rows[t]["主门市"].ToString() == EmployeeName) { cell.Value = Convert.ToDecimal(dt_OrderPayment.Rows[t]["主门市金额"]).ToString("N2"); } else { cell.Value = Convert.ToDecimal(dt_OrderPayment.Rows[t]["副门市金额"]).ToString("N2"); } } #endregion dgvr.Cells.Add(cell); //收款时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_OrderPayment.Rows[t]["收款时间"].ToString().Trim(); dgvr.Cells.Add(cell); //套系类别 cell = new DataGridViewTextBoxCell(); if (dt_OrderPayment.Rows[t]["收款类型"].ToString() == "0") { cell.Value = dt_OrderPayment.Rows[t]["套系类别"].ToString().Trim(); } if (dt_OrderPayment.Rows[t]["收款类型"].ToString() == "1") { cell.Value = "/其它消费"; } if (dt_OrderPayment.Rows[t]["收款类型"].ToString() == "2") { cell.Value = "/礼服租售"; } dgvr.Cells.Add(cell); //套系名称 cell = new DataGridViewTextBoxCell(); if (dt_OrderPayment.Rows[t]["收款类型"].ToString() == "0") { cell.Value = dt_OrderPayment.Rows[t]["套系名称"].ToString().Trim(); } if (dt_OrderPayment.Rows[t]["收款类型"].ToString() == "1") { cell.Value = dt_OrderPayment.Rows[t]["项目名称"].ToString().Trim(); } dgvr.Cells.Add(cell); //应收金额 cell = new DataGridViewTextBoxCell(); if (!string.IsNullOrEmpty(dt_OrderPayment.Rows[t]["应收金额"].ToString().Trim())) { cell.Value = Convert.ToDecimal(dt_OrderPayment.Rows[t]["应收金额"]).ToString("N2").Trim(); } else { cell.Value = 0; } dgvr.Cells.Add(cell); //项目名称 cell = new DataGridViewTextBoxCell(); if (dt_OrderPayment.Rows[t]["收款类型"].ToString() == "0") { if (string.IsNullOrEmpty(dt_OrderPayment.Rows[t]["项目名称"].ToString().Trim())) { cell.Value = dt_OrderPayment.Rows[t]["收款类别"].ToString(); } else { cell.Value = dt_OrderPayment.Rows[t]["项目名称"].ToString().Trim(); } } else { cell.Value = dt_OrderPayment.Rows[t]["项目名称"].ToString().Trim(); } dgvr.Cells.Add(cell); //付款名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_OrderPayment.Rows[t]["付款方式名称"].ToString().Trim(); dgvr.Cells.Add(cell); #region if (dt_OrderPayment.Rows[t]["收款类型"].ToString() == "0") { //拍摄状态 cell = new DataGridViewTextBoxCell(); if (Convert.ToInt32(dt_OrderPayment.Rows[t]["未拍个数"]) == 0) { cell.Value = "OK"; } else { cell.Value = "未拍"; } dgvr.Cells.Add(cell); //拍摄时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_OrderPayment.Rows[t]["最后拍摄时间"].ToString(); dgvr.Cells.Add(cell); //选片状态 cell = new DataGridViewTextBoxCell(); if (dt_OrderPayment.Rows[t]["选片状态"].ToString() == "1") { cell.Value = "OK"; } else { cell.Value = "未选"; } dgvr.Cells.Add(cell); //选片时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_OrderPayment.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //取件状态 cell = new DataGridViewTextBoxCell(); if (dt_OrderPayment.Rows[t]["取件状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未取"; } dgvr.Cells.Add(cell); //拍摄阶段 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_OrderPayment.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //取件时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_OrderPayment.Rows[t]["拍摄阶段"].ToString(); dgvr.Cells.Add(cell); //订单类型 cell = new DataGridViewTextBoxCell(); cell.Value = ""; dgvr.Cells.Add(cell); //收款类型 cell = new DataGridViewTextBoxCell(); cell.Value = ""; dgvr.Cells.Add(cell); //副订单 cell = new DataGridViewTextBoxCell(); cell.Value = ""; dgvr.Cells.Add(cell); //门市满意度 cell = new DataGridViewTextBoxCell(); cell.Value = dt_OrderPayment.Rows[t]["门市满意总分"].ToString(); dgvr.Cells.Add(cell); } #endregion this.Invoke(new UpdateControl(delegate() { this.dgv.Rows.Add(dgvr); })); #endregion } } } } #endregion } if (this.Str_ItemCategory.Trim() == "" || this.Str_ItemCategory.Trim() == "服务前期" || this.Str_ItemCategory.Trim() == "服务后期") { #region 获取流程状态（前期收款(摄影，化妆，引导，初修，精修，设计)前期业绩，选片二销业绩） if (this.Str_ItemCategory.Trim() == "" || this.Str_ItemCategory.Trim() == "服务前期") { #region 前期业绩 DataRow[] ConfigureRow = dt_SystemConfigure.Select("Sconfig_Code='PhotographersEarly' and Sconfig_IsEnabled=1"); if (ConfigureRow.Length > 0) { if (ConfigureRow[0]["Sconfig_Value"].ToString() == "1") { if (this.Str_ProjectTitle.Trim() == "" || this.Str_ProjectTitle.Trim() == "摄影前期") { #region 主摄影师 s = ""; strBuilder = new StringBuilder(); strBuilder.Append(" 收款类别 <> '后期收款'"); if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName)) { strBuilder.Append(" And 主摄影师ID like '%" + EmployeeName + "%' "); } if (this.Str_ProcessStatus.Trim() == "") { strBuilder.Append(" And 未拍个数 = 0 And (服务前期查询时间 >= '" + StartTime + "' And 服务前期查询时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "拍照OK") { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间>='" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "选片OK") { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "取件OK") { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); } if (!string.IsNullOrEmpty(this.Str_Scores1)) { strBuilder.Append(" and (主摄影满意总分>=" + this.Str_Scores1 + " and 主摄影满意总分<=" + this.Str_Scores2 + ")"); } s = BindSelect5(); DataTable dtCount1 = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0]; if (dtCount1.Rows.Count > 0) { if (Convert.ToInt32(dtCount1.Rows[0]["CountID"]) > 0) { backgroundWorker.ReportProgress(0, "正在获取'主摄影师前期业绩' ..."); string StrColumnName = "订单号,客户名称,订单类型,收款金额,应收金额,拍摄名称,收款时间,套系类别,套系名称,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,副订单,主摄影满意总分"; DataTable dt_MainPhotographer = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0]; for (int t = 0; t < dt_MainPhotographer.Rows.Count; t++) { #region DataGridViewRow dgvr = new DataGridViewRow(); DataGridViewCell cell = null; //订单号 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainPhotographer.Rows[t]["订单号"].ToString().Trim(); dgvr.Cells.Add(cell); //员工 cell = new DataGridViewTextBoxCell(); cell.Value = StrUserName; dgvr.Cells.Add(cell); //职务 cell = new DataGridViewTextBoxCell(); cell.Value = "主摄影师"; dgvr.Cells.Add(cell); //客户姓名 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainPhotographer.Rows[t]["客户名称"].ToString().Trim(); dgvr.Cells.Add(cell); //收款金额 cell = new DataGridViewTextBoxCell(); if (dt_MainPhotographer.Rows[t]["订单类型"].ToString() != "1") { cell.Value = Convert.ToDecimal(dt_MainPhotographer.Rows[t]["收款金额"]).ToString("N2"); } else { cell.Value = GetChildrenAmount(dt_MainPhotographer.Rows[t]["订单号"].ToString().Trim(), Convert.ToDecimal(dt_MainPhotographer.Rows[t]["应收金额"]), Convert.ToDecimal(dt_MainPhotographer.Rows[t]["收款金额"]), dt_MainPhotographer.Rows[t]["拍摄名称"].ToString()); } dgvr.Cells.Add(cell); //收款时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainPhotographer.Rows[t]["收款时间"].ToString().Trim(); dgvr.Cells.Add(cell); //套系类别 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainPhotographer.Rows[t]["套系类别"].ToString().Trim(); dgvr.Cells.Add(cell); //套系名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainPhotographer.Rows[t]["套系名称"].ToString().Trim(); dgvr.Cells.Add(cell); //应收金额 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(dt_MainPhotographer.Rows[t]["应收金额"]).ToString("N2").Trim(); dgvr.Cells.Add(cell); //项目名称 cell = new DataGridViewTextBoxCell(); if (string.IsNullOrEmpty(dt_MainPhotographer.Rows[t]["项目名称"].ToString().Trim())) { cell.Value = dt_MainPhotographer.Rows[t]["收款类别"].ToString(); } else { cell.Value = dt_MainPhotographer.Rows[t]["项目名称"].ToString().Trim(); } dgvr.Cells.Add(cell); //付款名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainPhotographer.Rows[t]["付款方式名称"].ToString().Trim(); dgvr.Cells.Add(cell); //拍摄状态 cell = new DataGridViewTextBoxCell(); if (Convert.ToInt32(dt_MainPhotographer.Rows[t]["未拍个数"]) == 0) { cell.Value = "OK"; } else { cell.Value = "未拍"; } dgvr.Cells.Add(cell); //拍摄时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainPhotographer.Rows[t]["最后拍摄时间"].ToString(); dgvr.Cells.Add(cell); //选片状态 cell = new DataGridViewTextBoxCell(); if (dt_MainPhotographer.Rows[t]["选片状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未选"; } dgvr.Cells.Add(cell); //选片时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_MainPhotographer.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //取件状态 cell = new DataGridViewTextBoxCell(); if (dt_MainPhotographer.Rows[t]["取件状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未取"; } dgvr.Cells.Add(cell); //取件时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_MainPhotographer.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //拍摄名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainPhotographer.Rows[t]["拍摄名称"].ToString(); dgvr.Cells.Add(cell); //订单类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainPhotographer.Rows[t]["订单类型"].ToString(); dgvr.Cells.Add(cell); //收款类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainPhotographer.Rows[t]["收款类别"].ToString(); dgvr.Cells.Add(cell); //副订单 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainPhotographer.Rows[t]["副订单"].ToString(); dgvr.Cells.Add(cell); //主摄影满意总分 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainPhotographer.Rows[t]["主摄影满意总分"].ToString(); dgvr.Cells.Add(cell); this.Invoke(new UpdateControl(delegate() { this.dgv.Rows.Add(dgvr); })); #endregion } } } #endregion #region 摄影助理 s = ""; strBuilder = new StringBuilder(); strBuilder.Append(" 收款类别 <> '后期收款'"); if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName)) { strBuilder.Append(" And 摄影助理ID like '%" + EmployeeName + "%' "); } if (this.Str_ProcessStatus.Trim() == "") { strBuilder.Append(" And 未拍个数 = 0 And (服务前期查询时间 >= '" + StartTime + "' And 服务前期查询时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "拍照OK") { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "选片OK") { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "取件OK") { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); } if (!string.IsNullOrEmpty(this.Str_Scores1)) { strBuilder.Append(" and (摄影助理满意总分>=" + this.Str_Scores1 + " and 摄影助理满意总分<=" + this.Str_Scores2 + ")"); } s = BindSelect5(); DataTable dtCount2 = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0]; if (dtCount2.Rows.Count > 0) { if (Convert.ToInt32(dtCount2.Rows[0]["CountID"]) > 0) { backgroundWorker.ReportProgress(0, "正在获取'摄影助理前期业绩' ..."); string StrColumnName = "订单号,客户名称,订单类型,收款金额,应收金额,拍摄名称,收款时间,套系类别,套系名称,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,副订单,摄影助理满意总分"; DataTable dt_VicePhotographer = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0]; for (int t = 0; t < dt_VicePhotographer.Rows.Count; t++) { #region DataGridViewRow dgvr = new DataGridViewRow(); DataGridViewCell cell = null; //订单号 cell = new DataGridViewTextBoxCell(); cell.Value = dt_VicePhotographer.Rows[t]["订单号"].ToString().Trim(); dgvr.Cells.Add(cell); //员工 cell = new DataGridViewTextBoxCell(); cell.Value = StrUserName; dgvr.Cells.Add(cell); //职务 cell = new DataGridViewTextBoxCell(); cell.Value = "摄影助理"; dgvr.Cells.Add(cell); //客户姓名 cell = new DataGridViewTextBoxCell(); cell.Value = dt_VicePhotographer.Rows[t]["客户名称"].ToString().Trim(); dgvr.Cells.Add(cell); //收款金额 cell = new DataGridViewTextBoxCell(); if (dt_VicePhotographer.Rows[t]["订单类型"].ToString() != "1") { cell.Value = Convert.ToDecimal(dt_VicePhotographer.Rows[t]["收款金额"]).ToString("N2"); } else { cell.Value = GetChildrenAmount(dt_VicePhotographer.Rows[t]["订单号"].ToString().Trim(), Convert.ToDecimal(dt_VicePhotographer.Rows[t]["应收金额"]), Convert.ToDecimal(dt_VicePhotographer.Rows[t]["收款金额"]), dt_VicePhotographer.Rows[t]["拍摄名称"].ToString()); } dgvr.Cells.Add(cell); //收款时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_VicePhotographer.Rows[t]["收款时间"].ToString().Trim(); dgvr.Cells.Add(cell); //套系类别 cell = new DataGridViewTextBoxCell(); cell.Value = dt_VicePhotographer.Rows[t]["套系类别"].ToString().Trim(); dgvr.Cells.Add(cell); //套系名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_VicePhotographer.Rows[t]["套系名称"].ToString().Trim(); dgvr.Cells.Add(cell); //应收金额 cell = new DataGridViewTextBoxCell(); cell.Value = dt_VicePhotographer.Rows[t]["应收金额"].ToString().Trim(); dgvr.Cells.Add(cell); //项目名称 cell = new DataGridViewTextBoxCell(); if (string.IsNullOrEmpty(dt_VicePhotographer.Rows[t]["项目名称"].ToString().Trim())) { cell.Value = dt_VicePhotographer.Rows[t]["收款类别"].ToString(); } else { cell.Value = dt_VicePhotographer.Rows[t]["项目名称"].ToString().Trim(); } dgvr.Cells.Add(cell); //付款名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_VicePhotographer.Rows[t]["付款方式名称"].ToString().Trim(); dgvr.Cells.Add(cell); //拍摄状态 cell = new DataGridViewTextBoxCell(); if (Convert.ToInt32(dt_VicePhotographer.Rows[t]["未拍个数"]) == 0) { cell.Value = "OK"; } else { cell.Value = "未拍"; } dgvr.Cells.Add(cell); //拍摄时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_VicePhotographer.Rows[t]["最后拍摄时间"].ToString(); dgvr.Cells.Add(cell); //选片状态 cell = new DataGridViewTextBoxCell(); if (dt_VicePhotographer.Rows[t]["选片状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未选"; } dgvr.Cells.Add(cell); //选片时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_VicePhotographer.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //取件状态 cell = new DataGridViewTextBoxCell(); if (dt_VicePhotographer.Rows[t]["取件状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未取"; } dgvr.Cells.Add(cell); //取件时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_VicePhotographer.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //拍摄名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_VicePhotographer.Rows[t]["拍摄名称"].ToString(); dgvr.Cells.Add(cell); //订单类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_VicePhotographer.Rows[t]["订单类型"].ToString(); dgvr.Cells.Add(cell); //收款类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_VicePhotographer.Rows[t]["收款类别"].ToString(); dgvr.Cells.Add(cell); //副订单 cell = new DataGridViewTextBoxCell(); cell.Value = dt_VicePhotographer.Rows[t]["副订单"].ToString(); dgvr.Cells.Add(cell); //摄影助理满意总分 cell = new DataGridViewTextBoxCell(); cell.Value = dt_VicePhotographer.Rows[t]["摄影助理满意总分"].ToString(); dgvr.Cells.Add(cell); this.Invoke(new UpdateControl(delegate() { this.dgv.Rows.Add(dgvr); })); #endregion } } } #endregion } } } ConfigureRow = dt_SystemConfigure.Select("Sconfig_Code='MakeupArtistEarly' and Sconfig_IsEnabled=1"); if (ConfigureRow.Length > 0) { if (ConfigureRow[0]["Sconfig_Value"].ToString() == "1") { if (this.Str_ProjectTitle.Trim() == "" || this.Str_ProjectTitle.Trim() == "化妆前期") { #region 主化妆师 s = ""; strBuilder = new StringBuilder(); strBuilder.Append(" 收款类别 <> '后期收款'"); if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName)) { strBuilder.Append(" And 主化妆ID like '%" + EmployeeName + "%' "); } if (this.Str_ProcessStatus.Trim() == "") { strBuilder.Append(" And 未拍个数 = 0 And (服务前期查询时间 >= '" + StartTime + "' And 服务前期查询时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "拍照OK") { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "选片OK") { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "取件OK") { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); } if (!string.IsNullOrEmpty(this.Str_Scores1)) { strBuilder.Append(" and (主化妆满意总分>=" + this.Str_Scores1 + " and 主化妆满意总分<=" + this.Str_Scores2 + ")"); } s = BindSelect5(); DataTable dtCount1 = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0]; if (dtCount1.Rows.Count > 0) { if (Convert.ToInt32(dtCount1.Rows[0]["CountID"]) > 0) { backgroundWorker.ReportProgress(0, "正在获取'主化妆师前期业绩' ..."); string StrColumnName = "订单号,客户名称,订单类型,收款金额,应收金额,拍摄名称,收款时间,套系类别,套系名称,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,副订单,主化妆满意总分"; DataTable dt_MainMakeupArtist = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0]; for (int t = 0; t < dt_MainMakeupArtist.Rows.Count; t++) { #region DataGridViewRow dgvr = new DataGridViewRow(); DataGridViewCell cell = null; //订单号 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainMakeupArtist.Rows[t]["订单号"].ToString().Trim(); dgvr.Cells.Add(cell); //员工 cell = new DataGridViewTextBoxCell(); cell.Value = StrUserName; dgvr.Cells.Add(cell); //职务 cell = new DataGridViewTextBoxCell(); cell.Value = "主化妆师"; dgvr.Cells.Add(cell); //客户姓名 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainMakeupArtist.Rows[t]["客户名称"].ToString().Trim(); dgvr.Cells.Add(cell); //收款金额 cell = new DataGridViewTextBoxCell(); if (dt_MainMakeupArtist.Rows[t]["订单类型"].ToString() != "1") { cell.Value = Convert.ToDecimal(dt_MainMakeupArtist.Rows[t]["收款金额"]).ToString("N2"); } else { cell.Value = GetChildrenAmount(dt_MainMakeupArtist.Rows[t]["订单号"].ToString().Trim(), Convert.ToDecimal(dt_MainMakeupArtist.Rows[t]["应收金额"]), Convert.ToDecimal(dt_MainMakeupArtist.Rows[t]["收款金额"]), dt_MainMakeupArtist.Rows[t]["拍摄名称"].ToString()); } dgvr.Cells.Add(cell); //收款时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainMakeupArtist.Rows[t]["收款时间"].ToString().Trim(); dgvr.Cells.Add(cell); //套系类别 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainMakeupArtist.Rows[t]["套系类别"].ToString().Trim(); dgvr.Cells.Add(cell); //套系名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainMakeupArtist.Rows[t]["套系名称"].ToString().Trim(); dgvr.Cells.Add(cell); //应收金额 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(dt_MainMakeupArtist.Rows[t]["应收金额"]).ToString("N2").Trim(); dgvr.Cells.Add(cell); //项目名称 cell = new DataGridViewTextBoxCell(); if (string.IsNullOrEmpty(dt_MainMakeupArtist.Rows[t]["项目名称"].ToString().Trim())) { cell.Value = dt_MainMakeupArtist.Rows[t]["收款类别"].ToString(); } else { cell.Value = dt_MainMakeupArtist.Rows[t]["项目名称"].ToString().Trim(); } dgvr.Cells.Add(cell); //付款名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainMakeupArtist.Rows[t]["付款方式名称"].ToString().Trim(); dgvr.Cells.Add(cell); //拍摄状态 cell = new DataGridViewTextBoxCell(); if (Convert.ToInt32(dt_MainMakeupArtist.Rows[t]["未拍个数"]) == 0) { cell.Value = "OK"; } else { cell.Value = "未拍"; } dgvr.Cells.Add(cell); //拍摄时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainMakeupArtist.Rows[t]["最后拍摄时间"].ToString(); dgvr.Cells.Add(cell); //选片状态 cell = new DataGridViewTextBoxCell(); if (dt_MainMakeupArtist.Rows[t]["选片状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未选"; } dgvr.Cells.Add(cell); //选片时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_MainMakeupArtist.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //取件状态 cell = new DataGridViewTextBoxCell(); if (dt_MainMakeupArtist.Rows[t]["取件状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未取"; } dgvr.Cells.Add(cell); //取件时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_MainMakeupArtist.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //拍摄名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainMakeupArtist.Rows[t]["拍摄名称"].ToString(); dgvr.Cells.Add(cell); //订单类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainMakeupArtist.Rows[t]["订单类型"].ToString(); dgvr.Cells.Add(cell); //收款类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainMakeupArtist.Rows[t]["收款类别"].ToString(); dgvr.Cells.Add(cell); //副订单 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainMakeupArtist.Rows[t]["副订单"].ToString(); dgvr.Cells.Add(cell); //主化妆满意总分 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainMakeupArtist.Rows[t]["主化妆满意总分"].ToString(); dgvr.Cells.Add(cell); #endregion this.Invoke(new UpdateControl(delegate() { this.dgv.Rows.Add(dgvr); })); } } } #endregion #region 化妆助理 s = ""; strBuilder = new StringBuilder(); strBuilder.Append(" 收款类别 <> '后期收款'"); if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName)) { strBuilder.Append(" And 化妆助理ID like '%" + EmployeeName + "%' "); } if (this.Str_ProcessStatus.Trim() == "") { strBuilder.Append(" And 未拍个数 = 0 And (服务前期查询时间 >= '" + StartTime + "' And 服务前期查询时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "拍照OK") { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "选片OK") { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "取件OK") { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); } if (!string.IsNullOrEmpty(this.Str_Scores1)) { strBuilder.Append(" and (化妆助理满意总分>=" + this.Str_Scores1 + " and 化妆助理满意总分<=" + this.Str_Scores2 + ")"); } s = BindSelect5(); DataTable dtCount2 = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0]; if (dtCount2.Rows.Count > 0) { if (Convert.ToInt32(dtCount2.Rows[0]["CountID"]) > 0) { backgroundWorker.ReportProgress(0, "正在获取'化妆助理前期业绩' ..."); string StrColumnName = "订单号,客户名称,订单类型,收款金额,应收金额,拍摄名称,收款时间,套系类别,套系名称,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,副订单,化妆助理满意总分"; DataTable dt_ViceMakeupArtist = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0]; for (int t = 0; t < dt_ViceMakeupArtist.Rows.Count; t++) { #region DataGridViewRow dgvr = new DataGridViewRow(); DataGridViewCell cell = null; //订单号 cell = new DataGridViewTextBoxCell(); cell.Value = dt_ViceMakeupArtist.Rows[t]["订单号"].ToString().Trim(); dgvr.Cells.Add(cell); //员工 cell = new DataGridViewTextBoxCell(); cell.Value = StrUserName; dgvr.Cells.Add(cell); //职务 cell = new DataGridViewTextBoxCell(); cell.Value = "化妆助理"; dgvr.Cells.Add(cell); //客户姓名 cell = new DataGridViewTextBoxCell(); cell.Value = dt_ViceMakeupArtist.Rows[t]["客户名称"].ToString().Trim(); dgvr.Cells.Add(cell); //收款金额 cell = new DataGridViewTextBoxCell(); if (dt_ViceMakeupArtist.Rows[t]["订单类型"].ToString() != "1") { cell.Value = Convert.ToDecimal(dt_ViceMakeupArtist.Rows[t]["收款金额"]).ToString("N2"); } else { cell.Value = GetChildrenAmount(dt_ViceMakeupArtist.Rows[t]["订单号"].ToString().Trim(), Convert.ToDecimal(dt_ViceMakeupArtist.Rows[t]["应收金额"]), Convert.ToDecimal(dt_ViceMakeupArtist.Rows[t]["收款金额"]), dt_ViceMakeupArtist.Rows[t]["拍摄名称"].ToString()); } dgvr.Cells.Add(cell); //收款时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_ViceMakeupArtist.Rows[t]["收款时间"].ToString().Trim(); dgvr.Cells.Add(cell); //套系类别 cell = new DataGridViewTextBoxCell(); cell.Value = dt_ViceMakeupArtist.Rows[t]["套系类别"].ToString().Trim(); dgvr.Cells.Add(cell); //套系名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_ViceMakeupArtist.Rows[t]["套系名称"].ToString().Trim(); dgvr.Cells.Add(cell); //应收金额 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(dt_ViceMakeupArtist.Rows[t]["应收金额"]).ToString("N2").Trim(); dgvr.Cells.Add(cell); //项目名称 cell = new DataGridViewTextBoxCell(); if (string.IsNullOrEmpty(dt_ViceMakeupArtist.Rows[t]["项目名称"].ToString().Trim())) { cell.Value = dt_ViceMakeupArtist.Rows[t]["收款类别"].ToString(); } else { cell.Value = dt_ViceMakeupArtist.Rows[t]["项目名称"].ToString().Trim(); } dgvr.Cells.Add(cell); //付款名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_ViceMakeupArtist.Rows[t]["付款方式名称"].ToString().Trim(); dgvr.Cells.Add(cell); //拍摄状态 cell = new DataGridViewTextBoxCell(); if (Convert.ToInt32(dt_ViceMakeupArtist.Rows[t]["未拍个数"]) == 0) { cell.Value = "OK"; } else { cell.Value = "未拍"; } dgvr.Cells.Add(cell); //拍摄时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_ViceMakeupArtist.Rows[t]["最后拍摄时间"].ToString(); dgvr.Cells.Add(cell); //选片状态 cell = new DataGridViewTextBoxCell(); if (dt_ViceMakeupArtist.Rows[t]["选片状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未选"; } dgvr.Cells.Add(cell); //选片时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_ViceMakeupArtist.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //取件状态 cell = new DataGridViewTextBoxCell(); if (dt_ViceMakeupArtist.Rows[t]["取件状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未取"; } dgvr.Cells.Add(cell); //取件时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_ViceMakeupArtist.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //拍摄名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_ViceMakeupArtist.Rows[t]["拍摄名称"].ToString(); dgvr.Cells.Add(cell); //订单类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_ViceMakeupArtist.Rows[t]["订单类型"].ToString(); dgvr.Cells.Add(cell); //收款类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_ViceMakeupArtist.Rows[t]["收款类别"].ToString(); dgvr.Cells.Add(cell); //副订单 cell = new DataGridViewTextBoxCell(); cell.Value = dt_ViceMakeupArtist.Rows[t]["副订单"].ToString(); dgvr.Cells.Add(cell); //化妆助理满意总分 cell = new DataGridViewTextBoxCell(); cell.Value = dt_ViceMakeupArtist.Rows[t]["化妆助理满意总分"].ToString(); dgvr.Cells.Add(cell); #endregion this.Invoke(new UpdateControl(delegate() { this.dgv.Rows.Add(dgvr); })); } } } #endregion } } } ConfigureRow = dt_SystemConfigure.Select("Sconfig_Code='BootDivisionEarly' and Sconfig_IsEnabled=1"); if (ConfigureRow.Length > 0) { if (ConfigureRow[0]["Sconfig_Value"].ToString() == "1") { if (this.Str_ProjectTitle.Trim() == "" || this.Str_ProjectTitle.Trim() == "引导前期") { #region 引导师 s = ""; strBuilder = new StringBuilder(); strBuilder.Append(" 收款类别 <> '后期收款'"); if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName)) { strBuilder.Append(" And 引导师ID like '%" + EmployeeName + "%' "); } if (this.Str_ProcessStatus.Trim() == "") { strBuilder.Append(" And 未拍个数 = 0 And (服务前期查询时间 >= '" + StartTime + "' And 服务前期查询时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "拍照OK") { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "选片OK") { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "取件OK") { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); } if (!string.IsNullOrEmpty(this.Str_Scores1)) { strBuilder.Append(" and (引导满意总分>=" + this.Str_Scores1 + " and 引导满意总分<=" + this.Str_Scores2 + ")"); } s = BindSelect5(); DataTable dtCount1 = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0]; if (dtCount1.Rows.Count > 0) { if (Convert.ToInt32(dtCount1.Rows[0]["CountID"]) > 0) { backgroundWorker.ReportProgress(0, "正在获取'引导师前期业绩' ..."); string StrColumnName = "订单号,客户名称,订单类型,收款金额,应收金额,拍摄名称,收款时间,套系类别,套系名称,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,副订单,引导满意总分"; DataTable dt_BootDivisiont = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0]; for (int t = 0; t < dt_BootDivisiont.Rows.Count; t++) { #region DataGridViewRow dgvr = new DataGridViewRow(); DataGridViewCell cell = null; //订单号 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["订单号"].ToString().Trim(); dgvr.Cells.Add(cell); //员工 cell = new DataGridViewTextBoxCell(); cell.Value = StrUserName; dgvr.Cells.Add(cell); //职务 cell = new DataGridViewTextBoxCell(); cell.Value = "引导师"; dgvr.Cells.Add(cell); //客户姓名 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["客户名称"].ToString().Trim(); dgvr.Cells.Add(cell); //收款金额 cell = new DataGridViewTextBoxCell(); if (dt_BootDivisiont.Rows[t]["订单类型"].ToString() != "1") { cell.Value = Convert.ToDecimal(dt_BootDivisiont.Rows[t]["收款金额"]).ToString("N2"); } else { cell.Value = GetChildrenAmount(dt_BootDivisiont.Rows[t]["订单号"].ToString().Trim(), Convert.ToDecimal(dt_BootDivisiont.Rows[t]["应收金额"]), Convert.ToDecimal(dt_BootDivisiont.Rows[t]["收款金额"]), dt_BootDivisiont.Rows[t]["拍摄名称"].ToString()); } dgvr.Cells.Add(cell); //收款时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["收款时间"].ToString().Trim(); dgvr.Cells.Add(cell); //套系类别 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["套系类别"].ToString().Trim(); dgvr.Cells.Add(cell); //套系名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["套系名称"].ToString().Trim(); dgvr.Cells.Add(cell); //应收金额 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(dt_BootDivisiont.Rows[t]["应收金额"]).ToString("N2").Trim(); dgvr.Cells.Add(cell); //项目名称 cell = new DataGridViewTextBoxCell(); if (string.IsNullOrEmpty(dt_BootDivisiont.Rows[t]["项目名称"].ToString().Trim())) { cell.Value = dt_BootDivisiont.Rows[t]["收款类别"].ToString(); } else { cell.Value = dt_BootDivisiont.Rows[t]["项目名称"].ToString().Trim(); } dgvr.Cells.Add(cell); //付款名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["付款方式名称"].ToString().Trim(); dgvr.Cells.Add(cell); //拍摄状态 cell = new DataGridViewTextBoxCell(); if (Convert.ToInt32(dt_BootDivisiont.Rows[t]["未拍个数"]) == 0) { cell.Value = "OK"; } else { cell.Value = "未拍"; } dgvr.Cells.Add(cell); //拍摄时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["最后拍摄时间"].ToString(); dgvr.Cells.Add(cell); //选片状态 cell = new DataGridViewTextBoxCell(); if (dt_BootDivisiont.Rows[t]["选片状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未选"; } dgvr.Cells.Add(cell); //选片时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_BootDivisiont.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //取件状态 cell = new DataGridViewTextBoxCell(); if (dt_BootDivisiont.Rows[t]["取件状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未取"; } dgvr.Cells.Add(cell); //取件时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_BootDivisiont.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //拍摄名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["拍摄名称"].ToString(); dgvr.Cells.Add(cell); //订单类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["订单类型"].ToString(); dgvr.Cells.Add(cell); //收款类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["收款类别"].ToString(); dgvr.Cells.Add(cell); //副订单 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["副订单"].ToString(); dgvr.Cells.Add(cell); //引导满意总分 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["引导满意总分"].ToString(); dgvr.Cells.Add(cell); #endregion this.Invoke(new UpdateControl(delegate() { this.dgv.Rows.Add(dgvr); })); } } } #endregion #region 引导助理 s = ""; strBuilder = new StringBuilder(); strBuilder.Append(" 收款类别 <> '后期收款'"); if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName)) { strBuilder.Append(" And 引导助理ID like '%" + EmployeeName + "%' "); } if (this.Str_ProcessStatus.Trim() == "") { strBuilder.Append(" And 未拍个数 = 0 And (服务前期查询时间 >= '" + StartTime + "' And 服务前期查询时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "拍照OK") { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "选片OK") { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "取件OK") { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); } if (!string.IsNullOrEmpty(this.Str_Scores1)) { strBuilder.Append(" and (引导助理满意总分>=" + this.Str_Scores1 + " and 引导助理满意总分<=" + this.Str_Scores2 + ")"); } s = BindSelect5(); DataTable dtCount2 = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0]; if (dtCount2.Rows.Count > 0) { if (Convert.ToInt32(dtCount2.Rows[0]["CountID"]) > 0) { backgroundWorker.ReportProgress(0, "正在获取'引导师助理前期业绩' ..."); string StrColumnName = "订单号,客户名称,订单类型,收款金额,应收金额,拍摄名称,收款时间,套系类别,套系名称,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,副订单,引导助理满意总分"; DataTable dt_BootDivisiont = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0]; for (int t = 0; t < dt_BootDivisiont.Rows.Count; t++) { #region DataGridViewRow dgvr = new DataGridViewRow(); DataGridViewCell cell = null; //订单号 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["订单号"].ToString().Trim(); dgvr.Cells.Add(cell); //员工 cell = new DataGridViewTextBoxCell(); cell.Value = StrUserName; dgvr.Cells.Add(cell); //职务 cell = new DataGridViewTextBoxCell(); cell.Value = "引导助理"; dgvr.Cells.Add(cell); //客户姓名 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["客户名称"].ToString().Trim(); dgvr.Cells.Add(cell); //收款金额 cell = new DataGridViewTextBoxCell(); if (dt_BootDivisiont.Rows[t]["订单类型"].ToString() != "1") { cell.Value = Convert.ToDecimal(dt_BootDivisiont.Rows[t]["收款金额"]).ToString("N2"); } else { cell.Value = GetChildrenAmount(dt_BootDivisiont.Rows[t]["订单号"].ToString().Trim(), Convert.ToDecimal(dt_BootDivisiont.Rows[t]["应收金额"]), Convert.ToDecimal(dt_BootDivisiont.Rows[t]["收款金额"]), dt_BootDivisiont.Rows[t]["拍摄名称"].ToString()); } dgvr.Cells.Add(cell); //收款时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["收款时间"].ToString().Trim(); dgvr.Cells.Add(cell); //套系类别 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["套系类别"].ToString().Trim(); dgvr.Cells.Add(cell); //套系名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["套系名称"].ToString().Trim(); dgvr.Cells.Add(cell); //应收金额 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(dt_BootDivisiont.Rows[t]["应收金额"]).ToString("N2").Trim(); dgvr.Cells.Add(cell); //项目名称 cell = new DataGridViewTextBoxCell(); if (string.IsNullOrEmpty(dt_BootDivisiont.Rows[t]["项目名称"].ToString().Trim())) { cell.Value = dt_BootDivisiont.Rows[t]["收款类别"].ToString(); } else { cell.Value = dt_BootDivisiont.Rows[t]["项目名称"].ToString().Trim(); } dgvr.Cells.Add(cell); //付款名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["付款方式名称"].ToString().Trim(); dgvr.Cells.Add(cell); //拍摄状态 cell = new DataGridViewTextBoxCell(); if (Convert.ToInt32(dt_BootDivisiont.Rows[t]["未拍个数"]) == 0) { cell.Value = "OK"; } else { cell.Value = "未拍"; } dgvr.Cells.Add(cell); //拍摄时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["最后拍摄时间"].ToString(); dgvr.Cells.Add(cell); //选片状态 cell = new DataGridViewTextBoxCell(); if (dt_BootDivisiont.Rows[t]["选片状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未选"; } dgvr.Cells.Add(cell); //选片时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_BootDivisiont.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //取件状态 cell = new DataGridViewTextBoxCell(); if (dt_BootDivisiont.Rows[t]["取件状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未取"; } dgvr.Cells.Add(cell); //取件时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_BootDivisiont.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //拍摄名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["拍摄名称"].ToString(); dgvr.Cells.Add(cell); //订单类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["订单类型"].ToString(); dgvr.Cells.Add(cell); //收款类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["收款类别"].ToString(); dgvr.Cells.Add(cell); //副订单 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["副订单"].ToString(); dgvr.Cells.Add(cell); //引导满意总分 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["引导助理满意总分"].ToString(); dgvr.Cells.Add(cell); #endregion this.Invoke(new UpdateControl(delegate() { this.dgv.Rows.Add(dgvr); })); } } } #endregion } } } ConfigureRow = dt_SystemConfigure.Select("Sconfig_Code='FirstRepairDivisionEarly' and Sconfig_IsEnabled=1"); if (ConfigureRow.Length > 0) { if (ConfigureRow[0]["Sconfig_Value"].ToString() == "1") { if (this.Str_ProjectTitle.Trim() == "" || this.Str_ProjectTitle.Trim() == "初修前期") { #region 初修师 s = ""; strBuilder = new StringBuilder(); strBuilder.Append(" 收款类别 <> '后期收款'"); if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName)) { strBuilder.Append(" And 初修师ID like '%" + EmployeeName + "%' "); } if (this.Str_ProcessStatus.Trim() == "") { strBuilder.Append(" And 未拍个数 = 0 And 服务前期初修查询状态 = '2' And (服务前期初修查询时间 >= '" + StartTime + "' And 服务前期初修查询时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "拍照OK") { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "选片OK") { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "取件OK") { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); } if (!string.IsNullOrEmpty(this.Str_Scores1)) { strBuilder.Append(" and (初修师满意总分>=" + this.Str_Scores1 + " and 初修师满意总分<=" + this.Str_Scores2 + ")"); } s = BindSelect5(); DataTable dtCount = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0]; if (dtCount.Rows.Count > 0) { if (Convert.ToInt32(dtCount.Rows[0]["CountID"]) > 0) { backgroundWorker.ReportProgress(0, "正在获取'初修师前期业绩' ..."); string StrColumnName = "订单号,客户名称,订单类型,收款金额,应收金额,拍摄名称,收款时间,套系类别,套系名称,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,副订单,初修师满意总分"; DataTable dt_EarlyRepair = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0]; for (int t = 0; t < dt_EarlyRepair.Rows.Count; t++) { #region DataGridViewRow dgvr = new DataGridViewRow(); DataGridViewCell cell = null; //订单号 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["订单号"].ToString().Trim(); dgvr.Cells.Add(cell); //员工 cell = new DataGridViewTextBoxCell(); cell.Value = StrUserName; dgvr.Cells.Add(cell); //职务 cell = new DataGridViewTextBoxCell(); cell.Value = "初修师"; dgvr.Cells.Add(cell); //客户姓名 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["客户名称"].ToString().Trim(); dgvr.Cells.Add(cell); //收款金额 cell = new DataGridViewTextBoxCell(); if (dt_EarlyRepair.Rows[t]["订单类型"].ToString() != "1") { cell.Value = Convert.ToDecimal(dt_EarlyRepair.Rows[t]["收款金额"]).ToString("N2"); } else { cell.Value = GetChildrenAmount(dt_EarlyRepair.Rows[t]["订单号"].ToString().Trim(), Convert.ToDecimal(dt_EarlyRepair.Rows[t]["应收金额"]), Convert.ToDecimal(dt_EarlyRepair.Rows[t]["收款金额"]), dt_EarlyRepair.Rows[t]["拍摄名称"].ToString()); } dgvr.Cells.Add(cell); //收款时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["收款时间"].ToString().Trim(); dgvr.Cells.Add(cell); //套系类别 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["套系类别"].ToString().Trim(); dgvr.Cells.Add(cell); //套系名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["套系名称"].ToString().Trim(); dgvr.Cells.Add(cell); //应收金额 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(dt_EarlyRepair.Rows[t]["应收金额"]).ToString("N2").Trim(); dgvr.Cells.Add(cell); //项目名称 cell = new DataGridViewTextBoxCell(); if (string.IsNullOrEmpty(dt_EarlyRepair.Rows[t]["项目名称"].ToString().Trim())) { cell.Value = dt_EarlyRepair.Rows[t]["收款类别"].ToString(); } else { cell.Value = dt_EarlyRepair.Rows[t]["项目名称"].ToString().Trim(); } dgvr.Cells.Add(cell); //付款名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["付款方式名称"].ToString().Trim(); dgvr.Cells.Add(cell); //拍摄状态 cell = new DataGridViewTextBoxCell(); if (Convert.ToInt32(dt_EarlyRepair.Rows[t]["未拍个数"]) == 0) { cell.Value = "OK"; } else { cell.Value = "未拍"; } dgvr.Cells.Add(cell); //拍摄时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["最后拍摄时间"].ToString(); dgvr.Cells.Add(cell); //选片状态 cell = new DataGridViewTextBoxCell(); if (dt_EarlyRepair.Rows[t]["选片状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未选"; } dgvr.Cells.Add(cell); //选片时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_EarlyRepair.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //取件状态 cell = new DataGridViewTextBoxCell(); if (dt_EarlyRepair.Rows[t]["取件状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未取"; } dgvr.Cells.Add(cell); //取件时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_EarlyRepair.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //拍摄名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["拍摄名称"].ToString(); dgvr.Cells.Add(cell); //订单类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["订单类型"].ToString(); dgvr.Cells.Add(cell); //收款类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["收款类别"].ToString(); dgvr.Cells.Add(cell); //副订单 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["副订单"].ToString(); dgvr.Cells.Add(cell); //初修师满意总分 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["初修师满意总分"].ToString(); dgvr.Cells.Add(cell); #endregion this.Invoke(new UpdateControl(delegate() { this.dgv.Rows.Add(dgvr); })); } } } #endregion } } } ConfigureRow = dt_SystemConfigure.Select("Sconfig_Code='FinishingDivisionEarly' and Sconfig_IsEnabled=1"); if (ConfigureRow.Length > 0) { if (ConfigureRow[0]["Sconfig_Value"].ToString() == "1") { if (this.Str_ProjectTitle.Trim() == "" || this.Str_ProjectTitle.Trim() == "精修前期") { #region 精修师 s = ""; strBuilder = new StringBuilder(); strBuilder.Append(" 收款类别 <> '后期收款'"); if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName)) { strBuilder.Append(" And 精修师ID like '%" + EmployeeName + "%' "); } if (this.Str_ProcessStatus.Trim() == "") { strBuilder.Append(" And 未拍个数 = 0 And 服务前期精修查询状态 = '2' And (服务前期精修查询时间 >= '" + StartTime + "' And 服务前期精修查询时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "拍照OK") { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "选片OK") { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "取件OK") { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); } if (!string.IsNullOrEmpty(this.Str_Scores1)) { strBuilder.Append(" and (精修师满意总分>=" + this.Str_Scores1 + " and 精修师满意总分<=" + this.Str_Scores2 + ")"); } s = BindSelect5(); DataTable dtCount = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0]; if (dtCount.Rows.Count > 0) { if (Convert.ToInt32(dtCount.Rows[0]["CountID"]) > 0) { backgroundWorker.ReportProgress(0, "正在获取'精修师前期业绩' ..."); string StrColumnName = "订单号,客户名称,订单类型,收款金额,应收金额,拍摄名称,收款时间,套系类别,套系名称,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,副订单,精修师满意总分"; DataTable dt_Refinement = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0]; for (int t = 0; t < dt_Refinement.Rows.Count; t++) { #region DataGridViewRow dgvr = new DataGridViewRow(); DataGridViewCell cell = null; //订单号 cell = new DataGridViewTextBoxCell(); cell.Value = dt_Refinement.Rows[t]["订单号"].ToString().Trim(); dgvr.Cells.Add(cell); //员工 cell = new DataGridViewTextBoxCell(); cell.Value = StrUserName; dgvr.Cells.Add(cell); //职务 cell = new DataGridViewTextBoxCell(); cell.Value = "精修师"; dgvr.Cells.Add(cell); //客户姓名 cell = new DataGridViewTextBoxCell(); cell.Value = dt_Refinement.Rows[t]["客户名称"].ToString().Trim(); dgvr.Cells.Add(cell); //收款金额 cell = new DataGridViewTextBoxCell(); if (dt_Refinement.Rows[t]["订单类型"].ToString() != "1") { cell.Value = Convert.ToDecimal(dt_Refinement.Rows[t]["收款金额"]).ToString("N2"); } else { cell.Value = GetChildrenAmount(dt_Refinement.Rows[t]["订单号"].ToString().Trim(), Convert.ToDecimal(dt_Refinement.Rows[t]["应收金额"]), Convert.ToDecimal(dt_Refinement.Rows[t]["收款金额"]), dt_Refinement.Rows[t]["拍摄名称"].ToString()); } dgvr.Cells.Add(cell); //收款时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_Refinement.Rows[t]["收款时间"].ToString().Trim(); dgvr.Cells.Add(cell); //套系类别 cell = new DataGridViewTextBoxCell(); cell.Value = dt_Refinement.Rows[t]["套系类别"].ToString().Trim(); dgvr.Cells.Add(cell); //套系名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_Refinement.Rows[t]["套系名称"].ToString().Trim(); dgvr.Cells.Add(cell); //应收金额 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(dt_Refinement.Rows[t]["应收金额"]).ToString("N2").Trim(); dgvr.Cells.Add(cell); //项目名称 cell = new DataGridViewTextBoxCell(); if (string.IsNullOrEmpty(dt_Refinement.Rows[t]["项目名称"].ToString().Trim())) { cell.Value = dt_Refinement.Rows[t]["收款类别"].ToString(); } else { cell.Value = dt_Refinement.Rows[t]["项目名称"].ToString().Trim(); } dgvr.Cells.Add(cell); //付款名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_Refinement.Rows[t]["付款方式名称"].ToString().Trim(); dgvr.Cells.Add(cell); //拍摄状态 cell = new DataGridViewTextBoxCell(); if (Convert.ToInt32(dt_Refinement.Rows[t]["未拍个数"]) == 0) { cell.Value = "OK"; } else { cell.Value = "未拍"; } dgvr.Cells.Add(cell); //拍摄时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_Refinement.Rows[t]["最后拍摄时间"].ToString(); dgvr.Cells.Add(cell); //选片状态 cell = new DataGridViewTextBoxCell(); if (dt_Refinement.Rows[t]["选片状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未选"; } dgvr.Cells.Add(cell); //选片时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_Refinement.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //取件状态 cell = new DataGridViewTextBoxCell(); if (dt_Refinement.Rows[t]["取件状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未取"; } dgvr.Cells.Add(cell); //取件时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_Refinement.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //拍摄名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_Refinement.Rows[t]["拍摄名称"].ToString(); dgvr.Cells.Add(cell); //订单类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_Refinement.Rows[t]["订单类型"].ToString(); dgvr.Cells.Add(cell); //收款类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_Refinement.Rows[t]["收款类别"].ToString(); dgvr.Cells.Add(cell); //副订单 cell = new DataGridViewTextBoxCell(); cell.Value = dt_Refinement.Rows[t]["副订单"].ToString(); dgvr.Cells.Add(cell); //精修师满意总分 cell = new DataGridViewTextBoxCell(); cell.Value = dt_Refinement.Rows[t]["精修师满意总分"].ToString(); dgvr.Cells.Add(cell); #endregion this.Invoke(new UpdateControl(delegate() { this.dgv.Rows.Add(dgvr); })); } } } #endregion } } } ConfigureRow = dt_SystemConfigure.Select("Sconfig_Code='DesignersEarly' and Sconfig_IsEnabled=1"); if (ConfigureRow.Length > 0) { if (ConfigureRow[0]["Sconfig_Value"].ToString() == "1") { if (this.Str_ProjectTitle.Trim() == "" || this.Str_ProjectTitle.Trim() == "设计前期") { #region 设计师 s = ""; strBuilder = new StringBuilder(); strBuilder.Append(" 收款类别 <> '后期收款'"); if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName)) { strBuilder.Append(" And 设计师ID like '%" + EmployeeName + "%' "); } if (this.Str_ProcessStatus.Trim() == "") { strBuilder.Append(" And 未拍个数 = 0 And 服务前期设计查询状态 = '2' And (服务前期设计查询时间 >= '" + StartTime + "' And 服务前期设计查询时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "拍照OK") { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "选片OK") { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "取件OK") { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); } if (!string.IsNullOrEmpty(this.Str_Scores1)) { strBuilder.Append(" and (设计师满意总分>=" + this.Str_Scores1 + " and 设计师满意总分<=" + this.Str_Scores2 + ")"); } s = BindSelect5(); DataTable dtCount = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0]; if (dtCount.Rows.Count > 0) { if (Convert.ToInt32(dtCount.Rows[0]["CountID"]) > 0) { backgroundWorker.ReportProgress(0, "正在获取'设计师前期业绩' ..."); string StrColumnName = "订单号,客户名称,订单类型,收款金额,应收金额,拍摄名称,收款时间,套系类别,套系名称,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,副订单,设计师满意总分"; DataTable dt_Designer = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0]; for (int t = 0; t < dt_Designer.Rows.Count; t++) { #region DataGridViewRow dgvr = new DataGridViewRow(); DataGridViewCell cell = null; //订单号 cell = new DataGridViewTextBoxCell(); cell.Value = dt_Designer.Rows[t]["订单号"].ToString().Trim(); dgvr.Cells.Add(cell); //员工 cell = new DataGridViewTextBoxCell(); cell.Value = StrUserName; dgvr.Cells.Add(cell); //职务 cell = new DataGridViewTextBoxCell(); cell.Value = "设计师"; dgvr.Cells.Add(cell); //客户姓名 cell = new DataGridViewTextBoxCell(); cell.Value = dt_Designer.Rows[t]["客户名称"].ToString().Trim(); dgvr.Cells.Add(cell); //收款金额 cell = new DataGridViewTextBoxCell(); if (dt_Designer.Rows[t]["订单类型"].ToString() != "1") { cell.Value = Convert.ToDecimal(dt_Designer.Rows[t]["收款金额"]).ToString("N2"); } else { cell.Value = GetChildrenAmount(dt_Designer.Rows[t]["订单号"].ToString().Trim(), Convert.ToDecimal(dt_Designer.Rows[t]["应收金额"]), Convert.ToDecimal(dt_Designer.Rows[t]["收款金额"]), dt_Designer.Rows[t]["拍摄名称"].ToString()); } dgvr.Cells.Add(cell); //收款时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_Designer.Rows[t]["收款时间"].ToString().Trim(); dgvr.Cells.Add(cell); //套系类别 cell = new DataGridViewTextBoxCell(); cell.Value = dt_Designer.Rows[t]["套系类别"].ToString().Trim(); dgvr.Cells.Add(cell); //套系名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_Designer.Rows[t]["套系名称"].ToString().Trim(); dgvr.Cells.Add(cell); //应收金额 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(dt_Designer.Rows[t]["应收金额"]).ToString("N2").Trim(); dgvr.Cells.Add(cell); //项目名称 cell = new DataGridViewTextBoxCell(); if (string.IsNullOrEmpty(dt_Designer.Rows[t]["项目名称"].ToString().Trim())) { cell.Value = dt_Designer.Rows[t]["收款类别"].ToString(); } else { cell.Value = dt_Designer.Rows[t]["项目名称"].ToString().Trim(); } dgvr.Cells.Add(cell); //付款名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_Designer.Rows[t]["付款方式名称"].ToString().Trim(); dgvr.Cells.Add(cell); //拍摄状态 cell = new DataGridViewTextBoxCell(); if (Convert.ToInt32(dt_Designer.Rows[t]["未拍个数"]) == 0) { cell.Value = "OK"; } else { cell.Value = "未拍"; } dgvr.Cells.Add(cell); //拍摄时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_Designer.Rows[t]["最后拍摄时间"].ToString(); dgvr.Cells.Add(cell); //选片状态 cell = new DataGridViewTextBoxCell(); if (dt_Designer.Rows[t]["选片状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未选"; } dgvr.Cells.Add(cell); //选片时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_Designer.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //取件状态 cell = new DataGridViewTextBoxCell(); if (dt_Designer.Rows[t]["取件状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未取"; } dgvr.Cells.Add(cell); //取件时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_Designer.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //拍摄名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_Designer.Rows[t]["拍摄名称"].ToString(); dgvr.Cells.Add(cell); //订单类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_Designer.Rows[t]["订单类型"].ToString(); dgvr.Cells.Add(cell); //收款类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_Designer.Rows[t]["收款类别"].ToString(); dgvr.Cells.Add(cell); //副订单 cell = new DataGridViewTextBoxCell(); cell.Value = dt_Designer.Rows[t]["副订单"].ToString(); dgvr.Cells.Add(cell); //设计师满意总分 cell = new DataGridViewTextBoxCell(); cell.Value = dt_Designer.Rows[t]["设计师满意总分"].ToString(); dgvr.Cells.Add(cell); #endregion this.Invoke(new UpdateControl(delegate() { this.dgv.Rows.Add(dgvr); })); } } } #endregion } } } #endregion } if (this.Str_ItemCategory.Trim() == "" || this.Str_ItemCategory.Trim() == "服务后期") { #region 选片二销业绩 DataRow[] ConfigureRow = dt_SystemConfigure.Select("Sconfig_Code='PhotographerSelectionFilms' and Sconfig_IsEnabled=1"); if (ConfigureRow.Length > 0) { if (ConfigureRow[0]["Sconfig_Value"].ToString() == "1") { if (this.Str_ProjectTitle.Trim() == "" || this.Str_ProjectTitle.Trim() == "摄影选片二销") { #region 主摄影师 s = ""; strBuilder = new StringBuilder(); if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName)) { strBuilder.Append(" And 主摄影师ID like '%" + EmployeeName + "%' "); } if (this.Str_ProcessStatus.Trim() == "") { strBuilder.Append(" And 未拍个数 = 0 And (收款时间 >= '" + StartTime + "' And 收款时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "拍照OK") { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "选片OK") { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "取件OK") { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); } if (!string.IsNullOrEmpty(this.Str_Scores1)) { strBuilder.Append(" and (主摄影满意总分>=" + this.Str_Scores1 + " and 主摄影满意总分<=" + this.Str_Scores2 + ")"); } s = BindSelect5(); DataTable dtCount1 = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0]; if (dtCount1.Rows.Count > 0) { if (Convert.ToInt32(dtCount1.Rows[0]["CountID"]) > 0) { backgroundWorker.ReportProgress(0, "正在获取'主摄影师选片二销业绩' ..."); string StrColumnName = "订单号,客户名称,收款金额,收款时间,套系类别,套系名称,应收金额,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,拍摄名称,订单类型,副订单,主摄影满意总分"; DataTable dt_MainPhotographer = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0]; for (int t = 0; t < dt_MainPhotographer.Rows.Count; t++) { #region DataGridViewRow dgvr = new DataGridViewRow(); DataGridViewCell cell = null; //订单号 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainPhotographer.Rows[t]["订单号"].ToString().Trim(); dgvr.Cells.Add(cell); //员工 cell = new DataGridViewTextBoxCell(); cell.Value = StrUserName; dgvr.Cells.Add(cell); //职务 cell = new DataGridViewTextBoxCell(); cell.Value = "主摄影选片二销"; dgvr.Cells.Add(cell); //客户姓名 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainPhotographer.Rows[t]["客户名称"].ToString().Trim(); dgvr.Cells.Add(cell); //收款金额 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(dt_MainPhotographer.Rows[t]["收款金额"]).ToString("N2"); dgvr.Cells.Add(cell); //收款时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainPhotographer.Rows[t]["收款时间"].ToString().Trim(); dgvr.Cells.Add(cell); //套系类别 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainPhotographer.Rows[t]["套系类别"].ToString().Trim(); dgvr.Cells.Add(cell); //套系名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainPhotographer.Rows[t]["套系名称"].ToString().Trim(); dgvr.Cells.Add(cell); //应收金额 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(dt_MainPhotographer.Rows[t]["应收金额"]).ToString("N2").Trim(); dgvr.Cells.Add(cell); //项目名称 cell = new DataGridViewTextBoxCell(); if (string.IsNullOrEmpty(dt_MainPhotographer.Rows[t]["项目名称"].ToString().Trim())) { cell.Value = dt_MainPhotographer.Rows[t]["收款类别"].ToString(); } else { cell.Value = dt_MainPhotographer.Rows[t]["项目名称"].ToString().Trim(); } dgvr.Cells.Add(cell); //付款名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainPhotographer.Rows[t]["付款方式名称"].ToString().Trim(); dgvr.Cells.Add(cell); //拍摄状态 cell = new DataGridViewTextBoxCell(); if (Convert.ToInt32(dt_MainPhotographer.Rows[t]["未拍个数"]) == 0) { cell.Value = "OK"; } else { cell.Value = "未拍"; } dgvr.Cells.Add(cell); //拍摄时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainPhotographer.Rows[t]["最后拍摄时间"].ToString(); dgvr.Cells.Add(cell); //选片状态 cell = new DataGridViewTextBoxCell(); if (dt_MainPhotographer.Rows[t]["选片状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未选"; } dgvr.Cells.Add(cell); //选片时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_MainPhotographer.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //取件状态 cell = new DataGridViewTextBoxCell(); if (dt_MainPhotographer.Rows[t]["取件状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未取"; } dgvr.Cells.Add(cell); //取件时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_MainPhotographer.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //拍摄名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainPhotographer.Rows[t]["拍摄名称"].ToString(); dgvr.Cells.Add(cell); //订单类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainPhotographer.Rows[t]["订单类型"].ToString(); dgvr.Cells.Add(cell); //收款类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainPhotographer.Rows[t]["收款类别"].ToString(); dgvr.Cells.Add(cell); //副订单 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainPhotographer.Rows[t]["副订单"].ToString(); dgvr.Cells.Add(cell); //主摄影满意总分 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainPhotographer.Rows[t]["主摄影满意总分"].ToString(); dgvr.Cells.Add(cell); #endregion this.Invoke(new UpdateControl(delegate() { this.dgv.Rows.Add(dgvr); })); } } } #endregion #region 摄影助理 s = ""; strBuilder = new StringBuilder(); if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName)) { strBuilder.Append(" And 摄影助理ID like '%" + EmployeeName + "%' "); } if (this.Str_ProcessStatus.Trim() == "") { strBuilder.Append(" And 未拍个数 = 0 And (收款时间 >= '" + StartTime + "' And 收款时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "拍照OK") { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "选片OK") { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "取件OK") { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); } if (!string.IsNullOrEmpty(this.Str_Scores1)) { strBuilder.Append(" and (摄影助理满意总分>=" + this.Str_Scores1 + " and 摄影助理满意总分<=" + this.Str_Scores2 + ")"); } s = BindSelect5(); DataTable dtCount2 = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0]; if (dtCount2.Rows.Count > 0) { if (Convert.ToInt32(dtCount2.Rows[0]["CountID"]) > 0) { backgroundWorker.ReportProgress(0, "正在获取'摄影助理选片二销业绩' ..."); string StrColumnName = "订单号,客户名称,收款金额,收款时间,套系类别,套系名称,应收金额,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,拍摄名称,订单类型,副订单,摄影助理满意总分"; DataTable dt_VicePhotographer = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0]; for (int t = 0; t < dt_VicePhotographer.Rows.Count; t++) { #region DataGridViewRow dgvr = new DataGridViewRow(); DataGridViewCell cell = null; //订单号 cell = new DataGridViewTextBoxCell(); cell.Value = dt_VicePhotographer.Rows[t]["订单号"].ToString().Trim(); dgvr.Cells.Add(cell); //员工 cell = new DataGridViewTextBoxCell(); cell.Value = StrUserName; dgvr.Cells.Add(cell); //职务 cell = new DataGridViewTextBoxCell(); cell.Value = "摄影助理选片二销"; dgvr.Cells.Add(cell); //客户姓名 cell = new DataGridViewTextBoxCell(); cell.Value = dt_VicePhotographer.Rows[t]["客户名称"].ToString().Trim(); dgvr.Cells.Add(cell); //收款金额 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(dt_VicePhotographer.Rows[t]["收款金额"]).ToString("N2"); dgvr.Cells.Add(cell); //收款时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_VicePhotographer.Rows[t]["收款时间"].ToString().Trim(); dgvr.Cells.Add(cell); //套系类别 cell = new DataGridViewTextBoxCell(); cell.Value = dt_VicePhotographer.Rows[t]["套系类别"].ToString().Trim(); dgvr.Cells.Add(cell); //套系名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_VicePhotographer.Rows[t]["套系名称"].ToString().Trim(); dgvr.Cells.Add(cell); //应收金额 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(dt_VicePhotographer.Rows[t]["应收金额"]).ToString("N2").Trim(); dgvr.Cells.Add(cell); //项目名称 cell = new DataGridViewTextBoxCell(); if (string.IsNullOrEmpty(dt_VicePhotographer.Rows[t]["项目名称"].ToString().Trim())) { cell.Value = dt_VicePhotographer.Rows[t]["收款类别"].ToString(); } else { cell.Value = dt_VicePhotographer.Rows[t]["项目名称"].ToString().Trim(); } dgvr.Cells.Add(cell); //付款名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_VicePhotographer.Rows[t]["付款方式名称"].ToString().Trim(); dgvr.Cells.Add(cell); //拍摄状态 cell = new DataGridViewTextBoxCell(); if (Convert.ToInt32(dt_VicePhotographer.Rows[t]["未拍个数"]) == 0) { cell.Value = "OK"; } else { cell.Value = "未拍"; } dgvr.Cells.Add(cell); //拍摄时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_VicePhotographer.Rows[t]["最后拍摄时间"].ToString(); dgvr.Cells.Add(cell); //选片状态 cell = new DataGridViewTextBoxCell(); if (dt_VicePhotographer.Rows[t]["选片状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未选"; } dgvr.Cells.Add(cell); //选片时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_VicePhotographer.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //取件状态 cell = new DataGridViewTextBoxCell(); if (dt_VicePhotographer.Rows[t]["取件状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未取"; } dgvr.Cells.Add(cell); //取件时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_VicePhotographer.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //拍摄名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_VicePhotographer.Rows[t]["拍摄名称"].ToString(); dgvr.Cells.Add(cell); //订单类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_VicePhotographer.Rows[t]["订单类型"].ToString(); dgvr.Cells.Add(cell); //收款类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_VicePhotographer.Rows[t]["收款类别"].ToString(); dgvr.Cells.Add(cell); //副订单 cell = new DataGridViewTextBoxCell(); cell.Value = dt_VicePhotographer.Rows[t]["副订单"].ToString(); dgvr.Cells.Add(cell); //摄影助理满意总分 cell = new DataGridViewTextBoxCell(); cell.Value = dt_VicePhotographer.Rows[t]["摄影助理满意总分"].ToString(); dgvr.Cells.Add(cell); #endregion this.Invoke(new UpdateControl(delegate() { this.dgv.Rows.Add(dgvr); })); } } } #endregion } } } ConfigureRow = dt_SystemConfigure.Select("Sconfig_Code='MakeupArtistSelectionFilms' and Sconfig_IsEnabled=1"); if (ConfigureRow.Length > 0) { if (ConfigureRow[0]["Sconfig_Value"].ToString() == "1") { if (this.Str_ProjectTitle.Trim() == "" || this.Str_ProjectTitle.Trim() == "化妆选片二销") { #region 主化妆师 s = ""; strBuilder = new StringBuilder(); if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName)) { strBuilder.Append(" And 主化妆ID like '%" + EmployeeName + "%' "); } if (this.Str_ProcessStatus.Trim() == "") { strBuilder.Append(" And 未拍个数 = 0 And (收款时间 >= '" + StartTime + "' And 收款时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "拍照OK") { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "选片OK") { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "取件OK") { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); } if (!string.IsNullOrEmpty(this.Str_Scores1)) { strBuilder.Append(" and (主化妆满意总分>=" + this.Str_Scores1 + " and 主化妆满意总分<=" + this.Str_Scores2 + ")"); } s = BindSelect5(); DataTable dtCount1 = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0]; if (dtCount1.Rows.Count > 0) { if (Convert.ToInt32(dtCount1.Rows[0]["CountID"]) > 0) { backgroundWorker.ReportProgress(0, "正在获取'主化妆师选片二销业绩' ..."); string StrColumnName = "订单号,客户名称,收款金额,收款时间,套系类别,套系名称,应收金额,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,拍摄名称,订单类型,副订单,主化妆满意总分"; DataTable dt_MainMakeupArtist = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0]; for (int t = 0; t < dt_MainMakeupArtist.Rows.Count; t++) { #region DataGridViewRow dgvr = new DataGridViewRow(); DataGridViewCell cell = null; //订单号 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainMakeupArtist.Rows[t]["订单号"].ToString().Trim(); dgvr.Cells.Add(cell); //员工 cell = new DataGridViewTextBoxCell(); cell.Value = StrUserName; dgvr.Cells.Add(cell); //职务 cell = new DataGridViewTextBoxCell(); cell.Value = "主化妆选片二销"; dgvr.Cells.Add(cell); //客户姓名 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainMakeupArtist.Rows[t]["客户名称"].ToString().Trim(); dgvr.Cells.Add(cell); //收款金额 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(dt_MainMakeupArtist.Rows[t]["收款金额"]).ToString("N2"); dgvr.Cells.Add(cell); //收款时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainMakeupArtist.Rows[t]["收款时间"].ToString().Trim(); dgvr.Cells.Add(cell); //套系类别 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainMakeupArtist.Rows[t]["套系类别"].ToString().Trim(); dgvr.Cells.Add(cell); //套系名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainMakeupArtist.Rows[t]["套系名称"].ToString().Trim(); dgvr.Cells.Add(cell); //应收金额 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(dt_MainMakeupArtist.Rows[t]["应收金额"]).ToString("N2").Trim(); dgvr.Cells.Add(cell); //项目名称 cell = new DataGridViewTextBoxCell(); if (string.IsNullOrEmpty(dt_MainMakeupArtist.Rows[t]["项目名称"].ToString().Trim())) { cell.Value = dt_MainMakeupArtist.Rows[t]["收款类别"].ToString(); } else { cell.Value = dt_MainMakeupArtist.Rows[t]["项目名称"].ToString().Trim(); } dgvr.Cells.Add(cell); //付款名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainMakeupArtist.Rows[t]["付款方式名称"].ToString().Trim(); dgvr.Cells.Add(cell); //拍摄状态 cell = new DataGridViewTextBoxCell(); if (Convert.ToInt32(dt_MainMakeupArtist.Rows[t]["未拍个数"]) == 0) { cell.Value = "OK"; } else { cell.Value = "未拍"; } dgvr.Cells.Add(cell); //拍摄时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainMakeupArtist.Rows[t]["最后拍摄时间"].ToString(); dgvr.Cells.Add(cell); //选片状态 cell = new DataGridViewTextBoxCell(); if (dt_MainMakeupArtist.Rows[t]["选片状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未选"; } dgvr.Cells.Add(cell); //选片时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_MainMakeupArtist.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //取件状态 cell = new DataGridViewTextBoxCell(); if (dt_MainMakeupArtist.Rows[t]["取件状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未取"; } dgvr.Cells.Add(cell); //取件时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_MainMakeupArtist.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //拍摄名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainMakeupArtist.Rows[t]["拍摄名称"].ToString(); dgvr.Cells.Add(cell); //订单类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainMakeupArtist.Rows[t]["订单类型"].ToString(); dgvr.Cells.Add(cell); //收款类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainMakeupArtist.Rows[t]["收款类别"].ToString(); dgvr.Cells.Add(cell); //副订单 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainMakeupArtist.Rows[t]["副订单"].ToString(); dgvr.Cells.Add(cell); //主化妆满意总分 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MainMakeupArtist.Rows[t]["主化妆满意总分"].ToString(); dgvr.Cells.Add(cell); #endregion this.Invoke(new UpdateControl(delegate() { this.dgv.Rows.Add(dgvr); })); } } } #endregion #region 化妆助理 s = ""; strBuilder = new StringBuilder(); if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName)) { strBuilder.Append(" And 化妆助理ID like '%" + EmployeeName + "%' "); } if (this.Str_ProcessStatus.Trim() == "") { strBuilder.Append(" And 未拍个数 = 0 And (收款时间 >= '" + StartTime + "' And 收款时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "拍照OK") { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "选片OK") { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "取件OK") { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); } if (!string.IsNullOrEmpty(this.Str_Scores1)) { strBuilder.Append(" and (化妆助理满意总分>=" + this.Str_Scores1 + " and 化妆助理满意总分<=" + this.Str_Scores2 + ")"); } s = BindSelect5(); DataTable dtCount2 = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0]; if (dtCount2.Rows.Count > 0) { if (Convert.ToInt32(dtCount2.Rows[0]["CountID"]) > 0) { backgroundWorker.ReportProgress(0, "正在获取'化妆助理选片二销业绩' ..."); string StrColumnName = "订单号,客户名称,收款金额,收款时间,套系类别,套系名称,应收金额,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,拍摄名称,订单类型,副订单,化妆助理满意总分"; DataTable dt_ViceMakeupArtist = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0]; for (int t = 0; t < dt_ViceMakeupArtist.Rows.Count; t++) { #region DataGridViewRow dgvr = new DataGridViewRow(); DataGridViewCell cell = null; //订单号 cell = new DataGridViewTextBoxCell(); cell.Value = dt_ViceMakeupArtist.Rows[t]["订单号"].ToString().Trim(); dgvr.Cells.Add(cell); //员工 cell = new DataGridViewTextBoxCell(); cell.Value = StrUserName; dgvr.Cells.Add(cell); //职务 cell = new DataGridViewTextBoxCell(); cell.Value = "化妆助理选片二销"; dgvr.Cells.Add(cell); //客户姓名 cell = new DataGridViewTextBoxCell(); cell.Value = dt_ViceMakeupArtist.Rows[t]["客户名称"].ToString().Trim(); dgvr.Cells.Add(cell); //收款金额 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(dt_ViceMakeupArtist.Rows[t]["收款金额"]).ToString("N2"); dgvr.Cells.Add(cell); //收款时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_ViceMakeupArtist.Rows[t]["收款时间"].ToString().Trim(); dgvr.Cells.Add(cell); //套系类别 cell = new DataGridViewTextBoxCell(); cell.Value = dt_ViceMakeupArtist.Rows[t]["套系类别"].ToString().Trim(); dgvr.Cells.Add(cell); //套系名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_ViceMakeupArtist.Rows[t]["套系名称"].ToString().Trim(); dgvr.Cells.Add(cell); //应收金额 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(dt_ViceMakeupArtist.Rows[t]["应收金额"]).ToString("N2").Trim(); dgvr.Cells.Add(cell); //项目名称 cell = new DataGridViewTextBoxCell(); if (string.IsNullOrEmpty(dt_ViceMakeupArtist.Rows[t]["项目名称"].ToString().Trim())) { cell.Value = dt_ViceMakeupArtist.Rows[t]["收款类别"].ToString(); } else { cell.Value = dt_ViceMakeupArtist.Rows[t]["项目名称"].ToString().Trim(); } dgvr.Cells.Add(cell); //付款名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_ViceMakeupArtist.Rows[t]["付款方式名称"].ToString().Trim(); dgvr.Cells.Add(cell); //拍摄状态 cell = new DataGridViewTextBoxCell(); if (Convert.ToInt32(dt_ViceMakeupArtist.Rows[t]["未拍个数"]) == 0) { cell.Value = "OK"; } else { cell.Value = "未拍"; } dgvr.Cells.Add(cell); //拍摄时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_ViceMakeupArtist.Rows[t]["最后拍摄时间"].ToString(); dgvr.Cells.Add(cell); //选片状态 cell = new DataGridViewTextBoxCell(); if (dt_ViceMakeupArtist.Rows[t]["选片状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未选"; } dgvr.Cells.Add(cell); //选片时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_ViceMakeupArtist.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //取件状态 cell = new DataGridViewTextBoxCell(); if (dt_ViceMakeupArtist.Rows[t]["取件状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未取"; } dgvr.Cells.Add(cell); //取件时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_ViceMakeupArtist.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //拍摄名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_ViceMakeupArtist.Rows[t]["拍摄名称"].ToString(); dgvr.Cells.Add(cell); //订单类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_ViceMakeupArtist.Rows[t]["订单类型"].ToString(); dgvr.Cells.Add(cell); //收款类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_ViceMakeupArtist.Rows[t]["收款类别"].ToString(); dgvr.Cells.Add(cell); //副订单 cell = new DataGridViewTextBoxCell(); cell.Value = dt_ViceMakeupArtist.Rows[t]["副订单"].ToString(); dgvr.Cells.Add(cell); //化妆助理满意总分 cell = new DataGridViewTextBoxCell(); cell.Value = dt_ViceMakeupArtist.Rows[t]["化妆助理满意总分"].ToString(); dgvr.Cells.Add(cell); #endregion this.Invoke(new UpdateControl(delegate() { this.dgv.Rows.Add(dgvr); })); } } } #endregion } } } ConfigureRow = dt_SystemConfigure.Select("Sconfig_Code='GuideSelectionFilmsDivision' and Sconfig_IsEnabled=1"); if (ConfigureRow.Length > 0) { if (ConfigureRow[0]["Sconfig_Value"].ToString() == "1") { if (this.Str_ProjectTitle.Trim() == "" || this.Str_ProjectTitle.Trim() == "引导选片二销") { #region 引导师 s = ""; strBuilder = new StringBuilder(); if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName)) { strBuilder.Append(" And 引导师ID like '%" + EmployeeName + "%' "); } if (this.Str_ProcessStatus.Trim() == "") { strBuilder.Append(" And 未拍个数 = 0 And (收款时间 >= '" + StartTime + "' And 收款时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "拍照OK") { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "选片OK") { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "取件OK") { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); } if (!string.IsNullOrEmpty(this.Str_Scores1)) { strBuilder.Append(" and (引导满意总分>=" + this.Str_Scores1 + " and 引导满意总分<=" + this.Str_Scores2 + ")"); } s = BindSelect5(); DataTable dtCount1 = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0]; if (dtCount1.Rows.Count > 0) { if (Convert.ToInt32(dtCount1.Rows[0]["CountID"]) > 0) { backgroundWorker.ReportProgress(0, "正在获取'引导师选片二销业绩' ..."); string StrColumnName = "订单号,客户名称,收款金额,收款时间,套系类别,套系名称,应收金额,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,拍摄名称,订单类型,副订单,引导满意总分"; DataTable dt_BootDivisiont = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0]; for (int t = 0; t < dt_BootDivisiont.Rows.Count; t++) { #region DataGridViewRow dgvr = new DataGridViewRow(); DataGridViewCell cell = null; //订单号 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["订单号"].ToString().Trim(); dgvr.Cells.Add(cell); //员工 cell = new DataGridViewTextBoxCell(); cell.Value = StrUserName; dgvr.Cells.Add(cell); //职务 cell = new DataGridViewTextBoxCell(); cell.Value = "引导选片二销"; dgvr.Cells.Add(cell); //客户姓名 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["客户名称"].ToString().Trim(); dgvr.Cells.Add(cell); //收款金额 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(dt_BootDivisiont.Rows[t]["收款金额"]).ToString("N2"); dgvr.Cells.Add(cell); //收款时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["收款时间"].ToString().Trim(); dgvr.Cells.Add(cell); //套系类别 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["套系类别"].ToString().Trim(); dgvr.Cells.Add(cell); //套系名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["套系名称"].ToString().Trim(); dgvr.Cells.Add(cell); //应收金额 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(dt_BootDivisiont.Rows[t]["应收金额"]).ToString("N2").Trim(); dgvr.Cells.Add(cell); //项目名称 cell = new DataGridViewTextBoxCell(); if (string.IsNullOrEmpty(dt_BootDivisiont.Rows[t]["项目名称"].ToString().Trim())) { cell.Value = dt_BootDivisiont.Rows[t]["收款类别"].ToString(); } else { cell.Value = dt_BootDivisiont.Rows[t]["项目名称"].ToString().Trim(); } dgvr.Cells.Add(cell); //付款名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["付款方式名称"].ToString().Trim(); dgvr.Cells.Add(cell); //拍摄状态 cell = new DataGridViewTextBoxCell(); if (Convert.ToInt32(dt_BootDivisiont.Rows[t]["未拍个数"]) == 0) { cell.Value = "OK"; } else { cell.Value = "未拍"; } dgvr.Cells.Add(cell); //拍摄时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["最后拍摄时间"].ToString(); dgvr.Cells.Add(cell); //选片状态 cell = new DataGridViewTextBoxCell(); if (dt_BootDivisiont.Rows[t]["选片状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未选"; } dgvr.Cells.Add(cell); //选片时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_BootDivisiont.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //取件状态 cell = new DataGridViewTextBoxCell(); if (dt_BootDivisiont.Rows[t]["取件状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未取"; } dgvr.Cells.Add(cell); //取件时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_BootDivisiont.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //拍摄名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["拍摄名称"].ToString(); dgvr.Cells.Add(cell); //订单类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["订单类型"].ToString(); dgvr.Cells.Add(cell); //收款类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["收款类别"].ToString(); dgvr.Cells.Add(cell); //副订单 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["副订单"].ToString(); dgvr.Cells.Add(cell); //引导满意总分 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["引导满意总分"].ToString(); dgvr.Cells.Add(cell); #endregion this.Invoke(new UpdateControl(delegate() { this.dgv.Rows.Add(dgvr); })); } } } #endregion #region 引导助理 s = ""; strBuilder = new StringBuilder(); if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName)) { strBuilder.Append(" And 引导助理ID like '%" + EmployeeName + "%' "); } if (this.Str_ProcessStatus.Trim() == "") { strBuilder.Append(" And 未拍个数 = 0 And (收款时间 >= '" + StartTime + "' And 收款时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "拍照OK") { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "选片OK") { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "取件OK") { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); } if (!string.IsNullOrEmpty(this.Str_Scores1)) { strBuilder.Append(" and (引导助理满意总分>=" + this.Str_Scores1 + " and 引导助理满意总分<=" + this.Str_Scores2 + ")"); } s = BindSelect5(); DataTable dtCount2 = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0]; if (dtCount2.Rows.Count > 0) { if (Convert.ToInt32(dtCount2.Rows[0]["CountID"]) > 0) { backgroundWorker.ReportProgress(0, "正在获取'引导助理选片二销业绩' ..."); string StrColumnName = "订单号,客户名称,收款金额,收款时间,套系类别,套系名称,应收金额,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,拍摄名称,订单类型,副订单,引导助理满意总分"; DataTable dt_BootDivisiont = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0]; for (int t = 0; t < dt_BootDivisiont.Rows.Count; t++) { #region DataGridViewRow dgvr = new DataGridViewRow(); DataGridViewCell cell = null; //订单号 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["订单号"].ToString().Trim(); dgvr.Cells.Add(cell); //员工 cell = new DataGridViewTextBoxCell(); cell.Value = StrUserName; dgvr.Cells.Add(cell); //职务 cell = new DataGridViewTextBoxCell(); cell.Value = "引导助理选片二销"; dgvr.Cells.Add(cell); //客户姓名 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["客户名称"].ToString().Trim(); dgvr.Cells.Add(cell); //收款金额 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(dt_BootDivisiont.Rows[t]["收款金额"]).ToString("N2"); dgvr.Cells.Add(cell); //收款时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["收款时间"].ToString().Trim(); dgvr.Cells.Add(cell); //套系类别 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["套系类别"].ToString().Trim(); dgvr.Cells.Add(cell); //套系名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["套系名称"].ToString().Trim(); dgvr.Cells.Add(cell); //应收金额 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(dt_BootDivisiont.Rows[t]["应收金额"]).ToString("N2").Trim(); dgvr.Cells.Add(cell); //项目名称 cell = new DataGridViewTextBoxCell(); if (string.IsNullOrEmpty(dt_BootDivisiont.Rows[t]["项目名称"].ToString().Trim())) { cell.Value = dt_BootDivisiont.Rows[t]["收款类别"].ToString(); } else { cell.Value = dt_BootDivisiont.Rows[t]["项目名称"].ToString().Trim(); } dgvr.Cells.Add(cell); //付款名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["付款方式名称"].ToString().Trim(); dgvr.Cells.Add(cell); //拍摄状态 cell = new DataGridViewTextBoxCell(); if (Convert.ToInt32(dt_BootDivisiont.Rows[t]["未拍个数"]) == 0) { cell.Value = "OK"; } else { cell.Value = "未拍"; } dgvr.Cells.Add(cell); //拍摄时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["最后拍摄时间"].ToString(); dgvr.Cells.Add(cell); //选片状态 cell = new DataGridViewTextBoxCell(); if (dt_BootDivisiont.Rows[t]["选片状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未选"; } dgvr.Cells.Add(cell); //选片时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_BootDivisiont.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //取件状态 cell = new DataGridViewTextBoxCell(); if (dt_BootDivisiont.Rows[t]["取件状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未取"; } dgvr.Cells.Add(cell); //取件时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_BootDivisiont.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //拍摄名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["拍摄名称"].ToString(); dgvr.Cells.Add(cell); //订单类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["订单类型"].ToString(); dgvr.Cells.Add(cell); //收款类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["收款类别"].ToString(); dgvr.Cells.Add(cell); //副订单 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["副订单"].ToString(); dgvr.Cells.Add(cell); //引导满意总分 cell = new DataGridViewTextBoxCell(); cell.Value = dt_BootDivisiont.Rows[t]["引导助理满意总分"].ToString(); dgvr.Cells.Add(cell); #endregion this.Invoke(new UpdateControl(delegate() { this.dgv.Rows.Add(dgvr); })); } } } #endregion } } } ConfigureRow = dt_SystemConfigure.Select("Sconfig_Code='FirstRepairDivisionSelectionFilms' and Sconfig_IsEnabled=1"); if (ConfigureRow.Length > 0) { if (ConfigureRow[0]["Sconfig_Value"].ToString() == "1") { if (this.Str_ProjectTitle.Trim() == "" || this.Str_ProjectTitle.Trim() == "初修选片二销") { #region 初修师 s = ""; strBuilder = new StringBuilder(); if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName)) { strBuilder.Append(" And 初修师ID like '%" + EmployeeName + "%' "); } if (this.Str_ProcessStatus.Trim() == "") { strBuilder.Append(" And 未拍个数 = 0 And 服务前期初修查询状态 = '2' And (初修二销查询时间 >= '" + StartTime + "' And 初修二销查询时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "拍照OK") { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "选片OK") { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "取件OK") { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); } if (!string.IsNullOrEmpty(this.Str_Scores1)) { strBuilder.Append(" and (初修师满意总分>=" + this.Str_Scores1 + " and 初修师满意总分<=" + this.Str_Scores2 + ")"); } s = BindSelect5(); DataTable dtCount = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0]; if (dtCount.Rows.Count > 0) { if (Convert.ToInt32(dtCount.Rows[0]["CountID"]) > 0) { backgroundWorker.ReportProgress(0, "正在获取'初修师选片二销业绩' ..."); string StrColumnName = "订单号,客户名称,收款金额,收款时间,套系类别,套系名称,应收金额,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,初修状态,初修时间,取件状态,取件日期,拍摄名称,订单类型,副订单,初修师满意总分"; DataTable dt_EarlyRepair = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0]; for (int t = 0; t < dt_EarlyRepair.Rows.Count; t++) { #region DataGridViewRow dgvr = new DataGridViewRow(); DataGridViewCell cell = null; //订单号 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["订单号"].ToString().Trim(); dgvr.Cells.Add(cell); //员工 cell = new DataGridViewTextBoxCell(); cell.Value = StrUserName; dgvr.Cells.Add(cell); //职务 cell = new DataGridViewTextBoxCell(); cell.Value = "初修师选片二销"; dgvr.Cells.Add(cell); //客户姓名 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["客户名称"].ToString().Trim(); dgvr.Cells.Add(cell); //收款金额 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(dt_EarlyRepair.Rows[t]["收款金额"]).ToString("N2"); dgvr.Cells.Add(cell); //收款时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["收款时间"].ToString().Trim(); dgvr.Cells.Add(cell); //套系类别 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["套系类别"].ToString().Trim(); dgvr.Cells.Add(cell); //套系名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["套系名称"].ToString().Trim(); dgvr.Cells.Add(cell); //应收金额 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(dt_EarlyRepair.Rows[t]["应收金额"]).ToString("N2").Trim(); dgvr.Cells.Add(cell); //项目名称 cell = new DataGridViewTextBoxCell(); if (string.IsNullOrEmpty(dt_EarlyRepair.Rows[t]["项目名称"].ToString().Trim())) { cell.Value = dt_EarlyRepair.Rows[t]["收款类别"].ToString(); } else { cell.Value = dt_EarlyRepair.Rows[t]["项目名称"].ToString().Trim(); } dgvr.Cells.Add(cell); //付款名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["付款方式名称"].ToString().Trim(); dgvr.Cells.Add(cell); //拍摄状态 cell = new DataGridViewTextBoxCell(); if (Convert.ToInt32(dt_EarlyRepair.Rows[t]["未拍个数"]) == 0) { cell.Value = "OK"; } else { cell.Value = "未拍"; } dgvr.Cells.Add(cell); //拍摄时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["最后拍摄时间"].ToString(); dgvr.Cells.Add(cell); //选片状态 cell = new DataGridViewTextBoxCell(); if (dt_EarlyRepair.Rows[t]["选片状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未选"; } dgvr.Cells.Add(cell); //选片时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_EarlyRepair.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //取件状态 cell = new DataGridViewTextBoxCell(); if (dt_EarlyRepair.Rows[t]["取件状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未取"; } dgvr.Cells.Add(cell); //取件时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_EarlyRepair.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //拍摄名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["拍摄名称"].ToString(); dgvr.Cells.Add(cell); //订单类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["订单类型"].ToString(); dgvr.Cells.Add(cell); //收款类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["收款类别"].ToString(); dgvr.Cells.Add(cell); //副订单 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["副订单"].ToString(); dgvr.Cells.Add(cell); //初修师满意总分 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["初修师满意总分"].ToString(); dgvr.Cells.Add(cell); #endregion this.Invoke(new UpdateControl(delegate() { this.dgv.Rows.Add(dgvr); })); } } } #endregion } } } ConfigureRow = dt_SystemConfigure.Select("Sconfig_Code = 'StoreSelectionFilms' and Sconfig_IsEnabled = 1"); if (ConfigureRow.Length > 0) { if (ConfigureRow[0]["Sconfig_Value"].ToString() == "1") { if (this.Str_ProjectTitle.Trim() == "" || this.Str_ProjectTitle.Trim() == "门市选片二销") { #region 门市 s = ""; strBuilder = new StringBuilder(); if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName)) { strBuilder.Append(" And 订单门市 like '%" + EmployeeName + "%' "); } if (this.Str_ProcessStatus.Trim() == "") { strBuilder.Append(" And 未拍个数 = 0 And (收款时间 >= '" + StartTime + " 00:00:00.000' And 收款时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "拍照OK") { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "选片OK") { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "取件OK") { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); } s = BindSelect5(); DataTable dtCount = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0]; if (dtCount.Rows.Count > 0) { if (Convert.ToInt32(dtCount.Rows[0]["CountID"]) > 0) { backgroundWorker.ReportProgress(0, "正在获取'门市选片二销业绩' ..."); string StrColumnName = "订单号,客户名称,收款金额,收款时间,套系类别,套系名称,应收金额,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,取件状态,取件日期,拍摄名称,订单类型,副订单"; DataTable dt_OrderPerson = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0]; for (int t = 0; t < dt_OrderPerson.Rows.Count; t++) { #region DataGridViewRow dgvr = new DataGridViewRow(); DataGridViewCell cell = null; //订单号 cell = new DataGridViewTextBoxCell(); cell.Value = dt_OrderPerson.Rows[t]["订单号"].ToString().Trim(); dgvr.Cells.Add(cell); //员工 cell = new DataGridViewTextBoxCell(); cell.Value = StrUserName; dgvr.Cells.Add(cell); //职务 cell = new DataGridViewTextBoxCell(); cell.Value = "门市选片二销"; dgvr.Cells.Add(cell); //客户姓名 cell = new DataGridViewTextBoxCell(); cell.Value = dt_OrderPerson.Rows[t]["客户名称"].ToString().Trim(); dgvr.Cells.Add(cell); //收款金额 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(dt_OrderPerson.Rows[t]["收款金额"]).ToString("N2"); dgvr.Cells.Add(cell); //收款时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_OrderPerson.Rows[t]["收款时间"].ToString().Trim(); dgvr.Cells.Add(cell); //套系类别 cell = new DataGridViewTextBoxCell(); cell.Value = dt_OrderPerson.Rows[t]["套系类别"].ToString().Trim(); dgvr.Cells.Add(cell); //套系名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_OrderPerson.Rows[t]["套系名称"].ToString().Trim(); dgvr.Cells.Add(cell); //应收金额 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(dt_OrderPerson.Rows[t]["应收金额"]).ToString("N2").Trim(); dgvr.Cells.Add(cell); //项目名称 cell = new DataGridViewTextBoxCell(); if (string.IsNullOrEmpty(dt_OrderPerson.Rows[t]["项目名称"].ToString().Trim())) { cell.Value = dt_OrderPerson.Rows[t]["收款类别"].ToString(); } else { cell.Value = dt_OrderPerson.Rows[t]["项目名称"].ToString().Trim(); } dgvr.Cells.Add(cell); //付款名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_OrderPerson.Rows[t]["付款方式名称"].ToString().Trim(); dgvr.Cells.Add(cell); //拍摄状态 cell = new DataGridViewTextBoxCell(); if (Convert.ToInt32(dt_OrderPerson.Rows[t]["未拍个数"]) == 0) { cell.Value = "OK"; } else { cell.Value = "未拍"; } dgvr.Cells.Add(cell); //拍摄时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_OrderPerson.Rows[t]["最后拍摄时间"].ToString(); dgvr.Cells.Add(cell); //选片状态 cell = new DataGridViewTextBoxCell(); if (dt_OrderPerson.Rows[t]["选片状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未选"; } dgvr.Cells.Add(cell); //选片时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_OrderPerson.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //取件状态 cell = new DataGridViewTextBoxCell(); if (dt_OrderPerson.Rows[t]["取件状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未取"; } dgvr.Cells.Add(cell); //取件时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_OrderPerson.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //拍摄名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_OrderPerson.Rows[t]["拍摄名称"].ToString(); dgvr.Cells.Add(cell); //订单类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_OrderPerson.Rows[t]["订单类型"].ToString(); dgvr.Cells.Add(cell); //收款类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_OrderPerson.Rows[t]["收款类别"].ToString(); dgvr.Cells.Add(cell); //副订单 cell = new DataGridViewTextBoxCell(); cell.Value = dt_OrderPerson.Rows[t]["副订单"].ToString(); dgvr.Cells.Add(cell); //门市满意总分 cell = new DataGridViewTextBoxCell(); cell.Value = ""; dgvr.Cells.Add(cell); #endregion this.Invoke(new UpdateControl(delegate() { this.dgv.Rows.Add(dgvr); })); } } } #endregion } } } ConfigureRow = dt_SystemConfigure.Select("Sconfig_Code='DesignerSelectionFilms' and Sconfig_IsEnabled=1"); if (ConfigureRow.Length > 0) { if (ConfigureRow[0]["Sconfig_Value"].ToString() == "1") { if (this.Str_ProjectTitle.Trim() == "" || this.Str_ProjectTitle.Trim() == "设计选片二销") { #region 设计师 s = ""; strBuilder = new StringBuilder(); if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName)) { strBuilder.Append(" And 设计师ID like '%" + EmployeeName + "%' "); } if (this.Str_ProcessStatus.Trim() == "") { strBuilder.Append(" And 未拍个数 = 0 And 服务前期设计查询状态 = '2' And (设计二销查询时间 >= '" + StartTime + "' And 设计二销查询时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "拍照OK") { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "选片OK") { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "取件OK") { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); } if (!string.IsNullOrEmpty(this.Str_Scores1)) { strBuilder.Append(" and (设计师满意总分>=" + this.Str_Scores1 + " and 设计师满意总分<=" + this.Str_Scores2 + ")"); } s = BindSelect5(); DataTable dtCount = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0]; if (dtCount.Rows.Count > 0) { if (Convert.ToInt32(dtCount.Rows[0]["CountID"]) > 0) { backgroundWorker.ReportProgress(0, "正在获取'设计师选片二销业绩' ..."); string StrColumnName = "订单号,客户名称,收款金额,收款时间,套系类别,套系名称,应收金额,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,设计状态,设计时间,取件状态,取件日期,拍摄名称,订单类型,副订单,设计师满意总分"; DataTable dt_EarlyRepair = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0]; for (int t = 0; t < dt_EarlyRepair.Rows.Count; t++) { #region DataGridViewRow dgvr = new DataGridViewRow(); DataGridViewCell cell = null; //订单号 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["订单号"].ToString().Trim(); dgvr.Cells.Add(cell); //员工 cell = new DataGridViewTextBoxCell(); cell.Value = StrUserName; dgvr.Cells.Add(cell); //职务 cell = new DataGridViewTextBoxCell(); cell.Value = "设计师选片二销"; dgvr.Cells.Add(cell); //客户姓名 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["客户名称"].ToString().Trim(); dgvr.Cells.Add(cell); //收款金额 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(dt_EarlyRepair.Rows[t]["收款金额"]).ToString("N2"); dgvr.Cells.Add(cell); //收款时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["收款时间"].ToString().Trim(); dgvr.Cells.Add(cell); //套系类别 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["套系类别"].ToString().Trim(); dgvr.Cells.Add(cell); //套系名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["套系名称"].ToString().Trim(); dgvr.Cells.Add(cell); //应收金额 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(dt_EarlyRepair.Rows[t]["应收金额"]).ToString("N2").Trim(); dgvr.Cells.Add(cell); //项目名称 cell = new DataGridViewTextBoxCell(); if (string.IsNullOrEmpty(dt_EarlyRepair.Rows[t]["项目名称"].ToString().Trim())) { cell.Value = dt_EarlyRepair.Rows[t]["收款类别"].ToString(); } else { cell.Value = dt_EarlyRepair.Rows[t]["项目名称"].ToString().Trim(); } dgvr.Cells.Add(cell); //付款名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["付款方式名称"].ToString().Trim(); dgvr.Cells.Add(cell); //拍摄状态 cell = new DataGridViewTextBoxCell(); if (Convert.ToInt32(dt_EarlyRepair.Rows[t]["未拍个数"]) == 0) { cell.Value = "OK"; } else { cell.Value = "未拍"; } dgvr.Cells.Add(cell); //拍摄时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["最后拍摄时间"].ToString(); dgvr.Cells.Add(cell); //选片状态 cell = new DataGridViewTextBoxCell(); if (dt_EarlyRepair.Rows[t]["选片状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未选"; } dgvr.Cells.Add(cell); //选片时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_EarlyRepair.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //取件状态 cell = new DataGridViewTextBoxCell(); if (dt_EarlyRepair.Rows[t]["取件状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未取"; } dgvr.Cells.Add(cell); //取件时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_EarlyRepair.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //拍摄名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["拍摄名称"].ToString(); dgvr.Cells.Add(cell); //订单类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["订单类型"].ToString(); dgvr.Cells.Add(cell); //收款类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["收款类别"].ToString(); dgvr.Cells.Add(cell); //副订单 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["副订单"].ToString(); dgvr.Cells.Add(cell); //初修师满意总分 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["设计师满意总分"].ToString(); dgvr.Cells.Add(cell); #endregion this.Invoke(new UpdateControl(delegate() { this.dgv.Rows.Add(dgvr); })); } } } #endregion } } } ConfigureRow = dt_SystemConfigure.Select("Sconfig_Code='RefinedRepairSelectionFilms' and Sconfig_IsEnabled=1"); if (ConfigureRow.Length > 0) { if (ConfigureRow[0]["Sconfig_Value"].ToString() == "1") { if (this.Str_ProjectTitle.Trim() == "" || this.Str_ProjectTitle.Trim() == "精修选片二销") { #region 精修师 s = ""; strBuilder = new StringBuilder(); if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName)) { strBuilder.Append(" And 精修师ID like '%" + EmployeeName + "%' "); } if (this.Str_ProcessStatus.Trim() == "") { strBuilder.Append(" And 未拍个数 = 0 And 服务前期精修查询状态 = '2' And (精修二销查询时间 >= '" + StartTime + "' And 精修二销查询时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "拍照OK") { strBuilder.Append(" And 未拍个数 = 0 And (最后拍摄时间 >= '" + StartTime + "' And 最后拍摄时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "选片OK") { strBuilder.Append(" And 选片状态 = 'OK' And (选片时间 >= '" + StartTime + "' And 选片时间 <= '" + EndTime + " 23:59:59.000')"); } if (this.Str_ProcessStatus.Trim() == "取件OK") { strBuilder.Append(" And 取件状态 = 'OK' And (取件日期 >= '" + StartTime + "' And 取件日期 <= '" + EndTime + " 23:59:59.000')"); } if (!string.IsNullOrEmpty(this.Str_Scores1)) { strBuilder.Append(" and (精修师满意总分>=" + this.Str_Scores1 + " and 精修师满意总分<=" + this.Str_Scores2 + ")"); } s = BindSelect5(); DataTable dtCount = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0]; if (dtCount.Rows.Count > 0) { if (Convert.ToInt32(dtCount.Rows[0]["CountID"]) > 0) { backgroundWorker.ReportProgress(0, "正在获取'精修师选片二销业绩' ..."); string StrColumnName = "订单号,客户名称,收款金额,收款时间,套系类别,套系名称,应收金额,项目名称,收款类别,付款方式名称,未拍个数,最后拍摄时间,选片状态,选片时间,精修状态,精修时间,取件状态,取件日期,拍摄名称,订单类型,副订单,精修师满意总分"; DataTable dt_EarlyRepair = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: "二销类别编号='BEBCABBAAHFCJBJGJ'" + strBuilder.ToString() + s.ToString(), ShowColumnName: StrColumnName).Tables[0]; for (int t = 0; t < dt_EarlyRepair.Rows.Count; t++) { #region DataGridViewRow dgvr = new DataGridViewRow(); DataGridViewCell cell = null; //订单号 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["订单号"].ToString().Trim(); dgvr.Cells.Add(cell); //员工 cell = new DataGridViewTextBoxCell(); cell.Value = StrUserName; dgvr.Cells.Add(cell); //职务 cell = new DataGridViewTextBoxCell(); cell.Value = "精修师选片二销"; dgvr.Cells.Add(cell); //客户姓名 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["客户名称"].ToString().Trim(); dgvr.Cells.Add(cell); //收款金额 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(dt_EarlyRepair.Rows[t]["收款金额"]).ToString("N2"); dgvr.Cells.Add(cell); //收款时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["收款时间"].ToString().Trim(); dgvr.Cells.Add(cell); //套系类别 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["套系类别"].ToString().Trim(); dgvr.Cells.Add(cell); //套系名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["套系名称"].ToString().Trim(); dgvr.Cells.Add(cell); //应收金额 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(dt_EarlyRepair.Rows[t]["应收金额"]).ToString("N2").Trim(); dgvr.Cells.Add(cell); //项目名称 cell = new DataGridViewTextBoxCell(); if (string.IsNullOrEmpty(dt_EarlyRepair.Rows[t]["项目名称"].ToString().Trim())) { cell.Value = dt_EarlyRepair.Rows[t]["收款类别"].ToString(); } else { cell.Value = dt_EarlyRepair.Rows[t]["项目名称"].ToString().Trim(); } dgvr.Cells.Add(cell); //付款名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["付款方式名称"].ToString().Trim(); dgvr.Cells.Add(cell); //拍摄状态 cell = new DataGridViewTextBoxCell(); if (Convert.ToInt32(dt_EarlyRepair.Rows[t]["未拍个数"]) == 0) { cell.Value = "OK"; } else { cell.Value = "未拍"; } dgvr.Cells.Add(cell); //拍摄时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["最后拍摄时间"].ToString(); dgvr.Cells.Add(cell); //选片状态 cell = new DataGridViewTextBoxCell(); if (dt_EarlyRepair.Rows[t]["选片状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未选"; } dgvr.Cells.Add(cell); //选片时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_EarlyRepair.Rows[t]["选片时间"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //取件状态 cell = new DataGridViewTextBoxCell(); if (dt_EarlyRepair.Rows[t]["取件状态"].ToString() == "OK") { cell.Value = "OK"; } else { cell.Value = "未取"; } dgvr.Cells.Add(cell); //取件时间 cell = new DataGridViewTextBoxCell(); cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(dt_EarlyRepair.Rows[t]["取件日期"], "yyyy-MM-dd HH:mm"); dgvr.Cells.Add(cell); //拍摄名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["拍摄名称"].ToString(); dgvr.Cells.Add(cell); //订单类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["订单类型"].ToString(); dgvr.Cells.Add(cell); //收款类型 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["收款类别"].ToString(); dgvr.Cells.Add(cell); //副订单 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["副订单"].ToString(); dgvr.Cells.Add(cell); //初修师满意总分 cell = new DataGridViewTextBoxCell(); cell.Value = dt_EarlyRepair.Rows[t]["精修师满意总分"].ToString(); dgvr.Cells.Add(cell); #endregion this.Invoke(new UpdateControl(delegate() { this.dgv.Rows.Add(dgvr); })); } } } #endregion } } } #endregion } #endregion } if (this.Str_ItemCategory.Trim() == "" || this.Str_ItemCategory.Trim() == "会员充值") { #region 获取会员充值 s = ""; strBuilder = new StringBuilder(); bool IsQuery = true; if (string.IsNullOrEmpty(this.Str_ProcessStatus.Trim())) { strBuilder.Append("and 创建时间 >= '" + StartTime + "' and 创建时间 <= '" + EndTime + " 23:59:59.000' "); if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName)) { strBuilder.Append("and 接单人编号 like '%" + EmployeeName + "%'"); } s = BindSelect2(ref IsQuery); } else { IsQuery = false; } if (IsQuery) { DataTable dtCount = orbll.GetView_Custom("Vw_StaffPerformance_MemberCardRechargeRecord", StrWhere: " 1 = 1 " + strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0]; if (dtCount.Rows.Count > 0) { if (Convert.ToInt32(dtCount.Rows[0]["CountID"]) > 0) { backgroundWorker.ReportProgress(0, "正在获取'会员充值' ..."); DataTable dt_MemberRecharge = avsbll.Vw_StaffPerformance_MemberCardRechargeRecord(strBuilder.ToString() + s.ToString()).Tables[0]; for (int t = 0; t < dt_MemberRecharge.Rows.Count; t++) { #region DataGridViewRow dgvr = new DataGridViewRow(); DataGridViewCell cell = null; //订单号 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MemberRecharge.Rows[t]["充值编号"].ToString().Trim(); dgvr.Cells.Add(cell); //员工 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MemberRecharge.Rows[t]["接单人名称"].ToString().Trim(); dgvr.Cells.Add(cell); //职务 cell = new DataGridViewTextBoxCell(); cell.Value = "会员接单人"; dgvr.Cells.Add(cell); //客户姓名 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MemberRecharge.Rows[t]["客户姓名"].ToString().Trim(); dgvr.Cells.Add(cell); //收款金额 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(dt_MemberRecharge.Rows[t]["充值金额"]).ToString("N2").Trim(); dgvr.Cells.Add(cell); //收款时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MemberRecharge.Rows[t]["创建时间"].ToString().Trim(); dgvr.Cells.Add(cell); //套系类别 cell = new DataGridViewTextBoxCell(); cell.Value = "/会员充值"; dgvr.Cells.Add(cell); //套系名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MemberRecharge.Rows[t]["充值名称"].ToString().Trim(); dgvr.Cells.Add(cell); //应收金额 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(dt_MemberRecharge.Rows[t]["充值金额"]).ToString("N2").Trim(); dgvr.Cells.Add(cell); //项目名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MemberRecharge.Rows[t]["充值名称"].ToString().Trim(); dgvr.Cells.Add(cell); //付款名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_MemberRecharge.Rows[t]["支付方式名称"].ToString().Trim(); dgvr.Cells.Add(cell); //拍摄状态 cell = new DataGridViewTextBoxCell(); cell.Value = ""; dgvr.Cells.Add(cell); //拍摄时间 cell = new DataGridViewTextBoxCell(); cell.Value = ""; dgvr.Cells.Add(cell); //选片状态 cell = new DataGridViewTextBoxCell(); cell.Value = ""; dgvr.Cells.Add(cell); //选片时间 cell = new DataGridViewTextBoxCell(); cell.Value = ""; dgvr.Cells.Add(cell); //取件状态 cell = new DataGridViewTextBoxCell(); cell.Value = ""; dgvr.Cells.Add(cell); //取件时间 cell = new DataGridViewTextBoxCell(); cell.Value = ""; dgvr.Cells.Add(cell); //副订单 cell = new DataGridViewTextBoxCell(); cell.Value = ""; dgvr.Cells.Add(cell); #endregion this.Invoke(new UpdateControl(delegate() { this.dgv.Rows.Add(dgvr); })); } } } } #endregion } if (this.Str_ItemCategory.Trim() == "" || this.Str_ItemCategory.Trim() == "服务卡充值") { #region 获取服务卡充值 s = ""; strBuilder = new StringBuilder(); bool IsQuery = true; if (string.IsNullOrEmpty(this.Str_ProcessStatus.Trim())) { strBuilder.Append("and 创建日期>='" + StartTime + "' and 创建日期<='" + EndTime + " 23:59:59.000' "); if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName)) { strBuilder.Append("and 接单人编号 like '%" + EmployeeName + "%'"); } s = BindSelect3(ref IsQuery); } else { IsQuery = false; } if (IsQuery) { DataTable dtCount = orbll.GetView_Custom("Vw_ErpMemberCardPayment", StrWhere: " 1 = 1 " + strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0]; if (dtCount.Rows.Count > 0) { if (Convert.ToInt32(dtCount.Rows[0]["CountID"]) > 0) { backgroundWorker.ReportProgress(0, "正在获取'服务卡充值' ..."); DataTable dt_ServiceRecharge = avsbll.Vw_ErpMemberCardPayment(strBuilder.ToString() + s.ToString()).Tables[0]; for (int t = 0; t < dt_ServiceRecharge.Rows.Count; t++) { #region DataGridViewRow dgvr = new DataGridViewRow(); DataGridViewCell cell = null; //订单号 cell = new DataGridViewTextBoxCell(); cell.Value = dt_ServiceRecharge.Rows[t]["收款编号"].ToString().Trim(); dgvr.Cells.Add(cell); //员工 cell = new DataGridViewTextBoxCell(); cell.Value = dt_ServiceRecharge.Rows[t]["接单人名称"].ToString().Trim(); dgvr.Cells.Add(cell); //职务 cell = new DataGridViewTextBoxCell(); cell.Value = "服务卡接单人"; dgvr.Cells.Add(cell); //客户姓名 cell = new DataGridViewTextBoxCell(); cell.Value = dt_ServiceRecharge.Rows[t]["客户姓名"].ToString().Trim(); dgvr.Cells.Add(cell); //收款金额 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(dt_ServiceRecharge.Rows[t]["收款金额"]).ToString("N2").Trim(); dgvr.Cells.Add(cell); //收款时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_ServiceRecharge.Rows[t]["创建日期"].ToString().Trim(); dgvr.Cells.Add(cell); //套系类别 cell = new DataGridViewTextBoxCell(); cell.Value = "/服务卡充值"; dgvr.Cells.Add(cell); //套系名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_ServiceRecharge.Rows[t]["服务套系类别名称"].ToString().Trim(); dgvr.Cells.Add(cell); //应收金额 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(dt_ServiceRecharge.Rows[t]["收款金额"]).ToString("N2").Trim(); dgvr.Cells.Add(cell); //项目名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_ServiceRecharge.Rows[t]["服务套系类别名称"].ToString().Trim(); dgvr.Cells.Add(cell); //付款名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_ServiceRecharge.Rows[t]["支付方式名称"].ToString().Trim(); dgvr.Cells.Add(cell); //拍摄状态 cell = new DataGridViewTextBoxCell(); cell.Value = ""; dgvr.Cells.Add(cell); //拍摄时间 cell = new DataGridViewTextBoxCell(); cell.Value = ""; dgvr.Cells.Add(cell); //选片状态 cell = new DataGridViewTextBoxCell(); cell.Value = ""; dgvr.Cells.Add(cell); //选片时间 cell = new DataGridViewTextBoxCell(); cell.Value = ""; dgvr.Cells.Add(cell); //取件状态 cell = new DataGridViewTextBoxCell(); cell.Value = ""; dgvr.Cells.Add(cell); //取件时间 cell = new DataGridViewTextBoxCell(); cell.Value = ""; dgvr.Cells.Add(cell); //副订单 cell = new DataGridViewTextBoxCell(); cell.Value = ""; dgvr.Cells.Add(cell); #endregion this.Invoke(new UpdateControl(delegate() { this.dgv.Rows.Add(dgvr); })); } } } } #endregion } if (this.Str_ItemCategory.Trim() == "" || this.Str_ItemCategory.Trim() == "计件提成") { #region 获取计件提成 s = ""; strBuilder = new StringBuilder(); bool IsQuery = true; if (string.IsNullOrEmpty(this.Str_ProcessStatus.Trim())) { strBuilder.Append("and Pcr_Date >= '" + StartTime + "' and Pcr_Date <= '" + EndTime + " 23:59:59.000' "); if (EmployeeName != null && !string.IsNullOrEmpty(EmployeeName)) { strBuilder.Append("and Pcr_DigitalDivision like '%" + EmployeeName + "%'"); } s = BindSelect4(ref IsQuery); } else { IsQuery = false; } if (IsQuery) { DataTable dtCount = orbll.GetView_Custom("Vw_ErpPieceCommissionRecords", StrWhere: " 1 = 1 " + strBuilder.ToString() + s.ToString(), ShowColumnName: "Count(ID) CountID").Tables[0]; if (dtCount.Rows.Count > 0) { if (Convert.ToInt32(dtCount.Rows[0]["CountID"]) > 0) { backgroundWorker.ReportProgress(0, "正在获取'计件提成' ..."); DataTable dt_PieceCommission = pcrbll.Vw_ErpPieceCommissionRecords(strBuilder.ToString() + s.ToString()).Tables[0]; for (int t = 0; t < dt_PieceCommission.Rows.Count; t++) { #region DataGridViewRow dgvr = new DataGridViewRow(); DataGridViewCell cell = null; //订单号 cell = new DataGridViewTextBoxCell(); cell.Value = dt_PieceCommission.Rows[t]["Pcr_OrderNumber"].ToString().Trim(); dgvr.Cells.Add(cell); //员工 cell = new DataGridViewTextBoxCell(); cell.Value = dt_PieceCommission.Rows[t]["Pcr_DigitalDivisionName"].ToString().Trim(); dgvr.Cells.Add(cell); //职务 cell = new DataGridViewTextBoxCell(); cell.Value = "计件接单人"; dgvr.Cells.Add(cell); //客户姓名 cell = new DataGridViewTextBoxCell(); cell.Value = dt_PieceCommission.Rows[t]["Cus_Name"].ToString().Trim(); dgvr.Cells.Add(cell); //收款金额 cell = new DataGridViewTextBoxCell(); cell.Value = dt_PieceCommission.Rows[t]["总价格"].ToString() == "" ? "0" : Convert.ToDecimal(dt_PieceCommission.Rows[t]["总价格"]).ToString("N2"); dgvr.Cells.Add(cell); //收款时间 cell = new DataGridViewTextBoxCell(); cell.Value = dt_PieceCommission.Rows[t]["Pcr_Date"].ToString().Trim(); dgvr.Cells.Add(cell); //套系类别 cell = new DataGridViewTextBoxCell(); cell.Value = "/计件提成"; dgvr.Cells.Add(cell); //套系名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_PieceCommission.Rows[t]["Pcr_CompletionContentsName"].ToString().Trim(); dgvr.Cells.Add(cell); //应收金额 cell = new DataGridViewTextBoxCell(); cell.Value = dt_PieceCommission.Rows[t]["总价格"].ToString() == "" ? "0" : Convert.ToDecimal(dt_PieceCommission.Rows[t]["总价格"]).ToString("N2"); dgvr.Cells.Add(cell); //项目名称 cell = new DataGridViewTextBoxCell(); cell.Value = dt_PieceCommission.Rows[t]["Pcr_CompletionContentsName"].ToString().Trim(); dgvr.Cells.Add(cell); //付款名称 cell = new DataGridViewTextBoxCell(); cell.Value = ""; dgvr.Cells.Add(cell); //拍摄状态 cell = new DataGridViewTextBoxCell(); cell.Value = ""; dgvr.Cells.Add(cell); //拍摄时间 cell = new DataGridViewTextBoxCell(); cell.Value = ""; dgvr.Cells.Add(cell); //选片状态 cell = new DataGridViewTextBoxCell(); cell.Value = ""; dgvr.Cells.Add(cell); //选片时间 cell = new DataGridViewTextBoxCell(); cell.Value = ""; dgvr.Cells.Add(cell); //取件状态 cell = new DataGridViewTextBoxCell(); cell.Value = ""; dgvr.Cells.Add(cell); //取件时间 cell = new DataGridViewTextBoxCell(); cell.Value = ""; dgvr.Cells.Add(cell); //副订单 cell = new DataGridViewTextBoxCell(); cell.Value = ""; dgvr.Cells.Add(cell); //满意总分 cell = new DataGridViewTextBoxCell(); cell.Value = ""; dgvr.Cells.Add(cell); // cell = new DataGridViewTextBoxCell(); cell.Value = ""; dgvr.Cells.Add(cell); // cell = new DataGridViewTextBoxCell(); cell.Value = ""; dgvr.Cells.Add(cell); // cell = new DataGridViewTextBoxCell(); cell.Value = ""; dgvr.Cells.Add(cell); //数量 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToInt32(dt_PieceCommission.Rows[t]["Pcr_Quantity"]).ToString().Trim(); dgvr.Cells.Add(cell); #endregion this.Invoke(new UpdateControl(delegate() { this.dgv.Rows.Add(dgvr); })); } } } } #endregion } #endregion #region 显示绘画(计算业绩) backgroundWorker.ReportProgress(0, "正在计算业绩 ..."); string StrWhere1 = ""; string StrWhere2 = ""; string StrMainNumber = ""; string StrViceNumber = ""; this.Invoke(new UpdateControl(delegate() { for (int i = 0; i < this.dgv.Rows.Count; i++) { if (this.dgv.Rows[i].Cells["Column19"].Value != null) { if (this.dgv.Rows[i].Cells["Column19"].Value.ToString().Trim() != "1") { StrMainNumber += "'" + this.dgv.Rows[i].Cells["Column1"].Value.ToString().Trim() + "',"; } else { StrViceNumber += "'" + this.dgv.Rows[i].Cells["Column21"].Value.ToString().Trim() + "',"; } } } })); if (!string.IsNullOrEmpty(StrMainNumber)) { //StrWhere1 += "主订单 in (" + StrMainNumber.TrimEnd(',') + ")"; StrWhere1 += "Ordv_Number in (" + StrMainNumber.TrimEnd(',') + ")"; StrWhere2 += "Ordpg_Number in (" + StrMainNumber.TrimEnd(',') + ")"; } if (!string.IsNullOrEmpty(StrViceNumber)) { if (string.IsNullOrEmpty(StrMainNumber)) { //StrWhere1 += "副订单 in (" + StrViceNumber.TrimEnd(',') + ")"; StrWhere1 += "Ordv_ViceNumber in (" + StrViceNumber.TrimEnd(',') + ")"; StrWhere2 += "Ordpg_ViceNumber in (" + StrViceNumber.TrimEnd(',') + ")"; } else { //StrWhere1 += " Or 副订单 in (" + StrViceNumber.TrimEnd(',') + ")"; StrWhere1 += " Or Ordv_ViceNumber in (" + StrViceNumber.TrimEnd(',') + ")"; StrWhere2 += " Or Ordpg_ViceNumber in (" + StrViceNumber.TrimEnd(',') + ")"; } } DataTable dt_Level = new DataTable(); DataTable dt_Sights = new DataTable(); if (!string.IsNullOrEmpty(StrWhere1)) { //dt_Level = orbll.GetView_Custom("Vw_StaffPerformance_Photograph", StrWhere: StrWhere1, ShowColumnName: "*").Tables[0]; dt_Level = LYFZ.BLL.BLL_ErpPaymentPayrollClass.GetPayrollLevel(StrWhere1); } if (!string.IsNullOrEmpty(StrWhere2)) { dt_Sights = orbll.GetView_Custom("tb_ErpOrdersPhotography", StrWhere: StrWhere2, ShowColumnName: "*").Tables[0]; } this.Invoke(new UpdateControl(delegate() { if (this.dgv.Rows.Count > 0) { decimal CurrentPerformance = 0; //业绩 decimal PieceCommission = 0; for (int i = 0; i < this.dgv.Rows.Count; i++) { #region 参数 string Ord_Number = this.dgv.Rows[i].Cells["Column1"].Value.ToString(); object DeputyOrd_Number = this.dgv.Rows[i].Cells["Column21"].Value; object Ord_Type = this.dgv.Rows[i].Cells["Column19"].Value; object Pay_Category = this.dgv.Rows[i].Cells["Column20"].Value; object Project_Name = this.dgv.Rows[i].Cells["Column8"].Value; object Post = this.dgv.Rows[i].Cells["Column17"].Value; decimal Pay_AmountOf = Convert.ToDecimal(this.dgv.Rows[i].Cells["Column3"].Value); //摄影师 string OrdPg_Photographer = ""; string OrdPg_PhotographyAssistant = ""; //等级 string OrdPg_SightsLevel = ""; //化妆 string OrdPg_MakeupArtist = ""; string OrdPg_MakeupAssistant = ""; //引导 string Ordpg_BootDivision = ""; string Ordpg_BootDivisionAssistant = ""; #endregion #region 绘画前期业绩(摄影，化妆) if (Ord_Type != null) { if (Pay_Category.ToString() == "预约收款" || Pay_Category.ToString() == "全款" || Pay_Category.ToString() == "预约补款" || Project_Name.ToString() == "选片二销") { if (Ord_Type.ToString() != "") { #region 获取等级级别个数 //以下为滕工版 string StrWhere = ""; //if (Ord_Type.ToString() != "1") //{ StrWhere = " 主订单='" + Ord_Number + "'"; } //else //{ StrWhere = " 副订单='" + DeputyOrd_Number + "'"; } if (Ord_Type.ToString() != "1") { StrWhere = " Ordv_Number='" + Ord_Number + "'"; } else { StrWhere = " Ordv_ViceNumber='" + DeputyOrd_Number + "'"; } DataRow[] dtRows = dt_Level.Select(StrWhere); if (dtRows.Length > 0) { OneLevelCount = Convert.ToInt32(dtRows[0]["景点一级个数"]); TwoLevelCount = Convert.ToInt32(dtRows[0]["景点二级个数"]); ThreeLevelCount = Convert.ToInt32(dtRows[0]["景点三级个数"]); OrdPg_Photographer = dtRows[0]["主摄影师ID"].ToString(); OrdPg_PhotographyAssistant = dtRows[0]["摄影助理ID"].ToString(); OrdPg_MakeupArtist = dtRows[0]["主化妆ID"].ToString(); OrdPg_MakeupAssistant = dtRows[0]["化妆助理ID"].ToString(); Ordpg_BootDivision = dtRows[0]["引导师ID"].ToString(); Ordpg_BootDivisionAssistant = dtRows[0]["引导助理ID"].ToString(); } #region 摄影工资 if (Post.ToString() == "主摄影师" || Post.ToString() == "摄影助理" || Post.ToString() == "主摄影选片二销" || Post.ToString() == "摄影助理选片二销") { //修改前 if ((OneLevelCount >= 1 && TwoLevelCount == 0 && ThreeLevelCount == 0) || (OneLevelCount == 0 && TwoLevelCount >= 1 && ThreeLevelCount == 0) || (OneLevelCount == 0 && TwoLevelCount == 0 && ThreeLevelCount >= 1)) //刘工修改 if ((OneLevelCount + TwoLevelCount + ThreeLevelCount) == 1) { #region 1.如果所以景点阶段都相同 decimal Amount = 0; if (Post.ToString() == "主摄影师" || Post.ToString() == "主摄影选片二销") { OrdPg_Photographer = OrdPg_Photographer.TrimEnd(','); string[] OrdPg_Photographer_O = OrdPg_Photographer.Split(','); for (int t = 0; t < OrdPg_Photographer_O.Length; t++) { if (OrdPg_Photographer_O[t] == EmployeeName) { if (!string.IsNullOrEmpty(OrdPg_Photographer.ToString().TrimEnd(',')) && !string.IsNullOrEmpty(OrdPg_PhotographyAssistant.ToString().TrimEnd(','))) { Amount += (Pay_AmountOf * (MainPhotography / 100)) / OrdPg_Photographer_O.Length; } else { Amount += Pay_AmountOf / OrdPg_Photographer_O.Length; } } } } if (Post.ToString() == "摄影助理" || Post.ToString() == "摄影助理选片二销") { OrdPg_PhotographyAssistant = OrdPg_PhotographyAssistant.TrimEnd(','); string[] OrdPg_PhotographyAssistant_O = OrdPg_PhotographyAssistant.Split(','); for (int t = 0; t < OrdPg_PhotographyAssistant_O.Length; t++) { if (OrdPg_PhotographyAssistant_O[t] == EmployeeName) { if (!string.IsNullOrEmpty(OrdPg_Photographer.ToString().TrimEnd(',')) && !string.IsNullOrEmpty(OrdPg_PhotographyAssistant.ToString().TrimEnd(','))) { Amount += (Pay_AmountOf * (DeputyPhotography / 100)) / OrdPg_PhotographyAssistant_O.Length; } else { Amount += Pay_AmountOf / OrdPg_PhotographyAssistant_O.Length; } } } } this.dgv.Rows[i].Cells["Column3"].Value = Convert.ToDecimal(Amount).ToString("N2"); #endregion } else { #region 2.如果等级不相同 decimal Amount = 0; decimal Amount_A = 0; decimal Onej = 0;//一级景点工资 decimal Twoj = 0; //二级景点工资 decimal Threej = 0; //三级景点工资 //获取景点等级总百分比 decimal AttractionsPercentage = (OneLevelCount * OneLevel) + (TwoLevelCount * TwoLevel) + (ThreeLevelCount * ThreeLevel); if (AttractionsPercentage != 0) { Onej = Pay_AmountOf / AttractionsPercentage * OneLevel; Twoj = Pay_AmountOf / AttractionsPercentage * TwoLevel; Threej = Pay_AmountOf / AttractionsPercentage * ThreeLevel; } if (!string.IsNullOrEmpty(OrdPg_Photographer.ToString().TrimEnd(','))) { #region 主等于副 if (OrdPg_Photographer.ToString().TrimEnd(',') == OrdPg_PhotographyAssistant.ToString().TrimEnd(',')) { if (Post.ToString() == "主摄影师" || Post.ToString() == "主摄影选片二销") { Amount = (Pay_AmountOf * (MainPhotography / 100)); } if (Post.ToString() == "摄影助理" || Post.ToString() == "摄影助理选片二销") { Amount = (Pay_AmountOf * (DeputyPhotography / 100)); } } #endregion #region 副为空 if (string.IsNullOrEmpty(OrdPg_PhotographyAssistant.ToString().TrimEnd(','))) { //按照景点等级比重 if (Post.ToString() == "主摄影师" || Post.ToString() == "主摄影选片二销") { //获取摄影人员 DataRow[] dtRow = null; if (Ord_Type.ToString() != "1") { dtRow = dt_Sights.Select("Ordpg_Number='" + Ord_Number + "' and Ordpg_Photographer = '" + EmployeeName + "'"); } else { dtRow = dt_Sights.Select("Ordpg_ViceNumber='" + DeputyOrd_Number + "' and Ordpg_Photographer = '" + EmployeeName + "'"); } if (dtRow != null) { for (int y = 0; y < dtRow.Length; y++) { OrdPg_SightsLevel = dtRow[y]["OrdPg_SightsLevel"].ToString(); //一级 if (OrdPg_SightsLevel == "BEBBBCADDEBFJDFFC") { Amount += Onej; } //二级 if (OrdPg_SightsLevel == "BEBBBCADEGBGAFFJC") { Amount += Twoj; } //三级 if (OrdPg_SightsLevel == "BEBBBCADAFBHBCHCI") { Amount += Threej; } } } } } #endregion #region 主副不为空并且不相等 if ((!string.IsNullOrEmpty(OrdPg_Photographer.ToString().TrimEnd(',')) && !string.IsNullOrEmpty(OrdPg_PhotographyAssistant.ToString().TrimEnd(','))) && OrdPg_Photographer.ToString().TrimEnd(',') != OrdPg_PhotographyAssistant.ToString().TrimEnd(',')) { #region 主 if (Post.ToString() == "主摄影师" || Post.ToString() == "主摄影选片二销") { //获取摄影人员 DataRow[] dtRow = null; if (Ord_Type.ToString() != "1") { dtRow = dt_Sights.Select("Ordpg_Number='" + Ord_Number + "' and Ordpg_Photographer = '" + EmployeeName + "'"); } else { dtRow = dt_Sights.Select("Ordpg_ViceNumber='" + DeputyOrd_Number + "' and Ordpg_Photographer = '" + EmployeeName + "'"); } if (dtRow != null) { Amount_A = Pay_AmountOf * (MainPhotography / 100); for (int y = 0; y < dtRow.Length; y++) { OrdPg_SightsLevel = dtRow[y]["OrdPg_SightsLevel"].ToString(); if (AttractionsPercentage != 0) { //一级 if (OrdPg_SightsLevel == "BEBBBCADDEBFJDFFC") { Amount += Amount_A / AttractionsPercentage * OneLevel; } //二级 if (OrdPg_SightsLevel == "BEBBBCADEGBGAFFJC") { Amount += Amount_A / AttractionsPercentage * TwoLevel; } //三级 if (OrdPg_SightsLevel == "BEBBBCADAFBHBCHCI") { Amount += Amount_A / AttractionsPercentage * ThreeLevel; } } } } } #endregion #region 副 if (Post.ToString() == "摄影助理" || Post.ToString() == "摄影助理选片二销") { //获取摄影人员 DataRow[] dtRow = null; if (Ord_Type.ToString() != "1") { dtRow = dt_Sights.Select("Ordpg_Number='" + Ord_Number + "' and Ordpg_PhotographyAssistant = '" + EmployeeName + "'"); } else { dtRow = dt_Sights.Select("Ordpg_ViceNumber='" + DeputyOrd_Number + "' and Ordpg_PhotographyAssistant = '" + EmployeeName + "'"); } if (dtRow != null) { Amount_A = Pay_AmountOf * (DeputyPhotography / 100); for (int y = 0; y < dtRow.Length; y++) { OrdPg_SightsLevel = dtRow[y]["OrdPg_SightsLevel"].ToString(); if (AttractionsPercentage != 0) { //一级 if (OrdPg_SightsLevel == "BEBBBCADDEBFJDFFC") { Amount += Amount_A / AttractionsPercentage * OneLevel; } //二级 if (OrdPg_SightsLevel == "BEBBBCADEGBGAFFJC") { Amount += Amount_A / AttractionsPercentage * TwoLevel; } //三级 if (OrdPg_SightsLevel == "BEBBBCADAFBHBCHCI") { Amount += Amount_A / AttractionsPercentage * ThreeLevel; } } } } } #endregion } #endregion } this.dgv.Rows[i].Cells["Column3"].Value = Convert.ToDecimal(Amount).ToString("N2"); #endregion } } #endregion #region 化妆工资 if (Post.ToString() == "主化妆师" || Post.ToString() == "化妆助理" || Post.ToString() == "主化妆选片二销" || Post.ToString() == "化妆助理选片二销") { //修改前 if ((OneLevelCount >= 1 && TwoLevelCount == 0 && ThreeLevelCount == 0) || (OneLevelCount == 0 && TwoLevelCount >= 1 && ThreeLevelCount == 0) || (OneLevelCount == 0 && TwoLevelCount == 0 && ThreeLevelCount >= 1)) //刘工修改 if ((OneLevelCount + TwoLevelCount + ThreeLevelCount) == 1) { #region 1.如果所以景点阶段都相同 decimal Amount = 0; if (Post.ToString() == "主化妆师" || Post.ToString() == "主化妆选片二销") { OrdPg_MakeupArtist = OrdPg_MakeupArtist.TrimEnd(','); string[] OrdPg_MakeupArtist_O = OrdPg_MakeupArtist.Split(','); for (int t = 0; t < OrdPg_MakeupArtist_O.Length; t++) { if (OrdPg_MakeupArtist_O[t] == EmployeeName) { if (!string.IsNullOrEmpty(OrdPg_MakeupArtist.ToString().TrimEnd(',')) && !string.IsNullOrEmpty(OrdPg_MakeupAssistant.ToString().TrimEnd(','))) { Amount += (Pay_AmountOf * (MainMake / 100)) / OrdPg_MakeupArtist_O.Length; } else { Amount += Pay_AmountOf / OrdPg_MakeupArtist_O.Length; } } } } if (Post.ToString() == "化妆助理" || Post.ToString() == "化妆助理选片二销") { OrdPg_MakeupAssistant = OrdPg_MakeupAssistant.TrimEnd(','); string[] OrdPg_MakeupAssistant_O = OrdPg_MakeupAssistant.Split(','); for (int t = 0; t < OrdPg_MakeupAssistant_O.Length; t++) { if (OrdPg_MakeupAssistant_O[t] == EmployeeName) { if (!string.IsNullOrEmpty(OrdPg_MakeupArtist.ToString().TrimEnd(',')) && !string.IsNullOrEmpty(OrdPg_MakeupAssistant.ToString().TrimEnd(','))) { Amount += (Pay_AmountOf * (DeputyMake / 100)) / OrdPg_MakeupAssistant_O.Length; } else { Amount += Pay_AmountOf / OrdPg_MakeupAssistant_O.Length; } } } } this.dgv.Rows[i].Cells["Column3"].Value = Convert.ToDecimal(Amount).ToString("N2"); #endregion } else { #region 2.如果等级不相同 decimal Amount = 0; decimal Amount_A = 0; decimal Onej = 0;//一级景点工资 decimal Twoj = 0; //二级景点工资 decimal Threej = 0; //三级景点工资 //获取景点等级总百分比 decimal AttractionsPercentage = (OneLevelCount * OneLevel) + (TwoLevelCount * TwoLevel) + (ThreeLevelCount * ThreeLevel); if (AttractionsPercentage != 0) { Onej = Pay_AmountOf / AttractionsPercentage * OneLevel; Twoj = Pay_AmountOf / AttractionsPercentage * TwoLevel; Threej = Pay_AmountOf / AttractionsPercentage * ThreeLevel; } if (!string.IsNullOrEmpty(OrdPg_MakeupArtist.ToString().TrimEnd(','))) { #region 主等于副 if (OrdPg_MakeupArtist.ToString().TrimEnd(',') == OrdPg_MakeupAssistant.ToString().TrimEnd(',')) { if (Post.ToString() == "主化妆师" || Post.ToString() == "主化妆选片二销") { Amount = (Pay_AmountOf * (MainMake / 100)); } if (Post.ToString() == "化妆助理" || Post.ToString() == "化妆助理选片二销") { Amount = (Pay_AmountOf * (DeputyMake / 100)); } } #endregion #region 副为空 if (string.IsNullOrEmpty(OrdPg_MakeupAssistant.ToString().TrimEnd(','))) { //按照景点等级比重 if (Post.ToString() == "主化妆师" || Post.ToString() == "主化妆选片二销") { //获取化妆人员 DataRow[] dtRow = null; if (Ord_Type.ToString() != "1") { dtRow = dt_Sights.Select("Ordpg_Number='" + Ord_Number + "' and Ordpg_MakeupArtist = '" + EmployeeName + "'"); } else { dtRow = dt_Sights.Select("Ordpg_ViceNumber='" + DeputyOrd_Number + "' and Ordpg_MakeupArtist = '" + EmployeeName + "'"); } if (dtRow != null) { for (int y = 0; y < dtRow.Length; y++) { OrdPg_SightsLevel = dtRow[y]["OrdPg_SightsLevel"].ToString(); //一级 if (OrdPg_SightsLevel == "BEBBBCADDEBFJDFFC") { Amount += Onej; } //二级 if (OrdPg_SightsLevel == "BEBBBCADEGBGAFFJC") { Amount += Twoj; } //三级 if (OrdPg_SightsLevel == "BEBBBCADAFBHBCHCI") { Amount += Threej; } } } } } #endregion #region 主副不为空并且不相等 if ((!string.IsNullOrEmpty(OrdPg_MakeupArtist.ToString().TrimEnd(',')) && !string.IsNullOrEmpty(OrdPg_MakeupAssistant.ToString().TrimEnd(','))) && OrdPg_MakeupArtist.ToString().TrimEnd(',') != OrdPg_MakeupAssistant.ToString().TrimEnd(',')) { #region 主 if (Post.ToString() == "主化妆师" || Post.ToString() == "主化妆选片二销") { //获取摄影人员 DataRow[] dtRow = null; if (Ord_Type.ToString() != "1") { dtRow = dt_Sights.Select("Ordpg_Number='" + Ord_Number + "' and Ordpg_MakeupArtist = '" + EmployeeName + "'"); } else { dtRow = dt_Sights.Select("Ordpg_ViceNumber='" + DeputyOrd_Number + "' and Ordpg_MakeupArtist = '" + EmployeeName + "'"); } if (dtRow != null) { Amount_A = Pay_AmountOf * (MainMake / 100); for (int y = 0; y < dtRow.Length; y++) { OrdPg_SightsLevel = dtRow[y]["OrdPg_SightsLevel"].ToString(); if (AttractionsPercentage != 0) { //一级 if (OrdPg_SightsLevel == "BEBBBCADDEBFJDFFC") { Amount += Amount_A / AttractionsPercentage * OneLevel; } //二级 if (OrdPg_SightsLevel == "BEBBBCADEGBGAFFJC") { Amount += Amount_A / AttractionsPercentage * TwoLevel; } //三级 if (OrdPg_SightsLevel == "BEBBBCADAFBHBCHCI") { Amount += Amount_A / AttractionsPercentage * ThreeLevel; } } } } } #endregion #region 副 if (Post.ToString() == "化妆助理" || Post.ToString() == "化妆助理选片二销") { //获取摄影人员 DataRow[] dtRow = null; if (Ord_Type.ToString() != "1") { dtRow = dt_Sights.Select("Ordpg_Number='" + Ord_Number + "' and Ordpg_MakeupAssistant = '" + EmployeeName + "'"); } else { dtRow = dt_Sights.Select("Ordpg_ViceNumber='" + DeputyOrd_Number + "' and Ordpg_MakeupAssistant = '" + EmployeeName + "'"); } if (dtRow != null) { Amount_A = Pay_AmountOf * (DeputyMake / 100); for (int y = 0; y < dtRow.Length; y++) { OrdPg_SightsLevel = dtRow[y]["OrdPg_SightsLevel"].ToString(); if (AttractionsPercentage != 0) { //一级 if (OrdPg_SightsLevel == "BEBBBCADDEBFJDFFC") { Amount += Amount_A / AttractionsPercentage * OneLevel; } //二级 if (OrdPg_SightsLevel == "BEBBBCADEGBGAFFJC") { Amount += Amount_A / AttractionsPercentage * TwoLevel; } //三级 if (OrdPg_SightsLevel == "BEBBBCADAFBHBCHCI") { Amount += Amount_A / AttractionsPercentage * ThreeLevel; } } } } } #endregion } #endregion } this.dgv.Rows[i].Cells["Column3"].Value = Convert.ToDecimal(Amount).ToString("N2"); #endregion } } #endregion #region 引导工资 if (Post.ToString() == "引导师" || Post.ToString() == "引导助理" || Post.ToString() == "引导选片二销" || Post.ToString() == "引导助理选片二销") { //修改前 if ((OneLevelCount >= 1 && TwoLevelCount == 0 && ThreeLevelCount == 0) || (OneLevelCount == 0 && TwoLevelCount >= 1 && ThreeLevelCount == 0) || (OneLevelCount == 0 && TwoLevelCount == 0 && ThreeLevelCount >= 1)) //刘工修改 if ((OneLevelCount + TwoLevelCount + ThreeLevelCount) == 1) { #region 1.如果所以景点阶段都相同 decimal Amount = 0; if (Post.ToString() == "引导师" || Post.ToString() == "引导选片二销") { Ordpg_BootDivision = Ordpg_BootDivision.TrimEnd(','); string[] OrdPg_MakeupArtist_O = Ordpg_BootDivision.Split(','); for (int t = 0; t < OrdPg_MakeupArtist_O.Length; t++) { if (OrdPg_MakeupArtist_O[t] == EmployeeName) { if (!string.IsNullOrEmpty(Ordpg_BootDivision.ToString().TrimEnd(',')) && !string.IsNullOrEmpty(Ordpg_BootDivisionAssistant.ToString().TrimEnd(','))) { Amount += (Pay_AmountOf * (MainBootDivision / 100)) / OrdPg_MakeupArtist_O.Length; } else { Amount += Pay_AmountOf / OrdPg_MakeupArtist_O.Length; } } } } if (Post.ToString() == "引导助理" || Post.ToString() == "引导助理选片二销") { Ordpg_BootDivisionAssistant = Ordpg_BootDivisionAssistant.TrimEnd(','); string[] OrdPg_MakeupAssistant_O = Ordpg_BootDivisionAssistant.Split(','); for (int t = 0; t < OrdPg_MakeupAssistant_O.Length; t++) { if (OrdPg_MakeupAssistant_O[t] == EmployeeName) { if (!string.IsNullOrEmpty(Ordpg_BootDivision.ToString().TrimEnd(',')) && !string.IsNullOrEmpty(Ordpg_BootDivisionAssistant.ToString().TrimEnd(','))) { Amount += (Pay_AmountOf * (DeputyBootDivision / 100)) / OrdPg_MakeupAssistant_O.Length; } else { Amount += Pay_AmountOf / OrdPg_MakeupAssistant_O.Length; } } } } this.dgv.Rows[i].Cells["Column3"].Value = Convert.ToDecimal(Amount).ToString("N2"); #endregion } else { #region 2.如果等级不相同 decimal Amount = 0; decimal Amount_A = 0; decimal Onej = 0;//一级景点工资 decimal Twoj = 0; //二级景点工资 decimal Threej = 0; //三级景点工资 //获取景点等级总百分比 decimal AttractionsPercentage = (OneLevelCount * OneLevel) + (TwoLevelCount * TwoLevel) + (ThreeLevelCount * ThreeLevel); if (AttractionsPercentage != 0) { Onej = Pay_AmountOf / AttractionsPercentage * OneLevel; Twoj = Pay_AmountOf / AttractionsPercentage * TwoLevel; Threej = Pay_AmountOf / AttractionsPercentage * ThreeLevel; } if (!string.IsNullOrEmpty(Ordpg_BootDivision.ToString().TrimEnd(','))) { #region 主等于副 if (Ordpg_BootDivision.ToString().TrimEnd(',') == Ordpg_BootDivisionAssistant.ToString().TrimEnd(',')) { if (Post.ToString() == "引导师" || Post.ToString() == "引导选片二销") { Amount = (Pay_AmountOf * (MainBootDivision / 100)); } if (Post.ToString() == "引导助理" || Post.ToString() == "引导助理选片二销") { Amount = (Pay_AmountOf * (DeputyBootDivision / 100)); } } #endregion #region 副为空 if (string.IsNullOrEmpty(Ordpg_BootDivisionAssistant.ToString().TrimEnd(','))) { //按照景点等级比重 if (Post.ToString() == "引导师" || Post.ToString() == "引导选片二销") { //获取化妆人员 DataRow[] dtRow = null; if (Ord_Type.ToString() != "1") { dtRow = dt_Sights.Select("Ordpg_Number='" + Ord_Number + "' and Ordpg_BootDivision = '" + EmployeeName + "'"); } else { dtRow = dt_Sights.Select("Ordpg_ViceNumber='" + DeputyOrd_Number + "' and Ordpg_BootDivision = '" + EmployeeName + "'"); } if (dtRow != null) { for (int y = 0; y < dtRow.Length; y++) { OrdPg_SightsLevel = dtRow[y]["OrdPg_SightsLevel"].ToString(); //一级 if (OrdPg_SightsLevel == "BEBBBCADDEBFJDFFC") { Amount += Onej; } //二级 if (OrdPg_SightsLevel == "BEBBBCADEGBGAFFJC") { Amount += Twoj; } //三级 if (OrdPg_SightsLevel == "BEBBBCADAFBHBCHCI") { Amount += Threej; } } } } } #endregion #region 主副不为空并且不相等 if ((!string.IsNullOrEmpty(Ordpg_BootDivision.ToString().TrimEnd(',')) && !string.IsNullOrEmpty(Ordpg_BootDivisionAssistant.ToString().TrimEnd(','))) && Ordpg_BootDivision.ToString().TrimEnd(',') != Ordpg_BootDivisionAssistant.ToString().TrimEnd(',')) { #region 主 if (Post.ToString() == "引导师" || Post.ToString() == "引导选片二销") { //获取摄影人员 DataRow[] dtRow = null; if (Ord_Type.ToString() != "1") { dtRow = dt_Sights.Select("Ordpg_Number='" + Ord_Number + "' and Ordpg_BootDivision = '" + EmployeeName + "'"); } else { dtRow = dt_Sights.Select("Ordpg_ViceNumber='" + DeputyOrd_Number + "' and Ordpg_BootDivision = '" + EmployeeName + "'"); } if (dtRow != null) { Amount_A = Pay_AmountOf * (MainBootDivision / 100); for (int y = 0; y < dtRow.Length; y++) { OrdPg_SightsLevel = dtRow[y]["OrdPg_SightsLevel"].ToString(); if (AttractionsPercentage != 0) { //一级 if (OrdPg_SightsLevel == "BEBBBCADDEBFJDFFC") { Amount += Amount_A / AttractionsPercentage * OneLevel; } //二级 if (OrdPg_SightsLevel == "BEBBBCADEGBGAFFJC") { Amount += Amount_A / AttractionsPercentage * TwoLevel; } //三级 if (OrdPg_SightsLevel == "BEBBBCADAFBHBCHCI") { Amount += Amount_A / AttractionsPercentage * ThreeLevel; } } } } } #endregion #region 副 if (Post.ToString() == "引导助理" || Post.ToString() == "引导助理选片二销") { //获取摄影人员 DataRow[] dtRow = null; if (Ord_Type.ToString() != "1") { dtRow = dt_Sights.Select("Ordpg_Number='" + Ord_Number + "' and Ordpg_BootDivisionAssistant = '" + EmployeeName + "'"); } else { dtRow = dt_Sights.Select("Ordpg_ViceNumber='" + DeputyOrd_Number + "' and Ordpg_BootDivisionAssistant = '" + EmployeeName + "'"); } if (dtRow != null) { Amount_A = Pay_AmountOf * (DeputyBootDivision / 100); for (int y = 0; y < dtRow.Length; y++) { OrdPg_SightsLevel = dtRow[y]["OrdPg_SightsLevel"].ToString(); if (AttractionsPercentage != 0) { //一级 if (OrdPg_SightsLevel == "BEBBBCADDEBFJDFFC") { Amount += Amount_A / AttractionsPercentage * OneLevel; } //二级 if (OrdPg_SightsLevel == "BEBBBCADEGBGAFFJC") { Amount += Amount_A / AttractionsPercentage * TwoLevel; } //三级 if (OrdPg_SightsLevel == "BEBBBCADAFBHBCHCI") { Amount += Amount_A / AttractionsPercentage * ThreeLevel; } } } } } #endregion } #endregion } this.dgv.Rows[i].Cells["Column3"].Value = Convert.ToDecimal(Amount).ToString("N2"); #endregion } } #endregion #endregion } } } #endregion #region 计件提成 object ItemName = this.dgv.Rows[i].Cells["Column5"].Value; if (ItemName != null) { if (ItemName.ToString().Trim() == "/计件提成") { PieceCommission += Convert.ToDecimal(this.dgv.Rows[i].Cells["Column3"].Value); } else { CurrentPerformance += Convert.ToDecimal(this.dgv.Rows[i].Cells["Column3"].Value); } } #endregion } //当前业绩 Sum = Convert.ToDecimal(CurrentPerformance); // 计件提成 this.txtPieceCommission.Text = Convert.ToDecimal(PieceCommission).ToString("N2"); } else { this.txtCurrentPerformance.Text = "0.00"; this.txtPieceCommission.Text = "0.00"; } })); #endregion return Sum; } ///

/// 绑定业绩列表查询方法1（全部收款记录） ///

/// /// public string BindSelect1(ref bool IsQuery) { StringBuilder str = new StringBuilder(); if (!string.IsNullOrEmpty(Str_CustomerSource.Trim()) && Str_CustomerSourceTag != null) { str.Append(" and 客户来源='" + Str_CustomerSource.Trim() + "'"); } if (!string.IsNullOrEmpty(Str_PakName.Trim()) && Str_PakNameTag != null) { str.Append(" and 订单类别='" + Str_PakName.Trim() + "'"); } if (this.Str_ProjectTitle.Trim() != "选片二销") { if (!string.IsNullOrEmpty(this.Str_AmountRange1.Trim())) { str.Append(" and (应收金额>=" + this.Str_AmountRange1.Trim() + " and 应收金额<=" + this.Str_AmountRange2.Trim() + ")"); } } // 订单前期 if (this.Str_ItemCategory.Trim() == "订单前期") { if (!string.IsNullOrEmpty(this.Str_ProjectTitle.Trim())) { if (this.Str_ProjectTitle.Trim() == "实收") { str.Append(" and 收款类别 <> '后期收款'"); } if (this.Str_ProjectTitle.Trim() == "全款") { str.Append(" and 应收金额 = 前期实收金额"); } } str.Append(" and 收款类别 <> '后期收款'"); } // 订单后期 if (this.Str_ItemCategory.Trim() == "订单后期") { if (!string.IsNullOrEmpty(this.Str_ProjectTitle.Trim())) { if (!string.IsNullOrEmpty(this.Str_AmountRange1.Trim())) { if (this.Str_ProjectTitle.Trim() == "选片二销") { str.Append(" and (收款金额>=" + this.Str_AmountRange1.Trim() + " and 收款金额<=" + this.Str_AmountRange2.Trim() + ")"); } } str.Append(" and 二销类别编号='" + this.Str_ProjectTitleTag.ToString().Trim() + "'"); } str.Append(" and 收款类别='后期收款' and 收款类型=0"); } // 其它消费 if (this.Str_ItemCategory.Trim() == "其它消费") { if (!string.IsNullOrEmpty(this.Str_ProjectTitle.Trim())) { str.Append(" and 二销类别编号='" + this.Str_ProjectTitleTag.ToString().Trim() + "'"); } str.Append(" and 收款类型=1"); } if (this.Str_ItemCategory.Trim() == "礼服租售") { str.Append(" and 收款类型 = '2' "); } // 其它 //if (this.Str_ItemCategory.Trim() == "会员充值") //{ str.Append(" and id=-3"); } //if (this.Str_ItemCategory.Trim() == "服务卡充值") //{ str.Append(" and id=-3"); } //if (this.Str_ItemCategory.Trim() == "礼服租售") //{ str.Append(" and id=-3"); } //if (this.Str_ItemCategory.Trim() == "计件提成") //{ str.Append(" and id=-3"); } switch (this.Str_ItemCategory.Trim()) { case "会员充值": case "服务卡充值": //case "礼服租售": case "计件提成": IsQuery = false; break; default: IsQuery = true; break; } return str.ToString(); } ///

/// 绑定业绩列表查询方法2 ///

/// /// public string BindSelect2(ref bool IsQuery) { if (!string.IsNullOrEmpty(this.Str_CustomerSource.Trim()) || (!string.IsNullOrEmpty(this.Str_PakName.Trim()) && this.Str_PakNameTag != null) || !string.IsNullOrEmpty(this.Str_ProcessStatus.Trim()) || (!string.IsNullOrEmpty(this.Str_ItemCategory.Trim()) && this.Str_ItemCategory.Trim() != "会员充值")) { IsQuery = false; } else { IsQuery = true; } StringBuilder str = new StringBuilder(); if (!string.IsNullOrEmpty(this.Str_AmountRange1.Trim())) { str.Append(" and 充值金额 >= " + this.Str_AmountRange1.Trim() + " and 充值金额 <= " + this.Str_AmountRange2.Trim() + ""); } return str.ToString(); //StringBuilder str = new StringBuilder(); //if (!string.IsNullOrEmpty(this.Str_CustomerSource.Trim())) //{ str.Append(" and id = -3"); } //if (!string.IsNullOrEmpty(this.Str_PakName.Trim()) && this.Str_PakNameTag != null) //{ str.Append(" and id = -3"); } //if (!string.IsNullOrEmpty(this.Str_AmountRange1.Trim())) //{ str.Append(" and 充值金额 >= " + this.Str_AmountRange1.Trim() + " and 充值金额 <= " + this.Str_AmountRange2.Trim() + ""); } //if (!string.IsNullOrEmpty(this.Str_ProcessStatus.Trim())) //{ str.Append(" and id = -3"); } //// 会员充值 //if (!string.IsNullOrEmpty(this.Str_ItemCategory.Trim())) //{ // if (this.Str_ItemCategory.Trim() != "会员充值") // { str.Append("and id = -3"); } //} //return str.ToString(); } ///

/// 绑定业绩列表查询方法3（服务卡） ///

/// /// public string BindSelect3(ref bool IsQuery) { if (!string.IsNullOrEmpty(this.Str_CustomerSource.Trim()) || (!string.IsNullOrEmpty(this.Str_PakName.Trim()) && this.Str_PakNameTag != null) || !string.IsNullOrEmpty(this.Str_ProcessStatus.Trim()) || (!string.IsNullOrEmpty(this.Str_ItemCategory.Trim()) && this.Str_ItemCategory.Trim() != "服务卡充值")) { IsQuery = false; } else { IsQuery = true; } StringBuilder str = new StringBuilder(); if (!string.IsNullOrEmpty(this.Str_AmountRange1.Trim())) { str.Append(" and 收款金额 >= " + this.Str_AmountRange1.Trim() + " and 收款金额 <= " + this.Str_AmountRange2.Trim() + ""); } return str.ToString(); //StringBuilder str = new StringBuilder(); //if (!string.IsNullOrEmpty(cmbCustomerSource.Text.Trim())) //{ str.Append(" and id=-3"); } //if (!string.IsNullOrEmpty(CtvPak_Name.Text.Trim()) && CtvPak_Name.Tag != null) //{ str.Append(" and id=-3"); } //if (!string.IsNullOrEmpty(txtAmountRange1.Text)) //{ str.Append(" and 收款金额>=" + txtAmountRange1.Text.Trim() + " and 收款金额<=" + txtAmountRange2.Text.Trim() + ""); } //if (!string.IsNullOrEmpty(cmbProcessStatus.Text.Trim())) //{ str.Append(" and id=-3"); } //// 会员充值 //if (!string.IsNullOrEmpty(cmbItemCategory.Text.Trim())) //{ // if (cmbItemCategory.Text.Trim() != "服务卡充值") // { str.Append("and id=-3"); } //} //return str.ToString(); } ///

/// 绑定业绩列表查询方法4（计件） ///

/// /// public string BindSelect4(ref bool IsQuery) { if (!string.IsNullOrEmpty(this.Str_CustomerSource.Trim()) || !string.IsNullOrEmpty(this.Str_ProcessStatus.Trim()) || (!string.IsNullOrEmpty(this.Str_ItemCategory.Trim()) && this.Str_ItemCategory.Trim() != "计件提成")) { IsQuery = false; } else { IsQuery = true; } StringBuilder str = new StringBuilder(); if (!string.IsNullOrEmpty(this.Str_PakName.Trim()) && this.Str_PakNameTag != null) { str.Append(" and Ord_SeriesName = '" + this.Str_PakName.Trim() + "'"); } if (!string.IsNullOrEmpty(this.Str_AmountRange1.Trim())) { str.Append(" and 总价格 >= " + this.Str_AmountRange1.Trim() + " and 总价格 <= " + this.Str_AmountRange2.Trim() + ""); } // 计件 if (!string.IsNullOrEmpty(this.Str_ItemCategory.Trim())) { if (this.Str_ItemCategory.Trim() == "计件提成") { if (!string.IsNullOrEmpty(this.Str_ProjectTitle.Trim())) { str.Append(" and Pcr_CompletionContents = '" + this.Str_ProjectTitleTag + "'"); } } } return str.ToString(); //StringBuilder str = new StringBuilder(); //if (!string.IsNullOrEmpty(cmbCustomerSource.Text.Trim())) //{ str.Append(" and id=-3"); } //if (!string.IsNullOrEmpty(CtvPak_Name.Text.Trim()) && CtvPak_Name.Tag != null) //{ str.Append(" and Ord_SeriesName='" + CtvPak_Name.Text.Trim() + "'"); } //if (!string.IsNullOrEmpty(txtAmountRange1.Text)) //{ str.Append(" and 总价格>=" + txtAmountRange1.Text.Trim() + " and 总价格<=" + txtAmountRange2.Text.Trim() + ""); } //if (!string.IsNullOrEmpty(cmbProcessStatus.Text.Trim())) //{ str.Append(" and id=-3"); } //// 计件 //if (!string.IsNullOrEmpty(cmbItemCategory.Text.Trim())) //{ // if (cmbItemCategory.Text.Trim() == "计件提成") // { // if (!string.IsNullOrEmpty(cmbProjectTitle.Text.Trim())) // { str.Append(" and Pcr_CompletionContents='" + cmbProjectTitle.Tag + "'"); } // } // else // { str.Append("and id=-3"); } //} //return str.ToString(); } ///

/// 绑定业绩列表查询方法5（拍照） ///

/// public string BindSelect5() { StringBuilder str = new StringBuilder(); if (!string.IsNullOrEmpty(this.Str_CustomerSource.Trim()) && this.Str_CustomerSourceTag != null) { str.Append(" and 客户来源 = '" + this.Str_CustomerSource.Trim() + "'"); } if (!string.IsNullOrEmpty(this.Str_PakName.Trim()) && this.Str_PakNameTag != null) { str.Append(" and 订单类别 = '" + this.Str_PakName.Trim() + "'"); } if (!string.IsNullOrEmpty(this.Str_AmountRange1.Trim())) { str.Append(" and 应收金额 >= " + this.Str_AmountRange1.Trim() + " and 应收金额 <= " + this.Str_AmountRange2.Trim() + ""); } return str.ToString(); } ///

/// 统计业绩 ///

public void TotalPerformance() { DataTable dt = new DataTable(); this.dgvAll.Rows.Clear(); string StrWhere = ""; if (this.cmbEmployeeName.StrGetName.ToString() == "Department") { StrWhere = " And User_Department = '" + this.cmbEmployeeName.Tag.ToString().Trim() + "'"; } else if (this.cmbEmployeeName.StrGetName.ToString() == "StoreName") { StrWhere = " And User_DividedShop = '" + this.cmbEmployeeName.Tag.ToString().Trim() + "'"; } string StrTimeStart = this.txtTimeStart.DateValue.ToString().Trim(); string StrTimeEnd = this.txtTimeEnd.DateValue.ToString().Trim(); LYFZ.ComponentLibrary.FrmLoadHandling.LoadDoWorkMethod(delegate(object obj, BackgroundWorker backgroundWorker) { dt = orbll.GetView_Custom("tb_ErpUser", StrWhere: "User_Status='在职'" + StrWhere, ShowColumnName: "User_Name,User_EmployeeID").Tables[0]; for (int t = 0; t < dt.Rows.Count; t++) { DataGridViewRow dgvr = new DataGridViewRow(); DataGridViewCell cell = null; //员工编号 cell = new DataGridViewTextBoxCell(); cell.Value = dt.Rows[t]["User_EmployeeID"].ToString().Trim(); dgvr.Cells.Add(cell); //员工姓名 cell = new DataGridViewTextBoxCell(); cell.Value = dt.Rows[t]["User_Name"].ToString().Trim(); dgvr.Cells.Add(cell); //当前业绩 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(BindPerformance(StrTimeStart, StrTimeEnd, dt.Rows[t]["User_EmployeeID"].ToString().Trim(), backgroundWorker)).ToString(); dgvr.Cells.Add(cell); this.Invoke(new UpdateControl(delegate() { this.dgvAll.Rows.Add(dgvr); })); } }); } ///

/// 获取业绩个数 ///

/// /// /// /// public string GetNumberOfResults(string Ord_OrdersPersonID, string StartTime, string EndTime) { //DataTable dt = new DataTable(); //int OrderCount = 0; //int PhotographyCount = 0; //int PhotographyAssistantCount = 0; //int MakeUpCount = 0; //int MakeUpAssistantCount = 0; //int GuideCount = 0; //int FirstRepairCount = 0; //int RefinementCount = 0; //int DesignCount = 0; Hashtable htDataOrder = new Hashtable(); Hashtable htDataPhotography = new Hashtable(); Hashtable htDataPhotographyAssistant = new Hashtable(); Hashtable htDataMakeUp = new Hashtable(); Hashtable htDataMakeUpAssistant = new Hashtable(); Hashtable htDataGuide = new Hashtable(); Hashtable htDataGuideAssistant = new Hashtable(); Hashtable htDataFirstRepair = new Hashtable(); Hashtable htDataRefinement = new Hashtable(); Hashtable htDataDesign = new Hashtable(); #region 获取订单数 //dt = orbll.GetView_Custom("Vw_Customer_PaymentOrders", StrWhere: "Ord_OrdersPersonID like '%" + Ord_OrdersPersonID + "%' and Ord_Class=1 and Ord_CreateDatetime>='" + StartTime + "' and Ord_CreateDatetime<='" + EndTime + "' ", ShowColumnName: "ID").Tables[0]; //if (dt.Rows.Count > 0) //{ OrderCount = dt.Rows.Count; } this.Invoke(new UpdateControl(delegate() { for (int i = 0; i < this.dgv.Rows.Count; i++) { if (this.dgv.Rows[i].Cells["Column18"].Value != null && !string.IsNullOrEmpty(this.dgv.Rows[i].Cells["Column18"].Value.ToString().Trim())) { string StrKeys = this.dgv.Rows[i].Cells["Column1"].Value.ToString().Trim() + this.dgv.Rows[i].Cells["Column17"].Value.ToString().Trim(); switch (this.dgv.Rows[i].Cells["Column17"].Value.ToString().Trim()) { case "主接单人": case "副接单人": case "门市选片二销": if (!htDataOrder.ContainsKey(StrKeys)) { htDataOrder[StrKeys] = 1; } break; case "主摄影师": case "主摄影选片二销": if (!htDataPhotography.ContainsKey(StrKeys)) { htDataPhotography[StrKeys] = 1; } break; case "摄影助理": case "摄影助理选片二销": if (!htDataPhotographyAssistant.ContainsKey(StrKeys)) { htDataPhotographyAssistant[StrKeys] = 1; } break; case "主化妆师": case "主化妆选片二销": if (!htDataMakeUp.ContainsKey(StrKeys)) { htDataMakeUp[StrKeys] = 1; } break; case "化妆助理": case "化妆助理选片二销": if (!htDataMakeUpAssistant.ContainsKey(StrKeys)) { htDataMakeUpAssistant[StrKeys] = 1; } break; case "引导师": case "引导选片二销": if (!htDataGuide.ContainsKey(StrKeys)) { htDataGuide[StrKeys] = 1; } break; case "引导助理": case "引导助理选片二销": if (!htDataGuideAssistant.ContainsKey(StrKeys)) { htDataGuideAssistant[StrKeys] = 1; } break; case "初修师": case "初修师选片二销": if (!htDataFirstRepair.ContainsKey(StrKeys)) { htDataFirstRepair[StrKeys] = 1; } break; case "精修师": case "精修师选片二销": if (!htDataRefinement.ContainsKey(StrKeys)) { htDataRefinement[StrKeys] = 1; } break; case "设计师": case "设计师选片二销": if (!htDataDesign.ContainsKey(StrKeys)) { htDataDesign[StrKeys] = 1; } break; } } } })); #endregion #region 摄影师个数 //dt = new DataTable(); //dt = orbll.GetView_Custom("Vw_OrdersWagePhotography", StrWhere: "摄影师ID like '%" + Ord_OrdersPersonID + "%' and Ord_Class=1 and 拍摄状态=1 and 拍摄时间>='" + StartTime + "' and 拍摄时间<='" + EndTime + "' ", ShowColumnName: "ID").Tables[0]; //if (dt.Rows.Count > 0) //{ // PhotographyCount = dt.Rows.Count; //} #endregion #region 摄影助理个数 //dt = new DataTable(); //dt = orbll.GetView_Custom("Vw_OrdersWagePhotography", StrWhere: "摄影助理ID like '%" + Ord_OrdersPersonID + "%' and Ord_Class=1 and 拍摄状态=1 and 拍摄时间>='" + StartTime + "' and 拍摄时间<='" + EndTime + "' ", ShowColumnName: "ID").Tables[0]; //if (dt.Rows.Count > 0) //{ PhotographyAssistantCount = dt.Rows.Count; } #endregion #region 化妆师个数 //dt = new DataTable(); //dt = orbll.GetView_Custom("Vw_OrdersWagePhotography", StrWhere: "化妆师ID like '%" + Ord_OrdersPersonID + "%' and Ord_Class=1 and 拍摄状态=1 and 拍摄时间>='" + StartTime + "' and 拍摄时间<='" + EndTime + "' ", ShowColumnName: "ID").Tables[0]; //if (dt.Rows.Count > 0) //{ MakeUpCount = dt.Rows.Count; } #endregion #region 化妆助理个数 //dt = new DataTable(); //dt = orbll.GetView_Custom("Vw_OrdersWagePhotography", StrWhere: "化妆助理ID like '%" + Ord_OrdersPersonID + "%' and Ord_Class=1 and 拍摄状态=1 and 拍摄时间>='" + StartTime + "' and 拍摄时间<='" + EndTime + "' ", ShowColumnName: "ID").Tables[0]; //if (dt.Rows.Count > 0) //{ MakeUpAssistantCount = dt.Rows.Count; } #endregion #region 引导师个数 //dt = new DataTable(); //dt = orbll.GetView_Custom("Vw_OrdersWagePhotography", StrWhere: "引导师ID like '%" + Ord_OrdersPersonID + "%' and Ord_Class=1 and 拍摄状态=1 and 拍摄时间>='" + StartTime + "' and 拍摄时间<='" + EndTime + "' ", ShowColumnName: "ID").Tables[0]; //if (dt.Rows.Count > 0) //{ GuideCount = dt.Rows.Count; } #endregion #region 初修师个数 //dt = new DataTable(); //dt = orbll.GetView_Custom("Vw_OrdersWageDigital", StrWhere: "初修师ID like '%" + Ord_OrdersPersonID + "%' and Ord_Class=1 and 初修状态=2 and 初修时间>='" + StartTime + "' and 初修时间<='" + EndTime + "' ", ShowColumnName: "ID").Tables[0]; //if (dt.Rows.Count > 0) //{ FirstRepairCount = dt.Rows.Count; } #endregion #region 精修师个数 //dt = new DataTable(); //dt = orbll.GetView_Custom("Vw_OrdersWageDigital", StrWhere: "精修师ID like '%" + Ord_OrdersPersonID + "%' and Ord_Class=1 and 精修状态=2 and 精修时间>='" + StartTime + "' and 精修时间<='" + EndTime + "' ", ShowColumnName: "ID").Tables[0]; //if (dt.Rows.Count > 0) //{ RefinementCount = dt.Rows.Count; } #endregion #region 设计师个数 //dt = new DataTable(); //dt = orbll.GetView_Custom("Vw_OrdersWageDigital", StrWhere: "设计师ID like '%" + Ord_OrdersPersonID + "%' and Ord_Class=1 and 设计状态=2 and 设计时间>='" + StartTime + "' and 设计时间<='" + EndTime + "' ", ShowColumnName: "ID").Tables[0]; //if (dt.Rows.Count > 0) //{ RefinementCount = dt.Rows.Count; } #endregion string StrCountSum = "订单数：" + htDataOrder.Count + "；摄影景点数：" + htDataPhotography.Count + "；摄影助理景点数：" + htDataPhotographyAssistant.Count + "；化妆数：" + htDataMakeUp.Count + "；化妆助理数：" + htDataMakeUpAssistant.Count; StrCountSum += "；引导数：" + htDataGuide.Count + "；引导助理数：" + htDataGuideAssistant.Count + "；初修景点数：" + htDataFirstRepair.Count + "；精修景点数：" + htDataRefinement.Count + "；设计景点数：" + htDataDesign.Count; return StrCountSum; } string Str_ItemCategory = ""; string Str_ProcessStatus = ""; string Str_CustomerSource = ""; object Str_CustomerSourceTag = ""; string Str_ProjectTitle = ""; object Str_ProjectTitleTag = ""; string Str_PakName = ""; object Str_PakNameTag = ""; string Str_AmountRange1 = ""; string Str_AmountRange2 = ""; string Str_Scores1 = ""; string Str_Scores2 = ""; //======================================================================操作事件================================== ///

/// 选择人员姓名查询人员工资基本信息 ///

/// /// protected override void cmbEmployeeName_ComboBoxTree_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e) { if (this.cmbEmployeeName.Tag != null) { if (this.cmbEmployeeName.StrGetName.Trim() == "User") { this.dgvAll.Visible = false; this.dgv.Visible = true; DataTable dt = wsbll.GetList("Ws_StaffCode='" + this.cmbEmployeeName.Tag.ToString().Trim() + "'").Tables[0]; if (dt.Rows.Count > 0) { this.txtBasicwage.Text = dt.Rows[0]["Ws_BasicWage"].ToString(); this.txtPay_Remark.Text = dt.Rows[0]["Ws_Remark"].ToString(); } else { this.txtBasicwage.Text = "0"; this.txtPay_Remark.Text = ""; } } else if (string.IsNullOrEmpty(this.cmbEmployeeName.StrGetName.Trim()) || this.cmbEmployeeName.StrGetName.Trim() == "StoreName" || this.cmbEmployeeName.StrGetName.Trim() == "Department") { this.dgvAll.Visible = true; this.dgv.Visible = false; this.dgv.Rows.Clear(); this.txtBasicwage.Text = "0"; this.txtPay_Remark.Text = ""; this.txtCurrentPerformance.Text = "0"; this.cmbCommissionScheme.Text = ""; this.txtPieceCommission.Text = "0"; this.txtCommissionWages.Text = "0"; } } else { MessageBoxCustom.Show("请选择人员！"); } } ///

/// 对象转为时间 ///

/// /// DateTime GetObjectToDateTime(object timeObj) { try { if (timeObj != null) { return Convert.ToDateTime(timeObj.ToString()); } else { return DateTime.MinValue; } } catch { return DateTime.MinValue; } } ///

/// 选择项目类别 ///

/// /// protected override void cmbItemCategory_ComboBoxTree_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e) { //清空项目名称 this.cmbProjectTitle.TreeView.Nodes.Clear(); this.cmbProjectTitle.Text = ""; this.cmbCommissionScheme.SetTextAndTag_ValueNull(); this.cmbCommissionScheme.Enabled = true; this.cmbProjectTitle.Enabled = true; if (this.cmbItemCategory.Text.Trim() == "订单前期") { LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboxTreeView(this.cmbProjectTitle, StrBindData: "实收,全款", IsFirstNodeNull: true); } else if (this.cmbItemCategory.Text.Trim() == "服务前期") { LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboxTreeView(this.cmbProjectTitle, StrBindData: "摄影前期,化妆前期,引导前期,初修前期,精修前期,设计前期", IsFirstNodeNull: true); } else if (this.cmbItemCategory.Text.Trim() == "订单后期" || this.cmbItemCategory.Text.Trim() == "其它消费") { LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_SystemCategory("BEBACDAJDFDDEACGJ", this.cmbProjectTitle, IsFirstNodeNull: true, StrWhere: "Sc_ClassCode!='BEBCADBFBCDFBGJHC' and Sc_ClassCode!='BEBCADBFBDDEGGABF' and Sc_ClassCode!='BEBCBFBICGDHCGBEJ' and Sc_ClassCode!='BEBCABBAAICBDHDHI' and Sc_ClassCode!='BEBCABBAAICJAAGDG' and Sc_ClassCode!='BEBCBFBICFCECBHFF'"); } else if (this.cmbItemCategory.Text.Trim() == "服务后期") { LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboxTreeView(this.cmbProjectTitle, StrBindData: "门市选片二销,摄影选片二销,化妆选片二销,引导选片二销,初修选片二销,设计选片二销,精修选片二销", IsFirstNodeNull: true); } else if (this.cmbItemCategory.Text.Trim() == "会员充值" || this.cmbItemCategory.Text.Trim() == "服务卡充值") { this.cmbProjectTitle.Enabled = false; } else if (this.cmbItemCategory.Text.Trim() == "礼服租售") { LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboxTreeView(this.cmbProjectTitle, StrBindData: "礼服出租,礼服出售", IsFirstNodeNull: true); } else if (this.cmbItemCategory.Text.Trim() == "计件提成") { LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboBoxTreeView_SystemCategory("BEBBBABBEBAIHGDCB", this.cmbProjectTitle, IsFirstNodeNull: true, tbl: tblSystemCategory); this.cmbCommissionScheme.Enabled = false; this.cmbCommissionScheme.Text = "计件提成"; } } ///

/// 查询 ///

/// /// protected override void btnSelect_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(this.txtTimeStart.DateValue)) { MessageBoxCustom.Show("开始时间不能为空！"); return; } if (string.IsNullOrEmpty(this.txtTimeEnd.DateValue)) { MessageBoxCustom.Show("结束时间不能为空！"); return; } if (this.cmbItemCategory.Text.Trim() == "订单后期" && this.cmbProjectTitle.Text.Trim() == "选片二销") { this.lblAmountDisplay.Text = "选片金额:"; } else { this.lblAmountDisplay.Text = "套系金额:"; } if (!string.IsNullOrEmpty(this.txtAmountRange1.Text)) { if (string.IsNullOrEmpty(this.txtAmountRange2.Text)) { MessageBoxCustom.Show("结束金额范围不能为空！"); return; } } if (!string.IsNullOrEmpty(this.txtAmountRange2.Text)) { if (string.IsNullOrEmpty(this.txtAmountRange1.Text)) { MessageBoxCustom.Show("开始金额范围不能为空！"); return; } } if (!string.IsNullOrEmpty(this.txtScores1.Text)) { if (string.IsNullOrEmpty(this.txtScores2.Text)) { MessageBoxCustom.Show("满意分值范围不能为空！"); return; } } if (!string.IsNullOrEmpty(this.txtScores2.Text)) { if (string.IsNullOrEmpty(this.txtScores1.Text)) { MessageBoxCustom.Show("满意分值范围不能为空！"); return; } } this.Str_ItemCategory = this.cmbItemCategory.Text.Trim(); this.Str_ProcessStatus = this.cmbProcessStatus.Text.Trim(); this.Str_CustomerSource = this.cmbCustomerSource.Text.Trim(); this.Str_CustomerSourceTag = this.cmbCustomerSource.Tag; this.Str_ProjectTitle = this.cmbProjectTitle.Text.Trim(); this.Str_ProjectTitleTag = this.cmbProjectTitle.Tag; this.Str_PakName = this.CtvPak_Name.Text.Trim(); this.Str_PakNameTag = this.CtvPak_Name.Tag; this.Str_AmountRange1 = this.txtAmountRange1.Text.Trim(); this.Str_AmountRange2 = this.txtAmountRange2.Text.Trim(); this.Str_Scores1 = this.txtScores1.Text.Trim(); this.Str_Scores2 = this.txtScores2.Text.Trim(); if (this.cmbEmployeeName.Tag == null) { this.cmbEmployeeName.TagFindText(""); } string StrEmployeeNameTag = this.cmbEmployeeName.Tag.ToString().Trim(); string StrDateStart = this.txtTimeStart.DateValue.ToString().Trim(); string StrDateEnd = this.txtTimeEnd.DateValue.ToString().Trim(); if (this.cmbEmployeeName.Tag != null) { if (this.cmbEmployeeName.StrGetName.Trim() == "User") { this.txtCommissionWages.Text = "0"; LYFZ.ComponentLibrary.FrmLoadHandling.LoadDoWorkMethod(delegate(object obj, BackgroundWorker backgroundWorker) { string strCurrentPerformance = Convert.ToDecimal(this.BindPerformance(StrDateStart, StrDateEnd, StrEmployeeNameTag, backgroundWorker)).ToString("N2"); string StrCountSum = this.GetNumberOfResults(StrEmployeeNameTag, StrDateStart, StrDateEnd); this.Invoke(new UpdateControl(delegate() { //获取员工业绩列表 this.txtCurrentPerformance.Text = strCurrentPerformance; this.lblCountSum.Text = StrCountSum; })); }); } else { this.TotalPerformance(); this.dgvAll.Visible = true; } } //以下为滕工加，2016-01-28 this.cmbCommissionScheme_ComboBoxTree_NodeMouseClick(this, null); } ///

/// 输入框设置 ///

/// /// protected override void txtAmountRange2_KeyPress(object sender, KeyPressEventArgs e) { if (!Char.IsNumber(e.KeyChar) && !Char.IsControl(e.KeyChar)) { e.Handled = true; } } ///

/// 输入框设置 ///

/// /// protected override void txtAmountRange1_KeyPress(object sender, KeyPressEventArgs e) { if (!Char.IsNumber(e.KeyChar) && !Char.IsControl(e.KeyChar)) { e.Handled = true; } } ///

/// 关闭 ///

/// /// protected override void btnClose_Click(object sender, EventArgs e) { this.Close(); } ///

/// 提成工资事件 ///

/// /// protected override void cmbCommissionScheme_ComboBoxTree_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e) { if (!string.IsNullOrEmpty(this.cmbCommissionScheme.Text.Trim()) && this.cmbCommissionScheme.Tag != null) { if (this.cmbEmployeeName.Text.Trim() == "全部" || this.cmbEmployeeName.StrGetName.ToString() == "Department" || string.IsNullOrEmpty(this.cmbEmployeeName.Text.Trim())) { MessageBoxCustom.Show("请选择员工！"); this.cmbCommissionScheme.Text = ""; return; } DataTable dt = wcsbll.GetList("Wcs_TypeCode='" + this.cmbCommissionScheme.Tag.ToString() + "'").Tables[0]; if (dt.Rows.Count == 0) { MessageBoxCustom.Show("请在工资设置，设置规则！"); this.cmbCommissionScheme.Text = ""; this.txtCommissionWages.Text = "0"; return; } else { this.txtCommissionWages.Text = wcsbll.GetCommissionSpecifications(this.cmbCommissionScheme.Tag.ToString(), Convert.ToDecimal(this.txtCurrentPerformance.Text)).ToString("N2"); } } else { this.txtCommissionWages.Text = "0"; } } ///

/// 排序 ///

/// /// protected override void dgvAll_SortCompare(object sender, DataGridViewSortCompareEventArgs e) { if (e.Column.Name == "员工姓名" || e.Column.Name == "当前业绩") { e.SortResult = (Convert.ToDouble(e.CellValue1) - Convert.ToDouble(e.CellValue2) > 0) ? 1 : (Convert.ToDouble(e.CellValue1) - Convert.ToDouble(e.CellValue2) < 0) ? -1 : 0; } //否则，按字符串比较 else { e.SortResult = System.String.Compare(Convert.ToString(e.CellValue1), Convert.ToString(e.CellValue2)); } e.Handled = true;//不能省掉，不然没效果 } ///

/// 保存记录 ///

/// /// protected override void btnSave_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtTimeStart.DateValue)) { MessageBoxCustom.Show("开始时间不能为空！"); return; } if (string.IsNullOrEmpty(txtTimeEnd.DateValue)) { MessageBoxCustom.Show("结束时间不能为空！"); return; } if (cmbEmployeeName.Text.Trim() == "全部" || cmbEmployeeName.StrGetName.ToString() == "Department" || string.IsNullOrEmpty(cmbEmployeeName.Text.Trim())) { MessageBoxCustom.Show("请选择员工！"); return; } if (string.IsNullOrEmpty(cmbCommissionScheme.Text.Trim())) { MessageBoxCustom.Show("请选择提成方案！"); return; } if (cmbCommissionScheme.Text.Trim() != "计件提成") { DataTable dt = wcsbll.GetList("Wcs_TypeCode='" + cmbCommissionScheme.Tag.ToString() + "'").Tables[0]; if (dt.Rows.Count == 0) { MessageBoxCustom.Show("请在工资设置，设置规则！"); cmbCommissionScheme.SetTextAndTag_ValueNull(); txtCommissionWages.Text = "0"; return; } } #region 保存工资提成记录 LYFZ.Model.Model_ErpWageCommissionRecords WageCommissionRecordsModel = new Model.Model_ErpWageCommissionRecords(); WageCommissionRecordsModel.Wcr_DividedShop = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetLocalCompanyInfoID(); WageCommissionRecordsModel.Wcr_EmployeeID = cmbEmployeeName.Tag.ToString(); if (cmbCommissionScheme.Text.Trim() == "计件提成") { WageCommissionRecordsModel.Wcr_CommissionScheme = cmbCommissionScheme.Text.Trim(); } else { WageCommissionRecordsModel.Wcr_CommissionScheme = cmbCommissionScheme.Tag.ToString(); } WageCommissionRecordsModel.Wcr_CurrentPerformance = Convert.ToDecimal(txtCurrentPerformance.Text); WageCommissionRecordsModel.Wcr_PieceCommission = Convert.ToDecimal(txtPieceCommission.Text); WageCommissionRecordsModel.Wcr_CommissionWages = Convert.ToDecimal(txtCommissionWages.Text); WageCommissionRecordsModel.Wcr_PerformanceTimeStart = Convert.ToDateTime(txtTimeStart.Text); WageCommissionRecordsModel.Wcr_PerformanceTimeEnd = Convert.ToDateTime(txtTimeEnd.Text); WageCommissionRecordsModel.Wcr_CreateDateTime = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetServerDateTime(); WageCommissionRecordsModel.Wcr_CreateName = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_EmployeeID; if (wcrbll.Add(WageCommissionRecordsModel)) { MessageBoxCustom.Show("保存成功！"); cmbCommissionScheme.SetTextAndTag_ValueNull(); txtCommissionWages.Text = "0"; } #endregion } ///

/// 查看记录 ///

/// /// protected override void btnSearchRecord_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(cmbEmployeeName.Text.Trim())) { MessageBoxCustom.Show("员工姓名不能为空！请选择！"); return; } LYFZ.Software.MainBusiness.FinancialManagement.Payroll.FrmSearchRecord frm = new Payroll.FrmSearchRecord(); frm.N_NameText = cmbEmployeeName.Text.Trim(); if (cmbEmployeeName.Text.Trim() != "全部") { frm.N_NameTag = cmbEmployeeName.Tag.ToString(); frm.N_Name = cmbEmployeeName.Name; } frm.ShowDialog(); } ///

/// 添加行事件 ///

/// /// void dgv_RowsAdded(object sender, DataGridViewRowsAddedEventArgs e) { if (this.dgv.Rows[e.RowIndex].Cells["Column4"].Value != null && !string.IsNullOrEmpty(this.dgv.Rows[e.RowIndex].Cells["Column4"].Value.ToString().Trim())) { this.dgv.Rows[e.RowIndex].Cells["Column4"].Value = LYFZ.Command.Command_Validate.DateTimeToString(this.dgv.Rows[e.RowIndex].Cells["Column4"].Value, "yyyy-MM-dd HH:mm"); } if (this.dgv.Rows[e.RowIndex].Cells["Column11"].Value != null && !string.IsNullOrEmpty(this.dgv.Rows[e.RowIndex].Cells["Column11"].Value.ToString().Trim())) { this.dgv.Rows[e.RowIndex].Cells["Column11"].Value = LYFZ.Command.Command_Validate.DateTimeToString(this.dgv.Rows[e.RowIndex].Cells["Column11"].Value, "yyyy-MM-dd HH:mm"); } if (this.dgv.Rows[e.RowIndex].Cells["Column3"].Value != null && !string.IsNullOrEmpty(this.dgv.Rows[e.RowIndex].Cells["Column3"].Value.ToString().Trim())) { this.dgv.Rows[e.RowIndex].Cells["Column3"].Value = this.dgv.Rows[e.RowIndex].Cells["Column3"].Value.ToString(); } } ///

/// 导出 ///

/// /// protected override void btnExPort_Click(object sender, EventArgs e) { if (this.dgv.Visible) { this.dgv.DataToExcelPayroll(this.cmbEmployeeName.Text.Trim()); } else { this.dgvAll.ExportDataTable(); } } ///

/// 开始时间改变 ///

/// /// void txtTimeStart_Leave(object sender, EventArgs e) { if (!string.IsNullOrEmpty(this.txtTimeStart.DateValue.Trim())) { this.txtTimeEnd.DateValue = Convert.ToDateTime(this.txtTimeStart.DateValue).AddMonths(1).AddSeconds(-1).ToString("yyyy-MM-dd"); } } ///

/// 窗体大小发生改变事件 ///

/// /// void FrmPayroll_Resize(object sender, EventArgs e) { if (!this.IsFirstRun) { switch (this.panelSaveed.Location.Y) { case 0: this.flowLayoutPanel1.Height = 29; break; case 29: this.flowLayoutPanel1.Height = 59; break; case 58: this.flowLayoutPanel1.Height = 89; break; case 87: this.flowLayoutPanel1.Height = 119; break; case 116: this.flowLayoutPanel1.Height = 149; break; } } } } }