Пример #1
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(LogisticsChain.Entity.PositionEntity model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update position set ");
            strSql.Append("CreateTime=@CreateTime,");
            strSql.Append("longitude=@longitude,");
            strSql.Append("latitude=@latitude,");
            strSql.Append("Waybill=@Waybill");
            strSql.Append(" where Id=@Id ");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@CreateTime", MySqlDbType.DateTime),
                new MySqlParameter("@longitude",  MySqlDbType.VarChar,   12),
                new MySqlParameter("@latitude",   MySqlDbType.VarChar,   12),
                new MySqlParameter("@Waybill",    MySqlDbType.VarChar,   36),
                new MySqlParameter("@Id",         MySqlDbType.VarChar, 36)
            };
            parameters[0].Value = model.CreateTime;
            parameters[1].Value = model.longitude;
            parameters[2].Value = model.latitude;
            parameters[3].Value = model.Waybill;
            parameters[4].Value = model.Id;

            int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Пример #2
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public LogisticsChain.Entity.PositionEntity DataRowToModel(DataRow row)
 {
     LogisticsChain.Entity.PositionEntity model = new LogisticsChain.Entity.PositionEntity();
     if (row != null)
     {
         if (row["Id"] != null)
         {
             model.Id = row["Id"].ToString();
         }
         if (row["CreateTime"] != null && row["CreateTime"].ToString() != "")
         {
             model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
         }
         if (row["longitude"] != null)
         {
             model.longitude = row["longitude"].ToString();
         }
         if (row["latitude"] != null)
         {
             model.latitude = row["latitude"].ToString();
         }
         if (row["Waybill"] != null)
         {
             model.Waybill = row["Waybill"].ToString();
         }
     }
     return(model);
 }
Пример #3
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(LogisticsChain.Entity.PositionEntity model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into position(");
            strSql.Append("Id,CreateTime,longitude,latitude,Waybill)");
            strSql.Append(" values (");
            strSql.Append("@Id,@CreateTime,@longitude,@latitude,@Waybill)");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@Id",         MySqlDbType.VarChar,   36),
                new MySqlParameter("@CreateTime", MySqlDbType.DateTime),
                new MySqlParameter("@longitude",  MySqlDbType.VarChar,   12),
                new MySqlParameter("@latitude",   MySqlDbType.VarChar,   12),
                new MySqlParameter("@Waybill",    MySqlDbType.VarChar, 36)
            };
            parameters[0].Value = model.Id;
            parameters[1].Value = model.CreateTime;
            parameters[2].Value = model.longitude;
            parameters[3].Value = model.latitude;
            parameters[4].Value = model.Waybill;

            int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Пример #4
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public LogisticsChain.Entity.PositionEntity GetModel(string Id)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select Id,CreateTime,longitude,latitude,Waybill from position ");
            strSql.Append(" where Id=@Id ");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@Id", MySqlDbType.VarChar, 36)
            };
            parameters[0].Value = Id;

            LogisticsChain.Entity.PositionEntity model = new LogisticsChain.Entity.PositionEntity();
            DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }