/******************************************************************************* * Copyright(c) 2015 DongkeSoft All rights reserved. / Confidential * 类的信息: * 1.程序名称:F_RPT_010401.cs * 2.功能描述:在产品明细表 * 编辑履历: * 作者 日期 版本 修改内容 * 袁新成 2015/4/9 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_010401 : DKDockPanelBase { #region 成员变量 // 窗体的单例模式 private static F_RPT_010401 _instance; //默认清空工序,重置回用户当前权限工序 private string _currentUserPurview = null; //默认清空生产线,重置回用户当前权限生产线 private string _currentUserLinePuview = null; #endregion #region 构造函数 public F_RPT_010401() { InitializeComponent(); //自动适应列宽 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; // 窗体显示的Title this.Text = FormTitles.F_RPT_010401; } #endregion #region 单例模式 /// /// 单例模式,防止重复创建窗体 /// public static F_RPT_010401 Instance { get { if (_instance == null || _instance.IsDisposed) { _instance = new F_RPT_010401(); } return _instance; } } #endregion #region 事件 /// /// 窗体加载事件 /// /// /// private void F_RPT_010401_Load(object sender, EventArgs e) { try { // 加载权限 FormPermissionManager.FormPermissionControl(this.Name, this, LogInUserInfo.CurrentUser.CurrentUserEntity.UserRightData, LogInUserInfo.CurrentUser.CurrentUserEntity.FunctionData); // 设置表格不自动创建列 this.dgvInProduction.AutoGenerateColumns = false; // 初始化时间控件为当前日期 this.dtpCreateTimeStart.Value = DateTime.Now.Date; this.dtpCreateTimeEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1); this.dkproductionLineSearchBox.IsEnablePurview = true; this.dkProcedureSearchBox.IsEnablePurview = true; this.dtpUpdateTimeStart.Value = DateTime.Now.Date; this.dtpUpdateTimeEnd.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 F_RPT_010401_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._currentUserPurview)) { // 提示未查找到数据 MessageBox.Show(Messages.MSG_CMN_I002, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); return; } this.dgvInProduction.DataSource = null; this.dgvInProduction.DataSource = this.GetSearchData(); } 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 tsbtnAdaptive_Click(object sender, EventArgs e) { this.dgvInProduction.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells); } /// /// 清空条件按钮事件 /// /// /// private void btnClearCondition_Click(object sender, EventArgs e) { //清空更多条件内容 this.scbGoods.ClearValue(); scbGoodsType.ClearValue(); this.scbGMouldType.ClearValue(); this.scbGroutingLine.ClearValue(); this.dkProcedureSearchBox.ClearControl(); this.dkproductionLineSearchBox.ClearControl(); this.dkUserInfoSearchBox.ClearControl(); this.dtpCreateTimeStart.Value = DateTime.Now.Date; this.dtpCreateTimeEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1); this.dtpUpdateTimeStart.Value = DateTime.Now.Date; this.dtpUpdateTimeEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1); this.chkCreateTime.Checked = true; this.chkUpdateTime.Checked = true; this.txtBarCode.Text = string.Empty; this.dkProcedureSearchBox.ProcedureIDS = this._currentUserPurview; this.dkproductionLineSearchBox.ProductionLineIDS = this._currentUserLinePuview; this.radAll.Checked = true; this.radNormal.Checked = false; this.radScrap.Checked = false; } /// /// 交坯日期 /// /// /// private void chkCreateTime_CheckedChanged(object sender, EventArgs e) { this.dtpCreateTimeStart.Enabled = this.chkCreateTime.Checked; this.dtpCreateTimeEnd.Enabled = this.chkCreateTime.Checked; } private void chkUpdateTime_CheckedChanged(object sender, EventArgs e) { this.dtpUpdateTimeStart.Enabled = this.chkUpdateTime.Checked; this.dtpUpdateTimeEnd.Enabled = this.chkUpdateTime.Checked; } #endregion #region 私有方法 /// /// 根据界面查询条件获取数据集 /// private DataTable GetSearchData() { try { RPT010401_SE se = new RPT010401_SE(); se.Barcode = txtBarCode.Text.Trim(); se.ProductionLineIDS = dkproductionLineSearchBox.ProductionLineIDS; se.ProcedureIDS = dkProcedureSearchBox.ProcedureIDS; se.GoodsIDS = this.scbGoods.CheckedPKMember; se.UserIDS = dkUserInfoSearchBox.UserIDS; se.GroutingLineIDS = (this.scbGroutingLine.SearchedPKMember == 0 ? null : this.scbGroutingLine.SearchedPKMember.ToString()); se.GMouldTypeIDS = this.scbGMouldType.CheckedPKMember; if (this.chkCreateTime.Checked == true) { //se.CreateTimeStart = DateTime.Parse(this.dtpCreateTimeStart.Value.ToString("yyyy-MM-dd") + " 0:0:0"); //se.CreateTimeEnd = DateTime.Parse(this.dtpCreateTimeEnd.Value.ToString("yyyy-MM-dd") + " 23:59:59"); se.CreateTimeStart = this.dtpCreateTimeStart.Value; se.CreateTimeEnd = this.dtpCreateTimeEnd.Value; } if (this.chkUpdateTime.Checked == true) { //se.UpdateTimeStart = DateTime.Parse(this.dtpUpdateTimeStart.Value.ToString("yyyy-MM-dd") + " 0:0:0"); //se.UpdateTimeEnd = DateTime.Parse(this.dtpUpdateTimeEnd.Value.ToString("yyyy-MM-dd") + " 23:59:59"); se.UpdateTimeStart = this.dtpUpdateTimeStart.Value; se.UpdateTimeEnd = this.dtpUpdateTimeEnd.Value; } se.inscrapflag = radAll.Checked ? 2 : radNormal.Checked ? 0 : 1; se.IsReworkFlag = chkIsReworkFlag.Checked ? 1 : 0; se.GoodsTypeCode = scbGoodsType.SearchedValue + ""; // 调用服务器端获取数据集 ServiceResultEntity sre = DoAsync(() => { return ReportModuleProxy.Service.GetRPT010401SData(se); } ); 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 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 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; } } #endregion } }