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