/// <summary>
/// 获取单条数据
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static FIRERECORD_FIREINFO_Model getModel(FIRERECORD_FIREINFO_SW sw)
{
DataTable dt = BaseDT.FIRERECORD_FIREINFO.getDT2(sw);
FIRERECORD_FIREINFO_Model m = new FIRERECORD_FIREINFO_Model();
DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
}); //获取单位
if (dt != null && dt.Rows.Count > 0)
{
int i = 0;
m.FRFIID = dt.Rows[i]["FRFIID"].ToString();
m.JCFID = dt.Rows[i]["JCFID"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
m.FIRECODE = dt.Rows[i]["FIRECODE"].ToString();
m.FIREADDRESSCOUNTY = dt.Rows[i]["FIREADDRESSCOUNTY"].ToString();
m.FIREADDRESSTOWNS = dt.Rows[i]["FIREADDRESSTOWNS"].ToString();
m.ORGNAME = BaseDT.T_SYS_ORG.getName(dtORG, m.FIREADDRESSTOWNS);
m.FIREADDRESSVILLAGES = dt.Rows[i]["FIREADDRESSVILLAGES"].ToString();
m.FIRETIME = ClsSwitch.SwitTM(dt.Rows[i]["FIRETIME"].ToString());
m.FIREENDTIME = ClsSwitch.SwitTM(dt.Rows[i]["FIREENDTIME"].ToString());
m.FIREADDRESS = dt.Rows[i]["FIREADDRESS"].ToString();
m.FIRERECINFO000 = dt.Rows[i]["FIRERECINFO000"].ToString();
m.FIRERECINFO001 = dt.Rows[i]["FIRERECINFO001"].ToString();
m.FIRERECINFO020 = dt.Rows[i]["FIRERECINFO020"].ToString();
m.FIRERECINFO021 = dt.Rows[i]["FIRERECINFO021"].ToString();
m.FIRERECINFO030 = dt.Rows[i]["FIRERECINFO030"].ToString();
m.FIRERECINFO031 = dt.Rows[i]["FIRERECINFO031"].ToString();
m.FIRERECINFO032 = dt.Rows[i]["FIRERECINFO032"].ToString();
m.FIRERECINFO040 = dt.Rows[i]["FIRERECINFO040"].ToString();
m.FIRERECINFO041 = dt.Rows[i]["FIRERECINFO041"].ToString();
m.FIRERECINFO050 = dt.Rows[i]["FIRERECINFO050"].ToString();
m.FIRERECINFO051 = dt.Rows[i]["FIRERECINFO051"].ToString();
m.FIRERECINFO060 = dt.Rows[i]["FIRERECINFO060"].ToString();
m.FIRERECINFO061 = dt.Rows[i]["FIRERECINFO061"].ToString();
m.FIRERECINFO070 = dt.Rows[i]["FIRERECINFO070"].ToString();
m.FIRERECINFO071 = dt.Rows[i]["FIRERECINFO071"].ToString();
m.FIRERECINFO072 = dt.Rows[i]["FIRERECINFO072"].ToString();
m.FIRERECINFO080 = dt.Rows[i]["FIRERECINFO080"].ToString();
m.FIRERECINFO081 = dt.Rows[i]["FIRERECINFO081"].ToString();
m.FIRERECINFO082 = dt.Rows[i]["FIRERECINFO082"].ToString();
m.FIRERECINFO090 = dt.Rows[i]["FIRERECINFO090"].ToString();
m.FIRERECINFO100 = dt.Rows[i]["FIRERECINFO100"].ToString();
m.FIRERECINFO110 = dt.Rows[i]["FIRERECINFO110"].ToString();
m.FIRERECINFO111 = dt.Rows[i]["FIRERECINFO111"].ToString();
m.FIRERECINFO120 = dt.Rows[i]["FIRERECINFO120"].ToString();
m.FIRERECINFO130 = dt.Rows[i]["FIRERECINFO130"].ToString();
m.FIRERECINFO140 = dt.Rows[i]["FIRERECINFO140"].ToString();
m.FIRERECINFO150 = dt.Rows[i]["FIRERECINFO150"].ToString();
m.FIRERECINFO160 = dt.Rows[i]["FIRERECINFO160"].ToString();
m.FIRELOSEAREA = dt.Rows[i]["FIRELOSEAREA"].ToString();
//m.JD = dt.Rows[i]["JD"].ToString();
//m.WD = dt.Rows[i]["WD"].ToString();
}
dt.Clear();
dt.Dispose();
dtORG.Clear();
dtORG.Dispose();
return(m);
}
/// <summary>
/// 增、删、改
/// </summary>
/// <param name="m">参见模型FIRERECORD_FIREINFO_Model</param>
/// <returns>参见模型Message</returns>
public static Message Manager(FIRERECORD_FIREINFO_Model m)
{
if (m.opMethod == "Add")
{
Message msgMENU = BaseDT.FIRERECORD_FIREINFO.Add(m);
if (msgMENU.Success == false)
{
return(new Message(msgMENU.Success, msgMENU.Msg, ""));
}
return(new Message(msgMENU.Success, msgMENU.Msg, m.returnUrl));
}
if (m.opMethod == "Mdy")
{
Message msgMENU = BaseDT.FIRERECORD_FIREINFO.Mdy(m);
if (msgMENU.Success == false)
{
return(new Message(msgMENU.Success, msgMENU.Msg, ""));
}
return(new Message(msgMENU.Success, msgMENU.Msg, m.returnUrl));
}
if (m.opMethod == "Del")
{
Message msgMENU = BaseDT.FIRERECORD_FIREINFO.Del(m);
if (msgMENU.Success == false)
{
return(new Message(msgMENU.Success, msgMENU.Msg, ""));
}
return(new Message(msgMENU.Success, msgMENU.Msg, m.returnUrl));
}
return(new Message(false, "无效操作!", m.returnUrl));
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="sw">参见模型FIRERECORD_FIREINFO_Model</param>
/// <returns>参见模型FIRERECORD_FIREINFO_Model</returns>
public static IEnumerable <FIRERECORD_FIREINFO_Model> getListModel(FIRERECORD_FIREINFO_SW sw)
{
var result = new List <FIRERECORD_FIREINFO_Model>();
DataTable dt = BaseDT.FIRERECORD_FIREINFO.getDT(sw);
for (int i = 0; i < dt.Rows.Count; i++)
{
FIRERECORD_FIREINFO_Model m = new FIRERECORD_FIREINFO_Model();
m.FRFIID = dt.Rows[i]["FRFIID"].ToString();
m.JCFID = dt.Rows[i]["JCFID"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
m.FIRECODE = dt.Rows[i]["FIRECODE"].ToString();
m.FIREADDRESSCOUNTY = dt.Rows[i]["FIREADDRESSCOUNTY"].ToString();
m.FIREADDRESSTOWNS = dt.Rows[i]["FIREADDRESSTOWNS"].ToString();
m.FIREADDRESSVILLAGES = dt.Rows[i]["FIREADDRESSVILLAGES"].ToString();
m.FIRETIME = ClsSwitch.SwitTM(dt.Rows[i]["FIRETIME"].ToString());
m.FIREENDTIME = ClsSwitch.SwitTM(dt.Rows[i]["FIREENDTIME"].ToString());
m.FIREADDRESS = dt.Rows[i]["FIREADDRESS"].ToString();
m.FIRERECINFO000 = dt.Rows[i]["FIRERECINFO000"].ToString();
m.FIRERECINFO001 = dt.Rows[i]["FIRERECINFO001"].ToString();
m.FIRERECINFO020 = dt.Rows[i]["FIRERECINFO020"].ToString();
m.FIRERECINFO021 = dt.Rows[i]["FIRERECINFO021"].ToString();
m.FIRERECINFO030 = dt.Rows[i]["FIRERECINFO030"].ToString();
m.FIRERECINFO031 = dt.Rows[i]["FIRERECINFO031"].ToString();
m.FIRERECINFO032 = dt.Rows[i]["FIRERECINFO032"].ToString();
m.FIRERECINFO040 = dt.Rows[i]["FIRERECINFO040"].ToString();
m.FIRERECINFO041 = dt.Rows[i]["FIRERECINFO041"].ToString();
m.FIRERECINFO050 = dt.Rows[i]["FIRERECINFO050"].ToString();
m.FIRERECINFO051 = dt.Rows[i]["FIRERECINFO051"].ToString();
m.FIRERECINFO060 = dt.Rows[i]["FIRERECINFO060"].ToString();
m.FIRERECINFO061 = dt.Rows[i]["FIRERECINFO061"].ToString();
m.FIRERECINFO070 = dt.Rows[i]["FIRERECINFO070"].ToString();
m.FIRERECINFO071 = dt.Rows[i]["FIRERECINFO071"].ToString();
m.FIRERECINFO072 = dt.Rows[i]["FIRERECINFO072"].ToString();
m.FIRERECINFO080 = dt.Rows[i]["FIRERECINFO080"].ToString();
m.FIRERECINFO081 = dt.Rows[i]["FIRERECINFO081"].ToString();
m.FIRERECINFO082 = dt.Rows[i]["FIRERECINFO082"].ToString();
m.FIRERECINFO090 = dt.Rows[i]["FIRERECINFO090"].ToString();
m.FIRERECINFO100 = dt.Rows[i]["FIRERECINFO100"].ToString();
m.FIRERECINFO110 = dt.Rows[i]["FIRERECINFO110"].ToString();
m.FIRERECINFO111 = dt.Rows[i]["FIRERECINFO111"].ToString();
m.FIRERECINFO120 = dt.Rows[i]["FIRERECINFO120"].ToString();
m.FIRERECINFO130 = dt.Rows[i]["FIRERECINFO130"].ToString();
m.FIRERECINFO140 = dt.Rows[i]["FIRERECINFO140"].ToString();
m.FIRERECINFO150 = dt.Rows[i]["FIRERECINFO150"].ToString();
m.FIRERECINFO160 = dt.Rows[i]["FIRERECINFO160"].ToString();
m.FIRELOSEAREA = dt.Rows[i]["FIRELOSEAREA"].ToString();
//m.JD = dt.Rows[i]["JD"].ToString();
//m.WD = dt.Rows[i]["WD"].ToString();
result.Add(m);
}
dt.Clear();
dt.Dispose();
return(result);
}
/// <summary>
/// 根据JCFID获取FRFIID的值
/// </summary>
/// <param name="sw">FIRERECORD_FIREINFO_SW</param>
/// <returns></returns>
public static string getFrfiid(FIRERECORD_FIREINFO_SW sw)
{
DataTable dt = BaseDT.FIRERECORD_FIREINFO.getFRFIID(sw);
FIRERECORD_FIREINFO_Model m = new FIRERECORD_FIREINFO_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
m.FRFIID = dt.Rows[i]["FRFIID"].ToString();
}
dt.Clear();
dt.Dispose();
return(m.FRFIID);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Del(FIRERECORD_FIREINFO_Model m)
{
List <string> sqllist = new List <string>();
//删除FIRERECORD_FIREINFO表中的数据
StringBuilder sb1 = new StringBuilder();
sb1.AppendFormat("delete from FIRERECORD_FIREINFO ");
sb1.AppendFormat(" where JCFID = '{0}'", ClsSql.EncodeSql(m.JCFID));
sqllist.Add(sb1.ToString());
//删除JC_FIRE表中的数据
StringBuilder sb2 = new StringBuilder();
sb2.AppendFormat("delete from JC_FIRE ");
sb2.AppendFormat(" where JCFID ='{0}'", ClsSql.EncodeSql(m.JCFID));
sqllist.Add(sb2.ToString());
//删除JC_FIRE_PROP表中的数据
StringBuilder sb3 = new StringBuilder();
sb3.AppendFormat("delete from JC_FIRE_PROP ");
sb3.AppendFormat(" where JCFID = '{0}'", ClsSql.EncodeSql(m.JCFID));
sqllist.Add(sb3.ToString());
//删除空间库HUOQINGDANGAN的数据
StringBuilder sc = new StringBuilder();
sc.AppendFormat("delete from HUOQINGDANGAN ");
sc.AppendFormat(" where OBJECTID = '{0}", ClsSql.EncodeSql(m.JCFID));
var y = DataBaseClass.ExecuteSqlTran(sqllist);
if (y > 0)
{
SDEDataBaseClass.ExeSql(sc.ToString());
return(new Message(true, "删除成功!", m.returnUrl));
}
else
{
return(new Message(false, "删除失败,事物回滚机制!", ""));
}
}
/// <summary>
/// 分页获取数据列表
/// </summary>
/// <param name="sw"></param>
/// <param name="total"></param>
/// <returns></returns>
public static IEnumerable <FIRERECORD_FIREINFO_Model> getListModel(FIRERECORD_FIREINFO_SW sw, out int total)
{
var result = new List <FIRERECORD_FIREINFO_Model>();
DataTable dt = BaseDT.FIRERECORD_FIREINFO.getDT(sw, out total);
DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
}); //获取单位
for (int i = 0; i < dt.Rows.Count; i++)
{
FIRERECORD_FIREINFO_Model m = new FIRERECORD_FIREINFO_Model();
m.FRFIID = dt.Rows[i]["FRFIID"].ToString();
m.JCFID = dt.Rows[i]["JCFID"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
m.FIREADDRESSCOUNTY = dt.Rows[i]["FIREADDRESSCOUNTY"].ToString();
m.FIREADDRESSTOWNS = dt.Rows[i]["FIREADDRESSTOWNS"].ToString();
m.ORGNAME = BaseDT.T_SYS_ORG.getName(dtORG, m.FIREADDRESSTOWNS);
m.FIREADDRESSVILLAGES = dt.Rows[i]["FIREADDRESSVILLAGES"].ToString();
m.FIRETIME = ClsSwitch.SwitTM(dt.Rows[i]["FIRETIME"].ToString());
m.FIREENDTIME = ClsSwitch.SwitTM(dt.Rows[i]["FIREENDTIME"].ToString());
m.FIRERECINFO000 = dt.Rows[i]["FIRERECINFO000"].ToString();
m.FIRERECINFO001 = dt.Rows[i]["FIRERECINFO001"].ToString();
m.FIRERECINFO020 = dt.Rows[i]["FIRERECINFO020"].ToString();
m.FIRERECINFO021 = dt.Rows[i]["FIRERECINFO021"].ToString();
m.FIRERECINFO030 = dt.Rows[i]["FIRERECINFO030"].ToString();
m.FIRERECINFO031 = dt.Rows[i]["FIRERECINFO031"].ToString();
m.FIRERECINFO032 = dt.Rows[i]["FIRERECINFO032"].ToString();
m.FIRERECINFO040 = dt.Rows[i]["FIRERECINFO040"].ToString();
m.FIRERECINFO041 = dt.Rows[i]["FIRERECINFO041"].ToString();
m.FIRERECINFO050 = dt.Rows[i]["FIRERECINFO050"].ToString();
m.FIRERECINFO051 = dt.Rows[i]["FIRERECINFO051"].ToString();
m.FIRERECINFO060 = dt.Rows[i]["FIRERECINFO060"].ToString();
m.FIRERECINFO061 = dt.Rows[i]["FIRERECINFO061"].ToString();
m.FIRERECINFO070 = dt.Rows[i]["FIRERECINFO070"].ToString();
m.FIRERECINFO071 = dt.Rows[i]["FIRERECINFO071"].ToString();
m.FIRERECINFO072 = dt.Rows[i]["FIRERECINFO072"].ToString();
m.FIRERECINFO080 = dt.Rows[i]["FIRERECINFO080"].ToString();
m.FIRERECINFO081 = dt.Rows[i]["FIRERECINFO081"].ToString();
m.FIRERECINFO082 = dt.Rows[i]["FIRERECINFO082"].ToString();
m.FIRERECINFO090 = dt.Rows[i]["FIRERECINFO090"].ToString();
m.FIRERECINFO100 = dt.Rows[i]["FIRERECINFO100"].ToString();
m.FIRERECINFO110 = dt.Rows[i]["FIRERECINFO110"].ToString();
m.FIRERECINFO120 = dt.Rows[i]["FIRERECINFO120"].ToString();
m.FIRERECINFO130 = dt.Rows[i]["FIRERECINFO130"].ToString();
m.FIRERECINFO140 = dt.Rows[i]["FIRERECINFO140"].ToString();
m.FIRERECINFO150 = dt.Rows[i]["FIRERECINFO150"].ToString();
m.FIRERECINFO160 = dt.Rows[i]["FIRERECINFO160"].ToString();
if (BaseDT.FIRELOST_FIREINFO.isAssess(new FIRELOST_FIREINFO_SW {
JCFID = m.JCFID
}))
{
FIRELOST_FIREINFO_Model m2 = FIRELOST_FIREINFOCls.getModel(new FIRELOST_FIREINFO_SW {
JCFID = m.JCFID
});
if (m2 != null)
{
m.LOSSCOUNT = !string.IsNullOrEmpty(m2.LOSSCOUNT) ? float.Parse(m2.LOSSCOUNT) : 0;
m.FORESTRESOURCELOSSRATIO = !string.IsNullOrEmpty(m2.FORESTRESOURCELOSSRATIO) ? float.Parse(m2.FORESTRESOURCELOSSRATIO) : 0;
m.AVGLOSSPERCATITAVALUE = !string.IsNullOrEmpty(m2.AVGLOSSPERCATITAVALUE) ? float.Parse(m2.AVGLOSSPERCATITAVALUE) : 0;
m.WOODLANDLOSSAVGVALUE = !string.IsNullOrEmpty(m2.WOODLANDLOSSAVGVALUE) ? float.Parse(m2.WOODLANDLOSSAVGVALUE) : 0;
m.FIRESUPPEFFECTTHAN = !string.IsNullOrEmpty(m2.FIRESUPPEFFECTTHAN) ? float.Parse(m2.FIRESUPPEFFECTTHAN) : 0;
}
}
result.Add(m);
}
dt.Clear();
dt.Dispose();
dtORG.Clear();
dtORG.Dispose();
return(result);
}
/// <summary>
/// 添加火情档案管理
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Add(FIRERECORD_FIREINFO_Model m)
{
#region 添加数据至JC_FIRE表中
StringBuilder sb = new StringBuilder();
sb.AppendFormat("INSERT INTO JC_FIRE(BYORGNO,FIREFROM,FIRETIME,FIREENDTIME,JD,WD,ZQWZ,ISOUTFIRE) output inserted.JCFID ");
sb.AppendFormat("VALUES(");
sb.AppendFormat(" {0}", ClsSql.saveNullField(m.FIREADDRESSTOWNS));
sb.AppendFormat(",'50'");
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRETIME));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIREENDTIME));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.JD));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.WD));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIREADDRESS));
sb.AppendFormat(",'1'");
sb.AppendFormat(")");
string str = DataBaseClass.ReturnSqlField(sb.ToString());
#endregion
if (str != "")
{
List <string> sqllist = new List <string>();
#region 添加数据至FIRERECORD_FIREINFO表中
StringBuilder sb1 = new StringBuilder();
sb1.AppendFormat("INSERT INTO FIRERECORD_FIREINFO(JCFID, BYORGNO,FIRECODE, FIREADDRESSCOUNTY, FIREADDRESSTOWNS, FIREADDRESSVILLAGES, FIREADDRESS,FIRETIME,FIREENDTIME,");
sb1.AppendFormat("FIRERECINFO000,FIRERECINFO001, FIRERECINFO020,FIRERECINFO021,FIRERECINFO030,FIRERECINFO031,FIRERECINFO032,FIRERECINFO040,FIRERECINFO041,");
sb1.AppendFormat("FIRERECINFO050,FIRERECINFO051,FIRERECINFO060,FIRERECINFO061,FIRERECINFO070,FIRERECINFO071,FIRERECINFO072,FIRERECINFO080,FIRERECINFO081,FIRERECINFO082,");
sb1.AppendFormat("FIRERECINFO090,FIRERECINFO100,FIRERECINFO110,FIRERECINFO111,FIRERECINFO120,FIRERECINFO130,FIRERECINFO140,FIRERECINFO150,FIRERECINFO160,FIRELOSEAREA)");
sb1.AppendFormat("VALUES(");
sb1.AppendFormat("'{0}'", ClsSql.EncodeSql(str));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.BYORGNO));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRECODE));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIREADDRESSCOUNTY));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIREADDRESSTOWNS));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIREADDRESSVILLAGES));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIREADDRESS));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRETIME));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIREENDTIME));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO000));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO001));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO020));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO021));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO030));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO031));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO032));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO040));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO041));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO050));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO051));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO060));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO061));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO070));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO071));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO072));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO080));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO081));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO082));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO090));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO100));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO110));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO111));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO120));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO130));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO140));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO150));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO160));
sb1.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRELOSEAREA));
sb1.AppendFormat(")");
sqllist.Add(sb1.ToString());
#endregion ;
#region 添加火灾等级到JC_FIRE_PROP中
StringBuilder sb2 = new StringBuilder();
sb2.AppendFormat("INSERT INTO JC_FIRE_PROP(JCFID,FIRELEVEL) ");
sb2.AppendFormat("VALUES(");
sb2.AppendFormat("'{0}'", ClsSql.EncodeSql(str));
sb2.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO001));
sb2.AppendFormat(")");
sqllist.Add(sb2.ToString());
#endregion
#region 添加数据至空间库HUOQINGDANGAN
StringBuilder sb3 = new StringBuilder();
sb3.AppendFormat("INSERT INTO HUOQINGDANGAN(OBJECTID,NAME,JD,WD,ADDRESS,YEAR,Shape) ");
sb3.AppendFormat("VALUES(");
sb3.AppendFormat("'{0}'", ClsSql.EncodeSql(str));
sb3.AppendFormat(",{0}", ClsSql.saveNullField(m.FIREADDRESS));
sb3.AppendFormat(",{0}", ClsSql.saveNullField(m.JD));
sb3.AppendFormat(",{0}", ClsSql.saveNullField(m.WD));
sb3.AppendFormat(",{0}", ClsSql.saveNullField(m.FIREADDRESS));
string[] sTIME = m.FIRETIME.Split('-');
sb3.AppendFormat(",{0}", ClsSql.saveNullField(sTIME[0]));
sb3.AppendFormat(",{0}", m.Shape);
sb3.AppendFormat(")");
#endregion
var y = DataBaseClass.ExecuteSqlTran(sqllist);
if (y > 0)
{
SDEDataBaseClass.ExeSql(sb3.ToString());
return(new Message(true, "添加成功!", m.returnUrl));
}
else
{
return(new Message(false, "添加失败,事物回滚机制!", ""));
}
}
else
{
return(new Message(false, "添加失败,请检查各输入框是否正确!", m.returnUrl));
}
}
/// <summary>
/// 修改火情档案
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Mdy(FIRERECORD_FIREINFO_Model m)
{
List <string> sqllist = new List <string>();
#region 更新FIRERECORD_FIREINFO表数据
StringBuilder sb = new StringBuilder();
if (isExists(new FIRERECORD_FIREINFO_SW {
JCFID = m.JCFID
}))
{
sb.AppendFormat(" Update FIRERECORD_FIREINFO SET ");
sb.AppendFormat(" BYORGNO='{0}'", ClsSql.EncodeSql(m.BYORGNO));
sb.AppendFormat(",FIRECODE={0}", ClsSql.saveNullField(m.FIRECODE));
sb.AppendFormat(",FIREADDRESSCOUNTY={0}", ClsSql.saveNullField(m.FIREADDRESSCOUNTY));
sb.AppendFormat(",FIREADDRESSTOWNS={0}", ClsSql.saveNullField(m.FIREADDRESSTOWNS));
sb.AppendFormat(",FIREADDRESSVILLAGES={0}", ClsSql.saveNullField(m.FIREADDRESSVILLAGES));
sb.AppendFormat(",FIREADDRESS={0}", ClsSql.saveNullField(m.FIREADDRESS));
sb.AppendFormat(",FIRETIME={0}", ClsSql.saveNullField(m.FIRETIME));
sb.AppendFormat(",FIREENDTIME={0}", ClsSql.saveNullField(m.FIREENDTIME));
sb.AppendFormat(",FIRERECINFO000={0}", ClsSql.saveNullField(m.FIRERECINFO000));
sb.AppendFormat(",FIRERECINFO001={0}", ClsSql.saveNullField(m.FIRERECINFO001));
sb.AppendFormat(",FIRERECINFO020={0}", ClsSql.saveNullField(m.FIRERECINFO020));
sb.AppendFormat(",FIRERECINFO021={0}", ClsSql.saveNullField(m.FIRERECINFO021));
sb.AppendFormat(",FIRERECINFO030={0}", ClsSql.saveNullField(m.FIRERECINFO030));
sb.AppendFormat(",FIRERECINFO031={0}", ClsSql.saveNullField(m.FIRERECINFO031));
sb.AppendFormat(",FIRERECINFO032={0}", ClsSql.saveNullField(m.FIRERECINFO032));
sb.AppendFormat(",FIRERECINFO040={0}", ClsSql.saveNullField(m.FIRERECINFO040));
sb.AppendFormat(",FIRERECINFO041={0}", ClsSql.saveNullField(m.FIRERECINFO041));
sb.AppendFormat(",FIRERECINFO050={0}", ClsSql.saveNullField(m.FIRERECINFO050));
sb.AppendFormat(",FIRERECINFO051={0}", ClsSql.saveNullField(m.FIRERECINFO051));
sb.AppendFormat(",FIRERECINFO060={0}", ClsSql.saveNullField(m.FIRERECINFO060));
sb.AppendFormat(",FIRERECINFO061={0}", ClsSql.saveNullField(m.FIRERECINFO061));
sb.AppendFormat(",FIRERECINFO070={0}", ClsSql.saveNullField(m.FIRERECINFO070));
sb.AppendFormat(",FIRERECINFO071={0}", ClsSql.saveNullField(m.FIRERECINFO071));
sb.AppendFormat(",FIRERECINFO072={0}", ClsSql.saveNullField(m.FIRERECINFO072));
sb.AppendFormat(",FIRERECINFO080={0}", ClsSql.saveNullField(m.FIRERECINFO080));
sb.AppendFormat(",FIRERECINFO081={0}", ClsSql.saveNullField(m.FIRERECINFO081));
sb.AppendFormat(",FIRERECINFO082={0}", ClsSql.saveNullField(m.FIRERECINFO082));
sb.AppendFormat(",FIRERECINFO090={0}", ClsSql.saveNullField(m.FIRERECINFO090));
sb.AppendFormat(",FIRERECINFO100={0}", ClsSql.saveNullField(m.FIRERECINFO100));
sb.AppendFormat(",FIRERECINFO110={0}", ClsSql.saveNullField(m.FIRERECINFO110));
sb.AppendFormat(",FIRERECINFO111={0}", ClsSql.saveNullField(m.FIRERECINFO111));
sb.AppendFormat(",FIRERECINFO120={0}", ClsSql.saveNullField(m.FIRERECINFO120));
sb.AppendFormat(",FIRERECINFO130={0}", ClsSql.saveNullField(m.FIRERECINFO130));
sb.AppendFormat(",FIRERECINFO140={0}", ClsSql.saveNullField(m.FIRERECINFO140));
sb.AppendFormat(",FIRERECINFO150={0}", ClsSql.saveNullField(m.FIRERECINFO150));
sb.AppendFormat(",FIRERECINFO160={0}", ClsSql.saveNullField(m.FIRERECINFO160));
sb.AppendFormat(",FIRELOSEAREA={0}", ClsSql.saveNullField(m.FIRELOSEAREA));
sb.AppendFormat(" where JCFID= '{0}'", ClsSql.EncodeSql(m.JCFID));
sqllist.Add(sb.ToString());
}
else
{
sb.AppendFormat("INSERT INTO FIRERECORD_FIREINFO(JCFID, BYORGNO,FIRECODE, FIREADDRESSCOUNTY, FIREADDRESSTOWNS, FIREADDRESSVILLAGES, FIREADDRESS,FIRETIME,FIREENDTIME,");
sb.AppendFormat("FIRERECINFO000,FIRERECINFO001, FIRERECINFO020,FIRERECINFO021,FIRERECINFO030,FIRERECINFO031,FIRERECINFO032,FIRERECINFO040,FIRERECINFO041,");
sb.AppendFormat("FIRERECINFO050,FIRERECINFO051,FIRERECINFO060,FIRERECINFO061,FIRERECINFO070,FIRERECINFO071,FIRERECINFO072,FIRERECINFO080,FIRERECINFO081,FIRERECINFO082,");
sb.AppendFormat("FIRERECINFO090,FIRERECINFO100,FIRERECINFO110,FIRERECINFO111,FIRERECINFO120,FIRERECINFO130,FIRERECINFO140,FIRERECINFO150,FIRERECINFO160,FIRELOSEAREA)");
sb.AppendFormat("VALUES(");
sb.AppendFormat("'{0}'", ClsSql.EncodeSql(m.JCFID));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.BYORGNO));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRECODE));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIREADDRESSCOUNTY));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIREADDRESSTOWNS));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIREADDRESSVILLAGES));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIREADDRESS));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRETIME));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIREENDTIME));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO000));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO001));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO020));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO021));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO030));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO031));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO032));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO040));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO041));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO050));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO051));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO060));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO061));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO070));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO071));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO072));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO080));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO081));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO082));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO090));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO100));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO110));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO111));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO120));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO130));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO140));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO150));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO160));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRELOSEAREA));
sb.AppendFormat(")");
sqllist.Add(sb.ToString());
}
#endregion
#region 修改JC_FIRE表中的数据
StringBuilder sc = new StringBuilder();
sc.AppendFormat(" Update JC_FIRE SET ");
sc.AppendFormat(" BYORGNO='{0}'", ClsSql.EncodeSql(m.FIREADDRESSTOWNS));
sc.AppendFormat(",FIRETIME={0}", ClsSql.saveNullField(m.FIRETIME));
sc.AppendFormat(",FIREENDTIME={0}", ClsSql.saveNullField(m.FIREENDTIME));
sc.AppendFormat(",ZQWZ={0}", ClsSql.saveNullField(m.FIREADDRESS));
sc.AppendFormat(",JD={0}", ClsSql.saveNullField(m.JD));
sc.AppendFormat(",WD={0}", ClsSql.saveNullField(m.WD));
sc.AppendFormat(" where JCFID= '{0}'", ClsSql.EncodeSql(m.JCFID));
sqllist.Add(sc.ToString());
#endregion
#region 修改火灾等级到JC_FIRE_PROP中
StringBuilder sd = new StringBuilder();
if (isExistsfirelevel(new JC_FIRE_PROP_SW {
JCFID = m.JCFID
}))
{
sd.AppendFormat(" Update JC_FIRE_PROP SET ");
sd.AppendFormat(" FIRELEVEL={0}", ClsSql.saveNullField(m.FIRERECINFO001));
sd.AppendFormat(" where JCFID= '{0}'", ClsSql.EncodeSql(m.JCFID));
sqllist.Add(sd.ToString());
}
else
{
sd.AppendFormat(" INSERT INTO JC_FIRE_PROP(JCFID,FIRELEVEL) ");
sd.AppendFormat(" VALUES(");
sd.AppendFormat("'{0}'", ClsSql.EncodeSql(m.JCFID));
sd.AppendFormat(",{0}", ClsSql.saveNullField(m.FIRERECINFO001));
sd.AppendFormat(")");
sqllist.Add(sd.ToString());
}
#endregion
#region 修改空间库HUOQINGDANGAN的数据
StringBuilder se = new StringBuilder();
se.AppendFormat("delete from HUOQINGDANGAN");
se.AppendFormat(" where OBJECTID= '{0}'", ClsSql.EncodeSql(m.JCFID));
se.AppendFormat(";");
se.AppendFormat("INSERT INTO HUOQINGDANGAN(OBJECTID,NAME,JD,WD,ADDRESS,YEAR,Shape) ");
se.AppendFormat("VALUES(");
se.AppendFormat(" {0}", ClsSql.saveNullField(m.JCFID));
se.AppendFormat(",{0}", ClsSql.saveNullField(m.FIREADDRESS));
se.AppendFormat(",{0}", ClsSql.saveNullField(m.JD));
se.AppendFormat(",{0}", ClsSql.saveNullField(m.WD));
se.AppendFormat(",{0}", ClsSql.saveNullField(m.FIREADDRESS));
string[] sTIME = m.FIRETIME.Split('-');
se.AppendFormat(",{0}", ClsSql.saveNullField(sTIME[0]));
se.AppendFormat(",{0}", m.Shape);
se.AppendFormat(")");
#endregion
var y = DataBaseClass.ExecuteSqlTran(sqllist);
if (y > 0)
{
SDEDataBaseClass.ExeSql(se.ToString());
return(new Message(true, "修改成功!", m.returnUrl));
}
else
{
return(new Message(false, "修改失败,请检查各输入框是否正确!", m.returnUrl));
}
}
