/// <summary> /// 根据ID获取明细 /// </summary> /// <param name="sw">sw.REPORTID</param> /// <returns>参见模型</returns> public static IEnumerable <T_IPSRPT_REPORT_Model> getDetailModelList(T_IPSRPT_REPORT_SW sw) { var result = new List <T_IPSRPT_REPORT_Model>(); DataTable dt = BaseDT.T_IPSRPT_REPORT.getDetailDT(new T_IPSRPT_REPORT_SW { REPORTID = sw.REPORTID }); for (int i = 0; i < dt.Rows.Count; i++) { T_IPSRPT_REPORT_Model m = new T_IPSRPT_REPORT_Model(); m.REPORTDETAILID = dt.Rows[i]["REPORTDETAILID"].ToString(); m.REPORTID = dt.Rows[i]["REPORTID"].ToString(); m.LONGITUDE = dt.Rows[i]["LONGITUDE"].ToString(); m.LATITUDE = dt.Rows[i]["LATITUDE"].ToString(); //******************计算坐标偏移量 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.DIRECTION = dt.Rows[i]["DIRECTION"].ToString(); m.SBTIME = ClsSwitch.SwitTM(dt.Rows[i]["SBTIME"].ToString()); result.Add(m); } dt.Clear(); dt.Dispose(); return(result); }
/// <summary> /// 处理 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Man(T_IPSRPT_REPORT_Model m) { if (string.IsNullOrEmpty(m.REPORTID)) { return(new Message(false, "修改失败,请选择要处理的记录!", "")); } StringBuilder sb = new StringBuilder(); //(ORGNO,LOGINUSERNAME,USERNAME,USERPWD,REGISTERTIME,LOGINNUM,NOTE) sb.AppendFormat("UPDATE T_IPSRPT_REPORTDATA"); sb.AppendFormat(" set "); sb.AppendFormat(" COLLECTNAME='{0}'", ClsSql.EncodeSql(m.COLLECTNAME)); sb.AppendFormat(" ,MANSTATE='{0}'", "1"); sb.AppendFormat(" ,MANRESULT='{0}'", ClsSql.EncodeSql(m.MANRESULT)); if (!string.IsNullOrEmpty(m.ADDRESS)) { sb.AppendFormat(" ,ADDRESS='{0}'", ClsSql.EncodeSql(m.ADDRESS)); } sb.AppendFormat(" ,MANTIME='{0}'", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); sb.AppendFormat(" ,MANUSERID='{0}'", SystemCls.getUserID()); sb.AppendFormat(" where REPORTID= '{0}'", ClsSql.EncodeSql(m.REPORTID)); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "处理成功!", "")); } else { return(new Message(false, "处理失败,请检查各输入框是否正确!", "")); } }
/// <summary> /// 删除上报数据 /// </summary> /// <returns>参见模型</returns> public JsonResult DeleteReportDataAjax() { Message ms = null; string reportid = Request.Params["reportid"]; if (string.IsNullOrEmpty(reportid)) { ms = new Message(false, "reportid参数传递错误", ""); return(Json(ms)); } var m = new T_IPSRPT_REPORT_Model(); m.opMethod = "Del"; m.REPORTID = reportid; ms = T_IPSRPT_REPORTCls.Manager(m); return(Json(ms)); }
/// <summary> /// 根据ID获取上传文件 /// </summary> /// <param name="sw">sw.REPORTID</param> /// <returns>参见模型</returns> public static IEnumerable <T_IPSRPT_REPORT_Model> getUploadlModelList(T_IPSRPT_REPORT_SW sw) { var result = new List <T_IPSRPT_REPORT_Model>(); DataTable dt = BaseDT.T_IPSRPT_REPORT.getUploadDT(new T_IPSRPT_REPORT_SW { REPORTID = sw.REPORTID }); for (int i = 0; i < dt.Rows.Count; i++) { T_IPSRPT_REPORT_Model m = new T_IPSRPT_REPORT_Model(); m.REPORTUPLOADID = dt.Rows[i]["REPORTUPLOADID"].ToString(); m.REPORTID = dt.Rows[i]["REPORTID"].ToString(); m.UPLOADURL = dt.Rows[i]["UPLOADURL"].ToString(); m.UPLOADNAME = dt.Rows[i]["UPLOADNAME"].ToString(); m.UPLOADDESCRIBE = dt.Rows[i]["UPLOADDESCRIBE"].ToString(); result.Add(m); } dt.Clear(); dt.Dispose(); return(result); }
/// <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> /// 根据ID获取上传数据 /// </summary> /// <example> /// sw.MANSTATE 处理状态 0未处理1已处理 /// sw.DateBegin 开始日期 /// sw.DateEnd 结束日期 /// </example> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static T_IPSRPT_REPORT_Model getModel(T_IPSRPT_REPORT_SW sw) { DataTable dt = BaseDT.T_IPSRPT_REPORT.getDT(sw); T_IPSRPT_REPORT_Model m = new T_IPSRPT_REPORT_Model(); if (dt.Rows.Count > 0) { int i = 0; m.REPORTID = dt.Rows[i]["REPORTID"].ToString(); m.HID = dt.Rows[i]["HID"].ToString(); m.SYSTYPEVALUE = dt.Rows[i]["SYSTYPEVALUE"].ToString(); m.ADDRESS = dt.Rows[i]["ADDRESS"].ToString(); m.REPORTTIME = ClsSwitch.SwitTM(dt.Rows[i]["REPORTTIME"].ToString()); m.COLLECTNAME = dt.Rows[i]["COLLECTNAME"].ToString(); m.MANSTATE = dt.Rows[i]["MANSTATE"].ToString(); m.MANRESULT = dt.Rows[i]["MANRESULT"].ToString(); m.MANTIME = dt.Rows[i]["MANTIME"].ToString(); m.MANUSERID = dt.Rows[i]["MANUSERID"].ToString(); } dt.Clear(); dt.Dispose(); return(m); }
/// <summary> /// 报存上报信息 /// </summary> /// <returns>参见模型</returns> public JsonResult SaveReportDataAjax() { Message ms = null; string reportid = Request.Params["reportid"]; string address = Request.Params["address"]; string describe = Request.Params["describe"]; string result = Request.Params["result"]; if (string.IsNullOrEmpty(reportid)) { ms = new Message(false, "reportid上报id传参失败", ""); return(Json(ms)); } var m = new T_IPSRPT_REPORT_Model(); m.REPORTID = reportid; m.opMethod = "Man"; m.MANUSERID = SystemCls.getUserID(); m.ADDRESS = address.Trim(); m.COLLECTNAME = describe.Trim(); m.MANRESULT = result.Trim(); ms = T_IPSRPT_REPORTCls.Manager(m); var jctype = System.Configuration.ConfigurationManager.AppSettings["ISJcFire"].ToString(); //是否插入火情监测表 if (jctype.Trim() == "1") //增加至监测火情表 { var list = JC_FIRECls.GetListModel(new JC_FIRE_SW() { FIREFROMID = m.REPORTID }); if (!list.Any()) { if (ms.Success) { //红外相机 = 1, //卫星热点 = 2, //人工报警 = 3, //电子报警 = 4, //护林员火情 = 5 var sw = new T_IPSRPT_REPORT_SW(); sw.REPORTID = reportid; var record = T_IPSRPT_REPORTCls.getModel(sw); if (record != null) { if (record.SYSTYPEVALUE == "1")//1 为火情 { JC_FIRE_Model model = new JC_FIRE_Model(); model.opMethod = "Add"; model.FIREFROMID = m.REPORTID; model.FIREFROM = "5";//护林员火情上报 model.FIRENAME = ClsSwitch.SwitTM(record.REPORTTIME) + "护林员报警火情"; model.FIRETIME = record.REPORTTIME; var recordmodel = T_IPSRPT_REPORTCls.getDetailModelList(new T_IPSRPT_REPORT_SW() { REPORTID = record.REPORTID }).FirstOrDefault(); //获取数据详细 if (recordmodel != null) { model.JD = recordmodel.LONGITUDE; model.WD = recordmodel.LATITUDE; } model.BYORGNO = record.OrgNo; model.ZQWZ = record.ADDRESS; model.RECEIVETIME = record.MANTIME; var mm = JC_FIRECls.Manager(model); } } } } } return(Json(ms)); }
/// <summary> /// 获取多条数据 /// </summary> /// <example> /// sw.orgNo 机构编码,用于获取该机构编码下所有的上报信息 /// sw.MANSTATE 处理状态 0未处理1已处理 /// sw.DateBegin 开始日期 /// sw.DateEnd 结束日期 /// </example> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static IEnumerable <T_IPSRPT_REPORT_Model> getModelList(T_IPSRPT_REPORT_SW sw) { DataTable dtHRUser = BaseDT.T_IPSFR_USER.getDT(new T_IPSFR_USER_SW { BYORGNO = sw.orgNo }); DataTable dtUser = BaseDT.T_SYSSEC_USER.getDT(new T_SYSSEC_IPSUSER_SW { }); var result = new List <T_IPSRPT_REPORT_Model>(); DataTable dt = null; if (sw.UnionHUser) { dt = BaseDT.T_IPSRPT_REPORT.getDtUnionHUser(sw); //关联护林员表 } else { dt = BaseDT.T_IPSRPT_REPORT.getDT(sw); } string IDList = ""; for (int i = 0; i < dt.Rows.Count; i++) { if (i > 0) { IDList += ","; } IDList += dt.Rows[i]["REPORTID"].ToString(); } //var userid = SystemCls.getUserID(); //var rightsw = new T_SYSSEC_IPSUSER_SW(); //rightsw.USERID = userid; DataTable dtDetail = BaseDT.T_IPSRPT_REPORT.getDetailDT(new T_IPSRPT_REPORT_SW { REPORTID = IDList }); DataTable dtUpload = BaseDT.T_IPSRPT_REPORT.getUploadDT(new T_IPSRPT_REPORT_SW { REPORTID = IDList }); for (int i = 0; i < dt.Rows.Count; i++) { T_IPSRPT_REPORT_Model m = new T_IPSRPT_REPORT_Model(); m.REPORTID = dt.Rows[i]["REPORTID"].ToString(); m.HID = dt.Rows[i]["HID"].ToString(); m.SYSTYPEVALUE = dt.Rows[i]["SYSTYPEVALUE"].ToString(); m.ADDRESS = dt.Rows[i]["ADDRESS"].ToString(); m.REPORTTIME = ClsSwitch.SwitTM(dt.Rows[i]["REPORTTIME"].ToString()); m.COLLECTNAME = dt.Rows[i]["COLLECTNAME"].ToString(); m.MANSTATE = dt.Rows[i]["MANSTATE"].ToString(); m.MANRESULT = dt.Rows[i]["MANRESULT"].ToString(); m.MANTIME = dt.Rows[i]["MANTIME"].ToString(); m.MANUSERID = dt.Rows[i]["MANUSERID"].ToString(); DataRow[] drDetail = dtDetail.Select("REPORTID='" + m.REPORTID + "'", "SBTIME"); if (drDetail.Length > 0) { m.REPORTDETAILID = drDetail[0]["REPORTDETAILID"].ToString(); m.LONGITUDE = drDetail[0]["LONGITUDE"].ToString(); m.LATITUDE = drDetail[0]["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 = drDetail[0]["HEIGHT"].ToString(); m.DIRECTION = drDetail[0]["DIRECTION"].ToString(); m.SBTIME = ClsSwitch.SwitTM(drDetail[0]["SBTIME"].ToString()); } DataRow[] drUpload = dtUpload.Select("REPORTID='" + m.REPORTID + "'", "REPORTUPLOADID"); if (drUpload.Length > 0) { m.REPORTUPLOADID = drUpload[0]["REPORTUPLOADID"].ToString(); m.UPLOADURL = drUpload[0]["UPLOADURL"].ToString(); if (!string.IsNullOrEmpty(m.UPLOADURL)) { var wcfservice = System.Configuration.ConfigurationManager.AppSettings["SpringerWcfService"];//wcf服务地址 if (!string.IsNullOrEmpty(wcfservice)) { m.UPLOADURL = wcfservice + m.UPLOADURL; } ; } m.UPLOADNAME = drUpload[0]["UPLOADNAME"].ToString(); m.UPLOADDESCRIBE = drUpload[0]["UPLOADDESCRIBE"].ToString(); m.UPLOADTYPE = drUpload[0]["UPLOADTYPE"].ToString(); } DataRow[] drHRUser = dtHRUser.Select("HID='" + m.HID + "'"); if (drHRUser.Length > 0) { m.OrgNoName = drHRUser[0]["ORGNAME"].ToString(); m.HName = drHRUser[0]["HNAME"].ToString(); m.PHONE = drHRUser[0]["PHONE"].ToString(); m.OrgNo = drHRUser[0]["BYORGNO"].ToString(); } if (!string.IsNullOrEmpty(m.MANUSERID)) { DataRow[] drUser = dtUser.Select("USERID='" + m.MANUSERID + "'"); if (drUser.Length > 0) { m.ManUserName = drUser[0]["USERNAME"].ToString(); } } //权限获取 //m.Rights = T_SYSSEC_RIGHTCls.getRightStrByUID(rightsw); result.Add(m); } dtUser.Clear(); dtUser.Dispose(); dtHRUser.Clear(); dtHRUser.Dispose(); dtDetail.Clear(); dtDetail.Dispose(); dtUpload.Clear(); dtUpload.Dispose(); dt.Clear(); dt.Dispose(); return(result); }