/// <summary> /// 获取角色功能分配信息 /// </summary> public static DataTable GetJsGnfp(JsgnfpModel jsfp, out string err) { DataTable dt = null; err = string.Empty; ParamConvert pc = new ParamConvert(); pc.Basic(false); pc.Add("p_dwbm", jsfp.DWBM); pc.Add("p_jsbm", jsfp.JSBM); pc.Add("p_bmbm", jsfp.BMBM); try { dt = pc.DoExecuteDataTable("pkg_zzjg_manage.proc_get_gninfo"); dt.Columns.Add("icon"); foreach (DataRow dr in dt.Rows) { if (string.IsNullOrEmpty(dr["FBM"].ToString())) { dr["icon"] = "picon"; } else { dr["icon"] = "chicon"; } } err = Convert.ToString(pc.GetValueByKey("p_errmsg")); } catch (Exception e) { err += e.Message; } return(dt); }
/// <summary> /// 获取获取未分配人员信息 /// </summary> public static DataTable GetWfpRyInfo(string dwbm, string gh, string xm, string jsbm, string bmbm, int pagesize, int pageindex, out int count, out string err) { DataTable dt = null; count = 0; err = string.Empty; ParamConvert pc = new ParamConvert(); pc.Basic(false); pc.Add("p_dwbm", dwbm); pc.Add("p_gh", gh); pc.Add("p_xm", xm); pc.Add("p_jsbm", jsbm); pc.Add("p_bmbm", bmbm); pc.Add("p_pagesize", pagesize); pc.Add("p_pageindex", pageindex); pc.Add("p_count", count); try { dt = pc.DoExecuteDataTable("pkg_zzjg_manage.proc_get_wfpryinfo"); count = Convert.ToInt32(pc.GetValueByKey("p_count")); err = Convert.ToString(pc.GetValueByKey("p_errmsg")); } catch (Exception e) { err += e.Message; } return(dt); }
/// <summary> /// 查询该单位下的功能权限 /// </summary> public static DataTable QueryGnQx(string dwbm, string gnbm, string gnmc, string sslb, int pagesize, int pageindex, out int count, out string errmsg) { errmsg = string.Empty; count = 0; DataTable dt = null; ParamConvert pc = new ParamConvert(); pc.Basic(false); pc.Add("p_dwbm", dwbm); pc.Add("p_gnbm", gnbm); pc.Add("p_gnmc", gnmc); pc.Add("p_sslb", sslb); pc.Add("p_pagesize", pagesize); pc.Add("p_pageindex", pageindex); pc.Add("p_count", count); try { dt = pc.DoExecuteDataTable("pkg_zzjg_manage.proc_get_gnqx"); errmsg += Convert.ToString(pc.GetValueByKey("p_errmsg")); count = Convert.ToInt32(pc.GetValueByKey("p_count")); } catch (Exception e) { errmsg += e.Message; } return(dt); }
/// <summary> /// 获取角色序号 /// </summary> public static DataTable GetJsxh(string dwbm, string bmbm, string jsbm, out string errmsg) { errmsg = string.Empty; int jsxh = -1; ParamConvert pc = new ParamConvert(); pc.Basic(false); pc.Add("p_dwbm", dwbm); pc.Add("p_bmbm", bmbm); pc.Add("p_jsbm", jsbm); try { DataTable dt = pc.DoExecuteDataTable("pkg_zzjg_manage.proc_get_jsxh"); errmsg = Convert.ToString(pc.GetValueByKey("p_errmsg")); //if (dt != null && string.IsNullOrEmpty(errmsg)) //{ // jsxh = Convert.ToInt32(dt.Rows[0][0].ToString()); //} return(dt); } catch (Exception ex) { errmsg += ex.Message; } return(null); }
/// <summary> /// 查询监督案件(检察院查询由公安反馈回来的案件) /// </summary> public static DataTable GetCaseListForBack(JdAjModel param, out string strErr) { DataTable dt = null; strErr = string.Empty; ParamConvert pc = new ParamConvert(); pc.Basic(false); pc.Add("p_dwbm", param.CBDW_BM); pc.Add("p_ajmc", param.AJMC); pc.Add("p_cjrgh", param.CJRGH); pc.Add("p_dtbegin", param.dtPbBeg); pc.Add("p_dtend", param.dtPbEnd); pc.Add("p_pagesize", param.PageSize); pc.Add("p_pageindex", param.PageIndex); pc.Add("p_count", param.Count); try { dt = pc.DoExecuteDataTable("pkg_case_manage.proc_get_jdajforback"); param.Count = Convert.ToInt32(pc.GetValueByKey("p_count")); } catch (Exception e) { strErr = e.Message; } return(dt); }
/// <summary> /// 获取角色权限信息 /// </summary> public static DataTable GetJsQx(string dwbm, string bmbm, string jsbm, int pagesize, int pageindex, out int count, out string errmsg) { count = 0; errmsg = string.Empty; DataTable dt = null; ParamConvert pc = new ParamConvert(); pc.Basic(false); pc.Add("p_dwbm", dwbm); pc.Add("p_bmbm", bmbm); pc.Add("p_jsbm", jsbm); pc.Add("p_pagesize", pagesize); pc.Add("p_pageindex", pageindex); pc.Add("p_count", count); try { dt = pc.DoExecuteDataTable("pkg_zzjg_manage.proc_get_jsqx"); errmsg = Convert.ToString(pc.GetValueByKey("p_errmsg")); count = Convert.ToInt32(pc.GetValueByKey("p_count").ToString()); } catch (Exception e) { errmsg += e.Message; } return(dt); }
/// <summary> /// 获取案由 /// </summary> /// <param name="strErr"></param> /// <returns></returns> public static DataTable GetAy(out string strErr) { strErr = string.Empty; DataTable dt = new DataTable(); ParamConvert pc = new ParamConvert(); pc.Basic(true); try { dt = pc.DoExecuteDataTable("pkg_fldm_manage.proc_get_sjzdbygd"); } catch (Exception ex) { strErr = ex.Message; } return(dt); }
/// <summary> /// 获取侦办单位 /// </summary> /// <param name="dwbm"></param> /// <param name="strErr"></param> /// <returns></returns> public static DataTable GetZbdwByCbdw(string dwbm, out string strErr) { strErr = string.Empty; DataTable dt = new DataTable(); ParamConvert pc = new ParamConvert(); pc.Basic(true); pc.Add("p_dwbm", dwbm); try { dt = pc.DoExecuteDataTable("pkg_zzjg_manage.proc_get_gxzdw"); } catch (Exception ex) { strErr = ex.Message; } return(dt); }
/// <summary> /// 获取考评指标分类 /// </summary> /// <param name="strErr"></param> /// <returns></returns> public static DataTable GetKpzbfl(out string strErr) { strErr = string.Empty; DataTable dt = new DataTable(); ParamConvert pc = new ParamConvert(); pc.Basic(true); try { dt = pc.DoExecuteDataTable("pkg_ht_manage.proc_get_kpzbfl"); strErr = pc.Errmsg; } catch (Exception ex) { strErr = ex.Message; } return(dt); }
/// <summary> /// 获取功能分类 /// </summary> public static DataTable GetGnfl(string dwbm, out string errmsg) { errmsg = string.Empty; DataTable dt = null; ParamConvert pc = new ParamConvert(); pc.Basic(false); pc.Add("p_dwbm", dwbm); try { dt = pc.DoExecuteDataTable("pkg_zzjg_manage.proc_get_gnfl"); errmsg += Convert.ToString(pc.GetValueByKey("p_errmsg")); } catch (Exception e) { errmsg += e.Message; } return(dt); }
/// <summary> /// 获取人员信息 /// </summary> public static DataTable GetRyInfo(ParamRyFilter param, out string err) { DataTable dt = null; err = string.Empty; ParamConvert pc = new ParamConvert(); pc.ConvertParam <ParamRyFilter>(param); try { dt = pc.DoExecuteDataTable("pkg_zzjg_manage.proc_get_ryinfobydwbm"); param.Count = Convert.ToInt32(pc.GetValueByKey("p_count")); } catch (Exception e) { err = e.Message; } return(dt); }
/// <summary> /// 查询监督案件 /// </summary> /// <param name="param"></param> /// <param name="strErr"></param> /// <returns></returns> public static DataTable GetCaseList(JdAjModel param, out string strErr) { DataTable dt = null; strErr = string.Empty; ParamConvert pc = new ParamConvert(); pc.ConvertParam <JdAjModel>(param); try { dt = pc.DoExecuteDataTable("pkg_case_manage.proc_get_jdaj"); param.Count = Convert.ToInt32(pc.GetValueByKey("p_count")); } catch (Exception e) { strErr = e.Message; } return(dt); }
/// <summary> /// 查询考评指标分类 /// </summary> public static DataTable GetAjKpzbfl(string ajbh, out string strErr) { DataTable dt = null; strErr = string.Empty; ParamConvert pc = new ParamConvert(); pc.Basic(true); pc.Add("p_ajbh", ajbh); try { dt = pc.DoExecuteDataTable("pkg_case_manage.proc_get_zbflbyajbm"); } catch (Exception ex) { strErr = ex.Message; } return(dt); }
/// <summary> /// 获取该单位下的所有部门名称 /// </summary> public static DataTable GetBmInfoByDwBm(string dwbm, out string err) { err = string.Empty; DataTable dt = null; ParamConvert pc = new ParamConvert(); pc.Basic(true); pc.Add("p_dwbm", dwbm); try { dt = pc.DoExecuteDataTable("pkg_zzjg_manage.proc_get_bminfobydwbm"); err = Convert.ToString(pc.GetValueByKey("p_errmsg")); } catch (Exception e) { err += e.Message; } return(dt); }
/// <summary> /// 获取通知书或反馈书 /// </summary> /// <param name="ajbh">案件编号</param> /// <param name="tzfk">通知/反馈</param> /// <param name="errmsg"></param> /// <returns></returns> public static DataTable GetDocInfo(string ajbh, string tzfk, out string errmsg) { errmsg = string.Empty; DataTable dt = null; ParamConvert pc = new ParamConvert(); pc.Basic(true); pc.Add("p_ajbh", ajbh); pc.Add("p_tzfk", tzfk); try { dt = pc.DoExecuteDataTable("PKG_DOC_MANAGE.proc_get_docinfo"); errmsg += Convert.ToString(pc.GetValueByKey("p_errmsg")); } catch (Exception e) { errmsg += e.Message; } return(dt); }
/// <summary> /// 查询类别 /// </summary> public static DataTable GetSslb(out string errmsg) { DataTable dt = null; errmsg = string.Empty; ParamConvert pc = new ParamConvert(); pc.Basic(false); try { dt = pc.DoExecuteDataTable("pkg_fldm_manage.proc_get_sslb"); errmsg = Convert.ToString(pc.GetValueByKey("p_errmsg")); } catch (Exception e) { errmsg += e.Message; } return(dt); }
public static DataTable GetFileList(string ajbh, string fwjbh, out string errmsg) { errmsg = string.Empty; DataTable dt = null; ParamConvert pc = new ParamConvert(); pc.Basic(true); pc.Add("p_ajbh", ajbh); pc.Add("p_fwsbh", fwjbh); try { dt = pc.DoExecuteDataTable("PKG_DOC_MANAGE.proc_get_filelist"); errmsg += Convert.ToString(pc.GetValueByKey("p_errmsg")); } catch (Exception e) { errmsg += e.Message; } return(dt); }
/// <summary> /// 根据人员工号,获取人员对于功能 /// </summary> public static DataTable GetGnByRy(string dwbm, string rygh, out string err) { err = string.Empty; DataTable dt = new DataTable(); ParamConvert pc = new ParamConvert(); pc.Basic(true); pc.Add("p_dwbm", dwbm); pc.Add("p_rygh", rygh); try { dt = pc.DoExecuteDataTable("pkg_zzjg_manage.proc_get_gnbyry"); err = Convert.ToString(pc.GetValueByKey("p_errmsg")); } catch (Exception ex) { err = ex.Message; } return(dt); }
/// <summary> /// 获取部门考评案件数量 /// </summary> public static DataTable GetBmAjCount(JdAjModel param, out string strErr) { DataTable dt = null; strErr = string.Empty; ParamConvert pc = new ParamConvert(); pc.Basic(false); pc.Add("p_dwbm", param.CBDW_BM); pc.Add("p_dtbegin", param.dtPbBeg); pc.Add("p_dtend", param.dtPbEnd); try { dt = pc.DoExecuteDataTable("pkg_case_manage.proc_get_bmajcount"); } catch (Exception e) { strErr = e.Message; } return(dt); }
/// <summary> /// 获取通知书或反馈书 /// </summary> /// <param name="ajbh">案件编号</param> /// <param name="tzfk">通知/反馈</param> /// <param name="errmsg"></param> /// <returns></returns> public static DataTable GetTagData(string dwbm, string ajbh, string wsmbbh, out string errmsg) { errmsg = string.Empty; DataTable dt = null; ParamConvert pc = new ParamConvert(); pc.Basic(true); pc.Add("p_dwbm", dwbm); pc.Add("p_ajbh", ajbh); pc.Add("p_wsmbbh", wsmbbh); try { dt = pc.DoExecuteDataTable("PKG_DOC_TAGFUNC.proc_gettagdata"); errmsg += Convert.ToString(pc.GetValueByKey("p_errmsg")); } catch (Exception e) { errmsg += e.Message; } return(dt); }
/// <summary> /// 登录 /// </summary> /// <returns></returns> public static DataTable Login(string dwbm, string user, string passwd, out string errmsg) { DataTable dt = null; errmsg = string.Empty; ParamConvert pc = new ParamConvert(); pc.Basic(true); pc.Add("p_dwbm", dwbm); pc.Add("p_user", user); passwd = MD5Encrypt.getMd5Hash(passwd); pc.Add("p_passwd", passwd); try { dt = pc.DoExecuteDataTable("pkg_zzjg_manage.proc_login"); } catch (Exception e) { errmsg = e.Message; } return(dt); }
/// <summary> /// 获取该用户的角色信息 /// </summary> public static DataTable GetYhJsInfo(JsgnfpModel js, out string err) { DataTable dt = null; err = string.Empty; ParamConvert pc = new ParamConvert(); pc.Basic(false); pc.Add("p_dwbm", js.DWBM); pc.Add("p_gh", js.GH); try { dt = pc.DoExecuteDataTable("pkg_zzjg_manage.proc_get_ryjs"); err = Convert.ToString(pc.GetValueByKey("p_errmsg")); } catch (Exception e) { err += e.Message; } return(dt); }
/// <summary> /// 获取文书模板信息 /// </summary> /// <param name="wsmbbh"></param> /// <param name="errmsg"></param> /// <returns></returns> public static DocTemplateModel GetDocmbInfo(string wsmbbh, out string errmsg) { errmsg = string.Empty; DocTemplateModel docInfo = null; DataTable dt = null; ParamConvert pc = new ParamConvert(); pc.Basic(true); pc.Add("p_wsmbbh", wsmbbh); try { dt = pc.DoExecuteDataTable("PKG_DOC_MANAGE.proc_get_mbifo"); errmsg += Convert.ToString(pc.GetValueByKey("p_errmsg")); } catch (Exception e) { errmsg += e.Message; } if (string.IsNullOrEmpty(errmsg) && dt != null && dt.Rows.Count == 1) { docInfo = ModelHandler.FillModel <DocTemplateModel>(dt.Rows[0]); } return(docInfo); }