/******************************************************************************* * Copyright(c) 2015 DongkeSoft All rights reserved. / Confidential * 类的信息: * 1.程序名称:F_RPT_040110.cs * 2.功能描述:产成品逐日出窑数值分析表 * 编辑履历: * 作者 日期 版本 修改内容 * 陈晓野 2016/11/09 1.00 新建 *******************************************************************************/ using System; using System.Collections.Generic; 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_040110 : DKDockPanelBase { #region 成员变量 // 窗体的单例模式 private static F_RPT_040110 _instance; //private TreeNode tnGUsercode = new TreeNode("成型工号"); //private TreeNode tnGLType = new TreeNode("成型线类型"); #endregion #region 构造函数 public F_RPT_040110() { InitializeComponent(); // 窗体显示的Title //this.Text = FormTitles.F_RPT_040105; 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; //tnGUsercode.Name = "成型工号"; //tnGUsercode.Text = "成型工号"; //tnGLType.Name = "成型线类型"; //tnGLType.Text = "成型线类型"; //this.treeView1.Nodes.Insert(1, tnGUsercode); //this.treeView1.Nodes.Insert(2, tnGLType); this.gusercode.Visible = false; this.gltype.Visible = false; } #endregion #region 单例模式 /// /// 单例模式,防止重复创建窗体 /// public static F_RPT_040110 Instance { get { if (_instance == null || _instance.IsDisposed) { _instance = new F_RPT_040110(); } return _instance; } } #endregion #region 事件处理 /// /// 窗体加载事件 /// /// /// private void F_RPT_040104_Load(object sender, EventArgs e) { try { // 加载权限 FormPermissionManager.FormPermissionControl(this.Name, this, LogInUserInfo.CurrentUser.CurrentUserEntity.UserRightData, LogInUserInfo.CurrentUser.CurrentUserEntity.FunctionData); //绑定下了列表 BindPage(); // 设置表格不自动创建列 this.dgvTQ.AutoGenerateColumns = false; this.dropRptProcedure.Focus(); //回收标识默认选否 this.chkRecyclingFlag.FalseItemCheck(); // 初始化时间控件为当前日期 this.dtpAccountDateStart.Value = DateTime.Now.Date; this.dtpAccountDateEnd.Value = this.dtpAccountDateStart.Value.AddDays(1).AddSeconds(-1); } catch (Exception ex) { // 对异常进行共通处理 ExceptionManager.HandleEventException(this.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex); } } /// /// 自动适应列宽 /// /// /// private void tsbtnAdaptive_Click(object sender, EventArgs e) { this.dgvTQ.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells); } /// /// 窗体关闭事件 /// /// /// private void F_RPT_040104_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 { this.dgvTQ.DataSource = null; if (this.chkG.Checked) { this.gusercode.Visible = true; this.gltype.Visible = true; //if (!this.treeView1.Nodes.Contains(tnGUsercode)) //{ // this.treeView1.Nodes.Insert(1, tnGUsercode); //} //if (!this.treeView1.Nodes.Contains(tnGLType)) //{ // this.treeView1.Nodes.Insert(2, tnGLType); //} } else { this.gusercode.Visible = false; this.gltype.Visible = false; //if (this.treeView1.Nodes.Contains(tnGUsercode)) //{ // this.treeView1.Nodes.Remove(tnGUsercode); //} //if (this.treeView1.Nodes.Contains(tnGLType)) //{ // this.treeView1.Nodes.Remove(tnGLType); //} } DataSet dataSet = this.GetSearchData(); if (dataSet == null) { return; } this.dgvTQ.DataSource = dataSet.Tables[0]; } catch (Exception ex) { this.btnSearch.Enabled = true; this.btnClearCondition.Enabled = true; this.dgvTQ.Enabled = true; // 对异常进行共通处理 ExceptionManager.HandleEventException(this.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex); } finally { this.btnSearch.Enabled = true; this.btnClearCondition.Enabled = true; this.dgvTQ.Enabled = true; } } /// /// 清空条件按钮事件 /// /// /// private void btnClearCondition_Click(object sender, EventArgs e) { this.dropKilnCode.SelectedIndex = 0; this.dtpAccountDateStart.Value = DateTime.Now.Date; this.dtpAccountDateEnd.Value = this.dtpAccountDateStart.Value.AddDays(1).AddSeconds(-1); } #endregion #region 私有方法 /// /// 根据界面查询条件获取数据集 /// private DataSet GetSearchData() { try { RPT040110_SE se = new RPT040110_SE(); if (string.IsNullOrEmpty(this.dropRptProcedure.Text)) { this.dropRptProcedure.Focus(); return null; } se.RptProcedureID = Convert.ToInt32(this.dropRptProcedure.SelectedValue); //获取数据来源工序Id ServiceResultEntity sre0 = this.DoAsync(() => { return ReportModuleProxy.Service.GetRptSourceProcedureModule(se.RptProcedureID); } ); if (sre0.Data != null && sre0.Data.Tables.Count > 0) { se.RptSProcedureID = int.Parse(sre0.Data.Tables[0].Rows[Constant.INT_IS_ZERO]["Procedureid"].ToString()); } //获取数据来源工序Id if (!this.dropKilnCode.Text.Equals(Constant.CBO_SELECT_ALL_NAME)) { se.KilnID = Convert.ToInt32(this.dropKilnCode.SelectedValue); } object[] testRecyclingFlags = this.chkRecyclingFlag.SelectedValues; if (testRecyclingFlags.Length == 1) { se.RECYCLINGFLAG = Convert.ToInt32(testRecyclingFlags[0]); } se.CreateTimeStart = DateTime.Parse(this.dtpAccountDateStart.Value.ToString("yyyy-MM-dd HH:mm") + ":00"); se.CreateTimeEnd = DateTime.Parse(this.dtpAccountDateEnd.Value.ToString("yyyy-MM-dd HH:mm") + ":59"); se.IsShowG = this.chkG.Checked; // 调用服务器端获取数据集 ServiceResultEntity sre = DoAsync(() => { return ReportModuleProxy.Service.GetRPT040110SData(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; } return null; } catch (Exception ex) { throw ex; } } /// /// 绑定下拉列表值 /// /// private void BindPage() { //绑定数据来源下拉列表 ServiceResultEntity sre1 = DoAsync(() => { return ReportModuleProxy.Service.GetRptProcedureModule(); } ); this.dropRptProcedure.DataSource = sre1.Data.Tables[Constant.INT_IS_ZERO]; this.dropRptProcedure.ValueMember = "Rptprocedureid"; this.dropRptProcedure.DisplayMember = "Rptprocedurename"; //绑定窑炉下来列表 ServiceResultEntity sre2 = DoAsync(() => { byte byFlage = Convert.ToByte(Constant.ValueFlag.Invalid); return ReportModuleProxy.Service.GetKilnData(byFlage); } ); DataTable dtKilnInfo = sre2.Data.Tables[Constant.INT_IS_ZERO]; DataRow newRowDic = dtKilnInfo.NewRow(); newRowDic["KilnID"] = Constant.CBO_SELECT_ALL_VALUE; newRowDic["KilnCode"] = Constant.CBO_SELECT_ALL_NAME; dtKilnInfo.Rows.InsertAt(newRowDic, Constant.INT_IS_ZERO); this.dropKilnCode.DataSource = dtKilnInfo; this.dropKilnCode.ValueMember = "KilnID"; this.dropKilnCode.DisplayMember = "KilnCode"; } #endregion } }