/// <summary>
/// 上报数据信息
/// </summary>
/// <returns>参见模型</returns>
public JsonResult GetReportDataInfoAjax()
{
MessageObject ms = null;
string reportid = Request.Params["reportid"];
if (string.IsNullOrEmpty(reportid))
{
ms = new MessageObject(false, null);
return(Json(ms));
}
string maptype = Request.Params["maptype"];
var sw = new T_IPSRPT_REPORT_SW();
sw.REPORTID = reportid;
if (!string.IsNullOrEmpty(maptype))
{
sw.MapType = maptype;//地图类型
}
var list = T_IPSRPT_REPORTCls.getModelList(sw);
if (list.Any())
{
var model = list.FirstOrDefault();
ms = new MessageObject(true, model);
}
else
{
ms = new MessageObject(false, null);
}
return(Json(ms));
}
/// <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>
/// <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));
}
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>
/// 检索获取数据上报数据
/// </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));
}
public FileResult ReportCountExportExcel()
{
//ViewBag.ExportExcelUrl = string.Format("/HUReport/ReportCountExportExcel?TIMEBegin={0}&TIMEEnd={1}&BYORGNO={2}&HID={3}&SYSTYPEVALUE={4}"
string BYORGNO = Request.Params["BYORGNO"];
string TIMEBegin = Request.Params["TIMEBegin"];
string TIMEEnd = Request.Params["TIMEEnd"];
string HID = Request.Params["HID"];
string SYSTYPEVALUE = Request.Params["SYSTYPEVALUE"];
var vMenu = T_SYS_MENUCls.getModel(new T_SYS_MENU_SW {
MENUCODE = "004003", SYSFLAG = ConfigCls.getSystemFlag()
});
//vMenu.MENUNAME 页面/菜单名称
NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook();
NPOI.SS.UserModel.ISheet sheet1 = book.CreateSheet("Sheet1"); //添加一个sheet
sheet1.IsPrintGridlines = true; //打印时显示网格线
sheet1.DisplayGridlines = true; //查看时显示网格线
IRow row = sheet1.CreateRow(0);
row.CreateCell(0).SetCellValue(vMenu.MENUNAME);
row.GetCell(0).CellStyle = getCellStyleTitle(book);
IEnumerable <T_IPSRPT_REPORT_TypeCountModel> typeModel;
var list = T_IPSRPT_REPORTCls.getModelCount(new T_IPSRPT_REPORT_SW {
TopORGNO = BYORGNO, DateBegin = TIMEBegin, DateEnd = TIMEEnd
}, out typeModel);
int typeCount = 0;//计算类别有多少列
foreach (var v in typeModel)
{
typeCount++;
}
//设置宽度
sheet1.SetColumnWidth(0, 30 * 256);
sheet1.SetColumnWidth(1, 20 * 256);
for (int i = 0; i < typeCount; i++)
{
sheet1.SetColumnWidth(i + 2, 20 * 256);
}
row = sheet1.CreateRow(1);
if (PublicCls.OrgIsZhen(BYORGNO) == false)
{
row.CreateCell(0).SetCellValue("单位");
}
else
{
row.CreateCell(0).SetCellValue("姓名");
}
row.CreateCell(1).SetCellValue("总数");
int indexType = 2;//从第二列开始
foreach (var v in typeModel)
{
row.CreateCell(indexType).SetCellValue(v.typeName);
indexType++;
}
for (int i = 0; i < typeCount + 2; i++)
{
row.GetCell(i).CellStyle = getCellStyleHead(book);
}
sheet1.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(0, 0, 0, typeCount + 1));
int rowI = 0; //数据行
foreach (var v in list) //循环获取数据
{
row = sheet1.CreateRow(rowI + 2);
if (string.IsNullOrEmpty(v.ORGName) == false)
{
row.CreateCell(0).SetCellValue(v.ORGName);
row.GetCell(0).CellStyle = getCellStyleLeft(book);
}
else
{
row.CreateCell(0).SetCellValue(v.HName);
row.GetCell(0).CellStyle = getCellStyleCenter(book);
}
row.CreateCell(1).SetCellValue(v.ReportCount);
row.GetCell(1).CellStyle = getCellStyleCenter(book);
int TypeI = 2;//类型开始列
foreach (var vv in v.TypeCountModel)
{
row.CreateCell(TypeI).SetCellValue(vv.typeCount);
row.GetCell(TypeI).CellStyle = getCellStyleCenter(book);
TypeI++;
}
rowI++;
}
// 写入到客户端
System.IO.MemoryStream ms = new System.IO.MemoryStream();
book.Write(ms);
ms.Seek(0, SeekOrigin.Begin);
string fileName = vMenu.MENUNAME + DateTime.Now.ToString("yyyy-MM-dd") + ".xls";
return(File(ms, "application/vnd.ms-excel", fileName));
}
/// <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));
}
