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