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