XinYu_LZMES_Client/.svn/pristine/05/054d96ac24ee37d315d65788e11d84110bd538d1.svn-base

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;

namespace Core.LZMes.Client.UIM
{
    public partial class UIM010232 : FrmBase
    {
        public UIM010232()
        {
            InitializeComponent();
        }

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

        /// <summary>
        /// 查询成品库库存数据
        /// </summary>
        private void DoQuery()
        {
            try
            {
                this.dataSet1.Tables[0].Clear();

                string startTime = this.ultraDateTimeEditor1.Value != null ? ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd") : "";//入库开始时间
                string endTime = this.ultraDateTimeEditor2.Value != null ? ultraDateTimeEditor2.DateTime.ToString("yyyyMMdd") : "";//入库结束时间
                string specStlGrd = this.textBox3.Text;//牌号
                string coilWthMin = this.textBox4.Text;//宽度最小值
                string coilWthMax = this.textBox5.Text;//宽度最大值
                string coilThkMin = this.textBox6.Text;//厚度最小值
                string coilThkMax = this.textBox7.Text;//厚度最大值
                string curLoadLoc = this.textBox8.Text;//垛位
                string coilNo = this.textBox9.Text;//钢卷号
                string ordNo = this.textBox11.Text;//订单号
                string ordSeq = "";// this.textBox12.Text;//合同号
                string ordFl = -1 == this.ultraComboEditor5.SelectedIndex ? "" : this.ultraComboEditor5.Value.ToString();//订单区分
                string devlmtDate = this.ultraDateTimeEditor3.Value != null ? ultraDateTimeEditor3.DateTime.ToString("yyyyMMdd") : "";//交货期
                string progCd = -1 == this.ultraComboEditor2.SelectedIndex ? "" : this.ultraComboEditor2.Value.ToString();//进程状态
                string smpSendTime = this.ultraDateTimeEditor4.Value != null ? ultraDateTimeEditor4.DateTime.ToString("yyyyMMdd") : "";//送样时间
                string prodnmCd = -1 == this.ultraComboEditor6.SelectedIndex ? "" : this.ultraComboEditor6.Value.ToString();//产品类型

                string[] queryParams = new string[] { startTime, endTime, specStlGrd, coilWthMin, coilWthMax, 
                    coilThkMin, coilThkMax, curLoadLoc, coilNo, ordNo, ordSeq, ordFl, devlmtDate, progCd, smpSendTime, 
                    prodnmCd};
                List<string[]> list = new List<String[]>();
                list.Add(queryParams);
                if (this.checkBox1.Checked)
                {
                    CoreClientParam ccp1 = new CoreClientParam();
                    ccp1.ServerName = "UIM.UIM010232";
                    ccp1.MethodName = "queryYardListfjh";
                    ccp1.ServerParams = new object[] { list };
                    ccp1.SourceDataTable = this.dataSet1.Tables[0];
                    this.ExecuteQueryToDataTable(ccp1, CoreInvokeType.Internal);

                }
                else
                {
                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "UIM.UIM010232";
                    ccp.MethodName = "queryYardList";
                    ccp.ServerParams = new object[] { list };
                    ccp.SourceDataTable = this.dataSet1.Tables[0];
                    this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                }
                //统计钢卷数量，钢卷总重量
                int coilCount = (int)dataSet1.Tables[0].Compute("count(OLD_SAMPL_NO)", "");
                double coilWgtSum = 0;

                foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugr in ultraGrid1.Rows)
                {
                    double actWgt = 0;
                    try
                    {
                        Color color = Color.PaleGoldenrod;
                        string status = ugr.Cells["TOT_DEC_GRD"].Value.ToString().Trim();
                        if ("合格".Equals(status))
                        {
                            color = Color.White;
                        }
                        else if ("不合格".Equals(status))
                        {
                            color = Color.FromArgb(255, 128, 128);
                        }
                        string fhzt = ugr.Cells["CUR_PROG_CD"].Value.ToString().Trim();
                        string curloc = ugr.Cells["CUR_LOAD_LOC"].Value.ToString().Trim();
                        int asd = string.Compare(curloc.Substring(curloc.Length - 2, 2), "76");
                        string packlv = ugr.Cells["PACKAGE_LEVEL"].Value.ToString().Trim();
                        if (("发货指示待机".Equals(fhzt) || "运送待机".Equals(fhzt)) && packlv.Length > 0 && asd == -1 && "4".Equals(curloc.Substring(0,1)))
                          {
                              color = Color.Yellow;
                          }
                        ugr.Appearance.BackColor = color;

                        actWgt = double.Parse(ugr.Cells["ACT_WGT"].Value.ToString().Trim());
                    }
                    catch (Exception e)
                    {
                    }
                    coilWgtSum += actWgt;
                }
                double coilWgtSum1 = 0; int count1 = 0;
                double coilWgtSum2 = 0; int count2 = 0;
                double coilWgtSum3 = 0; int count3 = 0;
                double coilWgtSum4 = 0; int count4 = 0;
                double coilWgtSum5 = 0; int count5 = 0;
                double coilWgtSum6 = 0; int count6 = 0;
                double coilWgtSum7 = 0; int count7 = 0;
                double coilWgtSum8 = 0; int count8 = 0;
                foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugr in ultraGrid1.Rows)
                {
                    double actWgt1 = 0;

                    try
                    {
                        // Color color = Color.SandyBrown;
                        string status = ugr.Cells["CUR_PROG_CD"].Value.ToString().Trim();
                        if ("发货指示待机".Equals(status))
                        {
                            actWgt1 = double.Parse(ugr.Cells["ACT_WGT"].Value.ToString().Trim());
                            coilWgtSum1 += actWgt1;
                            count1++;
                        }
                        else if ("运送待机".Equals(status))
                        {
                            actWgt1 = double.Parse(ugr.Cells["ACT_WGT"].Value.ToString().Trim());
                            coilWgtSum2 += actWgt1;
                            count2++;
                        }
                        else if ("连退成品充当待机".Equals(status))
                        {
                            actWgt1 = double.Parse(ugr.Cells["ACT_WGT"].Value.ToString().Trim());
                            coilWgtSum3 += actWgt1;
                            count3++;
                        }
                        else if ("二级库存".Equals(status))
                        {
                            actWgt1 = double.Parse(ugr.Cells["ACT_WGT"].Value.ToString().Trim());
                            coilWgtSum4 += actWgt1;
                            count4++;
                        }
                        else if ("重卷作业待机".Equals(status))
                        {
                            actWgt1 = double.Parse(ugr.Cells["ACT_WGT"].Value.ToString().Trim());
                            coilWgtSum5 += actWgt1;
                            count5++;
                        }
                        else if ("综合判定待机".Equals(status))
                        {
                            actWgt1 = double.Parse(ugr.Cells["ACT_WGT"].Value.ToString().Trim());
                            coilWgtSum6 += actWgt1;
                            count6++;
                        }
                        else if ("重卷指示待机".Equals(status))
                        {
                            actWgt1 = double.Parse(ugr.Cells["ACT_WGT"].Value.ToString().Trim());
                            coilWgtSum7 += actWgt1;
                            count7++;
                        }
                        else if ("包装作业待机".Equals(status))
                        {
                            actWgt1 = double.Parse(ugr.Cells["ACT_WGT"].Value.ToString().Trim());
                            coilWgtSum8 += actWgt1;
                            count8++;
                        }
                    }
                    catch (Exception e)
                    {
                    }

                }

                this.textBox1.Text = coilCount.ToString();
                this.textBox2.Text = (coilWgtSum / 1000).ToString();
                
                this.textBox10.Text = count1.ToString();
                this.textBox12.Text = (coilWgtSum1 / 1000).ToString();
                
                this.textBox14.Text = count2.ToString();              
                this.textBox13.Text = (coilWgtSum2 / 1000).ToString();
                
                this.textBox18.Text = count4.ToString();
                this.textBox17.Text = (coilWgtSum4 / 1000).ToString();
                
                this.textBox16.Text = count3.ToString();
                this.textBox15.Text = (coilWgtSum3 / 1000).ToString();
                
                this.textBox22.Text = count5.ToString();
                this.textBox21.Text = (coilWgtSum5 / 1000).ToString();
                
                this.textBox20.Text = count6.ToString();
                this.textBox19.Text = (coilWgtSum6 / 1000).ToString();
                
                this.textBox24.Text = count8.ToString();
                this.textBox23.Text = (coilWgtSum8 / 1000).ToString();
                
                this.textBox26.Text = count7.ToString();
                this.textBox25.Text = (coilWgtSum7 / 1000).ToString();
            }
            catch (Exception EX)
            {
                MessageBox.Show(EX.ToString());
            }
        }

        private void UIM010232_Load(object sender, EventArgs e)
        {
            this.ultraDateTimeEditor1.Value = "";
            this.ultraDateTimeEditor2.Value = "";
            this.ultraDateTimeEditor3.Value = "";
            this.ultraDateTimeEditor4.Value = "";
        }

        private void DoExport()
        {
            try
            {
                if (this.saveFileDialog1.ShowDialog(this) == DialogResult.OK)
                {
                    string fileName = this.saveFileDialog1.FileName;
                    ultraGridExcelExporter1.Export(ultraGrid1, fileName);
                    System.Diagnostics.Process.Start(fileName);
                }
            }
            catch (Exception EX)
            {
                MessageBox.Show(EX.ToString());
            }
        }

     
    }
}