/// <summary>
/// 添加人员信息
/// </summary>
public static bool AddRYInfo(RybmModel ryxx, out string errmsg)
{
bool isSuc = false;
errmsg = string.Empty;
ParamConvert pc = new ParamConvert();
pc.Basic(false);
pc.Add("p_dwbm", ryxx.DWBM);
pc.Add("p_mc", ryxx.MC);
pc.Add("p_dlbm", ryxx.DLBM);
pc.Add("p_gzzh", ryxx.GZZH);
pc.Add("p_xb", ryxx.XB);
pc.Add("p_sflsry", ryxx.SFLSRY);
pc.Add("p_yddhhm", ryxx.YDDHHM);
pc.Add("p_dzyj", ryxx.DZYJ);
pc.Add("p_CAID", ryxx.CAID);
pc.Add("p_sftz", ryxx.SFTZ);
try
{
isSuc = pc.DoExecuteNonQuery("pkg_zzjg_manage.proc_add_ryinfo");
errmsg = Convert.ToString(pc.GetValueByKey("p_errmsg"));
}
catch (Exception e)
{
errmsg += e.Message;
}
return(isSuc);
}
/// <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 bool AddGnQx(string dwbm, int isExistedFlb, string gnfl, string gnbm, string gnmc, string gnct, string gnxsmc,
int gnxh, string gnsm, string cscs, string gjy, string sy, string sjy, string qy, out string errmsg)
{
bool isSuc = false;
errmsg = string.Empty;
ParamConvert pc = new ParamConvert();
pc.Basic(false);
pc.Add("p_dwbm", dwbm);
pc.Add("p_isexistedflb", isExistedFlb);
pc.Add("p_gnfl", gnfl);
pc.Add("p_gnbm", gnbm);
pc.Add("p_gnmc", gnmc);
pc.Add("p_gnct", gnct);
pc.Add("p_gnxsmc", gnxsmc);
pc.Add("p_gnxh", gnxh);
pc.Add("p_gnsm", gnsm);
pc.Add("p_cscs", cscs);
//pc.Add("p_sfgjysy", gjy);
//pc.Add("p_sfsysy", sy);
//pc.Add("p_sfsjysy", sjy);
//pc.Add("p_sfqysy", qy);
try
{
isSuc = pc.DoExecuteNonQuery("pkg_zzjg_manage.proc_add_gnqx");
errmsg += Convert.ToString(pc.GetValueByKey("p_errmsg"));
}
catch (Exception e)
{
errmsg += e.Message;
}
return(isSuc);
}
/// <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 bool AddJsInfo(string dwbm, string bmbm, string jsbm, string jsmc, int jsxh, out string errmsg)
{
errmsg = string.Empty;
bool isSuc = false;
ParamConvert pc = new ParamConvert();
pc.Basic(false);
pc.Add("p_dwbm", dwbm);
pc.Add("p_bmbm", bmbm);
pc.Add("p_jsmc", jsmc);
pc.Add("p_jsxh", jsxh);
pc.Add("p_jsbm", jsbm);
try
{
//pc.DoExecuteDataTable("proc_add_jsinfo");
isSuc = pc.DoExecuteNonQuery("pkg_zzjg_manage.proc_add_jsinfo");
errmsg = Convert.ToString(pc.GetValueByKey("p_errmsg"));
}
catch (Exception e)
{
errmsg += e.Message;
}
return(isSuc);
}
/// <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 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 bool AddBmInfo(string dwbm, string bmbm, string bmmc, string bmjc, int bmxh, string bz, string fbmbm, out string errmsg)
{
bool isSuc = false;
errmsg = string.Empty;
ParamConvert pc = new ParamConvert();
pc.Basic(false);
pc.Add("p_dwbm", dwbm);
pc.Add("p_bmbm", bmbm);
pc.Add("p_bmmc", bmmc);
pc.Add("p_bmjc", bmjc);
pc.Add("p_bmxh", bmxh);
pc.Add("p_bz", bz);
pc.Add("p_fbmbm", fbmbm);
try
{
//pc.DoExecuteDataTable("proc_add_bminfo");
pc.DoExecuteNonQuery("pkg_zzjg_manage.proc_add_bminfo");
errmsg = Convert.ToString(pc.GetValueByKey("p_errmsg"));
}
catch (Exception e)
{
errmsg += e.Message;
}
if (string.IsNullOrEmpty(errmsg))
{
isSuc = true;
}
else
{
isSuc = false;
}
return(isSuc);
}
public static void DeleteDoc(string ajbh, string wjbh, out string errmsg)
{
errmsg = string.Empty;
ParamConvert paramConvert = new ParamConvert();
paramConvert.Basic(false);
paramConvert.Add("p_ajbh", ajbh); // 案件编号
paramConvert.Add("p_wjbh", wjbh); // 文件编号
try
{
paramConvert.DoExecuteNonQuery("PKG_DOC_MANAGE.proc_del_doc");
errmsg = Convert.ToString(paramConvert.GetValueByKey("p_errmsg"));
}
catch (Exception e)
{
errmsg += e.Message;
}
}
/// <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>
/// <param name="ajbh"></param>
/// <param name="flbh"></param>
/// <param name="strErr"></param>
/// <returns></returns>
public static DataTable GetAjFlzbZl(string ajbh, string flbh, out string strErr)
{
DataTable dt = null;
strErr = string.Empty;
ParamConvert pc = new ParamConvert();
pc.Basic(true);
pc.Add("p_ajbh", ajbh);
pc.Add("p_flbh", flbh);
try
{
dt = pc.DoExecuteDataTable("pkg_case_manage.proc_get_ajzlbyajandfl");
}
catch (Exception ex)
{
strErr = ex.Message;
}
return(dt);
}
public static void UpdatePassWord(string dwbm, string gh, string oldPwd, string newPwd, out string errmsg)
{
errmsg = string.Empty;
ParamConvert pc = new ParamConvert();
pc.Basic(false);
pc.Add("p_dwbm", dwbm);
pc.Add("p_gh", gh);
pc.Add("p_oldpwd", oldPwd);
pc.Add("p_newpwd", newPwd);
try
{
pc.DoExecuteNonQuery("pkg_zzjg_manage.proc_update_psword");
errmsg += Convert.ToString(pc.GetValueByKey("p_errmsg"));
}
catch (Exception e)
{
errmsg += e.Message;
}
}
/// <summary>
/// 通过工号获取人员信息
/// </summary>
public static DataTable GetRyInfoByGh(string dwbm, string gh, out string errmsg)
{
errmsg = string.Empty;
DataTable dt = null;
ParamConvert pc = new ParamConvert();
pc.Basic(false);
pc.Add("p_dwbm", dwbm);
pc.Add("p_gh", gh);
try
{
dt = pc.DoExecuteDataTable("pkg_zzjg_manage.proc_get_ryinfobygh");
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 bool DeleteJsGnQx(string dwbm, string jsbm, string gnbm, out string errmsg)
{
errmsg = string.Empty;
bool isSuc = false;
ParamConvert pc = new ParamConvert();
pc.Basic(false);
pc.Add("p_dwbm", dwbm);
pc.Add("p_jsbm", jsbm);
pc.Add("p_gnbm", gnbm);
try
{
isSuc = pc.DoExecuteNonQuery("pkg_zzjg_manage.proc_delete_jsgnqx");
errmsg += Convert.ToString(pc.GetValueByKey("p_errmsg"));
}
catch (Exception e)
{
errmsg += e.Message;
}
return(isSuc);
}
/// <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>
public static bool ResetPwd(string dwbm, string ghj, out string errmsg)
{
bool isSuc = false;
errmsg = string.Empty;
ParamConvert pc = new ParamConvert();
pc.Basic(false);
pc.Add("p_dwbm", dwbm);
pc.Add("p_ghj", ghj);
try
{
isSuc = pc.DoExecuteNonQuery("pkg_zzjg_manage.proc_update_mmcz");
errmsg = Convert.ToString(pc.GetValueByKey("p_errmsg"));
}
catch (Exception e)
{
errmsg += e.Message;
}
return(isSuc);
}
/// <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>
/// <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>
public static bool RemoveJob(string dwbm, string bmbm, string jsbm, string gh, out string errmsg)
{
bool isSuc = false;
errmsg = string.Empty;
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_gh", gh);
try
{
isSuc = pc.DoExecuteNonQuery("pkg_zzjg_manage.proc_remove_job");
errmsg += Convert.ToString(pc.GetValueByKey("p_errmsg"));
}
catch (Exception e)
{
errmsg += e.Message;
}
return(isSuc);
}
/// <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>
/// <param name="ajbh"></param>
/// <param name="flbh"></param>
/// <param name="ajKpzl"></param>
/// <param name="strErr"></param>
public static void SaveAjKpzl(string ajbh, string flbh, List <AjKpzbZlModel> ajKpzl, LcsljdModel lcsljd, out string strErr)
{
strErr = string.Empty;
ParamConvert pc = new ParamConvert();
try
{
pc.DoExecuteWork(() =>
{
if (string.IsNullOrEmpty(lcsljd.LCSLBH))
{
pc.Basic(false);
pc.ConvertParam <LcsljdModel>(lcsljd);
pc.DoWork("pkg_wf_instance.proc_lcsl_start");
lcsljd.LCSLBH = Convert.ToString(pc.GetValueByKey("p_lcslbh")).Trim();
}
pc.Basic(false);
pc.Add("p_ajbh", ajbh);
pc.Add("p_flbh", flbh);
pc.Add("p_lcslbh", lcsljd.LCSLBH);
pc.DoWork("pkg_case_manage.proc_delete_ajzl");
foreach (AjKpzbZlModel o in ajKpzl)
{
o.LCSLBH = lcsljd.LCSLBH;
pc.Basic(false);
pc.ConvertParam <AjKpzbZlModel>(o);
pc.DoWork("pkg_case_manage.proc_add_ajzl");
}
});
}
catch (Exception ex)
{
strErr = ex.Message;
}
}
/// <summary>
/// 获取通知书或反馈书
/// </summary>
/// <param name="ajbh">案件编号</param>
/// <param name="tzfk">通知/反馈</param>
/// <param name="errmsg"></param>
/// <returns></returns>
public static string GetWH(string dwbm, string bmbm, string wsmbbh, string wsjc, out string errmsg)
{
errmsg = string.Empty;
string wh = string.Empty;
ParamConvert pc = new ParamConvert();
pc.Basic(false);
pc.Add("p_dwbm", dwbm);
pc.Add("p_bmbm", bmbm);
pc.Add("p_wsmbbh", wsmbbh);
pc.Add("p_wsjc", wsjc);
pc.Add("p_wh", DBNull.Value);
try
{
pc.DoExecuteNonQuery("pkg_no_manage.proc_get_wh");
wh = Convert.ToString(pc.GetValueByKey("p_wh"));
errmsg = Convert.ToString(pc.GetValueByKey("p_errmsg"));
}
catch (Exception e)
{
errmsg += e.Message;
}
return(wh);
}
/// <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);
}
/// <summary>
/// 监督案件删除
/// </summary>
public static void DeleteCaseInfo(string ajbhj, out string strErr)
{
strErr = string.Empty;
ParamConvert paramConvert = new ParamConvert();
paramConvert.Basic(false);
paramConvert.Add("p_ajbhj", ajbhj); // 案件名称
try
{
paramConvert.DoExecuteNonQuery("pkg_case_manage.proc_delete_jdaj");
}
catch (Exception e)
{
strErr = e.Message;
}
}
/// <summary>
/// 从数据字典中删除数据
/// </summary>
public static void DelSjzd(string dm, out string errmsg)
{
errmsg = string.Empty;
ParamConvert pc = new ParamConvert();
pc.Basic(false);
pc.Add("p_dm", dm);
try
{
pc.DoExecuteNonQuery("pkg_fldm_manage.proc_delete_sjzd");
errmsg = pc.Errmsg;
}
catch (Exception ex)
{
errmsg = ex.Message;
}
}
