UIK080013.cs 2.6 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Windows.Forms;
  9. using CoreFS.CA06;
  10. using System.Collections;
  11. namespace Core.LZMes.Client.UIK
  12. {
  13. public partial class UIK080013 : FrmBase
  14. {
  15. public UIK080013()
  16. {
  17. InitializeComponent();
  18. }
  19. public override void ToolBar_Click(object sender, string ToolbarKey)
  20. {
  21. switch(ToolbarKey){
  22. case "Query":
  23. this.doQuery();
  24. break;
  25. }
  26. }
  27. private void init(){
  28. string commCodeCd = "E04001";
  29. DataTable dt = new DataTable();
  30. CoreClientParam ccp = new CoreClientParam();
  31. ccp.ServerName = "UIB.COM.ComDBQuery";
  32. ccp.MethodName = "doSimpleQuery";
  33. ArrayList paramArray = new ArrayList();
  34. paramArray.Add("UIECOMM00_SELECT.COMM_CODE");
  35. paramArray.Add(commCodeCd);
  36. ccp.ServerParams = new object[] { paramArray };
  37. ccp.SourceDataTable = dt;
  38. this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
  39. Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.ComboOPTTYPE, ref dt, "E04001");
  40. }
  41. public void doQuery() {
  42. try {
  43. this.dataSet1.Tables[0].Clear();
  44. ArrayList arrayParam = new ArrayList();
  45. string queryStart= Convert.ToString(Common.FixDBManager.CheckNullStr(this.ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd")));
  46. string queryEnd = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ultraDateTimeEditor2.DateTime.ToString ("yyyyMMdd")));
  47. string opType = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ComboOPTTYPE.Value));
  48. arrayParam.Add("UIK080013_regdate_query");
  49. arrayParam.Add(queryStart);
  50. arrayParam.Add(queryEnd);
  51. arrayParam.Add(opType);
  52. CoreClientParam ccp = new CoreClientParam();
  53. ccp.ServerName ="UIB.COM.ComDBQuery";
  54. ccp.MethodName="doSimpleQuery";
  55. ccp.ServerParams = new object[] {arrayParam };
  56. ccp.SourceDataTable = this.dataSet1.Tables[0];
  57. this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
  58. }catch(Exception ex){
  59. }
  60. }
  61. private void UIK080013_Load(object sender, EventArgs e)
  62. {
  63. init();
  64. }
  65. }
  66. }