/// <summary> /// 校验编号的唯一性 /// </summary> /// <param name="tableName">表名</param> /// <param name="columnName">列名</param> /// <param name="codeValue">输入的编码值</param> /// <returns>bool 是否已经存在 true 不存在 false 存在</returns> public static bool CheckCodeUniq(string tableName, string CodeName, string Flag) { string companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; //校验存在性 return(CodeReasonFeeDBHelper.CheckCodeUniq(tableName, companyCD, CodeName, Flag)); }
/// <summary> /// 修改文档种类信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool UpdateThreeCodeInfo(CodeReasonFeeModel model, string TableName) { UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; if (model == null) { return(false); } //登陆日志 try { bool succ = false; LogInfoModel logModel = InitLogInfo(model.CodeName, TableName); logModel.Element = ConstUtil.LOG_PROCESS_UPDATE; succ = CodeReasonFeeDBHelper.UpdateThreeCodeInfo(model, TableName); 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, TableName); return(false); } }
/// <summary> /// 删除文档分类 /// </summary> /// <param name="id"></param> /// <returns></returns> public static bool DeleteThreeCodeType(string id, string TableName) { if (string.IsNullOrEmpty(id)) { return(false); } UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //string CompanyCD = "AAAAAA"; bool isSucc = CodeReasonFeeDBHelper.DeleteThreeCodeType(id, TableName); //定义变量 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); string name = ""; //操作日志 switch (TableName) { case "officedba.CodeReasonType": name = "原因ID:"; break; case "officedba.CodeFeeType": name = "费用ID:"; break; case "officedba.CodeUnitType": name = "计量单位ID:"; break; } LogInfoModel logModel = InitLogInfo(name + no, TableName); //涉及关键元素 这个需要根据每个页面具体设置,本页面暂时设置为空 logModel.Element = ConstUtil.LOG_PROCESS_DELETE; //设置操作成功标识 logModel.Remark = remark; //登陆日志 LogDBHelper.InsertLog(logModel); } return(isSucc); }
public static DataTable GetCodeUnitType() { try { UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; string CompanyCD = userInfo.CompanyCD; return(CodeReasonFeeDBHelper.GetCodeUnitType(CompanyCD)); } catch { return(null); throw; } }
/// <summary> /// 根据id获取文档种类 /// </summary> /// <param name="id"></param> /// <returns></returns> public static CodeReasonFeeModel GetThreeCodeById(int id, string TableName) { if (id == 0) { return(null); } try { return(CodeReasonFeeDBHelper.GetThreeCodeById(id, TableName)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 获取文档分类 /// </summary> /// <param name="CompanyCD"></param> /// <returns></returns> public static DataTable GetThreeCodeType(string CompanyCD, string SubNo, string TableName, string UsedStatus, string Name, string Flag) { if (string.IsNullOrEmpty(CompanyCD)) { return(null); } try { return(CodeReasonFeeDBHelper.GetThreeCodeType(CompanyCD, SubNo, TableName, UsedStatus, Name, Flag)); } catch { return(null); throw; } }
/// <summary> /// 判断费用表是否已经使用这个费用分类了 /// </summary> /// <param name="ID"></param> /// <returns></returns> public static bool ChargeFee(string ID) { return(CodeReasonFeeDBHelper.ChargeFee(ID)); }