using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using SQLHelper;
using DBUtility;

namespace BLL
{
    class ClsXt_AccountPeriod
    {
        private string _mvarItemKey;

        public string MvarItemKey
        {
            get { return _mvarItemKey; }
            set { _mvarItemKey = value; }
        }
        private string _mvarReportTitle;

        public string MvarReportTitle
        {
            get { return _mvarReportTitle; }
            set { _mvarReportTitle = value; }
        }
        ClsCN oCN = new ClsCN();
        public int HYear;
        public int HPeriod;
        public string HBeginDate;
        public string HEndDate;
        public bool HEndFlag;
        //新增
        public bool AddNew()
        {
            try
            {
                oCN.BeginTran();
                oCN.RunProc("Insert into Xt_AccountPeriod " +
                    " (HYear,HPeriod,HBeginDate" +
                    ",HEndDate,HEndFlag) " +
                    " Values(" + this.HYear.ToString() + "," + this.HPeriod.ToString() + ",'" + this.HBeginDate +
                    "','" + this.HEndDate + "',0)");
                 
                oCN.Commit();
                return true;
            }
            catch (Exception e)
            {
                oCN.RollBack();
                return false; 
            }
        }
       
        //修改
        public bool ModifyByID(int sYear,int sPeriod)
        {
            try
            {
                oCN.BeginTran();
                oCN.RunProc("Update Xt_AccountPeriod set " +
                    " HYear=" + this.HYear + "" +
                    ",HPeriod=" + this.HPeriod + "" +
                    ",HBeginDate='" + this.HBeginDate +"'"+
                    ",HEndDate='" + this.HEndDate + "' Where  HYear=" + sYear.ToString() + "  and  HPeriod=" + sPeriod.ToString());
                //
                oCN.Commit();
                return true;
            }
            catch (Exception e)
            {
                oCN.RollBack();
                return false;
            }
        }

        #region 固定代码
         
        //删除
        public bool DeleteByID(int sYear,int sPeriod)
        {
            try
            {
                oCN.RunProc("Delete from Xt_AccountPeriod where HYear=" + sYear.ToString() + "  and  HPeriod=" + sPeriod.ToString());
                return true;
            }
            catch (Exception e)
            {
                return false;
            }
        }
        //重复代码
        public bool HavSameNumber(int sYear,int sPeriod)
        {
            DataSet DS ;
            try
            {
                DS = oCN.RunProcReturn("Select HYear from Xt_AccountPeriod Where HYear=" + sYear + " and HPeriod=" + sPeriod + "", "Xt_AccountPeriod");
                if (DS.Tables[0].Rows.Count == 0)
                    return false;
                else
                {
                    return true;
                }
            }
            catch (Exception e)
            {
                return false;
            }
        }
        //结账
        public bool CloseAcc()
        {
            try
            {
                ClsPub.Sub_GetCurPeriod(ref ClsPub.CurYear,ref ClsPub.CurPeriod);
                oCN.RunProc("UpDate Xt_AccountPeriod set HEndFlag=1 where HYear="+ClsPub.CurYear+" and HPeriod="+ClsPub.CurPeriod);
                ClsPub.Sub_GetCurPeriod(ref ClsPub.CurYear, ref ClsPub.CurPeriod);
                return true;
            }
            catch (Exception e)
            {
                return false;
            }
        }

        //反结账
        public bool UnCloseAcc()
        {
            try
            {
                ClsPub.Sub_GetCurPeriod(ref ClsPub.CurYear, ref ClsPub.CurPeriod);
                oCN.RunProc("exec h_p_Xt_UnCloseAccount ");
                ClsPub.Sub_GetCurPeriod(ref ClsPub.CurYear, ref ClsPub.CurPeriod);
                return true;
            }
            catch (Exception e)
            {
                return false;
            }
        }
        

        //构造函数
        public ClsXt_AccountPeriod() 
        {
            MvarItemKey="Xt_AccountPeriod";
            MvarReportTitle = "会计期间设置";
        }
        #endregion

         
    }
}