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

namespace Core.XgMes.Client.JGKC.MaterialManager
{
    public partial class FrmAcppetSheet : Mes.ClientFrameWork.FrmBase
    {
        public FrmAcppetSheet()
        {
            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["SHEET_NO"].Value);//验收单号
                    Cmb_CKDM.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["STORE_CODE"].Value);//仓库代码
                    cmb_StorageLB.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["CATEGORY"].Value);//仓库类别
                    txt_CKMC.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["STORE_NAME"].Value);//仓库名称 
                    Cmb_wzdm.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["MATERIALS_CODE"].Value);//物资代码
                    txt_WZMC.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["MATERIALS_NAME"].Value);//物资名称 
                    txt_GGXH.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["SPECT"].Value);//规格型号 
                    txt_JLDW.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["UNIT"].Value);//计量单位
                    txt_CZ.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["MATERIALS"].Value);//材质
                    txt_DZ.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["WEIGHT"].Value);//单重
                    txt_Pactnobh.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["PACTNO_NO"].Value);//合同编号
                    txt_YSS.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["NUMBERS"].Value);//验收数量
                    txt_Moneny.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["MONMER"].Value);//金额
                    txt_Price.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["PRICE"].Value);//单价
                    Cmd_GFCode.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["PROVIDER_CODE"].Value);//供方代码
                    txt_GYMC.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["PROVIDER"].Value);//供方名称 
                    txt_Remark.Text = Comm.ObjToStr(this.gd_CK.ActiveRow.Cells["REMARK"].Value);//备注








                }
            }
            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.Cmb_wzdm.Text.Trim().ToString()));//6 物资代码
                MetarilInfo.Add(Comm.ObjToStr(this.txt_WZMC.Text.Trim().ToString()));//7 物资名称
                MetarilInfo.Add(Comm.ObjToStr(this.txt_GGXH.Text.Trim().ToString()));//8 规格型号
                MetarilInfo.Add(Comm.ObjToStr(this.txt_JLDW.Text.Trim().ToString()));//9 计量单位
                MetarilInfo.Add(Comm.ObjToStr(this.txt_CZ.Text.Trim().ToString()));//10 材质
                MetarilInfo.Add(Comm.ObjToStr(this.txt_Pactnobh.Text.Trim().ToString()));//11 合同编号
                MetarilInfo.Add(Comm.ObjToStr(this.txt_YSS.Text.Trim().ToString()));//12 验收数量
                MetarilInfo.Add(Comm.ObjToStr(this.txt_Price.Text.Trim().ToString()));//13 单价
                MetarilInfo.Add(Comm.ObjToStr(this.txt_Moneny.Text.Trim().ToString()));//14 金额
                MetarilInfo.Add(Comm.ObjToStr(this.Cmd_GFCode.Text.Trim().ToString()));//15 供方代码
                MetarilInfo.Add(Comm.ObjToStr(this.txt_GYMC.Text.Trim().ToString()));//16 供方名称
                
                MetarilInfo.Add(Comm.ObjToStr(this.txt_Remark.Text.Trim().ToString()));//17 备注
        




                MetarilInfo.Add(ClientCommon._UserInfo.UserName.ToString());//18 操作人
                MetarilInfo.Add(strMode);//19 操作模式
                MetarilInfo.Add(txt_DZ.Text.Trim().ToString());//单重
           


                object obj = Core.Mes.ClientFrameWork.ClientCommon._RemotingHelp.ExecuteMethod("BJZWWLStuff", "Core.XgMes.Server.JGKC.MaterialManager.Metarial",
                    "AccpetSheetAdd", 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  ACCPECT_DATE >='" + Convert.ToDateTime(dte_BeginTime.Value.ToString()).ToString("yyyyMMdd") + "' AND ACCPECT_DATE <='" + Convert.ToDateTime(dte_EndTime.Value.ToString()).ToString("yyyyMMdd") + "'";
            }
            if (Chk_CKLB.Checked && txt_ckm.Text.Trim().Length>0)
            {
                strWhere += " AND CATEGORY LIKE '" + txt_ckm.Text.Trim().ToString() + "%' ";
            }
            if (Chk_WZDM.Checked && txt_wzdm.Text.Trim().Length > 0)
            {
                strWhere += " AND MATERIALS_CODE LIKE '" + txt_wzdm.Text.Trim().ToString() + "%' ";
            }
            if (chk_wz.Checked && txt_wz.Text.Trim().Length > 0)
            {
                strWhere += " AND materials_name LIKE '" + txt_wz.Text.Trim().ToString() + "%' ";
            }
            if (chk_Spet.Checked && txt_Spet.Text.Trim().Length > 0)
            {
                strWhere += " AND spect LIKE '" + txt_Spet.Text.Trim().ToString() + "%' ";
            }
            string err = "";
             sql = "select sheet_no,accpect_date,category,store_name,materials_code,materials_name,spect,unit, provider,"
                         +"pactno_no,numbers, price,monmer,materials,weight,input_recoder, input_date,store_code, remark,provider_code     "
                         +" from sheet_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 FrmAcppetSheet_Load(object sender, EventArgs e)
        {
            dte_BeginTime.DateTime = DateTime.Now;
            dte_EndTime.DateTime = DateTime.Now;
            date_YS.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_wzdm_Enter(object sender, EventArgs e)
        {
           
        }

        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 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 chk_wz_CheckedChanged(object sender, EventArgs e)
        {
            txt_wz.Enabled=chk_wz.Checked ;
        }

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