/// <summary>
/// 得到督办单数据
/// </summary>
/// <param name="caseid">案件记录号</param>
/// <param name="ds"></param>
/// <returns></returns>
public static int GetCaseInfo(int userid, int caseid, ref DataSet ds)
{
try
{
//设置存储过程参数
OracleParameter[] paras = new OracleParameter[17];
// 当使用外链页面登录时,则使用默认admin用户Id获取督办单相关数据 潘杰 2011-12-06 16:28:18
paras[0] = new OracleParameter("p_userid", userid);
paras[1] = new OracleParameter("p_caseid", caseid);
paras[2] = new OracleParameter("p_caseinfo", OracleDbType.RefCursor);
paras[3] = new OracleParameter("p_teaminfo", OracleDbType.RefCursor);
paras[4] = new OracleParameter("p_curresult", OracleDbType.RefCursor);
paras[5] = new OracleParameter("p_historyresult", OracleDbType.RefCursor);
paras[6] = new OracleParameter("p_backinfo", OracleDbType.RefCursor);
paras[7] = new OracleParameter("p_delayinfo", OracleDbType.RefCursor);
paras[8] = new OracleParameter("p_solution", OracleDbType.RefCursor);
paras[9] = new OracleParameter("p_stepinfo", OracleDbType.RefCursor);
paras[10] = new OracleParameter("p_adjunct", OracleDbType.RefCursor);
paras[11] = new OracleParameter("p_record", OracleDbType.RefCursor);
paras[12] = new OracleParameter("p_teltype", OracleDbType.RefCursor);
paras[13] = new OracleParameter("p_satifyinfo", OracleDbType.RefCursor);
paras[14] = new OracleParameter("p_caselevel", OracleDbType.RefCursor);
paras[15] = new OracleParameter("p_currenthfqk", OracleDbType.RefCursor);
paras[16] = new OracleParameter("p_historyhfqk", OracleDbType.RefCursor);
//设置存储过程指定参数类型为输出参数
paras[2].Direction = ParameterDirection.Output;
paras[3].Direction = ParameterDirection.Output;
paras[4].Direction = ParameterDirection.Output;
paras[5].Direction = ParameterDirection.Output;
paras[6].Direction = ParameterDirection.Output;
paras[7].Direction = ParameterDirection.Output;
paras[8].Direction = ParameterDirection.Output;
paras[9].Direction = ParameterDirection.Output;
paras[10].Direction = ParameterDirection.Output;
paras[11].Direction = ParameterDirection.Output;
paras[12].Direction = ParameterDirection.Output;
paras[13].Direction = ParameterDirection.Output;
paras[14].Direction = ParameterDirection.Output;
paras[15].Direction = ParameterDirection.Output;
paras[16].Direction = ParameterDirection.Output;
ds = DbHelperOra.RunProcedure("pkg_caseinfo.proc_caseinfo", paras, "dt_caseinfo");
ds.Tables[0].TableName = "dt_caseinfo";
ds.Tables[1].TableName = "dt_teaminfo";
ds.Tables[2].TableName = "dt_curresult";
ds.Tables[3].TableName = "dt_historyresult";
ds.Tables[4].TableName = "dt_backinfo";
ds.Tables[5].TableName = "dt_delayinfo";
ds.Tables[6].TableName = "dt_solution";
ds.Tables[7].TableName = "dt_stepinfo";
ds.Tables[8].TableName = "dt_adjunct";
ds.Tables[9].TableName = "dt_record";
ds.Tables[10].TableName = "dt_teltype";
ds.Tables[11].TableName = "dt_satifyinfo";
ds.Tables[12].TableName = "dt_caselevel";//谢绍宁 2014-8-22 10:33:04
ds.Tables[13].TableName = "dt_currenthfqk";
ds.Tables[14].TableName = "dt_historyhfqk";
#region MyRegion
//DataTable dt0 = ds.Tables[0].Copy();
DataTable dt0 = ds.Tables[0].Clone();
dt0.Columns.Remove("市民姓名");
dt0.Columns.Remove("市民电话");
dt0.Columns.Add("市民姓名");
dt0.Columns.Add("市民电话");
foreach (DataRow dr in ds.Tables[0].Rows)//循环行
{
DataRow newdr = dt0.NewRow();
//newdr.ItemArray = dr.ItemArray;
newdr["市民姓名"] = dr["市民姓名"];
newdr["市民电话"] = dr["市民电话"];
if (Convert.ToInt32(dr["隐藏当事人资料"].ToString()) == 1 && dr["数据来源"].ToString() != "148")//148城市留言板
{
try
{
WebReference.DepartSvrInterface sm4 = new WebReference.DepartSvrInterface();
string smname = dr["市民姓名"].ToString();
string smtel = dr["市民电话"].ToString();
newdr["市民电话"] = (!string.IsNullOrEmpty(smtel) && smtel.Length < 12) ? strPublic(1, smtel) : strPublic(1, sm4.SM4Encryption(1, smtel));//市民电话隐藏关键字,SM4Encryption中1解密,2加密
newdr["市民姓名"] = (!string.IsNullOrEmpty(smname) && smname.Length < 12) ? strPublic(2, smname) : strPublic(2, sm4.SM4Encryption(1, smname));//市民姓名隐藏关键字,SM4Encryption中1解密,2加密
}
catch (Exception ex)
{
newdr["市民姓名"] = "保密";
newdr["市民电话"] = "保密";
};
}
else
{
newdr["市民姓名"] = dr["市民姓名"].ToString() == "" ? " " : dr["市民姓名"].ToString();
newdr["市民电话"] = dr["市民电话"].ToString() == "" ? " " : dr["市民电话"].ToString();
}
#region MyRegion
newdr["数据来源"] = dr["数据来源"];
newdr["案件记录号"] = dr["案件记录号"];
newdr["案件公文号"] = dr["案件公文号"];
newdr["案件类型编号"] = dr["案件类型编号"];
newdr["来话内容"] = dr["来话内容"];
newdr["办理时间MIN"] = dr["办理时间MIN"];
newdr["派单员备注"] = dr["派单员备注"];
newdr["领导批示"] = dr["领导批示"];
newdr["详细地址"] = dr["详细地址"];
newdr["规定完成时间"] = dr["规定完成时间"];
newdr["前台案件类型"] = dr["前台案件类型"];
newdr["隐藏当事人资料"] = dr["隐藏当事人资料"];
newdr["pdyid"] = dr["pdyid"];
newdr["派单员备注"] = dr["派单员备注"];
newdr["案件级别"] = dr["案件级别"];
newdr["重复记录号"] = dr["重复记录号"];
newdr["二次督办状态"] = dr["二次督办状态"];
newdr["是否转职能部门"] = dr["是否转职能部门"];
#endregion
dt0.Rows.Add(newdr);
}
DataSet newds = new DataSet();
dt0.TableName = "dt_caseinfo";
newds.Tables.Add(dt0);
DataTable dt1 = ds.Tables[1].Copy();
DataTable dt2 = ds.Tables[2].Copy();
DataTable dt3 = ds.Tables[3].Copy();
DataTable dt4 = ds.Tables[4].Copy();
DataTable dt5 = ds.Tables[5].Copy();
DataTable dt6 = ds.Tables[6].Copy();
DataTable dt7 = ds.Tables[7].Copy();
DataTable dt8 = ds.Tables[8].Copy();
DataTable dt9 = ds.Tables[9].Copy();
DataTable dt10 = ds.Tables[10].Copy();
DataTable dt11 = ds.Tables[11].Copy();
DataTable dt12 = ds.Tables[12].Copy();
DataTable dt13 = ds.Tables[13].Copy();
DataTable dt14 = ds.Tables[14].Copy();
newds.Tables.Add(dt1);
newds.Tables.Add(dt2);
newds.Tables.Add(dt3);
newds.Tables.Add(dt4);
newds.Tables.Add(dt5);
newds.Tables.Add(dt6);
newds.Tables.Add(dt7);
newds.Tables.Add(dt8);
newds.Tables.Add(dt9);
newds.Tables.Add(dt10);
newds.Tables.Add(dt11);
newds.Tables.Add(dt12);
newds.Tables.Add(dt13);
newds.Tables.Add(dt14);
ds.Clear();
ds = newds.Copy();
#endregion
return 1;
}
catch (Exception ex)
{
return 0;
}
}