/// <summary> /// 获取会计科目信息 /// </summary> /// <param name="CompanyCD">公司编码</param> /// <returns>DataTable</returns> public static DataTable GetAccountSubjects() { string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; try { DataTable dt = AccountSubjectsDBHelper.GetAccountSubjects(CompanyCD); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow rows in dt.Rows) { if (rows["BlanceDire"].ToString() == ConstUtil.SUBJECTS_DIRE_J_CODE) { rows["BlanceDire"] = ConstUtil.SUBJECTS_DIRE_J_NAME; } else if (rows["BlanceDire"].ToString() == ConstUtil.SUBJECTS_DIRE_D_CODE) { rows["BlanceDire"] = ConstUtil.SUBJECTS_DIRE_D_NAME; } } } return(dt); } catch (Exception ex) { throw ex; } }
/// <summary> /// 根据科目类别获取科目信息 /// </summary> /// <param name="TypeID">科目类别</param> /// <returns>DataTable</returns> public static DataTable GetSubjectsByTypeID(string TypeID, string ParentID) { string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; if (string.IsNullOrEmpty(CompanyCD) && string.IsNullOrEmpty(TypeID)) { return(null); } DataTable dt = new DataTable(); try { dt = AccountSubjectsDBHelper.GetSubjectsByTypeID(CompanyCD, TypeID, ParentID); } catch (Exception ex) { //定义变量 LogInfo logSys = new LogInfo(); //设置日志类型 需要指定为系统日志 logSys.Type = LogInfo.LogType.SYSTEM; //指定系统日志类型 出错信息 logSys.SystemKind = LogInfo.SystemLogKind.SYSTEM_ERROR; //指定登陆用户信息 // logSys.UserInfo = UserInfo; //设定模块ID // logSys.ModuleID = ConstUtil.MODULE_ID_HUMAN_EMPLOYEE_ADD; //描述 logSys.Description = ex.ToString(); //输出日志 LogUtil.WriteLog(logSys); } return(dt); }
public static DataTable GetSubjectsInfoByCD(string SubjectsCD) { string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; try { return(AccountSubjectsDBHelper.GetSubjectsInfo(CompanyCD, SubjectsCD)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 判断科目编码是否存在 /// </summary> /// <param name="SubjectsCD">科目编码</param> /// <returns>true 是,false 否</returns> public static bool SubjectsCDIsExist(string SubjectsCD) { string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; try { return(AccountSubjectsDBHelper.SubjectsCDIsExist(CompanyCD, SubjectsCD)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 判断该结点下,是否还有子结点 /// </summary> /// <param name="ParentCode">上级编码</param> /// <returns>大于0还有子节点,否则无子节点</returns> public static int ChildrenCount(string ParentCode) { string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; try { return(AccountSubjectsDBHelper.ChildrenCount(ParentCode, CompanyCD)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 根据企业编码获取科目信息 /// </summary> /// <param name="CompanyCD">企业编码</param> /// <returns>DataTable</returns> public static DataTable GetSubjectsInfo(string ParentID) { string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; if (string.IsNullOrEmpty(CompanyCD) && string.IsNullOrEmpty(ParentID)) { return(null); } try { return(AccountSubjectsDBHelper.GetASubjectsByCompanyCD(CompanyCD, ParentID)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 根据科目编码模糊查询科目 /// </summary> /// <param name="SubjectsCD">科目编码</param> /// <returns>DataTable</returns> public static DataTable QuerySubjectsBySubjectsCD(string SubjectsCD) { string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; if (string.IsNullOrEmpty(CompanyCD) && string.IsNullOrEmpty(SubjectsCD)) { return(null); } try { return(AccountSubjectsDBHelper.QuerySubjectsBySubjectsCD(CompanyCD, SubjectsCD)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 更新科目期初值 /// </summary> /// <param name="Model">科目实体</param> /// <returns>True 成功,false失败</returns> public static bool UpdateBeginMoney(AccountSubjectsModel Model) { UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; if (Model == null) { return(false); } if (Model.CompanyCD == null) { Model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; } try { return(AccountSubjectsDBHelper.UpdateBeginMoney(Model)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 修改会计科目信息 /// </summary> /// <param name="Model">科目实体</param> /// <returns>True 成功,false失败</returns> public static bool UpdateAccountSubjects(AccountSubjectsModel 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.SubjectsCD); logModel.Element = ConstUtil.LOG_PROCESS_UPDATE; succ = AccountSubjectsDBHelper.UpdateAccountSubjects(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; } }
/// <summary> /// 删除会计科目 /// </summary> /// <param name="ID">主键编码</param> /// <param name="CompanyCD">公司编码</param> /// <returns>True 成功,false失败</returns> public static string DeleteAccountSubjects(string ID, string SubjectsCode, string CompanyCD) { try { bool isSucc = false; UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; string[] sql = null; //sql语句数组 string Execresult = ""; //执行结果 DataTable dt = AccountSubjectsDBHelper.GetAccountsByID(CompanyCD, ID); if (dt != null && dt.Rows.Count > 0) { if (dt.Rows[0]["UsedStatus"].ToString().Trim() == ConstUtil.USED_STATUS_ON) { Execresult = ConstUtil.USED_STATUS_ON; } else { //查找当前科目是否有子节点 int count = AccountSubjectsDBHelper.ChildrenCount(SubjectsCode, CompanyCD); if (count > 0) { sql = new string[2]; sql[0] = "delete from officedba.AccountSubjects where CompanyCD='" + CompanyCD + "' and ID='" + ID + "'"; sql[1] = "delete from officedba.AccountSubjects where CompanyCD='" + CompanyCD + "' and ParentID='" + SubjectsCode + "'"; } else { sql = new string[1]; sql[0] = "delete from officedba.AccountSubjects where CompanyCD='" + CompanyCD + "' and ID='" + ID + "'"; } Execresult = AccountSubjectsDBHelper.DelAccountSubjects(sql) == true ? ConstUtil.EXEC_RESULT_SUCCESS_NAME : ConstUtil.EXEC_RESULT_FAIL_NAME; if (Execresult == ConstUtil.EXEC_RESULT_SUCCESS_NAME) { isSucc = true; } //定义变量 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(Execresult); } catch (Exception ex) { throw ex; } }