/// <summary> /// 修改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Mdy(PEST_MONITORINGSTATION_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("UPDATE PEST_MONITORINGSTATION"); sb.AppendFormat(" SET "); sb.AppendFormat("NUMBER={0}", ClsSql.saveNullField(m.NUMBER)); sb.AppendFormat(",NAME={0}", ClsSql.saveNullField(m.NAME)); sb.AppendFormat(",ADDRESS={0}", ClsSql.saveNullField(m.ADDRESS)); sb.AppendFormat(",MODEL={0}", ClsSql.saveNullField(m.MODEL)); sb.AppendFormat(",BYORGNO={0}", ClsSql.saveNullField(m.BYORGNO)); sb.AppendFormat(",TRANSFERMODETYPE={0}", ClsSql.saveNullField(m.TRANSFERMODETYPE)); sb.AppendFormat(",MONICONTENT={0}", ClsSql.saveNullField(m.MONICONTENT)); sb.AppendFormat(",BUILDDATE={0}", ClsSql.saveNullField(m.BUILDDATE)); sb.AppendFormat(",USESTATE={0}", ClsSql.saveNullField(m.USESTATE)); sb.AppendFormat(",MANAGERSTATE={0}", ClsSql.saveNullField(m.MANAGERSTATE)); sb.AppendFormat(",MARK={0}", ClsSql.saveNullField(m.MARK)); sb.AppendFormat(",JD={0}", ClsSql.saveNullField(m.JD)); sb.AppendFormat(",WD={0}", ClsSql.saveNullField(m.WD)); sb.AppendFormat(",WORTH={0}", ClsSql.saveNullField(m.WORTH)); sb.AppendFormat(" WHERE PEST_MONITORINGSTATIONID= '{0}'", ClsSql.EncodeSql(m.PEST_MONITORINGSTATIONID)); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "修改成功!", m.PEST_MONITORINGSTATIONID)); } else { return(new Message(false, "修改失败!", "")); } }
/// <summary> /// 判断是否相同坐标 /// </summary> /// <param name="m"></param> /// <returns></returns> public static bool IsExistsPoint(PEST_MONITORINGSTATION_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("select 1 from PEST_MONITORINGSTATION where 1=1"); sb.AppendFormat(" and JD='{0}'", ClsSql.EncodeSql(m.JD)); sb.AppendFormat(" and WD='{0}'", ClsSql.EncodeSql(m.WD)); return(DataBaseClass.JudgeRecordExists(sb.ToString())); }
/// <summary> /// 添加 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Add(PEST_MONITORINGSTATION_Model m) { if (IsExistsPoint(new PEST_MONITORINGSTATION_Model { JD = m.JD, WD = m.WD }) == false) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("INSERT INTO PEST_MONITORINGSTATION(NUMBER, NAME, ADDRESS, MODEL, BYORGNO, TRANSFERMODETYPE, MONICONTENT, BUILDDATE, USESTATE, MANAGERSTATE, MARK, JD, WD, WORTH)"); sb.AppendFormat(" OUTPUT INSERTED.PEST_MONITORINGSTATIONID"); sb.AppendFormat(" VALUES("); sb.AppendFormat("{0}", ClsSql.saveNullField(m.NUMBER)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.NAME)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.ADDRESS)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.MODEL)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.BYORGNO)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.TRANSFERMODETYPE)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.MONICONTENT)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.BUILDDATE)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.USESTATE)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.MANAGERSTATE)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.MARK)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.JD)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.WD)); sb.AppendFormat(",{0}", ClsSql.saveNullField(m.WORTH)); sb.AppendFormat(")"); try { string sId = DataBaseClass.ReturnSqlField(sb.ToString()); if (sId != "") { return(new Message(true, "添加成功!", sId)); } else { return(new Message(false, "添加失败!", "")); } } catch { return(new Message(false, "添加失败!", "")); } } else { return(new Message(false, "添加失败,已有相同的位置的监测点!", "")); } }
/// <summary> /// 删除 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Del(PEST_MONITORINGSTATION_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("delete PEST_MONITORINGSTATION"); sb.AppendFormat(" where PEST_MONITORINGSTATIONID= '{0}'", ClsSql.EncodeSql(m.PEST_MONITORINGSTATIONID)); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "删除成功!", "")); } else { return(new Message(false, "删除失败!", "")); } }
/// <summary> /// 修改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message MdyJWD(PEST_MONITORINGSTATION_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("UPDATE PEST_MONITORINGSTATION"); sb.AppendFormat(" set "); sb.AppendFormat("JD={0}", ClsSql.saveNullField(m.JD)); sb.AppendFormat(",WD={0}", ClsSql.saveNullField(m.WD)); sb.AppendFormat(" WHERE DC_UTILITY_MONITORINGSTATION_ID= '{0}'", ClsSql.EncodeSql(m.PEST_MONITORINGSTATIONID)); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "修改成功!", m.PEST_MONITORINGSTATIONID)); } else { return(new Message(false, "修改失败!", "")); } }
/// <summary> /// 增、删、改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Manager(PEST_MONITORINGSTATION_Model m) { if (m.opMethod == "Add") { Message msg = BaseDT.PEST_MONITORINGSTATION.Add(m); return(new Message(msg.Success, msg.Msg, msg.Url)); } if (m.opMethod == "Mdy") { Message msg = BaseDT.PEST_MONITORINGSTATION.Mdy(m); return(new Message(msg.Success, msg.Msg, msg.Url)); } if (m.opMethod == "MdyJWD") { Message msg = BaseDT.PEST_MONITORINGSTATION.MdyJWD(m); return(new Message(msg.Success, msg.Msg, msg.Url)); } if (m.opMethod == "Del") { Message msg = BaseDT.PEST_MONITORINGSTATION.Del(m); return(new Message(msg.Success, msg.Msg, msg.Url)); } return(new Message(false, "无效操作", "")); }
/// <summary> /// 获取单条数据 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static PEST_MONITORINGSTATION_Model getModel(PEST_MONITORINGSTATION_SW sw) { DataTable dt = BaseDT.PEST_MONITORINGSTATION.getDT(sw);//列表 DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW { SYSFLAG = ConfigCls.getSystemFlag() }); //获取单位 DataTable dt119 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW { DICTTYPEID = "119" }); //无线电传输方式 DataTable dt120 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW { DICTTYPEID = "120" }); //使用现状 DataTable dt121 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW { DICTTYPEID = "121" }); //维护类型 PEST_MONITORINGSTATION_Model m = new PEST_MONITORINGSTATION_Model(); if (dt.Rows.Count > 0) { int i = 0; m.PEST_MONITORINGSTATIONID = dt.Rows[i]["PEST_MONITORINGSTATIONID"].ToString(); m.NUMBER = dt.Rows[i]["NUMBER"].ToString(); m.NAME = dt.Rows[i]["NAME"].ToString(); m.ADDRESS = dt.Rows[i]["ADDRESS"].ToString(); m.MODEL = dt.Rows[i]["MODEL"].ToString(); m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString(); if (PublicCls.OrgIsShi(m.BYORGNO) || PublicCls.OrgIsXian(m.BYORGNO)) { m.ORGName = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO); m.ORGXSName = "--"; } else { m.ORGName = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO.Substring(0, 6) + "000"); m.ORGXSName = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO); } m.TRANSFERMODETYPE = dt.Rows[i]["TRANSFERMODETYPE"].ToString(); m.TRANSFERMODETYPEName = BaseDT.T_SYS_DICT.getName(dt119, m.TRANSFERMODETYPE); m.MONICONTENT = dt.Rows[i]["MONICONTENT"].ToString(); m.BUILDDATE = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["BUILDDATE"].ToString()); m.USESTATE = dt.Rows[i]["USESTATE"].ToString(); m.USESTATEName = BaseDT.T_SYS_DICT.getName(dt120, m.USESTATE); m.MANAGERSTATE = dt.Rows[i]["MANAGERSTATE"].ToString(); m.MANAGERSTATEName = BaseDT.T_SYS_DICT.getName(dt121, m.MANAGERSTATE); m.MARK = dt.Rows[i]["MARK"].ToString(); m.JD = dt.Rows[i]["JD"].ToString(); m.WD = dt.Rows[i]["WD"].ToString(); m.WORTH = dt.Rows[i]["WORTH"].ToString(); } dt.Clear(); dt.Dispose(); dtORG.Clear(); dtORG.Dispose(); dt119.Clear(); dt119.Dispose(); dt120.Clear(); dt120.Dispose(); dt121.Clear(); dt121.Dispose(); return(m); }