XinYu_ZHBMES/Client/Core.XgMes.Client.JGKC.SteelPlateManager/FrmOrdernoAcliat.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;

namespace Core.XgMes.Client.JGKC.SteelPlateManager
{
    public partial class FrmOrdernoAcliat : Mes.ClientFrameWork.FrmBase
    {
        public FrmOrdernoAcliat()
        {
            InitializeComponent();
        }
        private void InitCombo()
        {
            string strSQL = "";
            string strout = "";
            DataSet ds;
           

            try
            {
                //合同类型
                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.ultrCmb_PactNo, ds);

                strSQL = "SELECT BUYERCODE,BUYERNAME FROM SEL_BUYERBASEINFO 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);
                if (strout != "") { MessageBox.Show(strout); return; }

                Comm.Init_ComboControl(this.Cmb_Buy, "SEL_BUYERBASEINFO", "BUYERNAME", "BUYERCODE", ref ds);
                Comm.FillComboEditor(ref this.qBuyer, ds);
                Comm.SetGridDropDownList(this.ultraGrid1, ds, "SEL_BUYERBASEINFO", "BUYERCODE", "BUYERNAME", "BUYERCODE");


                strSQL = "SELECT INCEPTCORPCODE,INCEPTCORPNAME 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);
                if (strout != "") { MessageBox.Show(strout); return; }

                Comm.Init_ComboControl(this.Cmb_Inco, "SEL_INCEPTCORPINFO", "INCEPTCORPNAME", "INCEPTCORPCODE", ref ds);
                Comm.SetGridDropDownList(this.ultraGrid1, ds, "SEL_BUYERBASEINFO", "INCEPTCORPCODE", "INCEPTCORPNAME", "BUYERCODE");
                Comm.FillComboEditor(ref this.qIncep, ds);
                
            }
            catch { }

           
        }

        private void FrmOrdernoAcliat_Load(object sender, EventArgs e)
        {
            dte_TimeB.Value = DateTime.Now;
            dte_TimeE.Value = DateTime.Now;
            uCob_LX.Value = "0";
            InitCombo();
        }
        private void Query()
        {
            string sql = "";
            string strOut = "";
            string strWhere = "";
            if (chk_Intime.Checked == false && checkPactNo.Checked == false)
            {
                MessageBox.Show("请选择任意条件进行查询!!!!!");
            }
            if (chk_Intime.Checked  )
            {
                if (dte_TimeB.Enabled && dte_TimeE.Enabled)
                {
                    strWhere += " WHERE INTIME BETWEEN TO_DATE('" + Convert.ToDateTime(this.dte_TimeB.Value).ToString("yyyy-MM-dd") + "','yyyy-MM-dd') "
                            + " AND TO_DATE('" + Convert.ToDateTime(this.dte_TimeE.Value).ToString("yyyy-MM-dd") + " 23:59:59','yyyy-MM-dd hh24:mi:ss') ";
                }
            }
           
            if (checkPactNo.Checked)
            {
                if (strWhere == "")
                {
                    strWhere += "  WHERE (PACTNO LIKE '" + PactNo.Text.Trim() + "%')";
                }
                else
                {
                    strWhere += " AND (PACTNO LIKE '" + PactNo.Text.Trim() + "%' OR ORDERNO LIKE '" + PactNo.Text.Trim() + "%' )";
                }
            }
            DataSet ds = new DataSet();
            sql = "SELECT MAX(PACTNO)PACTNO,ORDERNO,MAX(BUYERCODE)BUYERCODE,MAX(INCEPTCORPCODE)INCEPTCORPCODE,MAX(BUYERCODE1)BUYERCODE1,MAX(INCEPECODE1)INCEPECODE1,RECODER,PACTNOLX,RECODERTIME,MAX(INTIME)INTIME FROM ("
                 + "SELECT SUBSTR(T.ORDERNO, 1, LENGTH(T.ORDERNO) - 3)PACTNO,T.ORDERNO,"
                 + " CASE WHEN (SELECT COUNT(1) FROM SEL_PACTDETAIL WHERE ORDERNO=T.ORDERNO)>0 THEN "
                 + "(SELECT BUYERCODE FROM SEL_PACTDETAIL WHERE ORDERNO=T.ORDERNO) "
                 + "WHEN (SELECT COUNT(1) FROM SEL_PACTINFO_CLEAR AA WHERE AA.PACTNO = SUBSTR(T.ORDERNO, 1, LENGTH(T.ORDERNO) - 3))>0 THEN  "
                 + "(SELECT AA.BUYERCODE FROM SEL_PACTINFO_CLEAR AA WHERE AA.PACTNO = SUBSTR(T.ORDERNO, 1, LENGTH(T.ORDERNO) - 3)) "
                 + " WHEN  T.ORDERNO LIKE '17%' THEN '106' END BUYERCODE,"
                 + "CASE WHEN (SELECT COUNT(1) FROM SEL_PACTDETAIL WHERE ORDERNO=T.ORDERNO)>0 THEN "
                 + "(SELECT INCEPTCORPCODE FROM SEL_PACTDETAIL WHERE ORDERNO=T.ORDERNO) "
                 + "WHEN (SELECT COUNT(1) FROM SEL_PACTINFO_CLEAR AA WHERE AA.PACTNO = SUBSTR(T.ORDERNO, 1, LENGTH(T.ORDERNO) - 3))>0 THEN  "
                 + "(SELECT AA.INCEPTCORPCODE FROM SEL_PACTINFO_CLEAR AA WHERE AA.PACTNO = SUBSTR(T.ORDERNO, 1, LENGTH(T.ORDERNO) - 3)) "
                 + "WHEN  T.ORDERNO LIKE '17%' THEN '201112020001' END INCEPTCORPCODE,"
                 +"T.INTIME,"
                 +"(SELECT BUYERCODE FROM KCJ_PACTNOLX_ZW WHERE ORDERNO=T.ORDERNO AND ISVALID='1')BUYERCODE1, "
                 + "(SELECT INCEPECODE FROM KCJ_PACTNOLX_ZW WHERE ORDERNO=T.ORDERNO AND ISVALID='1')INCEPECODE1,"
                 + "(SELECT RECODER FROM KCJ_PACTNOLX_ZW WHERE ORDERNO=T.ORDERNO AND ISVALID='1')RECODER,"
                 + "(SELECT PACTNOLX FROM KCJ_PACTNOLX_ZW WHERE ORDERNO=T.ORDERNO AND ISVALID='1')PACTNOLX,"
                 + "(SELECT TO_CHAR(RECODERTIME,'YYYY-MM-DD HH24:MI') FROM KCJ_PACTNOLX_ZW WHERE ORDERNO=T.ORDERNO AND ISVALID='1')RECODERTIME "
                 +" FROM KCJ_STORAGELIST_ZW T  "
          
                 + " UNION  "
                 + " SELECT B.ORD_NO PACTNO,B.ORD_NO||B.ORD_SEQ ORDERNO,A.CUST_CD BUYERCODE,A.ORDCUST_CD INCEPTCORPCODE,T.INTIME, "
                 + "(SELECT BUYERCODE FROM KCJ_PACTNOLX_ZW WHERE ORDERNO=T.ORD_NO||T.ORD_SEQ AND ISVALID='1')BUYERCODE1, "
                 + "(SELECT INCEPECODE FROM KCJ_PACTNOLX_ZW WHERE ORDERNO=T.ORD_NO||T.ORD_SEQ AND ISVALID='1')INCEPECODE1,"
                 + "(SELECT RECODER FROM KCJ_PACTNOLX_ZW WHERE ORDERNO=T.ORD_NO||T.ORD_SEQ AND ISVALID='1')RECODER,"
                 + "(SELECT PACTNOLX FROM KCJ_PACTNOLX_ZW WHERE ORDERNO=T.ORD_NO||T.ORD_SEQ AND ISVALID='1')PACTNOLX,"
                 + "(SELECT TO_CHAR(RECODERTIME,'YYYY-MM-DD HH24:MI') FROM KCJ_PACTNOLX_ZW WHERE ORDERNO=T.ORD_NO||T.ORD_SEQ AND ISVALID='1')RECODERTIME  "
                 + "FROM KCJ3_STUFFLIST_ZW T ,TBA01_ORD_COMM A,TBA01_ORD_LINE B WHERE T.ORD_NO=B.ORD_NO AND T.ORD_SEQ=B.ORD_SEQ AND A.ORD_NO=B.ORD_NO)"
                 + strWhere
                 + " GROUP BY ORDERNO,RECODER,PACTNOLX,RECODERTIME ";
            ds = (DataSet)ClientCommon._RemotingHelp.ExecuteMethod("BJZWStuff", "Core.XgMes.Server.JGKC.SteelPlateManager.Common", "GetDataSet",
                    new object[] { sql }, out strOut);
            if (ds != null)
            {
                ultraGrid1.DataSource = ds;
            }
        }
        public void Add()
        {
            try
            {
                string strErr = "";
                if (this.ultrCmb_PactNo.Text.Trim() == "")
                {
                    MessageBox.Show("请选择合同类型!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    return;
                }
                ArrayList alorderno = new ArrayList();
                foreach (Infragistics.Win.UltraWinGrid.UltraGridRow row in this.ultraGrid1.Selected.Rows)
                {
                    alorderno.Add(row.Cells["ORDERNO"].Value.ToString());
                }
                ArrayList al = new ArrayList();
                al.Add(ultrCmb_PactNo.Value.ToString());
                al.Add(qBuyer.Value.ToString());
                al.Add(qIncep.Value.ToString());
                al.Add(uCob_LX.Value.ToString());
                al.Add(ClientCommon._UserInfo.UserName.ToString());

                DataSet ds = (DataSet)Core.Mes.ClientFrameWork.ClientCommon._RemotingHelp.ExecuteMethod("BJZWStuff", "Core.XgMes.Server.JGKC.SteelPlateManager.SendManager", "addDJ", new object[] { alorderno, al }, out strErr);
                if (strErr != "")
                {
                    MessageBox.Show(strErr);
                    return;
                }
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
        }
        private void DoExc(Infragistics.Win.UltraWinGrid.UltraGrid _gd, string _title)
        {
            try
            {
                string filename = _title + @".xls";
                this.excelExporter.Export(_gd, filename);
                System.Diagnostics.ProcessStartInfo st = new System.Diagnostics.ProcessStartInfo(filename);
                st.WindowStyle = System.Diagnostics.ProcessWindowStyle.Maximized;
                System.Diagnostics.Process.Start(st);
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
        }
        private void ultraToolbars_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
        {
            switch (e.Tool.Key)
            { 
                case "Confirm":
                    Query();
                    break;
                case "Add":
                    Add();
                    break;
                case "Close":
                    this.Close();
                    break;
                case "Excel":
                    DoExc(this.ultraGrid1,this.Text);
                   
                    break;
            }
        }

        private void chk_Intime_CheckedChanged(object sender, EventArgs e)
        {
            dte_TimeB.Enabled = dte_TimeE.Enabled = chk_Intime.Checked;
        }

        private void checkPactNo_CheckedChanged(object sender, EventArgs e)
        {
            PactNo.Enabled = checkPactNo.Checked;
        }

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            if (this.ultraGrid1.Rows.Count > 0)
            {
                ultrCmb_PactNo.Value = Comm.ObjToStr(this.ultraGrid1.ActiveRow.Cells["PACTNOLX"].Value);
                qBuyer.Value = Comm.ObjToStr(this.ultraGrid1.ActiveRow.Cells["BUYERCODE"].Value);
                qIncep.Value = Comm.ObjToStr(this.ultraGrid1.ActiveRow.Cells["INCEPTCORPCODE"].Value);
            }
        }
    }
}