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