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