/// <summary>
/// 更新预警信息
/// </summary>
/// <param name="Model">预警实体</param>
/// <returns>true 成功,false 失败</returns>
public static bool UpdateWarningInfo(FinanceWarningModel Model)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("update officedba.FinanceWarning set ");
sql.AppendLine("[WarningItem] =@WarningItem,");
sql.AppendLine("[UpLimit] =@UpLimit,");
sql.AppendLine("[Lowerlimit] =@Lowerlimit,");
sql.AppendLine("[WarningPersonID] =@WarningPersonID,");
sql.AppendLine("[UsedStatus] = @UsedStatus,");
sql.AppendLine("[WarningWay] = @WarningWay,");
sql.AppendLine("[Remark] = @Remark ");
sql.AppendLine("where CompanyCD=@CompanyCD");
sql.AppendLine("and ID=@ID");
SqlParameter[]parms=new SqlParameter[9];
parms[0] = SqlHelper.GetParameter("@WarningItem", Model.WarningItem);
parms[1] = SqlHelper.GetParameter("@UpLimit", Model.UpLimit);
parms[2] = SqlHelper.GetParameter("@Lowerlimit", Model.Lowerlimit);
parms[3] = SqlHelper.GetParameter("@WarningPersonID", Model.WarningPersonID);
parms[4] = SqlHelper.GetParameter("@UsedStatus", Model.UsedStatus);
parms[5] = SqlHelper.GetParameter("@WarningWay", Model.WarningWay);
parms[6] = SqlHelper.GetParameter("@Remark", Model.Remark);
parms[7] = SqlHelper.GetParameter("@CompanyCD", Model.CompanyCD);
parms[8] = SqlHelper.GetParameter("@ID", Model.ID);
SqlHelper.ExecuteTransSql(sql.ToString(), parms);
return SqlHelper.Result.OprateCount > 0 ? true : false;
}
/// <summary>
/// 更新预警信息
/// </summary>
/// <param name="Model">预警实体</param>
/// <returns>true 成功,false 失败</returns>
public static bool UpdateWarningInfo(FinanceWarningModel Model)
{
if (Model == null) return false;
//Model.CompanyCD = "1001";
if (Model.CompanyCD == null) Model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
try
{
return FinanceWarningDBHelper.UpdateWarningInfo(Model);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 添加预警信息
/// </summary>
/// <param name="Model">预警实体</param>
/// <returns>true 成功,false 失败</returns>
public static bool InsertWarningInfo(FinanceWarningModel Model)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("INSERT INTO officedba.FinanceWarning( ");
sql.AppendLine("[CompanyCD] ,[WarningItem] ,");
sql.AppendLine("[UpLimit] ,[Lowerlimit] ,[WarningPersonID] ,");
sql.AppendLine("[UsedStatus] ,[WarningWay] ,[Remark] )");
sql.AppendLine(" VALUES (@CompanyCD,@WarningItem,");
sql.AppendLine("@UpLimit,@Lowerlimit,@WarningPersonID,@UsedStatus,");
sql.AppendLine("@WarningWay,@Remark)");
SqlParameter []parms=new SqlParameter[8];
parms[0] = SqlHelper.GetParameter("@CompanyCD",Model.CompanyCD);
parms[1] = SqlHelper.GetParameter("@WarningItem",Model.WarningItem);
parms[2] = SqlHelper.GetParameter("@UpLimit",Model.UpLimit);
parms[3] = SqlHelper.GetParameter("@Lowerlimit",Model.Lowerlimit);
parms[4] = SqlHelper.GetParameter("@WarningPersonID",Model.WarningPersonID);
parms[5] = SqlHelper.GetParameter("@UsedStatus",Model.UsedStatus);
parms[6] = SqlHelper.GetParameter("@WarningWay",Model.WarningWay);
parms[7] = SqlHelper.GetParameter("@Remark",Model.Remark);
SqlHelper.ExecuteTransSql(sql.ToString(), parms);
return SqlHelper.Result.OprateCount > 0 ? true : false;
}
