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