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