/// <summary>
/// 获取火情反馈表信息
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static DataTable GetDT(JC_FIRETICKLING_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.Append(" select * from JC_FIRETICKLING");
sb.Append(" where 1 = 1 ");
if (!string.IsNullOrEmpty(sw.JCFID))
{
sb.AppendFormat(" And JCFID='{0}'", sw.JCFID);
}
if (!string.IsNullOrEmpty(sw.MANSTATE))
{
sb.AppendFormat(" And MANSTATE={0}", sw.MANSTATE);
}
if (!string.IsNullOrEmpty(sw.MANUSERID))
{
sb.AppendFormat(" And MANUSERID={0}", sw.MANUSERID);
}
if (!string.IsNullOrEmpty(sw.BYORGNO))
{
sb.AppendFormat(" And BYORGNO={0}", sw.BYORGNO);
}
DataSet ds = DataBaseClass.FullDataSet(sb.ToString());
return(ds.Tables[0]);
}
/// <summary>
/// 获取反馈信息模型
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static IEnumerable <JC_FIRETICKLING_Model> GetModelList(JC_FIRETICKLING_SW sw)
{
var result = new List <JC_FIRETICKLING_Model>();
DataTable dt = BaseDT.JC_FIRETICKLING.GetDT(sw);//获取反馈信息记录
for (int i = 0; i < dt.Rows.Count; i++)
{
var model = new JC_FIRETICKLING_Model();
model.FKID = dt.Rows[i]["FKID"].ToString();
model.JCFID = dt.Rows[i]["JCFID"].ToString();
model.DL = dt.Rows[i]["DL"].ToString();
model.FORESTNAME = dt.Rows[i]["FORESTNAME"].ToString();
model.FORESTFIRETYPE = dt.Rows[i]["FORESTFIRETYPE"].ToString();
model.FUELTYPE = dt.Rows[i]["FUELTYPE"].ToString();
model.HOTTYPE = dt.Rows[i]["HOTTYPE"].ToString();
model.CHECKTIME = dt.Rows[i]["CHECKTIME"] == null ? "" : ClsSwitch.SwitTM(dt.Rows[i]["CHECKTIME"].ToString());
model.YY = dt.Rows[i]["YY"].ToString();
model.JXHQSJ = dt.Rows[i]["JXHQSJ"].ToString();
model.FIREBEGINTIME = dt.Rows[i]["FIREBEGINTIME"] == null ? "" : ClsSwitch.SwitTM(dt.Rows[i]["FIREBEGINTIME"].ToString());
model.FIREENDTIME = dt.Rows[i]["FIREENDTIME"] == null ? "" : ClsSwitch.SwitTM(dt.Rows[i]["FIREENDTIME"].ToString());
model.ISOUTFIRE = dt.Rows[i]["ISOUTFIRE"].ToString();
model.BURNEDAREA = dt.Rows[i]["BURNEDAREA"].ToString();
model.OVERDOAREA = dt.Rows[i]["OVERDOAREA"].ToString();
model.LOSTFORESTAREA = dt.Rows[i]["LOSTFORESTAREA"].ToString();
model.ELSELOSSINTRO = dt.Rows[i]["ELSELOSSINTRO"].ToString();
model.FIREINTRO = dt.Rows[i]["FIREINTRO"].ToString();
model.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
model.MANUSERID = dt.Rows[i]["MANUSERID"].ToString();
model.MANTIME = dt.Rows[i]["MANTIME"].ToString();
model.MANSTATE = dt.Rows[i]["MANSTATE"].ToString();
result.Add(model);
}
return(result);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Add(JC_FIRETICKLING_SW m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("INSERT INTO JC_FIRETICKLING(JCFID,DL,FORESTNAME,FORESTFIRETYPE,FUELTYPE,HOTTYPE,CHECKTIME,YY,JXHQSJ,FIREBEGINTIME,FIREENDTIME,ISOUTFIRE,BURNEDAREA,OVERDOAREA,LOSTFORESTAREA,ELSELOSSINTRO,FIREINTRO,BYORGNO,MANUSERID,MANTIME,MANSTATE)");
sb.AppendFormat("VALUES(");
sb.AppendFormat("'{0}'", ClsSql.EncodeSql(m.JCFID));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.DL));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.FORESTNAME));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.FORESTFIRETYPE));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.FUELTYPE));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.HOTTYPE));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(ClsSwitch.SwitTM(m.CHECKTIME)));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.YY));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.JXHQSJ));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(ClsSwitch.SwitTM(m.FIREBEGINTIME)));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(ClsSwitch.SwitTM(m.FIREENDTIME)));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.ISOUTFIRE));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.BURNEDAREA));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.OVERDOAREA));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.LOSTFORESTAREA));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.ELSELOSSINTRO));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.FIREINTRO));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.BYORGNO));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.MANUSERID));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(ClsSwitch.SwitTM(m.MANTIME)));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.MANSTATE));
sb.AppendFormat(")");
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "添加成功！", ""));
}
else
{
logs.Error(sb.ToString());
return(new Message(false, "添加失败，请检查各输入框是否正确！", ""));
}
}
/// <summary>
/// 增、删、改
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Manager(JC_FIRETICKLING_SW m)
{
if (m.opMethod == "Add")
{
//SystemCls.LogSave("3", "红外相机:" + m.INFRAREDCAMERANAME, ClsStr.getModelContent(m));
Message msgUser = BaseDT.JC_FIRETICKLING.Add(m);
return(new Message(msgUser.Success, msgUser.Msg, ""));
}
//if (m.opMethod == "Mdy")
//{
// SystemCls.LogSave("4", "红外相机:" + m.INFRAREDCAMERANAME, ClsStr.getModelContent(m));
// Message msgUser = BaseDT.JC_INFRAREDCAMERA_BASICINFO.Mdy(m);
// return new Message(msgUser.Success, msgUser.Msg, m.returnUrl);
//}
//if (m.opMethod == "Del")
//{
// SystemCls.LogSave("5", "红外相机:" + m.INFRAREDCAMERANAME, ClsStr.getModelContent(m));
// Message msgUser = BaseDT.JC_INFRAREDCAMERA_BASICINFO.Del(m);
// return new Message(msgUser.Success, msgUser.Msg, m.returnUrl);
//}
return(new Message(false, "无效操作", ""));
}
/// <summary>
/// 获取最新的火情反馈信息
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static JC_FIRETICKLING_Model getLatestfeedback(JC_FIRETICKLING_SW sw)
{
DataTable dt = BaseDT.JC_FIRETICKLING.Latestfeedback(sw);
DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
}); //获取单位
DataTable dt7 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "7"
}); //数据中心地类类型
DataTable dt8 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "8"
}); //数据中心林火类型
DataTable dt9 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "9"
}); //数据中心可燃物类别
DataTable dt10 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "10"
}); //热点类别
JC_FIRETICKLING_Model m = new JC_FIRETICKLING_Model();
//JCFireFKInfoModel m = new JCFireFKInfoModel();
if (dt.Rows.Count == 1)
{
m.DL = dt.Rows[0]["DL"].ToString();
m.DLName = BaseDT.T_SYS_DICT.getName(dt7, m.DL);
m.FORESTNAME = dt.Rows[0]["FORESTNAME"].ToString();
m.FORESTFIRETYPE = dt.Rows[0]["FORESTFIRETYPE"].ToString();
m.FORESTFIRETYPENAME = BaseDT.T_SYS_DICT.getName(dt8, m.FORESTFIRETYPE);
m.FUELTYPE = dt.Rows[0]["FUELTYPE"].ToString();
m.FUELTYPEName = BaseDT.T_SYS_DICT.getName(dt9, m.FUELTYPE);
m.HOTTYPE = dt.Rows[0]["HOTTYPE"].ToString();
m.HOTTYPEName = BaseDT.T_SYS_DICT.getName(dt10, m.HOTTYPE);
m.CHECKTIME = ClsSwitch.SwitTM(dt.Rows[0]["CHECKTIME"].ToString());
m.YY = dt.Rows[0]["YY"].ToString();
m.JXHQSJ = dt.Rows[0]["JXHQSJ"].ToString();
m.FIREBEGINTIME = ClsSwitch.SwitTM(dt.Rows[0]["FIREBEGINTIME"].ToString());
m.FIREENDTIME = ClsSwitch.SwitTM(dt.Rows[0]["FIREENDTIME"].ToString());
m.ISOUTFIRE = dt.Rows[0]["ISOUTFIRE"].ToString();
m.BURNEDAREA = dt.Rows[0]["BURNEDAREA"].ToString();
m.OVERDOAREA = dt.Rows[0]["OVERDOAREA"].ToString();
m.LOSTFORESTAREA = dt.Rows[0]["LOSTFORESTAREA"].ToString();
m.ELSELOSSINTRO = dt.Rows[0]["ELSELOSSINTRO"].ToString();
m.FIREINTRO = dt.Rows[0]["FIREINTRO"].ToString();
m.BYORGNO = dt.Rows[0]["BYORGNO"].ToString();
m.MANUSERID = dt.Rows[0]["MANUSERID"].ToString();
m.MANSTATE = dt.Rows[0]["MANSTATE"].ToString();
m.MANTIME = dt.Rows[0]["MANTIME"].ToString();
m.AUDITREASON = dt.Rows[0]["AUDITREASON"].ToString(); //审核不通过理由
m.ADDRESS = dt.Rows[0]["ADDRESS"].ToString(); //实际发生地
m.JD = dt.Rows[0]["JD"].ToString();
m.WD = dt.Rows[0]["WD"].ToString();
m.ORGNAME = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO);
//m.JC_FireFKData.JD = string.IsNullOrEmpty(dt.Rows[0]["JD"].ToString()) ? dt.Rows[0]["JCJD"].ToString() : dt.Rows[0]["JD"].ToString();//实际发生经度
//m.JC_FireFKData.WD = string.IsNullOrEmpty(dt.Rows[0]["WD"].ToString()) ? dt.Rows[0]["JCWD"].ToString() : dt.Rows[0]["WD"].ToString();//实际发生纬度
}
dt.Clear();
dt.Dispose();
dt7.Clear();
dt7.Dispose();
dt8.Clear();
dt8.Dispose();
dt9.Clear();
dt9.Dispose();
dt10.Clear();
dt10.Dispose();
return(m);
}
/// <summary>
/// 根据JCFID获取最新的反馈信息
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static DataTable Latestfeedback(JC_FIRETICKLING_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" Select top 1 * from JC_FIRETICKLING Where 1=1 ");
if (!string.IsNullOrEmpty(sw.JCFID))
{
sb.AppendFormat(" AND JCFID ={0}", ClsSql.EncodeSql(sw.JCFID));
}
if (!string.IsNullOrEmpty(sw.DL))
{
sb.AppendFormat(" AND DL ={0}", ClsSql.EncodeSql(sw.DL));
}
if (!string.IsNullOrEmpty(sw.FORESTNAME))
{
sb.AppendFormat(" AND FORESTNAME ={0}", ClsSql.EncodeSql(sw.FORESTNAME));
}
if (!string.IsNullOrEmpty(sw.FORESTFIRETYPE))
{
sb.AppendFormat(" AND FORESTFIRETYPE ={0}", ClsSql.EncodeSql(sw.FORESTFIRETYPE));
}
if (!string.IsNullOrEmpty(sw.FUELTYPE))
{
sb.AppendFormat(" AND FUELTYPE ={0}", ClsSql.EncodeSql(sw.FUELTYPE));
}
if (!string.IsNullOrEmpty(sw.HOTTYPE))
{
sb.AppendFormat(" AND HOTTYPE ={0}", ClsSql.EncodeSql(sw.HOTTYPE));
}
if (!string.IsNullOrEmpty(sw.CHECKTIME))
{
sb.AppendFormat(" AND CHECKTIME ={0}", ClsSql.EncodeSql(sw.CHECKTIME));
}
if (!string.IsNullOrEmpty(sw.YY))
{
sb.AppendFormat(" AND YY ={0}", ClsSql.EncodeSql(sw.YY));
}
if (!string.IsNullOrEmpty(sw.JXHQSJ))
{
sb.AppendFormat(" AND JXHQSJ ={0}", ClsSql.EncodeSql(sw.JXHQSJ));
}
if (!string.IsNullOrEmpty(sw.FIREBEGINTIME))
{
sb.AppendFormat(" AND FIREBEGINTIME ={0}", ClsSql.EncodeSql(sw.FIREBEGINTIME));
}
if (!string.IsNullOrEmpty(sw.ISOUTFIRE))
{
sb.AppendFormat(" AND ISOUTFIRE ={0}", ClsSql.EncodeSql(sw.ISOUTFIRE));
}
if (!string.IsNullOrEmpty(sw.OVERDOAREA))
{
sb.AppendFormat(" AND OVERDOAREA ={0}", ClsSql.EncodeSql(sw.OVERDOAREA));
}
if (!string.IsNullOrEmpty(sw.LOSTFORESTAREA))
{
sb.AppendFormat(" AND LOSTFORESTAREA ={0}", ClsSql.EncodeSql(sw.LOSTFORESTAREA));
}
if (!string.IsNullOrEmpty(sw.ELSELOSSINTRO))
{
sb.AppendFormat(" AND ELSELOSSINTRO ={0}", ClsSql.EncodeSql(sw.ELSELOSSINTRO));
}
if (!string.IsNullOrEmpty(sw.FIREINTRO))
{
sb.AppendFormat(" AND FIREINTRO ={0}", ClsSql.EncodeSql(sw.FIREINTRO));
}
if (!string.IsNullOrEmpty(sw.BYORGNO))
{
sb.AppendFormat(" AND BYORGNO ={0}", ClsSql.EncodeSql(sw.BYORGNO));
}
if (!string.IsNullOrEmpty(sw.MANUSERID))
{
sb.AppendFormat(" AND MANUSERID ={0}", ClsSql.EncodeSql(sw.MANUSERID));
}
if (!string.IsNullOrEmpty(sw.MANTIME))
{
sb.AppendFormat(" AND MANTIME ={0}", ClsSql.EncodeSql(sw.MANTIME));
}
if (!string.IsNullOrEmpty(sw.MANSTATE))
{
sb.AppendFormat(" AND MANSTATE ={0}", ClsSql.EncodeSql(sw.MANSTATE));
}
if (!string.IsNullOrEmpty(sw.AUDITREASON))
{
sb.AppendFormat(" AND AUDITREASON ={0}", ClsSql.EncodeSql(sw.AUDITREASON));
}
if (!string.IsNullOrEmpty(sw.ADDRESS))
{
sb.AppendFormat(" AND ADDRESS ={0}", ClsSql.EncodeSql(sw.ADDRESS));
}
if (!string.IsNullOrEmpty(sw.JD))
{
sb.AppendFormat(" AND JD ={0}", ClsSql.EncodeSql(sw.JD));
}
if (!string.IsNullOrEmpty(sw.WD))
{
sb.AppendFormat(" AND WD ={0}", ClsSql.EncodeSql(sw.WD));
}
sb.AppendFormat(" order by MANTIME desc ");
DataSet ds = DataBaseClass.FullDataSet(sb.ToString());
return(ds.Tables[0]);
}
/// <summary>
/// 签收
/// </summary>
/// <param name="jcfire"></param>
/// <param name="jcfirefk"></param>
/// <returns></returns>
public static Message QSFireTrans(JC_FIRE_Model jcfire, JC_FIRETICKLING_SW jcfirefk)
{
return(BaseDT.JC_FIRE.QSFire(jcfire, jcfirefk));
}
