const string DIRECTION_D = "1";//贷方向
#endregion
#region 结转到下一年
public static bool JZtoNextYear()
{
//bool result = false;
//获取当前企业代码
string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
try
{
//获取结转下一年的期末余额的记录ID
DataTable dtid = EndItemProcessing.GetJZNextYearRecordId(CompanyCD);
//登帐凭证期末余额ID
string AccountID = string.Empty;
//实例存放科目实体的数组
ArrayList modelList = new ArrayList();
if (dtid != null && dtid.Rows.Count > 0)
{
foreach (DataRow rows in dtid.Rows)
{
AccountID += rows["ID"].ToString() + ",";
}
AccountID = AccountID.Remove(AccountID.Length - 1);
//获取科目年末余额
DataTable dtEndAmount = EndItemProcessing.GetJZNextYearEndAmount(AccountID);
//定义会计科目实体
AccountSubjectsModel model = null;
if (dtEndAmount != null && dtEndAmount.Rows.Count > 0)
{
foreach (DataRow row in dtEndAmount.Rows)
{
//实例科目实体
model = new AccountSubjectsModel();
model.SubjectsCD = row["SubjectsCD"].ToString();
model.CompanyCD = CompanyCD;
model.YInitialValue = Convert.ToDecimal(row["EndAmount"]);
modelList.Add(model);
}
}
}
//更新会计科目年初始值
return EndItemProcessing.UpdateSubjectsYInitialValue(modelList);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 更新科目期初值
/// </summary>
/// <param name="Model">科目实体</param>
/// <returns>True 成功，false失败</returns>
public static bool UpdateBeginMoney(AccountSubjectsModel Model)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("Update officedba.AccountSubjects set CreateDate=@CreateDate,");
sql.AppendLine("YInitialValue=@YInitialValue,YTotalDebit=@YTotalDebit,");
sql.AppendLine("YTotalLenders=@YTotalLenders,BeginMoney=@BeginMoney where ID=@ID and CompanyCD=@CompanyCD");
SqlParameter[]parms=new SqlParameter[7];
parms[0] = SqlHelper.GetParameter("@CreateDate", Model.CreateDate);
parms[1] = SqlHelper.GetParameter("@YInitialValue", Model.YInitialValue);
parms[2] = SqlHelper.GetParameter("@YTotalDebit", Model.YTotalDebit);
parms[3] = SqlHelper.GetParameter("@YTotalLenders", Model.YTotalLenders);
parms[4] = SqlHelper.GetParameter("@BeginMoney", Model.BeginMoney);
parms[5] = SqlHelper.GetParameter("@ID", Model.ID);
parms[6] = SqlHelper.GetParameter("@CompanyCD", Model.CompanyCD);
SqlHelper.ExecuteTransSql(sql.ToString(), parms);
return SqlHelper.Result.OprateCount > 0 ? true : false;
}
/// <summary>
/// 新增会计科目信息
/// </summary>
/// <param name="Model">科目实体</param>
/// <returns>True 成功，false失败</returns>
public static bool InsertAccountSubjects(AccountSubjectsModel Model)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("Insert into Officedba.AccountSubjects(CompanyCD,SubjectsCD,SubjectsName, ");
sql.AppendLine("ParentID,SubjectsType,Type,BlanceDire,CreateDate,AuciliaryCD,ForCurrencyAcc,UsedStatus)");
sql.AppendLine("Values(@CompanyCD,@SubjectsCD,@SubjectName,");
sql.AppendLine("@ParentID,@SubjectsType,@Type,@BlanceDire,getdate(),@AuciliaryCD,@ForCurrencyAcc,@UsedStatus)");
SqlParameter []parms=new SqlParameter[10];
parms[0] = SqlHelper.GetParameter("@CompanyCD", Model.CompanyCD);
parms[1] = SqlHelper.GetParameter("@SubjectsCD", Model.SubjectsCD);
parms[2] = SqlHelper.GetParameter("@SubjectName", Model.SubjectsName);
parms[3] = SqlHelper.GetParameter("@ParentID", Model.ParentID);
parms[4] = SqlHelper.GetParameter("@SubjectsType", Model.SubjectsType);
parms[5] = SqlHelper.GetParameter("@Type", Model.Type);
parms[6] = SqlHelper.GetParameter("@BlanceDire", Model.BlanceDire);
parms[7] = SqlHelper.GetParameter("@AuciliaryCD", Model.AuciliaryCD);
parms[8] = SqlHelper.GetParameter("@ForCurrencyAcc", Model.ForCurrencyAcc);
parms[9] = SqlHelper.GetParameter("@UsedStatus", Model.UsedStatus);
SqlHelper.ExecuteTransSql(sql.ToString(), parms);
return SqlHelper.Result.OprateCount > 0 ? true : false;
}
/// <summary>
/// 修改会计科目信息
/// </summary>
/// <param name="Model">科目实体</param>
/// <returns>True 成功，false失败</returns>
public static bool UpdateAccountSubjects(AccountSubjectsModel Model)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("Update Officedba.AccountSubjects set SubjectsCD=@SubjectsCD, ");
sql.AppendLine("SubjectsName=@SubjectsName,ParentID=@ParentID,SubjectsType=@SubjectsType,Type=@Type,BlanceDire=@BlanceDire,");
sql.AppendLine("AuciliaryCD=@AuciliaryCD,UsedStatus=@UsedStatus,ForCurrencyAcc=@ForCurrencyAcc where CompanyCD=@CompanyCD and ID=@ID ");
SqlParameter[]parms=new SqlParameter[11];
parms[0] = SqlHelper.GetParameter("@CompanyCD", Model.CompanyCD);
parms[1] = SqlHelper.GetParameter("@SubjectsName", Model.SubjectsName);
parms[2] = SqlHelper.GetParameter("@ParentID", Model.ParentID);
parms[3] = SqlHelper.GetParameter("@SubjectsType", Model.SubjectsType);
parms[4] = SqlHelper.GetParameter("@Type", Model.Type);
parms[5] = SqlHelper.GetParameter("@BlanceDire", Model.BlanceDire);
parms[6] = SqlHelper.GetParameter("@AuciliaryCD", Model.AuciliaryCD);
parms[7] = SqlHelper.GetParameter("@ForCurrencyAcc", Model.ForCurrencyAcc);
parms[8] = SqlHelper.GetParameter("@ID", Model.ID);
parms[9] = SqlHelper.GetParameter("@UsedStatus", Model.UsedStatus);
parms[10] = SqlHelper.GetParameter("@SubjectsCD", Model.SubjectsCD);
SqlHelper.ExecuteTransSql(sql.ToString(),parms);
return SqlHelper.Result.OprateCount > 0 ? true : false;
}
/// <summary>
/// 修改会计科目信息
/// </summary>
/// <param name="Model">科目实体</param>
/// <returns>True 成功，false失败</returns>
public static bool UpdateAccountSubjects(AccountSubjectsModel Model)
{
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
if (Model == null) return false;
if (Model.CompanyCD == null) Model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
try
{
bool succ = false;
string loginUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID;
LogInfoModel logModel = InitLogInfo(Model.SubjectsCD);
logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
succ = AccountSubjectsDBHelper.UpdateAccountSubjects(Model);
if (!succ)
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
else
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
LogDBHelper.InsertLog(logModel);
return succ;
}
catch (Exception ex)
{
WriteSystemLog(userInfo, ex);
throw ex;
}
}
/// <summary>
/// 更新科目期初值
/// </summary>
/// <param name="Model">科目实体</param>
/// <returns>True 成功，false失败</returns>
public static bool UpdateBeginMoney(AccountSubjectsModel Model)
{
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
if (Model == null) return false;
if (Model.CompanyCD == null) Model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
try
{
return AccountSubjectsDBHelper.UpdateBeginMoney(Model);
}
catch (Exception ex)
{
throw ex;
}
}