/// <summary> /// 获取采集信息List /// </summary> /// <returns>参见模型</returns> public JsonResult GetCollectDataListAjax() { string state = Request.Params["state"]; //获取处理状态 string type = Request.Params["type"]; //采集数据类型 string strarttime = Request.Params["strarttime"]; //开始时间 string endtime = Request.Params["endtime"]; //结束时间 var sw = new T_IPSCOL_COLLECT_SW(); if (state != "2") { sw.MANSTATE = state; } sw.DateBegin = strarttime; sw.DateEnd = endtime; sw.SYSTYPEVALUE = type; //采集类型 sw.orgNo = SystemCls.getCurUserOrgNo(); //当前单位 var list = T_IPSCOL_COLLECTCls.getModelList(sw); if (list.Any()) { return(Json(new MessageListObject(true, list))); } else { return(Json(new MessageListObject(false, null))); } }
public JsonResult GetRealAjax(string uidstr) { // string uidstr = Request.Params["uid"];//护林员ID string maptype = Request.Params["maptype"]; //获取最新护林员当前坐标点 var sw = new T_IPS_REALDATATEMPORARYSW(); sw.USERID = uidstr; if (!string.IsNullOrEmpty(maptype)) { sw.MapType = maptype;//地图类型 } if (string.IsNullOrEmpty(uidstr)) { sw.ORGNO = SystemCls.getCurUserOrgNo(); if (sw.ORGNO.Trim().EndsWith("000") || sw.ORGNO.Trim().EndsWith("0000")) { sw.ORGNO = "111111111";//市县级别不用首页定位 return(Json(null)); } } var model = T_IPS_REALDATATEMPORARYCls.getTopOneModelList(sw);//选取最新的一条记录 return(Json(model)); }
/// <summary> /// 获取单条记录 /// </summary> /// <returns></returns> public static DUTY_USER_Model getModel(DUTY_USER_SW sw) { DUTY_USER_Model m = new DUTY_USER_Model(); DataTable dt = BaseDT.Duty.DUTY_USER.getDT(sw); DataTable dtUser = BaseDT.T_SYSSEC_USER.getDT(new T_SYSSEC_IPSUSER_SW { curOrgNo = SystemCls.getCurUserOrgNo() }); if (dt.Rows.Count > 0) { int i = 0; m.DUID = dt.Rows[i]["DUID"].ToString(); m.DUTYDATE = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["DUTYDATE"].ToString()); m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString(); m.DUTYUSERTYPE = dt.Rows[i]["DUTYUSERTYPE"].ToString(); m.DUTYUSERID = dt.Rows[i]["DUTYUSERID"].ToString(); m.ISATTENDED = dt.Rows[i]["ISATTENDED"].ToString(); m.ATTENDEDTIME = PublicClassLibrary.ClsSwitch.SwitTM(dt.Rows[i]["ATTENDEDTIME"].ToString()); m.USERNAME = BaseDT.T_SYSSEC_USER.getNameByUserList(dtUser, m.DUTYUSERID); } dt.Clear(); dt.Dispose(); dtUser.Clear(); dtUser.Dispose(); return(m); }
public ActionResult DocManager() { string Method = Request.Params["Method"]; //默认为添加 if (string.IsNullOrEmpty(Method)) { Method = "Add"; } if (Method != "Del") { if (string.IsNullOrEmpty(Request.Params["ARTTITLE"])) { return(Content(JsonConvert.SerializeObject(new Message(false, "请输入标题!", "")), "text/html;charset=UTF-8")); } } ART_DOCUMENT_Model m = new ART_DOCUMENT_Model(); m.ARTID = Request.Params["id"]; m.ARTTYPEID = Request.Params["ARTTYPEID"]; m.ARTTITLE = Request.Params["ARTTITLE"]; m.ARTCONTENT = Request.Params["ARTCONTENT"]; m.PLANFILENAME = Request.Params["PLANFILENAME"]; m.opMethod = Method; m.returnUrl = Request.Params["returnUrl"]; m.BYORGNO = SystemCls.getCurUserOrgNo(); m.ARTADDUSERID = SystemCls.getUserID(); return(Content(JsonConvert.SerializeObject(ART_DOCUMENTCls.Manager(m)), "text/html;charset=UTF-8")); }
/// <summary> /// 有害生物页面-三维 /// </summary> /// <returns></returns> public ActionResult PEST_3D() { ViewBag.StartTime = DateTime.Now.AddMonths(-1).ToString("yyyy-MM-dd"); ViewBag.EndTime = DateTime.Now.ToString("yyyy-MM-dd"); ViewBag.vdOrg = T_SYS_ORGCls.getSelectOption(new T_SYS_ORGSW { TopORGNO = SystemCls.getCurUserOrgNo(), SYSFLAG = ConfigCls.getSystemFlag(), CurORGNO = SystemCls.getCurUserOrgNo() }); ViewBag.SEARCHTYPE = T_SYS_DICTCls.getSelectOption(new T_SYS_DICTSW { DICTTYPEID = "123", isShowAll = "1" }); ViewBag.SEARCHTYPEAdd = T_SYS_DICTCls.getSelectOption(new T_SYS_DICTSW { DICTTYPEID = "123" }); ViewBag.HARMPOSITIONAdd = T_SYS_DICTCls.getSelectOption(new T_SYS_DICTSW { DICTTYPEID = "102" }); ViewBag.HARMLEVELAdd = T_SYS_DICTCls.getSelectOption(new T_SYS_DICTSW { DICTTYPEID = "103" }); ViewBag.MANSTATEAdd = T_SYS_DICTCls.getSelectOption(new T_SYS_DICTSW { DICTTYPEID = "104" }); ViewBag.OrgNo = SystemCls.getCurUserOrgNo(); return(View()); }
/// <summary> /// 获取热点个数 /// </summary> /// <returns></returns> private IEnumerable <HotInfoModel> GetHotInfoList() { var result = new List <HotInfoModel>(); var sw = new JC_FIRE_SW(); var curogr = SystemCls.getCurUserOrgNo(); var bb = PublicCls.OrgIsXian(curogr); if (bb) { sw.BYORGNO = curogr; } var list = JC_FIRECls.GetListModel(sw); //遍历火情来源 Array ary = Enum.GetValues(typeof(EnumType)); //array是数组的基类, 无法实例化 foreach (int item in ary) { var info = new HotInfoModel(); info.HotType = item.ToString(); info.HotName = Enum.GetName(typeof(EnumType), item);//名称 if (list.Any()) { var firelist = list.Where(p => p.FIREFROM == info.HotType && ((p.ISOUTFIRE.Trim() == "1" && p.MANSTATE.Trim() != "4") || p.ISOUTFIRE.Trim() != "1")); //筛选热点类型 排除已灭的 info.HotSum = firelist.Count().ToString(); //热点个数 if (bb) //县 { info.QSSum = firelist.Where(p => p.MANSTATE != "1").ToList().Count.ToString(); info.WQSSum = firelist.Where(p => p.MANSTATE == "1").ToList().Count.ToString(); } else { info.QSSum = firelist.Where(p => p.MANSTATE == "1").ToList().Count.ToString(); info.WQSSum = firelist.Where(p => p.MANSTATE == "0").ToList().Count.ToString(); } if (bb)//县 { info.FKSum = firelist.Where(p => p.MANSTATE == "3" || p.MANSTATE == "4").ToList().Count.ToString(); info.WFKSum = firelist.Where(p => p.MANSTATE == "2").ToList().Count.ToString(); } else { info.FKSum = firelist.Where(p => p.MANSTATE == "4").ToList().Count.ToString(); info.WFKSum = firelist.Where(p => p.MANSTATE == "3").ToList().Count.ToString(); } } else { info.HotSum = "0"; info.QSSum = "0"; info.WQSSum = "0"; info.FKSum = "0"; info.WFKSum = "0"; } result.Add(info); } return(result); }
/// <summary> /// 获取待审核(反馈)个数 /// </summary> /// <returns></returns> public JsonResult getSHFKCount() { Message ms = null; int count = 0; var curog = SystemCls.getCurUserOrgNo(); var bo = PublicCls.OrgIsShi(curog); //市 var bb = PublicCls.OrgIsXian(curog); //县 var bx = PublicCls.OrgIsZhen(curog); //镇 if (bo) { var list = JC_FIRECls.GetListModel(new JC_FIRE_SW { MANSTATESTR = "11,15" }); count = list.Count(); } else if (bb) { var list = JC_FIRECls.GetListModel(new JC_FIRE_SW { MANSTATESTR = "31,32,33,34" }); count = list.Count(); } else if (bx) { var list = JC_FIRECls.GetListModel(new JC_FIRE_SW { MANSTATESTR = "0,51" }); count = list.Count(); } ms = new Message(true, count.ToString(), ""); return(Json(ms)); }
/// <summary> /// 添加返回当前记录的id /// </summary> /// <param name="o"></param> /// <returns></returns> public static Message Add(OD_ODTYPE_Model o) {//增加判断该值班日期是否已存在 StringBuilder sbExits = new StringBuilder(); sbExits.AppendFormat("select ONDUTYID,ONDUTYDATE from OD_DATE where OD_TYPEID in(select OD_TYPEID from OD_TYPE where byorgno='{0}')", SystemCls.getCurUserOrgNo()); sbExits.AppendFormat("and( ONDUTYDATE>='{0}' and ONDUTYDATE<='{1}')", o.OD_DATEBEGIN, o.OD_DATEEND); if (DataBaseClass.JudgeRecordExists(sbExits.ToString()) == true) { return(new Message(false, "新建失败,在该值班日期范围内已存在历史值班日期!", "")); } StringBuilder sb = new StringBuilder(); sb.AppendFormat("insert into OD_TYPE(OD_TYPENAME,OD_DATEBEGIN,OD_DATEEND,BYORGNO) output inserted.OD_TYPEID values("); sb.AppendFormat("'{0}',", ClsSql.EncodeSql(o.OD_TYPENAME)); sb.AppendFormat("'{0}',", ClsSql.EncodeSql(o.OD_DATEBEGIN)); sb.AppendFormat("'{0}',", ClsSql.EncodeSql(o.OD_DATEEND)); sb.AppendFormat("'{0}')", ClsSql.EncodeSql(SystemCls.getCurUserOrgNo())); try { string strid = DataBaseClass.ReturnSqlField(sb.ToString()); return(new Message(true, "新建成功", strid)); } catch (Exception) { throw; } }
/// <summary> /// 获取车辆Tree树 /// </summary> /// <returns></returns> public ActionResult CarTreeGet() { string idorgno = Request.Params["id"]; string orgno = SystemCls.getCurUserOrgNo();//获取当前登录用户的机构编码 string result = DC_CARCls.GetJsonStrCar(orgno, idorgno); return(Content(result, "application/json")); }
/// <summary> /// 三维定位--预警监测 /// </summary> /// <returns></returns> public ActionResult From2Dto3D() { CookieModel cookieInfo1 = SystemCls.getCookieInfo(); ViewBag.LAYERNAME = T_SYS_LAYERCls.getLayerNameStr(new T_SYS_LAYER_SW { USERID = cookieInfo1.UID }); ViewBag.DEFAULTCH = T_SYS_LAYERCls.getLayerDEFAULTCHStr(new T_SYS_LAYER_SW { USERID = cookieInfo1.UID }); ViewBag.AllNAME = T_SYS_LAYERCls.getLayerAllNAME(); var result = new List <MapShowModel>(); var sw = new JC_FIRE_SW(); string jcfid = Request.Params["jcfid"]; if (!string.IsNullOrEmpty(jcfid)) { ViewBag.strjcfid = jcfid; var ss = jcfid.Split(','); if (ss.Length == 1) { sw.JCFID = jcfid; } else { sw.JCFIDSTR = jcfid; } } var list = JC_FIRECls.GetListModel(sw); if (list.Any()) { foreach (var item in list) { //var info = JC_FIRETICKLINGCls.GetFKFireInfoData(item.JCFID); var fklist = GetFKInfoList(item.JCFID); var recordlist = fklist.Select(p => p.MANSTATE).ToList();//MANSTATE状态集合 var model = new MapShowModel(); model.JCFID = item.JCFID; model.AREA = item.ZQWZ; model.BH = item.WXBH; if (Convert.ToInt32(item.MANSTATE) > 10)//大于10 说明已经入反馈阶段有顺序 { model.FKSTATE = StateSwitch.QSStateNew(SystemCls.getCurUserOrgNo(), item.MANSTATE); } else//签收无顺序性 状态判断是否反馈表包含 签到状态 1 市 2 县 3 乡镇 { model.FKSTATE = StateSwitch.QSStateNewList(SystemCls.getCurUserOrgNo(), recordlist); } //model.FKSTATE = StateSwitch.QSStateNew(SystemCls.getCurUserOrgNo(), info.JC_FireFKData.MANSTATE); result.Add(model); } } return(View(result)); }
/// <summary> /// 页面公用ViewBag /// </summary> /// <param name="PageCode">页面编码(菜单编码)</param> /// <param name="RightCode">权限编码 用于页面级权限验证</param> /// <param name="PageTitle">页面标题 标题为空自动获取页面标题及上级页面标题</param> public void pubViewBag(string PageCode, string RightCode, string PageTitle) { CookieModel cookieInfo = SystemCls.getCookieInfo(); ViewBag.getPageMenuStr = getPageMenuStr(PageCode); ViewBag.PageCode = PageCode; string curORGNo = SystemCls.getCurUserOrgNo(); if (PublicCls.OrgIsShi(curORGNo)) { curORGNo = ConfigCls.getConfigValue("ProvincialCapital");//州府所在地行政区划编码 } //获取火险等级 ViewBag.fireLevel = YJ_DANGERCLASSCls.getLevelByOrgNo(new YJ_DANGERCLASS_SW { BYORGNO = curORGNo }); //获取滚动信息 if (T_SYS_PARAMETERCls.getValueByFlag(new T_SYS_PARAMETER_SW { PARAMFLAG = "LoginInfo" }).ToString() == "0") { ViewBag.marqueeSysInfo = T_SYS_PARAMETERCls.getValueByFlag(new T_SYS_PARAMETER_SW { PARAMFLAG = "marqueeIndexInfo" }).ToString(); } else { ViewBag.marqueeSysInfo = YJ_WEATHERCls.getWeather(new YJ_WEATHER_SW { BYORGNO = curORGNo }); } ViewBag.PageLeftMenu = getPageLeftMenu(PageCode); //左侧菜单 ViewBag.isPageRight = SystemCls.isRight(RightCode); //判断页面是否有权限 ViewBag.SystemName = ConfigCls.getSystemName(); //系统名称 ViewBag.noticeRefreshTimeInterval = ConfigCls.noticeRefreshTimeInterval(); //菜单自动刷新间隔 ViewBag.PageTitle = PageTitle; //如果页面标题为空,则自动通过页面编码从系统菜单表中获取菜单名称及上级菜单名称 if (string.IsNullOrEmpty(PageTitle)) { ViewBag.PageTitle = T_SYS_MENUCls.getModel(new T_SYS_MENU_SW { MENUCODE = PageCode, SYSFLAG = ConfigCls.getSystemFlag() }).MENUNAME; } ViewBag.Title = ConfigCls.getSystemName() + "-" + ViewBag.PageTitle; //Title名称 ViewBag.SystemLogo = ConfigCls.getSystemLogo(); //获取系统logo图片 ViewBag.trueName = cookieInfo.trueName; //当前登录用户姓名 ViewBag.TopFireAlarm = ConfigCls.getTopFireAlarm(); //是否火情报警 ViewBag.TopFireLevel = ConfigCls.getTopFireLevel(); //是否显示火险等级 ViewBag.depName = StateSwitch.GetOrgNameByOrgNO(SystemCls.getCurUserOrgNo()); //部门名称 string systemFlag = ConfigCls.getSystemFlag(); //系统标识 如Springer ViewBag.T_UrlReferrer = Request.UrlReferrer; }
/// <summary> /// 野生动物页面-三维 /// </summary> /// <returns></returns> public ActionResult WILD_ANIMAL_3D() { ViewBag.POPULATIONTYPE = T_SYS_DICTCls.getSelectOption(new T_SYS_DICTSW { DICTTYPEID = "55", isShowAll = "1" }); ViewBag.ANIMAL = WILD_ANIMALDISTRIBUTECls.getSelectOption(new WILD_LOCALANIMAL_SW { isShowAll = "1", BYORGNO = SystemCls.getCurUserOrgNo() }); return(View()); }
/// <summary> /// 护林员统计Echarts /// </summary> /// <returns></returns> public ActionResult HUCountMan() { pubViewBag("004001", "004001", ""); if (ViewBag.isPageRight == false) { return(View()); } ViewBag.vdOrg = T_SYS_ORGCls.getSelectOption(new T_SYS_ORGSW { SYSFLAG = ConfigCls.getSystemFlag(), TopORGNO = SystemCls.getCurUserOrgNo() }); return(View()); }
/// <summary> /// 野生植物页面-三维 /// </summary> /// <returns></returns> public ActionResult WILD_BOTANY_3D() { ViewBag.vdOrg = T_SYS_ORGCls.getSelectOption(new T_SYS_ORGSW { TopORGNO = SystemCls.getCurUserOrgNo(), SYSFLAG = ConfigCls.getSystemFlag(), CurORGNO = SystemCls.getCurUserOrgNo() }); ViewBag.POPULATIONTYPE = T_SYS_DICTCls.getSelectOption(new T_SYS_DICTSW { DICTTYPEID = "55", isShowAll = "1" }); ViewBag.BOTANY = WILD_BOTANYDISTRIBUTECls.getSelectOption(new WILD_LOCALBOTANY_SW { isShowAll = "1" }); return(View()); }
/// <summary> /// 巡检路线Echarts /// </summary> /// <returns></returns> public ActionResult PatrolRouteStatMan() { pubViewBag("004002", "004002", ""); if (ViewBag.isPageRight == false) { return(View()); } ViewBag.TIMEBegin = DateTime.Now.ToString("yyyy-MM-01"); ViewBag.TIMEEnd = DateTime.Now.ToString("yyyy-MM-dd"); ViewBag.vdOrg = T_SYS_ORGCls.getSelectOption(new T_SYS_ORGSW { SYSFLAG = ConfigCls.getSystemFlag(), TopORGNO = SystemCls.getCurUserOrgNo() }); return(View()); }
/// <summary> /// 考勤统计 /// </summary> /// <returns>参见模型</returns> public ActionResult HUCheckINCount() { pubViewBag("005001", "005001", ""); if (ViewBag.isPageRight == false) { return(View()); } ViewBag.TIMEEnd = DateTime.Now.ToString("yyyy-MM-dd"); ViewBag.TIMEBegin = DateTime.Now.AddDays(-6).ToString("yyyy-MM-dd"); ViewBag.vdOrg = T_SYS_ORGCls.getSelectOption(new T_SYS_ORGSW { SYSFLAG = ConfigCls.getSystemFlag(), TopORGNO = SystemCls.getCurUserOrgNo() }); return(View()); }
/// <summary> /// 获取火点信息 /// </summary> /// <returns></returns> public JsonResult GetFireDisTributionData() { MessageListObject ms = new MessageListObject(false, null); var curogr = SystemCls.getCurUserOrgNo(); if (string.IsNullOrEmpty(curogr)) { ms = new MessageListObject(false, null); } else { var dataList = JC_FIRECls.GetListModel(new JC_FIRE_SW() { BYORGNO = curogr, BeginTime = DateTime.Now.AddMonths(-6).ToShortDateString(), EndTime = DateTime.Now.ToShortDateString() }); ms = new MessageListObject(true, dataList); } return(Json(ms)); }
/// <summary> /// 获取当前火情 /// </summary> /// <returns></returns> private IEnumerable <EHCurFireMode> GetCUrFireList() { var result = new List <EHCurFireMode>(); var jcfirelist = JC_FIRECls.GetListModel(new JC_FIRE_SW { BYORGNO = SystemCls.getCurUserOrgNo() }).Where(p => (p.ISOUTFIRE.Trim() != "1")); //监测火情信息 if (jcfirelist.Any()) { foreach (var item in jcfirelist) { var firefkmodel = JC_FIRETICKLINGCls.GetModelList(new JC_FIRETICKLING_SW() { JCFID = item.JCFID, ISOUTFIRE = "0" }).Where(p => p.HOTTYPE == "1" || p.HOTTYPE == "6" || p.HOTTYPE == "10").FirstOrDefault(); if (firefkmodel != null) { var model = new EHCurFireMode(); model.ADDRESSS = item.ZQWZ; model.FIRENAME = item.FIRENAME; model.JCFID = item.JCFID; model.JD = item.JD; model.WD = item.WD; model.ORGNO = item.BYORGNO; var record = JC_FIRE_PROPCls.getModel(new JC_FIRE_PROP_SW { JCFID = item.JCFID }); if (record != null) { model.FIRELEVEL = record.FIRELEVEL; } if (model.FIRELEVEL == null) { model.FIRELEVEL = ""; } result.Add(model); } } } return(result); }
/// <summary> /// 获取当前火情——优化后 /// </summary> /// <returns></returns> private IEnumerable <EHCurFireMode> GetCUrFireListYH() { var result = new List <EHCurFireMode>(); var jcfirelist = JC_FIRECls.GetListModelYH(new JC_FIRE_SW { BYORGNO = SystemCls.getCurUserOrgNo() }); //监测火情信息 foreach (var item in jcfirelist) { var model = new EHCurFireMode(); model.ADDRESSS = item.ZQWZ; model.FIRENAME = item.FIRENAME; model.JCFID = item.JCFID; model.JD = item.JD; model.WD = item.WD; model.ORGNO = item.BYORGNO; model.FIRELEVEL = item.FIRELEVEL; result.Add(model); } return(result); }
/// <summary> /// 报警信息(一键报警) /// </summary> /// <returns></returns> public JsonResult GetAlarmListAjax() { string state = Request.Params["state"]; //处理状态 string starttime = Request.Params["starttime"]; //开始时间 string endtime = Request.Params["endtime"]; //开始时间 MessageListObject ms = null; var sw = new T_IPS_ALARM_SW(); sw.orgNo = SystemCls.getCurUserOrgNo(); sw.MANSTATE = state; sw.DateBegin = starttime; sw.DateEnd = endtime; sw.orgNo = SystemCls.getCurUserOrgNo(); var list = T_IPS_ALARMCls.getModelList(sw); if (list.Any()) { ms = new MessageListObject(true, list); } return(Json(ms)); }
/// <summary> /// 获取火情来源数据 /// </summary> /// <returns></returns> public JsonResult GetFireSourceData() { var result = new List <OutData>(); MessageListObject ms = new MessageListObject(false, null); var sw = new JC_FIRE_SW(); var curogr = SystemCls.getCurUserOrgNo(); if (!string.IsNullOrEmpty(curogr)) { var bo = PublicCls.OrgIsShi(curogr); var bb = PublicCls.OrgIsXian(curogr); var bx = PublicCls.OrgIsZhen(curogr); if (!bo) { sw.BYORGNO = curogr; } sw.isCountIndex = "1"; //遍历火情来源 Array ary = Enum.GetValues(typeof(EnumType)); //array是数组的基类, 无法实例化 var list = JC_FIRECls.GetListModel(sw); foreach (int item in ary) { string hotsum = "0"; var fireData = new OutData(); if (item.ToString() != "1")//排除红外相机 { if (list.Any()) { var firelist = list.Where(p => p.FIREFROM == item.ToString() && !string.IsNullOrEmpty(p.FIREFROM) && p.ISOUTFIRE != "1" && p.MANSTATE != "19" && p.MANSTATE != "18"); //筛选热点类型 排除已灭的 && ((p.ISOUTFIRE.Trim() == "1" && p.MANSTATE.Trim() != "4") || p.ISOUTFIRE.Trim() != "1") 已在程序中处理 hotsum = firelist.Count().ToString(); //热点个数 } fireData.name = Enum.GetName(typeof(EnumType), item); fireData.value = hotsum; result.Add(fireData); } } ms = new MessageListObject(true, result); } return(Json(ms)); }
/// <summary> /// 获取数据,获取所有角色 /// </summary> /// <returns>参见模型</returns> public static DataTable getDT(T_SYSSEC_ROLE_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("SELECT ROLEID, ROLENAME, ROLENOTE, SYSFLAG,ROLELEVEL, ORDERBY"); sb.AppendFormat(" FROM T_SYSSEC_ROLE"); sb.AppendFormat(" WHERE 1=1"); if (string.IsNullOrEmpty(sw.ROLEID) == false) { sb.AppendFormat(" AND ROLEID = '{0}'", ClsSql.EncodeSql(sw.ROLEID)); } if (string.IsNullOrEmpty(sw.SYSFLAG) == false) { sb.AppendFormat(" AND SYSFLAG = '{0}'", ClsSql.EncodeSql(sw.SYSFLAG)); } //if (string.IsNullOrEmpty(sw.USERID) == false) // sb.AppendFormat(" AND USERID = '{0}'", ClsSql.EncodeSql(sw.USERID)); string curOrg = SystemCls.getCurUserOrgNo(); if (PublicCls.OrgIsShi(curOrg)) { sb.AppendFormat(" AND ROLELEVEL>=1"); } else if (PublicCls.OrgIsXian(curOrg)) { sb.AppendFormat(" AND ROLELEVEL>=2"); } else { sb.AppendFormat(" AND ROLELEVEL>=3"); } sb.AppendFormat(" ORDER BY ORDERBY "); DataSet ds = DataBaseClass.FullDataSet(sb.ToString()); return(ds.Tables[0]); }
/// <summary> /// 检索获取数据上报数据 /// </summary> /// <returns>参见模型</returns> public JsonResult GetReportDataAjax() { MessageListObject ms = null; string starttime = Request.Params["starttime"]; //开始时间 string endtime = Request.Params["endtime"]; //开始时间 string type = Request.Params["type"]; //类型 string state = Request.Params["state"]; //状态 //if (string.IsNullOrEmpty(starttime) || string.IsNullOrEmpty(endtime) || string.IsNullOrEmpty(type)) //{ // ms = new MessageListObject(false, null); // return Json(ms); //} var sw = new T_IPSRPT_REPORT_SW(); sw.DateBegin = starttime; sw.DateEnd = endtime; sw.SYSTYPEVALUE = type; sw.orgNo = SystemCls.getCurUserOrgNo();//当前单位 if (state != "2") { sw.MANSTATE = state; } var list = T_IPSRPT_REPORTCls.getModelList(sw); if (list.Any()) { ms = new MessageListObject(true, list); } else { ms = new MessageListObject(false, null); } return(Json(ms)); }
/// <summary> /// 修改 /// </summary> /// <param name="o">对象</param> /// <returns></returns> public static Message Mdy(OD_ODTYPE_Model o) { if (string.IsNullOrEmpty(o.OD_TYPEID)) { return(new Message(false, "修改ID不能为空", "")); } //增加判断该值班日期是否已存在 StringBuilder sbExits = new StringBuilder(); sbExits.AppendFormat("select ONDUTYID,ONDUTYDATE from OD_DATE where OD_TYPEID in(select OD_TYPEID from OD_TYPE where byorgno='{0}')", SystemCls.getCurUserOrgNo()); sbExits.AppendFormat("and( ONDUTYDATE>='{0}' and ONDUTYDATE<='{1}')", o.OD_DATEBEGIN, o.OD_DATEEND); sbExits.AppendFormat("and OD_TYPEID<>'{0}'", o.OD_TYPEID); if (DataBaseClass.JudgeRecordExists(sbExits.ToString()) == true) { return(new Message(false, "重新生成失败,在该值班日期范围内已存在历史值班日期!", "")); } StringBuilder sb = new StringBuilder(); sb.AppendFormat("update OD_TYPE set"); sb.AppendFormat(" OD_TYPENAME='{0}',", ClsSql.EncodeSql(o.OD_TYPENAME)); sb.AppendFormat("OD_DATEBEGIN='{0}',", ClsSwitch.SwitDate(o.OD_DATEBEGIN)); sb.AppendFormat("OD_DATEEND='{0}'", ClsSwitch.SwitDate(o.OD_DATEEND)); if (!string.IsNullOrEmpty(o.OD_TYPEID)) { sb.AppendFormat(" where OD_TYPEID={0}", ClsSql.EncodeSql(o.OD_TYPEID)); } bool b = DataBaseClass.ExeSql(sb.ToString()); if (b) { return(new Message(true, "修改成功", o.OD_TYPEID)); } else { return(new Message(false, "修改失败", "")); } }
public string getPageLeftMenu(string PageCode) { StringBuilder sb = new StringBuilder(); var result = T_SYS_MENUCls.getT_SYS_MENUModel(new T_SYS_MENU_SW { UID = SystemCls.getUserID(), SYSFLAG = ConfigCls.getSystemFlag() }); var m = result.Where(p => p.MENUCODE == PageCode.Substring(0, 3)).FirstOrDefault();//获取该页面对应的菜单信息 sb.AppendFormat("<ul class=\"page-menu\">\r\n"); int indexI = -1; int indexII = 0; if (m != null) { string tmp = m.MENULINKMODE; if (string.IsNullOrEmpty(tmp)) { tmp = m.MENUCODE; } string[] arr = tmp.Split(',');//循环数组,用于判断如果是多个模块组合成左侧菜单 for (int i = 0; i < arr.Length; i++) { var mModel = result.Where(p => p.MENUCODE == arr[i]).FirstOrDefault(); string[] arrHQJC = new string[55]; if (arr[i] == "040")//火情监控统计个数 { var list = new List <JC_FIRE_Model>(); string orgno = ""; bool bo = PublicCls.OrgIsShi(SystemCls.getCurUserOrgNo());//市机构 if (!bo) { bool bc = PublicCls.OrgIsZhen(SystemCls.getCurUserOrgNo());//乡镇机构 if (bc) { orgno = SystemCls.getCurUserOrgNo();// } else { orgno = SystemCls.getCurUserOrgNo().Substring(0, 6);// } } if (string.IsNullOrEmpty(orgno)) { list = JC_FIRECls.GetListModel(new JC_FIRE_SW { }).Where(p => p.ISOUTFIRE.Trim() != "1" && p.MANSTATE != "19" && p.MANSTATE != "18").ToList(); //不筛选出火已灭的记录并且已经上报(非火情)19为市(州)已经上报 // && p.MANSTATE != "19" } else { list = JC_FIRECls.GetListModel(new JC_FIRE_SW { }).Where(p => p.BYORGNO.StartsWith(orgno.ToString()) && p.ISOUTFIRE.Trim() != "1" && p.MANSTATE != "19" && p.MANSTATE != "18").ToList(); //不筛选出火已灭的记录 } arrHQJC[2] = list.Where(p => p.FIREFROM == "2").Count().ToString(); arrHQJC[5] = list.Where(p => p.FIREFROM == "5").Count().ToString(); arrHQJC[4] = list.Where(p => p.FIREFROM == "4").Count().ToString(); arrHQJC[6] = list.Where(p => p.FIREFROM == "6").Count().ToString(); arrHQJC[3] = list.Where(p => p.FIREFROM == "3").Count().ToString(); } if (mModel != null) { indexI++; sb.AppendFormat("<li><span><h1><span>{0}</span></h1></span>\r\n", mModel.MENUNAME); sb.AppendFormat("<ul>\r\n"); foreach (var sv in mModel.subMenuModel) { var menu = false; var num = ""; if (arr[i] == "040")//火情监控 { if (sv.MENUCODE == "040002") { menu = true; num = arrHQJC[2]; } if (sv.MENUCODE == "040003") { menu = true; num = arrHQJC[3]; } if (sv.MENUCODE == "040004") { menu = true; num = arrHQJC[4]; } if (sv.MENUCODE == "040005") { menu = true; num = arrHQJC[5]; } if (sv.MENUCODE == "040006") { menu = true; num = arrHQJC[6]; } } if (sv.MENUCODE == "009005") { menu = true; num = E_RECEIVE_Cls.getCount(); } if (sv.MENUCODE == "011002") { menu = true; num = DC_ARMYCls.getCount(); } if (sv.MENUCODE == "011003") { menu = true; num = DC_RESOURCE_NEWCls.getCount(); } if (sv.MENUCODE == "011005") { menu = true; num = DC_EQUIP_NEWCls.getCount(); } if (sv.MENUCODE == "011006") { menu = true; num = JC_FIRECls.getCount(); } if (sv.MENUCODE == "011008") { menu = true; num = DC_REPOSITORYCls.getCount(); } if (sv.MENUCODE == "011009") { menu = true; num = DC_CARCls.getCount(); } if (sv.MENUCODE == "011011") { menu = true; num = TD_MOUNTAINCls.getCount(); } if (sv.MENUCODE == "042001") { menu = true; num = WILD_ANIMALDISTRIBUTECls.getCount(); } if (sv.MENUCODE == "043001") { menu = true; num = WILD_BOTANYDISTRIBUTECls.getCount(); } if (sv.MENUCODE == "016001") { menu = true; num = DC_UTILITY_CAMPCls.getCount(); } if (sv.MENUCODE == "016002") { menu = true; num = DC_UTILITY_OVERWATCHCls.getCount(); } if (sv.MENUCODE == "016003") { menu = true; num = DC_UTILITY_ISOLATIONSTRIPCls.getCount(); } if (sv.MENUCODE == "016004") { menu = true; num = DC_UTILITY_PROPAGANDASTELECls.getCount(); } if (sv.MENUCODE == "016005") { menu = true; num = DC_UTILITY_RELAYCls.getCount(); } if (sv.MENUCODE == "016006") { menu = true; num = DC_UTILITY_MONITORINGSTATIONCls.getCount(); } if (sv.MENUCODE == "016007") { menu = true; num = DC_UTILITY_FIRECHANNELCls.getCount(); } if (sv.MENUCODE == "016008") { menu = true; num = DC_UTILITY_FACTORCOLLECTSTATIONCls.getCount(); } if (PageCode == sv.MENUCODE) { if (menu == true) { sb.AppendFormat("<li class=\"title liCur\" onclick=\"window.location.href='{0}';\"><label class=\" {2}\"></label>{1}<font color =\"red\">[{3}]</font></li>\r\n", sv.MENUURL, sv.MENUNAME, sv.LICLASS, num); } else { sb.AppendFormat("<li class=\"title liCur\" onclick=\"window.location.href='{0}';\"><label class=\" {2}\"></label>{1}</li>\r\n", sv.MENUURL, sv.MENUNAME, sv.LICLASS); } indexII = indexI; } else { if (menu == true) { sb.AppendFormat("<li class=\"title {2}\" onclick=\"window.location.href='{0}';\"><label class=\" {2}\"></label>{1}<font color =\"red\">[{3}]</font></li>\r\n", sv.MENUURL, sv.MENUNAME, sv.LICLASS, num); } else { sb.AppendFormat("<li class=\"title {2}\" onclick=\"window.location.href='{0}';\"><label class=\" {2}\"></label>{1}</li>\r\n", sv.MENUURL, sv.MENUNAME, sv.LICLASS); } } } sb.AppendFormat("</ul>\r\n"); sb.AppendFormat("</li>\r\n"); } } } sb.AppendFormat("</ul>\r\n"); string str = ""; str += " <script type=\"text/javascript\">\r\n"; str += " function menuEvent() {"; str += " var $parent_li, $ul, $span;\r\n"; str += " $(\".page-menu li>span\").click(function () {\r\n"; str += " $span = $(this);\r\n"; str += " $parent_li = $span.parent();\r\n"; str += " $parent_li.siblings().children(\"ul\").slideUp();\r\n"; str += " $ul = $span.next(\"ul\");\r\n"; str += " $ul.slideToggle();\r\n"; str += " });\r\n"; str += " $(\".page-menu>li:eq(" + indexII + ")>span\").click();\r\n"; str += " }\r\n"; str += " $(function () {\r\n"; str += " menuEvent();\r\n"; str += " })\r\n"; str += " </script>\r\n"; return(sb.ToString() + str);//008,009,010,011, }
/// <summary> /// ajax 获取各种火情数据 /// </summary> /// <returns></returns> public JsonResult GetFireInfosAjax() { int total = 0; //记录总数 string topOrg = ""; var firetype = Request.Params["firetype"]; //火情类型 string PageSize = Request.Params["PageSize"]; //记录个数 string page = Request.Params["page"]; //页数 if (string.IsNullOrEmpty(firetype)) { return(Json(new Message(false, "没有火情类型", ""))); } var currOrgNo = SystemCls.getCurUserOrgNo(); if (PublicCls.OrgIsXian(currOrgNo))//县 { topOrg = currOrgNo.Substring(0, 6); } else if (PublicCls.OrgIsZhen(currOrgNo))//乡镇 { topOrg = currOrgNo; } var result = JC_FIRECls.getModelPager(new JC_FIRE_SW { curPage = int.Parse(page), pageSize = int.Parse(PageSize), FIREFROM = firetype, TopORGNO = topOrg }, out total); StringBuilder sb = new StringBuilder(); sb.AppendFormat("<table cellpadding=\"0\" cellspacing=\"0\">"); sb.AppendFormat("<thead>"); sb.AppendFormat("<tr>"); sb.AppendFormat("<th>序号</th>"); sb.AppendFormat("<th>区域</th>"); //sb.AppendFormat("<th>经度</th>"); //sb.AppendFormat("<th>纬度</th>"); sb.AppendFormat("<th>接收时间</th>"); //sb.AppendFormat("<th>周围(公里)</th>"); sb.AppendFormat("</tr>"); sb.AppendFormat("</thead>"); sb.AppendFormat("<tbody>"); if (result.Any()) { int i = 0; int rowB = (int.Parse(page) - 1) * int.Parse(PageSize); foreach (var s in result) { if (i % 2 == 0) { // onclick="moveto(@item.JD,@item.WD,'@item.FIRENAME',@item.JCFID);" sb.AppendFormat("<tr style=\"cursor: pointer;\" title='双击行定位' ondblclick=\"moveto(" + s.JD + "," + s.WD + ",'" + s.FIRENAME + "'," + s.JCFID + ")\">"); } else { sb.AppendFormat("<tr style=\"cursor: pointer;\" title='双击行定位' class='row1' ondblclick=\"moveto(" + s.JD + "," + s.WD + ",'" + s.FIRENAME + "'," + s.JCFID + ")\">"); } sb.AppendFormat("<td>{0}</td>", ++rowB); if (s.FIREFROM == "5")//护林员报警 { sb.AppendFormat("<td><font color=\"#FF0000;\">{0}</font></td>", StateSwitch.GetOrgNameByOrgNO(s.BYORGNO)); } else { sb.AppendFormat("<td><font color=\"#FF0000;\">{0}</font></td>", s.ZQWZ); } //sb.AppendFormat("<td>{0}</td>", Convert.ToDouble(s.JD).ToString("f3")); //sb.AppendFormat("<td>{0}</td>", Convert.ToDouble(s.WD).ToString("f3")); sb.AppendFormat("<td>{0}</td>", Convert.ToDateTime(s.RECEIVETIME).ToString("MM-dd HH:mm")); //sb.AppendFormat("<td><select onchange=\"GetHlyInfos(" + s.JD + "," + s.WD + ",'" + s.FIRENAME + "'," + s.JCFID + ")\" id=\"areaselect_{0}\" ><option value=\"0\">请选择</option><option value=\"1\">1</option><option value=\"2\">2</option><option value=\"3\">3</option><option value=\"4\">4</option><option value=\"5\">5</option>/select></td>", s.JCFID); sb.AppendFormat("</tr>"); ++i; } } else { sb.AppendFormat("<tr>"); sb.AppendFormat("<td colspan='5'>未查询出结果</td>"); sb.AppendFormat("</tr>"); } sb.AppendFormat("</tbody>"); sb.AppendFormat("</table>"); string pageInfo = PagerCls.getPagerInfoAjax(new PagerSW { curPage = int.Parse(page), pageSize = int.Parse(PageSize), rowCount = total, hidePageList = true, hidePageSize = true }); return(Json(new MessagePagerAjax(true, sb.ToString(), pageInfo))); }
/// <summary> /// 获取热点个数 /// </summary> /// <returns></returns> public ActionResult GetHotInfoJson() { var result = new List <HotInfoModel>(); var sw = new JC_FIRE_SW(); var curogr = SystemCls.getCurUserOrgNo(); var bo = PublicCls.OrgIsShi(curogr); var bb = PublicCls.OrgIsXian(curogr); var bx = PublicCls.OrgIsZhen(curogr); if (!bo) { sw.BYORGNO = curogr; } sw.isCountIndex = "1"; var list = JC_FIRECls.GetListModel(sw); StringBuilder sb = new StringBuilder(); //遍历火情来源 Array ary = Enum.GetValues(typeof(EnumType)); //array是数组的基类, 无法实例化 bool blnAlarm = false; //是否报警 foreach (int item in ary) { if (item.ToString() != "1") //&& item.ToString() != "6") { string[] arr = new string[5]; int wqs = 0; arr[0] = "0"; if (list.Any()) { var firelist = list.Where(p => p.FIREFROM == item.ToString() && !string.IsNullOrEmpty(p.FIREFROM) && p.ISOUTFIRE != "1" && p.MANSTATE != "19" && p.MANSTATE != "18"); //筛选热点类型 排除已灭的 && ((p.ISOUTFIRE.Trim() == "1" && p.MANSTATE.Trim() != "4") || p.ISOUTFIRE.Trim() != "1") 已在程序中处理 arr[0] = firelist.Count().ToString(); //热点个数 //签收 if (bo) //市 { arr[1] = JC_FIRECls.GetCount("1", item.ToString(), "", "0").ToString(); wqs = JC_FIRECls.GetCount("1", item.ToString(), "", "1"); arr[2] = wqs.ToString(); } else if (bb)//县 { //32 为本级单位签收 arr[1] = JC_FIRECls.GetCount("2,32", item.ToString(), curogr.Substring(0, 6), "0").ToString(); wqs = JC_FIRECls.GetCount("2,32", item.ToString(), curogr.Substring(0, 6), "1"); arr[2] = wqs.ToString(); } else//乡镇 { arr[1] = JC_FIRECls.GetCount("3", item.ToString(), curogr, "0").ToString(); wqs = JC_FIRECls.GetCount("3", item.ToString(), curogr, "1"); arr[2] = wqs.ToString(); } //上报 反馈 if (bo)//市 { arr[3] = firelist.Where(p => p.MANSTATE == "19" || p.MANSTATE == "18").ToList().Count.ToString(); arr[4] = firelist.Where(p => p.MANSTATE == "11" || p.MANSTATE == "15").ToList().Count.ToString(); } else if (bb)//县 { arr[3] = firelist.Where(p => p.MANSTATE == "11" || p.MANSTATE == "19" || p.MANSTATE == "15" || p.MANSTATE == "18").ToList().Count.ToString(); var wfkcount = firelist.Where(p => p.MANSTATE == "31" || p.MANSTATE == "33" || p.MANSTATE == "34").ToList().Count; string count = "0"; if (wqs <= wfkcount)//未反馈中去除未签收 { count = (wfkcount - wqs).ToString(); } arr[4] = count; } else//乡镇 { arr[3] = firelist.Where(p => Convert.ToInt32(p.MANSTATE) > 0 && Convert.ToInt32(p.MANSTATE) < 50).ToList().Count.ToString(); var wfkcount = firelist.Where(p => p.MANSTATE == "0" || p.MANSTATE == "51").ToList().Count; string count = "0"; if (wqs <= wfkcount)//未反馈中去除未签收 { count = (wfkcount - wqs).ToString(); } //arr[4] = "未反馈:" + count; arr[4] = count; } } else { arr[1] = "0"; arr[2] = "0"; arr[3] = "0"; arr[4] = "0"; } string strclass = "wxjk";//卫星报警 if (item == 3) { strclass = "dhbj";//电话报警 } else if (item == 4) { strclass = "dzjk";//电子监控 } else if (item == 5) { strclass = "lwhly";//瞭望护林员 } else if (item == 6) { strclass = "wrjxh"; //无人机巡护 } if (arr[2] != "0" || arr[4] != "0") //未签收 未上报报警 { blnAlarm = true; } sb.AppendFormat("<dl class=\"hqjc\">"); sb.AppendFormat("<dt class=\"floatLeft center\">"); sb.AppendFormat("<p><span class=\"same {1} floatLeft\"></span>|<span class=\"cor_ff0 floatRight\">{0}</span></p>", arr[0], strclass); //sb.AppendFormat("<p><a href='/MainYJJC/YJJCNIndex?typeid={1}' target='_blank'>{0}</a></p>", Enum.GetName(typeof(EnumType), item), item.ToString()); sb.AppendFormat("<p><a onClick=\"ShowFires({1})\" title=\"查看\">{0}</a></p>", Enum.GetName(typeof(EnumType), item), item.ToString()); sb.AppendFormat("</dt>"); sb.AppendFormat("<dd class=\"floatLeft\">"); sb.AppendFormat("<p>已签收:<span class=\"cor_4d9\">{0}</span></p>", arr[1]); sb.AppendFormat("<p>未签收:<span class=\"cor_ff7\">{0}</span></p>", arr[2]); sb.AppendFormat("<p>已上报:<span class=\"cor_4d9\">{0}</span></p>", arr[3]); sb.AppendFormat("<p>未上报:<span class=\"cor_ff7\">{0}</span></p>", arr[4]); sb.AppendFormat("</dd>"); sb.AppendFormat("<div class=\"floatRight\" style=\" margin-top: -20px;\"><p><a href='/MainYJJC/YJJCNIndex?typeid={0}' target='_blank' title=\"查看更多信息\">更多</a> </p></div>", item.ToString()); sb.AppendFormat("<div class=\"clear\"></div>"); sb.AppendFormat("</dl>"); } } if (blnAlarm) { sb.AppendFormat("<audio autoplay='autoplay'> <source src='/Content/albram.mp3' type='audio/mpeg'> </audio>"); } string type = Request.Params["type"];//用于所有页面公用提醒 if (type == "Alarm") { string a = SystemCls.getCurUserOrgNo(); if (string.IsNullOrEmpty(SystemCls.getCurUserOrgNo())) { return(Content(JsonConvert.SerializeObject(new Message(false, "", "")), "text/html;charset=UTF-8")); } if (blnAlarm) { return(Content(JsonConvert.SerializeObject(new Message(true, "<audio autoplay='autoplay'> <source src='/Content/albram.mp3' type='audio/mpeg'> </audio><img src='/images/fireAlarm.gif' width='25' height='30'>", "")), "text/html;charset=UTF-8")); } else { return(Content(JsonConvert.SerializeObject(new Message(true, "", "")), "text/html;charset=UTF-8")); } } return(Content(JsonConvert.SerializeObject(new Message(true, sb.ToString(), "")), "text/html;charset=UTF-8")); }
/// <summary> /// 获取护林员离线 在线 出围 /// </summary> /// <returns></returns> public JsonResult showHLYLineInOrOut() { Message ms = null; string str = Request.Params["obj"]; string curUserOrg = SystemCls.getCurUserOrgNo(); //获取当前登录用户的机构编码 var dataResult = new List <T_IPSFR_USER_Model>(); //护林员结果 if (string.IsNullOrEmpty(str)) { ms = new Message(false, "护林员离在出线参数传参错误", ""); return(Json(ms)); } string hidstr = string.Empty; var sw = new T_IPSFR_USER_SW(); if (str == "0")//护林员在线 { hidstr = T_IPSFR_USERCls.GetHids(curUserOrg, "0"); } else if (str == "1")//护林员离线 { hidstr = T_IPSFR_USERCls.GetHids(curUserOrg, "1"); } else if (str == "2")//护林员出围 { hidstr = T_IPSFR_USERCls.GetHids(curUserOrg, "2"); } sw.HID = hidstr; if (!string.IsNullOrEmpty(hidstr)) { dataResult = T_IPSFR_USERCls.getListModel(sw).ToList(); } StringBuilder sb = new StringBuilder(); int i = 0; sb.AppendFormat("<div class=\"divTable\">"); sb.AppendFormat("<table cellpadding=\"0\" cellspacing=\"0\">"); sb.AppendFormat("<thead>"); sb.AppendFormat("<tr>"); sb.AppendFormat("<th>序号</th>"); sb.AppendFormat("<th>单位</th>"); sb.AppendFormat("<th>姓名</th>"); sb.AppendFormat("<th>电话</th>"); sb.AppendFormat("</tr>"); sb.AppendFormat("</thead>"); sb.AppendFormat("<tbody role=\"alert\" aria-live=\"polite\" aria-relevant=\"all\">"); if (dataResult.Any()) { foreach (var person in dataResult) { if (i % 2 == 0) { sb.AppendFormat("<tr>"); } else { sb.AppendFormat("<tr class='row1'>"); } sb.AppendFormat("<td class=\"center\">{0}</td>", ++i); sb.AppendFormat("<td class=\"center\">{0}</td>", person.ORGNAME); sb.AppendFormat("<td class=\"center\">{0}</td>", person.HNAME); sb.AppendFormat("<td class=\"center\">{0}</td>", person.PHONE); sb.AppendFormat("</tr>"); } } else { sb.AppendFormat("<td colspan=\"4\"><em>暂无信息</em></td>"); } sb.AppendFormat("</tbody>"); sb.AppendFormat("</table>"); sb.AppendFormat("</div>"); ms = new Message(true, sb.ToString(), ""); return(Json(ms)); }
/// <summary> /// 检索报警信息列表Html /// </summary> /// <returns></returns> public JsonResult GetAlarmAjax() { Message ms = null; StringBuilder sb = new StringBuilder(); sb.AppendFormat("<table cellpadding=\"0\" cellspacing=\"0\">"); sb.AppendFormat("<thead>"); sb.AppendFormat("<tr> "); sb.AppendFormat("<th>序号</th>"); sb.AppendFormat("<th>报警单位</th>"); sb.AppendFormat("<th>报警人</th>"); sb.AppendFormat("<th>电话号码</th>"); sb.AppendFormat("<th>报警时间</th>"); sb.AppendFormat("<th>状态</th>"); sb.AppendFormat("<th>操作</th>"); sb.AppendFormat("</tr>"); sb.AppendFormat("</thead>"); sb.AppendFormat("<tbody>"); string txtAlarmStartTime = Request.Params["txtAlarmStartTime"]; //开始时间 string txtAlarmEndTime = Request.Params["txtAlarmEndTime"]; //结束时间 string status = Request.Params["status"]; //处理结果 var sw = new T_IPS_ALARM_SW(); sw.DateBegin = txtAlarmStartTime; sw.DateEnd = txtAlarmEndTime; sw.orgNo = SystemCls.getCurUserOrgNo(); if (status != "2")//0 未处理1已处理 2全部 { sw.MANSTATE = status; } var list = T_IPS_ALARMCls.getModelList(sw); if (list.Any()) { int i = 0; foreach (var item in list) { sb.AppendFormat("<tr>"); sb.AppendFormat("<td>{0}</td>", ++i); sb.AppendFormat("<td>{0}</td>", item.OrgNoName); sb.AppendFormat("<td>{0}</td>", item.HName); sb.AppendFormat("<td>{0}</td>", item.PHONE); sb.AppendFormat("<td>{0}</td>", item.ALARMTIME); if (item.MANSTATE == "0") { sb.AppendFormat("<td><a class=\"label label-danger\">未处理</a></td>"); } else { sb.AppendFormat("<td><a class=\"label label-success\">已处理</a></td>"); } sb.AppendFormat("<td><a href=\"javascript:void(0);\" onClick=\"getLocaAlarm(" + item.ALARMID + ")\">定位</a></td>"); sb.AppendFormat("</tr>"); } } else { sb.AppendFormat("<tr>"); sb.AppendFormat("<td colspan=\"7\">暂无报警信息</td>"); sb.AppendFormat("</tr>"); } sb.AppendFormat("</tbody>"); sb.AppendFormat("</table>"); ms = new Message(true, sb.ToString(), ""); return(Json(ms)); }
/// <summary> /// 获取查询结果json字符串 /// </summary> /// <param name="m"></param> /// <returns></returns> public static string getJsonStr(DUTY_USER_Model m) { DateTime dtBegin = Convert.ToDateTime(m.dateBegin); DateTime dtEnd = Convert.ToDateTime(m.dateEnd); char[] specialChars = new char[] { ',' }; string strname = ""; string strid = ""; string strTitle = ""; //标题 string strZID = ""; //DUTYCLASSID string strBanCi = ""; //用作前台判断班次 string JSONstring = "["; var list = DUTY_CLASSCls.GetListModel(new DUTY_CLASS_SW { BYORGNO = SystemCls.getCurUserOrgNo() }).Select(p => p.DUTYCLASSID).ToList(); //查询当前组织机构有几个班次 var result = DUTY_USERCls.getListModel(new DUTY_USER_SW { BYORGNO = SystemCls.getCurUserOrgNo(), DTBegin = m.dateBegin, DTEnd = m.dateEnd }); if (result.Any()) { var datelist = result.Select(p => p.DUTYDATE).ToList(); var date = datelist.Distinct();//当前日期集合 for (DateTime dt = dtBegin; dt < dtEnd; dt = dt.AddDays(1)) { foreach (var item in date) { if (list.Count > 0 && item == dt.ToString("yyyy-MM-dd")) { var length = list.Count + 2; for (int k = 0; k < length; k++) { if (k == length - 2) { m.DUTYUSERTYPE = "-1"; strname = "带班领导:"; } else if (k == length - 1) { m.DUTYUSERTYPE = "-2"; strname = "总带班领导:"; } else if (list[k] == "1") { m.DUTYUSERTYPE = "1"; strname = "早班:"; strBanCi += "1,"; } else if (list[k] == "2") { m.DUTYUSERTYPE = "2"; strname = "中班:"; strBanCi += "2,"; } else if (list[k] == "3") { m.DUTYUSERTYPE = "3"; strname = "晚班:"; strBanCi += "3,"; } var str1 = result.Where(p => p.DUTYUSERTYPE == m.DUTYUSERTYPE && p.DUTYDATE == dt.ToString("yyyy-MM-dd")).Select(p => p.USERNAME).ToList(); //姓名 var str2 = result.Where(p => p.DUTYUSERTYPE == m.DUTYUSERTYPE && p.DUTYDATE == dt.ToString("yyyy-MM-dd")).Select(p => p.DUTYUSERID).ToList(); //DUTYUSERID if (str1.Count > 0) { if (str1.Count > 1) { for (int j = 0; j < str1.Count; j++) { if (j == str1.Count - 1) { strname += str1[j]; strid += str2[j]; } else { strname += str1[j] + ","; strid += str2[j] + ","; } } } else { strname += str1[0]; strid = str2[0]; } } strTitle += strname + "\\r\\n"; strZID += strid + "|"; strname = ""; strid = ""; } JSONstring += "{"; JSONstring += "\"title\":\"" + strTitle + "\","; JSONstring += "\"id\":\"" + strZID + "\","; JSONstring += "\"banci\":\"" + strBanCi + "\","; JSONstring += "\"start\":\"" + dt.ToString("yyyy-MM-dd") + "\""; JSONstring += "},"; strTitle = ""; strZID = ""; strBanCi = ""; } } } } JSONstring = JSONstring.TrimEnd(specialChars); JSONstring += "]"; //var str = JSONstring.ToString().Replace("\"", "\\\"").Replace("\r\n", "<br/>").Replace("\n", "<br/>").Replace("\r", "<br/>"); return(JSONstring.ToString()); }