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