/// <summary>
/// 卷宗页获取
/// </summary>
/// <param name="DWBM">单位编号</param>
/// <param name="BH">部门受案号</param>
/// <param name="JZBH">卷宗编号</param>
/// <param name="JZWJBH">卷宗文件编号</param>
public string GetDossierFilePageInfo()
{
// string dwbm = Request.Form["dwbm"];
string bh = Request.Form["bh"];
string wsbh = Request.Form["wsbh"];
string jzbh = Request.Form["jzbh"];
string jzwjbh = Request.Form["id"];
if (string.IsNullOrEmpty(bh) || string.IsNullOrEmpty(jzbh) || string.IsNullOrEmpty(jzwjbh) || string.IsNullOrEmpty(wsbh))
{
return(ReturnString.JsonToString(Prompt.error, "查询参数错误", null));
}
// dwbm = HttpUtility.UrlDecode(HttpUtility.UrlDecode(dwbm));
bh = HttpUtility.UrlDecode(HttpUtility.UrlDecode(bh));
jzbh = HttpUtility.UrlDecode(HttpUtility.UrlDecode(jzbh));
jzwjbh = HttpUtility.UrlDecode(HttpUtility.UrlDecode(jzwjbh));
wsbh = HttpUtility.UrlDecode(HttpUtility.UrlDecode(wsbh));
EDRS.BLL.YX_DZJZ_JZJBXX bllJzjbxx = new EDRS.BLL.YX_DZJZ_JZJBXX(HttpContext.Current.Request);
string where = "";//" and ajbh=:ajbh";
List <object> param = new List <object>();
if (!string.IsNullOrEmpty(bh) && bh != "null")
{
where += " and ajbh=:ajbh";
param.Add(bh);
}
if (!string.IsNullOrEmpty(wsbh) && wsbh != "null")
{
where += " and wsbh=:wsbh";
param.Add(wsbh);
}
List <EDRS.Model.YX_DZJZ_JZJBXX> list = bllJzjbxx.GetModelList(where, param.ToArray());
if (list == null || list.Count == 0)
{
return(ReturnString.JsonToString(Prompt.error, "未能查询到案件编号为【" + bh + "】的卷宗数据！", null));
}
bh = list[0].BMSAH;
//返回参数
string Str = string.Empty;
EDRS.BLL.YX_DZJZ_JZML bll = new EDRS.BLL.YX_DZJZ_JZML(HttpContext.Current.Request);
DataSet ds = bll.GetDossierFilePageInfo("", bh, jzbh, jzwjbh);
//判断是否查询出现异常
if (ds != null && ds.Tables.Count > 0)
{
//判断查询没有数据
if (ds.Tables[0].Rows.Count > 0)
{
//成功
DataTable dtData = ds.Tables[0].Copy();
dtData.Columns["JZWJYBH"].ColumnName = "id";
dtData.Columns["JZWJYMC"].ColumnName = "name";
dtData.Columns.Add("pId");
dtData.Columns.Add("title");
dtData.Columns.Add("isParent");
dtData.Columns.Add("type");
dtData.Columns.Add("icon");
DataColumn dc = new DataColumn();
dc.ColumnName = "nocheck";
dc.DefaultValue = true;
dtData.Columns.Add(dc);
for (int i = 0; i < dtData.Rows.Count; i++)
{
dtData.Rows[i]["isParent"] = false;
dtData.Rows[i]["pId"] = -1;
dtData.Rows[i]["title"] = dtData.Rows[i]["name"];
dtData.Rows[i]["type"] = "y";
dtData.Rows[i]["icon"] = "img/TextBox_16x16.png";
}
return(JsonHelper.JsonString(dtData));
}
else
{
//该案件没有卷
return(ReturnString.JsonToString(Prompt.error, "该文件信息下没有文件页", null));
}
}
else
{
//查询失败
return(ReturnString.JsonToString(Prompt.error, "查询失败", null));
}
}
/// <summary>
/// 制作信息获取接口
/// </summary>
/// <param name="DWBM">单位编码</param>
/// <param name="BH">部门受案号</param>
public string GetDossierDoInfo()
{
// string dwbm = Request.Form["dwbm"];
string bh = Request.Form["bh"];
string wsbh = Request.Form["wsbh"];
//if (string.IsNullOrEmpty(wsbh) || string.IsNullOrEmpty(bh))
// return ReturnString.JsonToString(Prompt.error, "查询参数错误", null);
// dwbm = HttpUtility.UrlDecode(HttpUtility.UrlDecode(dwbm));
bh = HttpUtility.UrlDecode(HttpUtility.UrlDecode(bh));
wsbh = HttpUtility.UrlDecode(HttpUtility.UrlDecode(wsbh));
EDRS.BLL.YX_DZJZ_JZJBXX bll = new EDRS.BLL.YX_DZJZ_JZJBXX(HttpContext.Current.Request);
// object[] param = new object[3];
List <object> param = new List <object>();
string where = "";//" and dwbm = :dwbm";
// param[0] = dwbm;
if (!string.IsNullOrEmpty(bh) && bh != "null")
{
where += " and ajbh=:ajbh";
param.Add(bh);
}
if (!string.IsNullOrEmpty(wsbh) && wsbh != "null")
{
where += " and wsbh=:wsbh";
param.Add(wsbh);
}
where += " and SFSC = 'N' and ZZZT >= 2 and WSBH is not null"; // and ZZZT=2
List <EDRS.Model.YX_DZJZ_JZJBXX> list = bll.GetModelList(where, param.ToArray());
if (list == null || list.Count == 0)
{
return(ReturnString.JsonToString(Prompt.error, "未能查询到案件编号为【" + bh + "】的卷宗数据！", null));
}
//判断卷宗状态
//if (Convert.ToInt32(list[0].ZZZT) != 2)
//{
// return ReturnString.JsonToString(Prompt.error, "未能查询到案件编号为【" + bh + "】的卷宗数据！", null);
//}
string bmsah = "";
for (int i = 0; i < list.Count; i++)
{
bmsah += "'" + list[i].BMSAH + "'";
if (i < list.Count - 1)
{
bmsah += ",";
}
}
//bh = list[0].BMSAH;
//返回参数
// DataSet ds = bll.GetJzjbxxByBmsah(bh, dwbm);
DataSet ds = bll.GetJzjbxxByBmsahList(bmsah, "");
//判断是否查询出现异常
if (ds != null && ds.Tables.Count > 0)
{
//判断查询没有数据
if (ds.Tables[0].Rows.Count > 0)
{
DataTable dtData = ds.Tables[0].Copy();
dtData.Columns["JZBH"].ColumnName = "id";
dtData.Columns["WSBH"].ColumnName = "name";
dtData.Columns.Add("pId");
dtData.Columns.Add("title");
dtData.Columns.Add("isParent");
dtData.Columns.Add("type");
dtData.Columns.Add("open");
dtData.Columns.Add("icon");
dtData.Columns.Add("zzzt");
//DataColumn dc = new DataColumn();
//dc.ColumnName = "checked";
//dc.DefaultValue = true;
//dtData.Columns.Add(dc);
// dtData.Columns.Add("nocheck");
for (int i = 0; i < dtData.Rows.Count; i++)
{
if (Convert.ToInt32(dtData.Rows[i]["JZSL"]) > 0)
{
dtData.Rows[i]["isParent"] = true;
}
else
{
dtData.Rows[i]["isParent"] = false;
}
dtData.Rows[i]["pId"] = "printjzbh";
dtData.Rows[i]["title"] = dtData.Rows[i]["name"];
dtData.Rows[i]["type"] = "a";
dtData.Rows[i]["open"] = false;
dtData.Rows[i]["icon"] = "img/Product_16x16.png";
dtData.Rows[i]["zzzt"] = (list[0].ZZZT == "2" ? true : false);
// dtData.Rows[i]["nocheck"] = "true";//nocheck:true
}
DataRow dr = dtData.NewRow();
dr["id"] = "printjzbh";
dr["name"] = dtData.Rows[0]["JZMC"];
dr["pId"] = -1;
dr["title"] = "";
dr["isParent"] = false;
dr["type"] = "pa";
dr["open"] = true;
dr["icon"] = "img/PackageProduct_16x16.png";
dtData.Rows.Add(dr);
return(JsonHelper.JsonString(dtData));
//成功
// return EDRS.Common.JsonHelper.JsonString(dt);
}
else
{
return(ReturnString.JsonToString(Prompt.error, "该案件没有制作信息", null));
}
}
else
{
return(ReturnString.JsonToString(Prompt.error, "查询失败", null));
}
}
/// <summary>
/// 卷宗信息获取
/// </summary>
/// <param name="bmsah"></param>
public string GetDossierInfo()
{
try
{
// string dwbm = Request.Form["dwbm"];
string bh = Request.Form["bh"];
string wsbh = Request.Form["wsbh"];
string wsbh_n = Request.Form["n"];
//if (string.IsNullOrEmpty(dwbm) || string.IsNullOrEmpty(bh))
// return ReturnString.JsonToString(Prompt.error, "查询参数错误", null);
if (string.IsNullOrEmpty(bh))
{
return(ReturnString.JsonToString(Prompt.error, "查询参数错误", null));
}
// dwbm = HttpUtility.UrlDecode(HttpUtility.UrlDecode(dwbm));
bh = HttpUtility.UrlDecode(HttpUtility.UrlDecode(bh));
EDRS.BLL.YX_DZJZ_JZJBXX bllJzjbxx = new EDRS.BLL.YX_DZJZ_JZJBXX(HttpContext.Current.Request);
//string where = " and ajbh=:ajbh and dwbm = :dwbm";
string where = "";// " and ajbh=:ajbh";
List <object> param = new List <object>();
if (!string.IsNullOrEmpty(bh) && bh != "null")
{
where += " and ajbh=:ajbh";
param.Add(bh);
}
if (!string.IsNullOrEmpty(wsbh) && wsbh != "null")
{
where += " and wsbh=:wsbh";
param.Add(wsbh);
}
List <EDRS.Model.YX_DZJZ_JZJBXX> list = bllJzjbxx.GetModelList(where, param.ToArray());
if (list == null || list.Count == 0)
{
return(ReturnString.JsonToString(Prompt.error, "未能查询到案件编号为【" + bh + "】的卷宗数据！", null));
}
list = list.Where(p => p.WSBH == wsbh_n).ToList <EDRS.Model.YX_DZJZ_JZJBXX>();
bh = list[0].BMSAH;
//返回参数
EDRS.BLL.YX_DZJZ_JZML bll = new EDRS.BLL.YX_DZJZ_JZML(HttpContext.Current.Request);
DataSet ds = bll.GetDossierInfo(bh, "");
//判断是否查询出现异常
if (ds != null && ds.Tables.Count > 0)
{
//判断查询没有数据
if (ds.Tables[0].Rows.Count > 0)
{
DataTable dtData = ds.Tables[0].Copy();
dtData.Columns["BH"].ColumnName = "id";
dtData.Columns["JZLBMC"].ColumnName = "name";
dtData.Columns.Add("pId");
dtData.Columns.Add("title");
dtData.Columns.Add("isParent");
dtData.Columns.Add("type");
dtData.Columns.Add("icon");
DataColumn dc = new DataColumn();
dc.ColumnName = "nocheck";
dc.DefaultValue = true;
dtData.Columns.Add(dc);
for (int i = 0; i < dtData.Rows.Count; i++)
{
if (Convert.ToInt32(dtData.Rows[i]["JZWJSL"]) > 0 || Convert.ToInt32(dtData.Rows[i]["JZWJSL2"]) > 0)
{
dtData.Rows[i]["isParent"] = true;
}
else
{
dtData.Rows[i]["isParent"] = false;
}
dtData.Rows[i]["pId"] = -1;
dtData.Rows[i]["title"] = dtData.Rows[i]["name"];
dtData.Rows[i]["type"] = "j";
dtData.Rows[i]["icon"] = "img/Content_16x16.png";
}
return(JsonHelper.JsonString(dtData));
//成功
// return EDRS.Common.JsonHelper.JsonString(ds.Tables[0]);
}
else
{
//该案件没有卷
return(ReturnString.JsonToString(Prompt.error, "该卷宗信息下没有文件", null));
}
}
else
{
//查询失败
return(ReturnString.JsonToString(Prompt.error, "查询失败", null));
}
}
catch (Exception ex)
{
LogHelper.LogError(Request, "Exception", ex.Message, "public string GetDossierInfo()", "GetDossierPage");
return(ReturnString.JsonToString(Prompt.error, "查询失败", null));
}
}