/******************************************************************************* * Copyright(c) 2016 DongkeSoft All rights reserved. / Confidential * 类的信息: * 1.程序名称:F_SAP_HEGII_0107.cs * 2.功能描述:成品SAP日志 * 编辑履历: * 作者 日期 版本 修改内容 * fy 2022/09/07 1.00 新建 *******************************************************************************/ using System; using System.Data; using System.Reflection; using System.Windows.Forms; using Dongke.IBOSS.PRD.Basics.BaseControls; using Dongke.IBOSS.PRD.Basics.BaseResources; using Dongke.IBOSS.PRD.Client.CommonModule; using Dongke.IBOSS.PRD.Client.Controls; using Dongke.IBOSS.PRD.WCF.DataModels; using Dongke.IBOSS.PRD.WCF.Proxys; namespace Dongke.IBOSS.PRD.Client.SAPDataModule { /// /// 成品SAP日志 /// public partial class F_SAP_HEGII_0107 : DKDockPanelBase { #region 成员变量 private static F_SAP_HEGII_0107 _instance = null; #endregion #region 单例模式 /// /// 单例模式,防止重复创建窗体 /// public static F_SAP_HEGII_0107 Instance { get { if (_instance == null) { _instance = new F_SAP_HEGII_0107(); } return _instance; } } #endregion #region 构造函数 /// /// 成品SAP日志 /// public F_SAP_HEGII_0107() { InitializeComponent(); this.Text = "报工同步日志"; this.tsbtnAdaptive.Text = ButtonText.TSBTN_ADAPTIVE; this.tsbtnClose.Text = ButtonText.TSBTN_CLOSE; this.dgvLog.AutoGenerateColumns = false; this.dgvSum.AutoGenerateColumns = false; this.dgvTotal.AutoGenerateColumns = false; } #endregion #region 控件事件 /// /// 关闭 /// /// /// private void F_SAP_HEGII_0107_FormClosed(object sender, FormClosedEventArgs e) { _instance = null; } /// /// 画面加载 /// /// /// private void F_SAP_HEGII_0107_Load(object sender, System.EventArgs e) { dgvLog.AutoGenerateColumns = false; //update xiacm 2022-10-12 this.dtpDatebegin.Value = DateTime.Now.Date.AddDays(-1); this.dtpDateend.Value = DateTime.Now.Date.AddMilliseconds(-1); //数据节点数据绑定 add xiacm 2022-10-12 DataTable DataCodeDt = new DataTable(); DataCodeDt.Columns.Add("DataCodeName",typeof(string)); DataCodeDt.Columns.Add("DataCode", typeof(string)); DataRow dr = DataCodeDt.NewRow(); dr["DataCodeName"] = ""; dr["DataCode"] = "-1"; DataCodeDt.Rows.InsertAt(dr, 0); dr = DataCodeDt.NewRow(); dr["DataCodeName"] = "模具"; dr["DataCode"] = "10"; DataCodeDt.Rows.InsertAt(dr, 1); dr = DataCodeDt.NewRow(); dr["DataCodeName"] = "湿坯"; dr["DataCode"] = "20"; DataCodeDt.Rows.InsertAt(dr, 2); dr = DataCodeDt.NewRow(); dr["DataCodeName"] = "精坯"; dr["DataCode"] = "30"; DataCodeDt.Rows.InsertAt(dr, 3); dr = DataCodeDt.NewRow(); dr["DataCodeName"] = "釉坯"; dr["DataCode"] = "40"; DataCodeDt.Rows.InsertAt(dr, 4); dr = DataCodeDt.NewRow(); dr["DataCodeName"] = "烧成"; dr["DataCode"] = "50"; DataCodeDt.Rows.InsertAt(dr, 5); dr = DataCodeDt.NewRow(); dr["DataCodeName"] = "成品"; dr["DataCode"] = "60"; DataCodeDt.Rows.InsertAt(dr, 6); this.CBDataCode.DisplayMember = "DataCodeName"; this.CBDataCode.ValueMember = "DataCode"; this.CBDataCode.DataSource = DataCodeDt; this.CBDataCode.SelectedValue = "-1"; } /// /// 查询 /// /// /// private void tsbtnSearch_Click(object sender, EventArgs e) { try { //this.dgvLog.DataSource = null; this.QueryDataFromOther(); tsbtnAdaptive_Click(null, null); } catch (Exception ex) { // 对异常进行共通处理 ExceptionManager.HandleEventException(this.ToString(), MethodBase.GetCurrentMethod().Name, this.Text, ex); } } /// /// 清除条件 /// /// /// private void tsbtnClearCondition_Click(object sender, EventArgs e) { //update xiacm 2022-10-12 this.dtpDatebegin.Value = DateTime.Now.Date.AddDays(-1); this.dtpDateend.Value = DateTime.Now.Date.AddMilliseconds(-1); this.CBDataCode.SelectedValue = "-1"; } /// /// 自适应列宽 /// /// /// private void tsbtnAdaptive_Click(object sender, EventArgs e) { this.dgvLog.AutoResizeColumns(); this.dgvSum.AutoResizeColumns(); this.dgvTotal.AutoResizeColumns();//add xiacm 2022-10-12 } /// /// 关闭画面 /// /// /// private void tsbtnClose_Click(object sender, EventArgs e) { this.Close(); } /// /// 查询同步明细 /// /// /// private void dgvLog_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex < 0 || this.dgvLog.CurrentRow == null) { return; } try { DataGridViewRow dgvr = this.dgvLog.CurrentRow; this.dgvSum.DataSource = null; ClientRequestEntity cre = new ClientRequestEntity(); cre.NameSpace = "Hegii"; cre.Name = "GetWorkData_BG"; cre.Request = dgvr.Cells["logid"].Value; ServiceResultEntity sre = DoAsync(() => { return SAPDataModuleProxy.Service.DoRequest(cre); } ); if (sre.Status == Constant.ServiceResultStatus.Success) { // 查询成功 this.dgvSum.DataSource = sre.Data.Tables[0]; } this.tabControl1.SelectedIndex = 2; } catch (Exception ex) { // 对异常进行共通处理 ExceptionManager.HandleEventException(this.ToString(), MethodBase.GetCurrentMethod().Name, this.Text, ex); } } #endregion #region 私有方法 /// /// 查询数据 /// private void QueryDataFromOther() { if (this.dtpDatebegin.Value == null || this.dtpDateend.Value == null) { return; } try { this.tsrToolStrip1.Focus(); int Indexed = this.tabControl1.SelectedIndex; string datacode = this.CBDataCode.SelectedValue.ToString();//数据节点 ClientRequestEntity cre = new ClientRequestEntity(); cre.Properties["datebegin"] = this.dtpDatebegin.Value; cre.Properties["dateend"] = this.dtpDateend.Value.AddMilliseconds(1); cre.Properties["datacode"] = datacode; cre.NameSpace = "Hegii"; if (Indexed == 0)//报工汇总 { cre.Properties["datebegin"] = this.dtpDatebegin.Value; cre.Properties["dateend"] = Convert.ToDateTime( this.dtpDateend.Value).AddSeconds(1); this.dgvTotal.DataSource = null; cre.Name = "GetDataLogTotal_BG"; } else if (Indexed == 1)//同步日志 { this.dgvLog.DataSource = null; cre.Name = "GetDataLog_BG"; } else//同步明细 { this.dgvSum.DataSource = null; cre.Name = "GetWorkData_BG"; } ServiceResultEntity sre = DoAsync(() => { return SAPDataModuleProxy.Service.DoRequest(cre); } ); if (sre.Status == Constant.ServiceResultStatus.Success) { if (Indexed == 0)//报工汇总 { // 查询成功 this.dgvTotal.DataSource = sre.Data.Tables[0]; if(this.dgvTotal.RowCount ==0) { DKMessageBox.ShowDialog(this, DKMessageCode.I_CMN_S_001); } } else if (Indexed == 1) { // 查询成功 this.dgvLog.DataSource = sre.Data.Tables[0]; // this.tabControl1.SelectedIndex = 0; if (this.dgvLog.RowCount == 0) { DKMessageBox.ShowDialog(this, DKMessageCode.I_CMN_S_001); } } else { // 查询成功 this.dgvSum.DataSource = sre.Data.Tables[0]; if (this.dgvSum.RowCount == 0) { DKMessageBox.ShowDialog(this, DKMessageCode.I_CMN_S_001); } } } } catch (Exception ex) { throw ex; } } #endregion } }