| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475 |
- /*******************************************************************************
- * Copyright(c) 2016 DongkeSoft All rights reserved. / Confidential
- * 类的信息:
- * 1.程序名称:F_SAP_HEGII_0103.cs
- * 2.功能描述:SAP同步日志
- * 编辑履历:
- * 作者 日期 版本 修改内容
- * 陈晓野 2018/11/13 1.00 新建
- *******************************************************************************/
- using System;
- using System.Reflection;
- using System.Windows.Forms;
- using Curtain.Extension.ExObjectConvert;
- 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.Client.DataModels;
- using Dongke.IBOSS.PRD.WCF.DataModels;
- using Dongke.IBOSS.PRD.WCF.Proxys;
- namespace Dongke.IBOSS.PRD.Client.SAPDataModule
- {
- /// <summary>
- /// SAP同步日志
- /// </summary>
- public partial class F_SAP_HEGII_0103 : DKDockPanelBase
- {
- #region 成员变量
- private static F_SAP_HEGII_0103 _instance = null;
- #endregion
- #region 单例模式
- /// <summary>
- /// 单例模式,防止重复创建窗体
- /// </summary>
- public static F_SAP_HEGII_0103 Instance
- {
- get
- {
- if (_instance == null)
- {
- _instance = new F_SAP_HEGII_0103();
- }
- return _instance;
- }
- }
- #endregion
- #region 构造函数
- /// <summary>
- /// SAP同步日志
- /// </summary>
- public F_SAP_HEGII_0103()
- {
- InitializeComponent();
- this.Text = "SAP同步日志";
- this.tsbtnAdaptive.Text = ButtonText.TSBTN_ADAPTIVE;
- this.tsbtnClose.Text = ButtonText.TSBTN_CLOSE;
- this.dgvLog.AutoGenerateColumns = false;
- this.dgvSum.AutoGenerateColumns = false;
- }
- #endregion
- #region 控件事件
- /// <summary>
- /// 关闭
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void F_SAP_HEGII_0103_FormClosed(object sender, FormClosedEventArgs e)
- {
- _instance = null;
- }
- /// <summary>
- /// 画面加载
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void F_SAP_HEGII_0103_Load(object sender, System.EventArgs e)
- {
- try
- {
- // 加载权限
- FormPermissionManager.FormPermissionControl(this.Name, this,
- LogInUserInfo.CurrentUser.CurrentUserEntity.UserRightData,
- LogInUserInfo.CurrentUser.CurrentUserEntity.FunctionData);
- this.dtpDatebegin.Value = DateTime.Now.Date;
- this.dtpDateend.Value = DateTime.Now.Date;
- }
- catch (Exception ex)
- {
- // 对异常进行共通处理
- ExceptionManager.HandleEventException(this.ToString(),
- MethodBase.GetCurrentMethod().Name, this.Text, ex);
- }
- }
- /// <summary>
- /// 查询
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void tsbtnSearch_Click(object sender, EventArgs e)
- {
- try
- {
- this.dgvLog.DataSource = null;
- //this.tsbtnSyn.Enabled = true;
- this.QueryDataFromOther();
- }
- catch (Exception ex)
- {
- // 对异常进行共通处理
- ExceptionManager.HandleEventException(this.ToString(),
- MethodBase.GetCurrentMethod().Name, this.Text, ex);
- }
- }
- /// <summary>
- /// 清除条件
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void tsbtnClearCondition_Click(object sender, EventArgs e)
- {
- this.dtpDatebegin.Value = DateTime.Now.Date;
- this.dtpDateend.Value = DateTime.Now.Date;
- }
- /// <summary>
- /// 自适应列宽
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void tsbtnAdaptive_Click(object sender, EventArgs e)
- {
- this.dgvLog.AutoResizeColumns();
- this.dgvSum.AutoResizeColumns();
- this.dgvFP.AutoResizeColumns();
- this.dgvSPSum.AutoResizeColumns();
- }
- /// <summary>
- /// 关闭画面
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void tsbtnClose_Click(object sender, EventArgs e)
- {
- this.Close();
- }
- /// <summary>
- /// 查询同步明细
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void dgvLog_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
- {
- if (e.RowIndex < 0 || this.dgvLog.CurrentRow == null)
- {
- return;
- }
- this.dgvSPSum.DataSource = null;
- try
- {
- string datacode = this.dgvLog.CurrentRow.Cells["datacode"].Value + "";
- if (datacode == "6001" || datacode == "6002" || datacode == "60")
- {
- this.dgvFP.DataSource = null;
- ClientRequestEntity cre = new ClientRequestEntity();
- cre.NameSpace = "Hegii";
- cre.Name = "GetFinishedProductByDataLog";
- cre.Request = this.dgvLog.CurrentRow.Cells["datalogid"].Value;
- ServiceResultEntity sre = DoAsync<ServiceResultEntity>(() =>
- {
- return SAPDataModuleProxy.Service.DoRequest(cre);
- }
- );
- if (sre.Status == Constant.ServiceResultStatus.Success)
- {
- // 查询成功
- this.dgvFP.DataSource = sre.Data.Tables[0];
- }
- this.tabControl1.SelectedIndex = 2;
- }
- if (datacode != "6001" && datacode != "6002")
- {
- this.dgvSum.DataSource = null;
- ClientRequestEntity cre = new ClientRequestEntity();
- cre.NameSpace = "Hegii";
- cre.Name = "GetWorkDataByDataLog";
- cre.Request = this.dgvLog.CurrentRow.Cells["datalogid"].Value;
- ServiceResultEntity sre = DoAsync<ServiceResultEntity>(() =>
- {
- return SAPDataModuleProxy.Service.DoRequest(cre);
- }
- );
- if (sre.Status == Constant.ServiceResultStatus.Success)
- {
- // 查询成功
- this.dgvSum.DataSource = sre.Data.Tables[0];
- if (sre.Data.Tables.Count > 1)
- {
- this.dgvSPSum.DataSource = sre.Data.Tables[1];
- }
- }
- this.tabControl1.SelectedIndex = 1;
- }
- }
- catch (Exception ex)
- {
- // 对异常进行共通处理
- ExceptionManager.HandleEventException(this.ToString(),
- MethodBase.GetCurrentMethod().Name, this.Text, ex);
- }
- }
- /// <summary>
- /// 行切换事件
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void dgvLog_SelectionChanged(object sender, EventArgs e)
- {
- if (dgvLog.CurrentRow == null)
- {
- //this.tsbtnSyn.Enabled = true;
- return;
- }
- try
- {
- string datacode = dgvLog.CurrentRow.Cells["datacode"].Value + "";
- string datastuts = dgvLog.CurrentRow.Cells["DataStuts"].Value + "";
- if (datacode == "60" || datastuts == "S")
- {
- //this.tsbtnSyn.Enabled = false;
- }
- else
- {
- //this.tsbtnSyn.Enabled = true;
- }
- }
- catch (Exception ex)
- {
- // 对异常进行共通处理
- ExceptionManager.HandleEventException(this.ToString(),
- MethodBase.GetCurrentMethod().Name, this.Text, ex);
- }
- }
- /// <summary>
- /// 获取数据并同步
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void tsbtnSyn_Click(object sender, EventArgs e)
- {
- try
- {
- F_SAP_HEGII_010301 f = new F_SAP_HEGII_010301(null, null);
- DialogResult dialogResult = f.ShowDialog();
- if (dialogResult == DialogResult.OK)
- {
- this.tsbtnSearch_Click(null, null);
- }
- }
- catch (Exception ex)
- {
- // 对异常进行共通处理
- ExceptionManager.HandleEventException(this.ToString(),
- MethodBase.GetCurrentMethod().Name, this.Text, ex);
- }
- #region 注销
- //DialogResult dialogResult = DialogResult.Cancel;
- //if (dgvLog.CurrentRow == null)
- //{
- // F_SAP_HEGII_010301 f = new F_SAP_HEGII_010301(null, null);
- // dialogResult = f.ShowDialog();
- // if (dialogResult == DialogResult.OK)
- // {
- // this.tsbtnSearch_Click(null, null);
- // }
- // return;
- //}
- //try
- //{
- // string datacode = dgvLog.CurrentRow.Cells["datacode"].Value + "";
- // //string datacodename = dgvLog.CurrentRow.Cells["datacodename"].Value + "";
- // string datastuts = dgvLog.CurrentRow.Cells["DataStuts"].Value + "";
- // string date = dgvLog.CurrentRow.Cells["executedateend"].Value + "";
- // if (datacode == "60" || datastuts == "S")
- // {
- // return;
- // }
- // F_SAP_HEGII_010301 f = new F_SAP_HEGII_010301(date, datacode);
- // dialogResult = f.ShowDialog();
- // if (dialogResult == DialogResult.OK)
- // {
- // this.tsbtnSearch_Click(null, null);
- // }
- //}
- //catch (Exception ex)
- //{
- // // 对异常进行共通处理
- // ExceptionManager.HandleEventException(this.ToString(),
- // MethodBase.GetCurrentMethod().Name, this.Text, ex);
- //}
- #endregion
- }
- /// <summary>
- /// 同步当前日志
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void tsbtnSynLog_Click(object sender, EventArgs e)
- {
- try
- {
- if (dgvLog.CurrentRow == null)
- {
- MessageBox.Show("请选择一条未成功的日志。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
- return;
- }
- DialogResult dr = MessageBox.Show("是否同步当前日志的数据到SAP。",
- this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2);
- if (dr != DialogResult.Yes)
- {
- return;
- }
- ClientRequestEntity cre = new ClientRequestEntity();
- cre.NameSpace = "Hegii";
- cre.Name = "SyncSap";
- cre.Request = dgvLog.CurrentRow.Cells["executedateend"].Value;
- if (cre.Request == null || cre.Request == DBNull.Value)
- {
- cre.Request = dgvLog.CurrentRow.Cells["BeginTime"].Value;
- }
- cre.Properties["datacode"] = dgvLog.CurrentRow.Cells["datacode"].Value + "";
- cre.Properties["logid"] = dgvLog.CurrentRow.Cells["logid"].Value.ToInt32();
- ServiceResultEntity sre = DoAsync(() =>
- {
- return SAPDataModuleProxy.Service.DoRequest(cre);
- });
- if (sre == null)
- {
- MessageBox.Show("数据同步失败。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
- return;
- }
- if (sre.Status == Constant.ServiceResultStatus.Other)
- {
- MessageBox.Show(sre.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
- return;
- }
- if (sre.Status == Constant.ServiceResultStatus.Success)
- {
- if (sre.Result + "" == "S")
- {
- MessageBox.Show("数据同步成功。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
- }
- else
- {
- MessageBox.Show(sre.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
- }
- }
- else
- {
- MessageBox.Show("数据同步失败。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
- }
- }
- catch (Exception ex)
- {
- // 对异常进行共通处理
- ExceptionManager.HandleEventException(this.ToString(),
- MethodBase.GetCurrentMethod().Name, this.Text, ex);
- }
- }
- #endregion
- #region 私有方法
- /// <summary>
- /// 查询数据
- /// </summary>
- private void QueryDataFromOther()
- {
- if (this.dtpDatebegin.Value == null ||
- this.dtpDateend.Value == null)
- {
- return;
- }
- try
- {
- this.tsrToolStrip1.Focus();
- this.dgvLog.DataSource = null;
- ClientRequestEntity cre = new ClientRequestEntity();
- cre.NameSpace = "Hegii";
- if (this.tabControl1.SelectedIndex == 3)
- {
- cre.Name = "GetWorkDataSPSumByDate";
- cre.Properties["datebegin"] = this.dtpDatebegin.Value.Value.ToString("yyyyMMdd");
- cre.Properties["dateend"] = this.dtpDateend.Value.Value.ToString("yyyyMMdd");
- ServiceResultEntity sre = DoAsync<ServiceResultEntity>(() =>
- {
- return SAPDataModuleProxy.Service.DoRequest(cre);
- }
- );
- if (sre.Status == Constant.ServiceResultStatus.Success)
- {
- // 查询成功
- this.dgvSPSum.DataSource = sre.Data.Tables[0];
- //this.tabControl1.SelectedIndex = 0;
- if (this.dgvSPSum.RowCount == 0)
- {
- DKMessageBox.ShowDialog(this, DKMessageCode.I_CMN_S_001);
- }
- }
- }
- else
- {
- cre.Name = "GetDataLog";
- cre.Properties["datebegin"] = this.dtpDatebegin.Value.Value.ToString("yyyyMMdd");
- cre.Properties["dateend"] = this.dtpDateend.Value.Value.ToString("yyyyMMdd");
- ServiceResultEntity sre = DoAsync<ServiceResultEntity>(() =>
- {
- return SAPDataModuleProxy.Service.DoRequest(cre);
- }
- );
- if (sre.Status == Constant.ServiceResultStatus.Success)
- {
- // 查询成功
- this.dgvLog.DataSource = sre.Data.Tables[0];
- this.tabControl1.SelectedIndex = 0;
- if (this.dgvLog.RowCount == 0)
- {
- DKMessageBox.ShowDialog(this, DKMessageCode.I_CMN_S_001);
- }
- }
- }
- }
- catch (Exception ex)
- {
- throw ex;
- }
- }
- #endregion
- }
- }
|