/// <summary> /// 删除 /// </summary> /// <returns></returns> private string DelData() { string ids = Request.Form["id"]; 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 += ","; } } XT_DM_AJLBBM bll = new XT_DM_AJLBBM(this.Request); if (bll.DeleteList(ids)) { //数据日志 OperateLog.AddLog(OperateLog.LogType.参数配置Web, "删除类别成功", Request.Form["cs"], UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.win, "删除类别成功", null)); } //数据日志 OperateLog.AddLog(OperateLog.LogType.参数配置Web, "删除类别失败", Request.Form["cs"], UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "删除类别失败", null)); }
/// <summary> /// 绑定案件类别 /// </summary> /// <returns></returns> private string GetSSLB() { XT_DM_AJLBBM bll = new XT_DM_AJLBBM(this.Request); string where = " "; List <object> objValues = new List <object>(); if (Request["key"] != null && !string.IsNullOrEmpty(Request["key"])) { where += " AND SSLBMC like :SSLBMC "; objValues.Add("%" + Request["key"].Trim() + "%"); } if (Request["LBLX"] != null && !string.IsNullOrEmpty(Request["LBLX"])) { where += " AND FSSLBBM = :FSSLBBM"; objValues.Add(Request["LBLX"]); } else { where = " AND FSSLBBM IS NULL"; objValues.Clear(); } where += ""; DataSet ds = bll.GetSSLBList(where, objValues.ToArray()); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { DataTable dt = ds.Tables[0]; dt.Columns["SSLBBM"].ColumnName = "id"; dt.Columns["SSLBMC"].ColumnName = "text"; return(EDRS.Common.JsonHelper.JsonString(dt)); } return(ReturnString.JsonToString(Prompt.error, "未找到" + ((VersionName)0).ToString() + "类别", null)); }
/// <summary> /// 添加类别 /// </summary> /// <returns></returns> private string AddData() { string msg = string.Empty; if (!ProvingFrom(ref msg)) { return(ReturnString.JsonToString(Prompt.error, msg, null)); } string ywbm = Request.Form.Get("slct_type_val"); string ajlbbm = ywbm + "01"; XT_DM_AJLBBM bll = new XT_DM_AJLBBM(this.Request); DataSet ds = bll.GetListByPage(" and ywbm=:ywbm ", "ajlbbm desc", 1, 1, new object[] { ywbm }); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { string lb = ds.Tables[0].Rows[0]["AJLBBM"].ToString(); lb = lb.Substring(ywbm.Length, lb.Length - ywbm.Length); int num = int.Parse(lb); num++; ajlbbm = ywbm + num.ToString().PadLeft(lb.Length, '0'); } EDRS.Model.XT_DM_AJLBBM model = new EDRS.Model.XT_DM_AJLBBM(); model.YWBM = ywbm; model.AJLBBM = ajlbbm; model.AJLBMC = Request.Form.Get("txt_lbname"); model.AJSLJC = Request.Form.Get("txt_sljc"); model.SFSC = "N"; if (bll.Add(model)) { //数据日志 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)); }
/// <summary> /// 根据类别编号获取数据 /// </summary> /// <param name="DWBM"></param> /// <returns></returns> private string GetModel(string ajlbbm) { if (string.IsNullOrEmpty(ajlbbm)) { ajlbbm = Request.Form.Get("id"); if (string.IsNullOrEmpty(ajlbbm)) { return(ReturnString.JsonToString(Prompt.error, "参数错误", null)); } } XT_DM_AJLBBM bll = new XT_DM_AJLBBM(this.Request); EDRS.Model.XT_DM_AJLBBM model = bll.GetModel(ajlbbm); if (model != null) { //数据日志 OperateLog.AddLog(OperateLog.LogType.参数配置Web, "根据编号获取类型信息成功", "", UserInfo, UserRole, this.Request); return(JsonHelper.JsonString(model)); } //数据日志 OperateLog.AddLog(OperateLog.LogType.参数配置Web, "根据编号获取类型信息失败", "", UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "获取数据失败", null)); }
/// <summary> /// 绑定案件类别 /// </summary> /// <returns></returns> private string GetAJType() { XT_DM_AJLBBM bll = new XT_DM_AJLBBM(this.Request); string where = " and SFSC=:SCSC"; object[] objValues = new object[2]; objValues[0] = "N"; if (Request["key"] != null && !string.IsNullOrEmpty(Request["key"])) { where += " and AJLBMC like :AJLBMC "; objValues[1] = "%" + Request["key"].Trim() + "%"; } where += " order by xh desc "; DataSet ds = bll.GetList(where, objValues); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { DataTable dt = ds.Tables[0]; dt.Columns["AJLBBM"].ColumnName = "id"; dt.Columns["AJLBMC"].ColumnName = "text"; return(EDRS.Common.JsonHelper.JsonString(dt)); } return(ReturnString.JsonToString(Prompt.error, "未找到" + ((VersionName)0).ToString() + "类别", null)); }
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); } } } } }
/// <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_DM_AJLBBM bll = new XT_DM_AJLBBM(this.Request); EDRS.Model.XT_DM_AJLBBM model = bll.GetModel(ajlbbm); if (model != null) { string ywbm = Request.Form.Get("slct_type_val"); string ajlbbmNew = ywbm + "01"; //业务类型不同重新设置编号 if (model.YWBM != ywbm) { DataSet ds = bll.GetListByPage(" and ywbm=:ywbm ", "ajlbbm desc", 1, 1, new object[] { ywbm }); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { //int num = int.Parse(ds.Tables[0].Rows[0]["AJLBBM"].ToString().Substring(2, 2)); //num++; //ajlbbmNew = Request.Form.Get("slct_type_val") + num.ToString().PadLeft(2, '0'); string lb = ds.Tables[0].Rows[0]["AJLBBM"].ToString(); lb = lb.Substring(ywbm.Length, lb.Length - ywbm.Length); int num = int.Parse(lb); num++; ajlbbmNew = ywbm + num.ToString().PadLeft(lb.Length, '0'); } model.AJLBBM = ajlbbmNew; } model.YWBM = Request.Form.Get("slct_type_val"); model.AJLBMC = Request.Form.Get("txt_lbname"); model.AJSLJC = Request.Form.Get("txt_sljc"); if (bll.Update(model, ajlbbm)) { //数据日志 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)); }