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.CameraControlBook { public partial class A_ProcessMonitorFormMain : LYFZ.Software.UI.CameraControlBook.A_ProcessMonitorFormMain { LYFZ.BLL.BLL_ErpOrder orbll = new BLL.BLL_ErpOrder(); LYFZ.BLL.BLL_ErpSystemConfigure sgbll = new BLL.BLL_ErpSystemConfigure(); LYFZ.BLL.BLL_ErpOrderProductList opbll = new BLL.BLL_ErpOrderProductList(); LYFZ.BLL.BLL_ErpOrderProductList orpbll = new BLL.BLL_ErpOrderProductList(); public A_ProcessMonitorFormMain() { this.Load += A_ProcessMonitorFormMain_Load; this.butnAddRecord.Click += butnAddRecord_Click; this.butnAlarmSet.Click += butnAlarmSet_Click; this.butnColse.Click += butnColse_Click; this.butnEmployeeSchedule.Click += butnEmployeeSchedule_Click; this.butnQuery.Click += butnQuery_Click; this.butnTimeArrange.Click += butnTimeArrange_Click; this.btnClientServiceAnPai.Click += btnClientServiceAnPai_Click; this.tabPanel.SelectedIndexChanged += tabPanel_SelectedIndexChanged; this.txtNoBack.KeyPress += txtNoBack_KeyPress; this.txtNoDesign.KeyPress += txtNoDesign_KeyPress; this.txtNoLook.KeyPress += txtNoLook_KeyPress; this.txtNoPickup.KeyPress += txtNoPickup_KeyPress; this.txtNoRepair.KeyPress += txtNoRepair_KeyPress; this.txtNoSelected.KeyPress += txtNoSelected_KeyPress; this.txtNoSelected2.KeyPress += txtNoSelected2_KeyPress; this.txtNoSend.KeyPress += txtNoSend_KeyPress; this.txtNoShot.KeyPress += txtNoShot_KeyPress; this.txtNoShotIn.KeyPress += txtNoShotIn_KeyPress; this.txtNoBack.KeyDown += txtNoBack_KeyDown; this.txtNoDesign.KeyDown += txtNoDesign_KeyDown; this.txtNoLook.KeyDown += txtNoLook_KeyDown; this.txtNoPickup.KeyDown += txtNoPickup_KeyDown; this.txtNoRepair.KeyDown += txtNoRepair_KeyDown; this.txtNoSelected.KeyDown += txtNoSelected_KeyDown; this.txtNoSelected2.KeyDown += txtNoSelected2_KeyDown; this.txtNoSend.KeyDown += txtNoSend_KeyDown; this.txtNoShot.KeyDown += txtNoShot_KeyDown; this.txtNoShotIn.KeyDown += txtNoShotIn_KeyDown; this.txtNoBack.Leave += txtNoBack_Leave; this.txtNoDesign.Leave += txtNoDesign_Leave; this.txtNoLook.Leave += txtNoLook_Leave; this.txtNoPickup.Leave += txtNoPickup_Leave; this.txtNoRepair.Leave += txtNoRepair_Leave; this.txtNoSelected.Leave += txtNoSelected_Leave; this.txtNoSelected2.Leave += txtNoSelected2_Leave; this.txtNoSend.Leave += txtNoSend_Leave; this.txtNoShot.Leave += txtNoShot_Leave; this.txtNoShotIn.Leave += txtNoShotIn_Leave; this.txtQuery.KeyDown += txtQuery_KeyDown; this.btnCommunicateDetails.Click += btnCommunicateDetails_Click; this.btnExport.Click += btnExport_Click; this.Resize += A_ProcessMonitorFormMain_Resize; this.dgvData.CellDoubleClick += dgvData_CellDoubleClick; this.tb_NoShot.Parent = null; this.tb_NoShotIn.Parent = null; this.tb_NoRepair.Parent = null; this.tb_NoSelected.Parent = null; this.tb_NoSelected2.Parent = null; this.tb_NoDesign.Parent = null; this.tb_NoSend2.Parent = null; this.tb_NoLook.Parent = null; this.tb_NoSend.Parent = null; this.tb_NoBack.Parent = null; this.tb_NoPickup.Parent = null; this.tb_NoPickup2.Parent = null; this.tb_SelectNotRefinement.Parent = null; this.tb_RefinementNotDesign.Parent = null; //this.btnClientServiceAnPai.Visible = false; } /// /// 安排任务的任务类型 /// public string StrClientServiceType = ""; /// /// 员工编号 /// string StrUserID = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_EmployeeID; #region 窗体事件 /// /// 窗体加载事件 /// /// /// void A_ProcessMonitorFormMain_Load(object sender, EventArgs e) { LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindGroupStoreName(this.cmbtreevStoreName, StrGroupKeyCode: "st071", StrKeyCode: "st0703"); if (this.cmbtreevStoreName.Nodes.Count <= 0) { LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindGroupStoreName(this.cmbtreevStoreName, StrGroupKeyCode: LYFZ.Model.Model_UserRights.GetQuickToolsPet(), StrKeyCode: "st0703"); } #region 预警设置 DateTime StrTime = SDateTime.Now; string StrUsrID = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_EmployeeID; DataTable tbl = orbll.GetView_Custom("tb_ErpSystemConfigure", StrWhere: "Sconfig_Code in ('ProcessMonitor_NoShot','ProcessMonitor_NoShotIn','ProcessMonitor_NoRepair','ProcessMonitor_NoSelected','ProcessMonitor_NoSelected2','ProcessMonitor_SelectNotRefinement','ProcessMonitor_RefinementNotDesign', 'ProcessMonitor_NoDesign','ProcessMonitor_NoLook','ProcessMonitor_NoSend','ProcessMonitor_NoBack','ProcessMonitor_NoPickup','ProcessMonitor_NoPickup2','ProcessMonitor_NoSend2')", ShowColumnName: "Sconfig_Code,Sconfig_Value", filedOrder: "ID").Tables[0]; bool IsFindNoShot = false; bool IsFindNoShotIn = false; bool IsFindNoRepair = false; bool IsFindNoSelected = false; bool IsFindNoSelected2 = false; bool IsFindNoDesign = false; bool IsFindNoLook = false; bool IsFindNoSend = false; bool IsFindNoSend2 = false; bool IsFindNoBack = false; bool IsFindNoPickup = false; bool IsFindNoPickup2 = false; bool IsSelectNotRefinement = false; bool IsRefinementNotDesign = false; if (tbl.Rows.Count > 0) { tbl.PrimaryKey = new DataColumn[] { tbl.Columns["Sconfig_Code"] }; DataRow dtRow_NoShot = tbl.Rows.Find("ProcessMonitor_NoShot"); if (dtRow_NoShot != null) { IsFindNoShot = true; } DataRow dtRow_NoShotIn = tbl.Rows.Find("ProcessMonitor_NoShotIn"); if (dtRow_NoShotIn != null) { IsFindNoShotIn = true; } DataRow dtRow_NoRepair = tbl.Rows.Find("ProcessMonitor_NoRepair"); if (dtRow_NoRepair != null) { IsFindNoRepair = true; } DataRow dtRow_NoSelected = tbl.Rows.Find("ProcessMonitor_NoSelected"); if (dtRow_NoSelected != null) { IsFindNoSelected = true; } DataRow dtRow_NoSelected2 = tbl.Rows.Find("ProcessMonitor_NoSelected2"); if (dtRow_NoSelected2 != null) { IsFindNoSelected2 = true; } DataRow dtRow_NoDesign = tbl.Rows.Find("ProcessMonitor_NoDesign"); if (dtRow_NoDesign != null) { IsFindNoDesign = true; } DataRow dtRow_NoLook = tbl.Rows.Find("ProcessMonitor_NoLook"); if (dtRow_NoLook != null) { IsFindNoLook = true; } DataRow dtRow_NoSend = tbl.Rows.Find("ProcessMonitor_NoSend"); if (dtRow_NoSend != null) { IsFindNoSend = true; } DataRow dtRow_NoSend2 = tbl.Rows.Find("ProcessMonitor_NoSend2"); if (dtRow_NoSend2 != null) { IsFindNoSend2 = true; } DataRow dtRow_NoBack = tbl.Rows.Find("ProcessMonitor_NoBack"); if (dtRow_NoBack != null) { IsFindNoBack = true; } DataRow dtRow_NoPickup = tbl.Rows.Find("ProcessMonitor_NoPickup"); if (dtRow_NoPickup != null) { IsFindNoPickup = true; } DataRow dtRow_NoPickup2 = tbl.Rows.Find("ProcessMonitor_NoPickup2"); if (dtRow_NoPickup2 != null) { IsFindNoPickup2 = true; } DataRow dtRow_SelectNotRefinement = tbl.Rows.Find("ProcessMonitor_SelectNotRefinement"); if (dtRow_SelectNotRefinement != null) { IsSelectNotRefinement = true; } DataRow dtRow_RefinementNotDesign = tbl.Rows.Find("ProcessMonitor_RefinementNotDesign"); if (dtRow_RefinementNotDesign != null) { IsRefinementNotDesign = true; } } LYFZ.Model.Model_ErpSystemConfigure model = null; List clist = new List(); if (!IsFindNoShot) { model = new Model.Model_ErpSystemConfigure(); model.Sconfig_Code = "ProcessMonitor_NoShot"; model.Sconfig_Name = "流程把控_已定未拍"; model.Sconfig_Value = "1"; model.Sconfig_IsEnabled = true; model.Sconfig_Remark = "流程把控_已定几天未拍"; model.Sconfig_Order = 1; model.Sconfig_CreateDatetime = StrTime; model.Sconfig_CreateName = StrUsrID; clist.Add(sgbll.GetAddCommandInfo(model)); } if (!IsFindNoShotIn) { model = new Model.Model_ErpSystemConfigure(); model.Sconfig_Code = "ProcessMonitor_NoShotIn"; model.Sconfig_Name = "流程把控_已拍未拍完"; model.Sconfig_Value = "1"; model.Sconfig_IsEnabled = true; model.Sconfig_Remark = "流程把控_已拍几天未拍完"; model.Sconfig_Order = 1; model.Sconfig_CreateDatetime = StrTime; model.Sconfig_CreateName = StrUsrID; clist.Add(sgbll.GetAddCommandInfo(model)); } if (!IsFindNoRepair) { model = new Model.Model_ErpSystemConfigure(); model.Sconfig_Code = "ProcessMonitor_NoRepair"; model.Sconfig_Name = "流程把控_已拍未修"; model.Sconfig_Value = "1"; model.Sconfig_IsEnabled = true; model.Sconfig_Remark = "流程把控_已拍几天未修"; model.Sconfig_Order = 1; model.Sconfig_CreateDatetime = StrTime; model.Sconfig_CreateName = StrUsrID; clist.Add(sgbll.GetAddCommandInfo(model)); } if (!IsFindNoSelected) { model = new Model.Model_ErpSystemConfigure(); model.Sconfig_Code = "ProcessMonitor_NoSelected"; model.Sconfig_Name = "流程把控_已拍未选"; model.Sconfig_Value = "1"; model.Sconfig_IsEnabled = true; model.Sconfig_Remark = "流程把控_已拍几天未选"; model.Sconfig_Order = 1; model.Sconfig_CreateDatetime = StrTime; model.Sconfig_CreateName = StrUsrID; clist.Add(sgbll.GetAddCommandInfo(model)); } if (!IsFindNoSelected2) { model = new Model.Model_ErpSystemConfigure(); model.Sconfig_Code = "ProcessMonitor_NoSelected2"; model.Sconfig_Name = "流程把控_已修未选"; model.Sconfig_Value = "1"; model.Sconfig_IsEnabled = true; model.Sconfig_Remark = "流程把控_已修几天未选"; model.Sconfig_Order = 1; model.Sconfig_CreateDatetime = StrTime; model.Sconfig_CreateName = StrUsrID; clist.Add(sgbll.GetAddCommandInfo(model)); } if (!IsFindNoDesign) { model = new Model.Model_ErpSystemConfigure(); model.Sconfig_Code = "ProcessMonitor_NoDesign"; model.Sconfig_Name = "流程把控_已选未设计"; model.Sconfig_Value = "1"; model.Sconfig_IsEnabled = true; model.Sconfig_Remark = "流程把控_已选几天未设计"; model.Sconfig_Order = 1; model.Sconfig_CreateDatetime = StrTime; model.Sconfig_CreateName = StrUsrID; clist.Add(sgbll.GetAddCommandInfo(model)); } if (!IsFindNoLook) { model = new Model.Model_ErpSystemConfigure(); model.Sconfig_Code = "ProcessMonitor_NoLook"; model.Sconfig_Name = "流程把控_已设计未看版"; model.Sconfig_Value = "1"; model.Sconfig_IsEnabled = true; model.Sconfig_Remark = "流程把控_已设计几天未看版"; model.Sconfig_Order = 1; model.Sconfig_CreateDatetime = StrTime; model.Sconfig_CreateName = StrUsrID; clist.Add(sgbll.GetAddCommandInfo(model)); } if (!IsFindNoSend) { model = new Model.Model_ErpSystemConfigure(); model.Sconfig_Code = "ProcessMonitor_NoSend"; model.Sconfig_Name = "流程把控_已看版未发片"; model.Sconfig_Value = "1"; model.Sconfig_IsEnabled = true; model.Sconfig_Remark = "流程把控_已看版几天未发片"; model.Sconfig_Order = 1; model.Sconfig_CreateDatetime = StrTime; model.Sconfig_CreateName = StrUsrID; clist.Add(sgbll.GetAddCommandInfo(model)); } if (!IsFindNoSend2) { model = new Model.Model_ErpSystemConfigure(); model.Sconfig_Code = "ProcessMonitor_NoSend2"; model.Sconfig_Name = "流程把控_已选未发片"; model.Sconfig_Value = "1"; model.Sconfig_IsEnabled = true; model.Sconfig_Remark = "流程把控_已选几天未发片"; model.Sconfig_Order = 1; model.Sconfig_CreateDatetime = StrTime; model.Sconfig_CreateName = StrUsrID; clist.Add(sgbll.GetAddCommandInfo(model)); } if (!IsFindNoBack) { model = new Model.Model_ErpSystemConfigure(); model.Sconfig_Code = "ProcessMonitor_NoBack"; model.Sconfig_Name = "流程把控_已发片未回件"; model.Sconfig_Value = "1"; model.Sconfig_IsEnabled = true; model.Sconfig_Remark = "流程把控_已发片几天未回件"; model.Sconfig_Order = 1; model.Sconfig_CreateDatetime = StrTime; model.Sconfig_CreateName = StrUsrID; clist.Add(sgbll.GetAddCommandInfo(model)); } if (!IsFindNoPickup) { model = new Model.Model_ErpSystemConfigure(); model.Sconfig_Code = "ProcessMonitor_NoPickup"; model.Sconfig_Name = "流程把控_部分回件未取件"; model.Sconfig_Value = "1"; model.Sconfig_IsEnabled = true; model.Sconfig_Remark = "流程把控_部分回件未取件"; model.Sconfig_Order = 1; model.Sconfig_CreateDatetime = StrTime; model.Sconfig_CreateName = StrUsrID; clist.Add(sgbll.GetAddCommandInfo(model)); } if (!IsFindNoPickup2) { model = new Model.Model_ErpSystemConfigure(); model.Sconfig_Code = "ProcessMonitor_NoPickup2"; model.Sconfig_Name = "流程把控_全部回件未取件"; model.Sconfig_Value = "1"; model.Sconfig_IsEnabled = true; model.Sconfig_Remark = "流程把控_全部回件未取件"; model.Sconfig_Order = 1; model.Sconfig_CreateDatetime = StrTime; model.Sconfig_CreateName = StrUsrID; clist.Add(sgbll.GetAddCommandInfo(model)); } if (!IsSelectNotRefinement) { model = new Model.Model_ErpSystemConfigure(); model.Sconfig_Code = "ProcessMonitor_SelectNotRefinement"; model.Sconfig_Name = "流程把控_已选未精修"; model.Sconfig_Value = "1"; model.Sconfig_IsEnabled = true; model.Sconfig_Remark = "流程把控_已选未精修"; model.Sconfig_Order = 1; model.Sconfig_CreateDatetime = StrTime; model.Sconfig_CreateName = StrUsrID; clist.Add(sgbll.GetAddCommandInfo(model)); } if (!IsRefinementNotDesign) { model = new Model.Model_ErpSystemConfigure(); model.Sconfig_Code = "ProcessMonitor_RefinementNotDesign"; model.Sconfig_Name = "流程把控_已精修未设计"; model.Sconfig_Value = "1"; model.Sconfig_IsEnabled = true; model.Sconfig_Remark = "流程把控_已精修未设计"; model.Sconfig_Order = 1; model.Sconfig_CreateDatetime = StrTime; model.Sconfig_CreateName = StrUsrID; clist.Add(sgbll.GetAddCommandInfo(model)); } if (clist.Count > 0) { LYFZ.BLL.BaseBllOperate.ExecuteSqlTran(clist); } #endregion DataTable dt = sgbll.GetProcessMonitorInterfaceManagement(); TabPage tblPage = null; if (dt.Rows.Count > 0) { this.IsExecute = false; for (int i = 0; i < dt.Columns.Count; i++) { if (Convert.ToBoolean(dt.Rows[0][i])) { switch ("tb_" + dt.Columns[i].ColumnName.Trim()) { case "tb_NoShot": this.tb_NoShot.Parent = this.tabPanel; tblPage = this.tb_NoShot; break; case "tb_NoShotIn": this.tb_NoShotIn.Parent = this.tabPanel; tblPage = this.tb_NoShotIn; break; case "tb_NoRepair": this.tb_NoRepair.Parent = this.tabPanel; tblPage = this.tb_NoRepair; break; case "tb_NoSelected": this.tb_NoSelected.Parent = this.tabPanel; tblPage = this.tb_NoSelected; break; case "tb_NoSelected2": this.tb_NoSelected2.Parent = this.tabPanel; tblPage = this.tb_NoSelected2; break; case "tb_NoDesign": this.tb_NoDesign.Parent = this.tabPanel; tblPage = this.tb_NoDesign; break; case "tb_NoSend2": this.tb_NoSend2.Parent = this.tabPanel; tblPage = this.tb_NoSend2; break; case "tb_NoLook": this.tb_NoLook.Parent = this.tabPanel; tblPage = this.tb_NoLook; break; case "tb_NoSend": this.tb_NoSend.Parent = this.tabPanel; tblPage = this.tb_NoSend; break; case "tb_NoBack": this.tb_NoBack.Parent = this.tabPanel; tblPage = this.tb_NoBack; break; case "tb_NoPickup": this.tb_NoPickup.Parent = this.tabPanel; tblPage = this.tb_NoPickup; break; case "tb_NoPickup2": this.tb_NoPickup2.Parent = this.tabPanel; tblPage = this.tb_NoPickup2; break; case "tb_SelectNotRefinement": this.tb_SelectNotRefinement.Parent = this.tabPanel; tblPage = this.tb_SelectNotRefinement; break; case "tb_RefinementNotDesign": this.tb_RefinementNotDesign.Parent = this.tabPanel; tblPage = this.tb_RefinementNotDesign; break; } } } } else { tblPage = this.tb_NoShot; this.tb_NoShot.Parent = this.tabPanel; this.tb_NoShotIn.Parent = this.tabPanel; this.tb_NoRepair.Parent = this.tabPanel; this.tb_NoSelected.Parent = this.tabPanel; this.tb_NoSelected2.Parent = this.tabPanel; this.tb_NoDesign.Parent = this.tabPanel; this.tb_NoSend2.Parent = this.tabPanel; this.tb_NoLook.Parent = this.tabPanel; this.tb_NoSend.Parent = this.tabPanel; this.tb_NoBack.Parent = this.tabPanel; this.tb_NoPickup.Parent = this.tabPanel; this.tb_NoPickup2.Parent = this.tabPanel; this.tb_SelectNotRefinement.Parent = this.tabPanel; this.tb_RefinementNotDesign.Parent = this.tabPanel; } TabPage strTabName = null; if (this.StrClientServiceType.Trim().Length > 0) { switch (this.StrClientServiceType.Trim()) { case "已定未拍": strTabName = this.tb_NoShot; break; case "已拍未拍完": strTabName = this.tb_NoShotIn; break; case "已拍未选": strTabName = this.tb_NoSelected; break; case "已修未选": strTabName = this.tb_NoSelected2; break; case "已设计未看": strTabName = this.tb_NoLook; break; case "部分回件未取": strTabName = this.tb_NoPickup; break; case "全部回件未取": strTabName = this.tb_NoPickup2; break; case "已选未精修": strTabName = this.tb_SelectNotRefinement; break; case "已精修未设计": strTabName = this.tb_RefinementNotDesign; break; } } if (strTabName != null && this.tabPanel.Contains(strTabName)) { this.Location = new Point(LYFZ.EnumPublic.FormLocation_X, LYFZ.EnumPublic.FormLocation_Y); this.Size = new Size(LYFZ.EnumPublic.FormSize_Width, LYFZ.EnumPublic.FormSize_Height); this.tabPanel.SelectedTab = strTabName; } else { this.tabPanel.SelectedTab = tblPage; } this.GetProcessMonitorVisible(); this.GetProcessMonitorData(); this.IsExecute = true; ///控制客服中心安排客服的版本权 //LYFZSS.SystemSpecterPossessed.ISystemSpecterPossessed.GetMySystemSpecter = LYFZSS.SystemSpecterType.SST_D; List hideControls = new List(); hideControls.Add(this.btnClientServiceAnPai); List moveControls = new List(); moveControls.Add(this.butnAddRecord); moveControls.Add(this.btnCommunicateDetails); moveControls.Add(this.butnRecordingsPlay); moveControls.Add(this.btnExport); moveControls.Add(this.butnColse); LYFZ.Software.MainBusiness.VersionControl.StaticVersion.BindVersionShowHideControl(VersionControl.VersionFunctionEnum.客服中心客服安排, hideControls, null, null); ///控制客服中心沟通记录的版本权 //LYFZSS.SystemSpecterPossessed.ISystemSpecterPossessed.GetMySystemSpecter = LYFZSS.SystemSpecterType.SST_D; hideControls = new List(); hideControls.Add(this.butnAddRecord); hideControls.Add(this.btnCommunicateDetails); moveControls = new List(); moveControls.Add(this.butnRecordingsPlay); moveControls.Add(this.btnExport); moveControls.Add(this.butnColse); LYFZ.Software.MainBusiness.VersionControl.StaticVersion.BindVersionShowHideControl(VersionControl.VersionFunctionEnum.客服中心流程把控客服沟通登记, hideControls, null, null); } /// /// 窗体大小发生变化 /// /// /// void A_ProcessMonitorFormMain_Resize(object sender, EventArgs e) { switch (this.butnColse.Location.Y) { case 3: this.flowLayoutPanel1.Height = 35; break; case 37: this.flowLayoutPanel1.Height = 70; break; } } /// /// 获取预警数据 /// void GetProcessMonitorData() { System.Threading.Thread t = new System.Threading.Thread(new System.Threading.ThreadStart(delegate() { string ExecuteSql = orbll.GetView_CustomReturnExecuteSql("tb_ErpSystemConfigure", StrWhere: " Sconfig_Code = 'ProcessMonitor_NoShot'", ShowColumnName: "Sconfig_Value"); ExecuteSql += ";" + orbll.GetView_CustomReturnExecuteSql("tb_ErpSystemConfigure", StrWhere: " Sconfig_Code = 'ProcessMonitor_NoShotIn'", ShowColumnName: "Sconfig_Value"); ExecuteSql += ";" + orbll.GetView_CustomReturnExecuteSql("tb_ErpSystemConfigure", StrWhere: " Sconfig_Code = 'ProcessMonitor_NoRepair'", ShowColumnName: "Sconfig_Value"); ExecuteSql += ";" + orbll.GetView_CustomReturnExecuteSql("tb_ErpSystemConfigure", StrWhere: " Sconfig_Code = 'ProcessMonitor_NoSelected'", ShowColumnName: "Sconfig_Value"); ExecuteSql += ";" + orbll.GetView_CustomReturnExecuteSql("tb_ErpSystemConfigure", StrWhere: " Sconfig_Code = 'ProcessMonitor_NoSelected2'", ShowColumnName: "Sconfig_Value"); ExecuteSql += ";" + orbll.GetView_CustomReturnExecuteSql("tb_ErpSystemConfigure", StrWhere: " Sconfig_Code = 'ProcessMonitor_NoDesign'", ShowColumnName: "Sconfig_Value"); ExecuteSql += ";" + orbll.GetView_CustomReturnExecuteSql("tb_ErpSystemConfigure", StrWhere: " Sconfig_Code = 'ProcessMonitor_NoLook'", ShowColumnName: "Sconfig_Value"); ExecuteSql += ";" + orbll.GetView_CustomReturnExecuteSql("tb_ErpSystemConfigure", StrWhere: " Sconfig_Code = 'ProcessMonitor_NoSend'", ShowColumnName: "Sconfig_Value"); ExecuteSql += ";" + orbll.GetView_CustomReturnExecuteSql("tb_ErpSystemConfigure", StrWhere: " Sconfig_Code = 'ProcessMonitor_NoSend2'", ShowColumnName: "Sconfig_Value"); ExecuteSql += ";" + orbll.GetView_CustomReturnExecuteSql("tb_ErpSystemConfigure", StrWhere: " Sconfig_Code = 'ProcessMonitor_NoBack'", ShowColumnName: "Sconfig_Value"); ExecuteSql += ";" + orbll.GetView_CustomReturnExecuteSql("tb_ErpSystemConfigure", StrWhere: " Sconfig_Code = 'ProcessMonitor_NoPickup'", ShowColumnName: "Sconfig_Value"); ExecuteSql += ";" + orbll.GetView_CustomReturnExecuteSql("tb_ErpSystemConfigure", StrWhere: " Sconfig_Code = 'ProcessMonitor_NoPickup2'", ShowColumnName: "Sconfig_Value"); ExecuteSql += ";" + orbll.GetView_CustomReturnExecuteSql("tb_ErpSystemConfigure", StrWhere: " Sconfig_Code = 'ProcessMonitor_SelectNotRefinement'", ShowColumnName: "Sconfig_Value"); ExecuteSql += ";" + orbll.GetView_CustomReturnExecuteSql("tb_ErpSystemConfigure", StrWhere: " Sconfig_Code = 'ProcessMonitor_RefinementNotDesign'", ShowColumnName: "Sconfig_Value"); DataSet dtSet = orbll.GetView_Custom(ExecuteSql); try { this.Invoke(new LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.UpdateControl(delegate() { this.txtNoShot.Text = dtSet.Tables["ds"].Rows[0]["Sconfig_Value"].ToString().Trim(); this.txtNoShotIn.Text = dtSet.Tables["ds1"].Rows[0]["Sconfig_Value"].ToString().Trim(); this.txtNoRepair.Text = dtSet.Tables["ds2"].Rows[0]["Sconfig_Value"].ToString().Trim(); this.txtNoSelected.Text = dtSet.Tables["ds3"].Rows[0]["Sconfig_Value"].ToString().Trim(); this.txtNoSelected2.Text = dtSet.Tables["ds4"].Rows[0]["Sconfig_Value"].ToString().Trim(); this.txtNoDesign.Text = dtSet.Tables["ds5"].Rows[0]["Sconfig_Value"].ToString().Trim(); this.txtNoLook.Text = dtSet.Tables["ds6"].Rows[0]["Sconfig_Value"].ToString().Trim(); this.txtNoSend.Text = dtSet.Tables["ds7"].Rows[0]["Sconfig_Value"].ToString().Trim(); this.txtNoSend2.Text = dtSet.Tables["ds8"].Rows[0]["Sconfig_Value"].ToString().Trim(); this.txtNoBack.Text = dtSet.Tables["ds9"].Rows[0]["Sconfig_Value"].ToString().Trim(); this.txtNoPickup.Text = dtSet.Tables["ds10"].Rows[0]["Sconfig_Value"].ToString().Trim(); this.txtNoPickup2.Text = dtSet.Tables["ds11"].Rows[0]["Sconfig_Value"].ToString().Trim(); if (dtSet.Tables["ds12"].Rows.Count>0) { this.txtSelectNotRefinement.Text = dtSet.Tables["ds12"].Rows[0]["Sconfig_Value"].ToString().Trim(); } else { this.txtSelectNotRefinement.Text = "1"; } if (dtSet.Tables["ds13"].Rows.Count>0) { this.txtRefinementNotDesign.Text = dtSet.Tables["ds13"].Rows[0]["Sconfig_Value"].ToString().Trim(); } else { this.txtRefinementNotDesign.Text = "1"; } this.PublicFunctionRows(); })); } catch { } })); t.Start(); } /// /// 预警数据显示隐藏 /// void GetProcessMonitorVisible() { this.panelNoShot.Visible = false; this.panelNoShotIn.Visible = false; this.panelNoRepair.Visible = false; this.panelNoSelected.Visible = false; this.panelNoSelected2.Visible = false; this.panelNoDesign.Visible = false; this.panelNoLook.Visible = false; this.panelNoSend.Visible = false; this.panelNoSend2.Visible = false; this.panelNoBack.Visible = false; this.panelNoPickup.Visible = false; this.panelNoPickup2.Visible = false; this.panelSelectNotRefinement.Visible = false; this.panelRefinementNotDesign.Visible = false; switch (this.tabPanel.SelectedTab.Name.Trim()) { case "tb_NoShot": this.panelNoShot.Visible = true; break; case "tb_NoShotIn": this.panelNoShotIn.Visible = true; break; case "tb_NoRepair": this.panelNoRepair.Visible = true; break; case "tb_NoSelected": this.panelNoSelected.Visible = true; break; case "tb_NoSelected2": this.panelNoSelected2.Visible = true; break; case "tb_NoDesign": this.panelNoDesign.Visible = true; break; case "tb_NoSend2": this.panelNoSend2.Visible = true; break; case "tb_NoLook": this.panelNoLook.Visible = true; break; case "tb_NoSend": this.panelNoSend.Visible = true; break; case "tb_NoBack": this.panelNoBack.Visible = true; break; case "tb_NoPickup": this.panelNoPickup.Visible = true; break; case "tb_NoPickup2": this.panelNoPickup2.Visible = true; break; case "tb_SelectNotRefinement": this.panelSelectNotRefinement.Visible = true; break; case "tb_RefinementNotDesign": this.panelRefinementNotDesign.Visible = true; break; } } #endregion #region 按钮事件 /// /// 添加记录 /// /// /// void butnAddRecord_Click(object sender, EventArgs e) { if (this.dgvData.Rows.Count > 0) { if (this.dgvData.CurrentCell.ColumnIndex >= 0 && this.dgvData.CurrentRow.Index >= 0) { string StrOrdNumber = ""; bool IsNextRemindTime = false; StrOrdNumber = this.dgvData.CurrentRow.Cells["Ord_Number"].Value.ToString().Trim(); LYFZ.EnumPublic.ClientServiceTaskItem inputType = EnumPublic.ClientServiceTaskItem.已定未拍; switch (this.tabPanel.SelectedTab.Name.Trim()) { case "tb_NoShot": inputType = EnumPublic.ClientServiceTaskItem.已定未拍; IsNextRemindTime = true; break; case "tb_NoShotIn": inputType = EnumPublic.ClientServiceTaskItem.已拍未拍完; IsNextRemindTime = true; break; case "tb_NoRepair": inputType = EnumPublic.ClientServiceTaskItem.已拍未修; break; case "tb_NoSelected": inputType = EnumPublic.ClientServiceTaskItem.已拍未选; IsNextRemindTime = true; break; case "tb_NoSelected2": inputType = EnumPublic.ClientServiceTaskItem.已修未选; IsNextRemindTime = true; break; case "tb_NoDesign": inputType = EnumPublic.ClientServiceTaskItem.已选未设计; break; case "tb_NoSend2": inputType = EnumPublic.ClientServiceTaskItem.已选未发片; break; case "tb_NoLook": inputType = EnumPublic.ClientServiceTaskItem.已设计未看; IsNextRemindTime = true; break; case "tb_NoSend": inputType = EnumPublic.ClientServiceTaskItem.已看未发片; break; case "tb_NoBack": inputType = EnumPublic.ClientServiceTaskItem.已发未回件; break; case "tb_NoPickup": inputType = EnumPublic.ClientServiceTaskItem.部分回件未取; IsNextRemindTime = true; break; case "tb_NoPickup2": inputType = EnumPublic.ClientServiceTaskItem.全部回件未取; IsNextRemindTime = false; break; case "tb_SelectNotRefinement": inputType = EnumPublic.ClientServiceTaskItem.已选未精修; break; case "tb_RefinementNotDesign": inputType = EnumPublic.ClientServiceTaskItem.已精修未设计; break; } if (StrOrdNumber != "") { DataTable tbl = orbll.GetView_Custom("tb_ErpCustomerGroup", StrWhere: "GP_OrderNumber = '" + StrOrdNumber + "'", ShowColumnName: "GP_CustomerGroupID").Tables[0]; if (tbl.Rows.Count > 0) { LYFZ.Software.MainBusiness.CameraControlBook.SuperSmallForm.A_AddCommunicateRecords frm = new SuperSmallForm.A_AddCommunicateRecords(); frm.StrClientNumber = tbl.Rows[0]["GP_CustomerGroupID"].ToString().Trim(); frm.EnumClientServiceTaskType = EnumPublic.ClientServiceTaskType.流程通知; frm.EnumClientServiceTaskItem = inputType; frm.Areminderdate = IsNextRemindTime; frm.ShowDialog(); if (frm.IsSaveed) { //this.PublicFunctionRows(); ,,, if (LYFZ.BLL.OtherCommonModel.DateTimeToString(frm.model.TR_NextRemindTime) != "" && this.tabPanel.SelectedTab.Text.Trim() == LYFZ.EnumPublic.ClientServiceTaskItem.部分回件未取.ToString().Trim()) { for (int i = 0; i <= this.dgvData.CurrentRow.Index; i++) { if (this.dgvData.Rows[i].Cells["Ord_Number"].Value.ToString().Trim() == this.dgvData.CurrentRow.Cells["Ord_Number"].Value.ToString().Trim()) { this.dgvData.Rows.RemoveAt(i); } } } else { for (int i = this.dgvData.CurrentRow.Index; i >= 0; i--) { if (this.dgvData.Rows[i].Cells["订单号"].Value.ToString().Trim() != "") { this.dgvData.Rows[i].Cells["客服人员"].Value = LYFZ.BLL.BLL_ErpOrderView.GetUserName(frm.model.TR_TracePersonID); this.dgvData.Rows[i].Cells["沟通时间"].Value = LYFZ.BLL.OtherCommonModel.DateTimeToString(frm.model.TR_TraceDateTime); this.dgvData.Rows[i].Cells["沟通状态"].Value = "已沟通"; this.dgvData.Rows[i].Cells["沟通备注"].Value = frm.model.TR_Remark; break; } } } } } } } } } /// /// 沟通详情 /// /// /// void btnCommunicateDetails_Click(object sender, EventArgs e) { if (this.dgvData.Rows.Count > 0) { if (this.dgvData.CurrentCell.ColumnIndex >= 0 && this.dgvData.CurrentRow.Index >= 0) { string StrOrdNumber = this.dgvData.CurrentRow.Cells["Ord_Number"].Value.ToString().Trim(); if (StrOrdNumber != "") { LYFZ.Software.MainBusiness.CameraControlBook.SuperSmallForm.A_CommunicationDetails frm = new SuperSmallForm.A_CommunicationDetails(); frm.StrNumber = StrOrdNumber; frm.ShowDialog(); if (frm.IsSaveed) { this.PublicFunctionRows(); } } } } } /// /// 是否执行 /// bool IsExecute = false; /// /// 预警设置 /// /// /// void butnAlarmSet_Click(object sender, EventArgs e) { LYFZ.Software.MainBusiness.CameraControlBook.SuperSmallForm.A_SetProcessAlertSuperSmallForm frm = new SuperSmallForm.A_SetProcessAlertSuperSmallForm(); frm.ShowDialog(); if (frm.IsSaveed) { DataTable dt = sgbll.GetProcessMonitorInterfaceManagement(); if (dt.Rows.Count > 0) { this.IsExecute = false; this.tb_NoShot.Parent = null; this.tb_NoShotIn.Parent = null; this.tb_NoRepair.Parent = null; this.tb_NoSelected.Parent = null; this.tb_NoSelected2.Parent = null; this.tb_NoDesign.Parent = null; this.tb_NoSend2.Parent = null; this.tb_NoLook.Parent = null; this.tb_NoSend.Parent = null; this.tb_NoBack.Parent = null; this.tb_NoPickup.Parent = null; this.tb_NoPickup2.Parent = null; TabPage tblPage = null; for (int i = 0; i < dt.Columns.Count; i++) { if (Convert.ToBoolean(dt.Rows[0][i])) { switch ("tb_" + dt.Columns[i].ColumnName.Trim()) { case "tb_NoShot": this.tb_NoShot.Parent = this.tabPanel; tblPage = this.tb_NoShot; break; case "tb_NoShotIn": this.tb_NoShotIn.Parent = this.tabPanel; tblPage = this.tb_NoShotIn; break; case "tb_NoRepair": this.tb_NoRepair.Parent = this.tabPanel; tblPage = this.tb_NoRepair; break; case "tb_NoSelected": this.tb_NoSelected.Parent = this.tabPanel; tblPage = this.tb_NoSelected; break; case "tb_NoSelected2": this.tb_NoSelected2.Parent = this.tabPanel; tblPage = this.tb_NoSelected2; break; case "tb_NoDesign": this.tb_NoDesign.Parent = this.tabPanel; tblPage = this.tb_NoDesign; break; case "tb_NoSend2": this.tb_NoSend2.Parent = this.tabPanel; tblPage = this.tb_NoSend2; break; case "tb_NoLook": this.tb_NoLook.Parent = this.tabPanel; tblPage = this.tb_NoLook; break; case "tb_NoSend": this.tb_NoSend.Parent = this.tabPanel; tblPage = this.tb_NoSend; break; case "tb_NoBack": this.tb_NoBack.Parent = this.tabPanel; tblPage = this.tb_NoBack; break; case "tb_NoPickup": this.tb_NoPickup.Parent = this.tabPanel; tblPage = this.tb_NoPickup; break; case "tb_NoPickup2": this.tb_NoPickup2.Parent = this.tabPanel; tblPage = this.tb_NoPickup2; break; case "tb_SelectNotRefinement": this.tb_SelectNotRefinement.Parent = this.tabPanel; tblPage = this.tb_SelectNotRefinement; break; case "tb_RefinementNotDesign": this.tb_RefinementNotDesign.Parent = this.tabPanel; tblPage = this.tb_RefinementNotDesign; break; } } } this.IsExecute = true; this.tabPanel.SelectedTab = tblPage; this.GetProcessMonitorVisible(); } this.GetProcessMonitorData(); } } /// /// 关闭 /// /// /// void butnColse_Click(object sender, EventArgs e) { this.Close(); } /// /// 员工档期 /// /// /// void butnEmployeeSchedule_Click(object sender, EventArgs e) { LYFZ.Software.MainBusiness.CameraControlBook.SmallForm.A_EmployeeScheduleSmallForm frm = new SmallForm.A_EmployeeScheduleSmallForm(); frm.ShowDialog(); } /// /// 查询 /// /// /// void butnQuery_Click(object sender, EventArgs e) { this.PublicFunctionRows(); } /// /// 时间安排 /// /// /// void butnTimeArrange_Click(object sender, EventArgs e) { bool IsSaveed = false; switch (this.tabPanel.SelectedTab.Name.Trim()) { case "tb_NoShot": if (this.dgvData.Rows.Count > 0) { if (this.dgvData.CurrentCell.ColumnIndex >= 0 && this.dgvData.CurrentRow.Index >= 0) { LYFZ.Software.MainBusiness.CameraControlBook.SmallForm.PhotographedReservationSmallForm frm = new SmallForm.PhotographedReservationSmallForm(); frm.OrdNumber = this.dgvData.CurrentRow.Cells["Ord_Number"].Value.ToString().Trim(); frm.ShowDialog(); IsSaveed = frm.IsSave; } } break; case "tb_NoShotIn": if (this.dgvData.Rows.Count > 0) { if (this.dgvData.CurrentCell.ColumnIndex >= 0 && this.dgvData.CurrentRow.Index >= 0) { LYFZ.Software.MainBusiness.CameraControlBook.SmallForm.PhotographedReservationSmallForm frm = new SmallForm.PhotographedReservationSmallForm(); frm.OrdNumber = this.dgvData.CurrentRow.Cells["Ord_Number"].Value.ToString().Trim(); frm.ShowDialog(); IsSaveed = frm.IsSave; } } break; case "tb_NoRepair": if (this.dgvData.Rows.Count > 0) { if (this.dgvData.CurrentCell.ColumnIndex >= 0 && this.dgvData.CurrentRow.Index >= 0) { LYFZ.Software.MainBusiness.DoorCityProcess.SetSmallForm.AnPaiWorkSmallForm frm = new DoorCityProcess.SetSmallForm.AnPaiWorkSmallForm(); frm.StrViceNumber = "'" + this.dgvData.CurrentRow.Cells["Ordv_ViceNumber"].Value.ToString().Trim() + "'"; frm.ShowDialog(); IsSaveed = frm.IsSave; } } break; case "tb_NoSelected": if (this.dgvData.Rows.Count > 0) { if (this.dgvData.CurrentCell.ColumnIndex >= 0 && this.dgvData.CurrentRow.Index >= 0) { LYFZ.Software.MainBusiness.CameraControlBook.SmallForm.FilmsSelectionReservationSmallForm frm = new SmallForm.FilmsSelectionReservationSmallForm(); frm.OrdViceNumber = this.dgvData.CurrentRow.Cells["Ordv_ViceNumber"].Value.ToString().Trim(); frm.ShowDialog(); IsSaveed = frm.IsSave; } } break; case "tb_NoSelected2": if (this.dgvData.Rows.Count > 0) { if (this.dgvData.CurrentCell.ColumnIndex >= 0 && this.dgvData.CurrentRow.Index >= 0) { LYFZ.Software.MainBusiness.CameraControlBook.SmallForm.FilmsSelectionReservationSmallForm frm = new SmallForm.FilmsSelectionReservationSmallForm(); frm.OrdViceNumber = this.dgvData.CurrentRow.Cells["Ordv_ViceNumber"].Value.ToString().Trim(); frm.ShowDialog(); IsSaveed = frm.IsSave; } } break; case "tb_NoDesign": if (this.dgvData.Rows.Count > 0) { if (this.dgvData.CurrentCell.ColumnIndex >= 0 && this.dgvData.CurrentRow.Index >= 0) { LYFZ.Software.MainBusiness.DoorCityProcess.SetSmallForm.AnPaiWorkSmallForm frm = new LYFZ.Software.MainBusiness.DoorCityProcess.SetSmallForm.AnPaiWorkSmallForm(); frm.StrViceNumber = "'" + this.dgvData.CurrentRow.Cells["Ordv_ViceNumber"].Value.ToString().Trim() + "'"; frm.ShowDialog(); IsSaveed = frm.IsSave; } } break; case "tb_NoSend2": if (this.dgvData.Rows.Count > 0) { if (this.dgvData.CurrentCell.ColumnIndex >= 0 && this.dgvData.CurrentRow.Index >= 0) { LYFZ.Software.MainBusiness.DoorCityProcess.SetSmallForm.AnPaiWorkSmallForm frm = new LYFZ.Software.MainBusiness.DoorCityProcess.SetSmallForm.AnPaiWorkSmallForm(); frm.StrViceNumber = "'" + this.dgvData.CurrentRow.Cells["Ordv_ViceNumber"].Value.ToString().Trim() + "'"; frm.ShowDialog(); IsSaveed = frm.IsSave; } } break; case "tb_NoLook": if (this.dgvData.Rows.Count > 0) { if (this.dgvData.CurrentCell.ColumnIndex >= 0 && this.dgvData.CurrentRow.Index >= 0) { LYFZ.Software.MainBusiness.CameraControlBook.SmallForm.LookDesignReservationSmallForm frm = new SmallForm.LookDesignReservationSmallForm(); frm.OrdViceNumber = this.dgvData.CurrentRow.Cells["Ordv_ViceNumber"].Value.ToString().Trim(); frm.ShowDialog(); IsSaveed = frm.IsSave; } } break; case "tb_NoSend": if (this.dgvData.Rows.Count > 0) { if (this.dgvData.CurrentCell.ColumnIndex >= 0 && this.dgvData.CurrentRow.Index >= 0) { LYFZ.Software.MainBusiness.DoorCityProcess.SetSmallForm.AnPaiWorkSmallForm frm = new LYFZ.Software.MainBusiness.DoorCityProcess.SetSmallForm.AnPaiWorkSmallForm(); frm.StrViceNumber = "'" + this.dgvData.CurrentRow.Cells["Ordv_ViceNumber"].Value.ToString().Trim() + "'"; frm.ShowDialog(); IsSaveed = frm.IsSave; } } break; case "tb_NoBack": break; case "tb_NoPickup": if (this.dgvData.Rows.Count > 0) { if (this.dgvData.CurrentCell.ColumnIndex >= 0 && this.dgvData.CurrentRow.Index >= 0) { LYFZ.Software.MainBusiness.CameraControlBook.SmallForm.TakePiecesReservationSmallForm frm = new SmallForm.TakePiecesReservationSmallForm(); frm.OrdNumber = this.dgvData.CurrentRow.Cells["Ord_Number"].Value.ToString().Trim(); frm.ShowDialog(); IsSaveed = frm.IsSave; } } break; case "tb_NoPickup2": if (this.dgvData.Rows.Count > 0) { if (this.dgvData.CurrentCell.ColumnIndex >= 0 && this.dgvData.CurrentRow.Index >= 0) { LYFZ.Software.MainBusiness.CameraControlBook.SmallForm.TakePiecesReservationSmallForm frm = new SmallForm.TakePiecesReservationSmallForm(); frm.OrdNumber = this.dgvData.CurrentRow.Cells["Ord_Number"].Value.ToString().Trim(); frm.ShowDialog(); IsSaveed = frm.IsSave; } } break; } if (IsSaveed) { this.PublicFunctionRows(); } } /// /// 选项卡选择事件 /// /// /// void tabPanel_SelectedIndexChanged(object sender, EventArgs e) { if (this.IsExecute) { this.butnTimeArrange.Visible = true; if (this.tabPanel.SelectedTab != null) { switch (this.tabPanel.SelectedTab.Name.Trim()) { case "tb_NoShot": this.btnClientServiceAnPai.Visible = true; break; case "tb_NoShotIn": this.btnClientServiceAnPai.Visible = true; break; case "tb_NoRepair": this.btnClientServiceAnPai.Visible = false; break; case "tb_NoSelected": this.btnClientServiceAnPai.Visible = true; break; case "tb_NoSelected2": this.btnClientServiceAnPai.Visible = true; break; case "tb_NoDesign": this.btnClientServiceAnPai.Visible = false; break; case "tb_NoSend2": this.btnClientServiceAnPai.Visible = false; break; case "tb_NoLook": this.btnClientServiceAnPai.Visible = true; break; case "tb_NoSend": this.btnClientServiceAnPai.Visible = false; break; case "tb_NoPickup": case "tb_NoPickup2": this.btnClientServiceAnPai.Visible = true; break; case "tb_NoBack": this.butnTimeArrange.Visible = false; this.btnClientServiceAnPai.Visible = false; break; case "tb_SelectNotRefinement": case "tb_RefinementNotDesign": butnTimeArrange.Visible = false; break; } List hideControl = new List(); //LYFZSS.SystemSpecterPossessed.ISystemSpecterPossessed.GetMySystemSpecter = LYFZSS.SystemSpecterType.SST_D; hideControl.Add(this.btnClientServiceAnPai); LYFZ.Software.MainBusiness.VersionControl.StaticVersion.BindVersionShowHideControl( VersionControl.VersionFunctionEnum.客服中心客服安排, hideControl, null, null); this.GetProcessMonitorVisible(); this.PublicFunctionRows(); } } } /// /// 导出 /// /// /// void btnExport_Click(object sender, EventArgs e) { if (this.tabPanel.SelectedTab != null) { this.dgvData.ExportDataTable(this.tabPanel.SelectedTab.Text.Trim()); } } /// /// 安排客服 /// /// /// void btnClientServiceAnPai_Click(object sender, EventArgs e) { if (this.dgvData.SelectedRows.Count > 0) { LYFZ.Software.MainBusiness.DoorCityProcess.SetSmallForm.ClientServiceTaskAnPaiSmallForm frm = new DoorCityProcess.SetSmallForm.ClientServiceTaskAnPaiSmallForm(); frm.ShowDialog(); if (frm.IsSaveed) { LYFZ.EnumPublic.ClientServiceTaskItem ClientServiceAnPai; switch (this.tabPanel.SelectedTab.Name.Trim()) { case "tb_NoShot": ClientServiceAnPai = EnumPublic.ClientServiceTaskItem.已定未拍; break; case "tb_NoShotIn": ClientServiceAnPai = EnumPublic.ClientServiceTaskItem.已拍未拍完; break; case "tb_NoSelected": ClientServiceAnPai = EnumPublic.ClientServiceTaskItem.已拍未选; break; case "tb_NoSelected2": ClientServiceAnPai = EnumPublic.ClientServiceTaskItem.已修未选; break; case "tb_NoLook": ClientServiceAnPai = EnumPublic.ClientServiceTaskItem.已设计未看; break; case "tb_NoPickup": ClientServiceAnPai = EnumPublic.ClientServiceTaskItem.部分回件未取; break; case "tb_NoPickup2": ClientServiceAnPai = EnumPublic.ClientServiceTaskItem.全部回件未取; break; default: MessageBoxCustom.Show(this.tabPanel.SelectedTab.Text.Trim() + "不是对客户客服，不支持安排客服！"); return; } LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.ClientServiceAnPai(this.dgvData, LYFZ.EnumPublic.ClientServiceTaskType.流程通知, frm.model, ClientServiceAnPai); } } } #endregion #region 文本框事件 /// /// 未回件输入控制 /// /// /// void txtNoBack_KeyPress(object sender, KeyPressEventArgs e) { if (!Char.IsNumber(e.KeyChar) && !Char.IsControl(e.KeyChar)) { e.Handled = true; } } /// /// 未设计输入控制 /// /// /// void txtNoDesign_KeyPress(object sender, KeyPressEventArgs e) { if (!Char.IsNumber(e.KeyChar) && !Char.IsControl(e.KeyChar)) { e.Handled = true; } } /// /// 未看版输入控制 /// /// /// void txtNoLook_KeyPress(object sender, KeyPressEventArgs e) { if (!Char.IsNumber(e.KeyChar) && !Char.IsControl(e.KeyChar)) { e.Handled = true; } } /// /// 未取件输入控制 /// /// /// void txtNoPickup_KeyPress(object sender, KeyPressEventArgs e) { if (!Char.IsNumber(e.KeyChar) && !Char.IsControl(e.KeyChar)) { e.Handled = true; } } /// /// 未修输入控制 /// /// /// void txtNoRepair_KeyPress(object sender, KeyPressEventArgs e) { if (!Char.IsNumber(e.KeyChar) && !Char.IsControl(e.KeyChar)) { e.Handled = true; } } /// /// 已拍未选片输入控制 /// /// /// void txtNoSelected_KeyPress(object sender, KeyPressEventArgs e) { if (!Char.IsNumber(e.KeyChar) && !Char.IsControl(e.KeyChar)) { e.Handled = true; } } /// /// 已修未选片输入控制 /// /// /// void txtNoSelected2_KeyPress(object sender, KeyPressEventArgs e) { if (!Char.IsNumber(e.KeyChar) && !Char.IsControl(e.KeyChar)) { e.Handled = true; } } /// /// 未发送输入控制 /// /// /// void txtNoSend_KeyPress(object sender, KeyPressEventArgs e) { if (!Char.IsNumber(e.KeyChar) && !Char.IsControl(e.KeyChar)) { e.Handled = true; } } /// /// 未拍输入控制 /// /// /// void txtNoShot_KeyPress(object sender, KeyPressEventArgs e) { if (!Char.IsNumber(e.KeyChar) && !Char.IsControl(e.KeyChar)) { e.Handled = true; } } /// /// 未拍完输入控制 /// /// /// void txtNoShotIn_KeyPress(object sender, KeyPressEventArgs e) { if (!Char.IsNumber(e.KeyChar) && !Char.IsControl(e.KeyChar)) { e.Handled = true; } } /// /// 关键字查询 /// /// /// void txtQuery_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { this.butnQuery_Click(this, null); } } /// /// 未拍完回车 /// /// /// void txtNoShotIn_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { this.butnQuery_Click(this, null); } } /// /// 未回件回车 /// /// /// void txtNoBack_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { this.butnQuery_Click(this, null); } } /// /// 未设计回车 /// /// /// void txtNoDesign_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { this.butnQuery_Click(this, null); } } /// /// 未看版回车 /// /// /// void txtNoLook_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { this.butnQuery_Click(this, null); } } /// /// 未取件回车 /// /// /// void txtNoPickup_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { this.butnQuery_Click(this, null); } } /// /// 未修片回车 /// /// /// void txtNoRepair_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { this.butnQuery_Click(this, null); } } /// /// 已拍未选片回车 /// /// /// void txtNoSelected_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { this.butnQuery_Click(this, null); } } /// /// 已修未选片回车 /// /// /// void txtNoSelected2_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { this.butnQuery_Click(this, null); } } /// /// 未发送回车 /// /// /// void txtNoSend_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { this.butnQuery_Click(this, null); } } /// /// 未拍回车 /// /// /// void txtNoShot_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { this.butnQuery_Click(this, null); } } /// /// 文本框离开事件 /// /// /// void txtNoBack_Leave(object sender, EventArgs e) { LYFZ.ComponentLibrary.TextBoxEx txtText = (LYFZ.ComponentLibrary.TextBoxEx)sender; if (txtText.Text.Trim().Length <= 0) { txtText.Text = "0"; } } /// /// 文本框离开事件 /// /// /// void txtNoDesign_Leave(object sender, EventArgs e) { LYFZ.ComponentLibrary.TextBoxEx txtText = (LYFZ.ComponentLibrary.TextBoxEx)sender; if (txtText.Text.Trim().Length <= 0) { txtText.Text = "0"; } } /// /// 文本框离开事件 /// /// /// void txtNoLook_Leave(object sender, EventArgs e) { LYFZ.ComponentLibrary.TextBoxEx txtText = (LYFZ.ComponentLibrary.TextBoxEx)sender; if (txtText.Text.Trim().Length <= 0) { txtText.Text = "0"; } } /// /// 文本框离开事件 /// /// /// void txtNoPickup_Leave(object sender, EventArgs e) { LYFZ.ComponentLibrary.TextBoxEx txtText = (LYFZ.ComponentLibrary.TextBoxEx)sender; if (txtText.Text.Trim().Length <= 0) { txtText.Text = "0"; } } /// /// 文本框离开事件 /// /// /// void txtNoRepair_Leave(object sender, EventArgs e) { LYFZ.ComponentLibrary.TextBoxEx txtText = (LYFZ.ComponentLibrary.TextBoxEx)sender; if (txtText.Text.Trim().Length <= 0) { txtText.Text = "0"; } } /// /// 文本框离开事件 /// /// /// void txtNoSelected_Leave(object sender, EventArgs e) { LYFZ.ComponentLibrary.TextBoxEx txtText = (LYFZ.ComponentLibrary.TextBoxEx)sender; if (txtText.Text.Trim().Length <= 0) { txtText.Text = "0"; } } /// /// 文本框离开事件 /// /// /// void txtNoSelected2_Leave(object sender, EventArgs e) { LYFZ.ComponentLibrary.TextBoxEx txtText = (LYFZ.ComponentLibrary.TextBoxEx)sender; if (txtText.Text.Trim().Length <= 0) { txtText.Text = "0"; } } /// /// 文本框离开事件 /// /// /// void txtNoSend_Leave(object sender, EventArgs e) { LYFZ.ComponentLibrary.TextBoxEx txtText = (LYFZ.ComponentLibrary.TextBoxEx)sender; if (txtText.Text.Trim().Length <= 0) { txtText.Text = "0"; } } /// /// 文本框离开事件 /// /// /// void txtNoShot_Leave(object sender, EventArgs e) { LYFZ.ComponentLibrary.TextBoxEx txtText = (LYFZ.ComponentLibrary.TextBoxEx)sender; if (txtText.Text.Trim().Length <= 0) { txtText.Text = "0"; } } /// /// 文本框离开事件 /// /// /// void txtNoShotIn_Leave(object sender, EventArgs e) { LYFZ.ComponentLibrary.TextBoxEx txtText = (LYFZ.ComponentLibrary.TextBoxEx)sender; if (txtText.Text.Trim().Length <= 0) { txtText.Text = "0"; } } #endregion /// /// 列表双击事件 /// /// /// void dgvData_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (this.dgvData.Columns.Contains("商品备注")) if (e.ColumnIndex == this.dgvData.Columns["商品备注"].Index) { DataGridViewCell cell = this.dgvData.Rows[e.RowIndex].Cells[e.ColumnIndex]; LYFZ.Software.MainBusiness.CameraControlBook.SuperSmallForm.GetTextRemarkSuperSmallForm frm = new CameraControlBook.SuperSmallForm.GetTextRemarkSuperSmallForm(); frm.txtMaxLength = 500; frm.StrValue = cell.Value.ToString().Trim(); frm.IsKeyEnterToOk = false; frm.ShowDialog(); if (frm.IsSaveed) { LYFZ.Model.Model_ErpOrderProductList model = orpbll.DataRowToModel(orbll.GetView_Custom("tb_ErpOrderProductList", StrWhere: "ID = '" + this.dgvData.Rows[e.RowIndex].Cells["PID"].Value + "'", ShowColumnName: "*").Tables[0].Rows[0]); if (model.ID > 0) { model.OPlist_PickupRemark = frm.StrValue.Trim(); model.OPlist_UpdateDateTime = SDateTime.Now; model.OPlist_UpdateName = StrUserID; if (orpbll.Update(model)) { this.dgvData.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = frm.StrValue; } } } } } /// /// 右键菜单 /// /// /// void dgvData_CellMouseDown(object sender, DataGridViewCellMouseEventArgs e) { if (e.Button == MouseButtons.Right) { if (e.RowIndex == -1) { this.dgvData.conMenu.Items.Clear(); ToolStripMenuItem item = new ToolStripMenuItem(); item.Text = "设置标题"; item.Tag = "SetColumnShow"; item.Name = "SetColumnShow"; this.dgvData.conMenu.Items.Add(item); //this.dgvData.conMenu.Show(MousePosition.X, MousePosition.Y);//弹出操作菜单 this.dgvData.conMenu.ItemClicked -= dgvData_DataGridViewConMenu_ItemClicked; this.dgvData.conMenu.ItemClicked += dgvData_DataGridViewConMenu_ItemClicked; // this.dgvData.conMenu.Show(); if (!this.dgvData.conMenu.Visible) { this.dgvData.conMenu.Show(MousePosition.X, MousePosition.Y);//弹出操作菜单 } } else if (e.RowIndex >= 0) { if (this.tabPanel.SelectedTab.Name.Trim() == "tb_NoSend2") { bool IsFind = false; for (int i = 0; i < this.dgvData.SelectedRows.Count; i++) { if (!string.IsNullOrEmpty(this.dgvData.SelectedRows[i].Cells["PID"].Value.ToString().Trim())) { IsFind = true; } } if (IsFind) { this.dgvData.conMenu.Items.Clear(); ToolStripMenuItem item = null; if (this.dgvData.SelectedRows.Count == 1) { if (!string.IsNullOrEmpty(this.dgvData.CurrentRow.Cells[e.ColumnIndex].Value.ToString().Trim())) { item = new ToolStripMenuItem(); item.Text = "复制" + this.dgvData.Columns[e.ColumnIndex].HeaderText; item.Tag = this.dgvData.CurrentRow.Index + "|" + e.ColumnIndex; item.Name = "复制列"; this.dgvData.conMenu.Items.Add(item); } } item = new ToolStripMenuItem(); item.Text = "下次选片显示"; item.Tag = "IsSendOuntRemind"; item.Name = "NextShow"; this.dgvData.conMenu.Items.Add(item); this.dgvData.conMenu.ItemClicked -= dgvData_DataGridViewConMenu_ItemClicked; this.dgvData.conMenu.ItemClicked += dgvData_DataGridViewConMenu_ItemClicked; } } } } } /// /// 右键菜单选择项事件 /// /// /// void dgvData_DataGridViewConMenu_ItemClicked(object sender, ToolStripItemClickedEventArgs e) { ToolStripItem item = e.ClickedItem; switch (item.Name.Trim()) { case "SetColumnShow": if (LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.ShowDataGridViewSetColumn(this.dgvData, StrEnabled: "超出天数")) { this.PublicFunctionRows(); } break; case "NextShow": List clist = new List(); for (int i = 0; i < this.dgvData.SelectedRows.Count; i++) { if (!string.IsNullOrEmpty(this.dgvData.SelectedRows[i].Cells["PID"].Value.ToString().Trim())) { DataTable tbl = orbll.GetView_Custom("tb_ErpOrderDigital", StrWhere: "Ordv_ViceNumber = '" + this.dgvData.SelectedRows[i].Cells["Ordv_ViceNumber"].Value.ToString().Trim() + "'", ShowColumnName: "Ordv_FilmSelectionTime").Tables[0]; LYFZ.Model.Model_ErpOrderProductList model = opbll.GetModel(Convert.ToInt32(this.dgvData.SelectedRows[i].Cells["PID"].Value)); if (tbl.Rows.Count > 0) { if (!string.IsNullOrEmpty(tbl.Rows[0]["Ordv_FilmSelectionTime"].ToString())) { model.OPlist_IsSendOuntRemind = 2; model.OPlist_FilmSelectionTime = Convert.ToDateTime(tbl.Rows[0]["Ordv_FilmSelectionTime"]); } } clist.Add(opbll.GetUpdateCommandInfo(model)); } } if (clist.Count > 0) { if (LYFZ.BLL.BaseBllOperate.ExecuteSqlTran(clist) > 0) { this.PublicFunctionRows(); } else { MessageBoxCustom.Show("放入下次显示失败"); } } break; } } /// /// 点击列标头排序 /// /// /// void dgvData_ColumnHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e) { if (e.Button == MouseButtons.Left) { //if (this.OrderBy_Suffix == 1) //{ this.OrderBy_Suffix = 0; } //else //{ this.OrderBy_Suffix = 1; } //this.OrderBy_Column = this.dgvData.Columns[e.ColumnIndex].Name; this.PublicFunctionRows(); } } /// /// 创建行 /// private void PublicFunctionRows() { try { DataTable newTable = new DataTable(); Dictionary dictColumns = new Dictionary(); string StrQueryCondition = LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetGroupQueryWhere(this.cmbtreevStoreName, "Ord_DividedShop"); if (!string.IsNullOrEmpty(this.txtQuery.Text.Trim())) { StrQueryCondition += LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetQueryTextQueryCondition(this.txtQuery.Text.Trim()); } switch (this.tabPanel.SelectedTab.Name.Trim()) { case "tb_NoShot": this.dgvData.dgvCurrentColumnOriginalSet = "Ord_Number,Ordv_ViceNumber,订单号,客户姓名,客户性别,客户电话,订单类型,接单人,套系名称,套系价格,结婚日期,欠款,超出天数,下单日期,拍摄名称,拍照状态,摄影师,化妆师,引导师,预约时间,宝宝生日,会员余额,客服人员,沟通时间,沟通状态,沟通备注"; string StrGuidNameA = LYFZ.EnumPublic.dgvGuidName.E_FormAll_A0017.ToString().Trim(); this.dgvData.dgvFixedHideColumn = "Ord_Number,Ordv_ViceNumber"; this.dgvData.dgvGuidName = StrGuidNameA; this.dgvData.dgvUserEmployeeID = this.StrUserID; this.dgvData.StrValueNullColumn = "订单号,客户姓名,客户性别,客户电话,订单类型,接单人,套系名称,套系价格,结婚日期,欠款,超出天数,下单日期"; this.dgvData.DataColumns(this.dgvData.dgvCurrentColumnOriginalSet, strHideField: this.dgvData.dgvFixedHideColumn); dictColumns = LYFZ.DAL.DAL_GridViewDisplayIndex.GetGridViewShowColumns(this.StrUserID, StrGuidNameA, this.dgvData.dgvCurrentColumnOriginalSet); this.dgvData.dictShowColumName = dictColumns; string StrQueryConditionA2 = ""; if (string.IsNullOrEmpty(this.txtQuery.Text.Trim())) { StrQueryConditionA2 = " And 超出天数 >= " + this.GetIntInput(this.txtNoShot.Text.Trim()) + ""; } newTable = LYFZ.ComponentLibrary.DataGridOrderView.GetData_ProcessMonitorNotShot(dictColumns, StrQueryCondition, StrQueryConditionA2, StrOrderBy: "Ord_CreateDateTime ASC,Ordv_DigitalNumber"); break; case "tb_NoShotIn": this.dgvData.dgvCurrentColumnOriginalSet = "Ord_Number,Ordv_ViceNumber,订单号,客户姓名,客户性别,客户电话,订单类型,接单人,套系名称,套系价格,结婚日期,欠款,超出天数,开拍日期,拍摄名称,拍照状态,摄影师,化妆师,引导师,预约时间,客服人员,沟通时间,沟通状态,沟通备注"; string StrGuidNameB = LYFZ.EnumPublic.dgvGuidName.E_FormAll_A0044.ToString().Trim(); this.dgvData.dgvFixedHideColumn = "Ord_Number,Ordv_ViceNumber"; this.dgvData.dgvGuidName = StrGuidNameB; this.dgvData.dgvUserEmployeeID = this.StrUserID; this.dgvData.StrValueNullColumn = "订单号,客户姓名,客户性别,客户电话,接单人,订单类型,套系名称,套系价格,结婚日期,欠款,超出天数,开拍日期"; this.dgvData.DataColumns(this.dgvData.dgvCurrentColumnOriginalSet, strHideField: this.dgvData.dgvFixedHideColumn); dictColumns = LYFZ.DAL.DAL_GridViewDisplayIndex.GetGridViewShowColumns(this.StrUserID, StrGuidNameB, this.dgvData.dgvCurrentColumnOriginalSet); this.dgvData.dictShowColumName = dictColumns; string StrQueryConditionB2 = ""; if (string.IsNullOrEmpty(this.txtQuery.Text.Trim())) { StrQueryConditionB2 = " And 超出天数 >= " + this.GetIntInput(this.txtNoShotIn.Text.Trim()) + ""; } newTable = LYFZ.ComponentLibrary.DataGridOrderView.GetData_ProcessMonitorNotShotIn(dictColumns, StrQueryCondition, StrQueryConditionB2, StrOrderBy: "Ords_PhotographMinTime ASC,Ord_Number,Ordv_DigitalNumber"); break; case "tb_NoRepair": this.dgvData.dgvCurrentColumnOriginalSet = "Ord_Number,Ordv_ViceNumber,订单号,客户姓名,客户性别,客户电话,订单类型,接单人,套系名称,套系价格,结婚日期,欠款,超出天数,拍摄时间,拍摄名称,拍照状态,摄影师,初修状态,初修师,预约时间,客服人员,沟通时间,沟通状态,沟通备注"; string StrGuidNameC = LYFZ.EnumPublic.dgvGuidName.E_FormAll_A0018.ToString().Trim(); this.dgvData.dgvFixedHideColumn = "Ord_Number,Ordv_ViceNumber"; this.dgvData.dgvGuidName = StrGuidNameC; this.dgvData.dgvUserEmployeeID = this.StrUserID; this.dgvData.StrValueNullColumn = "订单号,订单类型,客户姓名,客户性别,客户电话,接单人,套系名称,套系价格,结婚日期,欠款"; this.dgvData.DataColumns(this.dgvData.dgvCurrentColumnOriginalSet, strHideField: this.dgvData.dgvFixedHideColumn); dictColumns = LYFZ.DAL.DAL_GridViewDisplayIndex.GetGridViewShowColumns(this.StrUserID, StrGuidNameC, this.dgvData.dgvCurrentColumnOriginalSet); this.dgvData.dictShowColumName = dictColumns; string StrQueryConditionC2 = ""; if (string.IsNullOrEmpty(this.txtQuery.Text.Trim())) { StrQueryConditionC2 = " And 超出天数 >= " + this.GetIntInput(this.txtNoRepair.Text.Trim()) + ""; } newTable = LYFZ.ComponentLibrary.DataGridOrderView.GetData_ProcessMonitorNotRepair(dictColumns, StrQueryCondition, StrQueryConditionC2, StrOrderBy: "Ords_PhotographMaxTime ASC,Ord_Number,Ordv_DigitalNumber"); break; case "tb_NoSelected": this.dgvData.dgvCurrentColumnOriginalSet = "Ord_Number,Ordv_ViceNumber,订单号,客户姓名,客户性别,客户电话,订单类型,接单人,套系名称,套系价格,结婚日期,欠款,超出天数,拍摄时间,拍摄名称,拍照状态,摄影师,选片状态,选片师,预约时间,客服人员,沟通时间,沟通状态,沟通备注"; string StrGuidNameD = LYFZ.EnumPublic.dgvGuidName.E_FormAll_A0019.ToString().Trim(); this.dgvData.dgvFixedHideColumn = "Ord_Number,Ordv_ViceNumber"; this.dgvData.dgvGuidName = StrGuidNameD; this.dgvData.dgvUserEmployeeID = this.StrUserID; this.dgvData.StrValueNullColumn = "订单号,客户姓名,客户性别,客户电话,订单类型,接单人,套系名称,套系价格,结婚日期,欠款"; this.dgvData.DataColumns(this.dgvData.dgvCurrentColumnOriginalSet, strHideField: this.dgvData.dgvFixedHideColumn); dictColumns = LYFZ.DAL.DAL_GridViewDisplayIndex.GetGridViewShowColumns(this.StrUserID, StrGuidNameD, this.dgvData.dgvCurrentColumnOriginalSet); this.dgvData.dictShowColumName = dictColumns; string StrQueryConditionD2 = ""; if (string.IsNullOrEmpty(this.txtQuery.Text.Trim())) { StrQueryConditionD2 = " And 超出天数 >= " + this.GetIntInput(this.txtNoSelected.Text.Trim()) + ""; } newTable = LYFZ.ComponentLibrary.DataGridOrderView.GetData_ProcessMonitorNotSelected(dictColumns, StrQueryCondition, StrQueryConditionD2, StrOrderBy: "Ords_PhotographMaxTime ASC,Ord_Number,Ordv_DigitalNumber"); break; case "tb_NoSelected2": this.dgvData.dgvCurrentColumnOriginalSet = "Ord_Number,Ordv_ViceNumber,订单号,客户姓名,客户性别,客户电话,订单类型,接单人,套系名称,套系价格,结婚日期,欠款,拍摄名称,超出天数,初修日期,初修状态,初修师,选片状态,选片师,预约时间,客服人员,沟通时间,沟通状态,沟通备注"; string StrGuidNameE = LYFZ.EnumPublic.dgvGuidName.E_FormAll_A0020.ToString().Trim(); this.dgvData.dgvFixedHideColumn = "Ord_Number,Ordv_ViceNumber"; this.dgvData.dgvGuidName = StrGuidNameE; this.dgvData.dgvUserEmployeeID = this.StrUserID; this.dgvData.StrValueNullColumn = "订单号,客户姓名,客户性别,客户电话,订单类型,接单人,套系名称,套系价格,结婚日期,欠款"; this.dgvData.DataColumns(this.dgvData.dgvCurrentColumnOriginalSet, strHideField: this.dgvData.dgvFixedHideColumn); dictColumns = LYFZ.DAL.DAL_GridViewDisplayIndex.GetGridViewShowColumns(this.StrUserID, StrGuidNameE, this.dgvData.dgvCurrentColumnOriginalSet); this.dgvData.dictShowColumName = dictColumns; string StrQueryConditionE2 = ""; if (string.IsNullOrEmpty(this.txtQuery.Text.Trim())) { StrQueryConditionE2 = " And 超出天数 >= " + this.GetIntInput(this.txtNoSelected2.Text.Trim()) + ""; } newTable = LYFZ.ComponentLibrary.DataGridOrderView.GetData_ProcessMonitorNotSelected2(dictColumns, StrQueryCondition, StrQueryConditionE2, StrOrderBy: "Ordv_EarlyRepairTime ASC,Ord_Number,Ordv_DigitalNumber"); break; case "tb_NoDesign": this.dgvData.dgvCurrentColumnOriginalSet = "Ord_Number,Ordv_ViceNumber,订单号,客户姓名,客户性别,客户电话,订单类型,接单人,套系名称,套系价格,结婚日期,欠款,拍摄名称,超出天数,选片日期,选片状态,选片师,设计状态,设计师,预约时间,客服人员,沟通时间,沟通状态,沟通备注"; string StrGuidNameF = LYFZ.EnumPublic.dgvGuidName.E_FormAll_A0021.ToString().Trim(); this.dgvData.dgvFixedHideColumn = "Ord_Number,Ordv_ViceNumber"; this.dgvData.dgvGuidName = StrGuidNameF; this.dgvData.dgvUserEmployeeID = this.StrUserID; this.dgvData.StrValueNullColumn = "订单号,客户姓名,客户性别,客户电话,订单类型,接单人,套系名称,套系价格,结婚日期,欠款"; this.dgvData.DataColumns(this.dgvData.dgvCurrentColumnOriginalSet, strHideField: this.dgvData.dgvFixedHideColumn); dictColumns = LYFZ.DAL.DAL_GridViewDisplayIndex.GetGridViewShowColumns(this.StrUserID, StrGuidNameF, this.dgvData.dgvCurrentColumnOriginalSet); this.dgvData.dictShowColumName = dictColumns; string StrQueryConditionF2 = ""; if (string.IsNullOrEmpty(this.txtQuery.Text.Trim())) { StrQueryConditionF2 = " And 超出天数 >= " + this.GetIntInput(this.txtNoDesign.Text.Trim()) + ""; } newTable = LYFZ.ComponentLibrary.DataGridOrderView.GetData_ProcessMonitorNotDesign(dictColumns, StrQueryCondition, StrQueryConditionF2, StrOrderBy: "Ordv_FilmSelectionTime ASC,Ord_Number,Ordv_DigitalNumber"); break; case "tb_NoSend2": this.dgvData.dgvCurrentColumnOriginalSet = "PID,Ord_Number,Ordv_ViceNumber,订单号,客户姓名,客户性别,客户电话,订单类型,接单人,套系名称,套系价格,结婚日期,欠款,拍摄名称,超出天数,选片日期,选片状态,选片师,商品名称,预约时间,发片状态,客服人员,沟通时间,沟通状态,沟通备注,商品备注"; string StrGuidNameG = LYFZ.EnumPublic.dgvGuidName.E_FormAll_A0042.ToString().Trim(); this.dgvData.dgvFixedHideColumn = "PID,Ord_Number,Ordv_ViceNumber"; this.dgvData.dgvGuidName = StrGuidNameG; this.dgvData.dgvUserEmployeeID = this.StrUserID; this.dgvData.StrValueNullColumn = "订单号,客户姓名,客户性别,客户电话,订单类型,接单人,套系名称,套系价格,结婚日期,欠款"; this.dgvData.StrSecondStageNull = "拍摄名称,选片日期,选片状态,选片师,客服人员,沟通时间,沟通状态,沟通备注,超出天数"; this.dgvData.DataColumns(this.dgvData.dgvCurrentColumnOriginalSet, strHideField: this.dgvData.dgvFixedHideColumn); dictColumns = LYFZ.DAL.DAL_GridViewDisplayIndex.GetGridViewShowColumns(this.StrUserID, StrGuidNameG, this.dgvData.dgvCurrentColumnOriginalSet); this.dgvData.dictShowColumName = dictColumns; string StrQueryConditionG2 = ""; if (string.IsNullOrEmpty(this.txtQuery.Text.Trim())) { StrQueryConditionG2 = " And 超出天数 >= " + this.GetIntInput(this.txtNoSend2.Text.Trim()) + ""; } newTable = LYFZ.ComponentLibrary.DataGridOrderView.GetData_ProcessMonitorNotSend2(dictColumns, StrQueryCondition, StrQueryConditionG2, StrOrderBy: "Ordv_FilmSelectionTime ASC,Ord_Number,Ordv_DigitalNumber"); break; case "tb_NoLook": this.dgvData.dgvCurrentColumnOriginalSet = "Ord_Number,Ordv_ViceNumber,订单号,客户姓名,客户性别,客户电话,订单类型,接单人,套系名称,套系价格,结婚日期,欠款,拍摄名称,超出天数,设计日期,设计师,设计状态,看样状态,看样师,预约时间,客服人员,沟通时间,沟通状态,沟通备注"; string StrGuidNameH = LYFZ.EnumPublic.dgvGuidName.E_FormAll_A0022.ToString().Trim(); this.dgvData.dgvFixedHideColumn = "Ord_Number,Ordv_ViceNumber"; this.dgvData.dgvGuidName = StrGuidNameH; this.dgvData.dgvUserEmployeeID = this.StrUserID; this.dgvData.StrValueNullColumn = "订单号,客户姓名,客户性别,客户电话,订单类型,接单人,套系名称,套系价格,结婚日期,欠款"; this.dgvData.DataColumns(this.dgvData.dgvCurrentColumnOriginalSet, strHideField: this.dgvData.dgvFixedHideColumn); dictColumns = LYFZ.DAL.DAL_GridViewDisplayIndex.GetGridViewShowColumns(this.StrUserID, StrGuidNameH, this.dgvData.dgvCurrentColumnOriginalSet); this.dgvData.dictShowColumName = dictColumns; string StrQueryConditionH2 = ""; if (string.IsNullOrEmpty(this.txtQuery.Text.Trim())) { StrQueryConditionH2 = " And 超出天数 >= " + this.GetIntInput(this.txtNoLook.Text.Trim()) + ""; } newTable = LYFZ.ComponentLibrary.DataGridOrderView.GetData_ProcessMonitorNotLook(dictColumns, StrQueryCondition, StrQueryConditionH2, StrOrderBy: "Ordv_DesignerTime ASC,Ord_Number,Ordv_DigitalNumber"); break; case "tb_NoSend": this.dgvData.dgvCurrentColumnOriginalSet = "PID,Ord_Number,Ordv_ViceNumber,订单号,客户姓名,客户性别,客户电话,订单类型,接单人,套系名称,套系价格,结婚日期,欠款,拍摄名称,超出天数,看版日期,看版师,看版状态,商品名称,发片状态,预约时间,客服人员,沟通时间,沟通状态,沟通备注,商品备注"; string StrGuidNameI = LYFZ.EnumPublic.dgvGuidName.E_FormAll_A0023.ToString().Trim(); this.dgvData.dgvFixedHideColumn = "PID,Ord_Number,Ordv_ViceNumber"; this.dgvData.dgvGuidName = StrGuidNameI; this.dgvData.dgvUserEmployeeID = this.StrUserID; this.dgvData.StrValueNullColumn = "订单号,客户姓名,客户性别,客户电话,订单类型,接单人,套系名称,套系价格,结婚日期,欠款"; this.dgvData.StrSecondStageNull = "拍摄名称,看版日期,看版师,看版状态,客服人员,沟通时间,沟通状态,沟通备注,超出天数"; this.dgvData.DataColumns(this.dgvData.dgvCurrentColumnOriginalSet, strHideField: this.dgvData.dgvFixedHideColumn); dictColumns = LYFZ.DAL.DAL_GridViewDisplayIndex.GetGridViewShowColumns(this.StrUserID, StrGuidNameI, this.dgvData.dgvCurrentColumnOriginalSet); this.dgvData.dictShowColumName = dictColumns; string StrQueryConditionI2 = ""; if (string.IsNullOrEmpty(this.txtQuery.Text.Trim())) { StrQueryConditionI2 = " And 超出天数 >= " + this.GetIntInput(this.txtNoSend.Text.Trim()) + ""; } newTable = LYFZ.ComponentLibrary.DataGridOrderView.GetData_ProcessMonitorNotSend(dictColumns, StrQueryCondition, StrQueryConditionI2, StrOrderBy: "Ordv_LookDesignTime ASC,Ord_Number,Ordv_DigitalNumber"); break; case "tb_NoBack": this.dgvData.dgvCurrentColumnOriginalSet = "PID,Ord_Number,Ordv_ViceNumber,订单号,客户姓名,客户性别,客户电话,订单类型,接单人,套系名称,套系价格,结婚日期,欠款,拍摄名称,商品名称,超出天数,发片日期,发片状态,发片师,完成状态,取件状态,取件日期,客服人员,沟通时间,沟通状态,沟通备注,商品备注"; string StrGuidNameJ = LYFZ.EnumPublic.dgvGuidName.E_FormAll_A0024.ToString().Trim(); this.dgvData.dgvFixedHideColumn = "PID,Ord_Number,Ordv_ViceNumber"; this.dgvData.dgvGuidName = StrGuidNameJ; this.dgvData.dgvUserEmployeeID = this.StrUserID; this.dgvData.StrValueNullColumn = "订单号,客户姓名,客户性别,客户电话,订单类型,接单人,套系名称,套系价格,结婚日期,欠款"; this.dgvData.StrSecondStageNull = "拍摄名称,客服人员,沟通时间,沟通状态,沟通备注"; this.dgvData.DataColumns(this.dgvData.dgvCurrentColumnOriginalSet, strHideField: this.dgvData.dgvFixedHideColumn); dictColumns = LYFZ.DAL.DAL_GridViewDisplayIndex.GetGridViewShowColumns(this.StrUserID, StrGuidNameJ, this.dgvData.dgvCurrentColumnOriginalSet); this.dgvData.dictShowColumName = dictColumns; string StrQueryConditionJ2 = ""; if (string.IsNullOrEmpty(this.txtQuery.Text.Trim())) { StrQueryConditionJ2 = " And 超出天数 >= " + this.GetIntInput(this.txtNoBack.Text.Trim()) + ""; } newTable = LYFZ.ComponentLibrary.DataGridOrderView.GetData_ProcessMonitorNotBack(dictColumns, StrQueryCondition, StrQueryConditionJ2, StrOrderBy: "OPlist_SendTime ASC,Ord_Number,Ordv_DigitalNumber"); break; case "tb_NoPickup": this.dgvData.dgvCurrentColumnOriginalSet = "PID,Ord_Number,Ordv_ViceNumber,订单号,客户姓名,客户性别,客户电话,订单类型,接单人,套系名称,套系价格,结婚日期,欠款,拍摄名称,商品名称,超出天数,完成日期,完成状态,完成师,预约时间,客服人员,沟通时间,沟通状态,沟通备注,商品备注"; string StrGuidNameK = LYFZ.EnumPublic.dgvGuidName.E_FormAll_A0025.ToString().Trim(); this.dgvData.dgvFixedHideColumn = "PID,Ord_Number,Ordv_ViceNumber"; this.dgvData.dgvGuidName = StrGuidNameK; this.dgvData.dgvUserEmployeeID = this.StrUserID; this.dgvData.StrValueNullColumn = "订单号,客户姓名,客户性别,客户电话,订单类型,接单人,套系名称,套系价格,结婚日期,欠款"; this.dgvData.StrSecondStageNull = "拍摄名称,客服人员,沟通时间,沟通状态,沟通备注"; this.dgvData.DataColumns(this.dgvData.dgvCurrentColumnOriginalSet, strHideField: this.dgvData.dgvFixedHideColumn); dictColumns = LYFZ.DAL.DAL_GridViewDisplayIndex.GetGridViewShowColumns(this.StrUserID, StrGuidNameK, this.dgvData.dgvCurrentColumnOriginalSet); this.dgvData.dictShowColumName = dictColumns; string StrQueryConditionK2 = ""; if (string.IsNullOrEmpty(this.txtQuery.Text.Trim())) { StrQueryConditionK2 = " And 超出天数 >= " + this.GetIntInput(this.txtNoPickup.Text.Trim()) + ""; } StrQueryCondition += " And Ords_ProductCompletedStatus in (1)"; newTable = LYFZ.ComponentLibrary.DataGridOrderView.GetData_ProcessMonitorNotPickup(dictColumns, StrQueryCondition, StrQueryConditionK2, StrOrderBy: "Ord_Number,Ordv_DigitalNumber,OPlist_CompletedTime ASC"); break; case "tb_NoPickup2": this.dgvData.dgvCurrentColumnOriginalSet = "Ord_Number,Ordv_ViceNumber,订单号,客户姓名,客户电话,订单类型,拍摄名称,超出天数,完成日期,完成状态,预约时间,客服人员,沟通时间,沟通状态,沟通备注"; string StrGuidNameL = LYFZ.EnumPublic.dgvGuidName.E_FormAll_A0046.ToString().Trim(); this.dgvData.dgvFixedHideColumn = "Ord_Number,Ordv_ViceNumber"; this.dgvData.dgvGuidName = StrGuidNameL; this.dgvData.dgvUserEmployeeID = this.StrUserID; this.dgvData.StrValueNullColumn = "订单号,客户姓名,客户电话,订单类型,超出天数"; this.dgvData.DataColumns(this.dgvData.dgvCurrentColumnOriginalSet, strHideField: this.dgvData.dgvFixedHideColumn); dictColumns = LYFZ.DAL.DAL_GridViewDisplayIndex.GetGridViewShowColumns(this.StrUserID, StrGuidNameL, this.dgvData.dgvCurrentColumnOriginalSet); this.dgvData.dictShowColumName = dictColumns; string StrQueryConditionL2 = ""; if (string.IsNullOrEmpty(this.txtQuery.Text.Trim())) { StrQueryConditionL2 = " And 超出天数 >= " + this.GetIntInput(this.txtNoPickup2.Text.Trim()) + ""; } StrQueryCondition += " And Ords_ProductCompletedStatus = '2'"; newTable = LYFZ.ComponentLibrary.DataGridOrderView.GetData_ProcessMonitorNotPickup2(dictColumns, StrQueryCondition, StrQueryConditionL2, StrOrderBy: "Ords_ProductCompletedTime,Ord_Number,Ordv_DigitalNumber"); break; case "tb_SelectNotRefinement": this.dgvData.dgvCurrentColumnOriginalSet = "Ord_Number,Ordv_ViceNumber,订单号,客户姓名,客户性别,客户电话,订单类型,接单人,套系名称,套系价格,结婚日期,欠款,拍摄名称,超出天数,选片日期,选片状态,选片师,精修状态,精修师,预约时间,客服人员,沟通时间,沟通状态,沟通备注"; string StrGuidNameM = "";//LYFZ.EnumPublic.dgvGuidName.E_FormAll_A0046.ToString().Trim(); this.dgvData.dgvFixedHideColumn = "Ord_Number,Ordv_ViceNumber"; this.dgvData.dgvGuidName = StrGuidNameM; this.dgvData.dgvUserEmployeeID = this.StrUserID; this.dgvData.StrValueNullColumn = "订单号,客户姓名,客户电话,订单类型,超出天数"; this.dgvData.DataColumns(this.dgvData.dgvCurrentColumnOriginalSet, strHideField: this.dgvData.dgvFixedHideColumn); dictColumns = LYFZ.DAL.DAL_GridViewDisplayIndex.GetGridViewShowColumns(this.StrUserID, StrGuidNameM, this.dgvData.dgvCurrentColumnOriginalSet); this.dgvData.dictShowColumName = dictColumns; string StrQueryConditionM2 = ""; if (string.IsNullOrEmpty(this.txtQuery.Text.Trim())) { StrQueryConditionM2 = " And 超出天数 >= " + this.GetIntInput(this.txtSelectNotRefinement.Text.Trim()) + ""; } StrQueryCondition += " And Ordv_RefinementStatus = '0'"; newTable = LYFZ.ComponentLibrary.DataGridOrderView.GetData_ProcessMonitorSelectNotRefinement(dictColumns, StrQueryCondition, StrQueryConditionM2, StrOrderBy: "Ordv_FilmSelectionTime,Ord_Number,Ordv_DigitalNumber"); break; case "tb_RefinementNotDesign": this.dgvData.dgvCurrentColumnOriginalSet = "Ord_Number,Ordv_ViceNumber,订单号,客户姓名,客户性别,客户电话,订单类型,接单人,套系名称,套系价格,结婚日期,欠款,拍摄名称,超出天数,精修日期,精修状态,精修师,设计状态,设计师,预约时间,客服人员,沟通时间,沟通状态,沟通备注"; string StrGuidNameN = "";//LYFZ.EnumPublic.dgvGuidName.E_FormAll_A0046.ToString().Trim(); this.dgvData.dgvFixedHideColumn = "Ord_Number,Ordv_ViceNumber"; this.dgvData.dgvGuidName = StrGuidNameN; this.dgvData.dgvUserEmployeeID = this.StrUserID; this.dgvData.StrValueNullColumn = "订单号,客户姓名,客户电话,订单类型,超出天数"; this.dgvData.DataColumns(this.dgvData.dgvCurrentColumnOriginalSet, strHideField: this.dgvData.dgvFixedHideColumn); dictColumns = LYFZ.DAL.DAL_GridViewDisplayIndex.GetGridViewShowColumns(this.StrUserID, StrGuidNameN, this.dgvData.dgvCurrentColumnOriginalSet); this.dgvData.dictShowColumName = dictColumns; string StrQueryConditionN2 = ""; if (string.IsNullOrEmpty(this.txtQuery.Text.Trim())) { StrQueryConditionN2 = " And 超出天数 >= " + this.GetIntInput(this.txtRefinementNotDesign.Text.Trim()) + ""; } StrQueryCondition += " And Ordv_DesignerStatus in ('0') "; newTable = LYFZ.ComponentLibrary.DataGridOrderView.GetData_ProcessMonitorRefinementNotDesign(dictColumns, StrQueryCondition, StrQueryConditionN2, StrOrderBy: "Ordv_RefinementTime,Ord_Number,Ordv_DigitalNumber"); break; } if (newTable.Rows.Count > 0) { switch (this.tabPanel.SelectedTab.Name.Trim()) { case "tb_NoSend2": case "tb_NoSend": case "tb_NoBack": case "tb_NoPickup": //this.dgvData.DataSource(newTable, StrSecondStageNull: this.dgvData.StrSecondStageNull); this.dgvData.UseVirtualMode(newTable, this.dgvData.StrSecondStageNull); break; default: //this.dgvData.DataSource(newTable); this.dgvData.UseVirtualMode(newTable); break; } } else { this.dgvData.DataColumns(string.Join(",", dictColumns.Keys.ToArray()), strHideField: this.dgvData.dgvFixedHideColumn); } if (this.dgvData.Columns.Contains("客户姓名")) { this.dgvData.Columns["客户姓名"].Frozen = true; } if (this.dgvData.Columns.Contains("商品备注")) { this.dgvData.Columns["商品备注"].Width = 300; } this.dgvData.FillLastColumn(); Hashtable htData = new Hashtable(); for (int i = 0; i < newTable.Rows.Count; i++) { htData[newTable.Rows[i]["Ord_Number"].ToString().Trim()] = newTable.Rows[i]["Ord_Number"].ToString().Trim(); } this.dataGridViewStatisticsCount1.LocationX = this.dgvData.RowHeadersWidth; this.dataGridViewStatisticsCount1.CurrenQuantity = htData.Count; this.dataGridViewStatisticsCount1.TotalQuantity = htData.Count; } catch(Exception e) { string err = e.ToString(); } this.dgvData.CellMouseDown += dgvData_CellMouseDown; this.dgvData.CellMouseDown += dgvData_CellMouseDown; this.dgvData.ColumnHeaderMouseClick -= dgvData_ColumnHeaderMouseClick; this.dgvData.ColumnHeaderMouseClick += dgvData_ColumnHeaderMouseClick; } string GetIntInput(string StrText) { if (StrText.Trim().Length > 0) { return StrText.Trim(); } else { return "0"; } } } }