public static DataTable GetSummaryTypeByCD() { string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; if (string.IsNullOrEmpty(CompanyCD)) { return(null); } try { DataTable dt = SummaryTypeDBHelper.GetSummaryTypeByCD(CompanyCD); 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 bool UpdateSummaryType(int ID, string Name, string UsedStatus) { string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; try { bool succ = false; string loginUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID; LogInfoModel logModel = InitLogInfo(ID.ToString()); logModel.Element = ConstUtil.LOG_PROCESS_UPDATE; succ = SummaryTypeDBHelper.UpdateSummaryType(CompanyCD, ID, Name, UsedStatus); 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; } }
public string GetSummaryTypeName(int id) { try { return(SummaryTypeDBHelper.GetSummaryTypeName(id)); } catch (Exception ex) { throw ex; } }
public static bool isSummaryTypeReference(int SummaryTypeID) { try { return(SummaryTypeDBHelper.isSummaryTypeReference(SummaryTypeID)); } catch (Exception ex) { throw ex; } }
public static bool NameIsExist(string Name) { string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; try { return(SummaryTypeDBHelper.NameIsExist(CompanyCD, Name)); } catch (Exception ex) { throw ex; } }
public static bool DelSummaryType(string ID) { bool isSucc = false; UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; try { isSucc = SummaryTypeDBHelper.DelSummaryType(CompanyCD, ID); //定义变量 string remark; //成功时 if (isSucc) { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_SUCCESS; } else { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_FAILED; } string[] noList = ID.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; } }