/// <summary> /// 解除卷宗案件基本信息锁定状态 /// </summary> /// <returns></returns> private string RomIsLock() { string bmsahs = Request.Form["bmsahs"]; if (bmsahs == null || string.IsNullOrEmpty(bmsahs)) { return ReturnString.JsonToString(Prompt.error, "解锁参数不正确", null); } string[] str = bmsahs.Split(new char[]{','},StringSplitOptions.RemoveEmptyEntries); List<EDRS.Model.YX_DZJZ_JZJBXX> modelList = new List<EDRS.Model.YX_DZJZ_JZJBXX>(); for (int i = 0; i < str.Length; i++) { EDRS.Model.YX_DZJZ_JZJBXX model = new EDRS.Model.YX_DZJZ_JZJBXX(); model.BMSAH = str[i]; model.JZXGH = ""; model.ZHXGSJ = DateTime.Now; model.ZZZT = "-1"; modelList.Add(model); } YX_DZJZ_JZJBXX bll = new YX_DZJZ_JZJBXX(this.Request); if (bll.LockByModelList(modelList)) { OperateLog.AddLogList(OperateLog.LogType.案件卷宗制作Web, "卷宗解锁成功", str, UserInfo, UserRole, this.Request); return ReturnString.JsonToString(Prompt.win, "解锁成功", null); } OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "卷宗解锁失败", bmsahs, UserInfo, UserRole, this.Request); return ReturnString.JsonToString(Prompt.error, "解锁失败", null); }
/// <summary> /// 登录账号阅卷 /// </summary> /// <returns></returns> private string ReadLogin() { string where = string.Empty; //string yjzh = Request.Form["txt_yjzh"].Trim(); //string yjmm = Request.Form["txt_yjmm"].Trim(); string yjxh = Request["yjxh"]; //where += " and YJZH='" + StringPlus.ReplaceSingle(yjzh) + "' and YJMM='" + StringPlus.ReplaceSingle(yjmm) + "' "; where += " and YJXH='" + StringPlus.ReplaceSingle(yjxh) + "'"; where += " and GH='" + UserInfo.GH + "'"; where += " and DWBM='" + UserInfo.DWBM + "'"; where += " and YJKSSJ <=to_date('" + DateTime.Now + "','yyyy-mm-dd hh24:mi:ss') "; where += " and YJJSSJ >=to_date('" + DateTime.Now + "','yyyy-mm-dd hh24:mi:ss') "; object[] values = new object[0]; EDRS.BLL.YX_DZJZ_LSAJBD bll = new EDRS.BLL.YX_DZJZ_LSAJBD(Request); List <EDRS.Model.YX_DZJZ_LSAJBD> listmodel = bll.GetModelList(where, values); if (listmodel != null && listmodel.Count > 0) { Session["YjData"] = listmodel[0]; return(JsonHelper.JsonString(listmodel)); } return(ReturnString.JsonToString(Prompt.error, "请确认阅卷时间是否未开始或者已结束", null)); }
/// <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 += ","; } } EDRS.BLL.XT_QX_GNFL bll = new EDRS.BLL.XT_QX_GNFL(this.Request); if (bll.DeleteList(ids)) { //数据日志 OperateLog.AddLog(OperateLog.LogType.功能分类管理Web, "删除功能分类成功", Request.Form["mc"], UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.win, "删除数据成功", null)); } //数据日志 OperateLog.AddLog(OperateLog.LogType.功能分类管理Web, "删除功能分类失败", Request.Form["mc"], UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "删除数据失败", null)); }
/// <summary> /// 修改 /// </summary> /// <param name="dwbm"></param> /// <returns></returns> private string UpData() { string JSBM = Request.Form.Get("key_hidd"); string BMBM = Request.Form.Get("key_hidd_dw"); string DWBM = Request.Form.Get("hidd_unitNumber"); if (string.IsNullOrEmpty(JSBM) || string.IsNullOrEmpty(BMBM) || string.IsNullOrEmpty(DWBM)) { return(ReturnString.JsonToString(Prompt.error, "参数错误", null)); } string msg = string.Empty; //if (!ProvingFrom(ref msg)) // return ReturnString.JsonToString(Prompt.error, msg, null); XT_QX_JSBM bll = new XT_QX_JSBM(this.Request); EDRS.Model.XT_QX_JSBM model = bll.GetModel(JSBM, BMBM, DWBM); if (model != null) { model.JSMC = Request.Form.Get("txt_name").Trim(); model.JSXH = Convert.ToDecimal(Request.Form.Get("txt_number").Trim()); if (bll.Update(model)) { return(ReturnString.JsonToString(Prompt.win, "保存成功", null)); } return(ReturnString.JsonToString(Prompt.error, "保存失败", null)); } else { return(ReturnString.JsonToString(Prompt.error, "未找到需要修改信息", null)); } }
/// <summary> /// 添加部门数据 /// </summary> /// <returns></returns> private string AddDepartmentData() { string msg = string.Empty; if (!ProvingFrom(ref msg)) { return(ReturnString.JsonToString(Prompt.error, msg, null)); } EDRS.Model.XT_ZZJG_BMBM model = new EDRS.Model.XT_ZZJG_BMBM(); model.DWBM = Request.Form.Get("hidd_superiorNumber"); model.BMBM = Request.Form.Get("txt_name"); model.FBMBM = Request.Form.Get("txt_abbreviation"); model.BMMC = Request.Form.Get("txt_number"); model.BMJC = Request.Form.Get("txt_rank"); model.BMAHJC = ""; model.BMWHJC = ""; model.SFLSJG = ""; model.SFCBBM = ""; model.BMXH = 0; model.BMYS = ""; XT_ZZJG_BMBM bll = new XT_ZZJG_BMBM(this.Request); if (bll.Add(model)) { return(ReturnString.JsonToString(Prompt.win, "保存成功", null)); } return(ReturnString.JsonToString(Prompt.error, "保存失败", null)); }
/// <summary> /// 绑定列表 /// </summary> /// <returns></returns> public string ListBind() { string page = Request["page"]; string rows = Request["pagesize"]; string key = Request["key"]; int pageNumber = int.Parse(page); int pageSize = int.Parse(rows); string where = " and T.SFSC='N'"; object[] values = new object[1]; if (!string.IsNullOrEmpty(key)) { where += " and YJSQDH like :YJSQDH"; values[0] = "%" + key + "%"; } where += " and T.GH='" + UserInfo.GH + "' and T.DWBM='" + UserInfo.DWBM + "'"; EDRS.BLL.YX_DZJZ_LSAJBD bll = new EDRS.BLL.YX_DZJZ_LSAJBD(this.Request); DataSet ds = bll.GetListByPage(where, "YJJSSJ desc,JDSJ desc", (pageSize * pageNumber) - pageSize + 1, (pageSize * pageNumber), values); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { //数据日志 OperateLog.AddLog(OperateLog.LogType.阅卷Web, "获取阅卷绑定列表成功", UserInfo, UserRole, this.Request); int count = bll.GetRecordCount(where, values); return("{\"Total\":" + count + ",\"Rows\":" + JsonHelper.JsonString(ds.Tables[0]) + "}"); } //数据日志 OperateLog.AddLog(OperateLog.LogType.阅卷Web, "获取阅卷绑定列表-未找到信息", UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "未找到阅卷绑定信息", null)); }
/// <summary> /// 添加配置数据 /// </summary> /// <returns></returns> private string AddData() { string msg = string.Empty; //if (!ProvingFrom(ref msg)) //{ // return ReturnString.JsonToString(Prompt.error, msg, null); //} YX_DZJZ_FMDYMB bll = new YX_DZJZ_FMDYMB(this.Request); EDRS.Model.YX_DZJZ_FMDYMB model = new EDRS.Model.YX_DZJZ_FMDYMB(); model.BT = Request.Form.Get("title"); model.NR = Request.Form.Get("value"); model.CZRGH = ""; model.CZR = ""; model.CZSJ = DateTime.Now; model.CZIP = Request.ServerVariables["REMOTE_ADDR"]; 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> /// <returns></returns> private string DelData() { string ids = Request.Form["DWBM"]; 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_ZZJG_DWBM bll = new XT_ZZJG_DWBM(this.Request); //string where = " and SFSC='N' and FDWBM in (" + ids + ")"; //if (bll.GetRecordCount(" and SFSC='N' and FDWBM in (" + ids + ")") == 0) if (bll.GetDwbmCount(ids) == 0) { // if (bll.DeleteListLogic(ids)) if (bll.DeleteList(ids)) { //数据日志 OperateLog.AddLog(OperateLog.LogType.单位管理Web, "删除数据成功", Request.Form["DWMC"], UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.win, "删除数据成功", null)); } //数据日志 OperateLog.AddLog(OperateLog.LogType.单位管理Web, "删除数据失败", Request.Form["DWMC"], UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "删除数据失败", null)); } //数据日志 OperateLog.AddLog(OperateLog.LogType.单位管理Web, "该单位已被使用,不能删除", Request.Form["DWMC"], UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "该单位已被使用,不能删除!", null)); }
/// <summary> /// 添加单位数据 /// </summary> /// <returns></returns> private string AddData() { string msg = string.Empty; if (!ProvingFrom(ref msg)) { return(ReturnString.JsonToString(Prompt.error, msg, null)); } EDRS.Model.XT_ZZJG_DWBM model = new EDRS.Model.XT_ZZJG_DWBM(); model.FDWBM = Request.Form.Get("hidd_superiorNumber").Trim(); model.DWMC = Request.Form.Get("txt_name").Trim(); model.DWJC = Request.Form.Get("txt_abbreviation").Trim(); model.DWBM = Request.Form.Get("txt_number").Trim(); model.DWJB = Request.Form.Get("txt_rank").Trim(); XT_ZZJG_DWBM bll = new XT_ZZJG_DWBM(this.Request); if (bll.Add(model)) { //数据日志 OperateLog.AddLog(OperateLog.LogType.单位管理Web, "添加单位成功", model.DWMC, UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.win, "保存成功", null)); } //数据日志 OperateLog.AddLog(OperateLog.LogType.单位管理Web, "添加单位失败", Request.Form.Get("txt_name"), UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "保存失败,请先确认单位编码是否已存在", null)); }
/// <summary> /// 获取最大排序数 /// </summary> /// <returns></returns> private string GetMaxSx() { string fid = Request.Form["fid"]; List <object> objValues = new List <object>(); string where = string.Empty; if (!string.IsNullOrEmpty(fid)) { where += " and fsslbbm=:fsslbbm"; objValues.Add(fid); where += " and sslblx=3"; } else { where += " and sslblx=1"; } XT_DZJZ_SSLB bll = new XT_DZJZ_SSLB(this.Request); object count = bll.GetMaxSx(where, objValues.ToArray()); if (count != null) { return(ReturnString.JsonToString(Prompt.win, (Convert.ToInt32(count) + 1).ToString(), null)); } return(ReturnString.JsonToString(Prompt.win, "1", null)); }
/// <summary> /// 绑定列表 /// </summary> /// <returns></returns> public string ListBind() { string where = string.Empty; //树形循环条件 bool direction = true; bool isOpen = false; string withWhere = string.Empty; string levelNum = " and level < " + (Request.Form["level"] == null ? 3 : int.Parse(Request.Form["level"].ToString())); string isLeaf = "ISLEAF"; string parentid = ""; XT_DZJZ_SSLB bll = new XT_DZJZ_SSLB(this.Request); List <object> values = new List <object>(); where += ""; //关键字搜索 string key = Request.Form["key"]; //获取父级节点 string pid = ""; if (!string.IsNullOrEmpty(key) && !string.IsNullOrEmpty(Request.Form["pid"])) { pid = Request.Form["pid"]; withWhere = " SSLBMC like '%" + StringPlus.ReplaceSingle(key) + "%' and FSSLBBM = '" + pid + "'"; } else if (!string.IsNullOrEmpty(key)) { withWhere = " SSLBMC like '%" + StringPlus.ReplaceSingle(key) + "%' "; direction = false; // levelNum = ""; // isOpen = true; // isLeaf = ""; } //else if (!string.IsNullOrEmpty(Request.Form["pid"])) //{ // pid = Request.Form["pid"]; // withWhere = " FSSLBBM = '" + StringPlus.ReplaceSingle(Request.Form["pid"].ToString()) + "'"; //} if (string.IsNullOrEmpty(withWhere)) { withWhere = " FSSLBBM is NULL "; } where += levelNum; DataSet ds = bll.GetTreeList(where, withWhere, direction, values.ToArray()); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { DataTable dt = ds.Tables[0]; //数据日志 OperateLog.AddLog(OperateLog.LogType.参数配置Web, "获取所属类别列表", UserInfo, UserRole, this.Request); return("{\"Rows\":" + new TreeJson(dt, "SSLBBM", "SSLBMC", "FSSLBBM", isLeaf, parentid, string.IsNullOrEmpty(pid) ? "" : pid, isOpen, true).ResultJson.ToString() + ",\"Total\":100}"); } //数据日志 OperateLog.AddLog(OperateLog.LogType.参数配置Web, "所属类别未找到数据", UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "未找到单位信息!", null)); }
/// <summary> /// 删除 /// </summary> /// <returns></returns> private string DelData() { string id = 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_DZJZ_SSLB bll = new XT_DZJZ_SSLB(this.Request); DataSet ds = bll.GetTreeList("", " FSSLBBM = '" + id + "'", true); string ids = string.Empty; if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { ids += "'" + ds.Tables[0].Rows[i]["SSLBBM"].ToString().Trim() + "',"; } } ids += "'" + id + "'"; 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 ListBindDWAll(HttpContext context) { //数据查询条件 string where = string.Empty; object[] values = new object[3]; where += " and SFSC=:SFSC"; values[0] = "N"; string key = context.Request["key"]; if (!string.IsNullOrEmpty(key)) { where += " and (DWMC like :DWMC or DWJC like :DWJC)"; values[1] = "%" + key + "%"; values[2] = "%" + key + "%"; } //树形循环条件 bool direction = true; bool isOpen = false; string withWhere = " FDWBM is NULL "; string levelNum = " and level <= 3 "; bool isNameAll = false; string pid = context.Request["pid"]; if (!string.IsNullOrEmpty(pid)) { withWhere = " FDWBM = '" + pid + "'"; } //根据搜索名称查询节点 string treeText = context.Request["treeText"]; if (!string.IsNullOrEmpty(treeText)) { withWhere = " DWMC like '%" + treeText + "%'"; direction = false; levelNum = ""; isOpen = true; } where += levelNum; try { XT_ZZJG_DWBM bll = new XT_ZZJG_DWBM(context.Request); DataSet ds = bll.GetTreeList(where, withWhere, direction, values); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { DataTable dt = ds.Tables[0]; dt.Columns["DWBM"].ColumnName = "ID"; dt.Columns["FDWBM"].ColumnName = "PARENTID"; dt.Columns["DWMC"].ColumnName = "NAME"; return(new TreeJson(dt, "ID", "NAME", "PARENTID", "ISLEAF", "", string.IsNullOrEmpty(pid) ? "" : pid, isOpen, isNameAll).ResultJson.ToString()); } return(ReturnString.JsonToString(Prompt.error, "未找到单位的数据", null)); } catch (Exception ex) { return(ReturnString.JsonToString(Prompt.error, ex.Message, null)); } }
/// <summary> /// 绑定列表 /// </summary> /// <returns></returns> public string ListBind() { int count = 0; DataTable dt = GetList(ref count); if (dt != null && dt.Rows.Count > 0) { string type = Request["type"]; if (type == "Graph") { //数据日志 OperateLog.AddLog(OperateLog.LogType.单位卷宗统计Web, "单位卷宗制作情况统计图形获取成功", UserInfo, UserRole, this.Request); return(StatisticsDataHelper.GetGraph(dt, new String[] { "AJNUM", "YZZNUM", "WZZNUM", "JNUM", "MLNUM", "WJNUM", "WJYNUM" }, "DWMC")); } else { //数据日志 OperateLog.AddLog(OperateLog.LogType.单位卷宗统计Web, "单位卷宗制作情况统计数据获取成功", UserInfo, UserRole, this.Request); return("{\"Total\":" + count + ",\"Rows\":" + JsonHelper.JsonString(dt) + "}"); } } //数据日志 OperateLog.AddLog(OperateLog.LogType.单位卷宗统计Web, "未找到单位卷宗制作情况统计信息", UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "未找到单位卷宗制作情况统计信息", null)); }
//#region 添加数据 ///// <summary> ///// 添加数据 ///// </summary> ///// <returns></returns> //public string AddData() //{ // EDRS.Model.YX_DZJZ_JZAJXX model = new EDRS.Model.YX_DZJZ_JZAJXX(); // model.BMSAH = Request.Form.Get("txt_BMSAH"); // model.AJMC = Request.Form.Get("txt_AJMC"); // model.AJLB_BM = Request.Form.Get("sct_AJLB_BM"); // model.AJLB_BM = Request.Form.Get("sct_CBDWBM"); // model.FQL = "4"; // YX_DZJZ_JZAJXX jzajxx = new YX_DZJZ_JZAJXX(this.Request); // if (jzajxx.Add(model)) // return ReturnString.JsonToString(Prompt.win, "保存成功", null); // return ReturnString.JsonToString(Prompt.error, "保存失败", null); //} //#endregion //#region 编辑数据 ///// <summary> ///// 编辑数据 ///// </summary> ///// <returns></returns> //public string UpData() //{ // YX_DZJZ_JZAJXX jzajxx = new YX_DZJZ_JZAJXX(this.Request); // EDRS.Model.YX_DZJZ_JZAJXX model = jzajxx.GetModel(Request.Form.Get("key_hidd")); // if (model != null) // { // model.BMSAH = Request.Form.Get("txt_BMSAH"); // model.AJMC = Request.Form.Get("txt_AJMC"); // model.AJLB_BM = Request.Form.Get("sct_AJLB_BM"); // model.AJLB_BM = Request.Form.Get("sct_CBDWBM"); // model.FQL = "4"; // if (jzajxx.Update(model)) // return ReturnString.JsonToString(Prompt.win, "修改成功", null); // } // return ReturnString.JsonToString(Prompt.error, "修改失败", null); //} //#endregion //#region 删除 ///// <summary> ///// 删除 ///// </summary> ///// <returns></returns> //private string DelData() //{ // string ids = Request.Form["BMSAH"]; // string[] id = ids.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); // ids=""; // for (int i = 0; i < id.Length; i++) // { // ids += "'" + id[i] + "'"; // if (i < id.Length - 1) // ids += ","; // } // YX_DZJZ_JZAJXX jzajxx = new YX_DZJZ_JZAJXX(this.Request); // if (jzajxx.DeleteList(ids)) // return ReturnString.JsonToString(Prompt.win, "删除数据成功", null); // return ReturnString.JsonToString(Prompt.error, "删除数据失败", null); //} //#endregion //#region 根据编号获取数据 ///// <summary> ///// 根据编号获取数据 ///// </summary> ///// <returns></returns> //public string GetModel(string BMSAH) //{ // if (string.IsNullOrEmpty(BMSAH)) // { // BMSAH = Request["id"]; // if(string.IsNullOrEmpty(BMSAH)) // return ReturnString.JsonToString(Prompt.error, "参数错误", null); // } // YX_DZJZ_JZAJXX jzajxx = new YX_DZJZ_JZAJXX(this.Request); // EDRS.Model.YX_DZJZ_JZAJXX model = jzajxx.GetModel(BMSAH); // if (model != null) // return JsonHelper.JsonString(model); // return ReturnString.JsonToString(Prompt.error, "获取数据失败", null); //} //#endregion #region 解除卷宗案件基本信息锁定状态 /// <summary> /// 解除卷宗案件基本信息锁定状态 /// </summary> /// <returns></returns> private string RomIsLock() { string BMSAH = Request.Form["BMSAH"]; if (BMSAH == null || string.IsNullOrEmpty(BMSAH)) { return(ReturnString.JsonToString(Prompt.error, "解锁参数不正确", null)); } YX_DZJZ_JZJBXX jzjbxx = new YX_DZJZ_JZJBXX(this.Request); List <EDRS.Model.YX_DZJZ_JZJBXX> jblist = jzjbxx.GetModelList(" and BMSAH=:BMSAH and SFSC='N'", new object[] { BMSAH }); if (jblist != null && jblist.Count > 0) { EDRS.Model.YX_DZJZ_JZJBXX model = jblist[0]; model.JZXGH = " "; model.ZHXGSJ = DateTime.Now; if (jzjbxx.Update(model)) { OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, ((VersionName)0).ToString() + "解锁成功", BMSAH, UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.win, "解锁成功", null)); } } OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, ((VersionName)0).ToString() + "解锁失败", BMSAH, UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "解锁失败", null)); }
/// <summary> /// 根据业务编码获取案件类别 /// </summary> /// <returns></returns> private void GetAjlbByYwbm(HttpContext context) { string ywbm = context.Request.Form["ywbm"]; if (string.IsNullOrEmpty(ywbm)) { //数据日志 context.Response.Write(ReturnString.JsonToString(Prompt.win, "保存成功", null)); return; } EDRS.BLL.XT_DM_AJLBBM bll = new EDRS.BLL.XT_DM_AJLBBM(context.Request); DataSet ds = bll.GetList(" and YWBM=:YWBM and SFSC='N' order by xh asc,ajlbbm asc", new object[] { ywbm }); if (ds != null && ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { context.Response.Write(EDRS.Common.JsonHelper.JsonString(ds.Tables[0])); return; } context.Response.Write("[]"); return; } context.Response.Write(ReturnString.JsonToString(Prompt.error, "查询失败", null)); }
/// <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)); }
/// <summary> /// 添加配置数据 /// </summary> /// <returns></returns> private string AddData() { string msg = string.Empty; if (!ProvingFrom(ref msg)) { return(ReturnString.JsonToString(Prompt.error, msg, null)); } EDRS.BLL.XT_QX_ANDY bll = new EDRS.BLL.XT_QX_ANDY(this.Request); int count = bll.GetRecordCount(" and ANBH = :ANBH", new object[] { Request.Form.Get("txt_xh").Trim() }); if (count > 0) { return(ReturnString.JsonToString(Prompt.error, "按钮编号已存在", null)); } EDRS.Model.XT_QX_ANDY model = new EDRS.Model.XT_QX_ANDY(); model.ANBH = Request.Form.Get("txt_xh").Trim(); model.ANMC = Request.Form.Get("txt_mc").Trim(); model.YMMC = Request.Form.Get("txt_ymmc_val").Trim(); if (bll.Add(model)) { //数据日志 //OperateLog.AddLog(OperateLog.LogType.功能分类管理Web, "添加功能分类成功", model.FLMC, UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.win, "保存成功", null)); } //数据日志 //OperateLog.AddLog(OperateLog.LogType.功能分类管理Web, "添加功能分类失败", model.FLMC, UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "保存失败", null)); }
// private void test() // { // TYYW_GG_AJJBXX jzajxx = new TYYW_GG_AJJBXX(this.Request); // EDRS.Model.TYYW_GG_AJJBXX model = new EDRS.Model.TYYW_GG_AJJBXX(); // model.BMSAH = "密检起诉受[2016]37078500026号"; // model.TYSAH = "37078520150084600"; // model.SFSC = "N"; // model.SFYGXTSJ = "N"; // model.CBDW_BM = "370785"; // model.CBDW_MC = "高密市院"; // model.FQDWBM = 3707; // model.FQL = "2016"; // model.CJSJ = DateTime.Now; // model.ZHXGSJ = DateTime.Now; // model.SLRQ = DateTime.Now; // model.AJMC = "邱玉波等三人贩卖毒品、李金辉等五人容留他人吸毒案"; // model.AJLB_BM = "0301"; // model.AJLB_MC = "一审公诉案件"; // model.ZCJG_DWDM = "0001213370785"; // model.ZCJG_DWMC = "高密市公安局"; // model.YSDW_DWDM = "0001213370785"; // model.YSDW_DWMC = "高密市公安局"; // model.YSWSWH = "高公(刑)诉字[2016]1003号"; // model.YSAY_AYDM = "9903106070100"; // model.YSAY_AYMC = "走私、贩卖、运输、制造毒品罪"; // model.YSQTAY_AYDMS = "9903106071100"; // model.YSQTAY_AYMCS = "容留他人吸毒罪"; // model.CBRGH = "0023"; // model.CBR = "李世乐"; // model.CBBM_BM = "0003"; // model.CBBM_MC = "公诉科"; // model.AJZT = "1"; // model.SFSWAJ = "N"; // model.SFDBAJ = "N"; // model.ZXHD_MC = ""; // model.WCRQ = DateTime.Now; // model.GDRQ = DateTime.Now; // model.GDRGH = ""; // model.GDR = ""; // model.AQZY = @"一、邱玉波、王武杰涉嫌贩卖毒品的犯罪事实 //犯罪嫌疑人邱玉波、王武杰于2015年5月份相识,后邱玉波拉拢王武杰帮助其贩卖冰毒,王武杰在明知邱玉波贩卖冰毒的情况下多次以介绍购买冰毒人员、运送冰毒的方式帮助邱玉波贩卖冰毒。 //1、2015年7月份的一天下午,犯罪嫌疑人王晨(另案已取保)通过犯罪嫌疑人王武杰的介绍,在高密市长丰街博然客房东侧邱玉波暂住房内交给犯罪嫌疑人邱玉波1000元钱购买冰毒。当天晚上,犯罪嫌疑人王武杰在犯罪嫌疑人邱玉波的指使下,帮助犯罪嫌疑人邱玉波将2.7克冰毒送至高密市毛家庄犯罪嫌疑人王晨租房处西侧空场交给犯罪嫌疑人王晨。 //2、2015年7月底的一天晚上,犯罪嫌疑人王刚(另案已刑拘)联系犯罪嫌疑人邱玉波购买200元的冰毒,后犯罪嫌疑人邱玉波指使犯罪嫌疑人王武杰与犯罪嫌疑人王刚联系,并指使犯罪嫌疑人王武杰将0.5克冰毒送至高密市毛家庄向群超市处交给犯罪嫌疑人王刚。 //二、犯罪嫌疑人李金辉涉嫌贩卖毒品、容留他人吸毒的犯罪事实 //贩卖毒品部分: //2013年11月的一天,犯罪嫌疑人李金辉为获取非法利益,在高密市谭上村其家中西间卧室内以300元的价格向任玉亮(已强戒)出售毒品冰毒0.6克。 //容留他人吸毒部分 //1、2013年10月的一天,犯罪嫌疑人李金辉在高密市创业街东头其经营的青岛啤酒店二楼容留任玉亮吸食毒品冰毒一次。 //2、2014年9月24日,犯罪嫌疑人李金辉在高密市刘新村村牌子北侧其表哥的厂房西间卧室内,容留秦浩(在逃)、任玉亮吸食毒品冰毒一次。 //3、2014年10月的一天,犯罪嫌疑人李金辉在高密市刘新村村牌子北侧其表哥的厂房西间卧室内,容留任玉亮、犯罪嫌疑人王海鑫(另案已移诉)吸食毒品冰毒一次。 //4、2014年11月的一天,犯罪嫌疑人李金辉在高密市刘新村村牌子北侧其表哥的厂房西间卧内,室容留任玉亮吸食毒品冰毒一次。 //5、2015年6、7月的一天,犯罪嫌疑人李金辉在高密市醴泉大街想唱就唱KTV门口路边其停放的车内,容留任玉亮吸食毒品冰毒一次。 //6、2015年7月份的一天,犯罪嫌疑人李金辉在高密市刘新村村牌子北侧其表哥的厂房西间卧室内,容留犯罪嫌疑人邱玉波吸食毒品冰毒一次。 //7、2015年7月份的一天,犯罪嫌疑人李金辉在高密市刘新村村牌子北侧其表哥的厂房西间卧室内,再次容留犯罪嫌疑人邱玉波吸食毒品冰毒一次。 //8、2015年7、8月份的一天,犯罪嫌疑人李金辉在高密市杨戈庄张涛家胡同东侧其停放的车内,容留犯罪嫌疑人张涛(已刑拘)吸食毒品冰毒一次。 //9、2015年9月份的一天,犯罪嫌疑人李金辉在高密市刘新村村牌子北侧其表哥的厂房大门南侧的小屋内,容留任玉亮、犯罪嫌疑人单鹏程(已取保)吸食毒品冰毒一次。 //10、2015年10月14日,犯罪嫌疑人李金辉在高密市刘新村村牌子北侧其表哥的厂房西间卧室内,容留犯罪嫌疑人张涛吸食毒品冰毒一次。 //犯罪嫌疑人李金辉共贩卖毒品1次,容留他人吸食毒品冰毒10次共13人次。"; // model.DQJD = "二次退回补充侦查"; // model.BLKSRQ = DateTime.Now; // model.BLTS = 0; // model.DQRQ = DateTime.Now; // model.BJRQ = DateTime.Now; // model.YJZT = "0"; // model.JYYJZT = "0"; // model.JYYJHCQXYRGS = 0; // model.LCSLBH = "01"; // model.FXDJ = ""; // model.SFGZAJ = "N"; // model.FZ = "邱玉波1999年1月12日因犯盗窃罪被高密市人民法院判处有期徒刑六个月,缓刑一年,并处罚金人民币二千元;2014年2月12日因吸毒被高密市公安局行政拘留十日并处罚款二千元;2014年7月8日因犯寻衅滋事罪被高密市人民法院判处有期徒刑一年二个月。王武杰2009年2月27日因犯故意伤害罪被高密市人民法院判处有期徒刑一年,缓刑一年;2010年5月10日因寻衅滋事被高密市公安局行政拘留十日;2015年9月18日因吸毒被高密市公安局行政拘留十日并处罚款二千元;2015年10月9日因吸毒被高密市公安局行政拘留十四日并处罚款二千元。"; // model.YSYJ_DM = "9930108100001"; // model.YSYJ_MC = "移送起诉"; // model.SFJBAJ = "N"; // model.ZXHD_DM = ""; // model.DQYJJD = "一次退查重报"; // model.YASCSSJD_DM = ""; // model.YASCSSJD_MC = ""; // model.YSRJDH = "高峰"; // model.XYR = ""; // model.SFZH = ""; // model.TARYXX = ""; // jzajxx.Add(model); // } #endregion #region 获取相关消息 /// <summary> /// 获取相关消息 /// </summary> /// <returns></returns> private string GetMessge() { string msg = ""; YX_DZJZ_LSYJSQ bll = new YX_DZJZ_LSYJSQ(Request); int count = bll.GetRecordCount(" and SHRGH=:SHRGH and SQDZT='T' and SFSC='N'", new object[] { UserInfo.GH }); if (count > 0) { msg += "您有" + count + "条阅卷申请需要审核"; } YX_DZJZ_LSAJBD bll2 = new YX_DZJZ_LSAJBD(Request); int count2 = bll2.GetRecordCount(" and JDRGH=:JDRGH and JDDWBM=:JDDWBM and q.SFSC='N' and t.SFSC='N' and SQDZT='Y'", new object[] { UserInfo.GH, UserInfo.DWBM }); if (count2 > 0) { msg += "|您有" + count2 + "条阅卷申请需写卡"; } if (!string.IsNullOrEmpty(msg)) { return(ReturnString.JsonToString(Prompt.win, msg, null)); } return(ReturnString.JsonToString(Prompt.error, "", null)); }
/// <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_YWBM bll = new XT_DM_YWBM(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 GetBmsah() { string nf = Request.Form["nf"]; string z = Request.Form["z"]; string h = Request.Form["h"]; string bmsah = string.Empty; if (string.IsNullOrEmpty(nf)) { return(ReturnString.JsonToString(Prompt.error, "请选择年份", null)); } if (string.IsNullOrEmpty(z)) { return(ReturnString.JsonToString(Prompt.error, "请选择字", null)); } if (string.IsNullOrEmpty(h)) { return(ReturnString.JsonToString(Prompt.error, "请输入号", null)); } bmsah = string.Format("({0}){1}{2}字第{3}号", nf, UserDwbm.DWJC, z, h); //EDRS.BLL.TYYW_GG_AJJBXX bll = new TYYW_GG_AJJBXX(Request); //if (bll.GetModel(bmsah) == null) //{ return(GetModelByBmsah(bmsah)); // return ReturnString.JsonToString(Prompt.win, bmsah, null); //} //return ReturnString.JsonToString(Prompt.win, "该案号名称名称已存在", null); }
/// <summary> /// 绑定数据列表 /// </summary> /// <returns></returns> private string ListBind() { int pageNumber = int.Parse(Request["page"]); int pageSize = int.Parse(Request["rows"]); string where = string.Empty; object[] values = new object[2]; string key = Request["key"]; if (!string.IsNullOrEmpty(key)) { where += " and JSMC like :JSMC"; values[0] = "%" + key + "%"; } if (!string.IsNullOrEmpty(Request["dkey"])) { where += " and BMBM in (SELECT distinct ID FROM view_dw_bm START WITH trim(ID) = :ID CONNECT BY nocycle Parentid = PRIOR ID)"; values[1] = Request["dkey"].ToString(); } XT_QX_JSBM bll = new XT_QX_JSBM(this.Request); DataSet ds = bll.GetListByPageAlly(where, "", (pageSize * pageNumber) - pageSize + 1, (pageSize * pageNumber), values); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { int count = bll.GetRecordCount(where, values); return("{\"total\":" + count + ",\"rows\":" + JsonHelper.JsonString(ds.Tables[0]) + "}"); } return(ReturnString.JsonToString(Prompt.error, "未设置角色", null));; }
/// <summary> /// 绑定列表 /// </summary> /// <returns></returns> public string ListBind() { string page = Request["page"]; string rows = Request["pagesize"]; string key = Request["key"]; int pageNumber = int.Parse(page); int pageSize = int.Parse(rows); string where = string.Empty; object[] values = new object[1]; if (!string.IsNullOrEmpty(key)) { where += " and BT like :BT "; values[0] = "%" + key + "%"; } EDRS.BLL.YX_DZJZ_FMDY bll = new EDRS.BLL.YX_DZJZ_FMDY(this.Request); DataSet ds = bll.GetListByPage(where, "", (pageSize * pageNumber) - pageSize + 1, (pageSize * pageNumber), values); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { //数据日志 OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "绑定打印封面数据成功", UserInfo, UserRole, this.Request); int count = bll.GetRecordCount(where, values); return("{\"Total\":" + count + ",\"Rows\":" + JsonHelper.JsonString(ds.Tables[0]) + "}"); } //数据日志 OperateLog.AddLog(OperateLog.LogType.案件卷宗制作Web, "绑定打印封面数据未找到信息", UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "未找到信息", null)); }
public static string Delete(string ids) { ids = ids.Replace("[", "").Replace("]", "").Replace("\"", ""); var idsArry = ids.Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries); XT_ZZJG_RYBM bllRybm = new XT_ZZJG_RYBM(request); //每个更新 try { foreach (var s in idsArry) { var rybm = bllRybm.GetModel(s); if (rybm == null) { continue; } rybm.SFSC = "Y"; bllRybm.Update(rybm); } } catch (Exception) { return(ReturnString.JsonToString(Prompt.error, "删除失败!", null)); } return(ReturnString.JsonToString(Prompt.win, "删除成功", null)); }
/// <summary> /// 根据律师证号获取数据 /// </summary> /// <param name="DWBM"></param> /// <returns></returns> private string GetModel(string lszh) { if (string.IsNullOrEmpty(lszh)) { lszh = Request.Form.Get("id"); if (string.IsNullOrEmpty(lszh)) { return(ReturnString.JsonToString(Prompt.error, "参数错误", null)); } } EDRS.BLL.YX_DZJZ_LSGL bll = new EDRS.BLL.YX_DZJZ_LSGL(this.Request); DataSet ds = bll.GetListfile(" and YX_DZJZ_LSGL.LSZH='" + lszh + "'", null); if (ds != null && ds.Tables.Count > 0) { DataTable dt = ds.Tables[0]; if (dt != null && dt.Columns.Count > 0 && dt.Rows.Count > 0) { //数据日志 OperateLog.AddLog(OperateLog.LogType.参数配置Web, "根据编号获取类型信息成功", "", UserInfo, UserRole, this.Request); return(JsonHelper.JsonString(dt)); } } //数据日志 OperateLog.AddLog(OperateLog.LogType.参数配置Web, "根据编号获取类型信息失败", "", UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "获取数据失败", null)); }
private string submitapply() { EDRS.BLL.YX_DZJZ_JZMLWJ bll = new EDRS.BLL.YX_DZJZ_JZMLWJ(Request); EDRS.BLL.YX_DZJZ_WJSQDY BLLSQ = new EDRS.BLL.YX_DZJZ_WJSQDY(Request); string id = Request["id"]; string wjxh = Request.Form["yjxh"]; string sq = string.Empty; if (!string.IsNullOrEmpty(id)) { sq = " and JZWJBH=:JZWJBH"; } DataSet d = BLLSQ.GetList(sq, new[] { id }); DataTable dt = d.Tables[0]; //判断该案件是否已在申请中. if (dt != null && dt.Rows.Count == 0) { string str = string.Empty; str = " and wjxh=:wjxh"; DataSet ds = bll.GetList(str, new[] { id }); if (ds.Tables[0].Rows.Count > 0) { //string bmsah = ds.Tables[0].Rows[0]["BMSAH"].ToString(); EDRS.Model.YX_DZJZ_WJSQDY model = new EDRS.Model.YX_DZJZ_WJSQDY(); model.BMSAH = ds.Tables[0].Rows[0]["BMSAH"].ToString(); model.DYBMBM = ""; //打印部门编码 model.DYBMMC = ""; model.DYDWBM = ""; model.DYDWMC = ""; model.DYFS = null; //打印份数 model.DYFY = null; //打印费用 model.DYR = ""; //打印人 model.DYRGH = ""; //打印人工号 model.DYSJ = null; //打印时间 model.LSZH = UserInfo.GH; //律师证号 model.DYSQDH = DateTime.Now.ToString("yyyyMMddHHmmssfff") + model.LSZH; model.JZWJBH = id; //文件编号 model.SFSC = "N"; model.SQFS = 1; //申请份数 model.SQSJ = DateTime.Now; //申请时间 model.YJXH = wjxh; //阅卷序号 if (BLLSQ.Add(model)) { return(ReturnString.JsonToString(Prompt.win, "申请成功", null)); } else { return(ReturnString.JsonToString(Prompt.error, "申请失败", null)); } } } else { return(ReturnString.JsonToString(Prompt.error, "该文件已申请", null)); } return(ReturnString.JsonToString(Prompt.error, "未获取文件信息", null)); }
/// <summary> /// 获取ICE统一业务配置参数 /// </summary> /// <param name="Request"></param> /// <param name="dwbm"></param> /// <param name="gh"></param> /// <returns></returns> public string GetConfiguration(string dwbm, string gh, IceServicePrx iceprx) { XY_DZJZ_XTPZ xtpzbll = new XY_DZJZ_XTPZ(null); DataSet ds = xtpzbll.GetAllList(dwbm, gh); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { DataRow[] dr = ds.Tables[0].Select("CONFIGID=" + (int)EnumConfig.访问统一业务ICE地址); if (dr.Length > 0 && dr[0]["CONFIGVALUE"] != null) { iceprx.DownPrx = dr[0]["CONFIGVALUE"].ToString(); } else { return(ReturnString.JsonToString(Prompt.error, "请先在系统配置模块配置访问统一业务ICE地址", null)); } dr = ds.Tables[0].Select("CONFIGID=" + (int)EnumConfig.ICE消息包大小); if (dr.Length > 0 && dr[0]["CONFIGVALUE"] != null) { iceprx.SizeMax = Convert.ToDecimal(dr[0]["CONFIGVALUE"].ToString()); } else { return(ReturnString.JsonToString(Prompt.error, "请先在系统配置模块配置ICE消息包大小", null)); } } else { return(ReturnString.JsonToString(Prompt.error, "请先在系统配置模块中进行配置", null)); } return(""); }
/// <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 += ","; } } YX_DZJZ_LSAJBD bll = new YX_DZJZ_LSAJBD(this.Request); if (bll.DeleteList(ids)) { //数据日志 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)); }
public static string DeleteFun(string id, string dwbm) { //检查参数是否有误 if (string.IsNullOrWhiteSpace(id) || string.IsNullOrWhiteSpace(dwbm)) { return(ReturnString.JsonToString(Prompt.error, "请选中一个选中项", null)); } var bll = new EDRS.BLL.XT_QX_GNDY(request); //删除 try { //修改标记为:"Y" var mode = bll.GetModel(id, dwbm); bll.Delete(mode.GNBM, mode.DWBM); } catch (Exception) { return(ReturnString.JsonToString(Prompt.error, "删除数据发生异常", null)); } return(ReturnString.JsonToString(Prompt.win, "删除成功", null)); }