using System; using System.Collections; using System.Collections.Generic; using System.Data; using System.Dynamic; using System.Linq; using System.Text; namespace LYFZ.Software.MainBusiness.DoorCityProcess { public class frmDigitalArrangement : LYFZ.Software.UI.DoorCityProcess.frmDigitalArrangement { /// /// 是否首次运行 /// bool IsFirstRun = true; /// /// 查询条件 /// private Dictionary DictData = new Dictionary(); /// /// 员工编号 /// string StrUserID = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_EmployeeID; Hashtable htData; Dictionary dictColumns; List earlyRepairColumns = new List(); List refinementColumns = new List(); List designColumns = new List(); List sendColumns = new List(); LYFZ.Model.Model_ErpOrderDigital vmodel=null; LYFZ.Model.Model_ErpOrder model = null; System.Windows.Forms.DataGridViewRow selectRow; string StrSightsName = ""; BLL.BLL_ErpOrdersPhotography bllPhotography = new BLL.BLL_ErpOrdersPhotography(); LYFZ.BLL.BLL_ErpOrder orbll = new BLL.BLL_ErpOrder(); LYFZ.BLL.BLL_ErpOrderDigital orvbll = new BLL.BLL_ErpOrderDigital(); LYFZ.BLL.BLL_ErpOrderDigitalStatus orsbll = new BLL.BLL_ErpOrderDigitalStatus(); /// /// 显示相片集合 /// System.Windows.Forms.ImageList ImageList1 = new System.Windows.Forms.ImageList(); public frmDigitalArrangement() { this.Shown += frmDigitalArrangement_Shown; this.Load += frmDigitalArrangement_Load; this.cbxDropDownList.ComboBoxTreeViewEx_TextChanged += cbxDropDownList_ComboBoxTreeViewEx_TextChanged; //this.PublicFunctionRights(); //this.PublicFunctionRows(); cbxPhotoType.SelectedIndex = 0; labDesign.Click += labDesign_Click; labEarlyRepair.Click += labDesign_Click; labRefineRepair.Click += labDesign_Click; labSendData.Click += labDesign_Click; this.dgvOrderList.CellDoubleClick += dgvOrderList_CellContentDoubleClick; this.dgvOrderList.MouseDoubleClick += dgvOrderList_MouseDoubleClick; /// 查看工作安排 this.btn_ArrangeWork.Click += btn_ArrangeWork_Click; /// 安排工作 this.btn_ViewPai.Click += btn_ViewPai_Click; ///导入原片 this.btnImportOriginalFilm.Click += btnImportOriginalFilm_Click; ///导出原片 this.btnExportOriginalFilm.Click += btnExportOriginalFilm_Click; ///分片 this.btnSlice.Click += btnSlice_Click; ///导出初修 this.btnExportRepair.Click +=btnExportRepair_Click; ///导入初修 this.btnImportRepairFilm.Click += btnImportRepairFilm_Click; ///外发初修 this.btnSendOutRepair.Click += btnSendOutRepair_Click; ///导出选好的片 this.btnExportSelectFilm.Click += btnExportSelectFilm_Click; ///导入精修 this.btnImportRefine.Click += btnImportRefine_Click; ///导出精修 this.btnExportRefine.Click += btnExportRefine_Click; ///外发精修 this.btnSendOutRefine.Click += btnSendOutRefine_Click; ///导出设计 this.btnExportDesign.Click += btnExportDesign_Click; ///导入设计 this.btnImportDesign.Click += btnImportDesign_Click; ///外发统计 this.btnOutDesignStatistics.Click += btnOutDesignStatistics_Click; ///外发设计 this.btnOutDesign.Click += btnOutDesign_Click; this.cbxMyJob.Click += cbxMyJob_Click; this.btn_Query.Click += btn_Query_Click; } void btn_Query_Click(object sender, EventArgs e) { labDesign_Click(null, null); } public void BindPostionSize() { this.StartPosition = System.Windows.Forms.FormStartPosition.Manual; this.Location = new System.Drawing.Point(LYFZ.EnumPublic.FormLocation_X, LYFZ.EnumPublic.FormLocation_Y); this.Size = new System.Drawing.Size(LYFZ.EnumPublic.FormSize_Width, LYFZ.EnumPublic.FormSize_Height); } void cbxMyJob_Click(object sender, EventArgs e) { this.PublicFunctionRights(); this.PublicFunctionRows(); } ///外发设计 void btnOutDesign_Click(object sender, EventArgs e) { if (this.dgvOrderList.Rows.Count > 0) { if (this.dgvOrderList.SelectedRows.Count > 0) { string StrViceNumber = this.dgvOrderList.CurrentRow.Cells["Ordv_ViceNumber"].Value.ToString().Trim(); if (!LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.IsEnterPassword(StrViceNumber)) { return; } LYFZ.Software.MainBusiness.DoorCityProcess.SetSmallForm.OutSendDesignSingleSmallForm frm = new SetSmallForm.OutSendDesignSingleSmallForm(); frm.StrOrdNumber = this.dgvOrderList.CurrentRow.Cells["Ord_Number"].Value.ToString().Trim(); frm.StrOrdViceNumber = this.dgvOrderList.CurrentRow.Cells["Ordv_ViceNumber"].Value.ToString().Trim(); frm.ShowDialog(); if (frm.IsSaveed) { this.PublicFunctionRows(); } } else { MessageBoxCustom.Show("请选择你要操作的订单"); return; } } } ///外发统计 void btnOutDesignStatistics_Click(object sender, EventArgs e) { LYFZ.Software.MainBusiness.DoorCityProcess.SetSmallForm.OutSendDesignStatisticSmallForm frm = new SetSmallForm.OutSendDesignStatisticSmallForm(); frm.ShowDialog(); } ///导入设计 void btnImportDesign_Click(object sender, EventArgs e) { if (this.dgvOrderList.Rows.Count > 0) { if (this.dgvOrderList.SelectedRows.Count > 0) { string ViceName = ""; if (this.dgvOrderList.CurrentRow.Cells["订单类型"].Value.ToString().Trim() == Convert.ToInt32(LYFZ.EnumPublic.OrderType.儿童订单).ToString().Trim()) { if (this.dgvOrderList.Columns["拍摄名称"] != null) { ViceName = this.dgvOrderList.CurrentRow.Cells["拍摄名称"].Value.ToString().Trim(); } } if (BLL.BLL_N8ClientConfig.N8ViewGoEnable) { if (LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.ImportN8UserPiece( this.dgvOrderList.CurrentRow.Cells["Ord_Number"].Value.ToString().Trim(), this.dgvOrderList.CurrentRow.Cells["Ordv_ViceNumber"].Value.ToString().Trim(), ViceName) ) { this.PublicFunctionRows(); } } else { if (this.dgvOrderList.CurrentRow.Cells["取件状态"].Value.ToString().Trim() == "OK") { MessageBoxCustom.Show("已取件,不能导片!"); } LYFZ.Model.Model_ErpOrderDigital _modelDigital = null; if (LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.ImportDesignPiece( this.dgvOrderList.CurrentRow.Cells["Ord_Number"].Value.ToString().Trim(), this.dgvOrderList.CurrentRow.Cells["Ordv_ViceNumber"].Value.ToString().Trim(), ViceName,ref _modelDigital, this.dgvOrderList.CurrentRow.Cells["取件状态"].Value.ToString().Trim())) { this.PublicFunctionRows(); } } } else { MessageBoxCustom.Show("请选择要导入的订单"); return; } } } ///导出设计 void btnExportDesign_Click(object sender, EventArgs e) { if (this.dgvOrderList.Rows.Count > 0) { if (this.dgvOrderList.SelectedRows.Count > 0) { string SightsName = ""; if (this.dgvOrderList.CurrentRow.Cells["订单类型"].Value.ToString().Trim() == Convert.ToInt32(LYFZ.EnumPublic.OrderType.儿童订单).ToString().Trim()) { if (this.dgvOrderList.Columns["拍摄名称"] != null) { SightsName = this.dgvOrderList.CurrentRow.Cells["拍摄名称"].Value.ToString().Trim(); } } if (BLL.BLL_N8ClientConfig.N8ViewGoEnable) { LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.ExportN8Piece( this.dgvOrderList.CurrentRow.Cells["Ord_Number"].Value.ToString().Trim(), this.dgvOrderList.CurrentRow.Cells["Ordv_ViceNumber"].Value.ToString().Trim(), SightsName ); } else { LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.ExportDesignPiece( this.dgvOrderList.CurrentRow.Cells["Ord_Number"].Value.ToString().Trim(), this.dgvOrderList.CurrentRow.Cells["Ordv_ViceNumber"].Value.ToString().Trim(), SightsName ); } } else { MessageBoxCustom.Show("请选择要导出的订单"); return; } } } ///外发精修 void btnSendOutRefine_Click(object sender, EventArgs e) { if (MessageBoxCustom.Show("你确定要外发精修片吗?", "温馨提示", System.Windows.Forms.MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes) { string StrOrdNumber = this.dgvOrderList.CurrentRow.Cells["Ord_Number"].Value.ToString().Trim(); string StrOrdViceNumber = this.dgvOrderList.CurrentRow.Cells["Ordv_ViceNumber"].Value.ToString().Trim(); if (!LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.IsEnterPassword(StrOrdViceNumber)) { return; } LYFZ.Software.MainBusiness.DoorCityProcess.SuperSmallForm.ChooseNameSuperSmallForm frm = new SuperSmallForm.ChooseNameSuperSmallForm(); frm.StrOrdNumber = StrOrdNumber; frm.StrOrdViceNumber = StrOrdViceNumber; frm.orderProcess = EnumPublic.OrderProcessEnum.精修; frm.ShowDialog(); if (frm.IsSaveed) { DateTime strTime = SDateTime.Now; List clist = new List(); DataTable dt = orbll.GetView_Custom("tb_ErpOrderDigitalStatus", StrWhere: "Ords_OrdNumber = '" + StrOrdNumber + "' And Ords_ViceNumber = '" + StrOrdViceNumber + "'", ShowColumnName: "*").Tables[0]; LYFZ.Model.Model_ErpOrderDigitalStatus modelStatus = null; if (dt.Rows.Count > 0) { modelStatus = orsbll.DataRowToModel(dt.Rows[0]); modelStatus.Ords_OutSendRefineRepairName = this.StrUserID; modelStatus.Ords_OutSendRefineRepairStatus = "已发"; modelStatus.Ords_OutSendRefineRepairTime = strTime; modelStatus.Ords_OutSendRefineRepairVendor = frm.htData["StrVendor"].ToString().Trim(); modelStatus.Ords_OutSendRefineRepairVendorQQ = frm.htData["StrQQ"].ToString().Trim(); clist.Add(orsbll.GetUpdateCommandInfo(modelStatus)); } if (clist.Count > 0) { if (LYFZ.BLL.BaseBllOperate.ExecuteSqlTran(clist) > 0) { if (Convert.ToBoolean(frm.htData["StrIsOutSend"]) && frm.htData["StrQQ"].ToString().Trim().Length > 0) { LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.QQCall(frm.htData["StrQQ"].ToString().Trim()); } } else { MessageBoxCustom.Show("操作选择供应商发出失败!"); } } else { MessageBoxCustom.Show("外发失败,可能数码状态表不存在!"); } } } } ///导出精修 void btnExportRefine_Click(object sender, EventArgs e) { if (this.dgvOrderList.Rows.Count > 0) { if (this.dgvOrderList.SelectedRows.Count > 0) { string ViceName = ""; if (this.dgvOrderList.CurrentRow.Cells["订单类型"].Value.ToString().Trim() == Convert.ToInt32(LYFZ.EnumPublic.OrderType.儿童订单).ToString().Trim()) { if (this.dgvOrderList.Columns["拍摄名称"] != null) { ViceName = this.dgvOrderList.CurrentRow.Cells["拍摄名称"].Value.ToString().Trim(); } } string ViceOrderNumber = this.dgvOrderList.CurrentRow.Cells["Ordv_ViceNumber"].Value.ToString().Trim(); LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.ExportRefinedRepairPiece(this.dgvOrderList.CurrentRow.Cells["Ord_Number"].Value.ToString().Trim(), ViceOrderNumber, ViceName); } else { MessageBoxCustom.Show("请选择订单"); return; } } } ///导入精修 void btnImportRefine_Click(object sender, EventArgs e) { if (this.dgvOrderList.Rows.Count > 0) { if (this.dgvOrderList.SelectedRows.Count > 0) { string SightsName = ""; if (this.dgvOrderList.CurrentRow.Cells["订单类型"].Value.ToString().Trim() == Convert.ToInt32(LYFZ.EnumPublic.OrderType.儿童订单).ToString().Trim()) { if (this.dgvOrderList.Columns["拍摄名称"] != null) { SightsName = this.dgvOrderList.CurrentRow.Cells["拍摄名称"].Value.ToString().Trim(); } } if (this.dgvOrderList.CurrentRow.Cells["取件状态"].Value.ToString().Trim() == "OK") { MessageBoxCustom.Show("已取件,不能导片!"); } LYFZ.Model.Model_ErpOrderDigital _modelDigital=null; if (LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.ImportRefinedRepairPiece( this.dgvOrderList.CurrentRow.Cells["Ord_Number"].Value.ToString().Trim(), this.dgvOrderList.CurrentRow.Cells["Ordv_ViceNumber"].Value.ToString().Trim(), SightsName,ref _modelDigital, this.dgvOrderList.CurrentRow.Cells["取件状态"].Value.ToString().Trim())) { this.PublicFunctionRows(); } } else { MessageBoxCustom.Show("请选择订单"); return; } } } void btnExportSelectFilm_Click(object sender, EventArgs e) { if (this.dgvOrderList.Rows.Count > 0) { if (this.dgvOrderList.SelectedRows.Count > 0) { string ViceOrderNumber = this.dgvOrderList.CurrentRow.Cells["Ordv_ViceNumber"].Value.ToString().Trim(); LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.ExportSelectionPiece(this.dgvOrderList.CurrentRow.Cells["Ord_Number"].Value.ToString().Trim(), ViceOrderNumber); } else { MessageBoxCustom.Show("请选择订单"); return; } } } void btnSendOutRepair_Click(object sender, EventArgs e) { if (this.dgvOrderList.Rows.Count > 0) { if (this.dgvOrderList.SelectedRows.Count > 0) { string StrOrdViceNumber = this.dgvOrderList.CurrentRow.Cells["Ordv_ViceNumber"].Value.ToString().Trim(); if (!LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.IsEnterPassword(StrOrdViceNumber)) { return; } if (MessageBoxCustom.Show("你确定要外发初修片吗?", "温馨提示", System.Windows.Forms.MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes) { string StrOrdNumber = this.dgvOrderList.CurrentRow.Cells["Ord_Number"].Value.ToString().Trim(); LYFZ.Software.MainBusiness.DoorCityProcess.SuperSmallForm.ChooseNameSuperSmallForm frm = new SuperSmallForm.ChooseNameSuperSmallForm(); frm.StrOrdNumber = StrOrdNumber; frm.StrOrdViceNumber = StrOrdViceNumber; frm.orderProcess = EnumPublic.OrderProcessEnum.初修; frm.ShowDialog(); if (frm.IsSaveed) { DateTime strTime = SDateTime.Now; List clist = new List(); DataTable dt = orbll.GetView_Custom("tb_ErpOrderDigitalStatus", StrWhere: "Ords_OrdNumber = '" + StrOrdNumber + "' And Ords_ViceNumber = '" + StrOrdViceNumber + "'", ShowColumnName: "*").Tables[0]; LYFZ.Model.Model_ErpOrderDigitalStatus modelStatus = null; if (dt.Rows.Count > 0) { modelStatus = orsbll.DataRowToModel(dt.Rows[0]); modelStatus.Ords_OutSendEarlyRepairName = this.StrUserID; modelStatus.Ords_OutSendEarlyRepairStatus = "已发"; modelStatus.Ords_OutSendEarlyRepairTime = strTime; modelStatus.Ords_OutSendEarlyRepairVendor = frm.htData["StrVendor"].ToString().Trim(); modelStatus.Ords_OutSendEarlyRepairVendorQQ = frm.htData["StrQQ"].ToString().Trim(); clist.Add(orsbll.GetUpdateCommandInfo(modelStatus)); } if (clist.Count > 0) { if (LYFZ.BLL.BaseBllOperate.ExecuteSqlTran(clist) > 0) { if (Convert.ToBoolean(frm.htData["StrIsOutSend"]) && frm.htData["StrQQ"].ToString().Trim().Length > 0) { LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.QQCall(frm.htData["StrQQ"].ToString().Trim()); } } else { MessageBoxCustom.Show("操作选择供应商发出失败!"); } } else { MessageBoxCustom.Show("外发失败,可能数码状态表不存在!"); } } } } } } void btnImportRepairFilm_Click(object sender, EventArgs e) { if (this.dgvOrderList.Rows.Count > 0) { if (this.dgvOrderList.SelectedRows.Count > 0) { string SightsName = ""; if (this.dgvOrderList.CurrentRow.Cells["订单类型"].Value.ToString().Trim() == Convert.ToInt32(LYFZ.EnumPublic.OrderType.儿童订单).ToString().Trim()) { if (this.dgvOrderList.Columns["拍摄名称"] != null) { SightsName = this.dgvOrderList.CurrentRow.Cells["拍摄名称"].Value.ToString().Trim(); } } if (this.dgvOrderList.CurrentRow.Cells["取件状态"].Value.ToString().Trim() == "OK") { MessageBoxCustom.Show("已取件,不能导片!"); } LYFZ.Model.Model_ErpOrderDigital _modelDigital = null; if (LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.ImportRepairPiece( this.dgvOrderList.CurrentRow.Cells["Ord_Number"].Value.ToString().Trim(), this.dgvOrderList.CurrentRow.Cells["Ordv_ViceNumber"].Value.ToString().Trim(), SightsName, ref _modelDigital, this.dgvOrderList.CurrentRow.Cells["取件状态"].Value.ToString().Trim())) { this.PublicFunctionRows(); } } else { MessageBoxCustom.Show("请选择订单"); return; } } } /// /// 熬出修片 /// /// /// private void btnExportRepair_Click(object sender, EventArgs e) { if (this.dgvOrderList.Rows.Count > 0) { if (this.dgvOrderList.SelectedRows.Count > 0) { try { System.Windows.Forms.FolderBrowserDialog fbd = new System.Windows.Forms.FolderBrowserDialog(); string ViceOrderNumber = this.dgvOrderList.CurrentRow.Cells["Ordv_ViceNumber"].Value.ToString().Trim();//数码编号 LYFZ.Model.Model_ErpOrder ord_model = orbll.GetModel("Ord_Number", this.dgvOrderList.CurrentRow.Cells["Ord_Number"].Value); LYFZ.Model.Model_ErpOrderDigital vmodel = orvbll.GetModel("Ordv_ViceNumber", ViceOrderNumber);// LYFZ.BLL.SelectPhotoHandling sPh = new BLL.SelectPhotoHandling(ord_model, vmodel); string ViceName = ""; if (this.dgvOrderList.CurrentRow.Cells["订单类型"].Value.ToString().Trim() == Convert.ToInt32(LYFZ.EnumPublic.OrderType.儿童订单).ToString().Trim()) { try { ViceName = this.dgvOrderList.CurrentRow.Cells["拍摄名称"].Value.ToString().Trim(); } catch { } } List sPhotoList = sPh.GetSpecifyTypePhotoList(Model.Model_ErpOrder.DirectoryType.EarlyRetouch, BLL.SelectPhotoHandling.PhotoType.Original, ViceName); if (sPhotoList.Count == 0) { MessageBoxCustom.Show("此单未导片"); return; } if (!LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.IsEnterPassword(ViceOrderNumber)) { return; } //显示对话框 if (fbd.ShowDialog() == System.Windows.Forms.DialogResult.OK) { bool IsImp = false; LYFZ.ComponentLibrary.FrmLoadHandling.ExecutionDoWorkMethod(delegate(object obj, System.ComponentModel.BackgroundWorker backgroundWorker) { LYFZ.PhotoSelectSystem.PhotoImportExport pe = new PhotoSelectSystem.PhotoImportExport(ord_model, vmodel); IsImp = pe.ExportEarlyRetouchFilm(fbd.SelectedPath.ToString().Trim(), backgroundWorker); }, width: 500); if (!IsImp) { return; } else { MessageBoxCustom.Show("导出完毕"); return; } } } catch { MessageBoxCustom.Show("导片出错"); } } else { MessageBoxCustom.Show("请选择订单"); return; } } } /// /// 分片 /// /// /// void btnSlice_Click(object sender, EventArgs e) { if (this.dgvOrderList.Rows.Count > 0) { if (this.dgvOrderList.SelectedRows.Count > 0) { string ViceOrderNumber = this.dgvOrderList.CurrentRow.Cells["Ordv_ViceNumber"].Value.ToString().Trim();//数码编号 if (!LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.IsEnterPassword(ViceOrderNumber)) { return; } LYFZ.Model.Model_ErpOrder model = orbll.GetModel("Ord_Number", this.dgvOrderList.CurrentRow.Cells["Ord_Number"].Value); LYFZ.Model.Model_ErpOrderDigital vmodel = orvbll.GetModel("Ordv_ViceNumber", ViceOrderNumber);// LYFZ.PhotoSelectSystem.PhotoCategory frm = new PhotoSelectSystem.PhotoCategory(model, vmodel); if (!frm.IsDisposed) { frm.ShowDialog(); } } } else { MessageBoxCustom.Show("请选择订单"); } } ///导出初修 void btnExportOriginalFilm_Click(object sender, EventArgs e) { if (this.dgvOrderList.Rows.Count > 0) { if (this.dgvOrderList.SelectedRows.Count > 0) { string StrSightsName = ""; string ViceOrderNumber = this.dgvOrderList.CurrentRow.Cells["Ordv_ViceNumber"].Value.ToString().Trim(); if (this.dgvOrderList.CurrentRow.Cells["订单类型"].Value.ToString().Trim() == Convert.ToInt32(LYFZ.EnumPublic.OrderType.儿童订单).ToString().Trim()) { if (this.dgvOrderList.Columns["拍摄名称"] != null) { StrSightsName = this.dgvOrderList.CurrentRow.Cells["拍摄名称"].Value.ToString().Trim(); } } LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.ExportOriginalPiece(this.dgvOrderList.CurrentRow.Cells["Ord_Number"].Value.ToString().Trim(), ViceOrderNumber, StrSightsName); } else { MessageBoxCustom.Show("请选择订单"); return; } } } ///导入原片 void btnImportOriginalFilm_Click(object sender, EventArgs e) { if (this.dgvOrderList.Rows.Count > 0) { string JID = ""; string MainOrderNumber = this.dgvOrderList.CurrentRow.Cells["Ord_Number"].Value.ToString().Trim();//主订单号 string ViceOrderNumber = this.dgvOrderList.CurrentRow.Cells["Ordv_ViceNumber"].Value.ToString().Trim();//副订单号 DataTable photographyDt = bllPhotography.GetPhotographySightByViceNumber(ViceOrderNumber); if (photographyDt.Rows.Count>0) { JID = photographyDt.Rows[0]["ID"].ToString_s(); } #region 抓数据 if (this.dgvOrderList.SelectedRows.Count <= 0) { MessageBoxCustom.Show("请选择要导入的景点"); return; } if (string.IsNullOrEmpty(JID)) { MessageBoxCustom.Show("此单无景点,不能导片!"); return; } #endregion //选择拍摄相关人员 LYFZ.Software.MainBusiness.DoorCityProcess.SuperSmallForm.OfficersConfirmSuperSmallForm frm = new SuperSmallForm.OfficersConfirmSuperSmallForm(); frm.OrdNumber = MainOrderNumber; frm.OrdViceNumber = ViceOrderNumber; frm.JID = JID; frm.SightsName = this.dgvOrderList.CurrentRow.Cells["拍摄名称"].Value.ToString().Trim(); if (this.dgvOrderList.CurrentRow.Cells["取件状态"].Value.ToString().Trim() == "OK") { MessageBoxCustom.Show("已取件,不能导片!"); frm.rdoYes1.Enabled = false; frm.rdoNo1.Checked = true; } frm.ShowDialog(); this.PublicFunctionRows(); } } /// /// 查看工作安排 /// /// /// void btn_ViewPai_Click(object sender, EventArgs e) { LYFZ.Software.MainBusiness.DoorCityProcess.SetSmallForm.AnPaiWorkDigitalSmallForm frm = new SetSmallForm.AnPaiWorkDigitalSmallForm(); frm.Text = "数码部工作安排"; frm.ShowDialog(); } /// /// 安排工作 /// /// /// void btn_ArrangeWork_Click(object sender, EventArgs e) { if (this.dgvOrderList.Rows.Count > 0) { if (dgvOrderList.SelectedRows.Count > 0) { try { if (this.dgvOrderList.CurrentRow.Cells["拍摄状态"].Value.ToString().Trim() != "OK") { MessageBoxCustom.Show("拍照流程未完成"); return; } } catch { } string strVid = ""; for (int i = 0; i < dgvOrderList.SelectedRows.Count; i++) { if (i == 0) { strVid += "'" + dgvOrderList.SelectedRows[i].Cells["Ordv_ViceNumber"].Value.ToString().Trim() + "'"; } else { strVid += ",'" + dgvOrderList.SelectedRows[i].Cells["Ordv_ViceNumber"].Value.ToString().Trim() + "'"; } } LYFZ.Software.MainBusiness.DoorCityProcess.SetSmallForm.AnPaiWorkSmallForm frm = new SetSmallForm.AnPaiWorkSmallForm(); frm.StrViceNumber = strVid; frm.ShowDialog(); if (frm.IsSave == true) { this.PublicFunctionRows(); } } else { MessageBoxCustom.Show("请选择订单"); } } } void dgvOrderList_MouseDoubleClick(object sender, System.Windows.Forms.MouseEventArgs e) { System.Drawing.Point hit = this.dgvOrderList.PointToClient(System.Windows.Forms.Cursor.Position); System.Windows.Forms.DataGridView.HitTestInfo hitTest = this.dgvOrderList.HitTest(hit.X, hit.Y); if (hitTest.RowIndex < 0 && hitTest.ColumnIndex < 0) { if (!string.IsNullOrEmpty(LYFZ.BLL.BLL_ErpOrder.CurrentSelectedOrderNumber)) { LYFZ.BLL.BLL_ErpOrder.CurrentSelectedOrderNumber = ""; PublicFunctionRows(); } } } void frmDigitalArrangement_Load(object sender, EventArgs e) { this.ImageList1.Images.Clear(); this.ImageList1.ColorDepth = System.Windows.Forms.ColorDepth.Depth32Bit; this.ImageList1.ImageSize = new System.Drawing.Size(95, 100); this.ImageList1.Images.Add(LYFZ.PhotoSelectSystem.MainPhotoSelect.ImageJPGE); this.PhotoListView.LargeImageList = ImageList1; this.PhotoListView.View = System.Windows.Forms.View.LargeIcon; this.cbxPhotoType.SelectedIndexChanged += cbxPhotoType_SelectedIndexChanged; gbDesign.Enabled = true; gbPhoto.Enabled = true; gbRefine.Enabled = true; gbRepair.Enabled = true; //this.dgvOrderList.VirtualMode = true; //this.dgvOrderList.CellValueNeeded += dgvOrderList_CellValueNeeded; } void dgvOrderList_CellValueNeeded(object sender, System.Windows.Forms.DataGridViewCellValueEventArgs e) { //throw new NotImplementedException(); } void cbxPhotoType_SelectedIndexChanged(object sender, EventArgs e) { SelectPhotoTypeGetPhotoData(); } void dgvOrderList_CellContentDoubleClick(object sender, System.Windows.Forms.DataGridViewCellEventArgs e) { if(e.RowIndex<0) { return; } string ViceOrderNumber = this.dgvOrderList.Rows[e.RowIndex].Cells["Ordv_ViceNumber"].Value.ToString(); string MainOrderNumber = this.dgvOrderList.Rows[e.RowIndex].Cells["Ord_Number"].Value.ToString(); StrSightsName = this.dgvOrderList.Rows[e.RowIndex].Cells["拍摄名称"].Value.ToString(); selectRow = this.dgvOrderList.Rows[e.RowIndex]; LYFZ.PhotoSelectSystem.EventSelectPhotoPrint eventSelectPhotoPrint = null; LYFZ.BLL.BLL_ErpOrderDigital mydbll = new LYFZ.BLL.BLL_ErpOrderDigital(); LYFZ.BLL.BLL_ErpOrder obll = new BLL.BLL_ErpOrder(); LYFZ.ComponentLibrary.FrmLoadHandling.LoadDoWorkMethod(delegate(object obj, System.ComponentModel.BackgroundWorker backgroundWorker) { backgroundWorker.ReportProgress(0, "正在获取相应数据...."); vmodel = mydbll.GetModel("Ordv_ViceNumber", ViceOrderNumber); model = obll.GetModel("Ord_Number", MainOrderNumber); eventSelectPhotoPrint = LYFZ.PhotoSelectSystem.frmSaveSelectPhotoInfo.GetStaticSelectPhotoPrint(model, vmodel); }); this.dgvPackage.Rows.Clear(); List ptlist = eventSelectPhotoPrint.MakingProductList; if (ptlist.Count > 0) { for (int i = 0; i < ptlist.Count; i++) { LYFZ.PhotoSelectSystem.MakingProduct mpdt = ptlist[i]; LYFZ.Model.Model_ErpOrderProductList mdl = mpdt.OrderProduct; System.Windows.Forms.DataGridViewRow row = new System.Windows.Forms.DataGridViewRow(); System.Windows.Forms.DataGridViewTextBoxCell cell = new System.Windows.Forms.DataGridViewTextBoxCell(); cell.Value = mdl.OPlist_ProdName; row.Cells.Add(cell); cell = new System.Windows.Forms.DataGridViewTextBoxCell(); cell.Value = mdl.OPlist_Batch.ToString().Trim(); row.Cells.Add(cell); cell = new System.Windows.Forms.DataGridViewTextBoxCell(); cell.Value = mdl.OPlist_ProdQuantity.ToString().Trim(); row.Cells.Add(cell); cell = new System.Windows.Forms.DataGridViewTextBoxCell(); cell.Value = mdl.OPlist_IsExpedited ? "加急件" : "普通件"; ; row.Cells.Add(cell); cell = new System.Windows.Forms.DataGridViewTextBoxCell(); cell.Value = mdl.OPlist_PickupTime == null ? "" : mdl.OPlist_PickupTime.Value.ToString("yyyy-MM-dd"); row.Cells.Add(cell); cell = new System.Windows.Forms.DataGridViewTextBoxCell(); cell.Value = mdl.OPlist_PickUpType; row.Cells.Add(cell); cell = new System.Windows.Forms.DataGridViewTextBoxCell(); cell.Value = mdl.OPlist_Remark; row.Cells.Add(cell); int photoCount = 0; string StrPhoto = eventSelectPhotoPrint.GetSelectProductPhotoNameString(mdl.OPlist_UniquelyIdentity.ToString(), ref photoCount);//所用照片 cell = new System.Windows.Forms.DataGridViewTextBoxCell(); cell.Value = StrPhoto; row.Cells.Add(cell); this.dgvPackage.Rows.Add(row); } } SelectPhotoTypeGetPhotoData(); //SetFunctionButton(); } void SetFunctionButton() { if(!selectRow.Cells["拍照状态"].Value.ToString().Contains("OK")) { this.gbPhoto.Enabled = true; } else { this.gbPhoto.Enabled = false; } if (!selectRow.Cells["初修状态"].Value.ToString().Contains("OK")) { this.gbRepair.Enabled = true; } else { this.gbRepair.Enabled = false; } if (!selectRow.Cells["精修状态"].Value.ToString().Contains("OK")) { this.gbRefine.Enabled = true; } else { this.gbRefine.Enabled = false; } if (!selectRow.Cells["设计状态"].Value.ToString().Contains("OK")) { this.gbDesign.Enabled = true; } else { this.gbDesign.Enabled = false; } } public void SelectPhotoTypeGetPhotoData() { this.ImageList1.Images.Clear(); this.PhotoListView.Items.Clear(); LYFZ.Model.Model_ErpOrder.DirectoryType _dirType = Model.Model_ErpOrder.DirectoryType.PrimitivePicture; switch (cbxPhotoType.Text.Replace(" ","")) { case "原片": _dirType = Model.Model_ErpOrder.DirectoryType.PrimitivePicture; break; case "初修": _dirType = Model.Model_ErpOrder.DirectoryType.EarlyRetouch; break; case "精修": _dirType = Model.Model_ErpOrder.DirectoryType.FineRetouch; break; case "设计": _dirType = Model.Model_ErpOrder.DirectoryType.DesignPiece; break; } if(vmodel!=null&&model!=null) { GetPhotoData(model, vmodel, _dirType, StrSightsName); } } public void GetPhotoData(LYFZ.Model.Model_ErpOrder _model, LYFZ.Model.Model_ErpOrderDigital _vmodel, LYFZ.Model.Model_ErpOrder.DirectoryType _dirType, string _StrSightsName) { LYFZ.ComponentLibrary.FrmLoadHandling.LoadDoWorkMethod(delegate(object obj, System.ComponentModel.BackgroundWorker backgroundWorker) { backgroundWorker.ReportProgress(0, "正在获取照片信息...."); LYFZ.BLL.SelectPhotoHandling sPh = new BLL.SelectPhotoHandling(_model, _vmodel); if (model.Ord_Type != "1") { StrSightsName = ""; } List photoList = sPh.GetSpecifyTypePhotoList(_dirType, BLL.SelectPhotoHandling.PhotoType.Small, _StrSightsName); for (int i = 0; i < photoList.Count; i++) { string PhotoPath = photoList[i].Trim(); string PreviewPath = LYFZ.BLL.SelectPhotoHandling.SmallPathToPreviewPath(PhotoPath); if (!this.ImageList1.Images.ContainsKey(PreviewPath)) { System.Drawing.Image smallImage = LYFZ.ImageFunction.ImageOperation.GetNewBitmap(PhotoPath); this.Invoke(new LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.UpdateControl(delegate() { this.ImageList1.Images.Add(PreviewPath, smallImage); this.PhotoListView.Items.Add(System.IO.Path.GetFileName(PreviewPath).Replace("Preview_", ""), i); //RefreshShowPhotoImageList(); })); } } }); } void labDesign_Click(object sender, EventArgs e) { //Dictionary tempColumns = new Dictionary(); List drList = new List(); DataTable orderDataList = htData["DTable"] as DataTable; List tempOrdValue = new List(); if(labSendData.Checked) { //DataRow[] tempDrList = orderDataList.Select(" Ord_Number in ('" + string.Join("','", sendColumns.Keys.ToArray()) + "') "); //foreach(string key in sendColumns) //{ // if(!tempColumns.ContainsKey(key)) // { // tempColumns.Add(key,""); // } //} if (sendColumns.Count == 0) { tempOrdValue.Add("-1"); } else { tempOrdValue.AddRange(sendColumns); } //drList.AddRange(tempDrList); } if (labDesign.Checked) { //DataRow[] tempDrList = orderDataList.Select(" Ord_Number in ('" + string.Join("','", designColumns.Keys.ToArray()) + "') "); //drList.AddRange(tempDrList); //foreach (string key in designColumns) //{ // if (!tempColumns.ContainsKey(key)) // { // tempColumns.Add(key, ""); // } //} if (designColumns.Count == 0) { tempOrdValue.Add("-1"); } else { tempOrdValue.AddRange(designColumns); } } if (this.labRefineRepair.Checked) { //DataRow[] tempDrList = orderDataList.Select(" Ord_Number in ('" + string.Join("','", refinementColumns.Keys.ToArray()) + "') "); //drList.AddRange(tempDrList); //foreach (string key in refinementColumns) //{ // if (!tempColumns.ContainsKey(key)) // { // tempColumns.Add(key, ""); // } //} //if (tempColumns.Count == 0) //{ // tempColumns.Add("-1", ""); //} if (refinementColumns.Count == 0) { tempOrdValue.Add("-1"); } else { tempOrdValue.AddRange(refinementColumns); } } if (labEarlyRepair.Checked) { //DataRow[] tempDrList = orderDataList.Select(" Ord_Number in ('" + string.Join("','", earlyRepairColumns.Keys.ToArray()) + "') "); //drList.AddRange(tempDrList); //foreach (string key in earlyRepairColumns) //{ // if (!tempColumns.ContainsKey(key)) // { // tempColumns.Add(key, ""); // } //} //if (tempColumns.Count == 0) //{ // tempColumns.Add("-1", ""); //} if (earlyRepairColumns.Count == 0) { tempOrdValue.Add("-1"); } else { tempOrdValue.AddRange(earlyRepairColumns); } } tempOrdValue = tempOrdValue.GroupBy(t => t).Select(t => t.First()).ToList(); if (orderDataList.Rows.Count > 0 && (tempOrdValue.Count > 0 || !string.IsNullOrEmpty(txt_QueryText.Text))) { DataTable dtList = new DataTable(); LYFZ.ComponentLibrary.FrmLoadHandling.LoadDoWorkMethod(delegate(object obj, System.ComponentModel.BackgroundWorker backgroundWorker) { //DataRow[] tempDrList = orderDataList.Select(" Ord_Number in ('" + string.Join("','", tempColumns.Keys.ToArray()) + "') "); if (tempOrdValue.Count > 0 && string.IsNullOrEmpty(txt_QueryText.Text)) { dtList = orderDataList.AsEnumerable().Where(p => tempOrdValue.Contains(p.Field("Ord_Number"))).CopyToDataTable(); } else { dtList = orderDataList.AsEnumerable().Where(p => (p.Field("Ord_Number") == txt_QueryText.Text || p.Field("客户电话").IndexOf(txt_QueryText.Text) != -1 || p.Field("客户姓名").IndexOf(txt_QueryText.Text) != -1)).CopyToDataTable(); } }); if (dtList.Rows.Count > 0) { //foreach (DataColumn colum in tempDrList[0].Table.Columns) //{ // dtList.Columns.Add(colum.ColumnName); //} //foreach (DataRow dr in tempDrList) //{ // DataRow tempDr = dtList.NewRow(); // foreach (DataColumn colum in dtList.Columns) // { // tempDr[colum.ColumnName] = dr[colum.ColumnName]; // } // dtList.Rows.Add(tempDr); //} LYFZ.ComponentLibrary.DataGridOrderView.GetData_ReplaceDigitalArrange(dgvOrderList, dictColumns, dtList, dtList.Rows.Count); } else { dgvOrderList.Rows.Clear(); } } else { LYFZ.ComponentLibrary.DataGridOrderView.GetData_ReplaceDigitalArrange(dgvOrderList, dictColumns, orderDataList, orderDataList.Rows.Count); } } void cbxDropDownList_ComboBoxTreeViewEx_TextChanged(object sender, System.Windows.Forms.TreeViewEventArgs e) { this.PublicFunctionRights(); this.PublicFunctionRows(); } void frmDigitalArrangement_Shown(object sender, EventArgs e) { LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindGroupStoreName(this.cbxDropDownList, StrGroupKeyCode: "retailProcess", StrKeyCode: "st014"); PublicFunctionRights(); this.PublicFunctionRows(); } /// /// 选择分店获取权限 /// void PublicFunctionRights() { ///我的工作权限 this.btn_ArrangeWork.Enabled = LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetGroupStoreRights(this.cbxDropDownList, "StoresDigital", LYFZ.CustomAttributes.OperatingAuthority.AnPaiWork); this.btn_ViewPai.Enabled = LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetGroupStoreRights(this.cbxDropDownList, "StoresDigital", LYFZ.CustomAttributes.OperatingAuthority.SeeAnPaiWork); ///设计权限 this.btnImportDesign.Enabled = LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetGroupStoreRights(this.cbxDropDownList, "StoresDesign", LYFZ.CustomAttributes.OperatingAuthority.PhotoImport); this.btnExportDesign.Enabled = LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetGroupStoreRights(this.cbxDropDownList, "StoresDesign", LYFZ.CustomAttributes.OperatingAuthority.PhotoExport); ///拍照 this.btnImportOriginalFilm.Enabled = LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetGroupStoreRights(this.cbxDropDownList, "StoresPhotograph", LYFZ.CustomAttributes.OperatingAuthority.PhotoImport); ///初修 this.btnExportOriginalFilm.Enabled = LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetGroupStoreRights(this.cbxDropDownList, "StoresPhotograph", LYFZ.CustomAttributes.OperatingAuthority.PhotoExport); this.btnImportRepairFilm.Enabled = LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetGroupStoreRights(this.cbxDropDownList, "StoresRepairPiece", LYFZ.CustomAttributes.OperatingAuthority.PhotoImport); this.btnExportRepair.Enabled = LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetGroupStoreRights(this.cbxDropDownList, "StoresRepairPiece", LYFZ.CustomAttributes.OperatingAuthority.PhotoExport); //this.btnViewRepairedPiece.Enabled = LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetGroupStoreRights(this.cbxDropDownList, "StoresRepairPiece", LYFZ.CustomAttributes.OperatingAuthority.PhotoView); this.btnSlice.Enabled = LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetGroupStoreRights(this.cbxDropDownList, "StoresRepairPiece", LYFZ.CustomAttributes.OperatingAuthority.RepairPieceSeparatePhoto); ///精修 this.btnExportSelectFilm.Enabled = LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetGroupStoreRights(this.cbxDropDownList, "StoresFilmSelection", LYFZ.CustomAttributes.OperatingAuthority.PhotoExport); this.btnImportRefine.Enabled = LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetGroupStoreRights(this.cbxDropDownList, "StoresRefinedRepair", LYFZ.CustomAttributes.OperatingAuthority.PhotoImport); this.btnExportRefine.Enabled = LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetGroupStoreRights(this.cbxDropDownList, "StoresRefinedRepair", LYFZ.CustomAttributes.OperatingAuthority.PhotoExport); //this.btnViewRefinedPiece.Enabled = LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetGroupStoreRights(this.cbxDropDownList, "StoresRefinedRepair", LYFZ.CustomAttributes.OperatingAuthority.PhotoView); } /// /// 当前点击的字段 /// string StrCurrentClickField = ""; /// /// 排序字段 /// string StrSortField = "Ord_CreateDateTime DESC,Ordv_DigitalNumber"; /// /// 排序顺序 /// string StrSortOrder = "DESC"; /// /// 创建行 /// void PublicFunctionRows() { this.dgvOrderList.Rows.Clear(); this.dgvPackage.Rows.Clear(); this.ImageList1.Images.Clear(); this.PhotoListView.Items.Clear(); this.dgvOrderList.dgvCurrentColumnOriginalSet = "Ord_Number,Ordv_ViceNumber,Ordv_EarlyRepairStatus,Ordv_RefinementStatus,Ordv_DesignerStatus,订单号,客户姓名,客户性别,客户电话,婚期,订单类型,接单人,套系名称,套系价格,加急,加急日期,拍摄名称,拍照状态,初修状态,初修日期,选片状态,选片日期,精修状态,精修日期,设计状态,设计日期,看版状态,看版日期,取件状态,会员卡号,发片状态"; string StrGuidName = ""; if ((LYFZ.BLL.BLL_SystemGlobalSetting.SysTemGlobalSetMoel.MemberCardShowHide)) { this.dgvOrderList.dgvFixedHideColumn = "Ord_Number,Ordv_ViceNumber,会员卡号,发片状态,Ordv_EarlyRepairStatus,Ordv_RefinementStatus,Ordv_DesignerStatus"; } else { this.dgvOrderList.dgvFixedHideColumn = "Ord_Number,Ordv_ViceNumber,发片状态,Ordv_EarlyRepairStatus,Ordv_RefinementStatus,Ordv_DesignerStatus"; } this.dgvOrderList.dgvGuidName = StrGuidName; this.dgvOrderList.dgvUserEmployeeID = this.StrUserID; this.dgvOrderList.StrValueNullColumn = "订单号,客户姓名,客户性别,客户电话,婚期,订单类型,接单人,套系名称,套系价格,加急,加急日期,会员卡号"; this.dgvOrderList.DataColumns(this.dgvOrderList.dgvCurrentColumnOriginalSet, strHideField: this.dgvOrderList.dgvFixedHideColumn); dictColumns = LYFZ.DAL.DAL_GridViewDisplayIndex.GetGridViewShowColumns(this.StrUserID, StrGuidName, this.dgvOrderList.dgvCurrentColumnOriginalSet); this.dgvOrderList.dictShowColumName = dictColumns; string StrQueryCondition = ""; LYFZ.ComponentLibrary.CheckBoxEx checkBox = new ComponentLibrary.CheckBoxEx() { Checked = false }; if (IsFirstRun && !string.IsNullOrEmpty(LYFZ.BLL.BLL_ErpOrder.CurrentSelectedOrderNumber)) { string StrWhere = " Where (Ords_PhotographIntStatus in (1,2)) And Ord_Class = '1' And Ord_SinceOrderNumber = '" + LYFZ.BLL.BLL_ErpOrder.CurrentSelectedOrderNumber + "'" + LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetVersionQuerySQL(checkBox, checkBox, checkBox, StrOrdType: "0,1,2"); StrQueryCondition = StrWhere + (this.cbxDropDownList.Tag.ToString()==""?"": LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetGroupQueryOrderClickWhere(this.cbxDropDownList, "Ord_DividedShop")); } else { StrQueryCondition = this.GetWhereStr(); } int intTopCount =10000; htData = LYFZ.ComponentLibrary.DataGridOrderView.GetData_OrderDigitalArrange(this.dgvOrderList, dictColumns, StrQueryCondition, intTopCount, StrSortField,1); BindPublicFunction(); } void BindPublicFunction() { int earlyRepairCount = 0; int refinementCount = 0; int designCount = 0; int sendCount = 0; earlyRepairColumns.Clear(); refinementColumns.Clear(); designColumns.Clear(); sendColumns.Clear(); this.tempPanelEx1.Visible = true; System.Threading.Thread thread = new System.Threading.Thread(new System.Threading.ParameterizedThreadStart(delegate(object obj) { DataTable orderDataList = htData["DTable"] as DataTable; earlyRepairColumns = orderDataList.AsEnumerable().Where(p => p.Field("Ordv_EarlyRepairStatus") == "0" || p.Field("Ordv_EarlyRepairStatus") == "1").Select(p => p.Field("Ord_Number")).ToList(); refinementColumns = orderDataList.AsEnumerable().Where(p => p.Field("Ordv_RefinementStatus") == "0" || p.Field("Ordv_RefinementStatus") == "1").Select(p => p.Field("Ord_Number")).ToList(); designColumns = orderDataList.AsEnumerable().Where(p => p.Field("Ordv_DesignerStatus") == "0" || p.Field("Ordv_DesignerStatus") == "1").Select(p => p.Field("Ord_Number")).ToList(); sendColumns = orderDataList.AsEnumerable().Where(p => p.Field("发片状态") == 1).Select(p => p.Field("Ord_Number")).ToList(); //foreach (DataRow dr in orderDataList.Rows) //{ // string ordNumber = dr["Ord_Number"].ToString_s(); // if (!earlyRepairColumns.ContainsKey(ordNumber)) // { // DataRow[] dtList = orderDataList.Select(" Ord_Number = '" + ordNumber + "' and Ordv_EarlyRepairStatus in ('0','1') "); // if (dtList.Length > 0) // { // if (!earlyRepairColumns.ContainsKey(ordNumber)) // { // earlyRepairColumns.Add(ordNumber, "1"); // } // } // } // if (!refinementColumns.ContainsKey(ordNumber)) // { // DataRow[] dtList = orderDataList.Select(" Ord_Number = '" + ordNumber + "' and Ordv_RefinementStatus in ('0','1') "); // if (dtList.Length > 0) // { // if (!refinementColumns.ContainsKey(ordNumber)) // { // refinementColumns.Add(ordNumber, "1"); // } // } // } // if (!designColumns.ContainsKey(ordNumber)) // { // DataRow[] dtList = orderDataList.Select(" Ord_Number = '" + ordNumber + "' and Ordv_DesignerStatus in ('0','1') "); // if (dtList.Length > 0) // { // if (!designColumns.ContainsKey(ordNumber)) // { // designColumns.Add(ordNumber, "1"); // } // } // } // if (!sendColumns.ContainsKey(ordNumber)) // { // DataRow[] dtList = orderDataList.Select(" Ord_Number = '" + ordNumber + "' and 发片状态 in ('1') "); // if (dtList.Length > 0) // { // if (!sendColumns.ContainsKey(ordNumber)) // { // sendColumns.Add(ordNumber, "1"); // } // } // } //} labEarlyRepair.Text = "初修(" + earlyRepairColumns.Count + ")"; labDesign.Text = "设计(" + designColumns.Count + ")"; labRefineRepair.Text = "精修(" + refinementColumns.Count + ")"; labSendData.Text = "发片(" + sendColumns.Count + ")"; })); thread.Start(); } /// /// 返回要操作的条件 /// /// string GetWhereStr() { LYFZ.ComponentLibrary.CheckBoxEx checkBox = new ComponentLibrary.CheckBoxEx() { Checked = false }; string StrWhere = " Where (Ords_PhotographIntStatus in (1,2) or Ordv_EarlyRepairStatus in ('1','2')) And Ord_Class = '1' " + LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetGroupQueryWhere(this.cbxDropDownList, "Ord_DividedShop"); if (DictData.ContainsKey("PhotographyStatus") && DictData["PhotographyStatus"].Trim().Length > 0) { StrWhere += " and Ords_PhotographStatus = '" + DictData["PhotographyStatus"].Trim() + "'"; } if (DictData.ContainsKey("EarlyRepairStatus") && DictData["EarlyRepairStatus"].Trim().Length > 0) { StrWhere += " and Ordv_EarlyRepairStatus = '" + DictData["EarlyRepairStatus"].Trim() + "'"; } if (DictData.ContainsKey("FilmSelectionStatus") && DictData["FilmSelectionStatus"].Trim().Length > 0) { StrWhere += " and Ordv_FilmSelectionStatus = '" + DictData["FilmSelectionStatus"].Trim() + "'"; } if (DictData.ContainsKey("RefinementStatus") && DictData["RefinementStatus"].Trim().Length > 0) { StrWhere += " and Ordv_RefinementStatus = '" + DictData["RefinementStatus"].Trim() + "'"; } if (DictData.ContainsKey("DesignStatus") && DictData["DesignStatus"].Trim().Length > 0) { StrWhere += " and Ordv_DesignerStatus = '" + DictData["DesignStatus"].Trim() + "'"; } if (DictData.ContainsKey("LookDesignStatus") && DictData["LookDesignStatus"].Trim().Length > 0) { StrWhere += " and Ordv_LookDesignStatus = '" + DictData["LookDesignStatus"].Trim() + "'"; } StrWhere += " And Ords_ProductPickupIntStatus in (0,1)"; StrWhere += LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetVersionQuerySQL( checkBox, checkBox, checkBox, StrOrdType: "0,1,2"); if (DictData.ContainsKey("FilmSelectionStartDateTime") && DictData["FilmSelectionStartDateTime"].Length > 0 && DictData.ContainsKey("FilmSelectionEndDateTime") && DictData["FilmSelectionEndDateTime"].Length > 0) { StrWhere += LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetDateTime("isnull(Ordv_FilmSelectionTime,Ordv_ReservationFilmSelectionTime)", DictData["FilmSelectionStartDateTime"], DictData["FilmSelectionEndDateTime"]); } if (DictData.ContainsKey("LookDesignStartDateTime") && DictData["LookDesignStartDateTime"].Length > 0 && DictData.ContainsKey("LookDesignEndDateTime") && DictData["LookDesignEndDateTime"].Length > 0) { StrWhere += LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetDateTime("isnull(Ordv_LookDesignTime,Ordv_ReservationLookDesignTime)", DictData["LookDesignStartDateTime"].Trim(), DictData["LookDesignEndDateTime"].Trim()); } if (cbxMyJob.Checked) { string tempStrWhere = ""; if (!labEarlyRepair.Checked && !labRefineRepair.Checked && !labDesign.Checked && !labSendData.Checked) { tempStrWhere += " Ordv_ReservationEarlyRepairName = '" + StrUserID + "' "; tempStrWhere += " or "; tempStrWhere += " Ordv_ReservationRefinementName = '" + StrUserID + "' "; tempStrWhere += " or "; tempStrWhere += " Ordv_ReservationDesignerName = '" + StrUserID + "' "; tempStrWhere += " or "; tempStrWhere += " Ordv_ReservationSendPhotoName = '" + StrUserID + "' "; } if (labEarlyRepair.Checked) { if (!string.IsNullOrEmpty(tempStrWhere)) { tempStrWhere += " or "; } tempStrWhere += " Ordv_ReservationEarlyRepairName = '" + StrUserID + "' "; } if (labRefineRepair.Checked) { if (!string.IsNullOrEmpty(tempStrWhere)) { tempStrWhere += " or "; } tempStrWhere += " Ordv_ReservationRefinementName = '" + StrUserID + "' "; } if (labDesign.Checked) { if (!string.IsNullOrEmpty(tempStrWhere)) { tempStrWhere += " or "; } tempStrWhere += " Ordv_ReservationDesignerName = '" + StrUserID + "' "; } if(labSendData.Checked) { if (!string.IsNullOrEmpty(tempStrWhere)) { tempStrWhere += " or "; } tempStrWhere += " Ordv_ReservationSendPhotoName = '" + StrUserID + "' "; } if (!string.IsNullOrEmpty(tempStrWhere)) { if (!string.IsNullOrEmpty(StrWhere)) { StrWhere += " and "; } StrWhere += "( " + tempStrWhere + " )"; } } return StrWhere; } } }