/// <summary>
/// 页面加载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
//if (Session["YJUser"] != null)
// YJUser = JsonHelper.JsonString(Session["YJUser"] as EDRS.Model.YX_DZJZ_LSAJBD);
string type = Request["t"];
if (!string.IsNullOrEmpty(type))
{
Response.ContentEncoding = Encoding.UTF8;
Response.ContentType = "application/json";
if (type.Equals("ReadLogin"))
{
Response.Write(ReadLogin());
}
if (type.Equals("GetMlTree"))
{
EDRS.BLL.YX_DZJZ_JZML bll = new EDRS.BLL.YX_DZJZ_JZML(Request);
Response.Write(bll.GetMlTree(Request, false, true));
}
if (type.Equals("ListBind"))
{
Response.Write(ListBind());
}
Response.End();
}
}
/// <summary>
/// 获取案件目录
/// </summary>
/// <returns></returns>
private string GetMlTree()
{
EDRS.BLL.YX_DZJZ_JZML bll = new EDRS.BLL.YX_DZJZ_JZML(Request);
return(bll.GetMlTree(Request, false, false));
}
/// <summary>
/// 获取案件目录
/// </summary>
/// <param name="Request"></param>
/// <param name="isAll">是否获取所有目录，false为只有已分配的</param>
/// <param name="isChecked">是否默认选中</param>
/// <returns></returns>
public string GetMlTreeEx(System.Web.HttpRequest Request, bool isAll, bool isChecked)
{
string bmsah = HttpUtility.UrlDecode(HttpUtility.UrlDecode(Request.Form["bmsah"]));
string parneid = Request["pid"];
string ischecked = Request["ischecked"];
string yjxh = Request["yjxh"] ?? "";
string sfsm = Request.Form["wjtype"];
string strMlWhere = " and SFSC='N'";
string where = " and level < 3";
string withWhere = " and FMLBH is null";
object[] values = new object[2];
if (!string.IsNullOrEmpty(bmsah))
{
strMlWhere += " and BMSAH=:BMSAH";
values[0] = bmsah;
}
//判断存在父级编码
if (!string.IsNullOrEmpty(parneid))
{
withWhere = " and FMLBH =:FMLBH";
values[1] = parneid;
}
if (!string.IsNullOrEmpty(sfsm) && sfsm == "N")
{
withWhere += " and SFSM='N'";
}
EDRS.BLL.YX_DZJZ_JZML bll = new EDRS.BLL.YX_DZJZ_JZML(Request);
DataSet ds = bll.GetListByTreeEx(strMlWhere, where, withWhere, true, StringPlus.ReplaceSingle(yjxh), isAll, values);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataTable dt = ds.Tables[0].Copy();
dt.Columns["MLBH"].ColumnName = "ID";
dt.Columns["FMLBH"].ColumnName = "PARENTID";
dt.Columns["MLXSMC"].ColumnName = "NAME";
if (isChecked)
{
dt.Columns["ISEXIST"].ColumnName = "ischecked";
}
dt.Columns.Add("icon");
foreach (DataRow dr in dt.Rows)
{
switch (int.Parse(dr["MLLX"].ToString()))
{
case 1:
dr["icon"] = "jicon";
break;
case 2:
dr["icon"] = "mlicon";
break;
case 3:
dr["icon"] = "yicon";
break;
case 4:
dr["icon"] = "wjicon";
break;
}
if (dr["wjxhjl"] != null && dr["wjxhjl"].ToString() != "")
{
dr["ischecked"] = 1;
}
else
{
dr["ischecked"] = DBNull.Value;
}
}
Dictionary <string, string> styleValues = new Dictionary <string, string>();
styleValues.Add("Y", "color:blue;");
string json = new TreeJson(dt, "ID", "NAME", "PARENTID", "", "", parneid ?? "", true, true, "SFSM", styleValues, (ischecked == "true" ? true : false)).ResultJson.ToString();
return(json);
}
return(ReturnString.JsonToString(Prompt.error, "未找到相关目录！", null));
}
/// <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>
/// <param name="JZBH"></param>
public string GetDossierFileInfo()
{
// string dwbm = Request.Form["dwbm"];
string bh = Request.Form["id"];
string jzbh = Request.Form["jzbh"];
//if (string.IsNullOrEmpty(dwbm) || string.IsNullOrEmpty(bh) || string.IsNullOrEmpty(jzbh))
// return ReturnString.JsonToString(Prompt.error, "查询参数错误", null);
if (string.IsNullOrEmpty(bh) || string.IsNullOrEmpty(jzbh))
{
return(ReturnString.JsonToString(Prompt.error, "查询参数错误", null));
}
// dwbm = HttpUtility.UrlDecode(HttpUtility.UrlDecode(dwbm));
bh = HttpUtility.UrlDecode(HttpUtility.UrlDecode(bh));
jzbh = HttpUtility.UrlDecode(HttpUtility.UrlDecode(jzbh));
//返回参数
EDRS.BLL.YX_DZJZ_JZML bll = new EDRS.BLL.YX_DZJZ_JZML(HttpContext.Current.Request);
DataSet ds = bll.GetDossierFileInfo("", bh, jzbh);
//判断是否查询出现异常
if (ds != null && ds.Tables.Count > 0)
{
//判断查询没有数据
if (ds.Tables[0].Rows.Count > 0)
{
DataTable dtData = ds.Tables[0].Copy();
dtData.Columns["JZWJBH"].ColumnName = "id";
dtData.Columns["JZWJMC"].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]["JZWJYSL"]) > 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"] = "w";
dtData.Rows[i]["icon"] = "img/GroupHeader_16x16.png";
}
return(JsonHelper.JsonString(dtData));
}
else
{
return(GetDossierFilePageInfo());
//该案件没有卷
// 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));
}
}