/// <summary> /// 返回查询表格 /// </summary> /// <returns></returns> public ActionResult getReportCountJson() { T_IPSRPT_REPORT_SW sw = new T_IPSRPT_REPORT_SW(); sw.TopORGNO = Request.Params["TopORGNO"]; sw.DateBegin = Request.Params["DateBegin"]; sw.DateEnd = Request.Params["DateEnd"]; IEnumerable <T_IPSRPT_REPORT_TypeCountModel> typeModel; //类别 var list = T_IPSRPT_REPORTCls.getModelCount(sw, out typeModel); //查询结果 StringBuilder sb = new StringBuilder(); sb.AppendFormat("<table id=\"tb\" cellpadding=\"0\" cellspacing=\"0\">"); sb.AppendFormat("<thead>"); sb.AppendFormat(" <tr>"); sb.AppendFormat(" <th>单位/姓名</th>"); sb.AppendFormat(" <th>总数</th>"); foreach (var v in typeModel) { sb.AppendFormat(" <th>{0}</th>", v.typeName); } sb.AppendFormat(" </tr>"); sb.AppendFormat("</thead>"); sb.AppendFormat("<tbody>"); int i = 0; foreach (var v in list) { i++; if (i % 2 == 0) { sb.AppendFormat("<tr>"); } else { sb.AppendFormat("<tr class='row1'>"); } if (string.IsNullOrEmpty(v.ORGNo)) { sb.AppendFormat("<td class=\"center\" style=\"{1}\">{0}</td>", v.HName, ""); } else { sb.AppendFormat("<td class=\"center\" style=\"{1}\">{0}</td>", v.ORGName, ""); } sb.AppendFormat("<td class=\"center\">{0}</td>", v.ReportCount);//总 var vvList = v.TypeCountModel; foreach (var vv in vvList) { sb.AppendFormat("<td class=\"center\">{0}</td>", vv.typeCount); } 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> /// <returns></returns> public ActionResult DataReportDetailViewIndex() { string repid = Request.Params["repid"];//数据上报id var sw = new T_IPSRPT_REPORT_SW(); sw.REPORTID = repid; var list = T_IPSRPT_REPORTCls.getModelList(sw).FirstOrDefault(); return(View(list)); }
/// <summary> /// 获取上报与护林员、单位组合查询 用于统计 /// </summary> /// <param name="sw">参见模型 sw.TopORGNO 顶级单位编码 sw.DateBegin 开始日期 年月日 sw.DateEnd 结束日期 年月日</param> /// <returns>返回DataTable HID, SYSTYPEVALUE, REPORTTIME, HNAME,ORGNAME,ORGNO</returns> public static DataTable getDTByOrgHUse(T_IPSRPT_REPORT_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("SELECT a.HID, a.SYSTYPEVALUE, a.REPORTTIME, b.HNAME,c.ORGNAME,c.ORGNO"); sb.AppendFormat(" FROM T_IPSRPT_REPORTDATA a "); sb.AppendFormat(" left outer join T_IPSFR_USER b on a.hid=b.hid"); sb.AppendFormat(" left outer join T_SYS_ORG c on b.BYORGNO=c.ORGNO"); sb.AppendFormat(" WHERE 1=1"); if (string.IsNullOrEmpty(sw.TopORGNO) == false) { if (sw.TopORGNO.Substring(4, 11) == "00000000000")//获取所有市的 { sb.AppendFormat(" AND SUBSTRING(ORGNO,1,4) = '{0}'", ClsSql.EncodeSql(sw.TopORGNO.Substring(0, 4))); } else if (sw.TopORGNO.Substring(6, 9) == "000000000")//获取所有县的 { sb.AppendFormat(" AND SUBSTRING(ORGNO,1,6) = '{0}'", ClsSql.EncodeSql(sw.TopORGNO.Substring(0, 6))); } else if (sw.TopORGNO.Substring(9, 6) == "000000") { sb.AppendFormat(" AND SUBSTRING(ORGNO,1,9) = '{0}'", ClsSql.EncodeSql(sw.TopORGNO.Substring(0, 9))); } else { sb.AppendFormat(" AND ORGNO = '{0}'", ClsSql.EncodeSql(sw.TopORGNO)); } } if (!string.IsNullOrEmpty(sw.DateBegin)) { sb.AppendFormat(" AND REPORTTIME>='{0} 00:00:00'", sw.DateBegin); } if (!string.IsNullOrEmpty(sw.DateEnd)) { sb.AppendFormat(" AND REPORTTIME<='{0} 23:59:59'", sw.DateEnd); } DataSet ds = DataBaseClass.FullDataSet(sb.ToString()); return(ds.Tables[0]); }
/// <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); }
private string getReportHidDetailStr(T_IPSRPT_REPORT_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("<table cellpadding=\"0\" cellspacing=\"0\">"); sb.AppendFormat("<thead>"); sb.AppendFormat(" <tr>"); sb.AppendFormat(" <th>序号</th>"); sb.AppendFormat(" <th>单位</th>"); sb.AppendFormat(" <th>姓名</th>"); sb.AppendFormat(" <th>电话</th>"); sb.AppendFormat(" <th>上报时间</th>"); sb.AppendFormat(" <th>处理状态</th>"); sb.AppendFormat(" <th>描述</th>"); sb.AppendFormat(" <th>地址</th>"); sb.AppendFormat(" </tr>"); var list = T_IPSRPT_REPORTCls.getModelList(sw); int i = 1; sb.AppendFormat("</thead>"); sb.AppendFormat("<tbody>"); foreach (var v in list) { sb.AppendFormat("<tr>"); sb.AppendFormat("<td class=\"center\">{0}</td>", i.ToString()); sb.AppendFormat("<td class=\"center\">{0}</td>", v.OrgNoName); sb.AppendFormat("<td class=\"center\">{0}</td>", v.HName); sb.AppendFormat("<td class=\"center\">{0}</td>", v.PHONE); sb.AppendFormat("<td class=\"center\">{0}</td>", v.REPORTTIME); sb.AppendFormat("<td class=\"center\">{0}</td>", (v.MANSTATE == "0") ? "×" : "√"); sb.AppendFormat("<td class=\"left\">{0}</td>", v.COLLECTNAME); sb.AppendFormat("<td class=\"left\">{0}</td>", v.ADDRESS); sb.AppendFormat("</tr>"); i++; } sb.AppendFormat("</tbody>"); sb.AppendFormat("</table>"); return(sb.ToString()); }
/// <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 GetReportDataAjax() { MessageListObject ms = null; string starttime = Request.Params["starttime"]; //开始时间 string endtime = Request.Params["endtime"]; //开始时间 string type = Request.Params["type"]; //类型 string state = Request.Params["state"]; //状态 //if (string.IsNullOrEmpty(starttime) || string.IsNullOrEmpty(endtime) || string.IsNullOrEmpty(type)) //{ // ms = new MessageListObject(false, null); // return Json(ms); //} var sw = new T_IPSRPT_REPORT_SW(); sw.DateBegin = starttime; sw.DateEnd = endtime; sw.SYSTYPEVALUE = type; sw.orgNo = SystemCls.getCurUserOrgNo();//当前单位 if (state != "2") { sw.MANSTATE = state; } var list = T_IPSRPT_REPORTCls.getModelList(sw); if (list.Any()) { ms = new MessageListObject(true, list); } else { ms = new MessageListObject(false, null); } return(Json(ms)); }
/// <summary> /// 获取检索上报数据Html /// </summary> /// <returns>参见模型</returns> public JsonResult GetReportDataListAjax() { Message ms = null; string typename = ""; string person = Request.Params["person"]; string starttime = Request.Params["starttime"]; string endtime = Request.Params["endtime"]; string state = Request.Params["state"]; string tid = Request.Params["tid"]; string type = Request.Params["type"]; var dicsw = new T_SYS_DICTSW(); dicsw.DICTTYPEID = "5"; dicsw.DICTVALUE = tid; var model = T_SYS_DICTCls.getModel(dicsw); typename = model.DICTNAME; StringBuilder sb = new StringBuilder(); if (type == "Skyline") { sb.AppendFormat("<table cellpadding=\"0\" cellspacing=\"0\">"); sb.AppendFormat("<thead>"); sb.AppendFormat(" <tr> "); sb.AppendFormat(" <th>序号</th>");; sb.AppendFormat(" <th>上报人</th>"); // sb.AppendFormat(" <th>电话号码</th>"); sb.AppendFormat(" <th>上报时间</th>"); sb.AppendFormat(" <th>操作</th>"); } else { sb.AppendFormat("<table cellpadding=\"0\" cellspacing=\"0\">"); sb.AppendFormat("<thead>"); sb.AppendFormat(" <tr> "); sb.AppendFormat(" <th>序号</th>"); sb.AppendFormat(" <th>数据类型</th>"); sb.AppendFormat(" <th>上报人</th>"); sb.AppendFormat(" <th>电话号码</th>"); sb.AppendFormat(" <th>上报时间</th>"); sb.AppendFormat(" <th>状态</th>"); sb.AppendFormat(" <th>操作</th>"); } sb.AppendFormat(" </tr>"); sb.AppendFormat("</thead>"); sb.AppendFormat("<tbody>"); var sw = new T_IPSRPT_REPORT_SW(); sw.DateBegin = starttime; sw.DateEnd = endtime; sw.SYSTYPEVALUE = tid; sw.UnionHUser = false; if (!string.IsNullOrEmpty(person)) { sw.HUserName = person; sw.UnionHUser = true; } if (state != "2") { sw.MANSTATE = state; } var cuurorg = SystemCls.getCurUserOrgNo(); if (!string.IsNullOrEmpty(cuurorg)) { sw.orgNo = cuurorg; } var list = T_IPSRPT_REPORTCls.getModelList(sw); if (list.Any()) { var url = System.Configuration.ConfigurationManager.AppSettings["SkylineUrl"].ToString(); var personPopurl = url + @"/SkylineManger/PersonDetailIndex"; var reportViewPopurl = url + @"/SkylineManger/DataReportDetailViewIndex"; int i = 0; foreach (var item in list) { sb.AppendFormat("<tr>"); sb.AppendFormat("<td>{0}</td>", ++i); if (type == "Skyline") { sb.AppendFormat("<td><a href=\"javascript:void(0);\" title=\"人员信息\" onclick=\"PopUrlReport('" + personPopurl + "'," + item.HID + ")\">{0}</a></td>", item.HName); // sb.AppendFormat("<td>{0}</td>", item.PHONE); sb.AppendFormat("<td title=\"{0}\">{1}</td>", item.REPORTTIME, Convert.ToDateTime(item.REPORTTIME).ToString("MM-dd HH:mm")); } else { sb.AppendFormat("<td>{0}</td>", typename); sb.AppendFormat("<td>{0}</td>", item.HName); sb.AppendFormat("<td>{0}</td>", item.PHONE); sb.AppendFormat("<td>{0}</td>", item.REPORTTIME); if (item.MANSTATE == "0") { sb.AppendFormat("<td><a class=\"label label-danger\">未处理</a></td>"); } else { sb.AppendFormat("<td><a class=\"label label-success\">已处理</a></td>"); } } //class=\"icon-flag\" if (type == "Skyline") { //sb.AppendFormat("<td><a href=\"javascript:void(0);\" onClick=\"getLocaReport(" + item.REPORTID + ")\">定位</a>" // + " <a href=\"javascript:void(0);\" onClick=\"getReportView('" + reportViewPopurl + "'," + item.REPORTID + ")\">查看</a> <a href=\"javascript:void(0);\">对讲</a></td>"); sb.AppendFormat("<td class=\"center\"> <a href=\"javascript:void(0);\" onClick=\"getLocaReport(" + item.REPORTID + ")\" class=\"dw option\"></a><a href=\"javascript:void(0);\" onClick=\"getReportView('" + reportViewPopurl + "'," + item.REPORTID + ")\" class=\"ck option\"></a><a href=\"javascript:void(0);\" class=\"dj option\"></a></td>"); } else { sb.AppendFormat("<td><a href=\"javascript:void(0);\" onClick=\"getLocaReport(" + item.REPORTID + ")\">定位</a></td>"); } sb.AppendFormat("</tr>"); } } else { if (type == "Skyline") { sb.AppendFormat("<tr>"); sb.AppendFormat("<td colspan=\"4\">暂无信息</td>"); sb.AppendFormat("</tr>"); } else { sb.AppendFormat("<tr>"); sb.AppendFormat("<td colspan=\"7\">暂无信息</td>"); sb.AppendFormat("</tr>"); } } sb.AppendFormat("</tbody>"); sb.AppendFormat("</table>"); ms = new Message(true, sb.ToString(), ""); return(Json(ms)); }
/// <summary> /// 报存上报信息 /// </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> /// <param name="sw">参见模型 sw.TopORGNO 顶级单位编码 sw.DateBegin 开始日期 年月日 sw.DateEnd 结束日期 年月日</param> /// <param name="typeModel">参见模型</param> /// <returns>参见模型</returns> public static IEnumerable <T_IPSRPT_REPORT_OrgCountModel> getModelCount(T_IPSRPT_REPORT_SW sw, out IEnumerable <T_IPSRPT_REPORT_TypeCountModel> typeModel) { var result = new List <T_IPSRPT_REPORT_OrgCountModel>(); //获取上报信息 DataTable dt = BaseDT.T_IPSRPT_REPORT.getDTByOrgHUse(sw); //获取单位 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); //上报类别 DataTable dtReportType = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW { DICTTYPEID = "5" }); //上报类别 //out 类别 var resultReportType = new List <T_IPSRPT_REPORT_TypeCountModel>(); for (int i = 0; i < dtReportType.Rows.Count; i++) { T_IPSRPT_REPORT_TypeCountModel m = new T_IPSRPT_REPORT_TypeCountModel(); m.typeName = dtReportType.Rows[i]["DICTNAME"].ToString(); resultReportType.Add(m); } typeModel = resultReportType; if (1 == 1) { T_IPSRPT_REPORT_OrgCountModel m = new T_IPSRPT_REPORT_OrgCountModel(); m.HName = BaseDT.T_SYS_ORG.getName(sw.TopORGNO) + "合计"; m.ORGName = m.HName; m.ReportCount = BaseDT.T_IPSRPT_REPORT.getCountByOrgHUse(dt, sw.TopORGNO, "");//总数 var typeResult = new List <T_IPSRPT_REPORT_TypeCountModel>(); //循环类别 for (int k = 0; k < dtReportType.Rows.Count; k++) { T_IPSRPT_REPORT_TypeCountModel mm = new T_IPSRPT_REPORT_TypeCountModel(); mm.typeID = dtReportType.Rows[k]["DICTVALUE"].ToString(); mm.typeName = dtReportType.Rows[k]["DICTNAME"].ToString(); mm.typeCount = BaseDT.T_IPSRPT_REPORT.getCountByOrgHUse(dt, sw.TopORGNO, mm.typeID);//分类别统计 typeResult.Add(mm); } m.TypeCountModel = typeResult; result.Add(m); } if (PublicCls.OrgIsZhen(sw.TopORGNO) == false) { //循环单位 for (int i = 0; i < dtOrg.Rows.Count; i++) { T_IPSRPT_REPORT_OrgCountModel m = new T_IPSRPT_REPORT_OrgCountModel(); m.ORGName = dtOrg.Rows[i]["ORGNAME"].ToString(); m.ORGNo = dtOrg.Rows[i]["ORGNO"].ToString(); //m.HID = dt.Rows[i]["HID"].ToString(); m.ReportCount = BaseDT.T_IPSRPT_REPORT.getCountByOrgHUse(dt, m.ORGNo, "");//总数 var typeResult = new List <T_IPSRPT_REPORT_TypeCountModel>(); //循环类别 for (int k = 0; k < dtReportType.Rows.Count; k++) { T_IPSRPT_REPORT_TypeCountModel mm = new T_IPSRPT_REPORT_TypeCountModel(); mm.typeID = dtReportType.Rows[k]["DICTVALUE"].ToString(); mm.typeName = dtReportType.Rows[k]["DICTNAME"].ToString(); mm.typeCount = BaseDT.T_IPSRPT_REPORT.getCountByOrgHUse(dt, m.ORGNo, mm.typeID);//分类别统计 typeResult.Add(mm); } m.TypeCountModel = typeResult; result.Add(m); } //if(1==1) //合计 //{ // T_IPSRPT_REPORT_OrgCountModel m = new T_IPSRPT_REPORT_OrgCountModel(); // m.ORGName = "合计"; // m.ORGNo = sw.TopORGNO; // //m.HID = dt.Rows[i]["HID"].ToString(); // m.ReportCount = BaseDT.T_IPSRPT_REPORT.getCountByOrgHUse(dt, sw.TopORGNO, "");//总数 // var typeResult = new List<T_IPSRPT_REPORT_TypeCountModel>(); // //循环类别 // for (int k = 0; k < dtReportType.Rows.Count; k++) // { // T_IPSRPT_REPORT_TypeCountModel mm = new T_IPSRPT_REPORT_TypeCountModel(); // mm.typeID = dtReportType.Rows[k]["DICTVALUE"].ToString(); // mm.typeName = dtReportType.Rows[k]["DICTNAME"].ToString(); // mm.typeCount = BaseDT.T_IPSRPT_REPORT.getCountByOrgHUse(dt, sw.TopORGNO, mm.typeID);//分类别统计 // typeResult.Add(mm); // } // m.TypeCountModel = typeResult; // result.Add(m); //} } else//如果查询的单位为镇,显示所有护林员的统计信息 { DataTable dtHUser = BaseDT.T_IPSFR_USER.getDT(new T_IPSFR_USER_SW { BYORGNO = sw.TopORGNO }); for (int i = 0; i < dtHUser.Rows.Count; i++) { T_IPSRPT_REPORT_OrgCountModel m = new T_IPSRPT_REPORT_OrgCountModel(); m.HID = dtHUser.Rows[i]["HID"].ToString(); m.HName = dtHUser.Rows[i]["HNAME"].ToString(); m.ReportCount = BaseDT.T_IPSRPT_REPORT.getCountByHID(dt, m.HID, "");//总数 var typeResult = new List <T_IPSRPT_REPORT_TypeCountModel>(); //循环类别 for (int k = 0; k < dtReportType.Rows.Count; k++) { T_IPSRPT_REPORT_TypeCountModel mm = new T_IPSRPT_REPORT_TypeCountModel(); mm.typeID = dtReportType.Rows[k]["DICTVALUE"].ToString(); mm.typeName = dtReportType.Rows[k]["DICTNAME"].ToString(); mm.typeCount = BaseDT.T_IPSRPT_REPORT.getCountByHID(dt, m.HID, mm.typeID);//分类别统计 typeResult.Add(mm); } m.TypeCountModel = typeResult; result.Add(m); } dtHUser.Clear(); dtHUser.Dispose(); } dt.Clear(); dt.Dispose(); dtOrg.Clear(); dtOrg.Dispose(); dtReportType.Clear(); dtReportType.Dispose(); return(result); }
/// <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); }
/// <summary> /// 获取数据 /// </summary> /// <param name="sw">参见模型</param> /// <returns>DataTable</returns> public static DataTable getDT(T_IPSRPT_REPORT_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("SELECT REPORTID, HID, SYSTYPEVALUE, ADDRESS, REPORTTIME, COLLECTNAME, MANSTATE, MANRESULT,MANTIME, MANUSERID"); sb.AppendFormat(" FROM T_IPSRPT_REPORTDATA "); sb.AppendFormat(" WHERE 1=1"); //判断是否是多少,如果是多少,用in,如果只是一个,用= 主要考虑到速度 if (string.IsNullOrEmpty(sw.REPORTID) == false) { if (sw.REPORTID.Split(',').Length > 1) { sb.AppendFormat(" AND REPORTID in({0})", ClsSql.EncodeSql(sw.REPORTID)); } else { sb.AppendFormat(" AND REPORTID ='{0}'", ClsSql.EncodeSql(sw.REPORTID)); } } if (string.IsNullOrEmpty(sw.SYSTYPEVALUE) == false) { sb.AppendFormat(" AND SYSTYPEVALUE ='{0}'", ClsSql.EncodeSql(sw.SYSTYPEVALUE)); } if (string.IsNullOrEmpty(sw.MANSTATE) == false) { sb.AppendFormat(" AND MANSTATE ='{0}'", ClsSql.EncodeSql(sw.MANSTATE)); } //根据护林员ID查询 if (string.IsNullOrEmpty(sw.HID) == false) { sb.AppendFormat(" AND HID ='{0}'", ClsSql.EncodeSql(sw.HID)); } if (string.IsNullOrEmpty(sw.orgNo) == false) { if (PublicCls.OrgIsShi(sw.orgNo)) { sb.AppendFormat(" and HID in (SELECT HID FROM T_IPSFR_USER where BYORGNO like '{0}%')", PublicCls.getShiIncOrgNo(sw.orgNo)); } else if (PublicCls.OrgIsXian(sw.orgNo)) { sb.AppendFormat(" and HID in (SELECT HID FROM T_IPSFR_USER where BYORGNO like '{0}%')", PublicCls.getXianIncOrgNo(sw.orgNo)); } else if (PublicCls.OrgIsZhen(sw.orgNo)) { sb.AppendFormat(" and HID in (SELECT HID FROM T_IPSFR_USER where BYORGNO='{0}')", PublicCls.getZhenIncOrgNo(sw.orgNo)); } else { //sb.AppendFormat(" and HID in (SELECT HID FROM T_IPSFR_USER where BYORGNO='{0}')", PublicCls.getZhenIncOrgNo(sw.orgNo)); } } if (!string.IsNullOrEmpty(sw.DateBegin)) { sb.AppendFormat(" AND REPORTTIME>='{0} 00:00:00'", sw.DateBegin); } if (!string.IsNullOrEmpty(sw.DateEnd)) { sb.AppendFormat(" AND REPORTTIME<='{0} 23:59:59'", sw.DateEnd); } sb.AppendFormat(" ORDER BY REPORTTIME DESC "); DataSet ds = DataBaseClass.FullDataSet(sb.ToString()); return(ds.Tables[0]); }