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