/// <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 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> public static bool AddRYJSFP(JsgnfpModel jsfp, string ghj, out string errmsg) { bool isSuc = false; errmsg = string.Empty; ParamConvert pc = new ParamConvert(); pc.Basic(false); pc.Add("p_dwbm", jsfp.DWBM); pc.Add("p_bmbm", jsfp.BMBM); pc.Add("p_jsbm", jsfp.JSBM); pc.Add("p_ghj", ghj); try { isSuc = pc.DoExecuteNonQuery("pkg_zzjg_manage.proc_add_ryjsfp"); errmsg = Convert.ToString(pc.GetValueByKey("p_errmsg")); } catch (Exception e) { errmsg += e.Message; } return(isSuc); }
/// <summary> /// 修改功能参数信息 /// </summary> public static bool UpdateGNCS(JsgnfpModel gnfp, out string errmsg) { bool isSuc = false; errmsg = string.Empty; ParamConvert pc = new ParamConvert(); pc.Basic(false); pc.Add("p_dwbm", gnfp.DWBM); pc.Add("p_jsbm", gnfp.JSBM); pc.Add("p_gnbm", gnfp.GNBM); pc.Add("p_bmbm", gnfp.BMBM); pc.Add("p_gncs", string.IsNullOrEmpty(gnfp.GNCS) ? (object)DBNull.Value : gnfp.GNCS); try { isSuc = pc.DoExecuteNonQuery("pkg_zzjg_manage.proc_update_gncs"); errmsg = Convert.ToString(pc.GetValueByKey("p_errmsg")); } catch (Exception e) { errmsg += e.Message; } return(isSuc); }