/// <summary>
/// 获取模板
/// </summary>
/// <returns></returns>
private string GetMBList()
{
string ajlb = Request.Form.Get("ajlb");
string strWhere = "";
if (string.IsNullOrEmpty(ajlb))
{
if (string.IsNullOrEmpty(ajlb))
{
return(ReturnString.JsonToString(Prompt.error, "参数错误", null));
}
}
else
{
strWhere += " and ajlbbm='" + StringPlus.ReplaceSingle(ajlb) + "'";
}
strWhere += " AND DWBM = '" + UserInfo.DWBM + "' AND JSBM in (" + Jsbms + ") AND BMBM in (" + Bmbms + ") AND QXLX = 0";
XY_DZJZ_MBPZB bll = new XY_DZJZ_MBPZB(this.Request);
int count;
DataSet ds = bll.GetDwAjList(out count, strWhere, "dwbm", 0, int.MaxValue, null);
if (ds != null && ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0].Copy();
dt.Columns["DOSSIERTYPEVALUEMEMBER"].ColumnName = "id";
dt.Columns["DOSSIERTYPEDISPLAYMEMBER"].ColumnName = "text";
return(JsonHelper.JsonString(dt));
}
return(ReturnString.JsonToString(Prompt.error, "获取数据失败", null));
}
private string GetLoaclData()
{
string where = string.Empty;
//树形循环条件
bool direction = true;
bool isOpen = false;
string withWhere = string.Empty;
string levelNum = "";// " and level < 10 ";
string isLeaf = "ISLEAF";
XY_DZJZ_MBPZB bll = new XY_DZJZ_MBPZB(this.Request);
object[] values = new object[2];
string dwbm = Request["dwbm"].Trim();
string ajlbbm = Request["ajlbbm"].Trim();
where = " and trim(UNITID) = :UNITID";
values[0] = dwbm;
where += " and trim(caseInfoTypeID) = :caseInfoTypeID";
values[1] = ajlbbm;
DataSet ds = bll.GetTreeList(where, withWhere, direction, values);
string treeJson = ConvertToLocalSSLBJosn(ds);
return(treeJson);
}
private void SaveTempSort(List <DataList> data)
{
Hashtable sqlList = new Hashtable();
int index = 0;
foreach (DataList item in data)
{
index++;
string sql = "UPDATE XY_DZJZ_MBPZB SET SORTINDEX = " + index + " WHERE DOSSIERTYPEVALUEMEMBER='" + item.id + "'";
sqlList.Add(sql, null);
if (item.children != null && item.children.Count > 0)
{
int childIndex = 0;
foreach (DataList _item in item.children)
{
childIndex++;
sql = "UPDATE XY_DZJZ_MBPZB SET SORTINDEX = " + childIndex + " , DOSSIERPARENTMEMBER='" + item.id + "' WHERE DOSSIERTYPEVALUEMEMBER='" + _item.id + "'";
sqlList.Add(sql, null);
}
}
}
EDRS.BLL.XY_DZJZ_MBPZB bll = new XY_DZJZ_MBPZB(Request);
bool result = bll.Update(sqlList);
if (result)
{
Response.Write("保存成功！");
}
else
{
Response.Write("保存失败！");
}
}
/// <summary>
/// 添加单位数据
/// </summary>
/// <returns></returns>
private string AddData()
{
string msg = string.Empty;
if (!ProvingFrom(ref msg))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "添加模板配置验证失败" + msg, Request.Form.Get("txt_name"), UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, msg, null));
}
string number = "00000001";
XY_DZJZ_MBPZB bll = new XY_DZJZ_MBPZB(this.Request);
DataSet ds = bll.GetListByPage("", "DOSSIERTYPEVALUEMEMBER desc", 0, 1);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
number = ds.Tables[0].Rows[0]["DOSSIERTYPEVALUEMEMBER"].ToString();
number = (int.Parse(number) + 1).ToString().PadLeft(8, '0');
}
EDRS.Model.XY_DZJZ_MBPZB model = new EDRS.Model.XY_DZJZ_MBPZB();
model.DossierTypeValueMember = number;
model.CaseInfoTypeID = Request.Form.Get("tree_ajtype_val") ?? "";
model.CaseInfoTypeName = Request.Form.Get("tree_ajtype");
model.DossierParentMember = Request.Form.Get("key_parent") ?? "";
model.UnitID = UserInfo.DWBM;
model.SSLBBM = Request.Form.Get("tree_sslb_val") ?? "";
model.SSLBMC = Request.Form.Get("tree_sslb") ?? "";
if (string.IsNullOrEmpty(Request.Form.Get("txt_rank")))
{
model.SortIndex = 1;
}
else
{
model.SortIndex = int.Parse(Request.Form.Get("txt_rank"));
}
model.DossierTypeDisplayMember = Request.Form.Get("txt_name");
model.DossierEvidenceValueMember = "";
model.Category = Request.Form.Get("hidd_Category");
if (bool.Parse(Request.Form.Get("chk_autoFound_ar")))
{
model.Auto = "Y";
}
else
{
model.Auto = "N";
}
if (bll.Add(model))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "添加模板配置成功", Request.Form.Get("txt_name"), UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "保存成功", number));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "添加模板配置失败", Request.Form.Get("txt_name"), UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "保存失败", null));
}
/// <summary>
/// 修改
/// </summary>
/// <param name="dwbm"></param>
/// <returns></returns>
private string UpData()
{
string dwbm = Request.Form.Get("key_hidd_up");
if (string.IsNullOrEmpty(dwbm) || !Regex.IsMatch(dwbm, @"^[A-Za-z0-9]{1,8}$"))
{
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null));
}
string msg = string.Empty;
if (!ProvingUpFrom(ref msg))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "修改模板配置验证失败" + msg, Request.Form.Get("txt_name_up"), UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, msg, null));
}
XY_DZJZ_MBPZB bll = new XY_DZJZ_MBPZB(this.Request);
EDRS.Model.XY_DZJZ_MBPZB model = bll.GetModel(dwbm);
if (model != null)
{
model.CaseInfoTypeID = Request.Form.Get("tree_ajtype_up_val");
model.CaseInfoTypeName = Request.Form.Get("tree_ajtype_up") ?? "";
model.DossierTypeDisplayMember = Request.Form.Get("txt_name_up");
model.SSLBBM = Request.Form.Get("tree_sslb_up_val") ?? "";
model.SSLBMC = Request.Form.Get("tree_sslb_up") ?? "";
if (string.IsNullOrEmpty(Request.Form.Get("txt_rank_up")))
{
model.SortIndex = 1;
}
else
{
model.SortIndex = int.Parse(Request.Form.Get("txt_rank_up"));
}
if (bool.Parse(Request.Form.Get("chk_autoFound_up_ar")))
{
model.Auto = "Y";
}
else
{
model.Auto = "N";
}
if (bll.Update(model))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "修改模板配置成功", Request.Form.Get("txt_name_up"), UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "保存成功", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "修改模板配置失败" + msg, Request.Form.Get("txt_name_up"), UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "保存失败", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "修改模板配置未找到修改信息" + msg, Request.Form.Get("txt_name_up"), UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null));
}
private string UpDate2()
{
string dwbm = Request["dwbm"];
string sslbbm = Request["sslbbm"];
string ajlbbm = Request["ajlbbm"];
List <object> param = new List <object>();
string strWhere = " and unitID=:dwbm";
param.Add(dwbm);
strWhere += " and CASEINFOTYPEID=:CASEINFOTYPEID";
param.Add(ajlbbm);
strWhere += " and sslbbm=:sslbbm";
param.Add(sslbbm);
EDRS.BLL.XY_DZJZ_MBPZB bll = new XY_DZJZ_MBPZB(Request);
DataSet ds = bll.GetList(strWhere, param.ToArray());
EDRS.Model.XY_DZJZ_MBPZB model = new EDRS.Model.XY_DZJZ_MBPZB();
string msg = string.Empty;
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
model = bll.GetModel(dr["DOSSIERTYPEVALUEMEMBER"].ToString());
if (model != null)
{
if (string.IsNullOrEmpty(Request.Form.Get("txt_rank")))
{
model.SortIndex = 1;
}
else
{
model.SortIndex = int.Parse(Request.Form.Get("txt_rank"));
}
if (bool.Parse(Request.Form.Get("chk_autoFound_ar")))
{
model.Auto = "Y";
}
else
{
model.Auto = "N";
}
if (bll.Update(model))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "修改模板配置成功", Request.Form.Get("txt_name_up"), UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "保存成功", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "修改模板配置失败" + msg, Request.Form.Get("txt_name_up"), UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "保存失败", null));
}
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "修改模板配置未找到修改信息" + msg, Request.Form.Get("txt_name_up"), UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null));
}
private string GetDwAjData()
{
EDRS.BLL.XY_DZJZ_MBPZB bll = new XY_DZJZ_MBPZB(Request);
DataSet ds = null;
string json = "{\"Rows\":" + "[]" + ",\"Total\":" + 0 + "}";
string orderBy = Request["sortName"] + " " + Request["sortOrder"];
int page = Convert.ToInt32(Request["page"]);
int pageSize = Convert.ToInt32(Request["pagesize"]);
string strWhere = "";
string dwbm = Request["dwbm"];
string caseajlb = Request["ajlb"];
strWhere += " and trim(qxbm) in(select distinct trim(QXBM) from xt_dm_qx a join XT_QX_RYJSFP b on trim(a.jsbm) = b.jsbm and trim(a.bmbm)=b.bmbm and trim(a.dwbm)=b.dwbm and gh=:GH1 and b.dwbm=:DWBM1 and a.qxlx=0)";
//strWhere += " and trim(ajlbbm) in ( select distinct trim(QXBM) from xt_dm_qx a join XT_QX_RYJSFP b on trim(a.jsbm) = b.jsbm and trim(a.bmbm)=b.bmbm and trim(a.dwbm)=b.dwbm and gh=:GH2 and b.dwbm=:DWBM2 and a.qxlx=1) ";
object[] param = new object[] {
UserInfo.GH,
UserInfo.DWBM
//,
//UserInfo.GH,
//UserInfo.DWBM
};
//strWhere += " and ajlbbm in (select qxbm from xt_dm_qx where DWBM = '" + UserInfo.DWBM + "' AND JSBM in (" + Jsbms + ") AND BMBM in (" + Bmbms + ") AND QXLX = 1)";
if (!string.IsNullOrEmpty(dwbm))
{
string dwbms = dwbm.Replace(";", ",");
strWhere += " and trim(qxbm) in (" + StringPlus.ReplaceSingle(dwbms) + ")";
}
if (!string.IsNullOrEmpty(caseajlb))
{
string caseajlbs = caseajlb.Replace(";", ",");
strWhere += " and trim(ajlbbm) in (" + caseajlbs + ")";
}
if (string.IsNullOrEmpty(orderBy.Trim()))
{
orderBy = "dwbm";
}
try
{
int count = 0;
ds = bll.GetDwAjList(out count, strWhere, orderBy, pageSize * (page - 1), pageSize * page, param);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
json = "{\"Rows\":" + ds.Tables[0].ToDatagridJson() + ",\"Total\":" + count + "}";
}
}
catch (Exception ex)
{
}
return(json);
}
/// <summary>
/// 修改类别
/// </summary>
/// <returns></returns>
private string UpData()
{
string ajlbbm = Request.Form.Get("key_hidd").Trim();
if (string.IsNullOrEmpty(ajlbbm))
{
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null));
}
string msg = string.Empty;
if (!ProvingFrom(ref msg))
{
return(ReturnString.JsonToString(Prompt.error, msg, null));
}
XT_DZJZ_SSLB bll = new XT_DZJZ_SSLB(this.Request);
EDRS.Model.XT_DZJZ_SSLB model = bll.GetModel(ajlbbm);
string lbbm = string.Empty;
if (model != null)
{
lbbm = model.SSLBBM;
model.SSLBMC = Request.Form.Get("txt_name");
model.SSLBSX = Convert.ToDecimal(Request.Form.Get("txt_sx"));
model.SSLBSM = Request.Form.Get("txt_sm");
if (bll.Update(model))
{
System.Collections.Hashtable hssql = new System.Collections.Hashtable();
hssql.Add(string.Format("update xy_dzjz_mbpzb set sslbmc='{0}',DossierTypeDisplayMember='{0}' where sslbbm='{1}'", model.SSLBMC, lbbm), null);
XY_DZJZ_MBPZB bllmb = new XY_DZJZ_MBPZB(this.Request);
bllmb.Update(hssql);
//数据日志
OperateLog.AddLog(OperateLog.LogType.参数配置Web, "修改所属类别成功", "", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "保存成功", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.参数配置Web, "修改所属类别失败", "", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "保存失败", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.参数配置Web, "修改所属类别未找到信息", "", UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null));
}
/// <summary>
/// 删除
/// </summary>
/// <returns></returns>
private string DelData()
{
//未启用多选
string sslbbm = Request.Form["sslbbm"];
string ajlbbm = Request.Form["ajlbbm"];
string dwbm = Request.Form["dwbm"];
XY_DZJZ_MBPZB bll = new XY_DZJZ_MBPZB(this.Request);
//if (!bll.ExistsChildren(ids))
//{
if (bll.DeleteNodeAndChild(dwbm, ajlbbm, sslbbm))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "删除模板配置成功", Request.Form["name"], UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "删除数据成功", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "删除模板配置失败", Request.Form["name"], UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "删除数据失败", null));
//}
//return ReturnString.JsonToString(Prompt.error, "该卷（目录）下包含目录（文件），请先选择删除该卷（目录）下的目录（文件）后再删除！", null);
//启用多选
//string[] id = ids.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
//ids = "";
//for (int i = 0; i < id.Length; i++)
//{
// ids += "'" + id[i].Trim() + "'";
// if (i < id.Length - 1)
// ids += ",";
//}
//if (bll.GetRecordCount(" and FDWBM in (" + ids + ")") == 0)
//{
// if (bll.Delete(ids))
// return ReturnString.JsonToString(Prompt.win, "删除数据成功", null);
// return ReturnString.JsonToString(Prompt.error, "删除数据失败", null);
//}
//else
// return ReturnString.JsonToString(Prompt.error, "该单位包含下级单位，请先选择删除下级单位！", null);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="dwbm"></param>
/// <returns></returns>
private string UpData1()
{
string msg = string.Empty;
XY_DZJZ_MBPZB bll = new XY_DZJZ_MBPZB(this.Request);
EDRS.Model.XY_DZJZ_MBPZB model = bll.GetModel(Request.Form.Get("tempID"));
if (model != null)
{
model.DossierTypeValueMember = Request.Form.Get("tempID");
if (string.IsNullOrEmpty(Request.Form.Get("txt_rank")))
{
model.SortIndex = 1;
}
else
{
model.SortIndex = int.Parse(Request.Form.Get("txt_rank"));
}
if (bool.Parse(Request.Form.Get("chk_autoFound_ar")))
{
model.Auto = "Y";
}
else
{
model.Auto = "N";
}
if (bll.Update(model))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "修改模板配置成功", Request.Form.Get("txt_name_up"), UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.win, "保存成功", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "修改模板配置失败" + msg, Request.Form.Get("txt_name_up"), UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "保存失败", null));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "修改模板配置未找到修改信息" + msg, Request.Form.Get("txt_name_up"), UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null));
}
private string ListBind()
{
//int pageNumber = 1; //int.Parse(Request["page"]);
//int pageSize = int.MaxValue;// int.Parse(Request["rows"]);
string where = string.Empty;
//树形循环条件
bool direction = true;
bool isOpen = false;
string withWhere = string.Empty;
string levelNum = "";// " and level < 10 ";
string isLeaf = "ISLEAF";
XY_DZJZ_MBPZB bll = new XY_DZJZ_MBPZB(this.Request);
object[] values = new object[1];
//if (UserInfo != null)
//{
where = " and UNITID = :UNITID";
values[0] = "370000";//UserInfo.DWBM;
//}
if (string.IsNullOrEmpty(withWhere))
{
withWhere = " and DossierParentMember is NULL ";
}
DataSet ds = bll.GetTreeList(where, withWhere, direction, values);
string datetype = Request["datetype"];
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataTable dt = ds.Tables[0];
string resultJson = dt.ToTreeJsonAll("DossierTypeValueMember", "DossierParentMember", "DossierTypeValueMember,DossierTypeDisplayMember", "");
return(resultJson);
}
return("");
}
/// <summary>
/// 根据编号获取数据
/// </summary>
/// <returns></returns>
private string GetModelOrParentList()
{
string DossierTypeValueMember = Request["id"];
if (string.IsNullOrEmpty(DossierTypeValueMember))
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "根据编号获取模板配置参数失败", Request.Form.Get("name"), UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "参数错误", null));
}
XY_DZJZ_MBPZB bll = new XY_DZJZ_MBPZB(this.Request);
EDRS.Model.XY_DZJZ_MBPZB model = bll.GetModel(DossierTypeValueMember);
if (model != null)
{
//数据日志
OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "根据编号获取模板配置成功", Request.Form.Get("name"), UserInfo, UserRole, this.Request);
return(EDRS.Common.JsonHelper.JsonString(model));
}
//数据日志
OperateLog.AddLog(OperateLog.LogType.卷宗模板配置Web, "根据编号获取模板配置失败", Request.Form.Get("name"), UserInfo, UserRole, this.Request);
return(ReturnString.JsonToString(Prompt.error, "获取数据失败", null));
}
private string GetYpzmb()
{
string dwbm = Request["dwbm"];
string sslbbm = Request["sslbbm"];
string ajlbbm = Request["ajlbbm"];
List <object> param = new List <object>();
string strWhere = " and unitID=:dwbm";
param.Add(dwbm);
strWhere += " and CASEINFOTYPEID=:CASEINFOTYPEID";
param.Add(ajlbbm);
strWhere += " and sslbbm=:sslbbm";
param.Add(sslbbm);
EDRS.BLL.XY_DZJZ_MBPZB bll = new XY_DZJZ_MBPZB(Request);
DataSet ds = bll.GetList(strWhere, param.ToArray());
string jsonResult = "";
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
jsonResult = ds.Tables[0].Rows[0]["AUTO"] + "," + ds.Tables[0].Rows[0]["SORTINDEX"];
}
return(ReturnString.JsonToString(Prompt.win, "", jsonResult));
}
/// <summary>
/// 绑定数据列表
/// </summary>
/// <returns></returns>
private string ListBind()
{
//int pageNumber = 1; //int.Parse(Request["page"]);
//int pageSize = int.MaxValue;// int.Parse(Request["rows"]);
string where = string.Empty;
//树形循环条件
bool direction = true;
bool isOpen = false;
string withWhere = string.Empty;
string levelNum = "";// " and level < 10 ";
string isLeaf = "ISLEAF";
XY_DZJZ_MBPZB bll = new XY_DZJZ_MBPZB(this.Request);
object[] values = new object[1];
if (UserInfo != null)
{
where = " and UNITID = :UNITID";
values[0] = UserInfo.DWBM;
}
//关键字搜索
string key = Request["key"];
//获取父级节点
string pid = "";
pid = Request["pid"];
if (!string.IsNullOrEmpty(key) && !string.IsNullOrEmpty(pid))
{
withWhere = " and (DossierTypeDisplayMember like '%" + key + "%') and DossierParentMember = '" + pid + "'";
}
else if (!string.IsNullOrEmpty(key))
{
withWhere = " and (DossierTypeDisplayMember like '%" + key + "%')";
direction = false;
levelNum = "";
isOpen = true;
isLeaf = "";
}
else if (!string.IsNullOrEmpty(pid))
{
withWhere = " and DossierParentMember = '" + pid.ToString() + "'";
}
if (string.IsNullOrEmpty(withWhere))
{
withWhere = " and DossierParentMember is NULL ";
}
where += levelNum;
DataSet ds = bll.GetTreeList(where, withWhere, direction, values);
string datetype = Request["datetype"];
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataTable dt = ds.Tables[0];
if (!string.IsNullOrEmpty(datetype) && datetype == "tree")
{
string resultJson = dt.ToTreeJsonAll("DossierTypeValueMember", "DossierParentMember", "DossierTypeDisplayMember", "");
return(resultJson);
}
dt.Columns["ICONCLS"].ColumnName = "icon";
if (Request["type"] != null && !string.IsNullOrEmpty(Request["type"]) && Request["type"] == "t")
{
return(new TreeJson(dt, "DossierTypeValueMember", "DossierTypeDisplayMember", "DossierParentMember", isLeaf, "", string.IsNullOrEmpty(pid) ? "" : pid, isOpen, true).ResultJson.ToString());
}
else
{
return("{\"Rows\":" + new TreeJson(dt, "DossierTypeValueMember", "DossierTypeDisplayMember", "DossierParentMember", isLeaf, "", string.IsNullOrEmpty(pid) ? "" : pid, isOpen, true).ResultJson.ToString() + "}");
}
}
return("");
}
protected void Button1_Click(object sender, EventArgs e)
{
Dictionary <string, string> SSLBList = new Dictionary <string, string>();
EDRS.BLL.XT_DM_AJLBBM bll2 = new XT_DM_AJLBBM(Request);
DataSet dsSSLB = bll2.GetSSLBList("", null);
foreach (DataRow dr in dsSSLB.Tables[0].Rows)
{
SSLBList.Add(dr["SSLBBM"].ToString(), dr["SSLBMC"].ToString());
}
if (FileUpload1.HasFile)
{
string path = FileUpload1.PostedFile.FileName;
DataSet ds = new DataSet();
ds.ReadXml(path);
foreach (DataRow dr in ds.Tables[0].Rows)
{
string number = "00000001";
XY_DZJZ_MBPZB bll = new XY_DZJZ_MBPZB(this.Request);
DataSet ds1 = bll.GetListByPage("", "DOSSIERTYPEVALUEMEMBER desc", 0, 1);
if (ds1 != null && ds1.Tables.Count > 0 && ds1.Tables[0].Rows.Count > 0)
{
number = ds1.Tables[0].Rows[0]["DOSSIERTYPEVALUEMEMBER"].ToString();
number = (int.Parse(number) + 1).ToString().PadLeft(8, '0');
}
EDRS.Model.XY_DZJZ_MBPZB model = new EDRS.Model.XY_DZJZ_MBPZB();
model.DossierTypeValueMember = number;
model.CaseInfoTypeID = "0301";
model.CaseInfoTypeName = "一审公诉案件";
model.UnitID = "370000";
model.DossierTypeDisplayMember = dr["value"].ToString();
model.DossierParentMember = "";
model.DossierEvidenceValueMember = "";
model.SortIndex = Convert.ToInt32(dr["index"]);
model.Category = "J";
model.SSLBBM = dr["key"].ToString();
model.SSLBMC = SSLBList[model.SSLBBM];
model.Auto = "N";
string pid = number;
EDRS.BLL.XY_DZJZ_MBPZB bll1 = new EDRS.BLL.XY_DZJZ_MBPZB(Request);
if (bll1.Add(model))
{
string key = dr["key"].ToString();
key = key.Split('-')[1];
DataRow[] drs = ds.Tables[1].Select("key like '" + key + "-%'");
foreach (DataRow dr1 in drs)
{
model.CaseInfoTypeID = "0301";
model.CaseInfoTypeName = "一审公诉案件";
model.UnitID = "370000";
model.DossierTypeDisplayMember = dr1["value"].ToString();
model.DossierParentMember = pid;
model.DossierEvidenceValueMember = "";
ds1 = bll.GetListByPage("", "DOSSIERTYPEVALUEMEMBER desc", 0, 1);
if (ds1 != null && ds1.Tables.Count > 0 && ds1.Tables[0].Rows.Count > 0)
{
number = ds1.Tables[0].Rows[0]["DOSSIERTYPEVALUEMEMBER"].ToString();
number = (int.Parse(number) + 1).ToString().PadLeft(8, '0');
}
model.DossierTypeValueMember = number;
model.SortIndex = Convert.ToInt32(dr1["index"]);;
model.Category = "W";
model.SSLBBM = dr1["key"].ToString();
model.SSLBMC = SSLBList[model.SSLBBM];
model.Auto = "N";
bll1.Add(model);
}
}
}
}
}
