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