/******************************************************************************* * Copyright(c) 2015 DongkeSoft All rights reserved. / Confidential * 类的信息: * 1.程序名称:F_RPT_030107.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; namespace Dongke.IBOSS.PRD.Client.ReportModule { /// /// 工序交接数量汇总表 /// public partial class F_RPT_030107 : DKDockPanelBase { #region 成员变量 // 窗体的单例模式 private static F_RPT_030107 _instance; //实体类 private RPT030107_SE _rptse = null; private RPT030107_SE _rptse1 = null; //默认清空工序,重置回用户当前权限工序 private string _currentUserPurview = null; //默认清空生产线,重置回用户当前权限生产线 private string _currentUserLinePuview = null; #endregion #region 构造函数 public F_RPT_030107() { InitializeComponent(); // 窗体显示的Title this.Text = "工序交接数量汇总表"; 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_030107 Instance { get { if (_instance == null || _instance.IsDisposed) { _instance = new F_RPT_030107(); } return _instance; } } #endregion #region 事件处理 /// /// 窗体加载事件 /// /// /// private void F_RPT_030103_1_Load(object sender, EventArgs e) { try { // 加载权限 FormPermissionManager.FormPermissionControl(this.Name, this, LogInUserInfo.CurrentUser.CurrentUserEntity.UserRightData, LogInUserInfo.CurrentUser.CurrentUserEntity.FunctionData); // 设置表格不自动创建列 this.dgvRptProcedureDetail.AutoGenerateColumns = false; this.dgvRptProcedure.AutoGenerateColumns = false; this.dkproductionLineSearchBox.IsEnablePurview = true; this.dkProcedureSearchBox.IsEnablePurview = true; // 初始化时间控件为当前日期 this.dtpPDateStart.Value = DateTime.Now.Date; this.dtpPDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1); this.dtpOverDateStart.Value = DateTime.Now.Date; this.dtpOverDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1); this.dtpDDateStart.Value = DateTime.Now.Date; this.dtpDDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1); this.dtpGDateStart.Value = DateTime.Now.Date; this.dtpGDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1); getPurview(); getPurviewLine(); } catch (Exception ex) { // 对异常进行共通处理 ExceptionManager.HandleEventException(this.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex); } } /// /// 自动适应列宽 /// /// /// private void tsbtnAdaptive_Click(object sender, EventArgs e) { if (this.tblReportModule.SelectedIndex == Constant.INT_IS_ZERO) { this.dgvRptProcedure.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells); } else { this.dgvRptProcedureDetail.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells); } } /// /// 窗体关闭事件 /// /// /// private void F_RPT_030103_1_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.dkProcedureSearchBox.Text)) { this.dkProcedureSearchBox.Focus(); MessageBox.Show("生产工序是必选项,请选择生产工序!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (string.IsNullOrEmpty(this.dkHandOverProcedure.Text)) { this.dkHandOverProcedure.Focus(); MessageBox.Show("交接工序是必选项,请选择交接工序!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } CreateSearchCondition(); if (this.tblReportModule.SelectedIndex == Constant.INT_IS_ZERO) { this._rptse1 = this._rptse; this.dgvRptProcedure.DataSource = null; this.dgvRptProcedure.DataSource = this.GetSearchTotalData(); } else //出窑数量明细查询 { this.dgvRptProcedureDetail.DataSource = null; this.dgvRptProcedureDetail.DataSource = this.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 btnClearCondition_Click(object sender, EventArgs e) { this.dkproductionLineSearchBox.ClearControl(); //this.dkproductionLineSearchBox.ProductionLineIDS = null; this.txtGroutingUserCode.Clear(); this.scbGoodsType.ClearValue(); this.txtGoodCode.Clear(); this.dkProcedureSearchBox.ClearControl(); //this.dkProcedureSearchBox.ProcedureIDS = null; this.dkUserInfoSearchBox.ClearControl(); //this.dkUserInfoSearchBox.UserIDS = null; this.dkHandOverProcedure.ClearControl(); //this.dkHandOverProcedure.ProcedureIDS = null; this.dkHandOverUser.ClearControl(); //this.dkHandOverUser.UserIDS = null; this.chkPDate.Checked = false; this.chkOver.Checked = true; this.dtpOverDateStart.Value = DateTime.Now.Date; this.dtpOverDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1); this.chkDDate.Checked = false; this.chkGDate.Checked = false; this.chkspecialrepairflag.Checked = false; this.chkPUserCode.Checked = true; } /// /// 双击单元格事件 /// /// /// private void dgvRptProcedure_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e) { try { //判断是否为空 if (this.dgvRptProcedure.CurrentRow == null || this.dgvRptProcedure.CurrentRow.Index < 0) { return; } //获取数据信息 DataGridViewRow dgvr = dgvRptProcedure.CurrentRow; string goodsId = dgvr.Cells["GoodsId"].Value.ToString(); string userId = dgvr.Cells["Userid"].Value.ToString(); string procedureId = dgvr.Cells["ProcedureId"].Value.ToString(); string goodstypecode2 = dgvr.Cells["goodstypecode2"].Value.ToString(); //判断是否选择统计行 if (!goodsId.Equals("--")) { this.dgvRptProcedureDetail.DataSource = null; this.tblReportModule.SelectTab(1); //获取条件 this.CreateSearchConditionDetail(); this._rptse.GoodsID = goodsId; this._rptse.ProcedureIDS = procedureId; this._rptse.UserIDS = userId; this.dgvRptProcedureDetail.DataSource = null; this.dgvRptProcedureDetail.DataSource = GetSearchDetailData(); return; } if (!string.IsNullOrEmpty(goodstypecode2)) { this.dgvRptProcedureDetail.DataSource = null; this.tblReportModule.SelectTab(1); //获取条件 this.CreateSearchConditionDetail(); this._rptse.ProcedureIDS = procedureId; this._rptse.GoodsTypeCode = goodstypecode2; this.dgvRptProcedureDetail.DataSource = null; this.dgvRptProcedureDetail.DataSource = GetSearchDetailData(); return; } if (!string.IsNullOrEmpty(procedureId)) { this.dgvRptProcedureDetail.DataSource = null; this.tblReportModule.SelectTab(1); //获取条件 this.CreateSearchConditionDetail(); this._rptse.ProcedureIDS = procedureId; this.dgvRptProcedureDetail.DataSource = null; this.dgvRptProcedureDetail.DataSource = GetSearchDetailData(); return; } this.dgvRptProcedureDetail.DataSource = null; this.tblReportModule.SelectTab(1); //获取条件 this.CreateSearchConditionDetail(); this.dgvRptProcedureDetail.DataSource = null; this.dgvRptProcedureDetail.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 chkOver_CheckedChanged(object sender, EventArgs e) { if (this.chkPDate.Checked) { this.dtpPDateStart.Enabled = true; this.dtpPDateEnd.Enabled = true; } else { this.dtpPDateStart.Enabled = false; this.dtpPDateEnd.Enabled = false; this.dtpPDateStart.Value = DateTime.Now.Date; this.dtpPDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1); } } private void chkOut_CheckedChanged(object sender, EventArgs e) { if (this.chkOver.Checked) { this.dtpOverDateStart.Enabled = true; this.dtpOverDateEnd.Enabled = true; } else { this.dtpOverDateStart.Enabled = false; this.dtpOverDateEnd.Enabled = false; this.dtpOverDateStart.Value = DateTime.Now.Date; this.dtpOverDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1); } } private void chkDDate_CheckedChanged(object sender, EventArgs e) { if (this.chkDDate.Checked) { this.dtpDDateStart.Enabled = true; this.dtpDDateEnd.Enabled = true; } else { this.dtpDDateStart.Enabled = false; this.dtpDDateEnd.Enabled = false; this.dtpDDateStart.Value = DateTime.Now.Date; this.dtpDDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1); } } private void chkGDate_CheckedChanged(object sender, EventArgs e) { if (this.chkGDate.Checked) { this.dtpGDateStart.Enabled = true; this.dtpGDateEnd.Enabled = true; } else { this.dtpGDateStart.Enabled = false; this.dtpGDateEnd.Enabled = false; this.dtpGDateStart.Value = DateTime.Now.Date; this.dtpGDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1); } } #endregion #region 私有方法 /// /// 搜索条件 /// /// private void CreateSearchCondition() { this._rptse = new RPT030107_SE(); this._rptse.ProductionLineID = this.dkproductionLineSearchBox.ProductionLineID; this._rptse.GroutingUserCode = this.txtGroutingUserCode.Text.Trim(); this._rptse.GoodsTypeCode = scbGoodsType.SearchedValue + ""; this._rptse.GoodsCode = this.txtGoodCode.Text.Trim(); this._rptse.ProcedureIDS = this.dkProcedureSearchBox.ProcedureIDS; this._rptse.UserIDS = this.dkUserInfoSearchBox.UserIDS; this._rptse.OverProcedureIDS = this.dkHandOverProcedure.ProcedureIDS; this._rptse.OverUserIDS = this.dkHandOverUser.UserIDS; if (this.chkPDate.Checked) { this._rptse.PTimeStart = DateTime.Parse(this.dtpPDateStart.Value.ToString("yyyy-MM-dd HH:mm") + ":00"); this._rptse.PTimeEnd = DateTime.Parse(this.dtpPDateEnd.Value.ToString("yyyy-MM-dd HH:mm") + ":59"); } if (this.chkOver.Checked) { this._rptse.OverTimeStart = DateTime.Parse(this.dtpOverDateStart.Value.ToString("yyyy-MM-dd HH:mm") + ":00"); this._rptse.OverTimeEnd = DateTime.Parse(this.dtpOverDateEnd.Value.ToString("yyyy-MM-dd HH:mm") + ":59"); } if (this.chkDDate.Checked) { this._rptse.DTimeStart = DateTime.Parse(this.dtpDDateStart.Value.ToString("yyyy-MM-dd HH:mm") + ":00"); this._rptse.DTimeEnd = DateTime.Parse(this.dtpDDateEnd.Value.ToString("yyyy-MM-dd HH:mm") + ":59"); } if (this.chkGDate.Checked) { this._rptse.GTimeStart = DateTime.Parse(this.dtpGDateStart.Value.ToString("yyyy-MM-dd HH:mm") + ":00"); this._rptse.GTimeEnd = DateTime.Parse(this.dtpGDateEnd.Value.ToString("yyyy-MM-dd HH:mm") + ":59"); } this._rptse.Specialrepairflag = this.chkspecialrepairflag.Checked; this._rptse.DisPUserCode = this.chkPUserCode.Checked; } /// /// 明细搜索条件 /// /// private void CreateSearchConditionDetail() { this._rptse = new RPT030107_SE(); this._rptse.ProductionLineID = this._rptse1.ProductionLineID; this._rptse.GroutingUserCode = this._rptse1.GroutingUserCode; this._rptse.GoodsTypeCode = this._rptse1.GoodsTypeCode; this._rptse.GoodsCode = this._rptse1.GoodsCode; this._rptse.ProcedureIDS = this._rptse1.ProcedureIDS; this._rptse.UserIDS = this._rptse1.UserIDS; this._rptse.OverProcedureIDS = this._rptse1.OverProcedureIDS; this._rptse.OverUserIDS = this._rptse1.OverUserIDS; this._rptse.PTimeStart = this._rptse1.PTimeStart; this._rptse.PTimeEnd = this._rptse1.PTimeEnd; this._rptse.OverTimeStart = this._rptse1.OverTimeStart; this._rptse.OverTimeEnd = this._rptse1.OverTimeEnd; this._rptse.DTimeStart = this._rptse1.DTimeStart; this._rptse.DTimeEnd = this._rptse1.DTimeEnd; this._rptse.GTimeStart = this._rptse1.GTimeStart; this._rptse.GTimeEnd = this._rptse1.GTimeEnd; this._rptse.Specialrepairflag = this._rptse1.Specialrepairflag; this._rptse.DisPUserCode = this._rptse1.DisPUserCode; } /// /// 查询出窑数量汇总表 /// private DataTable GetSearchTotalData() { try { // 调用服务器端获取数据集 ServiceResultEntity sre = DoAsync(() => { return ReportModuleProxy.Service.GetRPT030107SData(_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.Warning); //清空数据 return null; } return sre.Data.Tables[0]; } return null; } catch (Exception ex) { throw ex; } } /// /// 查询出窑数量明细表 /// private DataTable GetSearchDetailData() { try { // 调用服务器端获取数据集 ServiceResultEntity sre = DoAsync(() => { return ReportModuleProxy.Service.GetRPT030107IData(_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.Warning); //清空数据 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; } } #endregion } }