XinYu_LZMES_Client/Core.LZMes.Client.UIE/UIE041100.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.UIE
{
    public partial class UIE041100 : FrmBase
    {
        public UIE041100()
        {
            InitializeComponent();
        }
        
        public void init()
        {
            //string tt = System.DateTime.Today.Year.ToString() + "-" + System.DateTime.Today.Month.ToString() + "-" + "01 00:00:00";
            //string tb = System.DateTime.Today.Year.ToString() + "-" + System.DateTime.Today.Month.ToString() + "-" + "28 00:00:00";
            //System.DateTime firstDate = Convert.ToDateTime(tt);
            //System.DateTime lastDate = Convert.ToDateTime(tb);
            //this.dateTimePlanFrom.Value = firstDate;
            //this.dateTimePlanTo.Value = lastDate;
            //this.delToDateFrom.Value = firstDate;
            //this.DelToDateTo.Value = lastDate;

            string commCodeCd = "E01006";
            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.ComboPrcEndCD, ref dt, "E01006");
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    this.DoQuery();
                    break;
                case "Save":
                    this.Save();
                    this.DoQuery();
                    break;
            }
        }

        //查询
        private void DoQuery()
        {


            try
            {
                this.dataSet1.Tables[0].Clear();
                ArrayList arrayParam = new ArrayList();

                arrayParam.Add("UIE041100.OrdPrc.Select");
                //操作人
                //arrayParam.Add(this.UserInfo.GetUserID());
                //操作程序
                //arrayParam.Add("UIE041100");
                //合同号

                string starttime = this.ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd");
                arrayParam.Add(starttime);
                string endtime = this.ultraDateTimeEditor2.DateTime.ToString("yyyyMMdd");
                arrayParam.Add(endtime);
                string ordNO = Convert.ToString(Common.FixDBManager.CheckNullStr(this.textOrdNO.Text));
                arrayParam.Add(ordNO);
                //订单号
                string ordSeq = Convert.ToString(Common.FixDBManager.CheckNullStr(this.comboOrdSeq.Value));
                arrayParam.Add(ordSeq);
                //客户名称
                string prcEndCD = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ComboPrcEndCD.Value));
                arrayParam.Add(prcEndCD);
                

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.COM.ComDBQuery";
                ccp.MethodName = "doSimpleQuery";
                ccp.ServerParams = new object[] { arrayParam };
                ccp.SourceDataTable = this.dataSet1.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);

                DataRowCollection drs = dataSet1.Tables[0].Rows;


                for (int i = 0; i < drs.Count; i++)
                {
                    Color color = Color.FromArgb(255, 255, 255);
                    double shipEndWgt = double.Parse(drs[i]["SHIP_END_WGT"].ToString().Trim());
                    double wgtAcvalMin = double.Parse(drs[i]["WGT_ACVAL_MIN"].ToString().Trim());
                    if (shipEndWgt.CompareTo(wgtAcvalMin) > 0)
                    {
                        color = Color.LightGray;
                    }

                    ultraGrid1.Rows[i].Appearance.BackColor = color;
                }
            }
            catch (Exception EX)
            {
                MessageBox.Show(EX.ToString());
            }
        }

        public void Save()
        {
            try
            {
                string tempWgt = Convert.ToString(Common.FixDBManager.CheckNullStr(this.tempWgt.Text));
                Hashtable paramHsmp = new Hashtable();
                StringBuilder strBf = new StringBuilder();

                this.ultraGrid1.UpdateData();
                DataRow[] selectedRows = this.dataSet1.Tables[0].Select("CHK ='True'");
                //this.ultraGrid2.ActiveRow.Cells["CHK"].Text == "True"
                string msg = "";
                string retCD = "";
                for (int i = 0; i < selectedRows.Length; i++)
                {
                    strBf.Append(selectedRows[i]["ORD_NO"]).Append(selectedRows[i]["ORD_SEQ"]).Append("|");
                }

                //操作人
                paramHsmp.Add("i1", this.UserInfo.GetUserID());
                //操作程序
                paramHsmp.Add("i2", "UIE041100");
                paramHsmp.Add("i3", strBf.ToString());
                paramHsmp.Add("i4", tempWgt);
                paramHsmp.Add("o5", retCD);
                paramHsmp.Add("o6", msg);
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.COM.ComDBProcedure";
                ccp.MethodName = "doXmlProcedure";
                ccp.ServerParams = new Object[] { "UIE041100_PRC_END.call", paramHsmp };
                CoreClientParam obj = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                System.Collections.ArrayList err = obj.ReturnObject as System.Collections.ArrayList;
                if (err != null && err.Count > 0 && err[0] != null)
                {
                    MessageBox.Show(err[0].ToString());
                }
            }
            catch (Exception EX)
            {
                MessageBox.Show(EX.ToString());
            }
        }

        //获取订单序号
        public void getOrdSeq()
        {
            try
            {
                string ordNO = this.textOrdNO.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.comboOrdSeq, ref dt, "ORD_SEQ");
            }
            catch (Exception EX)
            {
                MessageBox.Show(EX.ToString());
            }
        }
        private void checkBox1_CheckedChanged(object sender, EventArgs e)
        {
            try
            {
                foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugr in this.ultraGrid1.Rows)
                {
                    ugr.Cells["CHK"].Value = this.checkBox1.Checked;
                    ugr.Update();
                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
        }

        private void textOrdNO_MouseLeave(object sender, EventArgs e)
        {
            getOrdSeq();
        }

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

        
    }
}