Ejemplo n.º 1
0
 private int RunCommandWithTransatcion(VSM.Entities.BuGPSLog ent, string vSql, IDbTransaction TRANS)
 {
     if (null == TRANS)
     {
         MySqlParameter[] paras = new MySqlParameter[ent.Column.Count];
         for (int i = 0; i < ent.Column.Count; i++)
         {
             paras[i] = new MySqlParameter();
             paras[i].ParameterName = ent.Column[i].FieldName;
             paras[i].DbType        = ent.Column[i].FieldType;
             paras[i].Value         = ent.Column[i].FieldValue;
         }
         return(DataBaseManage.ExecuteSql(vSql, paras));
     }
     else
     {
         System.Data.IDbCommand CM = TRANS.Connection.CreateCommand();
         CM.CommandText = vSql;
         CM.CommandType = CommandType.Text;
         CM.Transaction = TRANS;
         GetEntityDeleteParameter(CM, ent);
         try
         {
             return(CM.ExecuteNonQuery());
         }
         catch (System.Exception e)
         {
             if (isDebug)
             {
                 throw new Exception(e.Message);
             }
             return(0);
         }
     }
 }
Ejemplo n.º 2
0
 /// <summary>
 /// 得到列表
 /// </summary>
 /// <param name="ent"></param>
 /// <returns></returns>
 public List<BuGPSLog> GetBuGPSLogList(string Where)
 {
     List<BuGPSLog> list = new List<BuGPSLog>();
     using(DbDataReader reader = DataBaseManage.ExecuteReader(DalSql+Where))
     {
         while (reader.Read())
         {
            BuGPSLog ent = new BuGPSLog();
             SetEnt(ent, reader);
             list.Add(ent);
         }
     }
     return list;
 }
Ejemplo n.º 3
0
 /// <summary>
 /// 根据GPSLogId得到 BuGPSLog 实体
 /// </summary>
 /// <param name="ent"></param>
 /// <returns></returns>
 public BuGPSLog GetBuGPSLog(int GPSLogId)
 {
     BuGPSLog ent = null;
     string sql = DalSql;
     sql = sql + " And  GPSLogId";
     MySqlParameter[] paras = new MySqlParameter[]
     {
         new MySqlParameter("GPSLogId",GPSLogId)
     };
     using(DbDataReader reader = DataBaseManage.ExecuteReader(sql, paras))
     {
         if (reader.Read())
         {
             ent = new BuGPSLog();
             SetEnt(ent, reader);
         }
        		}
     return ent;
 }
Ejemplo n.º 4
0
 public void SetEnt(BuGPSLog ent, IDataReader dr)
 {
     ent.GPSLogId = MyConvert.ToInt(dr["GPSLogId"]);
     ent.SynchronizationStatus = MyConvert.ToString(dr["SynchronizationStatus"]);
     ent.SynchronizationDate = MyConvert.ToDateTime(dr["SynchronizationDate"]);
     ent.SynchronizationInfo = MyConvert.ToString(dr["SynchronizationInfo"]);
 }