F_SAP_HEGII_0107.cs 8.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320
  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"] = "55";
  113. DataCodeDt.Rows.InsertAt(dr, 6);
  114. dr = DataCodeDt.NewRow();
  115. dr["DataCodeName"] = "成品";
  116. dr["DataCode"] = "60";
  117. DataCodeDt.Rows.InsertAt(dr, 7);
  118. this.CBDataCode.DisplayMember = "DataCodeName";
  119. this.CBDataCode.ValueMember = "DataCode";
  120. this.CBDataCode.DataSource = DataCodeDt;
  121. this.CBDataCode.SelectedValue = "-1";
  122. }
  123. /// <summary>
  124. /// 查询
  125. /// </summary>
  126. /// <param name="sender"></param>
  127. /// <param name="e"></param>
  128. private void tsbtnSearch_Click(object sender, EventArgs e)
  129. {
  130. try
  131. {
  132. //this.dgvLog.DataSource = null;
  133. this.QueryDataFromOther();
  134. tsbtnAdaptive_Click(null, null);
  135. }
  136. catch (Exception ex)
  137. {
  138. // 对异常进行共通处理
  139. ExceptionManager.HandleEventException(this.ToString(),
  140. MethodBase.GetCurrentMethod().Name, this.Text, ex);
  141. }
  142. }
  143. /// <summary>
  144. /// 清除条件
  145. /// </summary>
  146. /// <param name="sender"></param>
  147. /// <param name="e"></param>
  148. private void tsbtnClearCondition_Click(object sender, EventArgs e)
  149. {
  150. //update xiacm 2022-10-12
  151. this.dtpDatebegin.Value = DateTime.Now.Date.AddDays(-1);
  152. this.dtpDateend.Value = DateTime.Now.Date.AddMilliseconds(-1);
  153. this.CBDataCode.SelectedValue = "-1";
  154. }
  155. /// <summary>
  156. /// 自适应列宽
  157. /// </summary>
  158. /// <param name="sender"></param>
  159. /// <param name="e"></param>
  160. private void tsbtnAdaptive_Click(object sender, EventArgs e)
  161. {
  162. this.dgvLog.AutoResizeColumns();
  163. this.dgvSum.AutoResizeColumns();
  164. this.dgvTotal.AutoResizeColumns();//add xiacm 2022-10-12
  165. }
  166. /// <summary>
  167. /// 关闭画面
  168. /// </summary>
  169. /// <param name="sender"></param>
  170. /// <param name="e"></param>
  171. private void tsbtnClose_Click(object sender, EventArgs e)
  172. {
  173. this.Close();
  174. }
  175. /// <summary>
  176. /// 查询同步明细
  177. /// </summary>
  178. /// <param name="sender"></param>
  179. /// <param name="e"></param>
  180. private void dgvLog_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
  181. {
  182. if (e.RowIndex < 0 || this.dgvLog.CurrentRow == null)
  183. {
  184. return;
  185. }
  186. try
  187. {
  188. DataGridViewRow dgvr = this.dgvLog.CurrentRow;
  189. this.dgvSum.DataSource = null;
  190. ClientRequestEntity cre = new ClientRequestEntity();
  191. cre.NameSpace = "Hegii";
  192. cre.Name = "GetWorkData_BG";
  193. cre.Request = dgvr.Cells["logid"].Value;
  194. ServiceResultEntity sre = DoAsync<ServiceResultEntity>(() =>
  195. {
  196. return SAPDataModuleProxy.Service.DoRequest(cre);
  197. }
  198. );
  199. if (sre.Status == Constant.ServiceResultStatus.Success)
  200. {
  201. // 查询成功
  202. this.dgvSum.DataSource = sre.Data.Tables[0];
  203. }
  204. this.tabControl1.SelectedIndex = 2;
  205. }
  206. catch (Exception ex)
  207. {
  208. // 对异常进行共通处理
  209. ExceptionManager.HandleEventException(this.ToString(),
  210. MethodBase.GetCurrentMethod().Name, this.Text, ex);
  211. }
  212. }
  213. #endregion
  214. #region 私有方法
  215. /// <summary>
  216. /// 查询数据
  217. /// </summary>
  218. private void QueryDataFromOther()
  219. {
  220. if (this.dtpDatebegin.Value == null ||
  221. this.dtpDateend.Value == null)
  222. {
  223. return;
  224. }
  225. try
  226. {
  227. this.tsrToolStrip1.Focus();
  228. int Indexed = this.tabControl1.SelectedIndex;
  229. string datacode = this.CBDataCode.SelectedValue.ToString();//数据节点
  230. ClientRequestEntity cre = new ClientRequestEntity();
  231. cre.Properties["datebegin"] = this.dtpDatebegin.Value;
  232. cre.Properties["dateend"] = this.dtpDateend.Value.AddMilliseconds(1);
  233. cre.Properties["datacode"] = datacode;
  234. cre.NameSpace = "Hegii";
  235. if (Indexed == 0)//报工汇总
  236. {
  237. cre.Properties["datebegin"] = this.dtpDatebegin.Value;
  238. cre.Properties["dateend"] = Convert.ToDateTime( this.dtpDateend.Value).AddSeconds(1);
  239. this.dgvTotal.DataSource = null;
  240. cre.Name = "GetDataLogTotal_BG";
  241. }
  242. else if (Indexed == 1)//同步日志
  243. {
  244. this.dgvLog.DataSource = null;
  245. cre.Name = "GetDataLog_BG";
  246. }
  247. else//同步明细
  248. {
  249. this.dgvSum.DataSource = null;
  250. cre.Name = "GetWorkData_BG";
  251. }
  252. ServiceResultEntity sre = DoAsync<ServiceResultEntity>(() =>
  253. {
  254. return SAPDataModuleProxy.Service.DoRequest(cre);
  255. }
  256. );
  257. if (sre.Status == Constant.ServiceResultStatus.Success)
  258. {
  259. if (Indexed == 0)//报工汇总
  260. {
  261. // 查询成功
  262. this.dgvTotal.DataSource = sre.Data.Tables[0];
  263. if(this.dgvTotal.RowCount ==0)
  264. {
  265. DKMessageBox.ShowDialog(this, DKMessageCode.I_CMN_S_001);
  266. }
  267. }
  268. else if (Indexed == 1)
  269. {
  270. // 查询成功
  271. this.dgvLog.DataSource = sre.Data.Tables[0];
  272. // this.tabControl1.SelectedIndex = 0;
  273. if (this.dgvLog.RowCount == 0)
  274. {
  275. DKMessageBox.ShowDialog(this, DKMessageCode.I_CMN_S_001);
  276. }
  277. }
  278. else
  279. {
  280. // 查询成功
  281. this.dgvSum.DataSource = sre.Data.Tables[0];
  282. if (this.dgvSum.RowCount == 0)
  283. {
  284. DKMessageBox.ShowDialog(this, DKMessageCode.I_CMN_S_001);
  285. }
  286. }
  287. }
  288. }
  289. catch (Exception ex)
  290. {
  291. throw ex;
  292. }
  293. }
  294. #endregion
  295. }
  296. }