XinYu_LZMES_Client/Core.LZMes.Client.UIN/UIN06/UIN060110.cs

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.UIN
{
    public partial class UIN060110 : FrmBase
    {
        public UIN060110()
        {
            InitializeComponent();
        }
        #region "ToolBar Event"
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    this.DoQuery();
                    break;
                case "Add":
                    this.Add();
                    break;
                case "Save":
                    this.Save();
                    this.DoQuery();
                    break;
            }
        }

        private void DoQuery()
        {
            try
            {

                string coilNO = Convert.ToString(Common.FixDBManager.CheckNullStr(this.CombCAL_COIL_NO.Value));


                this.dataSet1.Tables[0].Clear();
                this.dataSet2.Tables[0].Clear();
                this.dataSet3.Tables[0].Clear();

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.COM.ComDBQuery";
                ccp.MethodName = "doSimpleQuery";
                ArrayList paramArray = new ArrayList();
                paramArray.Add("UIN060110_COIL_NO.Select");
                paramArray.Add(coilNO);
                ccp.ServerParams = new object[] { paramArray };
                ccp.SourceDataTable = this.dataSet1.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                System.Diagnostics.Debug.WriteLine(this.dataSet1.Tables[0].ToString());

                ccp = new CoreClientParam();
                ccp.ServerName = "UIB.COM.ComDBQuery";
                ccp.MethodName = "doSimpleQuery";
                paramArray = new ArrayList();
                paramArray.Add("UIN060110_COIL_NO_02.Select");
                paramArray.Add(coilNO);
                ccp.ServerParams = new object[] { paramArray };
                ccp.SourceDataTable = this.dataSet2.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                System.Diagnostics.Debug.WriteLine(this.dataSet2.Tables[0].ToString());

                ccp = new CoreClientParam();
                ccp.ServerName = "UIB.COM.ComDBQuery";
                ccp.MethodName = "doSimpleQuery";
                paramArray = new ArrayList();
                paramArray.Add("UIN060110_COIL_NO_03.Select");
                paramArray.Add(coilNO);
                ccp.ServerParams = new object[] { paramArray };
                ccp.SourceDataTable = this.dataSet3.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                System.Diagnostics.Debug.WriteLine(this.dataSet3.Tables[0].ToString());
            }
            catch (Exception EX)
            {
                MessageBox.Show(EX.ToString());
            }
        }

        public void Add()
        {
            try
            {
                int rowCnt = this.dataSet1.Tables[0].Rows.Count;
                DataRow rowt = this.dataSet1.Tables[0].Rows[rowCnt - 1];

                string seq = rowt["COIL_CUT_SEQ"].ToString();
                int sq = Int16.Parse(seq);
                //rowt["COIL_CUT_SEQ"] = "0" + (sq + 1);

                DataTable dt = this.dataSet1.Tables[0];
                DataRow dr = dt.NewRow();
                dr["CHK"] = "false";
                dr["EN_COIL_NO"] = rowt["EN_COIL_NO"].ToString();
                dr["MILL_DTIME"] = "";
                dr["EXIT_COIL_NO"] = rowt["EXIT_COIL_NO"].ToString();
                dr["COIL_CUT_SEQ"] = "0";
                dr["ACT_WGT"] = "";
                dr["COIL_LEN"] = "";
                dr["COIL_WTH"] = "";
                dr["COIL_THK"] = "";
                dr["COIL_INDIA"] = "";
                dr["COIL_OUTDIA"] = "";
                dt.Rows.InsertAt(dr, rowCnt);


                this.ultraGrid1.Refresh();
                System.Diagnostics.Debug.WriteLine(this.dataSet1.Tables[0].ToString());
            }
            catch (Exception EX)
            {
                MessageBox.Show(EX.ToString());
            }
        }

        public void Save()
        {
            try
            {
                Hashtable paramHsmp = new Hashtable();
                StringBuilder strBf = new StringBuilder();

                this.ultraGrid1.UpdateData();

                int rowCount = 0;
                string coilNo = "";
                string enCoilNo = "";
                string actWgt = "";
                string coilLen = "";
                string coilWth = "";
                string coilThk = "";
                string coilIndia = "";
                string coilOutdia = "";
                string sleeve = "";
                string ordno = "";
                Infragistics.Win.UltraWinGrid.RowsCollection rs = this.ultraGrid1.Rows;
                if (rs.Count > 0)
                {
                    /*
                    for (int i = 0; i < rs.Count; i++)
                    {
                        if (rs[0].Cells["ACT_WGT"].Text.Trim() == null || rs[0].Cells["ACT_WGT"].Text.Trim() == "")
                        {
                            continue;
                        }
                        coilNo = coilNo + rs[0].Cells["EXIT_COIL_NO"].Text.Trim() + "|";
                        enCoilNo = enCoilNo + rs[0].Cells["EN_COIL_NO"].Text.Trim() + "|";
                        actWgt = actWgt + rs[0].Cells["ACT_WGT"].Text.Trim() + "|";
                        coilLen = coilLen + rs[0].Cells["COIL_LEN"].Text.Trim() + "|";
                        coilWth = coilWth + rs[0].Cells["COIL_WTH"].Text.Trim() + "|";
                        coilThk = coilThk + rs[0].Cells["COIL_THK"].Text.Trim() + "|";
                        coilIndia = coilIndia + rs[0].Cells["COIL_INDIA"].Text.Trim() + "|";
                        coilOutdia = coilOutdia + rs[0].Cells["COIL_OUTDIA"].Text.Trim() + "|";
                        sleeve = sleeve + rs[0].Cells["SLEEVE"].Text.Trim() + "|";
                        rowCount += 1;
                    }*/
                    for (int i = 0; i < rs.Count; i++)
                    {
                        if (rs[i].Cells["CHK"].Text.Trim() == "True" && rs[i].Cells["ACT_WGT"].Text.Trim() != null && rs[i].Cells["ACT_WGT"].Text.Trim() != "")
                        {
                            coilNo = rs[i].Cells["EXIT_COIL_NO"].Text.Trim();// +"|";
                            enCoilNo = rs[i].Cells["EN_COIL_NO"].Text.Trim();//+ "|";
                            actWgt = rs[i].Cells["ACT_WGT"].Text.Trim();//+ "|";
                            coilLen = rs[i].Cells["COIL_LEN"].Text.Trim();// + "|";
                            coilWth = rs[i].Cells["COIL_WTH"].Text.Trim();//+ "|";
                            coilThk = rs[i].Cells["COIL_THK"].Text.Trim();// + "|";
                            coilIndia = rs[i].Cells["COIL_INDIA"].Text.Trim();// + "|";
                            coilOutdia = rs[i].Cells["COIL_OUTDIA"].Text.Trim();// + "|";
                            ordno = rs[i].Cells["ORDNO"].Text.Trim();//+ "|";
                            rowCount += 1;

                            paramHsmp = new Hashtable();
                            ////shiji 
                            paramHsmp.Add("i1", this.UserInfo.GetUserID());
                            paramHsmp.Add("i2", enCoilNo);
                            paramHsmp.Add("i3", coilNo);
                            paramHsmp.Add("i4", ordno);
                            paramHsmp.Add("i5", actWgt);
                            paramHsmp.Add("i6", coilLen);
                            paramHsmp.Add("i7", coilWth);
                            paramHsmp.Add("i8", coilThk);
                            paramHsmp.Add("i9", coilIndia);
                            paramHsmp.Add("i10", coilOutdia);
                            paramHsmp.Add("i11", "");
                            paramHsmp.Add("i12", "");
                            paramHsmp.Add("i13", "");
                            paramHsmp.Add("i14", "MAN");
                            paramHsmp.Add("o15", "");

                            CoreClientParam ccp = new CoreClientParam();
                            ccp.ServerName = "UIB.COM.ComDBProcedure";
                            ccp.MethodName = "doXmlProcedure";
                            //ccp.ServerParams = new Object[] { "UIN060110_CAL_RESULT.call", paramHsmp };
                            ccp.ServerParams = new Object[] { "UIN060110_CAL_RESULT_NEW.call", paramHsmp };
                            this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                            //提示
                            ArrayList all = ccp.ReturnObject as ArrayList;
                            if (all[0].ToString() != "YY")//确认是否存在问题
                            {
                                MessageBox.Show(all[0].ToString(), "提示");
                            }

                        }

                    }
                    //coilNo = rs[0].Cells["EXIT_COIL_NO"].Text.Trim();
                    //enCoilNo = rs[0].Cells["EN_COIL_NO"].Text.Trim();
                    //ordno = rs[0].Cells["ORDNO"].Text.Trim();
                    //actWgt = rs[0].Cells["ACT_WGT"].Text.Trim();
                    //coilLen = rs[0].Cells["COIL_LEN"].Text.Trim();
                    //coilWth = rs[0].Cells["COIL_WTH"].Text.Trim();
                    //coilThk = rs[0].Cells["COIL_THK"].Text.Trim();
                    //coilIndia = rs[0].Cells["COIL_INDIA"].Text.Trim();
                    //coilOutdia = rs[0].Cells["COIL_OUTDIA"].Text.Trim();
                    //sleeve = rs[0].Cells["SLEEVE"].Text.Trim();

                    //操作人
                    //paramHsmp.Add("i1", this.UserInfo.GetUserID());
                    //paramHsmp.Add("i2", "");
                    //paramHsmp.Add("i3", "");
                    //paramHsmp.Add("i4", rowCount);
                    //paramHsmp.Add("i5", enCoilNo);
                    //paramHsmp.Add("i6", coilNo);
                    //paramHsmp.Add("i7", "");
                    //paramHsmp.Add("i8", ordno);
                    //paramHsmp.Add("i9", actWgt);
                    //paramHsmp.Add("i10", coilLen);
                    //paramHsmp.Add("i11", coilWth);
                    //paramHsmp.Add("i12", coilThk);
                    //paramHsmp.Add("i13", coilIndia);
                    //paramHsmp.Add("i14", coilOutdia);
                    //paramHsmp.Add("i15", "");
                }
            }
            catch (Exception EX)
            {
                MessageBox.Show(EX.ToString());
            }

        }
        #endregion

        #region "Init"
        public void init()
        {
            
            DataTable dt = new DataTable();
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "UIB.COM.ComDBQuery";
            ccp.MethodName = "doSimpleQuery";
            ArrayList paramArray = new ArrayList();
            paramArray.Add("UIECOMM00_SELECT.CAL_COILNO");
            ccp.ServerParams = new object[] { paramArray };
            ccp.SourceDataTable = dt;
            this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
            Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.CombCAL_COIL_NO, ref dt, "COIL_NO");

        }

        private void UIN060110_Load(object sender, EventArgs e)
        {
            init();
        }
        #endregion

        private void CombCAL_COIL_NO_ValueChanged(object sender, EventArgs e)
        {
            this.DoQuery();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                Hashtable ht = new Hashtable();
                ht.Add("i1" ,this.CombCAL_COIL_NO.Text.Trim());

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.COM.ComDBProcedure";
                ccp.MethodName = "doXmlProcedure";
                ccp.ServerParams = new Object[] { "UIN060110_CAL_RESULT_NEW_TEMP.call", ht };
                this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            }
            catch (Exception ex)
            {
                MessageBox.Show("系统发生未知异常" ,"提示");
            }
        }
    }
}