/// <summary>
/// 字典名称下拉框
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static string getSelectOption(T_SYS_DICTSW sw)
{
StringBuilder sb = new StringBuilder();
DataTable dt = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = sw.DICTTYPEID, DICTTYPENAME = sw.DICTTYPENAME, DICTFLAG = sw.DICTFLAG, STANDBY1 = sw.STANDBY1
});
if (sw.isShowAll == "1")
{
sb.AppendFormat("<option value=\"\">{0}</option>", "--所有--");
}
for (int i = 0; i < dt.Rows.Count; i++)
{
string text = dt.Rows[i]["DICTNAME"].ToString();
if (sw.STANDBY1InName == "1")
{
text = dt.Rows[i]["STANDBY1"].ToString() + "-" + text;
}
if (sw.DICTVALUE == dt.Rows[i]["DICTVALUE"].ToString())
{
sb.AppendFormat("<option value=\"{0}\" selected>{1}</option>", dt.Rows[i]["DICTVALUE"].ToString(), text);
}
else
{
sb.AppendFormat("<option value=\"{0}\">{1}</option>", dt.Rows[i]["DICTVALUE"].ToString(), text);
}
}
return(sb.ToString());
}
/// <summary>
/// 获取字典类型数据
/// </summary>
/// <returns>参见模型</returns>
public JsonResult GetDicDataAjax()
{
var sw = new T_SYS_DICTSW();
sw.DICTTYPEID = Request.Params["TYPEID"];;
sw.DICTVALUE = Request.Params["TID"];
var model = T_SYS_DICTCls.getModel(sw);
return(Json(model));
}
/// <summary>
/// 组成档案树形菜单
/// </summary>
/// <returns></returns>
public static string getARCHIVESTree(T_SYS_DICTSW sw)
{
DataTable dtDICT = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
});
string dicttypeid = "22";
JArray ARCHIVES = getARCHIVESChild(dtDICT, dicttypeid);
dtDICT.Clear();
dtDICT.Dispose();
return(JsonConvert.SerializeObject(ARCHIVES));
}
/// <summary>
/// 获取数据字典类型多少条记录
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static string getCount(T_SYS_DICTSW sw)
{
string total = "";
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" from T_SYS_DICT a ");
sb.AppendFormat("where ");
sb.AppendFormat("DICTTYPEID = '{0}'", ClsSql.EncodeSql(sw.DICTTYPEID));
string sqlC = "select count(1) " + sb.ToString();
//total = DataBaseClass.ReturnSqlField(sqlC);
total = (DataBaseClass.ReturnSqlField(sqlC)).ToString();
return(total);
}
/// <summary>
/// 获取字典名称
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns></returns>
public static string getName(T_SYS_DICTSW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("SELECT DICTNAME FROM T_SYS_DICT WHERE 1=1");
if (!string.IsNullOrEmpty(sw.DICTTYPEID))
{
sb.AppendFormat(" AND DICTTYPEID='{0}'", sw.DICTTYPEID);
}
if (!string.IsNullOrEmpty(sw.DICTVALUE))
{
sb.AppendFormat(" AND DICTVALUE='{0}'", sw.DICTVALUE);
}
return(DataBaseClass.ReturnSqlField(sb.ToString()));
}
/// <summary>
/// 获取某项字典列表
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static DataTable getDT(T_SYS_DICTSW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("SELECT DICTID,DICTTYPEID,DICTNAME, DICTVALUE,ORDERBY, STANDBY1,STANDBY2, STANDBY3, STANDBY4");
sb.AppendFormat(" FROM T_SYS_DICT");
sb.AppendFormat(" WHERE 1=1");
if (string.IsNullOrEmpty(sw.DICTID) == false)
{
sb.AppendFormat(" AND DICTID = '{0}'", sw.DICTID);
}
if (string.IsNullOrEmpty(sw.DICTTYPEID) == false)
{
sb.AppendFormat(" AND DICTTYPEID = '{0}'", sw.DICTTYPEID);
}
if (string.IsNullOrEmpty(sw.DICTVALUE) == false)
{
string[] arr = sw.DICTVALUE.Split(',');
if (arr.Length == 1)
{
sb.AppendFormat(" AND DICTVALUE = '{0}'", sw.DICTVALUE);
}
else
{
sb.AppendFormat(" AND DICTVALUE in({0})", sw.DICTVALUE);
}
}
if (string.IsNullOrEmpty(sw.DICTTYPENAME) == false)
{
sb.AppendFormat(" AND DICTTYPEID=(SELECT DICTTYPEID FROM T_SYS_DICTTYPE where DICTTYPENAME = '{0}')", sw.DICTTYPENAME);
}
if (string.IsNullOrEmpty(sw.DICTFLAG) == false)
{
sb.AppendFormat(" AND DICTTYPEID=(SELECT DICTTYPEID FROM T_SYS_DICTTYPE where DICTTYPENAME = '{0}')", sw.DICTFLAG);
}
if (!string.IsNullOrEmpty(sw.STANDBY1))
{
sb.AppendFormat(" AND STANDBY1= '{0}'", sw.STANDBY1);
}
sb.AppendFormat(" ORDER BY ORDERBY");
DataSet ds = DataBaseClass.FullDataSet(sb.ToString());
return(ds.Tables[0]);
}
/// <summary>
/// 获取字典数据列表
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static IEnumerable <T_SYS_DICTModel> getListModel(T_SYS_DICTSW sw)
{
var result = new List <T_SYS_DICTModel>();
DataTable dt = BaseDT.T_SYS_DICT.getDT(sw);
for (int i = 0; i < dt.Rows.Count; i++)
{
T_SYS_DICTModel m = new T_SYS_DICTModel();
m.DICTID = dt.Rows[i]["DICTID"].ToString();
m.DICTTYPEID = dt.Rows[i]["DICTTYPEID"].ToString();
m.DICTNAME = dt.Rows[i]["DICTNAME"].ToString();
m.DICTVALUE = dt.Rows[i]["DICTVALUE"].ToString();
m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString();
m.STANDBY1 = dt.Rows[i]["STANDBY1"].ToString();
m.STANDBY2 = dt.Rows[i]["STANDBY2"].ToString();
m.STANDBY3 = dt.Rows[i]["STANDBY3"].ToString();
m.STANDBY4 = dt.Rows[i]["STANDBY4"].ToString();
result.Add(m);
}
dt.Clear();
dt.Dispose();
return(result);
}
/// <summary>
/// 获取单条记录
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static T_SYS_DICTModel getModel(T_SYS_DICTSW sw)
{
DataTable dt = BaseDT.T_SYS_DICT.getDT(sw);
T_SYS_DICTModel m = new T_SYS_DICTModel();
if (dt.Rows.Count > 0)
{
int i = 0;
//数据库表字段
m.DICTID = dt.Rows[i]["DICTID"].ToString();
m.DICTTYPEID = dt.Rows[i]["DICTTYPEID"].ToString();
m.DICTNAME = dt.Rows[i]["DICTNAME"].ToString();
m.DICTVALUE = dt.Rows[i]["DICTVALUE"].ToString();
m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString();
m.STANDBY1 = dt.Rows[i]["STANDBY1"].ToString();
m.STANDBY2 = dt.Rows[i]["STANDBY2"].ToString();
m.STANDBY3 = dt.Rows[i]["STANDBY3"].ToString();
m.STANDBY4 = dt.Rows[i]["STANDBY4"].ToString();
//扩充字段
}
dt.Clear();
dt.Dispose();
return(m);
}
/// <summary>
/// 判断记录是否存在
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>true 存在记录 false 不存在</returns>
public static bool isExists(T_SYS_DICTSW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("SELECT 1");
sb.AppendFormat(" FROM T_SYS_DICT");
sb.AppendFormat(" WHERE 1=1");
//if (string.IsNullOrEmpty(sw.DICTID) == false)
// sb.AppendFormat(" AND DICTID = '{0}'", sw.DICTID);
if (string.IsNullOrEmpty(sw.DICTTYPEID) == false)
{
sb.AppendFormat(" AND DICTTYPEID = '{0}'", sw.DICTTYPEID);
}
if (string.IsNullOrEmpty(sw.DICTVALUE) == false)
{
sb.AppendFormat(" AND DICTVALUE = '{0}'", sw.DICTVALUE);
}
//if (string.IsNullOrEmpty(sw.DICTTYPENAME) == false)
// sb.AppendFormat(" AND DICTTYPEID=(SELECT DICTTYPEID FROM T_SYS_DICTTYPE where DICTTYPENAME = '{0}')", sw.DICTTYPENAME);
//if (string.IsNullOrEmpty(sw.DICTFLAG) == false)
// sb.AppendFormat(" AND DICTTYPEID=(SELECT DICTTYPEID FROM T_SYS_DICTTYPE where DICTTYPENAME = '{0}')", sw.DICTFLAG);
sb.AppendFormat(" ORDER BY ORDERBY");
return(DataBaseClass.JudgeRecordExists(sb.ToString()));
}
/// <summary>
/// 获取字典名称
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns></returns>
public static string getDicName(T_SYS_DICTSW sw)
{
return(BaseDT.T_SYS_DICT.getName(sw));
}
/// <summary>
/// 菜单
/// </summary>
/// <returns></returns>
public ActionResult Index()
{
pubViewBag("020002", "020002", "二维护林员");
var CenterX = Request.Params["CenterX"];
var CenterY = Request.Params["CenterY"];
var CenterZ = Request.Params["CenterZ"];
if (string.IsNullOrEmpty(CenterX) == false && string.IsNullOrEmpty(CenterY) == false)
{
double[] arr = ClsPositionTrans.GpsTransform(double.Parse(CenterY), double.Parse(CenterX), "1");
CenterX = arr[1].ToString();
CenterY = arr[0].ToString();
}
else
{
CenterX = ConfigCls.getConfigValue("Longitude");
CenterY = ConfigCls.getConfigValue("Latitude");
}
if (string.IsNullOrEmpty(CenterZ) == false)
{
if (Convert.ToDouble(CenterZ) >= 571000)
{
CenterZ = "8";
}
else if (Convert.ToDouble(CenterZ) >= 321000 && Convert.ToDouble(CenterZ) < 571000)
{
CenterZ = "9";
}
else if (Convert.ToDouble(CenterZ) >= 138000 && Convert.ToDouble(CenterZ) < 321000)
{
CenterZ = "10";
}
else if (Convert.ToDouble(CenterZ) >= 65000 && Convert.ToDouble(CenterZ) < 138000)
{
CenterZ = "11";
}
else if (Convert.ToDouble(CenterZ) >= 37000 && Convert.ToDouble(CenterZ) < 65000)
{
CenterZ = "12";
}
else if (Convert.ToDouble(CenterZ) >= 12600 && Convert.ToDouble(CenterZ) < 37000)
{
CenterZ = "13";
}
else if (Convert.ToDouble(CenterZ) >= 5980 && Convert.ToDouble(CenterZ) < 12600)
{
CenterZ = "14";
}
else if (Convert.ToDouble(CenterZ) >= 3700 && Convert.ToDouble(CenterZ) < 5980)
{
CenterZ = "15";
}
else if (Convert.ToDouble(CenterZ) >= 2390 && Convert.ToDouble(CenterZ) < 3700)
{
CenterZ = "16";
}
else if (Convert.ToDouble(CenterZ) >= 1096 && Convert.ToDouble(CenterZ) < 2390)
{
CenterZ = "17";
}
else if (Convert.ToDouble(CenterZ) >= 635 && Convert.ToDouble(CenterZ) < 1096)
{
CenterZ = "18";
}
else if (Convert.ToDouble(CenterZ) < 635)
{
CenterZ = "19";
}
}
else
{
CenterZ = "10";
}
ViewBag.CenterX = CenterX;
ViewBag.CenterY = CenterY;
ViewBag.CenterZ = CenterZ;
ViewBag.rights = T_SYSSEC_RIGHTCls.getRightStrByUID(new T_SYSSEC_IPSUSER_SW {
USERID = SystemCls.getUserID()
});
string method = Request.Params["Method"];
string str = ViewBag.getPageMenuStr;
ViewBag.getPageMenuStr = str.Replace("window.location.href='/Home/Index?Method=report&TID=1';", "getReport("1","0","火情")")
.Replace("window.location.href='/Home/Index?Method=report&TID=2';", "getReport("2","0","病虫害")")
.Replace("window.location.href='/Home/Index?Method=report&TID=3';", "getReport("3","0","盗砍盗伐")")
.Replace("window.location.href='/Home/Index?Method=report&TID=4';", "getReport("4","0","安全隐患")")
.Replace("window.location.href='/Home/Index?Method=collect&TID=1';", "getCollect("1","0","建筑物")")
.Replace("window.location.href='/Home/Index?Method=collect&TID=2';", "getCollect("2","0","消防设施")")
.Replace("window.location.href='/Home/Index?Method=collect&TID=3';", "getCollect("3","0","道路")")
.Replace("window.location.href='/Home/Index?Method=collect&TID=4';", "getCollect("4","0","可燃物载量")")
.Replace("window.location.href='/Home/Index';", "(getLonLat(""))")
.Replace("window.location.href='/Home/Index?Method=dm';", "(GetDmFun())")
.Replace("window.location.href='/Home/Index?Method=hot';", "(getHot("0"))")
.Replace("window.location.href='/Home/Index?Method=alarm';", "(getAlarm("0"))")
.Replace("window.location.href='/Home/Index?Method=dl';", "(GetElecFun())");
ViewBag.getPageMenuStr = ViewBag.getPageMenuStr;
switch (method)
{
case "alarm":
ViewBag.loadFunc = "getAlarm(\"0\")"; //一键报警
break;
case "hot":
ViewBag.loadFunc = "getHot(\"0\")"; //热点
break;
case "report": //数据上报
var reportsw = new T_SYS_DICTSW();
reportsw.DICTTYPEID = "5";
reportsw.DICTVALUE = Request.Params["TID"];
var reportmodel = T_SYS_DICTCls.getModel(reportsw);
ViewBag.loadFunc = "getReport(\"" + Request.Params["TID"] + "\",\"0\",\"" + reportmodel.DICTNAME + "\")"; //1 火情 2 病虫害 3 盗砍盗伐 //第一个参数是数据类型 第二个参数是处理状态
break;
case "collect": //数据采集
var sw = new T_SYS_DICTSW();
sw.DICTTYPEID = "4";
sw.DICTVALUE = Request.Params["TID"];
var model = T_SYS_DICTCls.getModel(sw);
ViewBag.loadFunc = "getCollect(\"" + Request.Params["TID"] + "\",\"0\",\"" + model.DICTNAME + "\")"; //第一个参数是数据类型 第二个参数是处理状态 第三个参数名字
break;
default:
ViewBag.loadFunc = "getLonLat(\"\")";
break;
}
string TID = Request.Params["TID"];
if (method == "report")//上报
{
var sw = new T_SYS_DICTSW();
sw.DICTTYPEID = "5";
sw.DICTVALUE = TID;
var model = T_SYS_DICTCls.getModel(sw);
if (TID.Length == 1)
{
pubViewBag("00200" + TID, "00200" + TID, model.DICTNAME);
}
else if (TID.Length == 2)
{
pubViewBag("0020" + TID, "0020" + TID, model.DICTNAME);
}
else
{
pubViewBag("002" + TID, "002" + TID, model.DICTNAME);
}
}
else if (method == "collect")//采集
{
var sw = new T_SYS_DICTSW();
sw.DICTTYPEID = "4";
sw.DICTVALUE = TID;
var model = T_SYS_DICTCls.getModel(sw);
if (TID.Length == 1)
{
pubViewBag("00300" + TID, "00300" + TID, model.DICTNAME);
}
else if (TID.Length == 2)
{
pubViewBag("0030" + TID, "0030" + TID, model.DICTNAME);
}
else
{
pubViewBag("003" + TID, "003" + TID, model.DICTNAME);
}
}
else if (method == "dm")
{
pubViewBag("001002", "001002", "点名管理");
}
else if (method == "dl")
{
pubViewBag("001005", "001005", "电量查询");
}
else if (method == "hot")
{
pubViewBag("001003", "001003", "热点追踪");
}
else if (method == "alarm")
{
pubViewBag("001004", "001004", "报警管理");
}
else
{
pubViewBag("001001", "001001", "巡查监控");
}
ViewBag.Method = Request.Params["Method"]; //类别方法 用于GIS页面
ViewBag.TID = Request.Params["TID"]; //类别ID
return(View());
}
/// <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));
}
