public void Update(EMOpenGPSInfo entity)
 {
     StringBuilder sql = new StringBuilder();
     sql.Append(string.Format("update movo_open_gpsinfo set Results='{0}'", entity.Results));
     if (entity.LastSetTime.HasValue)
         sql.Append(string.Format(",LastSetTime='{0}'", entity.LastSetTime.Value));
     sql.Append(string.Format(" where id={0};", entity.ID));
     MySqlHelper.ExecuteNonQuery(ConnectionString, sql.ToString());
 }
Exemple #2
0
 public static EMOpenGPSInfo ConvertInfo(DataRow row)
 {
     if (row == null)
     {
         return null;
     }
     EMOpenGPSInfo info = new EMOpenGPSInfo();
     info.ID = (ulong)row["ID"];
     info.GPSCode = row["GPSCode"].ToString();
     info.Type = System.Convert.ToInt32(row["Type"]);
     info.Results = row["Results"].ToString();
     if (row["LastSetTime"] == DBNull.Value || row["LastSetTime"] == null)
         info.LastSetTime = null;
     else
         info.LastSetTime = DateTimeConvertHelper.Parse(row["LastSetTime"].ToString());
     return info;
 }
 public void Add(EMOpenGPSInfo entity)
 {
     string sql = string.Format(@"INSERT INTO movo_open_gpsinfo (`GPSCode`, `Type`)
                 VALUES ('{0}','{1}');", entity.GPSCode, entity.Type);
     MySqlHelper.ExecuteNonQuery(ConnectionString, sql);
 }
Exemple #4
0
        /// <summary>
        /// 根据GPSCode获取movo_open_gpsinfo中的信息
        /// </summary>
        /// <param name="gpsCode"></param>
        /// <returns></returns>
        public EMOpenGPSInfo GetOpenGPSInfoDeatails(string gpsCode)
        {
            EMOpenGPSInfo emGPs = null;
            if (!string.IsNullOrEmpty(gpsCode))
            {
                string sCmdText = string.Format(@"SELECT ID, GPSCode, Type, Results, LastSetTime 
 FROM movo_open_gpsinfo WHERE Type=1 AND  GPSCode='{0}' order by LastSetTime desc limit 0,1 ", gpsCode);
                using (MySqlDataReader sdr = MySqlDB.GetDataReader(CommandType.Text, sCmdText))
                {
                    if (sdr != null)
                    {
                        if (sdr.Read())
                        {
                            emGPs = new EMOpenGPSInfo();
                            emGPs.ID = sdr.GetUInt64(0);
                            emGPs.GPSCode = sdr.GetStringExt(1);
                            emGPs.Type = sdr.GetInt32(2);
                            emGPs.Results = sdr.GetStringExt(3);
                            emGPs.LastSetTime = sdr.GetDateTimeNull(4);
                        }
                        sdr.Close();
                    }
                }
            }
            return emGPs;
        }