| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151 |
- using System;
- using System.Collections.Generic;
- using System.ComponentModel;
- using System.Data;
- using System.Drawing;
- using System.Linq;
- using System.Text;
- using System.Windows.Forms;
- using CoreFS.CA06;
- using System.Collections;
- namespace Core.LZMes.Client.UIE
- {
- public partial class UIE041070 : FrmBase
- {
- public UIE041070()
- {
- InitializeComponent();
- }
- public override void ToolBar_Click(object sender, string ToolbarKey)
- {
- switch (ToolbarKey)
- {
- case "Query":
- this.DoQuery();
- break;
- }
- }
- public string Condition
- {
- set
- {
- string[] array = value.Trim().Split(new char[] { '|' });
- if (array.Length < 3) return;
- this.textORD_NO.Text = array[0];
- this.ComboORD_SEQ.Value = array[1];
- this.ComboPROG_CD.Value = array[2];
- this.DoQuery();
- }
- }
- public void init()
- {
- string commCodeCd = "E01002";
- DataTable dt = new DataTable();
- CoreClientParam ccp = new CoreClientParam();
- ccp.ServerName = "UIB.COM.ComDBQuery";
- ccp.MethodName = "doSimpleQuery";
- ArrayList paramArray = new ArrayList();
- paramArray.Add("UIECOMM00_SELECT.COMM_CODE");
- paramArray.Add(commCodeCd);
- ccp.ServerParams = new object[] { paramArray };
- ccp.SourceDataTable = dt;
- this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
- Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.ComboPROG_CD, ref dt, "E01002");
- }
- public void getOrdSeq()
- {
- try
- {
- string ordNO = this.textORD_NO.Text;
- DataTable dt = new DataTable();
- ArrayList paramArray = new ArrayList();
- paramArray.Add("UIECOMM00_SELECT.ORD_SEQ");
- paramArray.Add(ordNO);
- CoreClientParam ccp = new CoreClientParam();
- ccp.ServerName = "UIB.COM.ComDBQuery";
- ccp.MethodName = "doSimpleQuery";
- ccp.ServerParams = new object[] { paramArray };
- ccp.SourceDataTable = dt;
- this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
- Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.ComboORD_SEQ, ref dt, "ORD_SEQ");
- }
- catch (Exception EX)
- {
- MessageBox.Show(EX.ToString());
- }
- }
- private void DoQuery()
- {
- try
- {
- string ordNO = Convert.ToString(Common.FixDBManager.CheckNullStr(this.textORD_NO.Text));
- string ordSeq = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ComboORD_SEQ.Value));
- string progCD = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ComboPROG_CD.Value));
- this.dataSet1.Tables[0].Clear();
- CoreClientParam ccp = new CoreClientParam();
- ccp.ServerName = "UIB.COM.ComDBQuery";
- ccp.MethodName = "doSimpleQuery";
- ArrayList paramArray = new ArrayList();
- paramArray.Add("UIE041070.COIL.Select");
- paramArray.Add(ordNO);
- paramArray.Add(ordSeq);
- paramArray.Add(progCD);
- paramArray.Add(ordNO);
- paramArray.Add(ordSeq);
- paramArray.Add(progCD);
- paramArray.Add(ordNO);
- paramArray.Add(ordSeq);
- paramArray.Add(progCD);
- paramArray.Add(ordNO);
- paramArray.Add(ordSeq);
- paramArray.Add(progCD);
- paramArray.Add(ordNO);
- paramArray.Add(ordSeq);
- paramArray.Add(progCD);
- paramArray.Add(ordNO); //
- paramArray.Add(ordSeq);//
- paramArray.Add(progCD);//
- ccp.ServerParams = new object[] { paramArray};
- ccp.SourceDataTable = this.dataSet1.Tables[0];
- this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
- Console.WriteLine(this.dataSet1.Tables[0].ToString());
- }
- catch (Exception EX)
- {
- MessageBox.Show(EX.ToString());
- }
- }
- private void UIE041070_Load(object sender, EventArgs e)
- {
- init();
- }
- private void textORD_NO_Leave(object sender, EventArgs e)
- {
- this.getOrdSeq();
- }
- private void ultraGrid1_AfterCellActivate(object sender, EventArgs e)
- {
- Infragistics.Win.UltraWinGrid.UltraGrid tt = (Infragistics.Win.UltraWinGrid.UltraGrid)sender;
- string matNO = Convert.ToString(Common.FixDBManager.CheckNullStr(tt.ActiveRow.Cells["MAT_NO"].Value));
- UIE041090 frm = new UIE041090();
- frm.ob = this.ob;
- frm.Condition = matNO;
- frm.ShowDialog();
- }
- }
- }
|