/// <summary>
/// 修改资产负债表计算公式
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool UpdateFormulaDetails(FormulaDetailsModel model)
{
try
{
return(FormulaDetailsDBHelper.UpdateFormulaDetails(model));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 添加资产负债表公式明细
/// </summary>
/// <param name="model"></param>
/// <param name="IntID"></param>
/// <returns></returns>
public static bool InsertFormulaDetails(FormulaDetailsModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.AppendLine("insert into officedba.FormulaDetails(");
strSql.AppendLine("FormulaID,SubjectsCD,SubjectsName,Operator,Direction,CompanyCD)");
strSql.AppendLine(" values (");
strSql.AppendLine("@FormulaID,@SubjectsCD,@SubjectsName,@Operator,@Direction,@CompanyCD)");
SqlParameter[] parms = new SqlParameter[6];
parms[0] = SqlHelper.GetParameter("@FormulaID", model.FormulaID);
parms[1] = SqlHelper.GetParameter("@SubjectsCD", model.SubjectsCD);
parms[2] = SqlHelper.GetParameter("@SubjectsName", model.SubjectsName);
parms[3] = SqlHelper.GetParameter("@Operator", model.Operator);
parms[4] = SqlHelper.GetParameter("@Direction", model.Direction);
parms[5] = SqlHelper.GetParameter("@CompanyCD", model.CompanyCD);
SqlHelper.ExecuteTransSql(strSql.ToString(), parms);
return(SqlHelper.Result.OprateCount > 0 ? true : false);
}
/// <summary>
/// 修改资产负债表计算公式
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool UpdateFormulaDetails(FormulaDetailsModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.AppendLine("update officedba.FormulaDetails set ");
strSql.AppendLine("FormulaID=@FormulaID,");
strSql.AppendLine("SubjectsCD=@SubjectsCD,");
strSql.AppendLine("SubjectsName=@SubjectsName,");
strSql.AppendLine("Operator=@Operator,");
strSql.AppendLine("Direction=@Direction,");
strSql.AppendLine(" where ID=@ID");
SqlParameter[] parms = new SqlParameter[6];
parms[0] = SqlHelper.GetParameter("@FormulaID", model.FormulaID);
parms[1] = SqlHelper.GetParameter("@SubjectsCD", model.SubjectsCD);
parms[2] = SqlHelper.GetParameter("@SubjectsName", model.SubjectsName);
parms[3] = SqlHelper.GetParameter("@Operator", model.Operator);
parms[4] = SqlHelper.GetParameter("@Direction", model.Direction);
parms[5] = SqlHelper.GetParameter("@ID", model.ID);
SqlHelper.ExecuteTransSql(strSql.ToString(), parms);
return(SqlHelper.Result.OprateCount > 0 ? true : false);
}
