/******************************************************************************* * Copyright(c) 2015 DongkeSoft All rights reserved. / Confidential * 类的信息: * 1.程序名称:F_RPT_030106.cs * 2.功能描述:成检缺陷汇总表 * 编辑履历: * 作者 日期 版本 修改内容 * 王鑫 2015/06/13 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; namespace Dongke.IBOSS.PRD.Client.ReportModule { public partial class F_RPT_030106 : DKDockPanelBase { #region 成员变量 // 窗体的单例模式 private static F_RPT_030106 _instance; //实体类 private RPT030106_SE rptse = null; private RPT030106_SE rptsed = null; //默认清空工序,重置回用户当前权限工序 private string _currentUserPurview = null; //默认清空生产线,重置回用户当前权限生产线 private string _currentUserLinePuview = null; //默认清空查看工号,重置回用户当前权限工号 private string _currentUserCodePuview = null; #endregion #region 构造函数 public F_RPT_030106() { InitializeComponent(); // 窗体显示的Title this.Text = FormTitles.F_RPT_030106; 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_030106 Instance { get { if (_instance == null || _instance.IsDisposed) { _instance = new F_RPT_030106(); } return _instance; } } #endregion #region 事件处理 /// /// 窗体加载事件 /// /// /// private void F_RPT_030106_Load(object sender, EventArgs e) { try { // 加载权限 FormPermissionManager.FormPermissionControl(this.Name, this, LogInUserInfo.CurrentUser.CurrentUserEntity.UserRightData, LogInUserInfo.CurrentUser.CurrentUserEntity.FunctionData); // 设置表格不自动创建列 this.dgvReportModuleDetail.AutoGenerateColumns = false; this.dgvReportModule.AutoGenerateColumns = false; this.dgvDefectDetail.AutoGenerateColumns = false; //this.dkproductionLineSearchBox.IsEnablePurview = true; //this.dkProcedureSearchBox.IsEnablePurview = true; //this.dkOrganizationSearchBox.Focus(); // 初始化时间控件为当前日期 this.dtpAccountDateStart.Value = DateTime.Now.Date; this.dtpAccountDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1); this.dtpHandOverStart.Value = DateTime.Now.Date; this.dtpHandOverEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1); this.dtpCompleteDateStart.Value = DateTime.Now.Date; this.dtpCompleteDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1); this.dtpCheckDateStart.Value = DateTime.Now.Date; this.dtpCheckDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1); //getPurview(); //getPurviewLine(); // 交接工序 ServiceResultEntity sresource = ReportModuleProxy.Service.GetRptProcedureModule(); if (sresource != null && sresource.Data != null && sresource.Data.Tables.Count > 0) { this.dropRptProcedure.DataSource = sresource.Data.Tables[0]; this.dropRptProcedure.ValueMember = "Rptprocedureid"; this.dropRptProcedure.DisplayMember = "Rptprocedurename"; } } catch (Exception ex) { // 对异常进行共通处理 ExceptionManager.HandleEventException(this.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex); } } /// /// 自动适应列宽 /// /// /// private void tsbtnAdaptive_Click(object sender, EventArgs e) { this.dgvReportModule.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells); this.dgvReportModuleDetail.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells); this.dgvDefectDetail.AutoResizeColumns(); this.dgvProDetail.AutoResizeColumns(); } /// /// 窗体关闭事件 /// /// /// private void F_RPT_030106_FormClosed(object sender, FormClosedEventArgs e) { _instance = null; } /// /// 关闭按钮 /// /// /// private void tsbtnClose_Click(object sender, EventArgs e) { this.Close(); } /// /// 查询按钮事件 /// /// /// private void btnSearch_Click(object sender, EventArgs e) { try { //没有对应的生产线权限,返回 因为有无责任工序,则可以不用分配工序的权限,不分配,只能查无责任工序 //if (string.IsNullOrEmpty(this._currentUserLinePuview)) //{ // // 提示未查找到数据 // MessageBox.Show(Messages.MSG_CMN_I002, this.Text, // MessageBoxButtons.OK, MessageBoxIcon.Information); // return; //} // 交接工序必须输入项 if (this.dropRptProcedure.SelectedValue == null) { MessageBox.Show(Messages.MSG_CMN_W005, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1); return; } // 登记时间与交接时间必须选择一个 if ((!this.chkCdate.Checked && (this.chkCheckDate.Enabled && !this.chkCheckDate.Checked)) && !this.chkHandOver.Checked) { MessageBox.Show("(缺陷)登记时间与交接时间至少选择一个作为查询条件。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1); return; } CreateSearchCondition(); if (this.tblReportModule.SelectedIndex == Constant.INT_IS_ZERO) { rptsed = rptse; this.dgvReportModule.DataSource = null; this.dgvReportModule.DataSource = GetSearchTotalData(); } else if (this.tblReportModule.SelectedIndex == 1) { this.dgvReportModuleDetail.DataSource = null; this.dgvReportModuleDetail.DataSource = GetSearchDetailData(); } else if (this.tblReportModule.SelectedIndex == 2) { this.dgvDefectDetail.DataSource = null; this.dgvDefectDetail.DataSource = GetSearchDefectData(); } else { if (string.IsNullOrEmpty(this.dkProcedureSearchBox1.ProcedureIDS)) { MessageBox.Show("最少选择一个【生产工序】。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1); this.dkProcedureSearchBox1.Focus(); return; } this.dgvProDetail.DataSource = null; this.dgvProDetail.DataSource = GetSearchProData(); } } 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 btnClearCondition_Click(object sender, EventArgs e) { this.scbGoods.ClearValue(); this.scbGoodsType.ClearValue(); this.dkProcedureSearchBox.ClearControl(); this.dkProcedureSearchBox1.ClearControl(); this.dkproductionLineSearchBox.ClearControl(); this.dkDefectTypeNameSearchBox1.ClearControl(); this.dtpAccountDateStart.Value = DateTime.Now.Date; this.dtpAccountDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1); this.dtpHandOverStart.Value = DateTime.Now.Date; this.dtpHandOverEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1); this.dtpCompleteDateStart.Value = DateTime.Now.Date; this.dtpCompleteDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1); this.dtpCheckDateStart.Value = DateTime.Now.Date; this.dtpCheckDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1); this.chkCdate.Checked = true; this.chkHandOver.Checked = false; this.chkCheckDate.Checked = false; this.dkCompleteProcedure.ClearControl(); this.dkCheckProcedureSearchBox.ClearControl(); this.txtKilnCode.Clear(); this.txtDefectUserCode.Text = ""; this.txtDefectCode.Text = ""; this.txtCheckUserCode.Text = ""; this.txtDefectName.Text = ""; this.txtGoodsCode.Text = ""; this.dkProcedureSearchBox.ProcedureIDS = this._currentUserPurview; this.dkproductionLineSearchBox.ProductionLineIDS = this._currentUserLinePuview; if (this.dropRptProcedure.Items.Count > 0) { this.dropRptProcedure.SelectedIndex = 0; } } /// /// 双击单元格事件 /// /// /// private void dgvReportModule_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { try { if (this.dgvReportModule.CurrentRow == null) { return; } //获取数据信息 DataGridViewRow dgvr = dgvReportModule.CurrentRow; string defectCode = dgvr.Cells["DefectCode"].Value.ToString(); string defectProcedureName = dgvr.Cells["DefectProcedureName"].Value.ToString(); string productionlinename = dgvr.Cells["Productionlinename"].Value.ToString(); if (defectCode.Equals("小计") || defectProcedureName.Equals("合计") || productionlinename.Equals("总计")) { return; } else { //跳转页 this.tblReportModule.SelectTab(1); //获取条件 CreateSearchCondition(); string procedureId = dgvr.Cells["Procedureid"].Value.ToString(); string defectProcedureID = dgvr.Cells["DefectProcedureID"].Value.ToString(); string goodsCode = dgvr.Cells["Goodscode"].Value.ToString(); string usercode1 = dgvr.Cells["Usercode1"].Value.ToString(); rptse.CheckProcedureIDS = procedureId.ToString(); rptse.DefectProcedureIDS = defectProcedureID; rptse.DefectCode = null; rptse.GoodsCode = null; rptse.CheckUserCode = null; rptse.DefectCodeS2D = defectCode; rptse.GoodsCodeS2D = goodsCode; rptse.CheckUserCodeS2D = usercode1; //清空数据 this.dgvReportModuleDetail.DataSource = null; this.dgvReportModuleDetail.DataSource = GetSearchDetailData(); } } 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 chkCdate_CheckedChanged(object sender, EventArgs e) { this.dtpAccountDateStart.Value = DateTime.Now.Date; this.dtpAccountDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1); this.dtpAccountDateStart.Enabled = this.chkCdate.Checked; this.dtpAccountDateEnd.Enabled = this.chkCdate.Checked; } private void chkHandOver_CheckedChanged(object sender, EventArgs e) { this.dtpHandOverStart.Value = DateTime.Now.Date; this.dtpHandOverEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1); this.dtpHandOverStart.Enabled = this.chkHandOver.Checked; this.dtpHandOverEnd.Enabled = this.chkHandOver.Checked; } private void chkCheckDate_CheckedChanged(object sender, EventArgs e) { this.dtpCheckDateStart.Value = DateTime.Now.Date; this.dtpCheckDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1); this.dtpCheckDateStart.Enabled = this.chkCheckDate.Checked; this.dtpCheckDateEnd.Enabled = this.chkCheckDate.Checked; } private void tblReportModule_SelectedIndexChanged(object sender, EventArgs e) { if (tblReportModule.SelectedIndex == 2 || tblReportModule.SelectedIndex == 3) { this.chkCheckDate.Enabled = true; this.dtpCheckDateStart.Enabled = this.chkCheckDate.Checked; this.dtpCheckDateEnd.Enabled = this.chkCheckDate.Checked; } else { this.chkCheckDate.Enabled = false; this.dtpCheckDateStart.Enabled = false; this.dtpCheckDateEnd.Enabled = false; } } #endregion #region 私有方法 /// /// 搜索条件 /// /// private void CreateSearchCondition() { rptse = new RPT030106_SE(); rptse.GoodsTypeCode = scbGoodsType.SearchedValue + ""; rptse.LineIDS = this.dkproductionLineSearchBox.ProductionLineIDS; rptse.DefectProcedureIDS = this.dkProcedureSearchBox.ProcedureIDS; //rptse.PurViewUserCodeIDS = this._currentUserCodePuview;//默认查看对应权限工号 if (this.chkCdate.Checked) { rptse.CreateTimeStart = DateTime.Parse(this.dtpAccountDateStart.Value.ToString("yyyy-MM-dd HH:mm") + ":00"); rptse.CreateTimeEnd = DateTime.Parse(this.dtpAccountDateEnd.Value.ToString("yyyy-MM-dd HH:mm") + ":59"); } rptse.DefectTypeIDS = this.dkDefectTypeNameSearchBox1.DefectTypeIDS; rptse.DefectUserCode = this.txtDefectUserCode.Text.Trim(); rptse.CheckUserCode = this.txtCheckUserCode.Text.Trim(); rptse.DefectCode = this.txtDefectCode.Text.Trim(); rptse.DefectName = this.txtDefectName.Text.Trim(); rptse.GoodsCode = this.txtGoodsCode.Text.Trim(); rptse.GoodsIDS = scbGoods.CheckedPKMember; if (this.dropRptProcedure.SelectedValue != null) { rptse.HandOverProcedureID = Convert.ToInt32(this.dropRptProcedure.SelectedValue); } if (this.chkHandOver.Checked) { rptse.HandOverTimeStart = DateTime.Parse(this.dtpHandOverStart.Value.ToString("yyyy-MM-dd HH:mm") + ":00"); rptse.HandOverTimeEnd = DateTime.Parse(this.dtpHandOverEnd.Value.ToString("yyyy-MM-dd HH:mm") + ":59"); } if (this.chkCheckDate.Enabled && this.chkCheckDate.Checked) { rptse.CheckTimeStart = DateTime.Parse(this.dtpCheckDateStart.Value.ToString("yyyy-MM-dd HH:mm") + ":00"); rptse.CheckTimeEnd = DateTime.Parse(this.dtpCheckDateEnd.Value.ToString("yyyy-MM-dd HH:mm") + ":59"); } rptse.CheckProcedureIDS = this.dkCheckProcedureSearchBox.ProcedureIDS; rptse.KilnCode = this.txtKilnCode.Text.Trim(); //if (!string.IsNullOrEmpty(this.dkCompleteProcedure.ProcedureIDS)) //{ // rptse.CompleteProcedureIDS = this.dkCompleteProcedure.ProcedureIDS; // rptse.CompleteCreateTimeStart = DateTime.Parse(this.dtpCompleteDateStart.Value.ToString("yyyy-MM-dd HH:mm") + ":00"); // rptse.CompleteCreateTimeEnd = DateTime.Parse(this.dtpCompleteDateEnd.Value.ToString("yyyy-MM-dd HH:mm") + ":59"); //} if (!string.IsNullOrEmpty(this.dkProcedureSearchBox1.ProcedureIDS)) { rptse.CompleteProcedureIDS = this.dkProcedureSearchBox1.ProcedureIDS; } } /// /// 查询成检缺陷汇总表 /// private DataTable GetSearchTotalData() { try { // 调用服务器端获取数据集 ServiceResultEntity sre = DoAsync(() => { return ReportModuleProxy.Service.GetRPT030106Data(rptse); } ); 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.Information); //清空数据 return null; } return sre.Data.Tables[0]; } return null; } catch (Exception ex) { throw ex; } } /// /// 查询损坏明细表 /// private DataTable GetSearchDetailData() { try { // 调用服务器端获取数据集 ServiceResultEntity sre = DoAsync(() => { return ReportModuleProxy.Service.GetRPT030106IData(rptse); } ); 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.Information); //清空数据 return null; } return sre.Data.Tables[0]; } return null; } catch (Exception ex) { throw ex; } } /// /// 查询缺陷登记明细表 /// private DataTable GetSearchDefectData() { try { // 调用服务器端获取数据集 ServiceResultEntity sre = DoAsync(() => { return ReportModuleProxy.Service.GetRPT030106DData(rptse); } ); 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.Information); //清空数据 return null; } return sre.Data.Tables[0]; } return null; } catch (Exception ex) { throw ex; } } /// /// 查询缺陷登记明细表 /// private DataTable GetSearchProData() { try { // 调用服务器端获取数据集 ServiceResultEntity sre = DoAsync(() => { return ReportModuleProxy.Service.GetRPT030106ProData(rptse); } ); 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.Information); //清空数据 return null; } return sre.Data.Tables[0]; } return null; } catch (Exception ex) { throw ex; } } /// /// 获取权限(生产线) /// protected void getPurviewLine() { try { StringBuilder sbProcedurePurview = new StringBuilder(); //得到工序查看权限 DataSet dsProcedurePurview = (DataSet)DoAsync(new AsyncMethod(() => { return SystemModuleProxy.Service.GetUserPurview(7, LogInUserInfo.CurrentUser.UserID); })); if (dsProcedurePurview != null) { DataRow[] drPurview = dsProcedurePurview.Tables[Constant.INT_IS_ZERO].Select("PurviewID=-1"); if (drPurview.Length == 0) { foreach (DataRow dr in dsProcedurePurview.Tables[Constant.INT_IS_ZERO].Rows) { sbProcedurePurview.Append(dr[Constant.INT_IS_ZERO].ToString() + ","); } if (sbProcedurePurview.Length != Constant.INT_IS_ZERO) { this.dkproductionLineSearchBox.Purview = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1); this.dkproductionLineSearchBox.ProductionLineIDS = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1); this._currentUserLinePuview = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1); } } else { ProductionLineEntity line = new ProductionLineEntity(); line.ValueFlags = new object[] { 1 }; dsProcedurePurview = (DataSet)DoAsync(() => { return PCModuleProxy.Service.SearchProductionLine(line); }); foreach (DataRow dr in dsProcedurePurview.Tables[Constant.INT_IS_ZERO].Rows) { sbProcedurePurview.Append(dr["productionlineID"].ToString() + ","); } if (sbProcedurePurview.Length != Constant.INT_IS_ZERO) { this.dkproductionLineSearchBox.Purview = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1); this.dkproductionLineSearchBox.ProductionLineIDS = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1); this._currentUserLinePuview = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1); } } } } catch (Exception ex) { throw ex; } } /// /// 获取权限 /// protected void getPurview() { try { StringBuilder sbProcedurePurview = new StringBuilder(); //得到工序查看权限 DataSet dsProcedurePurview = (DataSet)DoAsync(new AsyncMethod(() => { return SystemModuleProxy.Service.GetUserPurview(9, LogInUserInfo.CurrentUser.UserID); })); if (dsProcedurePurview != null) { DataRow[] drPurview = dsProcedurePurview.Tables[Constant.INT_IS_ZERO].Select("PurviewID=-1"); if (drPurview.Length == 0) { foreach (DataRow dr in dsProcedurePurview.Tables[Constant.INT_IS_ZERO].Rows) { sbProcedurePurview.Append(dr[Constant.INT_IS_ZERO].ToString() + ","); } if (sbProcedurePurview.Length != Constant.INT_IS_ZERO) { this.dkProcedureSearchBox.Purview = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1); this.dkProcedureSearchBox.ProcedureIDS = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1); this._currentUserPurview = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1); } } else { SearchProductionLineEntity line = new SearchProductionLineEntity(); dsProcedurePurview = SystemModuleProxy.Service.GetProdureList(line); foreach (DataRow dr in dsProcedurePurview.Tables[Constant.INT_IS_ZERO].Rows) { sbProcedurePurview.Append(dr["ProcedureID"].ToString() + ","); } if (sbProcedurePurview.Length != Constant.INT_IS_ZERO) { this.dkProcedureSearchBox.Purview = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1); this.dkProcedureSearchBox.ProcedureIDS = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1); this._currentUserPurview = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1); } } } } catch (Exception ex) { throw ex; } } /// /// 查看工号权限 /// protected void getPurviewUserCode() { try { //StringBuilder sbProcedurePurview = new StringBuilder(); ////得到工序查看权限 //DataSet dsProcedurePurview = (DataSet)DoAsync(new AsyncMethod(() => //{ // return SystemModuleProxy.Service.GetUserPurview(3, LogInUserInfo.CurrentUser.UserID); //})); //if (dsProcedurePurview != null) //{ // foreach (DataRow dr in dsProcedurePurview.Tables[Constant.INT_IS_ZERO].Rows) // { // sbProcedurePurview.Append(dr[Constant.INT_IS_ZERO].ToString() + ","); // } // if (sbProcedurePurview.Length != Constant.INT_IS_ZERO) // { // this._currentUserCodePuview = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1); // } //} } catch (Exception ex) { throw ex; } } #endregion } }