using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace PayM
{
    public partial class Pay_PayMent_QCAdd : Form
    {
        public Pay_PayMent_QCAdd()
        {
            InitializeComponent();
        }

        public int HYear;
        public int HPeriod;
        long HMaterID;
        long HDeptID;
        long HGroupID;
        long HEmpID;
        long HProcID;
        long HUnitID;
        double HMoney;
        long HICMOInterID;
        string HICMOBillNo;
        string HRemark;
        private void cmdHMaterID_Click(object sender, EventArgs e)
        {

            DAL.ClsGy_Material_View oMater = new DAL.ClsGy_Material_View();
            if (oMater.RefreshView())
            {
                txtHMaterID.Tag = oMater.omodel.HItemID;
                txtHMaterID.Text = oMater.omodel.HNumber;
                txtHMaterName.Text = oMater.omodel.HName;
                txtHUnitID.Tag = oMater.omodel.HUnitID;
                txtHUnitID.Text = oMater.omodel.HUnitName;
            }
            else
            {
                txtHMaterID.Tag = 0;
                txtHMaterID.Text = "";
                txtHMaterName.Text = "";
                txtHUnitID.Tag = 0;
                txtHUnitID.Text = "";
            }
        }

        private void txtHMaterID_TextChanged(object sender, EventArgs e)
        {
            if (txtHMaterID.Text.Trim() == "")
            {
                txtHMaterID.Tag = "0";
                txtHMaterName.Text = "";
            }
        }

        private void cmdHCostItemID_Click(object sender, EventArgs e)
        {
            DAL.ClsGy_Department_View oDept = new DAL.ClsGy_Department_View();
            if (oDept.RefreshView())
            {
                txtHDeptID.Text = oDept.oModel.HName;
                txtHDeptID.Tag = oDept.oModel.HItemID;
            }
            else
            {
                txtHDeptID.Text = "";
                txtHDeptID.Tag = 0;
            }
        }

        private void txtHCostItemID_TextChanged(object sender, EventArgs e)
        {
            if (txtHDeptID.Text.Trim() == "")
                txtHDeptID.Tag = "0";
        }

        private void Pay_PayMent_QCAdd_Load(object sender, EventArgs e)
        {

            //获取本期成本会计期间
            if (DBUtility.ClsPub.Sub_CBGetCurPeriod() == false)
            {
                MessageBox.Show("获取成本会计期间失败!");
                return;
            }
            cmbHYear.Items.Add(DBUtility.ClsPub.CBCurYear);
            cmbHYear.Items.Add(DBUtility.ClsPub.CBCurYear - 1);
            cmbHYear.Items.Add(DBUtility.ClsPub.CBCurYear - 2);
            cmbHYear.Items.Add(DBUtility.ClsPub.CBCurYear - 3);
            //cmbHYear.SelectedIndex = 0;
            //cmdHPeriod.Text = DBUtility.ClsPub.CBCurPeriod.ToString();
            cmbHYear.Text = DBUtility.ClsPub.isStrNull(HYear);
            cmbHPeriod.Text = DBUtility.ClsPub.isStrNull(HPeriod);
        }

        private void button2_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
            DataSet Ds;
            HYear = DBUtility.ClsPub.isInt( cmbHYear.Text);
            HPeriod = DBUtility.ClsPub.isInt(cmbHPeriod.Text);
            HDeptID = DBUtility.ClsPub.isLong(txtHDeptID.Tag);
            HGroupID = DBUtility.ClsPub.isLong(txtHGroupID.Tag);
            HEmpID = DBUtility.ClsPub.isLong(txtHEmpID.Tag);
            HMaterID = DBUtility.ClsPub.isLong(txtHMaterID.Tag);
            HProcID = DBUtility.ClsPub.isLong(txtHProcID.Tag);
            HUnitID = DBUtility.ClsPub.isLong(txtHUnitID.Tag);
            HMoney = DBUtility.ClsPub.isDoule(txtHMoney.Text);
            HICMOInterID = DBUtility.ClsPub.isLong(txtHICMOBillNo.Tag);
            HICMOBillNo = DBUtility.ClsPub.isStrNull(txtHICMOBillNo.Text);
            HRemark=DBUtility.ClsPub.isStrNull(txtHRemark.Text);


            Ds = oCn.RunProcReturn("select * from Pay_InitReportBalBill where HYear=" + HYear +
                                                    " and HPeriod=" + HPeriod +
                                                    " and HDeptID=" + HDeptID +
                                                    " and HGroupID=" + HGroupID +
                                                    " and HEmpID=" + HEmpID +
                                                    " and HMaterID=" + HMaterID +
                                                    " and HProcID=" + HProcID +
                                                    " and HICMOBillNo='" + HICMOBillNo +"'"+
                                                    " and HICMOInterID=" + HICMOInterID +
                                                    " and HUnitID=" + HUnitID, "Pay_InitReportBalBill");
            if (Ds.Tables[0].Rows.Count > 0)
            {
                if (MessageBox.Show("该员工对应工序已存在期初，是否覆盖？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
                {
                    oCn.RunProc("delete Pay_InitReportBalBill  where HYear=" + HYear +
                                                    " and HPeriod=" + HPeriod +
                                                    " and HDeptID=" + HDeptID +
                                                    " and HGroupID=" + HGroupID +
                                                    " and HEmpID=" + HEmpID +
                                                    " and HMaterID=" + HMaterID +
                                                    " and HProcID=" + HProcID +
                                                    " and HICMOBillNo='" + HICMOBillNo + "'" +
                                                    " and HICMOInterID=" + HICMOInterID +
                                                    " and HUnitID=" + HUnitID);
                }
                else
                {
                    return; 
                }
            }
            oCn.RunProc("insert into  Pay_InitReportBalBill (HYear,HPeriod,HBillType,HDate " +
                               " ,HDeptID,HGroupID,HEmpID,HMaterID,HProcID,HUnitID,HBeginQty" +
                               " ,HReceiveQty,HSendQty,HEndQty,HBeginBal,HReceiveBal,HSendBal,HEndBal" +
                               " ,HICMOInterID,HICMOBillNo,HRemark,HMaker,HMakeDate" +
                               ") values (" +
                                HYear + "," + HPeriod + ",2213,getdate()"+
                                "," + HDeptID + "," + HGroupID + "," + HEmpID + "," + HMaterID + "," + HProcID + "," + HUnitID + "," + HMoney + 
                                ",0,0,0,0,0,0,0"+
                                ","+HICMOInterID+",'"+HICMOBillNo+"','"+HRemark+"','"+DBUtility.ClsPub.CurUserName+"',getdate()"+
                                ")");
            MessageBox.Show("保存完毕！"); 
        }

        private void cmdHGroupID_Click(object sender, EventArgs e)
        {
            DAL.ClsGy_Group_View oGroup = new DAL.ClsGy_Group_View();
            if (oGroup.RefreshView())
            {
                txtHGroupID.Text = oGroup.oModel.HName;
                txtHGroupID.Tag = oGroup.oModel.HItemID;
            }
            else
            {
                txtHGroupID.Text = "";
                txtHGroupID.Tag = 0;
            }
        }

        private void cmdHProcID_Click(object sender, EventArgs e)
        {
            //DAL.ClsK3_Process_View oProc = new DAL.ClsK3_Process_View();
            //if (oProc.RefreshView())
            //{
            //    txtHProcID.Text = oProc.oModel.HName;
            //    txtHProcID.Tag = oProc.oModel.HItemID;
            //}
            //else
            //{
            //    txtHProcID.Text = "";
            //    txtHProcID.Tag = 0;
            //}
            if (DBUtility.ClsPub.isLong(txtHICMOBillNo.Tag) == 0)
            {
                BLL.ClsBaseSelect_InterFace.SetTextByProc(txtHProcID);
            }
            else
            {
                BLL.ClsBaseSelect_InterFace.SetTextByProc_ICMO(txtHProcID, DBUtility.ClsPub.isLong(txtHICMOBillNo.Tag));
            }
        }

        private void cmdHEmpID_Click(object sender, EventArgs e)
        {
            DAL.ClsGy_Employee_View oEmp = new DAL.ClsGy_Employee_View();
            if (oEmp.RefreshView())
            {
                txtHEmpID.Text = oEmp.oModel.HName;
                txtHEmpID.Tag = oEmp.oModel.HItemID;
            }
            else
            {
                txtHEmpID.Text = "";
                txtHEmpID.Tag = 0;
            }
        }

        private void txtHGroupID_TextChanged(object sender, EventArgs e)
        {
            if (txtHGroupID.Text.Trim() == "")
                txtHGroupID.Tag = "0";
        }

        private void txtHProcID_TextChanged(object sender, EventArgs e)
        {
            if (txtHProcID.Text.Trim() == "")
                txtHProcID.Tag = "0";
        }

        private void txtHEmpID_TextChanged(object sender, EventArgs e)
        {
            if (txtHEmpID.Text.Trim() == "")
                txtHEmpID.Tag = "0";
        }

        private void cmdHUnitID_Click(object sender, EventArgs e)
        {
            DAL.ClsGy_Unit_View oUnit = new DAL.ClsGy_Unit_View();
            if (oUnit.RefreshView())
            {
                txtHUnitID.Text = oUnit.oModel.HName;
                txtHUnitID.Tag = oUnit.oModel.HItemID;
            }
            else
            {
                txtHUnitID.Text = "";
                txtHUnitID.Tag = 0;
            }
        }

        private void txtHUnitID_TextChanged(object sender, EventArgs e)
        {
            if (txtHUnitID.Text.Trim() == "")
                txtHUnitID.Tag = "0";
        }

        private void cmdHICMOBillNo_Click(object sender, EventArgs e)
        {
            DAL.Cls_S_K3_ICMOForProdInList oK3_ICMOForProdInList = new DAL.Cls_S_K3_ICMOForProdInList();
            if (oK3_ICMOForProdInList.Refresh(""))  //选择原单
            {
                FillSelectData(oK3_ICMOForProdInList.oBillSelectColl);
            }
        }
        private void FillSelectData(List<DBUtility.BillSelect> oList)
        {
            DataSet Ds;
            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
            int i = -1;
            foreach (DBUtility.BillSelect oSelectRow in oList)
            {
                i = i + 1;
                //生产任务单
                if (oSelectRow.BillType == "85")
                {
                    //grdMain.Rows.Add();
                    Application.DoEvents();
                    //得到信息
                    Ds = oCn.RunProcReturn("select * from h_v_K3_ICMOBillList where hmainid=" + oSelectRow.BillMainID + " and hsubid=0", "h_v_K3_ICMOBillList");
                    //写入信息
                    //Sub_WriteInForm(Ds.Tables[0], i);
                    txtHDeptID.Tag = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HDeptID"]);
                    txtHDeptID.Text = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["部门"]);
                    txtHMaterID.Tag = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HMaterID"]);
                    txtHMaterID.Text = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["物料代码"]);
                    txtHMaterName.Text = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["物料名称"]);
                    txtHUnitID.Tag = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HUnitID"]);
                    txtHUnitID.Text = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["计量单位"]);
                    txtHICMOBillNo.Tag = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HMainID"]);
                    txtHICMOBillNo.Text = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["单据号"]);
                    Application.DoEvents();
                }

                //
            }
        }
    }
}