F_SAP_HEGII_0107.cs 8.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321
  1. /*******************************************************************************
  2. * Copyright(c) 2016 DongkeSoft All rights reserved. / Confidential
  3. * 类的信息:
  4. * 1.程序名称:F_SAP_HEGII_0107.cs
  5. * 2.功能描述:成品SAP日志
  6. * 编辑履历:
  7. * 作者 日期 版本 修改内容
  8. * fy 2022/09/07 1.00 新建
  9. *******************************************************************************/
  10. using System;
  11. using System.Data;
  12. using System.Reflection;
  13. using System.Windows.Forms;
  14. using Dongke.IBOSS.PRD.Basics.BaseControls;
  15. using Dongke.IBOSS.PRD.Basics.BaseResources;
  16. using Dongke.IBOSS.PRD.Client.CommonModule;
  17. using Dongke.IBOSS.PRD.Client.Controls;
  18. using Dongke.IBOSS.PRD.WCF.DataModels;
  19. using Dongke.IBOSS.PRD.WCF.Proxys;
  20. namespace Dongke.IBOSS.PRD.Client.SAPDataModule
  21. {
  22. /// <summary>
  23. /// 成品SAP日志
  24. /// </summary>
  25. public partial class F_SAP_HEGII_0107 : DKDockPanelBase
  26. {
  27. #region 成员变量
  28. private static F_SAP_HEGII_0107 _instance = null;
  29. #endregion
  30. #region 单例模式
  31. /// <summary>
  32. /// 单例模式,防止重复创建窗体
  33. /// </summary>
  34. public static F_SAP_HEGII_0107 Instance
  35. {
  36. get
  37. {
  38. if (_instance == null)
  39. {
  40. _instance = new F_SAP_HEGII_0107();
  41. }
  42. return _instance;
  43. }
  44. }
  45. #endregion
  46. #region 构造函数
  47. /// <summary>
  48. /// 成品SAP日志
  49. /// </summary>
  50. public F_SAP_HEGII_0107()
  51. {
  52. InitializeComponent();
  53. this.Text = "报工同步日志";
  54. this.tsbtnAdaptive.Text = ButtonText.TSBTN_ADAPTIVE;
  55. this.tsbtnClose.Text = ButtonText.TSBTN_CLOSE;
  56. this.dgvLog.AutoGenerateColumns = false;
  57. this.dgvSum.AutoGenerateColumns = false;
  58. this.dgvTotal.AutoGenerateColumns = false;
  59. }
  60. #endregion
  61. #region 控件事件
  62. /// <summary>
  63. /// 关闭
  64. /// </summary>
  65. /// <param name="sender"></param>
  66. /// <param name="e"></param>
  67. private void F_SAP_HEGII_0107_FormClosed(object sender, FormClosedEventArgs e)
  68. {
  69. _instance = null;
  70. }
  71. /// <summary>
  72. /// 画面加载
  73. /// </summary>
  74. /// <param name="sender"></param>
  75. /// <param name="e"></param>
  76. private void F_SAP_HEGII_0107_Load(object sender, System.EventArgs e)
  77. {
  78. dgvLog.AutoGenerateColumns = false;
  79. //update xiacm 2022-10-12
  80. this.dtpDatebegin.Value = DateTime.Now.Date.AddDays(-1);
  81. this.dtpDateend.Value = DateTime.Now.Date.AddMilliseconds(-1);
  82. //数据节点数据绑定 add xiacm 2022-10-12
  83. DataTable DataCodeDt = new DataTable();
  84. DataCodeDt.Columns.Add("DataCodeName",typeof(string));
  85. DataCodeDt.Columns.Add("DataCode", typeof(string));
  86. DataRow dr = DataCodeDt.NewRow();
  87. dr["DataCodeName"] = "";
  88. dr["DataCode"] = "-1";
  89. DataCodeDt.Rows.InsertAt(dr, 0);
  90. dr = DataCodeDt.NewRow();
  91. dr["DataCodeName"] = "模具";
  92. dr["DataCode"] = "10";
  93. DataCodeDt.Rows.InsertAt(dr, 1);
  94. dr = DataCodeDt.NewRow();
  95. dr["DataCodeName"] = "湿坯";
  96. dr["DataCode"] = "20";
  97. DataCodeDt.Rows.InsertAt(dr, 2);
  98. dr = DataCodeDt.NewRow();
  99. dr["DataCodeName"] = "精坯";
  100. dr["DataCode"] = "30";
  101. DataCodeDt.Rows.InsertAt(dr, 3);
  102. dr = DataCodeDt.NewRow();
  103. dr["DataCodeName"] = "釉坯";
  104. dr["DataCode"] = "40";
  105. DataCodeDt.Rows.InsertAt(dr, 4);
  106. dr = DataCodeDt.NewRow();
  107. dr["DataCodeName"] = "烧成";
  108. dr["DataCode"] = "50";
  109. DataCodeDt.Rows.InsertAt(dr, 5);
  110. dr = DataCodeDt.NewRow();
  111. dr["DataCodeName"] = "成品";
  112. dr["DataCode"] = "60";
  113. DataCodeDt.Rows.InsertAt(dr, 6);
  114. this.CBDataCode.DisplayMember = "DataCodeName";
  115. this.CBDataCode.ValueMember = "DataCode";
  116. this.CBDataCode.DataSource = DataCodeDt;
  117. this.CBDataCode.SelectedValue = "-1";
  118. }
  119. /// <summary>
  120. /// 查询
  121. /// </summary>
  122. /// <param name="sender"></param>
  123. /// <param name="e"></param>
  124. private void tsbtnSearch_Click(object sender, EventArgs e)
  125. {
  126. try
  127. {
  128. //this.dgvLog.DataSource = null;
  129. this.QueryDataFromOther();
  130. tsbtnAdaptive_Click(null, null);
  131. }
  132. catch (Exception ex)
  133. {
  134. // 对异常进行共通处理
  135. ExceptionManager.HandleEventException(this.ToString(),
  136. MethodBase.GetCurrentMethod().Name, this.Text, ex);
  137. }
  138. }
  139. /// <summary>
  140. /// 清除条件
  141. /// </summary>
  142. /// <param name="sender"></param>
  143. /// <param name="e"></param>
  144. private void tsbtnClearCondition_Click(object sender, EventArgs e)
  145. {
  146. //update xiacm 2022-10-12
  147. this.dtpDatebegin.Value = DateTime.Now.Date.AddDays(-1);
  148. this.dtpDateend.Value = DateTime.Now.Date.AddMilliseconds(-1);
  149. this.CBDataCode.SelectedValue = "-1";
  150. }
  151. /// <summary>
  152. /// 自适应列宽
  153. /// </summary>
  154. /// <param name="sender"></param>
  155. /// <param name="e"></param>
  156. private void tsbtnAdaptive_Click(object sender, EventArgs e)
  157. {
  158. this.dgvLog.AutoResizeColumns();
  159. this.dgvSum.AutoResizeColumns();
  160. this.dgvTotal.AutoResizeColumns();//add xiacm 2022-10-12
  161. }
  162. /// <summary>
  163. /// 关闭画面
  164. /// </summary>
  165. /// <param name="sender"></param>
  166. /// <param name="e"></param>
  167. private void tsbtnClose_Click(object sender, EventArgs e)
  168. {
  169. this.Close();
  170. }
  171. /// <summary>
  172. /// 查询同步明细
  173. /// </summary>
  174. /// <param name="sender"></param>
  175. /// <param name="e"></param>
  176. private void dgvLog_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
  177. {
  178. if (e.RowIndex < 0 || this.dgvLog.CurrentRow == null)
  179. {
  180. return;
  181. }
  182. try
  183. {
  184. DataGridViewRow dgvr = this.dgvLog.CurrentRow;
  185. this.dgvSum.DataSource = null;
  186. ClientRequestEntity cre = new ClientRequestEntity();
  187. cre.NameSpace = "Hegii";
  188. cre.Name = "GetWorkData_BG";
  189. cre.Request = dgvr.Cells["logid"].Value;
  190. ServiceResultEntity sre = DoAsync<ServiceResultEntity>(() =>
  191. {
  192. return SAPDataModuleProxy.Service.DoRequest(cre);
  193. }
  194. );
  195. if (sre.Status == Constant.ServiceResultStatus.Success)
  196. {
  197. // 查询成功
  198. this.dgvSum.DataSource = sre.Data.Tables[0];
  199. }
  200. this.tabControl1.SelectedIndex = 2;
  201. }
  202. catch (Exception ex)
  203. {
  204. // 对异常进行共通处理
  205. ExceptionManager.HandleEventException(this.ToString(),
  206. MethodBase.GetCurrentMethod().Name, this.Text, ex);
  207. }
  208. }
  209. #endregion
  210. #region 私有方法
  211. /// <summary>
  212. /// 查询数据
  213. /// </summary>
  214. private void QueryDataFromOther()
  215. {
  216. if (this.dtpDatebegin.Value == null ||
  217. this.dtpDateend.Value == null)
  218. {
  219. return;
  220. }
  221. try
  222. {
  223. this.tsrToolStrip1.Focus();
  224. int Indexed = this.tabControl1.SelectedIndex;
  225. string datacode = this.CBDataCode.SelectedValue.ToString();//数据节点
  226. ClientRequestEntity cre = new ClientRequestEntity();
  227. cre.Properties["datebegin"] = this.dtpDatebegin.Value;
  228. cre.Properties["dateend"] = this.dtpDateend.Value.AddMilliseconds(1);
  229. cre.Properties["datacode"] = datacode;
  230. cre.NameSpace = "Hegii";
  231. if (Indexed == 0)//报工汇总
  232. {
  233. cre.Properties["datebegin"] = this.dtpDatebegin.Value;
  234. cre.Properties["dateend"] = Convert.ToDateTime( this.dtpDateend.Value).AddSeconds(1);
  235. this.dgvTotal.DataSource = null;
  236. cre.Name = "GetDataLogTotal_BG";
  237. }
  238. else if (Indexed == 1)//同步日志
  239. {
  240. this.dgvLog.DataSource = null;
  241. cre.Name = "GetDataLog_BG";
  242. }
  243. else//同步明细
  244. {
  245. this.dgvSum.DataSource = null;
  246. cre.Name = "GetWorkData_BG";
  247. }
  248. ServiceResultEntity sre = DoAsync<ServiceResultEntity>(() =>
  249. {
  250. return SAPDataModuleProxy.Service.DoRequest(cre);
  251. }
  252. );
  253. if (sre.Status == Constant.ServiceResultStatus.Success)
  254. {
  255. if (Indexed == 0)//报工汇总
  256. {
  257. // 查询成功
  258. this.dgvTotal.DataSource = sre.Data.Tables[0];
  259. if(this.dgvTotal.RowCount ==0)
  260. {
  261. DKMessageBox.ShowDialog(this, DKMessageCode.I_CMN_S_001);
  262. }
  263. }
  264. else if (Indexed == 1)
  265. {
  266. // 查询成功
  267. this.dgvLog.DataSource = sre.Data.Tables[0];
  268. // this.tabControl1.SelectedIndex = 0;
  269. if (this.dgvLog.RowCount == 0)
  270. {
  271. DKMessageBox.ShowDialog(this, DKMessageCode.I_CMN_S_001);
  272. }
  273. }
  274. else
  275. {
  276. // 查询成功
  277. this.dgvSum.DataSource = sre.Data.Tables[0];
  278. if (this.dgvSum.RowCount == 0)
  279. {
  280. DKMessageBox.ShowDialog(this, DKMessageCode.I_CMN_S_001);
  281. }
  282. }
  283. }
  284. }
  285. catch (Exception ex)
  286. {
  287. throw ex;
  288. }
  289. }
  290. #endregion
  291. private void lblLabel2_Click(object sender, EventArgs e)
  292. {
  293. }
  294. }
  295. }