/// <summary>
/// 新增报表项目信息
/// </summary>
/// <param name="Model">实体</param>
/// <returns>true 成功，false失败</returns>
public static bool InsertReportItem(ReportItemSettingModel Model)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("Insert into officedba.ReportItemSetting (CompanyCD,");
sql.AppendLine("ItemType,ItemRow,ItemName,UsedStatus)");
sql.AppendLine("values(@CompanyCD,@ItemType,@ItemRow,@ItemName,@UsedStatus)");
SqlParameter [] parms = new SqlParameter[5];
parms[0] = SqlHelper.GetParameter("@CompanyCD", Model.CompanyCD);
parms[1] = SqlHelper.GetParameter("@ItemType", Model.ItemType);
parms[2] = SqlHelper.GetParameter("@ItemRow", Model.ItemRow);
parms[3] = SqlHelper.GetParameter("@ItemName", Model.ItemName);
parms[4] = SqlHelper.GetParameter("@UsedStatus", Model.UsedStatus);
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 UpdateReportItem(ReportItemSettingModel Model)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("Update officedba.ReportItemSetting set ItemType=@ItemType ,");
sql.AppendLine("ItemRow=@ItemRow,ItemName=@ItemName,UsedStatus=@UsedStatus");
sql.AppendLine("where CompanyCD=@CompanyCD and ID=@ID");
SqlParameter[] parms = new SqlParameter[6];
parms[0] = SqlHelper.GetParameter("@CompanyCD", Model.CompanyCD);
parms[1] = SqlHelper.GetParameter("@ItemType", Model.ItemType);
parms[2] = SqlHelper.GetParameter("@ItemRow", Model.ItemRow);
parms[3] = SqlHelper.GetParameter("@ItemName", Model.ItemName);
parms[4] = SqlHelper.GetParameter("@UsedStatus", Model.UsedStatus);
parms[5] = 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 UpdateReportItem(ReportItemSettingModel Model)
{
if (Model == null)
{
return(false);
}
if (Model.CompanyCD == null)
{
Model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
}
try
{
return(ReportItemSettingDBHelper.UpdateReportItem(Model));
}
catch (Exception ex)
{
throw ex;
}
}
