XinYu_LZMES_Client/Core.LZMes.Client.UIM/UIM01/UIM010290.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 Core.LZMes.Client.UIE;
using System.Collections;

namespace Core.LZMes.Client.UIM
{
    public partial class UIM010290 : FrmBase
    {
        public UIM010290()
        {
            InitializeComponent();
        }
        private void init()
        {
            string commCodeCd = "M01001";
            DataTable dt = new DataTable();
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "UIB.COM.ComDBQuery";
            ccp.MethodName = "doSimpleQuery";
            System.Collections.ArrayList paramArray = new System.Collections.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.ComboOrdProc, ref dt, "M01001");
        }
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    this.DoQuery();
                    break;
                case "Save":
                    this.DoSave();
                    break;
                case "setDefectiveCoil":
                    this.setDefectiveCoil();
                    break;
                case "unsetDefectiveCoil":
                    this.unsetDefectiveCoil();
                    break;
            }
        }

        /// <summary>
        /// 查询待入库钢卷
        /// </summary>
        private void DoQuery()
        {
            try
            {
                this.dataSet1.Tables[0].Clear();
                
                string procuctedTime = ultraDateTimeEditor1.Value != null ? ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd") : "";
                string procuctedTime2 = ultraDateTimeEditor1.Value != null ? ultraDateTimeEditor2.DateTime.ToString("yyyyMMdd") : "";
                string coilNo = textBox9.Text.Trim();

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.COM.ComDBQuery";
                ccp.MethodName = "doSimpleQuery";
                System.Collections.ArrayList paramArray = new System.Collections.ArrayList();
                if (this.CustomInfo=="2")
                    paramArray.Add("UIM010290_04.SELECT");
                else
                    paramArray.Add("UIM010290_03.SELECT");
                paramArray.Add(coilNo);
                paramArray.Add(procuctedTime);
                paramArray.Add(procuctedTime2);
                paramArray.Add(coilNo);
                ccp.ServerParams = new object[] { paramArray };
                ccp.SourceDataTable = this.dataSet1.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);

                textBox1.Text = "";
            }
            catch (Exception EX)
            {
                MessageBox.Show(EX.ToString());
            }
        }

        /// <summary>
        /// 待处理钢卷保存
        /// </summary>
        private void DoSave()
        {
            

            string entryShift = UserInfo.GetUserOrder();//入库班次
            string entryGroup = UserInfo.GetUserGroup();//入库班组
            string reg_id = UserInfo.GetUserID();//操作人
            string mdType = Common.FixDBManager.CheckNullStr(Convert.ToString(this.ComboOrdProc.Value));//操作类型
            string coilno = Common.FixDBManager.CheckNullStr(Convert.ToString(this.textBox1.Text));//操作类型
            string fbreason = Common.FixDBManager.CheckNullStr(Convert.ToString(this.textBox2.Text));//封闭原因
            string msg = "";
            string line = "";
            if (this.CustomInfo == "2") line = "S";
            else line = "L";
            this.ultraGrid1.UpdateData();
            StringBuilder strBf = new StringBuilder();
            DataRow[] selectedRows = this.dataSet1.Tables[0].Select("CHK ='True'");
            for (int i = 0; i < selectedRows.Length; i++)
            {
                strBf.Append(selectedRows[i]["COIL_NO"]).Append("|");
            }
            Hashtable paramHsmp = new Hashtable();
            paramHsmp.Add("i1", reg_id);
            paramHsmp.Add("i2", entryShift);
            paramHsmp.Add("i3", entryGroup);
            paramHsmp.Add("i4", mdType);
            paramHsmp.Add("i5", strBf.ToString());
            paramHsmp.Add("i6", line);
            paramHsmp.Add("i7", fbreason);
            paramHsmp.Add("o8", msg);

            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "UIB.COM.ComDBProcedure";
            ccp.MethodName = "doXmlProcedure";
            ccp.ServerParams = new object[] { "UIM010290_03.CALL", paramHsmp };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

            if (0 == ccp.ReturnCode)
            {
                MessageBox.Show("操作成功！");
            }
            
            DoQuery();
        }

        /// <summary>
        /// 次品卷指定
        /// </summary>
        private void setDefectiveCoil()
        {
            /*
            for (int i = 0; i < this.ultraGrid1.Rows.Count; i++)
            {
                if(this.ultraGrid1.Rows[i].Cells["CHK"].Value.Equals("Y"))
                {
                    str.Append(this.ultraGrid1.Rows[i].Cells["COIL_NO"].Value).Append(",");
                }
            }*/
            this.ultraGrid1.UpdateData();
            StringBuilder strBf = new StringBuilder();
            DataRow[] selectedRows = this.dataSet1.Tables[0].Select("CHK ='True'");
            for (int i = 0; i < selectedRows.Length; i++)
            {
                strBf.Append(selectedRows[i]["COIL_NO"]).Append("|");
            }

            string entryShift = UserInfo.GetUserOrder();//入库班次
            string entryGroup = UserInfo.GetUserGroup();//入库班组
            string reg_id = UserInfo.GetUserID();//操作人
            string mdType = Common.FixDBManager.CheckNullStr(Convert.ToString(this.ComboOrdProc.Value));//操作类型
            //string coilno = Common.FixDBManager.CheckNullStr(Convert.ToString(this.textBox1.Text));//操作类型
            string msg = "";
            string line = "";
            if (this.CustomInfo == "2") line = "S";
            else line = "L";
            Hashtable paramHsmp = new Hashtable();
            paramHsmp.Add("i1", reg_id);
            paramHsmp.Add("i2", entryShift);
            paramHsmp.Add("i3", entryGroup);
            paramHsmp.Add("i4", "02");  // M01002  01：取消  02：指定
            paramHsmp.Add("i5", strBf.ToString());
            paramHsmp.Add("i6", line);
            paramHsmp.Add("o7", msg);

            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "UIB.COM.ComDBProcedure";
            ccp.MethodName = "doXmlProcedure";
            ccp.ServerParams = new object[] { "UIM010290_04.CALL", paramHsmp };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

            if (0 == ccp.ReturnCode)
            {
                MessageBox.Show("操作成功！");
            }

            DoQuery();
        }

        /// <summary>
        /// 次品卷指定
        /// </summary>
        private void unsetDefectiveCoil()
        {
            /*
            String str = "";
            for (int i = 0; i < this.ultraGrid1.Rows.Count; i++)
            {
                if (this.ultraGrid1.Rows[i].Cells["CHK"].Value.Equals("Y"))
                {
                    str = str + this.ultraGrid1.Rows[i].Cells[""].Value + ",";
                }
            }*/
            this.ultraGrid1.UpdateData();
            StringBuilder strBf = new StringBuilder();
            DataRow[] selectedRows = this.dataSet1.Tables[0].Select("CHK ='True'");
            for (int i = 0; i < selectedRows.Length; i++)
            {
                strBf.Append(selectedRows[i]["COIL_NO"]).Append("|");
            }
            string entryShift = UserInfo.GetUserOrder();//入库班次
            string entryGroup = UserInfo.GetUserGroup();//入库班组
            string reg_id = UserInfo.GetUserID();//操作人
            string mdType = Common.FixDBManager.CheckNullStr(Convert.ToString(this.ComboOrdProc.Value));//操作类型
            //string coilno = Common.FixDBManager.CheckNullStr(Convert.ToString(this.textBox1.Text));//操作类型
            string msg = "";
            string line = "";
            if (this.CustomInfo == "2") line = "S";
            else line = "L";
            Hashtable paramHsmp = new Hashtable();
            paramHsmp.Add("i1", reg_id);
            paramHsmp.Add("i2", entryShift);
            paramHsmp.Add("i3", entryGroup);
            paramHsmp.Add("i4", "01");   // M01002  01：取消  02：指定
            paramHsmp.Add("i5", strBf.ToString());
            paramHsmp.Add("i6", line);
            paramHsmp.Add("o7", msg);

            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "UIB.COM.ComDBProcedure";
            ccp.MethodName = "doXmlProcedure";
            ccp.ServerParams = new object[] { "UIM010290_04.CALL", paramHsmp };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

            if (0 == ccp.ReturnCode)
            {
                MessageBox.Show("操作成功！");
            }

            DoQuery();
        }

        private void ultraGrid1_CellChange(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e)
        {

        }

        private void UIM010290_Load(object sender, EventArgs e)
        {
            init();
        }

        private void ultraGrid1_MouseDoubleClick(object sender, Infragistics.Win.UltraWinGrid.DoubleClickRowEventArgs e)
        {
            textBox1.Text = e.Row.Cells["COIL_NO"].Value.ToString();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            int jx = 1;
            string mod_name = this.UserInfo.GetUserName();
             DataRow[] selectedRows = dataSet1.Tables[0].Select("CHK ='True'");
             for (int i = 0; i < selectedRows.Length; i++)
             {
                 string coilno = Convert.ToString(Common.FixDBManager.CheckNullStr(selectedRows[i]["COIL_NO"]));
                 string ycscczyj = Convert.ToString(Common.FixDBManager.CheckNullStr(selectedRows[i]["YCSCCZYJ"]));
                 string ycjsczyj = Convert.ToString(Common.FixDBManager.CheckNullStr(selectedRows[i]["YCJSCZYJ"]));
                 Hashtable ht = new Hashtable();
                 ht.Add("i" + jx, coilno); jx++;//卷号
                 ht.Add("i" + jx, ycscczyj); jx++;//生产意见
                 ht.Add("i" + jx, ycjsczyj); jx++;//技术意见
                 ht.Add("i" + jx, mod_name); jx++;//变更人
                 ht.Add("o" + jx, ""); jx = 1;
                 CoreClientParam ccp1 = new CoreClientParam();
                 ccp1.ServerName = "UIB.COM.ComDBProcedure";
                 ccp1.MethodName = "doXmlProcedure";
                 ccp1.ServerParams = new object[] { "UIM010290_06.CALL", ht };
                 this.ExecuteNonQuery(ccp1, CoreInvokeType.Internal);
                 ArrayList all = ccp1.ReturnObject as ArrayList;
                 if (all[0].ToString() != "YY")//确认是否存在问题
                 {
                     MessageBox.Show(all[0].ToString(), "提示");
                     return;
                 }
             }
             MessageBox.Show("录入成功", "提示");
             DoQuery();  
        }
    }
}