/*******************************************************************************
* 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.Add(dr);
dr = DataCodeDt.NewRow();
dr["DataCodeName"] = "模具";
dr["DataCode"] = "10";
DataCodeDt.Rows.Add(dr);
dr = DataCodeDt.NewRow();
dr["DataCodeName"] = "湿坯";
dr["DataCode"] = "20";
DataCodeDt.Rows.Add(dr);
dr = DataCodeDt.NewRow();
dr["DataCodeName"] = "精坯";
dr["DataCode"] = "30";
DataCodeDt.Rows.Add(dr);
dr = DataCodeDt.NewRow();
dr["DataCodeName"] = "釉坯";
dr["DataCode"] = "40";
DataCodeDt.Rows.Add(dr);
dr = DataCodeDt.NewRow();
dr["DataCodeName"] = "烧成";
dr["DataCode"] = "50";
DataCodeDt.Rows.Add(dr);
dr = DataCodeDt.NewRow();
dr["DataCodeName"] = "裸瓷包装";
dr["DataCode"] = "55";
DataCodeDt.Rows.Add(dr);
dr = DataCodeDt.NewRow();
dr["DataCodeName"] = "成品";
dr["DataCode"] = "60";
DataCodeDt.Rows.Add(dr);
dr = DataCodeDt.NewRow();
dr["DataCodeName"] = "模具生产";
dr["DataCode"] = "1001";
DataCodeDt.Rows.Add(dr);
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//同步明细
{
cre.Properties["datebegin"] = this.dtpDatebegin.Value;
cre.Properties["dateend"] = Convert.ToDateTime(this.dtpDateend.Value).AddSeconds(1);
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
private void lblLabel2_Click(object sender, EventArgs e)
{
}
}
}