/// <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);
}
