XinYu_ZHBMES_BJNEWS/Client/Core.XgMes.Client.JGKC.SteelPlateManager/发运/FrmPlan.cs

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using Core.Mes.ClientFrameWork;
using Core.Mes.IBaseInterface;
using System.Data;
using System.Runtime.InteropServices;

namespace Core.XgMes.Client.JGKC.SteelPlateManager
{
    public partial class FrmPlan : Mes.ClientFrameWork.FrmBase
    {
        public FrmPlan()
        {
            InitializeComponent();
        }

        private void FrmPlan_Load(object sender, EventArgs e)
        {
            Init();
            uCob_LX.Value = "0";
            cmb_LX.Value = "0";
            dte_EndTime.Value=dte_BeginTime.Value = Dte_PlanTime.Value = DateTime.Now;
        }
      
        private void Init()
        {
            string strOut="";
            string strSql = "";
            DataSet ds_;
            try
            {
                strSql = "SELECT BUYERCODE ID_, BUYERNAME NAME_ FROM SEL_BUYERBASEINFO a UNION SELECT CUST_CD BUYERCODE, CUST_NM BUYERNAME FROM TBZ00_CUSTOMER WHERE  REC_TP='01' AND REC_STS='1'  ";
                     ds_ = (DataSet)ClientCommon._RemotingHelp.ExecuteMethod("BJZWStuff", "Core.XgMes.Server.JGKC.SteelPlateManager.Common", "GetDataSet", new object[] { strSql }, out strOut);
                    ds_.Tables[0].TableName = "SEL_BUYERBASEINFO";

                    Comm.FillComboEditor(ref this.qBuyer, ds_);
                    Comm.FillComboEditor(ref this.cobBuyname, ds_);
                    Comm.SetGridDropDownList(this.gd_Plan, ds_, "SEL_BUYERBASEINFO", "BUYERCODE", "NAME_", "ID_");
                    Comm.SetGridDropDownList(this.ultraGrid2, ds_, "SEL_BUYERBASEINFO", "BUYERCODE", "NAME_", "ID_");

                    strSql = "SELECT INCEPTCORPCODE ID_, INCEPTCORPNAME NAME_ FROM SEL_INCEPTCORPINFO  UNION SELECT CUST_CD INCEPTCORPNAME, CUST_NM BUYERNAME FROM TBZ00_CUSTOMER WHERE  REC_TP='02' AND REC_STS='1'  ";
                     ds_ = (DataSet)ClientCommon._RemotingHelp.ExecuteMethod("BJZWStuff", "Core.XgMes.Server.JGKC.SteelPlateManager.Common", "GetDataSet", new object[] { strSql }, out strOut);
                    ds_.Tables[0].TableName = "SEL_INCEPTCORPINFO";

                    Comm.FillComboEditor(ref this.qIncep,  ds_);
                    Comm.FillComboEditor(ref this.cob_Incop, ds_);
                    Comm.SetGridDropDownList(this.gd_Plan, ds_, "SEL_INCEPTCORPINFO", "INCEPTCORPCODE", "NAME_", "ID_");
                    Comm.SetGridDropDownList(this.ultraGrid2, ds_, "SEL_INCEPTCORPINFO", "INCEPTCORPCODE", "NAME_", "ID_");

                    strSql = "select ID_ ,Name_ from KCJ_BASEDATA where Sort_Code='8091' ";
                    ds_ = (DataSet)ClientCommon._RemotingHelp.ExecuteMethod("BJZWStuff", "Core.XgMes.Server.JGKC.SteelPlateManager.Common", "GetDataSet",
                        new object[] { strSql }, out strOut);
                    if (strOut != "") { MessageBox.Show(strOut); return; }
                    Comm.FillComboEditor(ref this.cmb_pactnoLX, ds_);
                


            }catch(Exception ex)
            {
                MessageBox.Show("错误" + ex, "错误提示");
                return;
            }
        }

        private void chk_CollectTime_CheckedChanged(object sender, EventArgs e)
        {
            dte_BeginTime.Enabled = dte_EndTime.Enabled = chk_CollectTime.Checked;
        }

        private void chk_BuyName_CheckedChanged(object sender, EventArgs e)
        {
            cobBuyname.Enabled = chk_BuyName.Checked;
        }

        private void chk_Incep_CheckedChanged(object sender, EventArgs e)
        {
            cob_Incop.Enabled = chk_Incep.Checked;
        }

        private void chk_LX_CheckedChanged(object sender, EventArgs e)
        {
            cmb_LX.Enabled = chk_LX.Checked;
        }

        private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
        {
            switch (e.Tool.Key)
            {
                case "QUERY":
                    QueryPlan();
                    break;
                case "PLAN_ADD":
                    AddPlan("1");
                    break;
                case "PALN_DEL":
                    AddPlan("2");
                    break;
                case "FP":
                    queryFP();
                    break;
            }
        }
        private void queryFP()
        {
            string sql = "";
            string strOut = "";
            string strWhere = "";
            if (chk_CollectTime.Checked == false && chk_LX.Checked == false)
            {
                MessageBox.Show("请选择任意条件进行查询!!!!!");
            }
            if (chk_CollectTime.Checked)
            {
                if (dte_BeginTime.Enabled && dte_EndTime.Enabled)
                {
                    strWhere += " AND T.RECODERTIME BETWEEN TO_DATE('" + Convert.ToDateTime(this.dte_BeginTime.Value).ToString("yyyy-MM-dd") + "','yyyy-MM-dd') "
                            + " AND TO_DATE('" + Convert.ToDateTime(this.dte_EndTime.Value).ToString("yyyy-MM-dd") + " 23:59:59','yyyy-MM-dd hh24:mi:ss') ";
                }
            }

            if (chk_LX.Checked)
            {
                strWhere += " AND T.PRODUCT_LX LIKE '" + cmb_LX.Value.ToString().Trim() + "%'";
            }
            DataSet ds = new DataSet();
            sql = "SELECT DISTINCT T.PACTNO,T.PACTNOLX,TO_CHAR(T.RECODERTIME,'YYYY-MM-DD HH24:MI')RECODERTIME,T.RECODER,"
                 + "T.BUYERCODE, "
                 + "T.INCEPECODE,T.PRODUCT_LX "
                 + " FROM KCJ_PACTNOLX_ZW T  WHERE T.ISVALID='1' " + strWhere;
            ds = (DataSet)ClientCommon._RemotingHelp.ExecuteMethod("BJZWStuff", "Core.XgMes.Server.JGKC.SteelPlateManager.Common", "GetDataSet",
                    new object[] { sql }, out strOut);
            if (ds != null)
            {
                ultraGrid2.DataSource = ds;
            }
        }
        private void QueryPlan()
        {
            //string orderNO = "";
            //string billetID = "";
            //string shopSign = "";
            string where = "";
            string strOut = "";




            if (this.cobBuyname.Enabled && this.cobBuyname.Value.ToString().Trim().Length > 0)
                {
                    where += " AND A.BUYERCODE LIKE '" + this.cobBuyname.Value.ToString().Trim() + "%'";
                }

                if (this.cob_Incop.Enabled && this.cob_Incop.Value.ToString().Trim().Length > 0)
                {
                    where += " AND A.INCEPTCORPCODE LIKE '" + this.cob_Incop.Value.ToString().Trim() + "%'";

                }
                if (this.cmb_LX.Enabled && this.cmb_LX.Value.ToString().Trim().Length > 0)
                {
                    where += " AND A.PL LIKE '" + this.cmb_LX.Value.ToString().Trim() + "%'";

                }
               
               
                if (this.dte_BeginTime.Enabled && this.dte_EndTime.Enabled)
                {
                    where += " AND TO_CHAR(A.INCEPTDATE,'YYYY-MM-DD') >='" + Convert.ToDateTime(this.dte_BeginTime.Value).ToString("yyyy-MM-dd") + "' "
                        + " AND TO_CHAR(A.INCEPTDATE,'YYYY-MM-DD') <='" + Convert.ToDateTime(this.dte_EndTime.Value).ToString("yyyy-MM-dd") + "' ";
                }

               
        
         

            try
            {
                
                DataSet ds = (DataSet)Core.Mes.ClientFrameWork.ClientCommon._RemotingHelp.ExecuteMethod("BJZWStuff", "Core.XgMes.Server.JGKC.SteelPlateManager.TurnoffManager",
                    "QueryPlan", new object[] {  where }, out strOut);

                if (strOut == "")
                {
           
                    this.gd_Plan.DataSource = ds;
                    this.gd_Plan.UpdateData();//++
                    Comm.SetGridSumArea(this.gd_Plan);


                }
                else
                {
                    MessageBox.Show(strOut, "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }	
        }
        private void AddPlan(string sMode)
        {
            string strOut="";
            System.Collections.ArrayList Billet = new ArrayList();
            if (qBuyer.Value.ToString() == "")
            {
                MessageBox.Show("请选择客户名称!!!!");
                return;
            }
            if (qIncep.Value.ToString() == "")
            {
                MessageBox.Show("请选择收货单位!!!!");
                return;
            }
            if (uCob_LX.Value.ToString() == "")
            {
                MessageBox.Show("请选择产品类型!!!!");
                return;
            }
            if (txt_Weigth.Text.Trim() == "")
            {
                MessageBox.Show("请输入排车重量！！！");
                return;
            }
            Billet.Add(qBuyer.Value.ToString());
            Billet.Add(qIncep.Value.ToString());
            Billet.Add(Dte_PlanTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss"));
            Billet.Add(uCob_LX.Value.ToString());
            Billet.Add(txt_Weigth.Text.ToString().Trim().ToString());
            Billet.Add(txt_CH.Text.ToString().Trim().ToString());
            Billet.Add(txt_Remark.Text.ToString().Trim().ToString());
            Billet.Add(txt_Pactno.Text.ToString().Trim().ToString());
            Billet.Add(ClientCommon._UserInfo.UserName.ToString());
            Billet.Add(sMode);
            Billet.Add(txt_Askid.Text.ToString().Trim());
            string info = Core.Mes.ClientFrameWork.ClientCommon._RemotingHelp.ExecuteMethod("BJZWStuff", "Core.XgMes.Server.JGKC.SteelPlateManager.TurnoffManager",
                       "AddPlan", new object[] { Billet }, out strOut).ToString();
            if (info != "1" || strOut != "")
            {
                MessageBox.Show(strOut);

                return;
            }
            else
            {
                MessageBox.Show("计划制定成功!!!!");
                QueryPlan();
            }
               
        }

        private void gd_Plan_AfterRowActivate(object sender, EventArgs e)
        {
            Dte_PlanTime.Value = Comm.ObjToStr(this.gd_Plan.ActiveRow.Cells["INCEPTDATE"].Value);
            qBuyer.Value = Comm.ObjToStr(this.gd_Plan.ActiveRow.Cells["BUYERCODE"].Value);
            qIncep.Value = Comm.ObjToStr(this.gd_Plan.ActiveRow.Cells["INCEPTCORPCODE"].Value);
            uCob_LX.Value = Comm.ObjToStr(this.gd_Plan.ActiveRow.Cells["PL"].Value);
            txt_Weigth.Text = Comm.ObjToStr(this.gd_Plan.ActiveRow.Cells["WEIGHT"].Value);
            txt_Pactno.Text = Comm.ObjToStr(this.gd_Plan.ActiveRow.Cells["PACTNO"].Value);
            txt_CH.Text = Comm.ObjToStr(this.gd_Plan.ActiveRow.Cells["TRANSNO"].Value);
            txt_Remark.Text = Comm.ObjToStr(this.gd_Plan.ActiveRow.Cells["REMARK"].Value);
            txt_Askid.Text = Comm.ObjToStr(this.gd_Plan.ActiveRow.Cells["ASKPLAN_ID"].Value);
        }

        private void ultraGrid2_AfterRowActivate(object sender, EventArgs e)
        {
            if (this.ultraGrid2.Rows.Count > 0)
            {
                uCob_LX.Value = Comm.ObjToStr(this.ultraGrid2.ActiveRow.Cells["PRODUCT_LX"].Value);
                qBuyer.Value = Comm.ObjToStr(this.ultraGrid2.ActiveRow.Cells["BUYERCODE"].Value);
                qIncep.Value = Comm.ObjToStr(this.ultraGrid2.ActiveRow.Cells["INCEPECODE"].Value);
                txt_Pactno.Text = Comm.ObjToStr(this.ultraGrid2.ActiveRow.Cells["PACTNO"].Value);
            }
        }
    }
}