F_SAP_HEGII_0107.cs 8.6 KB

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