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
|
|
|
}
|
}
|
