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_SingleBalBill_YR : Form
    {
        public Pay_SingleBalBill_YR()
        {
            InitializeComponent();
        }

        public DAL.ClsPay_SingleBalBill BillNew = new DAL.ClsPay_SingleBalBill();   //¶ÔÓ¦µ¥¾ÝÀà
        private void Pay_SingleBalBill_YR_Load(object sender, EventArgs e)
        {
            cmbHYear.Items.Clear();
            //»ñÈ¡±¾Æڳɱ¾»á¼ÆÆÚ¼ä
            int CurYear=0;
            int CurPeriod=0;
            if (DBUtility.ClsPub.Sub_GetCurPeriod(ref  CurYear,ref  CurPeriod) == false)
            {
                MessageBox.Show("»ñÈ¡³É±¾»á¼ÆÆÚ¼äʧ°Ü!");
                return;
            }
            cmbHYear.Items.Add(CurYear);
            cmbHYear.Items.Add(CurYear - 1);
            cmbHYear.Items.Add(CurYear - 2);
            cmbHYear.Items.Add(CurYear - 3);
            cmbHYear.Items.Add("");
            cmbHYear.SelectedIndex = 0;
            cmbHPeriod.Text = CurPeriod.ToString();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            SQLHelper.ClsCN oCn=new SQLHelper.ClsCN();
            DataSet Ds;
            Ds = oCn.RunProcReturn("select * from xt_AccountPeriod where HYear="+cmbHYear.Text+" and HPeriod="+cmbHPeriod.Text+" and HEndFlag=0", "xt_AccountPeriod",ref DBUtility.ClsPub.sErrInfo);
            if (Ds == null)
            {
                MessageBox.Show("»ñÈ¡»á¼ÆÆÚ¼ä³ö´í£º"+DBUtility.ClsPub.sErrInfo);
                return;
            }
            if (Ds.Tables[0].Rows.Count == 0)
            {
                MessageBox.Show("±¾»á¼ÆÆÚ¼äÒѽáÕË£¬²»ÔÊÐíÒýÈ룡"  );
                return;
            }

            Ds = oCn.RunProcReturn("select * from Pay_SingleBalBillMain  where HSaveFlag=1 and HYear=" + cmbHYear.Text + " and HPeriod=" + cmbHPeriod.Text, "Pay_SingleBalBillMain", ref DBUtility.ClsPub.sErrInfo);
            if (Ds == null)
            {
                MessageBox.Show("ÅжÏÊÇ·ñÒÑÒýÈë³ö´í£º" + DBUtility.ClsPub.sErrInfo);
                return;
            }
            if (Ds.Tables[0].Rows.Count != 0)
            {
                if (MessageBox.Show("±¾»á¼ÆÆÚ¼äÒÑÒýÈ룬ÊÇ·ñ¸²¸Ç£¿", "Ìáʾ", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
                {
                    oCn.RunProc("delete Pay_SingleBalBillMain  where HSaveFlag=1 and HYear=" + cmbHYear.Text + " and HPeriod=" + cmbHPeriod.Text);
                }
                else
                {
                    return;
                }
            }
            Ds = oCn.RunProcReturn("exec h_p_Pay_SingleBalBill_YR " + cmbHYear.Text + "," + cmbHPeriod.Text, "h_p_Pay_SingleBalBill_YR");
            for (int i = 0; i < Ds.Tables[0].Rows.Count; i++)
            {
                if (DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[i]["HPrice"]) == 0)
                {
                    MessageBox.Show("ÎïÁÏ´úÂ룺" + Ds.Tables[0].Rows[i]["HMaterNumber"].ToString() + "£¬¹¤Ðò£º" + Ds.Tables[0].Rows[i]["HProcName"].ToString() + " ¹¤¼ÛΪ0£¬²»ÔÊÐíÒýÈ룡");
                    return;
                }
            }
            bool bResult;
            for (int i = 0; i < Ds.Tables[0].Rows.Count; i++)
            {
                BillNew.omodel.HYear = DBUtility.ClsPub.isLong(cmbHYear.Text);
                BillNew.omodel.HPeriod = DBUtility.ClsPub.isLong(cmbHPeriod.Text);
                //¹Ì¶¨¸³Öµ=================================
                BillNew.omodel.HBillNo = DBUtility.ClsPub.CreateBillCode(BillNew.BillType, ref DBUtility.ClsPub.sExeReturnInfo, true);  //ÔÚ¸³ÖµÀàÇ°¾Í´¦ÀíºÃ×Ö·û´®ºÍÊý×Ö
                BillNew.omodel.HDate = DBUtility.ClsPub.isDate(cmbHYear.Text + "-" + cmbHPeriod.Text + "-01");
                BillNew.omodel.HRemark = "";
                //====================================================
                BillNew.omodel.HGroupID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HGroupID"]);
                BillNew.omodel.HDeptID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HDeptID"]);
                BillNew.omodel.HEmpID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HEmpID"]);
                BillNew.omodel.HPayType = 0;
                BillNew.omodel.HExplanation = "";
                BillNew.omodel.HInnerBillNo = "";
                BillNew.omodel.HSaveFlag = true;
                //Ã÷ϸÀำֵ
                BillNew.DetailColl = new List<Model.ClsPay_SingleBalBillSub>();

                Model.ClsPay_SingleBalBillSub oSub = new Model.ClsPay_SingleBalBillSub();
                //¹Ì¶¨¸³Öµ========================================
                oSub.HEntryID = 1;
                oSub.HRemark = "";
                oSub.HSourceInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HInterID"]);
                oSub.HSourceEntryID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HEntryID"]);
                oSub.HSourceBillType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HBillType"]);
                oSub.HSourceBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HBillNo"]);
                oSub.HRelationQty = 0;
                oSub.HRelationMoney = 0;
                oSub.HCloseMan = "";
                oSub.HEntryCloseDate = DBUtility.ClsPub.isDate("1900-01-01");
                oSub.HCloseType = false;
                //=============================
                oSub.HMaterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HMaterID"]);
                oSub.HProcID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HProcID"]);
                oSub.HSourceID = 0;
                oSub.HEmpID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HEmpID"]);
                oSub.HTimes = 0;
                oSub.HQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[i]["HQty"]);
                oSub.HPrice = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[i]["HPrice"]);
                oSub.HPriceRate = 1;

                oSub.HSubsidyTotal = 0;
                oSub.HDeuctTotal = 0;
                //
                oSub.HSubsidyID = 0;
                oSub.HDeuctID = 0;

                oSub.HMoney = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[i]["HMoney"]);
                oSub.HICMOInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HICMOInterID"]);
                oSub.HICMOBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HICMOBillNo"]);
                oSub.HProcReportInterID = 0;
                oSub.HProcReportEntryID = 0;
                oSub.HProcReportBillNo = "";
                oSub.HProcPlanInterID = 0;
                oSub.HProcPlanEntryID = 0;
                oSub.HProcPlanBillNo = "";
                oSub.HPackQty = 0;
                oSub.HPackPrice = 0;
                oSub.HPackMoney = 0;
                oSub.HPackMaterID = 0;
                oSub.HSubsidyQty = 0;
                oSub.HSubsidyMoney = 0;
                oSub.HSqty = 0;
                BillNew.DetailColl.Add(oSub);

                bResult = BillNew.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
                if(bResult==false)
                {
                    MessageBox.Show("±£´æʧ°Ü!Ô­Òò:" + DBUtility.ClsPub.sExeReturnInfo, "Ìáʾ");
                    oCn.RunProc("delete Pay_SingleBalBillMain  where HSaveFlag=1 and HYear=" + cmbHYear.Text + " and HPeriod=" + cmbHPeriod.Text);
                    return;
                }
            }
            MessageBox.Show("ÒýÈëÍê±Ï£¡");
            this.Close();
        }

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