/// <summary> /// 获取摘要信息 /// </summary> /// <param name="CompanyCD">公司编码</param> /// <returns>DataTable</returns> public static DataTable GetSummaryInfo(string TypeID, string isUsed) { string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; if (string.IsNullOrEmpty(CompanyCD)) { return(null); } try { DataTable dt = SummarySettingDBHelper.GetSummaryByCompanyCD(CompanyCD, TypeID, isUsed); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow rows in dt.Rows) { if (rows["UsedStatus"].ToString() == ConstUtil.USED_STATUS_OFF) { rows["UsedStatus"] = ConstUtil.USED_STATUS_OFF_NAME; } else if (rows["UsedStatus"].ToString() == ConstUtil.USED_STATUS_ON) { rows["UsedStatus"] = ConstUtil.USED_STATUS_ON_NAME; } } } return(dt); } catch (Exception ex) { throw ex; } }
public static string GetSummaryIDByName(string SummaryName) { try { return(SummarySettingDBHelper.GetSummaryIDByName(SummaryName)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 删除摘要信息 /// </summary> /// <param name="SummaryCD">摘要编码</param> /// <param name="CompanyCD">公司编码</param> /// <returns>true 成功,false失败</returns> public static bool DelSummary(string SummaryCD) { bool isSucc = false; UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; if (string.IsNullOrEmpty(SummaryCD) && string.IsNullOrEmpty(CompanyCD)) { return(false); } try { isSucc = SummarySettingDBHelper.DelSummary(SummaryCD, CompanyCD); //定义变量 string remark; //成功时 if (isSucc) { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_SUCCESS; } else { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_FAILED; } string[] noList = SummaryCD.Split(','); for (int i = 0; i < noList.Length; i++) { //获取编号 string no = noList[i]; //替换两边的 ' no = no.Replace("'", string.Empty); //操作日志 LogInfoModel logModel = InitLogInfo(no); //涉及关键元素 这个需要根据每个页面具体设置,本页面暂时设置为空 logModel.Element = ConstUtil.LOG_PROCESS_DELETE; //设置操作成功标识 logModel.Remark = remark; //登陆日志 LogDBHelper.InsertLog(logModel); } return(isSucc); } catch (Exception ex) { WriteSystemLog(userInfo, ex); throw ex; } }
/// <summary> /// 修改摘要信息 /// </summary> /// <param name="Model">实体</param> /// <returns>true 成功,false失败</returns> public static bool UpdateSummary(SummarySettingModel Model) { UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; if (Model == null) { return(false); } if (Model.CompanyCD == null) { Model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; } try { bool succ = false; string loginUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID; LogInfoModel logModel = InitLogInfo(Model.SummaryCD.ToString()); logModel.Element = ConstUtil.LOG_PROCESS_UPDATE; succ = SummarySettingDBHelper.UpdateSummary(Model); if (!succ) { logModel.Remark = ConstUtil.LOG_PROCESS_FAILED; } else { logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS; } LogDBHelper.InsertLog(logModel); return(succ); } catch (Exception ex) { WriteSystemLog(userInfo, ex); throw ex; } }