/// <summary> /// 删除、处理 /// </summary> /// <param name="m">参见模型T_IPS_ALARM_Model</param> /// <returns>参见模型Manager</returns> public static Message Manager(T_IPS_ALARM_Model m) { if (m.opMethod == "Del") { T_IPS_ALARM_Model m1 = getModel(new T_IPS_ALARM_SW { ALARMID = m.ALARMID }); SystemCls.LogSave("5", "报警处理:" + m.PHONE, ClsStr.getModelContent(m1)); Message msgUser = BaseDT.T_IPS_ALARM.Del(m); return(new Message(msgUser.Success, msgUser.Msg, "")); } if (m.opMethod == "Man") { T_IPS_ALARM_Model m1 = getModel(new T_IPS_ALARM_SW { ALARMID = m.ALARMID }); SystemCls.LogSave("4", "报警处理:" + m.PHONE, ClsStr.getModelContent(m1)); Message msgUser = BaseDT.T_IPS_ALARM.Man(m); return(new Message(msgUser.Success, msgUser.Msg, "")); } return(new Message(false, "无效操作", "")); }
/// <summary> /// 保存登录状态 /// </summary> /// <param name="m">参见CookieModel</param> public static void SaveLoginState(CookieModel m) { ClearLoginState(); string str = ""; str += ClsStr.EncryptA01(m.UID, "DKIDLEKD") + ","; str += ClsStr.EncryptA01(m.userName, "DKIDLEKD") + ","; str += ClsStr.EncryptA01(m.trueName, "DKIDLEKD") + ","; str = ClsStr.EncryptA01(str, "LOKUDJIE"); System.Web.HttpContext.Current.Session["SpringerSystemSession"] = str; if (m.SaveType == "false") { } else { HttpCookie _cookie = new HttpCookie("SpringerSystem"); switch (m.SaveType) { case "true": _cookie.Expires = DateTime.Now.AddYears(1); //.AddDays(1); break; default: _cookie.Expires = DateTime.Now.AddMinutes(10); //.AddYears(1);//.AddMinutes(10);//保存10分钟 break; } _cookie.Values.Add("SpringerSystemCookie", str); HttpContext.Current.Response.Cookies.Add(_cookie); } }
/// <summary> /// 获取用户登录信息 /// </summary> /// <returns>用户登录信息 参见CookieModel</returns> public static CookieModel getCookieInfo() { CookieModel model = new CookieModel(); string cookieStr = ""; if (System.Web.HttpContext.Current.Session["SpringerSystemSession"] != null) { cookieStr = System.Web.HttpContext.Current.Session["SpringerSystemSession"].ToString(); } HttpCookie cookies = HttpContext.Current.Request.Cookies["SpringerSystem"]; if (string.IsNullOrEmpty(cookieStr) && cookies != null) { cookieStr = cookies["SpringerSystemCookie"]; } //if (HttpContext.Current.Request.Cookies["SpringerSystem"] != null) //{ // cookieStr = HttpContext.Current.Request.Cookies["SpringerSystem"]["SpringerSystemCookie"]; //} if (!string.IsNullOrEmpty(cookieStr)) { string[] arr = ClsStr.DecryptA01(cookieStr, "LOKUDJIE").Split(','); model.UID = ClsStr.DecryptA01(arr[0], "DKIDLEKD"); model.userName = ClsStr.DecryptA01(arr[1], "DKIDLEKD"); model.trueName = ClsStr.DecryptA01(arr[2], "DKIDLEKD"); } else { model.UID = ""; model.userName = ""; model.trueName = ""; } return(model); }
/// <summary> /// 删除、处理 /// </summary> /// <param name="m">参见模型T_IPS_HOTS_Model</param> /// <returns>参见模型Message</returns> public static Message Manager(T_IPS_HOTS_Model m) { if (m.opMethod == "Del") { T_IPS_HOTS_Model m1 = getModel(new T_IPS_HOTS_SW { HOTSID = m.HOTSID }); SystemCls.LogSave("5", "热点处理:" + m1.FXSJ, ClsStr.getModelContent(m1)); Message msgUser = BaseDT.T_IPS_HOTS.Del(m); return(new Message(msgUser.Success, msgUser.Msg, "")); } if (m.opMethod == "Man") { T_IPS_HOTS_Model m1 = getModel(new T_IPS_HOTS_SW { HOTSID = m.HOTSID }); SystemCls.LogSave("4", "热点处理:" + m1.FXSJ, ClsStr.getModelContent(m1)); Message msgUser = BaseDT.T_IPS_HOTS.Man(m); return(new Message(msgUser.Success, msgUser.Msg, "")); } return(new Message(false, "无效操作", "")); }
/// <summary> /// 增、删、改 /// </summary> /// <param name="m">参见模型T_IPSFR_ROUTERAIL_Model</param> /// <returns>参见模型Message</returns> public static Message Manager(T_IPSFR_ROUTERAIL_Model m) { if (m.opMethod == "Add") { SystemCls.LogSave("3", "护林员路线添加:" + m.HID, ClsStr.getModelContent(m)); Message msg = BaseDT.T_IPSFR_ROUTERAIL.Add(m); return(new Message(msg.Success, msg.Msg, "")); } if (m.opMethod == "AddBatch") { SystemCls.LogSave("3", "护林员路线添加:" + m.HID, ClsStr.getModelContent(m)); Message msg = BaseDT.T_IPSFR_ROUTERAIL.AddBatch(m); return(new Message(msg.Success, msg.Msg, "")); } if (m.opMethod == "Mdy") { SystemCls.LogSave("4", "护林员路线修改:" + m.HID, ClsStr.getModelContent(m)); Message msg = BaseDT.T_IPSFR_ROUTERAIL.Mdy(m); return(new Message(msg.Success, msg.Msg, "")); } if (m.opMethod == "Del") { SystemCls.LogSave("5", "护林员路线删除:" + m.HID, ClsStr.getModelContent(m)); Message msg = BaseDT.T_IPSFR_ROUTERAIL.Del(m); return(new Message(msg.Success, msg.Msg, "")); } if (m.opMethod == "DelBatch") { SystemCls.LogSave("5", "护林员路线删除:" + m.HID, ClsStr.getModelContent(m)); Message msg = BaseDT.T_IPSFR_ROUTERAIL.DelBatch(m); return(new Message(msg.Success, msg.Msg, "")); } return(new Message(false, "无效操作", "")); }
/// <summary> /// 增、删、改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Manager(JC_PERALARM_Model m) { if (m.opMethod == "Add") { string[] arr = m.BYORGNOLIST.Split(','); for (int i = 0; i < arr.Length; i++) { m.BYORGNO = arr[i]; BaseDT.JC_PERALARM.Add(m); } SystemCls.LogSave("3", "群众报警:" + m.PERALARMID, ClsStr.getModelContent(m)); return(new Message(true, "添加成功", m.returnUrl)); } if (m.opMethod == "Mdy") { SystemCls.LogSave("4", "群众报警:" + m.PERALARMID, ClsStr.getModelContent(m)); Message msgUser = BaseDT.JC_PERALARM.Mdy(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } if (m.opMethod == "Del") { SystemCls.LogSave("5", "群众报警:" + m.PERALARMID, ClsStr.getModelContent(m)); Message msgUser = BaseDT.JC_PERALARM.Del(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } if (m.opMethod == "Man") { SystemCls.LogSave("5", "群众报警:" + m.PERALARMID, ClsStr.getModelContent(m)); Message msgUser = BaseDT.JC_PERALARM.Man(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } return(new Message(false, "无效操作", "")); }
/// <summary> /// 增、删、改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Manager(JC_FIRE_Model m) { if (m.opMethod == "Add") { SystemCls.LogSave("3", "转为火情:" + m.FIRENAME, ClsStr.getModelContent(m)); Message msgUser = BaseDT.JC_FIRE.Add(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } if (m.opMethod == "Mdy") { Message msgUser = BaseDT.JC_FIRE.Mdy(m); return(new Message(msgUser.Success, msgUser.Msg, "")); } if (m.opMethod == "AddWX") { Message msgUser = BaseDT.JC_FIRE.Add(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } if (m.opMethod == "PLAdd") { Message msgUser = BaseDT.JC_FIRE.PLAdd(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } if (m.opMethod == "PLEnd") { Message msgUser = BaseDT.JC_FIRE.PLEnd(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } return(new Message(false, "无效操作", "")); }
/// <summary> /// 添加 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Add(T_SYSSEC_IPSUSER_Model m) { if (isExists(new T_SYSSEC_IPSUSER_SW { LOGINUSERNAME = m.LOGINUSERNAME }) == true) { return(new Message(false, "添加失败,登陆名重复请重新输入!", "")); } StringBuilder sb = new StringBuilder(); sb.AppendFormat("INSERT INTO T_SYSSEC_USER(ORGNO,LOGINUSERNAME,USERNAME,USERPWD,REGISTERTIME,LOGINNUM,NOTE,DEPARTMENT)"); sb.AppendFormat("VALUES("); sb.AppendFormat("'{0}'", ClsSql.EncodeSql(m.ORGNO)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.LOGINUSERNAME)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.USERNAME)); sb.AppendFormat(",'{0}'", ClsStr.getSystemManMd5(ClsSql.EncodeSql(m.USERPWD))); sb.AppendFormat(",'{0}'", PublicClassLibrary.ClsSwitch.SwitTM(DateTime.Now)); sb.AppendFormat(",'{0}'", "0"); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.NOTE)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.DEPARTMENT)); sb.AppendFormat(")"); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "添加成功!", "")); } else { return(new Message(false, "添加失败,请检查各输入框是否正确!", "")); } }
/// <summary> /// 出围查询Json /// </summary> /// <returns></returns> public ActionResult getOutRaiLCountJson() { OutRaiLCount_SW sw = new OutRaiLCount_SW(); sw.TopORGNO = Request.Params["BYORGNO"]; sw.DateBegin = Request.Params["TIMEBegin"]; sw.DateEnd = Request.Params["TIMEEnd"]; var list = HUCheckCls.getOutRaiLCountModel(sw); StringBuilder sb = new StringBuilder(); DateTime dt1 = Convert.ToDateTime(sw.DateBegin); DateTime dt2 = Convert.ToDateTime(sw.DateEnd); int days = ClsStr.getDateDiff(sw.DateBegin, sw.DateEnd) + 1;//日期包含天数 sb.AppendFormat("<table cellpadding=\"0\" cellspacing=\"0\">"); sb.AppendFormat("<thead>"); sb.AppendFormat(" <tr>"); sb.AppendFormat(" <th rowspan=\"2\">单位<br>(姓名)</th>"); sb.AppendFormat(" <th rowspan=\"2\">出围合计</th>"); sb.AppendFormat(" <th colspan=\"{1}\">{0}</th>", "日期(日)", days.ToString()); sb.AppendFormat(" </tr>"); sb.AppendFormat(" <tr>"); for (DateTime tm = dt1; tm <= dt2; tm = tm.AddDays(1)) { sb.AppendFormat(" <th>{0}</th>", tm.ToString("dd")); } sb.AppendFormat(" </tr>"); sb.AppendFormat("</thead>"); sb.AppendFormat("<tbody>"); //var list = HUCheckCls.getCheckInModel(new HUCheckINCount_SW { DateBegin = arr[1], DateEnd = arr[2], ORGNO = arr[0], HUNM = arr[3] }); int j = 0; foreach (var v in list) { string orgName = v.ORGName; string orgNo = v.ORGNo; j++; if (j % 2 == 0) { sb.AppendFormat("<tr>"); } else { sb.AppendFormat("<tr class='row1'>"); } sb.AppendFormat("<td class=\"center\">{0}</td>", v.ORGName); sb.AppendFormat("<td class=\"center\">{0}</td>", v.Count);//总 string[] arr1 = v.DayCountList.Split(','); for (int i = 0; i < days; i++) { sb.AppendFormat("<td class=\"center\">{0}</td>", arr1[i]); } sb.AppendFormat("</tr>"); } sb.AppendFormat("</tbody>"); sb.AppendFormat("</table>"); return(Content(JsonConvert.SerializeObject(new Message(true, sb.ToString(), "")), "text/html;charset=UTF-8")); }
/// <summary> /// 增、删、改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Manager(T_SYSSEC_ROLE_Model m) { if (m.opMethod == "Add") { SystemCls.LogSave("3", "角色:" + m.ROLENAME, ClsStr.getModelContent(m)); Message msg0 = BaseDT.T_SYSSEC_ROLE.Add(m); if (msg0.Success == false) { return(new Message(msg0.Success, msg0.Msg, "")); } //获取新添加的UserID DataTable dt = BaseDT.T_SYSSEC_ROLE.getDT(new T_SYSSEC_ROLE_SW { ROLENAME = m.ROLENOTE, SYSFLAG = m.SYSFLAG }); string ID = ""; if (dt.Rows.Count > 0) { ID = dt.Rows[0]["ROLEID"].ToString(); } dt.Clear(); dt.Dispose(); Message msg = BaseDT.T_SYSSEC_ROLE_RIGHT.Save(new T_SYSSEC_ROLE_RIGHT_Model { RIGHTID = m.rightIDList, ROLEID = m.ROLEID }); return(new Message(true, "添加成功!", m.returnUrl)); } if (m.opMethod == "Mdy") { SystemCls.LogSave("4", "角色:" + m.ROLENAME, ClsStr.getModelContent(m)); Message msg0 = BaseDT.T_SYSSEC_ROLE.Mdy(m); if (msg0.Success == false) { return(new Message(msg0.Success, msg0.Msg, "")); } Message msg = BaseDT.T_SYSSEC_ROLE_RIGHT.Save(new T_SYSSEC_ROLE_RIGHT_Model { RIGHTID = m.rightIDList, ROLEID = m.ROLEID }); return(new Message(true, "修改成功!", m.returnUrl)); } if (m.opMethod == "Del") { SystemCls.LogSave("5", "角色:" + m.ROLENAME, ClsStr.getModelContent(m)); Message msgUser = BaseDT.T_SYSSEC_ROLE.Del(m); if (msgUser.Success == false) { return(new Message(msgUser.Success, msgUser.Msg, "")); } Message msg = BaseDT.T_SYSSEC_ROLE_RIGHT.Save(new T_SYSSEC_ROLE_RIGHT_Model { RIGHTID = "", ROLEID = m.ROLEID }); return(new Message(true, "删除成功!", m.returnUrl)); } return(new Message(false, "无效操作", "")); }
/// <summary> /// 删除、处理 /// </summary> /// <param name="m">参见模型T_IPSCOL_COLLECT_Model</param> /// <returns>参见模型Message</returns> public static Message Manager(T_IPSCOL_COLLECT_Model m) { if (m.opMethod == "Del") { SystemCls.LogSave("5", "采集删除序号:" + m.COLLECTID, ClsStr.getModelContent(m)); Message msgUser = BaseDT.T_IPSCOL_COLLECT.Del(new T_IPSCOL_COLLECT_SW { COLLECTID = m.COLLECTID }); return(new Message(msgUser.Success, msgUser.Msg, "")); } if (m.opMethod == "DelDetail") { SystemCls.LogSave("5", "采集明细删除序号:" + m.COLLECTDETAILID, ClsStr.getModelContent(m)); Message msgUser = BaseDT.T_IPSCOL_COLLECT.DelDetail(new T_IPSCOL_COLLECT_SW { COLLECTDETAILID = m.COLLECTDETAILID }); return(new Message(msgUser.Success, msgUser.Msg, "")); } if (m.opMethod == "ModifyDetail") { SystemCls.LogSave("9", "数据采集坐标点修改" + m.COLLECTID, ClsStr.getModelContent(m)); Message msg = BaseDT.T_IPSCOL_COLLECT.DelDetail(new T_IPSCOL_COLLECT_SW { COLLECTID = m.COLLECTID }); if (msg.Success == true) { Message msgUser = null; foreach (var item in m.DataList) { msgUser = BaseDT.T_IPSCOL_COLLECT.AddDetail(item); } return(new Message(msgUser.Success, "数据采集坐标点修改成功!", "")); } return(new Message(msg.Success, "数据采集坐标点修改失败!", "")); } if (m.opMethod == "DelUpload") { SystemCls.LogSave("5", "采集文件删除序号:" + m.COLLECTUPLOADID, ClsStr.getModelContent(m)); Message msgUser = BaseDT.T_IPSCOL_COLLECT.DelUpload(new T_IPSCOL_COLLECT_SW { COLLECTUPLOADID = m.COLLECTUPLOADID }); return(new Message(msgUser.Success, msgUser.Msg, "")); } if (m.opMethod == "Man") { SystemCls.LogSave("4", "采集处理:" + m.COLLECTDETAILID, ClsStr.getModelContent(m)); Message msgUser = BaseDT.T_IPSCOL_COLLECT.Man(m); return(new Message(msgUser.Success, msgUser.Msg, "")); } return(new Message(false, "无效操作", "")); }
/// <summary> /// 查询时,跳转页面 /// </summary> /// <returns>参见模型</returns> public ActionResult CollectCountquery() { string BYORGNO = Request.Params["BYORGNO"]; string TIMEBegin = Request.Params["TIMEBegin"]; string TIMEEnd = Request.Params["TIMEEnd"]; string HUNM = Request.Params["HUNM"]; string str = ClsStr.EncryptA01(BYORGNO + "|" + TIMEBegin + "|" + TIMEEnd + "|||", "kkkkkkkk"); return(Content(JsonConvert.SerializeObject(new Message(true, "", "/HUReport/CollectCount?trans=" + str)), "text/html;charset=UTF-8")); }
/// <summary> /// 搜索 /// </summary> /// <returns></returns> public ActionResult DocQuery() { string PageSize = Request.Params["PageSize"]; string Page = Request.Params["Page"]; string EMAILTITLE = Request.Params["TITLE"]; string tid = Request.Params["tid"]; pubViewBag(tid, tid, ""); string str = ClsStr.EncryptA01((PageSize + "|" + EMAILTITLE + "|" + tid), "kkkkkkkk"); return(Content(JsonConvert.SerializeObject(new Message(true, "", "/ArtDocument/DocIndex?trans=" + str + "&typeID=" + tid + "&page=" + Page)), "text/html;charset=UTF-8")); }
/// <summary> /// 增、删、改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message ManagerPhoto(JC_INFRAREDCAMERA_PHOTO_Model m) { if (m.opMethod == "Del") { SystemCls.LogSave("5", "红外相机图片:" + m.smid, ClsStr.getModelContent(m)); Message msgUser = BaseDT.JC_INFRAREDCAMERA_PHOTO.Del(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } if (m.opMethod == "Man") { SystemCls.LogSave("5", "红外相机图片:" + m.smid, ClsStr.getModelContent(m)); Message msgUser = BaseDT.JC_INFRAREDCAMERA_PHOTO.Man(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } return(new Message(false, "无效操作", "")); }
/// <summary> /// 数据采集处理 /// </summary> /// <param name="m">参见模型T_COLLECTLINES_Model</param> /// <returns>参见模型Message</returns> public static Message Manager(T_COLLECTLINES_Model m) { if (m.opMethod == "ADD") { T_COLLECTLINES_SW sw = new T_COLLECTLINES_SW(); var id = BaseDT.T_COLLECTLINES.GetLineMaxObjID(); sw.OBJECTID = Convert.ToInt32(id) + 1; sw.NAME = m.NAME; sw.TypeId = m.TypeId; sw.Shape = m.Shape; SystemCls.LogSave("11", "空间线:" + m.NAME, ClsStr.getModelContent(m)); Message msgUser = BaseDT.T_COLLECTLINES.AddLines(sw); return(new Message(msgUser.Success, msgUser.Msg, "")); } return(new Message(false, "无效操作", "")); }
/// <summary> /// 增、删、改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Manager(T_SYSSEC_RIGHT_Model m) { if (m.opMethod == "Add") { SystemCls.LogSave("3", "权限:" + m.RIGHTNAME, ClsStr.getModelContent(m)); return(BaseDT.T_SYSSEC_RIGHT.Add(m)); } if (m.opMethod == "Mdy") { SystemCls.LogSave("4", "权限:" + m.RIGHTNAME, ClsStr.getModelContent(m)); return(BaseDT.T_SYSSEC_RIGHT.Mdy(m)); } if (m.opMethod == "Del") { SystemCls.LogSave("5", "权限:" + m.RIGHTNAME, ClsStr.getModelContent(m)); return(BaseDT.T_SYSSEC_RIGHT.Del(m)); } return(new Message(false, "无效操作", "")); }
/// <summary> /// 删除、处理 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Manager(T_IPSRPT_REPORT_Model m) { if (m.opMethod == "Del") { SystemCls.LogSave("5", "上报删除序号:" + m.REPORTID, ClsStr.getModelContent(m)); Message msgUser = BaseDT.T_IPSRPT_REPORT.Del(new T_IPSRPT_REPORT_SW { REPORTID = m.REPORTID }); return(new Message(msgUser.Success, msgUser.Msg, "")); } if (m.opMethod == "DelDetail") { SystemCls.LogSave("5", "上报明细删除序号:" + m.REPORTDETAILID, ClsStr.getModelContent(m)); Message msgUser = BaseDT.T_IPSRPT_REPORT.DelDetail(new T_IPSRPT_REPORT_SW { REPORTDETAILID = m.REPORTDETAILID }); return(new Message(msgUser.Success, msgUser.Msg, "")); } if (m.opMethod == "DelUpload") { SystemCls.LogSave("5", "上报文件删除序号:" + m.REPORTUPLOADID, ClsStr.getModelContent(m)); Message msgUser = BaseDT.T_IPSRPT_REPORT.DelUpload(new T_IPSRPT_REPORT_SW { REPORTUPLOADID = m.REPORTUPLOADID }); return(new Message(msgUser.Success, msgUser.Msg, "")); } if (m.opMethod == "Man") { SystemCls.LogSave("4", "上报处理:" + m.REPORTDETAILID, ClsStr.getModelContent(m)); Message msgUser = BaseDT.T_IPSRPT_REPORT.Man(m); return(new Message(msgUser.Success, msgUser.Msg, "")); } return(new Message(false, "无效操作", "")); }
/// <summary> /// 增、删、改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Manager(T_SYS_ADDREDDBOOK_Model m) { if (m.opMethod == "Add") { SystemCls.LogSave("3", "通讯录:" + m.ADNAME, ClsStr.getModelContent(m)); Message msgUser = BaseDT.T_SYS_ADDREDDBOOK.Add(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } if (m.opMethod == "Mdy") { SystemCls.LogSave("4", "通讯录:" + m.ADNAME, ClsStr.getModelContent(m)); Message msgUser = BaseDT.T_SYS_ADDREDDBOOK.Mdy(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } if (m.opMethod == "Del") { SystemCls.LogSave("5", "通讯录:" + m.ADNAME, ClsStr.getModelContent(m)); Message msgUser = BaseDT.T_SYS_ADDREDDBOOK.Del(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } return(new Message(false, "无效操作", "")); }
/// <summary> /// 增、删、改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Manager(T_SYS_NOTICE_Model m) { if (m.opMethod == "Add") { SystemCls.LogSave("3", "通知公告:" + m.INFOTITLE, ClsStr.getModelContent(m)); Message msgUser = BaseDT.T_SYS_NOTICE.Add(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } if (m.opMethod == "Mdy") { SystemCls.LogSave("4", "通知公告:" + m.INFOTITLE, ClsStr.getModelContent(m)); Message msgUser = BaseDT.T_SYS_NOTICE.Mdy(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } if (m.opMethod == "Del") { SystemCls.LogSave("5", "通知公告:" + m.INFOTITLE, ClsStr.getModelContent(m)); Message msgUser = BaseDT.T_SYS_NOTICE.Del(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } return(new Message(false, "无效操作", "")); }
/// <summary> /// 增、删、改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Manager(JC_MONITOR_BASICINFO_Model m) { if (m.opMethod == "Add") { SystemCls.LogSave("3", "电子监控基本信息:" + m.EMNAME, ClsStr.getModelContent(m)); Message msgUser = BaseDT.JC_MONITOR_BASICINFO.Add(m); if (msgUser.Success == true) { Message msgUser1 = BaseDT.JC_MONITOR_BASICINFO.AddSHIPINGJIANKONG(m, msgUser.Url);//添加三维库 return(new Message(msgUser1.Success, msgUser1.Msg, m.returnUrl)); } return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } if (m.opMethod == "Mdy") { SystemCls.LogSave("4", "电子监控基本信息:" + m.EMNAME, ClsStr.getModelContent(m)); Message msgUser = BaseDT.JC_MONITOR_BASICINFO.Mdy(m); if (msgUser.Success == true) { Message msgUser1 = BaseDT.JC_MONITOR_BASICINFO.MdySHIPINGJIANKONG(m);//添加三维库 return(new Message(msgUser1.Success, msgUser1.Msg, m.returnUrl)); } return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } if (m.opMethod == "Del") { SystemCls.LogSave("5", "电子监控基本信息:" + m.EMNAME, ClsStr.getModelContent(m)); Message msgUser = BaseDT.JC_MONITOR_BASICINFO.Del(m); if (msgUser.Success == true) { Message msgUser1 = BaseDT.JC_MONITOR_BASICINFO.DelSHIPINGJIANKONG(m);//添加三维库 return(new Message(msgUser1.Success, msgUser1.Msg, m.returnUrl)); } return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } return(new Message(false, "无效操作", "")); }
/// <summary> /// 修改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Mdy(T_SYSSEC_IPSUSER_Model m) { if (string.IsNullOrEmpty(m.USERID)) { return(new Message(false, "修改失败,无效的用户序号!", "")); } if (isExists(new T_SYSSEC_IPSUSER_SW { USERID = m.USERID }) == false) { return(new Message(false, "修改失败,用户名不存在!", "")); } StringBuilder sb = new StringBuilder(); sb.AppendFormat("UPDATE T_SYSSEC_USER"); sb.AppendFormat(" set "); sb.AppendFormat("ORGNO='{0}'", ClsSql.EncodeSql(m.ORGNO)); sb.AppendFormat(",LOGINUSERNAME='******'", ClsSql.EncodeSql(m.LOGINUSERNAME)); sb.AppendFormat(",USERNAME='******'", ClsSql.EncodeSql(m.USERNAME)); if (string.IsNullOrEmpty(m.USERPWD) == false) { sb.AppendFormat(",USERPWD='{0}'", ClsStr.getSystemManMd5(ClsSql.EncodeSql(m.USERPWD))); } sb.AppendFormat(" ,NOTE= '{0}'", ClsSql.EncodeSql(m.NOTE)); sb.AppendFormat(" ,DEPARTMENT= '{0}'", ClsSql.EncodeSql(m.DEPARTMENT)); sb.AppendFormat(" where USERID= '{0}'", ClsSql.EncodeSql(m.USERID)); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "修改成功!", "")); } else { return(new Message(false, "修改失败,请检查各输入框是否正确!", "")); } }
/// <summary> /// 增、删、改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Manager(YJ_WEATHER_Model m) { if (m.opMethod == "Add") { SystemCls.LogSave("3", "气象信息:" + m.WEATHERID, ClsStr.getModelContent(m)); Message msgUser = BaseDT.YJ_WEATHER.Add(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } //if (m.opMethod == "Mdy") //{ // SystemCls.LogSave("4", "气象信息:" + m.EMNAME, ClsStr.getModelContent(m)); // Message msgUser = BaseDT.YJ_WEATHER.Mdy(m); // return new Message(msgUser.Success, msgUser.Msg, m.returnUrl); //} //if (m.opMethod == "Del") //{ // SystemCls.LogSave("5", "气象信息:" + m.EMNAME, ClsStr.getModelContent(m)); // Message msgUser = BaseDT.YJ_WEATHER.Del(m); // return new Message(msgUser.Success, msgUser.Msg, m.returnUrl); //} return(new Message(false, "无效操作", "")); }
/// <summary> /// 增、删、改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message ManagerMonitor(JC_MONITOR_Model m) { if (m.opMethod == "Add") { SystemCls.LogSave("3", "电子监控火情信息图片:" + m.IMBID, ClsStr.getModelContent(m)); Message msgUser = BaseDT.JC_MONITOR.Add(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } if (m.opMethod == "Del") { SystemCls.LogSave("5", "电子监控火情信息图片:" + m.IMBID, ClsStr.getModelContent(m)); Message msgUser = BaseDT.JC_MONITOR.Del(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } if (m.opMethod == "Man") { SystemCls.LogSave("5", "电子监控火情信息图片:" + m.IMBID, ClsStr.getModelContent(m)); Message msgUser = BaseDT.JC_MONITOR.Man(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } return(new Message(false, "无效操作", "")); }
/// <summary> /// 增、删、改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Manager(JC_INFRAREDCAMERA_BASICINFO_Model m) { if (m.opMethod == "Add") { SystemCls.LogSave("3", "红外相机:" + m.INFRAREDCAMERANAME, ClsStr.getModelContent(m)); Message msgUser = BaseDT.JC_INFRAREDCAMERA_BASICINFO.Add(m); if (msgUser.Success == true) { Message msgUser1 = BaseDT.JC_INFRAREDCAMERA_BASICINFO.AddHONGWAIXIANGJI(m, msgUser.Url);//添加三维库 return(new Message(msgUser1.Success, msgUser1.Msg, m.returnUrl)); } return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } if (m.opMethod == "Mdy") { SystemCls.LogSave("4", "红外相机:" + m.INFRAREDCAMERANAME, ClsStr.getModelContent(m)); Message msgUser = BaseDT.JC_INFRAREDCAMERA_BASICINFO.Mdy(m); if (msgUser.Success == true) { Message msgUser1 = BaseDT.JC_INFRAREDCAMERA_BASICINFO.MdyHONGWAIXIANGJI(m);//添加三维库 return(new Message(msgUser1.Success, msgUser1.Msg, m.returnUrl)); } return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } if (m.opMethod == "Del") { SystemCls.LogSave("5", "红外相机:" + m.INFRAREDCAMERANAME, ClsStr.getModelContent(m)); Message msgUser = BaseDT.JC_INFRAREDCAMERA_BASICINFO.Del(m); if (msgUser.Success == true) { Message msgUser1 = BaseDT.JC_INFRAREDCAMERA_BASICINFO.DelHONGWAIXIANGJI(m);//添加三维库 return(new Message(msgUser1.Success, msgUser1.Msg, m.returnUrl)); } return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } return(new Message(false, "无效操作", "")); }
/// <summary> /// 考勤统计 Model /// </summary> /// <param name="sw">参见HUCheckINCount_SW</param> /// <returns>参见HUCheck_CheckInCount_Model</returns> public static IEnumerable <HUCheck_CheckInCount_Model> getCheckInModel(HUCheckINCount_SW sw) { var result = new List <HUCheck_CheckInCount_Model>(); if (string.IsNullOrEmpty(sw.DateBegin))//开始时间为空 { return(result); } if (string.IsNullOrEmpty(sw.DateEnd))//结束时间为空 { return(result); } if (string.IsNullOrEmpty(sw.ORGNO))//组织机构编码 { return(result); } DateTime dt1 = Convert.ToDateTime(sw.DateBegin); DateTime dt2 = Convert.ToDateTime(sw.DateEnd); int days = ClsStr.getDateDiff(sw.DateBegin, sw.DateEnd) + 1;//日期包含天数 //根据机构编码获取下属组织机构 注意:这个函数含本级及所有下级的 //DataTable dtOrg = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW { TopORGNO = sw.ORGNO }); DataTable dtHRRealData = BaseDT.T_IPS_REALDATATEMPORARY.getDTByOrgNoToDate(new PatrolRouteStat_SW { DateBegin = sw.DateBegin, DateEnd = sw.DateEnd, TopORGNO = sw.ORGNO }); DataTable dtHU = BaseDT.T_IPSFR_USER.getDTByOrgSum(new T_IPSFR_USER_SW { BYORGNO = sw.ORGNO, ISENABLE = "1" }); if (PublicCls.OrgIsZhen(sw.ORGNO) == false) //市、县处理 { //只获取该市下面的县 县下面的乡 T_SYS_ORGSW swOrg = new T_SYS_ORGSW(); swOrg.SYSFLAG = ConfigCls.getSystemFlag(); swOrg.TopORGNO = sw.ORGNO; if (PublicCls.OrgIsShi(sw.ORGNO)) { swOrg.GetContyORGNOByCity = sw.ORGNO;//获取所有县 } if (PublicCls.OrgIsXian(sw.ORGNO)) { swOrg.GetXZOrgNOByConty = sw.ORGNO;//获取所有镇 } DataTable dtOrg = BaseDT.T_SYS_ORG.getDT(swOrg); DataRow[] drOrg = dtOrg.Select("", "ORGNO");//取所有 for (int i = 0; i < drOrg.Length; i++) { HUCheck_CheckInCount_Model m = new HUCheck_CheckInCount_Model(); m.ORGName = drOrg[i]["ORGNAME"].ToString(); m.ORGNo = drOrg[i]["ORGNO"].ToString(); string CHr = dtHU.Compute("sum(C)", "BYORGNO=" + m.ORGNo).ToString(); //计算该单位下总人数 CHr = (string.IsNullOrEmpty(CHr) ? "0" : CHr); m.HUCount = CHr; //考勤人数 string cList = ""; for (DateTime tm = dt1; tm <= dt2; tm = tm.AddDays(1)) { string tm1 = PublicClassLibrary.ClsSwitch.SwitDate(tm).ToString(); if (string.IsNullOrEmpty(cList) == false) { cList += ","; } string tmp = dtHRRealData.Compute("sum(C)", "BYORGNO='" + m.ORGNo + "' and SBDATE='" + tm1 + "'").ToString(); //计算该日期下人数 cList += (string.IsNullOrEmpty(tmp) ? "0" : tmp); //各日期以逗号分隔 } m.DayCountList = cList; //日期考勤列表 if (CHr != "0") { CHr = (int.Parse(CHr) * days).ToString(); string Chr0 = dtHRRealData.Compute("sum(C)", "BYORGNO='" + m.ORGNo + "'").ToString(); Chr0 = (string.IsNullOrEmpty(Chr0) ? "0" : Chr0);; // BaseDT.T_IPS_REALDATATEMPORARY.getCountByOrgNo(dtHRRealData, orgNo).ToString(); string Chr1 = ClsStr.getDiff(CHr, Chr0).ToString("F0"); Chr1 = (string.IsNullOrEmpty(Chr1) ? "0" : Chr1); string Chr2 = ClsStr.getPercent(Chr0, CHr).ToString("F0"); Chr2 = (string.IsNullOrEmpty(Chr2) ? "0" : Chr2); m.daysC = CHr; //总 m.daysOK = Chr0; //完成 m.daysPer = Chr2 + "%"; //完成率 } result.Add(m); } dtOrg.Clear(); dtOrg.Dispose(); } else//显示乡的,乡的列出各个护林员 { DataRow[] drOrg = dtHU.Select("", "");//取所有 for (int i = 0; i < drOrg.Length; i++) { HUCheck_CheckInCount_Model m = new HUCheck_CheckInCount_Model(); m.ORGName = drOrg[i]["hname"].ToString(); m.ORGNo = drOrg[i]["hid"].ToString(); string CHr = "1"; // dtHU.Compute("BYORGNO=" + m.ORGNo, "").ToString();//计算该单位下总人数 m.HUCount = (string.IsNullOrEmpty(CHr) ? "0" : CHr); //考勤人数 string cList = ""; for (DateTime tm = dt1; tm <= dt2; tm = tm.AddDays(1)) { if (string.IsNullOrEmpty(cList) == false) { cList += ","; } string tmp = dtHRRealData.Compute("sum(C)", "BYORGNO='" + m.ORGNo + "' and SBDATE='" + PublicClassLibrary.ClsSwitch.SwitDate(tm).ToString() + "'").ToString(); //计算该日期下人数 cList += (string.IsNullOrEmpty(tmp) ? "0" : tmp); //各日期以逗号分隔 } m.DayCountList = cList; //日期考勤列表 if (CHr != "0") { CHr = (int.Parse(CHr) * days).ToString(); string Chr0 = dtHRRealData.Compute("sum(C)", "BYORGNO='" + m.ORGNo + "'").ToString(); Chr0 = (string.IsNullOrEmpty(Chr0) ? "0" : Chr0);; // BaseDT.T_IPS_REALDATATEMPORARY.getCountByOrgNo(dtHRRealData, orgNo).ToString(); string Chr1 = ClsStr.getDiff(CHr, Chr0).ToString("F0"); Chr1 = (string.IsNullOrEmpty(Chr1) ? "0" : Chr1); string Chr2 = ClsStr.getPercent(Chr0, CHr).ToString("F0"); Chr2 = (string.IsNullOrEmpty(Chr2) ? "0" : Chr2); m.daysC = CHr; //总 m.daysOK = Chr0; //完成 m.daysPer = Chr2 + "%"; //完成率 } result.Add(m); } } dtHU.Clear(); dtHU.Dispose(); //根据机构编码获取所有护林员信息 // DataTable dtHU = BaseDT.T_IPSFR_USER.getDT(new T_IPSFR_USER_SW { BYORGNO = sw.ORGNO, ISENABLE = "1" }); dtHRRealData.Clear(); dtHRRealData.Dispose(); if (1 == 1) { HUCheck_CheckInCount_Model m = new HUCheck_CheckInCount_Model(); m.ORGName = "合计"; string HUCount = result.Sum(item => Convert.ToDecimal(item.HUCount)).ToString();//总数 string daysC = result.Sum(item => Convert.ToDecimal(item.daysC)).ToString(); string daysOK = result.Sum(item => Convert.ToDecimal(item.daysOK)).ToString(); HUCount = (string.IsNullOrEmpty(HUCount) ? "0" : HUCount); daysC = (string.IsNullOrEmpty(daysC) ? "0" : daysC); daysOK = (string.IsNullOrEmpty(daysOK) ? "0" : daysOK); //string PointCount0 = result.Sum(item => Convert.ToDecimal(item.PointCount0)).ToString(); m.HUCount = HUCount; m.daysC = daysC; //总天数 m.daysOK = daysOK; //已出勤 int[] arrI = new int[days]; foreach (var v in result) { string[] a = v.DayCountList.Split(',');//组合列表 for (int i = 0; i < days; i++) { if (string.IsNullOrEmpty(arrI[i].ToString())) { arrI[i] = 0; } arrI[i] += int.Parse(a[i]); } } string cList = ""; for (int i = 0; i < days; i++) { if (string.IsNullOrEmpty(cList) == false) { cList += ","; } cList += arrI[i]; } m.DayCountList = cList; //m.LineCount2 = ClsStr.getPercent(LineCount0, LineCount).ToString("F0") + "%"; //m.PointCount = PointCount; //m.PointCount0 = PointCount0; //m.PointCount1 = result.Sum(item => Convert.ToDecimal(item.PointCount1)).ToString(); m.daysPer = ClsStr.getPercent(m.daysOK, m.daysC).ToString("F0") + "%"; result.Insert(0, m); } return(result); }
/// <summary> /// 查询漏检统计 /// </summary> /// <param name="sw">参见OmitCheckCount_SW</param> /// <returns>参见HUCheck_OmitCount_Model</returns> public static IEnumerable <HUCheck_OmitCount_Model> getOmitCheckModel1(OmitCheckCount_SW sw) { var result = new List <HUCheck_OmitCount_Model>(); if (string.IsNullOrEmpty(sw.DateBegin))//开始时间为空 { return(result); } if (string.IsNullOrEmpty(sw.DateEnd))//结束时间为空 { return(result); } if (string.IsNullOrEmpty(sw.ORGNO))//组织机构编码 { return(result); } //根据机构编码获取下属组织机构 注意:这个函数含本级及所有下级的 DataTable dtOrg = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW { TopORGNO = sw.ORGNO }); DataTable dtHU = BaseDT.T_IPSFR_USER.getDT( new T_IPSFR_USER_SW { ISENABLE = "1", BYORGNO = sw.ORGNO, HNAME = sw.PhoneHname, HID = sw.HID }); //获取具体巡检情况 DataTable dtPatrol = BaseDT.T_IPSFR_ROUTERAIL_PATROL.getDT( new T_IPSFR_ROUTERAIL_PATROL_SW { DateBegin = sw.DateBegin, DateEnd = sw.DateEnd, orgNo = sw.ORGNO, PhoneHname = sw.PhoneHname, HID = sw.HID }); DateTime dt1 = Convert.ToDateTime(sw.DateBegin); DateTime dt2 = Convert.ToDateTime(sw.DateEnd); DataRow[] drOrg = dtOrg.Select("", "ORGNO"); //取所有 int days = ClsStr.getDateDiff(sw.DateBegin, sw.DateEnd) + 1; //日期包含天数 for (int i = 0; i < drOrg.Length; i++) { HUCheck_OmitCount_Model m = new HUCheck_OmitCount_Model(); string orgNo = drOrg[i]["ORGNO"].ToString(); m.ORGNo = orgNo; string orgName = BaseDT.T_SYS_ORG.getName(dtOrg, orgNo); m.ORGName = orgName; //巡检与漏检 string CCHr = BaseDT.T_IPSFR_ROUTERAIL_PATROL.getCountByOrgNo(dtPatrol, orgNo, "").ToString(); if (CCHr != "0") { string Chr0 = BaseDT.T_IPSFR_ROUTERAIL_PATROL.getCountByOrgNo(dtPatrol, orgNo, "1").ToString(); string Chr1 = ClsStr.getDiff(CCHr, Chr0).ToString("F0"); string Chr2 = ClsStr.getPercent(Chr0, CCHr).ToString("F0"); m.OmitCount0 = CCHr; //总 m.OmitCount1 = Chr0; //完成 m.OmitCount2 = Chr1; //未完成 m.OmitCount3 = Chr2 + "%"; //完成率 } result.Add(m); } if (PublicCls.OrgIsZhen(sw.ORGNO)) //显示所有护林员 { DataRow[] drHU = dtHU.Select("", ""); for (int k = 0; k < drHU.Length; k++)//循环护林员 { HUCheck_OmitCount_Model m = new HUCheck_OmitCount_Model(); string HID = dtHU.Rows[k]["HID"].ToString(); m.HID = HID; m.ORGName = dtHU.Rows[k]["HNAME"].ToString();//护林员姓名与机构名称共用一个 string CCHr1 = BaseDT.T_IPSFR_ROUTERAIL_PATROL.getCountByHID(dtPatrol, HID, "").ToString(); if (CCHr1 != "0") { string Chr0 = BaseDT.T_IPSFR_ROUTERAIL_PATROL.getCountByHID(dtPatrol, HID, "1").ToString(); string Chr1 = ClsStr.getDiff(CCHr1, Chr0).ToString("F0"); string Chr2 = ClsStr.getPercent(Chr0, CCHr1).ToString("F0"); m.OmitCount0 = CCHr1; //总 m.OmitCount1 = Chr0; //完成 m.OmitCount2 = Chr1; //未完成 m.OmitCount3 = Chr2 + "%"; //完成率 } result.Add(m); } } dtHU.Clear(); dtHU.Dispose(); dtPatrol.Clear(); dtPatrol.Dispose(); dtOrg.Clear(); dtOrg.Dispose(); return(result); }
/// <summary> /// 查询怠工统计 /// </summary> /// <param name="sw">参见SabotageCount_SW</param> /// <returns>参见getSabotageCount_Model</returns> public static IEnumerable <getSabotageCount_Model> getSabotageCountModel(SabotageCount_SW sw) { var result = new List <getSabotageCount_Model>(); if (string.IsNullOrEmpty(sw.DateBegin))//开始时间为空 { return(result); } if (string.IsNullOrEmpty(sw.DateEnd))//结束时间为空 { return(result); } DateTime dt1 = Convert.ToDateTime(sw.DateBegin); DateTime dt2 = Convert.ToDateTime(sw.DateEnd); int days = ClsStr.getDateDiff(sw.DateBegin, sw.DateEnd) + 1;//日期包含天数 DataTable dtHU = new DataTable(); DataTable dt = BaseDT.T_IPS_REALDATATEMPORARY.getDTSabotageByOrgNo(sw); if (PublicCls.OrgIsShi(sw.TopORGNO)) { dtHU = BaseDT.T_IPSFR_USER.getDTShi(new T_IPSFR_USER_SW { }); } else if (PublicCls.OrgIsXian(sw.TopORGNO)) { dtHU = BaseDT.T_IPSFR_USER.getDTXain(new T_IPSFR_USER_SW { BYORGNO = sw.TopORGNO }); } else { dtHU = BaseDT.T_IPSFR_USER.getDT(new T_IPSFR_USER_SW { ISENABLE = "1", BYORGNO = sw.TopORGNO }); } if (PublicCls.OrgIsZhen(sw.TopORGNO)) { DataRow[] drOrg = dtHU.Select("", ""); for (int i = 0; i < drOrg.Length; i++) { getSabotageCount_Model m = new getSabotageCount_Model(); m.ORGName = drOrg[i]["HNAME"].ToString(); m.ORGNo = drOrg[i]["HID"].ToString(); string CHr = dt.Compute("sum(C)", "BYORGNO='" + m.ORGNo + "'").ToString(); CHr = (string.IsNullOrEmpty(CHr) ? "0" : CHr); string cList = ""; for (DateTime tm = dt1; tm <= dt2; tm = tm.AddDays(1)) { string tm1 = PublicClassLibrary.ClsSwitch.SwitDate(tm).ToString(); if (string.IsNullOrEmpty(cList) == false) { cList += ","; } string tmp = dt.Compute("sum(C)", "BYORGNO='" + m.ORGNo + "' and SBDATE='" + tm1 + "' and PatrolLenErro=1").ToString(); //计算该日期下人数 cList += (string.IsNullOrEmpty(tmp) ? "0" : tmp); //各日期以逗号分隔 } m.DayCountList = cList; //日期考勤列表 string Chr0 = dt.Compute("sum(C)", "BYORGNO='" + m.ORGNo + "' and PatrolLenErro=0").ToString(); Chr0 = (string.IsNullOrEmpty(Chr0) ? "0" : Chr0); string Chr1 = ClsStr.getDiff(CHr, Chr0).ToString("F0"); string Chr2 = ClsStr.getPercent(Chr0, CHr).ToString("F0"); m.Count = CHr; //总 m.Count0 = Chr0; //完成 m.Count1 = Chr1; //未完成 m.CountPer = Chr2 + "%"; //完成率 result.Add(m); } dtHU.Clear(); dtHU.Dispose(); } else { T_SYS_ORGSW swOrg = new T_SYS_ORGSW(); swOrg.SYSFLAG = ConfigCls.getSystemFlag(); swOrg.TopORGNO = sw.TopORGNO; if (PublicCls.OrgIsShi(sw.TopORGNO)) { swOrg.GetContyORGNOByCity = sw.TopORGNO;//获取所有县 } if (PublicCls.OrgIsXian(sw.TopORGNO)) { swOrg.GetXZOrgNOByConty = sw.TopORGNO;//获取所有镇 } DataTable dtOrg = BaseDT.T_SYS_ORG.getDT(swOrg); DataRow[] drOrg = dtOrg.Select("", "ORGNO");//取所有 for (int i = 0; i < drOrg.Length; i++) { // string orgName = drOrg[i]["ORGNAME"].ToString(); //string orgNo = drOrg[i]["ORGNO"].ToString(); getSabotageCount_Model m = new getSabotageCount_Model(); m.ORGName = drOrg[i]["ORGNAME"].ToString(); m.ORGNo = drOrg[i]["ORGNO"].ToString(); string CHr = dt.Compute("sum(C)", "BYORGNO='" + m.ORGNo + "'").ToString(); CHr = (string.IsNullOrEmpty(CHr) ? "0" : CHr); string cList = ""; for (DateTime tm = dt1; tm <= dt2; tm = tm.AddDays(1)) { string tm1 = PublicClassLibrary.ClsSwitch.SwitDate(tm).ToString(); if (string.IsNullOrEmpty(cList) == false) { cList += ","; } string tmp = dt.Compute("sum(C)", "BYORGNO='" + m.ORGNo + "' and SBDATE='" + tm1 + "' and PatrolLenErro=0").ToString(); //计算该日期下人数 cList += (string.IsNullOrEmpty(tmp) ? "0" : tmp); //各日期以逗号分隔 } m.DayCountList = cList; //日期考勤列表 string Chr0 = dt.Compute("sum(C)", "BYORGNO='" + m.ORGNo + "' and PatrolLenErro=1").ToString(); Chr0 = (string.IsNullOrEmpty(Chr0) ? "0" : Chr0); string Chr1 = ClsStr.getDiff(CHr, Chr0).ToString("F0"); string Chr2 = ClsStr.getPercent(Chr0, CHr).ToString("F0"); m.Count = CHr; //总 m.Count0 = Chr0; //完成 m.Count1 = Chr1; //未完成 m.CountPer = Chr2 + "%"; //完成率 result.Add(m); } dtOrg.Clear(); dtOrg.Dispose(); } dt.Clear(); dt.Dispose(); if (1 == 1) { getSabotageCount_Model m = new getSabotageCount_Model(); m.ORGName = "合计"; string LineCount = result.Sum(item => Convert.ToDecimal(item.Count)).ToString(); string Count0 = result.Sum(item => Convert.ToDecimal(item.Count0)).ToString(); string Count1 = result.Sum(item => Convert.ToDecimal(item.Count1)).ToString(); m.Count = LineCount; m.Count0 = Count0; m.Count1 = Count1; m.CountPer = ClsStr.getPercent(m.Count0, m.Count).ToString("F0") + "%"; int[] arrI = new int[days]; foreach (var v in result) { string[] a = v.DayCountList.Split(',');//组合列表 for (int i = 0; i < days; i++) { if (string.IsNullOrEmpty(arrI[i].ToString())) { arrI[i] = 0; } arrI[i] += int.Parse(a[i]); } } string cList = ""; for (int i = 0; i < days; i++) { if (string.IsNullOrEmpty(cList) == false) { cList += ","; } cList += arrI[i]; } m.DayCountList = cList; result.Insert(0, m); } return(result); }
/// <summary> /// 查询怠工统计 /// </summary> /// <param name="sw">参见SabotageCount_SW</param> /// <returns>参见SabotageDetail_Model</returns> public static IEnumerable <SabotageDetail_Model> getSabotageDetailModel(SabotageCount_SW sw) { var result = new List <SabotageDetail_Model>(); if (string.IsNullOrEmpty(sw.DateBegin))//开始时间为空 { return(result); } if (string.IsNullOrEmpty(sw.DateEnd))//结束时间为空 { return(result); } if (string.IsNullOrEmpty(sw.ORGNO))//组织机构编码 { return(result); } //根据机构编码获取下属组织机构 注意:这个函数含本级及所有下级的 DataTable dtOrg = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW { TopORGNO = sw.ORGNO }); DataTable dtHU = BaseDT.T_IPSFR_USER.getDT(new T_IPSFR_USER_SW { ISENABLE = "1", BYORGNO = sw.ORGNO, PhoneHname = sw.PhoneHname }); //获取护林员每日巡检信息 DataTable dtHRRealData = BaseDT.T_IPS_REALDATATEMPORARY.getHRAndRealDataDT(new T_IPS_REALDATATEMPORARYSW { DateBegin = sw.DateBegin, DateEnd = sw.DateEnd, ORGNO = sw.ORGNO, PhoneHname = sw.PhoneHname }); float LengthError = ConfigCls.getPatrolLengthError() / 1000;//巡检距离误差 //仅查怠工DataRow[] dr = dtHRRealData.Select("PatrolLenError<=" + LengthError.ToString(), "SBDATE DESC"); DataRow[] dr = dtHRRealData.Select("", "HID,SBDATE DESC"); for (int i = 0; i < dr.Length; i++) { SabotageDetail_Model m = new SabotageDetail_Model(); string hid = dr[i]["HID"].ToString(); m.HID = hid; string orgNo = dr[i]["BYORGNO"].ToString(); m.ORGNo = orgNo; m.ORGName = BaseDT.T_SYS_ORG.getName(dtOrg, orgNo); m.HNAME = dr[i]["HNAME"].ToString(); //护林员姓名 m.PHONE = dr[i]["PHONE"].ToString(); //电话 m.Date = PublicClassLibrary.ClsSwitch.SwitDate(dr[i]["SBDATE"].ToString()); //日期 m.Count0 = Convert.ToDouble(dr[i]["PATROLLENGTH"].ToString()).ToString("F2"); //应巡长度 m.Count1 = Convert.ToDouble(dr[i]["RealPATROLLENGTH"].ToString()).ToString("F2"); //实巡长度 m.CountPer = ClsStr.getPercent(dr[i]["RealPATROLLENGTH"].ToString(), dr[i]["PATROLLENGTH"].ToString()); //string wcl1 = wcl.ToString("F0"); //if (wcl <= 100) // wcl1 = "<font color=red>" + wcl1 + "</font>"; //m.CountPer = wcl1; result.Add(m); } dtHRRealData.Clear(); dtHRRealData.Dispose(); dtHU.Clear(); dtHU.Dispose(); dtOrg.Clear(); dtOrg.Dispose(); return(result); }
/// <summary> /// 考勤统计 Model /// </summary> /// <param name="sw">参见HUCheckINCount_SW</param> /// <returns>参见HUCheck_CheckInCount_Model</returns>getOutRaiLCountModel public static IEnumerable <OutRaiLCount_Model> getOutRaiLCountModel(OutRaiLCount_SW sw) { var result = new List <OutRaiLCount_Model>(); if (string.IsNullOrEmpty(sw.DateBegin))//开始时间为空 { return(result); } if (string.IsNullOrEmpty(sw.DateEnd))//结束时间为空 { return(result); } if (string.IsNullOrEmpty(sw.TopORGNO))//组织机构编码 { return(result); } DateTime dt1 = Convert.ToDateTime(sw.DateBegin); DateTime dt2 = Convert.ToDateTime(sw.DateEnd); int days = ClsStr.getDateDiff(sw.DateBegin, sw.DateEnd) + 1;//日期包含天数 DataTable dt = BaseDT.T_IPSFR_ROUTERAIL_RAIL.getDTByOrgNoToDate(new OutRaiLCount_SW { DateBegin = sw.DateBegin, DateEnd = sw.DateEnd, TopORGNO = sw.TopORGNO }); DataTable dtHU = BaseDT.T_IPSFR_USER.getDTByOrgSum(new T_IPSFR_USER_SW { BYORGNO = sw.TopORGNO, ISENABLE = "1" }); if (PublicCls.OrgIsZhen(sw.TopORGNO) == false) //市、县处理 { //只获取该市下面的县 县下面的乡 T_SYS_ORGSW swOrg = new T_SYS_ORGSW(); swOrg.SYSFLAG = ConfigCls.getSystemFlag(); swOrg.TopORGNO = sw.TopORGNO; if (PublicCls.OrgIsShi(sw.TopORGNO)) { swOrg.GetContyORGNOByCity = sw.TopORGNO;//获取所有县 } if (PublicCls.OrgIsXian(sw.TopORGNO)) { swOrg.GetXZOrgNOByConty = sw.TopORGNO;//获取所有镇 } DataTable dtOrg = BaseDT.T_SYS_ORG.getDT(swOrg); DataRow[] drOrg = dtOrg.Select("", "ORGNO");//取所有 for (int i = 0; i < drOrg.Length; i++) { OutRaiLCount_Model m = new OutRaiLCount_Model(); m.ORGName = drOrg[i]["ORGNAME"].ToString(); m.ORGNo = drOrg[i]["ORGNO"].ToString(); string CHr = dt.Compute("sum(C)", "BYORGNO=" + m.ORGNo).ToString();//计算该单位下总数 CHr = (string.IsNullOrEmpty(CHr) ? "0" : CHr); m.Count = CHr; string cList = ""; for (DateTime tm = dt1; tm <= dt2; tm = tm.AddDays(1)) { string tm1 = PublicClassLibrary.ClsSwitch.SwitDate(tm).ToString(); if (string.IsNullOrEmpty(cList) == false) { cList += ","; } string tmp = dt.Compute("sum(C)", "BYORGNO='" + m.ORGNo + "' and SBDATE='" + tm1 + "'").ToString(); //计算该日期下数量 cList += (string.IsNullOrEmpty(tmp) ? "0" : tmp); //各日期以逗号分隔 } m.DayCountList = cList; //日期考勤列表 result.Add(m); } dtOrg.Clear(); dtOrg.Dispose(); } else//显示乡的,乡的列出各个护林员 { DataRow[] drOrg = dtHU.Select("", "");//取所有 for (int i = 0; i < drOrg.Length; i++) { OutRaiLCount_Model m = new OutRaiLCount_Model(); m.ORGName = drOrg[i]["hname"].ToString(); m.ORGNo = drOrg[i]["hid"].ToString(); string CHr = dt.Compute("sum(C)", "BYORGNO=" + m.ORGNo).ToString();//计算该单位下总数 CHr = (string.IsNullOrEmpty(CHr) ? "0" : CHr); m.Count = CHr; string cList = ""; for (DateTime tm = dt1; tm <= dt2; tm = tm.AddDays(1)) { if (string.IsNullOrEmpty(cList) == false) { cList += ","; } string tmp = dt.Compute("sum(C)", "BYORGNO='" + m.ORGNo + "' and SBDATE='" + PublicClassLibrary.ClsSwitch.SwitDate(tm).ToString() + "'").ToString(); //计算该日期下人数 cList += (string.IsNullOrEmpty(tmp) ? "0" : tmp); //各日期以逗号分隔 } m.DayCountList = cList; //日期列表 result.Add(m); } } dtHU.Clear(); dtHU.Dispose(); dt.Clear(); dt.Dispose(); if (1 == 1) { OutRaiLCount_Model m = new OutRaiLCount_Model(); m.ORGName = "合计"; string CHr = result.Sum(item => Convert.ToDecimal(item.Count)).ToString();//总数//计算该单位下总数 CHr = (string.IsNullOrEmpty(CHr) ? "0" : CHr); m.Count = CHr; int[] arrI = new int[days]; foreach (var v in result) { string[] a = v.DayCountList.Split(',');//组合列表 for (int i = 0; i < days; i++) { if (string.IsNullOrEmpty(arrI[i].ToString())) { arrI[i] = 0; } arrI[i] += int.Parse(a[i]); } } string cList = ""; for (int i = 0; i < days; i++) { if (string.IsNullOrEmpty(cList) == false) { cList += ","; } cList += arrI[i]; } m.DayCountList = cList; result.Insert(0, m); } return(result); }
/// <summary> /// 护林员定位 获取护林员最新一条位置信息 /// </summary> /// <param name="sw">传递护林员列表 参见条件模型T_IPS_REALDATATEMPORARYSW</param> /// <returns>参见模型T_IPS_REALDATATEMPORARYModel</returns> public static IEnumerable <T_IPS_REALDATATEMPORARYModel> getTopOneModelList(T_IPS_REALDATATEMPORARYSW sw) { var result = new List <T_IPS_REALDATATEMPORARYModel>(); DataTable dt = BaseDT.T_IPS_REALDATATEMPORARY.getTopOneDT(sw); DataTable dtOrg = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW { SYSFLAG = ConfigCls.getSystemFlag() }); //获取当前登录用户有权限查看的组织机构 DataTable dtFRUser = BaseDT.T_IPSFR_USER.getDT(new T_IPSFR_USER_SW { ISENABLE = "1", HID = sw.USERID }); //获取所有有权限查看的护林员 for (int i = 0; i < dt.Rows.Count; i++) { T_IPS_REALDATATEMPORARYModel m = new T_IPS_REALDATATEMPORARYModel(); //m.REALDATAID = dt.Rows[i]["REALDATAID"].ToString(); m.USERID = dt.Rows[i]["USERID"].ToString(); m.LONGITUDE = dt.Rows[i]["LONGITUDE"].ToString(); m.LATITUDE = dt.Rows[i]["LATITUDE"].ToString(); m.ORILONGITUDE = dt.Rows[i]["LONGITUDE"].ToString(); //原经度 m.ORILATITUDE = dt.Rows[i]["LATITUDE"].ToString(); //原纬度 if (sw.MapType != "Skyline") { //******************计算坐标偏移量 string[] arr = PublicCls.switJWD(m.LATITUDE, m.LONGITUDE); m.LATITUDE = arr[0]; m.LONGITUDE = arr[1]; //******************计算坐标偏移量 End } m.HEIGHT = dt.Rows[i]["HEIGHT"].ToString(); m.ELECTRIC = dt.Rows[i]["ELECTRIC"].ToString(); m.SPEED = dt.Rows[i]["SPEED"].ToString(); m.DIRECTION = dt.Rows[i]["DIRECTION"].ToString(); m.SBTIME = dt.Rows[i]["SBTIME"].ToString(); if (string.IsNullOrEmpty(m.SBTIME) == false) { m.SBTIME = PublicClassLibrary.ClsSwitch.SwitTM(m.SBTIME); } m.NOTE = dt.Rows[i]["NOTE"].ToString(); m.ORGNO = dt.Rows[i]["ORGNO"].ToString(); m.SBDATE = dt.Rows[i]["SBDATE"].ToString(); m.ISOUTRAIL = dt.Rows[i]["ISOUTRAIL"].ToString();//是否出围 if (string.IsNullOrEmpty(m.SBDATE) == false) { m.SBDATE = PublicClassLibrary.ClsSwitch.SwitDate(m.SBDATE); } m.SBTIMEBEGIN = dt.Rows[i]["SBTIMEBEGIN"].ToString(); m.PATROLLENGTH = dt.Rows[i]["PATROLLENGTH"].ToString(); DataRow[] drFRUser = dtFRUser.Select("HID=" + m.USERID); if (drFRUser.Length > 0) { m.HNAME = drFRUser[0]["HNAME"].ToString(); m.PHONE = drFRUser[0]["PHONE"].ToString(); m.ORGNO = drFRUser[0]["BYORGNO"].ToString(); m.ORGNAME = BaseDT.T_SYS_ORG.getName(dtOrg, m.ORGNO); } double intervalTime = ConfigCls.inLineTimeInterval(); var absTime = Math.Abs(ClsStr.getMinutesDiff(DateTime.Now, m.SBTIME)); m.HSTATE = absTime > intervalTime ? "0" : "1";//护林员在线状态 0 表示离线 1 表示在线 // //m.ISOUTRAIL result.Add(m); } dt.Clear(); dt.Dispose(); dtOrg.Clear(); dtOrg.Dispose(); dtFRUser.Clear(); dtFRUser.Dispose(); return(result); }