/// <summary>
/// 添加角色信息
/// </summary>
public static bool AddJsInfo(string dwbm, string bmbm, string jsbm, string jsmc, int jsxh, string qxzt, 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);
pc.Add("p_qxzt", qxzt);
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 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 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="param"></param>
/// <param name="strErr"></param>
public static void AddOrUpdateCase(JdAjModel param, out string strErr)
{
strErr = string.Empty;
if (param == null)
{
strErr = "监督数据错误！";
}
ParamConvert paramConvert = new ParamConvert();
paramConvert.ConvertParam <JdAjModel>(param, false);
try
{
if (string.IsNullOrEmpty(param.AJBH))
{
paramConvert.DoExecuteNonQuery("pkg_case_manage.proc_add_jdaj");
param.AJBH = Convert.ToString(paramConvert.GetValueByKey("p_ajbh"));
}
else
{
paramConvert.DoExecuteNonQuery("pkg_case_manage.proc_update_jdaj");
}
}
catch (Exception e)
{
strErr = e.Message;
}
}
/// <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 UpdateRYInfo(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_zw", ryxx.ZW);
pc.Add("p_gh", ryxx.GH);
pc.Add("p_sftz", ryxx.SFTZ);
try
{
isSuc = pc.DoExecuteNonQuery("pkg_zzjg_manage.proc_update_ryinfo");
errmsg = Convert.ToString(pc.GetValueByKey("p_errmsg"));
}
catch (Exception e)
{
errmsg += e.Message;
}
return(isSuc);
}
/// <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 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 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);
}
/// <summary>
/// 创建通知书
/// </summary>
/// <param name="docInfo"></param>
/// <param name="lc"></param>
/// <param name="errmsg"></param>
/// <returns></returns>
public static string CreateDoc(DocInfoModel docInfo, LcsljdModel lc, out string errmsg)
{
string wjbh = string.Empty;
errmsg = string.Empty;
ParamConvert paramConvert = new ParamConvert();
paramConvert.Basic(false);
paramConvert.Add("p_ajbh", docInfo.AJBH); // 案件编号
paramConvert.Add("p_dwbm", docInfo.DWBM); // 单位编码
paramConvert.Add("p_fwjbh", docInfo.FWJBH); // 父文件编号
paramConvert.Add("p_wjmc", docInfo.WJMC); // 文件名称
paramConvert.Add("p_wjlj", docInfo.WJLJ); // 文件路径
paramConvert.Add("p_wjwh", docInfo.WJWH); // 文书文号
paramConvert.Add("p_wjlx", docInfo.WJLX); // 文件类型
paramConvert.Add("p_wsmbbh", docInfo.DocTemplate.WSMBBH); // 文件类型
paramConvert.Add("p_lcmbbm", lc.LCMBBM); // 文件类型
paramConvert.Add("p_lcslbh", lc.LCSLBH); // 文件类型
paramConvert.Add("p_lcjdbm", lc.LCJDBM); // 文件类型
paramConvert.Add("p_jdzxzgh", lc.JDZXZGH); // 文件类型
paramConvert.Add("p_jdzxz", lc.JDZXZ); // 文件类型
paramConvert.Add("p_wjbh", DBNull.Value); // 文件类型
try
{
paramConvert.DoExecuteNonQuery("PKG_DOC_MANAGE.proc_newdoc");
wjbh = Convert.ToString(paramConvert.GetValueByKey("p_wjbh"));
errmsg = Convert.ToString(paramConvert.GetValueByKey("p_errmsg"));
}
catch (Exception e)
{
errmsg += e.Message;
}
return(wjbh);
}
/// <summary>
/// 修改监督案件
/// </summary>
public static void UpdateCaseInfo(JdAjModel param, out string strErr)
{
strErr = string.Empty;
ParamConvert paramConvert = new ParamConvert();
paramConvert.ConvertParam <JdAjModel>(param, false);
try
{
paramConvert.DoExecuteNonQuery("pkg_case_manage.proc_update_jdaj");
}
catch (Exception e)
{
strErr = e.Message;
}
}
/// <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>
/// <param name="zbbh"></param>
/// <param name="strErr"></param>
public static void DelKpzbByBh(string zbbh, out string strErr)
{
strErr = string.Empty;
ParamConvert pc = new ParamConvert();
pc.Basic(false);
pc.Add("p_zbbh", zbbh);
try
{
pc.DoExecuteNonQuery("pkg_fldm_manage.proc_delete_zbinfobyzbbh");
strErr = pc.Errmsg;
}
catch (Exception ex)
{
strErr = ex.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;
}
}
/// <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="kpzb"></param>
/// <param name="strErr"></param>
public static void AddOrUpdateKpzb(KpzbModel kpzb, out string strErr)
{
strErr = string.Empty;
ParamConvert pc = new ParamConvert();
pc.ConvertParam <KpzbModel>(kpzb, false);
try
{
pc.DoExecuteNonQuery("pkg_fldm_manage.proc_add_kpzb");
kpzb.ZBBH = Convert.ToString(pc.GetValueByKey("p_zbbh"));
strErr = pc.Errmsg;
}
catch (Exception ex)
{
strErr = ex.Message;
}
}
/// <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>
/// <param name="zbfl"></param>
/// <param name="strErr"></param>
public static void AddOrUpdateKpzbfl(KpzbflModel zbfl, out string strErr)
{
strErr = string.Empty;
ParamConvert pc = new ParamConvert();
pc.Basic(false);
pc.ConvertParam <KpzbflModel>(zbfl);
try
{
pc.DoExecuteNonQuery("PKG_FLDM_MANAGE.proc_add_kpzbfl");
zbfl.FLBH = pc.GetValueByKey("p_flbh").TryConvertToString();
strErr = pc.Errmsg;
}
catch (Exception ex)
{
strErr = ex.Message;
}
}
/// <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);
}
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="strErr"></param>
/// <returns></returns>
public static JdAjModel GetJdAjByAjbm(string ajbh, out string strErr)
{
strErr = string.Empty;
JdAjModel jdaj = new JdAjModel();
ParamConvert pc = new ParamConvert();
pc.Basic(true);
pc.Add("p_ajbh", ajbh);
try
{
jdaj = pc.DoExecuteSprocAccessor <JdAjModel>("pkg_case_manage.proc_get_jdajbyid").FirstOrDefault();
}
catch (Exception ex)
{
strErr = ex.Message;
}
return(jdaj);
}
/// <summary>
/// 根据分类编号获取指标分类
/// </summary>
/// <param name="flbh"></param>
/// <param name="strErr"></param>
/// <returns></returns>
public static KpzbflModel GetZbflByBh(string flbh, out string strErr)
{
strErr = string.Empty;
KpzbflModel kpzbfl = new KpzbflModel();
ParamConvert pc = new ParamConvert();
pc.Basic(true);
pc.Add("p_flbh", flbh);
try
{
kpzbfl = pc.DoExecuteSprocAccessor <KpzbflModel>("pkg_fldm_manage.proc_get_kpzbflbybh").FirstOrDefault();
strErr = pc.Errmsg;
}
catch (Exception ex)
{
strErr = ex.Message;
}
return(kpzbfl);
}
/// <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 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>
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>
/// <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 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);
}
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);
}
