public static bool UpdateSubjectsBeginDetails(SubjectsBeginDetailsModel model)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("Update officedba.SubjectsBeginDetails");
sql.AppendLine("set SubjectsCD=@SubjectsCD,Dirt=@Dirt,");
sql.AppendLine("YTotalDebit=@YTotalDebit,");
sql.AppendLine("OriginalCurrency=@OriginalCurrency,");
sql.AppendLine("StandardCurrency=@StandardCurrency,BeginMoney=@BeginMoney,SumOriginalCurrency=@SumOriginalCurrency ");
sql.AppendLine(",YTotalDebitY=@YTotalDebitY,YTotalLendersY=@YTotalLendersY,");
sql.AppendLine("SubjectsDetails=@SubjectsDetails,FormTBName=@FormTBName,FileName=@FileName");
sql.AppendLine("where ID=@ID");
SqlParameter[] parms =
{
new SqlParameter("@ID", model.ID),
new SqlParameter("@SubjectsCD", model.SubjectsCD),
new SqlParameter("@Dirt", model.Dirt),
new SqlParameter("@YTotalDebit", model.YTotalDebit),
new SqlParameter("@YTotalLenders", model.YTotalLenders),
new SqlParameter("@OriginalCurrency", model.OriginalCurrency),
new SqlParameter("@StandardCurrency", model.StandardCurrency),
new SqlParameter("@BeginMoney", model.BeginMoney),
new SqlParameter("@SumOriginalCurrency", model.SumOriginalCurrency),
new SqlParameter("@YTotalDebitY", model.YTotalDebitY),
new SqlParameter("@YTotalLendersY", model.YTotalLendersY),
new SqlParameter("@SubjectsDetails", model.SubjectsDetails),
new SqlParameter("@FormTBName", model.FormTBName),
new SqlParameter("@FileName", model.FileName)
};
SqlHelper.ExecuteTransSql(sql.ToString(), parms);
return(SqlHelper.Result.OprateCount > 0 ? true : false);
}
public static bool UpdateSubjectsBeginDetails(SubjectsBeginDetailsModel model, string PeriodNum)
{
try
{
bool result = false;
string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
if (model.CompanyCD == null)
{
model.CompanyCD = CompanyCD;
}
if (SubjectsBeginDetailsDBHelper.UpdateSubjectsBeginDetails(model))
{
result = SubjectsBeginDetailsDBHelper.InsertPeriodNum(CompanyCD, PeriodNum);
}
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool InsertSubjectsBeginDetails(SubjectsBeginDetailsModel model)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("Insert into officedba.SubjectsBeginDetails");
sql.AppendLine("(CompanyCD,SubjectsCD,Dirt,YTotalDebit,");
sql.AppendLine("YTotalLenders,OriginalCurrency,StandardCurrency,BeginMoney,CurrencyType,SumOriginalCurrency,YTotalDebitY,YTotalLendersY,")
;
sql.AppendLine(" SubjectsDetails,FormTBName,FileName)");
sql.AppendLine("values(@CompanyCD,@SubjectsCD,@Dirt,@YTotalDebit,");
sql.AppendLine("@YTotalLenders,@OriginalCurrency,@StandardCurrency,@BeginMoney,@CurrencyType,@SumOriginalCurrency,@YTotalDebitY,@YTotalLendersY,@SubjectsDetails,@FormTBName,@FileName)");
SqlParameter[] parms =
{
new SqlParameter("@CompanyCD", model.CompanyCD),
new SqlParameter("@SubjectsCD", model.SubjectsCD),
new SqlParameter("@Dirt", model.Dirt),
new SqlParameter("@YTotalDebit", model.YTotalDebit),
new SqlParameter("@YTotalLenders", model.YTotalLenders),
new SqlParameter("@OriginalCurrency", model.OriginalCurrency),
new SqlParameter("@StandardCurrency", model.StandardCurrency),
new SqlParameter("@BeginMoney", model.BeginMoney),
new SqlParameter("@CurrencyType", model.CurrencyType),
new SqlParameter("@SumOriginalCurrency", model.SumOriginalCurrency),
new SqlParameter("@YTotalDebitY", model.YTotalDebitY),
new SqlParameter("@YTotalLendersY", model.YTotalLendersY),
new SqlParameter("@SubjectsDetails", model.SubjectsDetails),
new SqlParameter("@FormTBName", model.FormTBName),
new SqlParameter("@FileName", model.FileName)
};
SqlHelper.ExecuteTransSql(sql.ToString(), parms);
return(SqlHelper.Result.OprateCount > 0 ? true : false);
}