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

namespace DAL
{
    public class ClsKf_BillDatePeriod
    {
        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 AddNew()
        {
            try
            {
                oCN.BeginTran();
                oCN.RunProc("Insert into Kf_BillDatePeriod " +
                    " (HYear,HPeriod,HBeginDate" +
                    ",HEndDate) " +
                    " Values(" + this.HYear.ToString() + "," + this.HPeriod.ToString() + ",'" + this.HBeginDate +
                    "','" + this.HEndDate + "')");
                 
                oCN.Commit();
                return true;
            }
            catch (Exception e)
            {
                oCN.RollBack();
                return false; 
            }
        }
       
        //修改
        public bool ModifyByID(int sYear,int sPeriod)
        {
            try
            {
                oCN.BeginTran();
                oCN.RunProc("Update Kf_BillDatePeriod 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 Kf_BillDatePeriod 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 Kf_BillDatePeriod Where HYear=" + sYear + " and HPeriod=" + sPeriod + "", "Kf_BillDatePeriod");
                if (DS.Tables[0].Rows.Count == 0)
                    return false;
                else
                {
                    return true;
                }
            }
            catch (Exception e)
            {
                return false;
            }
        }

        //返回项目信息
        public bool GetInfoByID(int sYear, int sPeriod)
        {
            DataSet DS;
            try
            {
                DS = oCN.RunProcReturn("Select * from Kf_BillDatePeriod Where HYear=" + sYear.ToString() + " and HPeriod=" + sPeriod.ToString(), "Kf_BillDatePeriod");
                if (DS.Tables[0].Rows.Count == 0)
                    return false;
                else
                {
                    HYear = ClsPub.isInt(DS.Tables[0].Rows[0]["HYear"]);
                    HPeriod = ClsPub.isInt(DS.Tables[0].Rows[0]["HPeriod"]);
                    HBeginDate = ClsPub.isDate(DS.Tables[0].Rows[0]["HBeginDate"]).ToShortDateString();
                    HEndDate = ClsPub.isDate(DS.Tables[0].Rows[0]["HEndDate"]).ToShortDateString();
                    return true;
                }
            }
            catch (Exception e)
            {
                return false;
            }
        }

        //构造函数
        public ClsKf_BillDatePeriod() 
        {
            MvarItemKey="Kf_BillDatePeriod";
            MvarReportTitle = "单据日期期间设置";
        }
        #endregion

         
    }
}