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