/******************************************************************************* * Copyright(c) 2015 DongkeSoft All rights reserved. / Confidential * 类的信息: * 1.程序名称:F_RPT_030102_1.cs * 2.功能描述:产成品交接汇总表 * 编辑履历: * 作者 日期 版本 修改内容 * 袁新成 2015/4/14 1.00 新建 *******************************************************************************/ using System; using System.Data; using System.Text; using System.Windows.Forms; using Dongke.IBOSS.PRD.Basics.BaseResources; using Dongke.IBOSS.PRD.Basics.DockPanel; using Dongke.IBOSS.PRD.Client.CommonModule; using Dongke.IBOSS.PRD.Client.Controls; using Dongke.IBOSS.PRD.Client.DataModels; using Dongke.IBOSS.PRD.WCF.DataModels; using Dongke.IBOSS.PRD.WCF.Proxys; using Dongke.IBOSS.PRD.WCF.DataModels.PMModule; namespace Dongke.IBOSS.PRD.Client.ReportModule { public partial class F_RPT_030112 : DKDockPanelBase { #region 成员变量 // 窗体的单例模式 private static F_RPT_030112 _instance; //实体类 private RPT030102_SE _rptse = null; private RPT030102_SE _rptse1 = null; // 存储查询条件 private SearchFinishedProductEntity _orderEntity = null; //private SearchFinishedProductEntity _orderEntity2 = null; private SearchFinishedProductEntity _orderCRE = null; #endregion #region 构造函数 public F_RPT_030112() { InitializeComponent(); // 窗体显示的Title this.Text = FormTitles.F_RPT_030112; this.tsbtnAdaptive.Text = ButtonText.TSBTN_ADAPTIVE; this.tsbtnClose.Text = ButtonText.TSBTN_CLOSE; this.btnSearch.Text = ButtonText.BTN_SEARCH; this.btnClearCondition.Text = ButtonText.BTN_CLEARCONDITION; this.gbxCondition.Text = Constant.LABEL_QUERY_CONDITIONS; } #endregion #region 单例模式 /// /// 单例模式,防止重复创建窗体 /// public static F_RPT_030112 Instance { get { if (_instance == null || _instance.IsDisposed) { _instance = new F_RPT_030112(); } return _instance; } } #endregion #region 事件处理 /// /// 窗体加载事件 /// /// /// private void F_RPT_030102_1_Load(object sender, EventArgs e) { try { // 加载权限 FormPermissionManager.FormPermissionControl(this.Name, this, LogInUserInfo.CurrentUser.CurrentUserEntity.UserRightData, LogInUserInfo.CurrentUser.CurrentUserEntity.FunctionData); // 设置表格不自动创建列 this.dgvOrder.AutoGenerateColumns = false; this.dgvOrderDetail.AutoGenerateColumns = false; //this.dtpStartTime.Enabled = false; //this.dtpEndTime.Enabled = false; this.dtpStartTime.Value = DateTime.Now.Date; this.dtpEndTime.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1); this.chkTestMouldFlag.AllItemCheck(); } catch (Exception ex) { // 对异常进行共通处理 ExceptionManager.HandleEventException(this.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex); } } /// /// 窗体关闭事件 /// /// /// private void F_RPT_030102_1_FormClosed(object sender, FormClosedEventArgs e) { _instance = null; } /// /// 关闭按钮 /// /// /// private void tsbtnClose_Click(object sender, EventArgs e) { this.Close(); } /// /// 自动适应列宽 /// /// /// private void tsbtnAdaptive_Click(object sender, EventArgs e) { if (this.tblScrapTotalModule.SelectedIndex == Constant.INT_IS_ZERO) { this.dgvOrder.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells); } else { this.dgvOrderDetail.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells); } } /// /// 查询按钮事件 /// /// /// private void btnSearch_Click(object sender, EventArgs e) { try { GetOrderEntityFromLayout();// 设置查询实体类 if (this.tblScrapTotalModule.SelectedIndex == 0)//交接汇总查询 { //this._orderEntity2 = this._orderEntity; //this.dgvOrder.DataSource = null; //this.dgvOrder.DataSource = this.GetSearchTotalData(); _orderCRE = this._orderEntity; this.GetSearchTotalData(); } else if (this.tblScrapTotalModule.SelectedIndex == 1)//交接明细查询 { this.dgvOrderDetail.DataSource = null; this.dgvOrderDetail.DataSource = this.GetSearchDetailData(); } else if (this.tblScrapTotalModule.SelectedIndex == 2)//交接数量查询 { this.dgvNum.DataSource = null; ClientRequestEntity cre = new ClientRequestEntity(); cre.NameSpace = "R03"; cre.Name = "R030112Num"; cre.Properties["OrderNo"] = this.txtOrderNo.Text.Trim(); cre.Properties["FHUserCode"] = this.txtFHUserCode.Text.Trim(); if (this.chkDateTime.Checked) { cre.Properties["FHTimeStart"] = this.dtpStartTime.Value; cre.Properties["FHTimeEnd"] = this.dtpEndTime.Value; } cre.Properties["GoodsTypeCode"] = scbGoodsType.SearchedValue + ""; cre.Properties["GoodsCode"] = this.txtGoodsCode.Text.Trim(); cre.Properties["GoodsModel"] = this.txtGoodsModel.Text.Trim(); cre.Properties["LogoIDS"] = this.dkLogoSearchBox1.LogoIDS; object[] testMouldFlags = this.chkTestMouldFlag.SelectedValues; if (testMouldFlags.Length == 1) { cre.Properties["TestMouldFlag"] = testMouldFlags[0].ToString(); } ServiceResultEntity resultEntity = DoAsync(() => { return ReportModuleProxy.Service.DoRequest(cre); }); if (resultEntity == null || resultEntity.Data == null || resultEntity.Data.Tables.Count == 0 || resultEntity.Data.Tables[0].Rows.Count == 0) { this.dgvNum.AutoResizeColumns(); return; } else { this.dgvNum.DataSource = resultEntity.Data.Tables[0]; this.dgvNum.ReadOnly = true; this.dgvNum.Rows[0].Selected = true; this.dgvNum.AutoResizeColumns(); } } else if (this.tblScrapTotalModule.SelectedIndex == 3)//型号数量查询 { this.dgvGoodsNum.DataSource = null; ClientRequestEntity cre = new ClientRequestEntity(); cre.NameSpace = "R03"; cre.Name = "R030112GoodsNum"; cre.Properties["OrderNo"] = this.txtOrderNo.Text.Trim(); cre.Properties["FHUserCode"] = this.txtFHUserCode.Text.Trim(); if (this.chkDateTime.Checked) { cre.Properties["FHTimeStart"] = this.dtpStartTime.Value; cre.Properties["FHTimeEnd"] = this.dtpEndTime.Value; } cre.Properties["GoodsTypeCode"] = scbGoodsType.SearchedValue + ""; cre.Properties["GoodsCode"] = this.txtGoodsCode.Text.Trim(); cre.Properties["GoodsModel"] = this.txtGoodsModel.Text.Trim(); cre.Properties["LogoIDS"] = this.dkLogoSearchBox1.LogoIDS; object[] testMouldFlags = this.chkTestMouldFlag.SelectedValues; if (testMouldFlags.Length == 1) { cre.Properties["TestMouldFlag"] = testMouldFlags[0].ToString(); } ServiceResultEntity resultEntity = DoAsync(() => { return ReportModuleProxy.Service.DoRequest(cre); }); if (resultEntity == null || resultEntity.Data == null || resultEntity.Data.Tables.Count == 0 || resultEntity.Data.Tables[0].Rows.Count == 0) { this.dgvGoodsNum.AutoResizeColumns(); return; } else { this.dgvGoodsNum.DataSource = resultEntity.Data.Tables[0]; this.dgvGoodsNum.ReadOnly = true; this.dgvGoodsNum.Rows[0].Selected = true; this.dgvGoodsNum.AutoResizeColumns(); } } else { } } catch (Exception ex) { this.btnSearch.Enabled = true; // 对异常进行共通处理 ExceptionManager.HandleEventException(this.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex); } } /// /// 清空条件按钮事件 /// /// /// private void btnClearCondition_Click(object sender, EventArgs e) { this.txtOrderNo.Clear(); this.txtFHUserCode.Clear(); this.chkDateTime.Checked = false; this.dtpStartTime.Value = DateTime.Now.Date; this.dtpEndTime.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1); this.scbGoodsType.ClearValue(); this.txtGoodsCode.Clear(); this.dkLogoSearchBox1.ClearControl(); this.chkTestMouldFlag.AllItemCheck(); } /// /// 双击单元格事件 /// /// /// private void dgvScrapTotalModule_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { try { //判断是否为空 if (this.dgvOrder.CurrentRow == null) { return; } //获取数据信息 DataRowView row = dgvOrder.CurrentRow.DataBoundItem as DataRowView; //this._orderEntity = _orderCRE; if (row["fhorderid"] == DBNull.Value) { this._orderCRE.OrderID = null; } else { this._orderCRE.OrderID = Convert.ToInt32(row["fhorderid"]); } if (row["goodsid"] == DBNull.Value) { this._orderCRE.GoodsID = null; } else { this._orderCRE.GoodsID = Convert.ToInt32(row["goodsid"]); } if (row["logoid"] == DBNull.Value) { this._orderCRE.LogoID = null; } else { this._orderCRE.LogoID = Convert.ToInt32(row["logoid"]); } this.dgvOrderDetail.DataSource = null; this.tblScrapTotalModule.SelectTab(1); this.dgvOrderDetail.DataSource = GetSearchDetailDataByDouble(); } catch (Exception ex) { this.btnSearch.Enabled = true; this.btnClearCondition.Enabled = true; // 对异常进行共通处理 ExceptionManager.HandleEventException(this.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex); } } /// /// 复选框按钮事件 /// /// /// private void chkDateTime_CheckedChanged(object sender, EventArgs e) { this.dtpStartTime.Enabled = chkDateTime.Checked; this.dtpEndTime.Enabled = chkDateTime.Checked; } #endregion #region 私有方法 /// /// 搜索条件 /// /// private SearchFinishedProductEntity GetOrderEntityFromLayout() { this._orderEntity = new SearchFinishedProductEntity(); this._orderEntity.OrderNo = this.txtOrderNo.Text.Trim(); this._orderEntity.FHUserCode = this.txtFHUserCode.Text.Trim(); if (this.chkDateTime.Checked) { this._orderEntity.FHTimeStart = this.dtpStartTime.Value; this._orderEntity.FHTimeEnd = this.dtpEndTime.Value; } this._orderEntity.GoodsTypeCode = scbGoodsType.SearchedValue + ""; this._orderEntity.GoodsCode = this.txtGoodsCode.Text.Trim(); this._orderEntity.GoodsModel = this.txtGoodsModel.Text.Trim(); this._orderEntity.LogoIDS = this.dkLogoSearchBox1.LogoIDS; object[] testMouldFlags = this.chkTestMouldFlag.SelectedValues; if (testMouldFlags.Length == 1) { _orderEntity.TestMouldFlag = testMouldFlags[0].ToString(); } return this._orderEntity; } /// /// 明细搜索条件 /// /// private void CreateSearchConditionDetail() { this._rptse = new RPT030102_SE(); this._rptse.ProductionLineID = this._rptse1.ProductionLineID; this._rptse.GoodsTypeCode = this._rptse1.GoodsTypeCode; this._rptse.GoodsCode = this._rptse1.GoodsCode; this._rptse.ProcedureIDS = this._rptse1.ProcedureIDS; this._rptse.ScrapDateStart = this._rptse1.ScrapDateStart; this._rptse.ScrapDateEnd = this._rptse1.ScrapDateEnd; this._rptse.ResponProcedureIDS = this._rptse1.ResponProcedureIDS; this._rptse.ResponUserIDS = this._rptse1.ResponUserIDS; this._rptse.CreatUser = this._rptse1.CreatUser; this._rptse.AuditUser = this._rptse1.AuditUser; this._rptse.SpecialRepairFlag = this._rptse1.SpecialRepairFlag; } /// /// 查询损坏汇总表 /// private DataTable GetSearchTotalData() { try { //// 调用服务器端获取数据集 //ServiceResultEntity sre = DoAsync(() => //{ // return ReportModuleProxy.Service.GetRPT0030112SData(this._orderEntity); //} //); //if (sre.Status == Constant.ServiceResultStatus.Success) //{ // if (sre.Data.Tables[0].Rows.Count <= Constant.INT_IS_ZERO) // { // // 提示未查找到数据 // MessageBox.Show(Messages.MSG_CMN_I002, this.Text, // MessageBoxButtons.OK, MessageBoxIcon.Warning); // //清空数据 // return null; // } // return sre.Data.Tables[0]; //} this.dgvOrder.DataSource = null; ClientRequestEntity cre = new ClientRequestEntity(); cre.NameSpace = "R03"; cre.Name = "R030112Sum"; cre.Properties["OrderNo"] = this.txtOrderNo.Text.Trim(); cre.Properties["FHUserCode"] = this.txtFHUserCode.Text.Trim(); if (this.chkDateTime.Checked) { cre.Properties["FHTimeStart"] = this.dtpStartTime.Value; cre.Properties["FHTimeEnd"] = this.dtpEndTime.Value; } cre.Properties["GoodsTypeCode"] = scbGoodsType.SearchedValue + ""; cre.Properties["GoodsCode"] = this.txtGoodsCode.Text.Trim(); cre.Properties["GoodsModel"] = this.txtGoodsModel.Text.Trim(); cre.Properties["LogoIDS"] = this.dkLogoSearchBox1.LogoIDS; object[] testMouldFlags = this.chkTestMouldFlag.SelectedValues; if (testMouldFlags.Length == 1) { cre.Properties["TestMouldFlag"] = testMouldFlags[0].ToString(); } ServiceResultEntity resultEntity = DoAsync(() => { return ReportModuleProxy.Service.DoRequest(cre); }); if (resultEntity == null || resultEntity.Data == null || resultEntity.Data.Tables.Count == 0 || resultEntity.Data.Tables[0].Rows.Count == 0) { this.dgvOrder.AutoResizeColumns(); return null; } else { this.dgvOrder.DataSource = resultEntity.Data.Tables[0]; this.dgvOrder.ReadOnly = true; this.dgvOrder.Rows[0].Selected = true; this.dgvOrder.AutoResizeColumns(); } return null; } catch (Exception ex) { throw ex; } } /// /// 查询损坏明细表 /// private DataTable GetSearchDetailData() { try { // 调用服务器端获取数据集 ServiceResultEntity sre = DoAsync(() => { return ReportModuleProxy.Service.GetRPT0030112DetailSData(this._orderEntity); } ); if (sre.Status == Constant.ServiceResultStatus.Success) { if (sre.Data.Tables[0].Rows.Count <= Constant.INT_IS_ZERO) { // 提示未查找到数据 MessageBox.Show(Messages.MSG_CMN_I002, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); //清空数据 return null; } return sre.Data.Tables[0]; } return null; } catch (Exception ex) { throw ex; } } /// /// 查询损坏明细表 /// private DataTable GetSearchDetailDataByDouble() { try { // 调用服务器端获取数据集 ServiceResultEntity sre = DoAsync(() => { return ReportModuleProxy.Service.GetRPT0030112DetailSData(this._orderCRE); } ); if (sre.Status == Constant.ServiceResultStatus.Success) { if (sre.Data.Tables[0].Rows.Count <= Constant.INT_IS_ZERO) { // 提示未查找到数据 MessageBox.Show(Messages.MSG_CMN_I002, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); //清空数据 return null; } return sre.Data.Tables[0]; } return null; } catch (Exception ex) { throw ex; } } #endregion } }