/// <summary> /// 添加科目核算类别 /// </summary> /// <param name="CompanyCD">公司编码</param> /// <param name="Name">核算名称</param> /// <param name="UsedStatus">使用状态</param> /// <returns>true 成功,false 失败</returns> public static bool InsertAssistantType(string Name, string UsedStatus) { UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; try { bool succ = false; string loginUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID; LogInfoModel logModel = InitLogInfo(Name); logModel.Element = ConstUtil.LOG_PROCESS_INSERT; succ = AssistantTypeDBHelper.InsertAssistantType(CompanyCD, 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; } }
/// <summary> /// 获取科目核算类别 /// </summary> /// <param name="CompanyCD">公司编码</param> /// <returns>DataTable</returns> public static DataTable GetAssistantType(string Name, string UsedStatus) { string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; if (string.IsNullOrEmpty(CompanyCD)) { return(null); } try { DataTable dt = AssistantTypeDBHelper.GetAssistantType(CompanyCD, Name, UsedStatus); 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; } }
/// <summary> /// 删除科目核算类别 /// </summary> /// <param name="CompanyCD">公司编码</param> /// <param name="ID">主键</param> /// <returns>true 成功,false 失败</returns> public static bool DelAssistantType(string ID) { bool isSucc = false; UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; if (string.IsNullOrEmpty(ID) && string.IsNullOrEmpty(CompanyCD)) { return(false); } try { isSucc = AssistantTypeDBHelper.DelAssistantType(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; } }
public static bool NameIsExist(string Name) { string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; try { return(AssistantTypeDBHelper.NameIsExist(CompanyCD, Name)); } catch (Exception ex) { throw ex; } }