XinYu_ZHBMES/Client/.svn/pristine/2c/2c4caab3efb435bc66947edc6903fb0b1d55c78b.svn-base

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;
using Core.XgMes.Client.JGKC.TurnoffSendManager;

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

        private void Cmb_wzdm_TextChanged(object sender, EventArgs e)
        {
           
        }
      



      


        private void Cmb_wzdm_DoubleClick(object sender, EventArgs e)
        {
            
        }

        private void Cmb_wzdm_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            FrmMaterialDaioage metaterial = new FrmMaterialDaioage();
            metaterial.StartPosition = FormStartPosition.CenterParent;
            metaterial.ShowDialog();
            Cmb_wzdm.Text = metaterial.strwzdm;
            txt_WZMC.Text = metaterial.strwzmc;
            txt_GGXH.Text = metaterial.strgg;
            txt_JLDW.Text = metaterial.strjldw;
            txt_CZ.Text = metaterial.strcz;
            txt_DZ.Text = metaterial.strdz;
            Cmb_CKDM.Text = metaterial.strckcode;
            cmb_StorageLB.Text = metaterial.strcklb;
            txt_CKMC.Text = metaterial.strckmc;

        }

        private void Cmb_CKDM_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            FrmDepotDialog depot = new FrmDepotDialog();
            depot.StartPosition = FormStartPosition.CenterParent;
            depot.ShowDialog();
            Cmb_CKDM.Text = depot.strckdm;
            cmb_StorageLB.Text = depot.strcklb;
            txt_CKMC.Text = depot.stckmc;

        }

        private void Cmd_GFCode_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            FrmProvlderDialog provlder = new FrmProvlderDialog();
            provlder.StartPosition = FormStartPosition.CenterParent;
            provlder.ShowDialog();
            Cmd_GFCode.Text = provlder.strgfdm;
            txt_GYMC.Text = provlder.strgfmc;
        }

        private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
        {
            switch (e.Tool.Key)
            {
                case "Add":
                    Add("ADD");
                    break;
                case "Query":
                    DoQuery();
                    break;
                case "UPDATE":
                    Add("UPDATE");
                    break;
                    break;
                case "Del":
                    Add("Del");
                    break;
                case "Export":
                    Export();
                    break;
                case "Close":
                    this.Close();
                    break;

                    
            }
        }
        private void gd_CK_AfterRowActivate(object sender, EventArgs e)
        {
            try
            {
                if (this.gd_CK.Rows.Count > 0)
                {

       



                    this.txt_BH.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["PICKING_NO"].Value); //1 领料单号
                    this.Cmb_CKDM.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["STORAGE_CODE"].Value); //3 仓库代码
                    this.cmb_StorageLB.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["STORAGE_STYLE"].Value);//4 仓库类别
                    this.txt_CKMC.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["ISSUE_STORE"].Value);//5 仓库名称
                    this.txt_ylbz.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["PICKING_NAME"].Value);//6 领料班组
                    this.Cmb_wzdm.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["MATERIAL_CODE"].Value);//7 物资代码
                    this.txt_WZMC.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["MATERIAL_NAME"].Value);//8 物资名称
                    this.txt_GGXH.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["SPET"].Value);//9 规格型号
                    this.txt_JLDW.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["UNIT"].Value);//10 计量单位
                    this.txt_CZ.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["MATERIAL"].Value);//11 材质
                    this.txt_DZ.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["WEIGHT"].Value);//12 单重
                    this.txt_PlanR.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["SCHEDULER"].Value);///13 计划人
                    this.txt_qlsl.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["PLEASE_NUM"].Value);///14 请领数量
                    this.txt_Price.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["REAL_NUM"].Value);//15 实发数量
                    this.txt_Price.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["PRICE"].Value);//16 单价
                    this.txt_Moneny.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["MONERY"].Value);//17 金额
                    this.txt_YR.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["PICKING_RECODER"].Value);//19 领料人
                    this.Cmd_GFCode.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["GF_CODE"].Value);///20 供方代码
                    this.txt_GYMC.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["GF_NAME"].Value);///21供方名称
                    this.txt_Remark.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["REMARK"].Value);///22 备注



                    
 


                 
                   
        








                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
        }






        private void chk_AllowFilter_CheckedChanged(object sender, System.EventArgs e)
        {
            if (this.chk_AllowFilter.Checked)
            {
                this.gd_CK.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.True;
            }
            else
            {
                this.gd_CK.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;

            }

        }
	
        private void Export()
        {
            if (this.gd_CK.Rows.Count > 0)
            {
                Comm.ExPortExcel(this.gd_CK, this.excelExporter);
            }
            else
            {
                MessageBox.Show("无领料单信息数据，不能导出！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }

        }
        private void Add(string strMode)
        {
            try
            {
                string strerr = "";

                System.Collections.ArrayList MetarilInfo = new ArrayList();


                if (strMode == "UPDATE")
                {
                    if (txt_BH.Text.Trim().ToString() == "")
                    {
                        MessageBox.Show("领料单号不能为空");
                        return;
                    }
                }
                MetarilInfo.Add(Comm.ObjToStr(this.txt_BH.Text.Trim().ToString()));//1 领料单号
                MetarilInfo.Add(Comm.ObjToStr(Convert.ToDateTime( this.date_YS.Value.ToString().Trim()).ToString("yyyyMMdd")));//2 发料日期
                MetarilInfo.Add(Comm.ObjToStr(this.Cmb_CKDM.Text.ToString().Trim()));//3 仓库代码
                MetarilInfo.Add(Comm.ObjToStr(this.cmb_StorageLB.Text.Trim().ToString()));//4 仓库类别
                MetarilInfo.Add(Comm.ObjToStr(this.txt_CKMC.Text.Trim().ToString()));//5 仓库名称
                MetarilInfo.Add(Comm.ObjToStr(this.txt_ylbz.Text.Trim().ToString()));//6 领料班组



                MetarilInfo.Add(Comm.ObjToStr(this.Cmb_wzdm.Text.Trim().ToString()));//7 物资代码
                MetarilInfo.Add(Comm.ObjToStr(this.txt_WZMC.Text.Trim().ToString()));//8 物资名称
                MetarilInfo.Add(Comm.ObjToStr(this.txt_GGXH.Text.Trim().ToString()));//9 规格型号
                MetarilInfo.Add(Comm.ObjToStr(this.txt_JLDW.Text.Trim().ToString()));//10 计量单位
                MetarilInfo.Add(Comm.ObjToStr(this.txt_CZ.Text.Trim().ToString()));//11 材质
                MetarilInfo.Add(Comm.ObjToStr(this.txt_DZ.Text.Trim().ToString()));//12 单重
                MetarilInfo.Add(Comm.ObjToStr(this.txt_PlanR.Text.Trim().ToString()));//13 计划人


                MetarilInfo.Add(Comm.ObjToStr(this.txt_qlsl.Text.Trim().ToString()));//14 请领数量
                MetarilInfo.Add(Comm.ObjToStr(this.txt_YSS.Text.Trim().ToString()));//15 实发数量
                MetarilInfo.Add(Comm.ObjToStr(this.txt_Price.Text.Trim().ToString()));//16 单价
                MetarilInfo.Add(Comm.ObjToStr(this.txt_Moneny.Text.Trim().ToString()));//17 金额
                MetarilInfo.Add(Comm.ObjToStr(Convert.ToDateTime(this.date_td.Value.ToString().Trim()).ToString("yyyyMMdd")));//18 填单日期
                MetarilInfo.Add(Comm.ObjToStr(txt_YR.Text.Trim().ToString()));//19 领料人


                MetarilInfo.Add(Comm.ObjToStr(this.Cmd_GFCode.Text.Trim().ToString()));//20 供方代码
                MetarilInfo.Add(Comm.ObjToStr(this.txt_GYMC.Text.Trim().ToString()));//21供方名称
                
                MetarilInfo.Add(Comm.ObjToStr(this.txt_Remark.Text.Trim().ToString()));//22 备注
        




                MetarilInfo.Add(ClientCommon._UserInfo.UserName.ToString());//23 操作人
                MetarilInfo.Add(strMode);//19 操作模式
         
           


                object obj = Core.Mes.ClientFrameWork.ClientCommon._RemotingHelp.ExecuteMethod("BJZWWLStuff", "Core.XgMes.Server.JGKC.MaterialManager.Metarial",
                    "PickingSheetAdd", new object[] { MetarilInfo }, out strerr);
                if (obj != null && obj.ToString() == "1")
                {
                    MessageBox.Show("新增成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    DoQuery();
                }
                else
                {
                    MessageBox.Show(strerr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
            }
            catch (Exception ex)
            {
            }
        }
        private void DoQuery()
        {
            string strWhere = "";
            string sql = "";
            if (chk_Time.Checked)
            {
                strWhere += " AND  ISSUE_DATE >='" + Convert.ToDateTime(dte_BeginTime.Value.ToString()).ToString("yyyyMMdd") + "' AND ISSUE_DATE <='" + Convert.ToDateTime(dte_EndTime.Value.ToString()).ToString("yyyyMMdd") + "'";
            }
            if (Chk_CKLB.Checked && txt_ckm.Text.Trim().Length>0)
            {
                strWhere += " AND STORAGE_STYLE LIKE '" + txt_ckm.Text.Trim().ToString() + "%' ";
            }
            if (Chk_WZDM.Checked && txt_wzdm.Text.Trim().Length > 0)
            {
                strWhere += " AND MATERIAL_CODE LIKE '" + txt_wzdm.Text.Trim().ToString() + "%' ";
            }
            if (chk_wzmc.Checked && txt_wz.Text.Trim().Length > 0)
            {
                strWhere += " AND MATERIAL_NAME LIKE '" + txt_wz.Text.Trim().ToString() + "%' ";
            }
            if (chk_Spet.Checked && txt_Spet.Text.Trim().Length > 0)
            {
                strWhere += " AND SPET LIKE '" + txt_Spet.Text.Trim().ToString() + "%' ";
            }

            string err = "";
            sql = "select PICKING_NO,ISSUE_DATE,STORAGE_CODE,STORAGE_STYLE,ISSUE_STORE,PICKING_NAME,MATERIAL_CODE,MATERIAL_NAME, SPET,"
                         + "UNIT,MATERIAL, WEIGHT,SCHEDULER,PLEASE_NUM,REAL_NUM,PRICE, MONERY,FILLING_DATE, PICKING_RECODER,GF_CODE,GF_NAME,RECODER,INPUT_DATE,REMARK     "
                         + " from PICKING_MANAGER where isvalid='1' ";
 
                           
            DataSet ds = (DataSet)ClientCommon._RemotingHelp.ExecuteMethod("BJZWStuff", "Core.XgMes.Server.JGKC.SteelPlateManager.Common", "GetDataSet", new object[] { sql }, out err);
            if (err == "")
            {
                gd_CK.DataSource = ds;
            }
        }

        private void AccpetSheet_Load(object sender, EventArgs e)
        {
            dte_BeginTime.DateTime = DateTime.Now;
            dte_EndTime.DateTime = DateTime.Now;
            date_YS.DateTime = DateTime.Now;
            date_td.DateTime = DateTime.Now;
        }

        private void Chk_CKLB_CheckedChanged(object sender, EventArgs e)
        {
            txt_ckm.Enabled = Chk_CKLB.Checked;
        }

        private void Chk_WZDM_CheckedChanged(object sender, EventArgs e)
        {
            txt_wzdm.Enabled = Chk_WZDM.Checked;
        }

        private void Cmb_CKDM_KeyDown(object sender, KeyEventArgs e)
        {
            
            string err = "";
            string sql = "SELECT BB.MATERIAL_CODE,BB.MATERIAL_NAME,BB.SPEC,BB.MATERIAL,BB.SUBSTANCE,BB.UNITS,CC.DEPOTID,CC.DEPOTNAME,AA.STOCK_CODE FROM MATERIAL_CODE_MANAGE BB,KCJ_STORESMAGNAGER AA,KCJ_DEPOTMAGAGER CC  WHERE BB.MATERIAL_CODE=AA.MATERIALCODE(+) AND AA.STOCK_CODE=CC.DEPOT_LB(+)  "
                        + " AND CC.DEPOTID  like '" + Cmb_CKDM.Text.ToString().Trim() + "' "
                        + " ORDER BY TO_NUMBER(BB.SORT_CODE)  ASC ";
            DataSet ds = (DataSet)ClientCommon._RemotingHelp.ExecuteMethod("BJZWStuff", "Core.XgMes.Server.JGKC.SteelPlateManager.Common", "GetDataSet", new object[] { sql }, out err);
            if (ds.Tables[0].Rows.Count > 0)
            {
                if (err == "")
                {
                    Cmb_wzdm.Text = ds.Tables[0].Rows[0]["MATERIAL_CODE"].ToString();
                    txt_WZMC.Text = ds.Tables[0].Rows[0]["MATERIAL_NAME"].ToString();
                    txt_GGXH.Text = ds.Tables[0].Rows[0]["SPEC"].ToString();
                    txt_JLDW.Text = ds.Tables[0].Rows[0]["UNITS"].ToString();
                    txt_CZ.Text = ds.Tables[0].Rows[0]["MATERIAL"].ToString();
                    txt_DZ.Text = ds.Tables[0].Rows[0]["SUBSTANCE"].ToString();
                    Cmb_CKDM.Text = ds.Tables[0].Rows[0]["DEPOTID"].ToString();
                    cmb_StorageLB.Text = ds.Tables[0].Rows[0]["STOCK_CODE"].ToString();
                    txt_CKMC.Text = ds.Tables[0].Rows[0]["DEPOTNAME"].ToString();

                }
            }
            else
            {


                txt_WZMC.Text = "";
                txt_GGXH.Text = "";
                txt_JLDW.Text = "";
                txt_CZ.Text = "";
                txt_DZ.Text = "";
            
                cmb_StorageLB.Text = "";
                txt_CKMC.Text = "";

            }
        }

        private void Cmb_wzdm_KeyDown(object sender, KeyEventArgs e)
        {
           
            string err = "";
            string sql = "SELECT BB.MATERIAL_CODE,BB.MATERIAL_NAME,BB.SPEC,BB.MATERIAL,BB.SUBSTANCE,BB.UNITS,CC.DEPOTID,CC.DEPOTNAME,AA.STOCK_CODE FROM MATERIAL_CODE_MANAGE BB,KCJ_STORESMAGNAGER AA,KCJ_DEPOTMAGAGER CC  WHERE BB.MATERIAL_CODE=AA.MATERIALCODE(+) AND AA.STOCK_CODE=CC.DEPOT_LB(+)  "
                        + " AND BB.MATERIAL_CODE  like '" + Cmb_wzdm.Text.ToString().Trim() + "' "
                        + " ORDER BY TO_NUMBER(BB.SORT_CODE)  ASC ";
            DataSet ds = (DataSet)ClientCommon._RemotingHelp.ExecuteMethod("BJZWStuff", "Core.XgMes.Server.JGKC.SteelPlateManager.Common", "GetDataSet", new object[] { sql }, out err);
            if (ds.Tables[0].Rows.Count > 0)
            {
                if (err == "")
                {
                    Cmb_wzdm.Text = ds.Tables[0].Rows[0]["MATERIAL_CODE"].ToString();
                    txt_WZMC.Text = ds.Tables[0].Rows[0]["MATERIAL_NAME"].ToString();
                    txt_GGXH.Text = ds.Tables[0].Rows[0]["SPEC"].ToString();
                    txt_JLDW.Text = ds.Tables[0].Rows[0]["UNITS"].ToString();
                    txt_CZ.Text = ds.Tables[0].Rows[0]["MATERIAL"].ToString();
                    txt_DZ.Text = ds.Tables[0].Rows[0]["SUBSTANCE"].ToString();
                    Cmb_CKDM.Text = ds.Tables[0].Rows[0]["DEPOTID"].ToString();
                    cmb_StorageLB.Text = ds.Tables[0].Rows[0]["STOCK_CODE"].ToString();
                    txt_CKMC.Text = ds.Tables[0].Rows[0]["DEPOTNAME"].ToString();

                }
            }
            else
            {


                txt_WZMC.Text = "";
                txt_GGXH.Text = "";
                txt_JLDW.Text = "";
                txt_CZ.Text = "";
                txt_DZ.Text = "";
                Cmb_CKDM.Text = "";
                cmb_StorageLB.Text = "";
                txt_CKMC.Text = "";

            }
        }

        private void chk_wzmc_CheckedChanged(object sender, EventArgs e)
        {
            txt_wz.Enabled = chk_wzmc.Checked;
        }

        private void chk_Spet_CheckedChanged(object sender, EventArgs e)
        {
            txt_Spet.Enabled=chk_Spet.Checked  ;
        }
    }
}