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