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