/// <summary>
/// 修改现金流量表计算公式
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool UpdateCashFlowFormulaDetails(CashFlowFormulaDetailsModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.AppendLine("update officedba.CashFlowFormulaDetails set ");
strSql.AppendLine("FormulaID=@FormulaID,");
strSql.AppendLine("SubjectsCD=@SubjectsCD,");
strSql.AppendLine("SubjectsName=@SubjectsName,");
strSql.AppendLine("Operator=@Operator,");
strSql.AppendLine("Direction=@Direction,");
strSql.AppendLine("OperatorType=@OperatorType,");
strSql.AppendLine("CompanyCD=@CompanyCD");
strSql.AppendLine(" where ID=@ID");
SqlParameter[] parms = new SqlParameter[8];
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("@OperatorType", model.OperatorType);
parms[6] = SqlHelper.GetParameter("@CompanyCD", model.CompanyCD);
parms[7] = SqlHelper.GetParameter("@ID", model.ID);
SqlHelper.ExecuteTransSql(strSql.ToString(), parms);
return SqlHelper.Result.OprateCount > 0 ? true : false;
}
/// <summary>
/// 修改现金流量表计算公式
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool UpdateCashFlowFormulaDetails(CashFlowFormulaDetailsModel model)
{
try
{
return CashFlowFormulaDetailsDBHelper.UpdateCashFlowFormulaDetails(model);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 添加现金流量表公式明细
/// </summary>
/// <param name="model"></param>
/// <param name="IntID"></param>
/// <returns></returns>
public static bool InsertCashFlowFormulaDetails(CashFlowFormulaDetailsModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.AppendLine("insert into officedba.CashFlowFormulaDetails(");
strSql.AppendLine("FormulaID,SubjectsCD,SubjectsName,Operator,CompanyCD,Direction,OperatorType)");
strSql.AppendLine(" values (");
strSql.AppendLine("@FormulaID,@SubjectsCD,@SubjectsName,@Operator,@CompanyCD,@Direction,@OperatorType)");
SqlParameter[] parms = new SqlParameter[7];
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("@CompanyCD", model.CompanyCD);
parms[5] = SqlHelper.GetParameter("@Direction", model.Direction);
parms[6] = SqlHelper.GetParameter("@OperatorType", model.OperatorType);
SqlHelper.ExecuteTransSql(strSql.ToString(), parms);
return SqlHelper.Result.OprateCount > 0 ? true : false;
}
