public GPSRecord GetMax(string car) { var list = instance.GetMax(car); GPSRecord model = new GPSRecord(); if (list.Count>0) { model = list[0]; } else { model = null; } return model; }
/// <summary> /// 获取实体数据 /// </summary> /// <param name='strCondition'>条件(AND Code='11')</param> /// <returns>model</returns> public GPSRecord GetModel(string strCondition) { List<GPSRecord> list = instance.GetListByWhere(strCondition); GPSRecord model = new GPSRecord(); if (list != null && list.Count > 0) { model = list[0]; } else { model = null; } return model; }
/// <summary> /// 插入数据 /// </summary> /// <param name='model'>实体</param> /// <param name='model'>是否完成验证</param> /// <returns>bool</returns> public bool Insert(GPSRecord model,bool IsValid) { var e = new ModelExceptions(); bool result = false; if (e.IsValid && IsValid) { //完成了验证,开始更新数据库了 int _result = instance.Add(model); if (_result > 0) { result = true; } } return result; }
/// <summary> /// 更新数据 /// </summary> /// <param name='model'>实体</param> /// <returns>bool</returns> public bool Update(GPSRecord model,bool IsValid) { bool result = false; var e = new ModelExceptions(); if(e.IsValid && IsValid){ int _rseult = instance.Update(model); if (_rseult > 0) { result = true; } } return result; }
/// <summary> /// 插入数据 /// </summary> /// <param name='model'>实体</param> /// <returns>bool</returns> public bool Insert(GPSRecord model) { bool result = false; try { int _result = instance.Add(model); if (_result > 0) { result = true; } } catch (Exception ex) { throw ex; } return result; }
/// <summary> /// 更新GPSRecord对象(即:一条记录 /// </summary> public int Update(GPSRecord gPSRecord) { StringBuilder sbParameter=new StringBuilder(); StringBuilder sb=new StringBuilder(); sb.Append(@"UPDATE GPSRecord SET "); if(gPSRecord.License_Plate_IsChanged){sbParameter.Append("License_Plate=@License_Plate, ");} if(gPSRecord.Terminal_ID_IsChanged){sbParameter.Append("Terminal_ID=@Terminal_ID, ");} if(gPSRecord.PlateColor_IsChanged){sbParameter.Append("PlateColor=@PlateColor, ");} if(gPSRecord.DataType_IsChanged){sbParameter.Append("DataType=@DataType, ");} if(gPSRecord.GPSTime_IsChanged){sbParameter.Append("GPSTime=@GPSTime, ");} if(gPSRecord.Longitude_IsChanged){sbParameter.Append("Longitude=@Longitude, ");} if(gPSRecord.Latitude_IsChanged){sbParameter.Append("Latitude=@Latitude, ");} if(gPSRecord.GPSFlag_IsChanged){sbParameter.Append("GPSFlag=@GPSFlag, ");} if(gPSRecord.Speed_IsChanged){sbParameter.Append("Speed=@Speed, ");} if(gPSRecord.Direction_IsChanged){sbParameter.Append("Direction=@Direction, ");} if(gPSRecord.Comm_Type_IsChanged){sbParameter.Append("Comm_Type=@Comm_Type, ");} if(gPSRecord.MDTStatus_IsChanged){sbParameter.Append("MDTStatus=@MDTStatus, ");} if(gPSRecord.MDTAlarm_IsChanged){sbParameter.Append("MDTAlarm=@MDTAlarm, ");} if(gPSRecord.Data_Length_IsChanged){sbParameter.Append("Data_Length=@Data_Length, ");} if(gPSRecord.DataContend_IsChanged){sbParameter.Append("DataContend=@DataContend, ");} if(gPSRecord.Stat_IsChanged){sbParameter.Append("Stat=@Stat, ");} if(gPSRecord.CreateTime_IsChanged){sbParameter.Append("CreateTime=@CreateTime ");} sb.Append(sbParameter.ToString().Trim().TrimEnd(',')); sb.Append( " WHERE 1=1 AND ((Stat is null) or (Stat=0)) and Record_ID=@Record_ID; " ); string sql=sb.ToString(); if(gPSRecord.License_Plate_IsChanged) { if (string.IsNullOrEmpty(gPSRecord.License_Plate)) { idb.AddParameter("@License_Plate", DBNull.Value); } else { idb.AddParameter("@License_Plate", gPSRecord.License_Plate); } } if(gPSRecord.Terminal_ID_IsChanged) { if (string.IsNullOrEmpty(gPSRecord.Terminal_ID)) { idb.AddParameter("@Terminal_ID", DBNull.Value); } else { idb.AddParameter("@Terminal_ID", gPSRecord.Terminal_ID); } } if(gPSRecord.PlateColor_IsChanged) { if (gPSRecord.PlateColor == 0) { idb.AddParameter("@PlateColor", 0); } else { idb.AddParameter("@PlateColor", gPSRecord.PlateColor); } } if(gPSRecord.DataType_IsChanged) { if (gPSRecord.DataType == 0) { idb.AddParameter("@DataType", 0); } else { idb.AddParameter("@DataType", gPSRecord.DataType); } } if(gPSRecord.GPSTime_IsChanged) { if (gPSRecord.GPSTime == DateTime.MinValue) { idb.AddParameter("@GPSTime", DBNull.Value); } else { idb.AddParameter("@GPSTime", gPSRecord.GPSTime); } } if(gPSRecord.Longitude_IsChanged) { if (gPSRecord.Longitude == 0) { idb.AddParameter("@Longitude", 0); } else { idb.AddParameter("@Longitude", gPSRecord.Longitude); } } if(gPSRecord.Latitude_IsChanged) { if (gPSRecord.Latitude == 0) { idb.AddParameter("@Latitude", 0); } else { idb.AddParameter("@Latitude", gPSRecord.Latitude); } } if(gPSRecord.GPSFlag_IsChanged) { if (gPSRecord.GPSFlag == 0) { idb.AddParameter("@GPSFlag", 0); } else { idb.AddParameter("@GPSFlag", gPSRecord.GPSFlag); } } if(gPSRecord.Speed_IsChanged) { if (gPSRecord.Speed == 0) { idb.AddParameter("@Speed", 0); } else { idb.AddParameter("@Speed", gPSRecord.Speed); } } if(gPSRecord.Direction_IsChanged) { if (gPSRecord.Direction == 0) { idb.AddParameter("@Direction", 0); } else { idb.AddParameter("@Direction", gPSRecord.Direction); } } if(gPSRecord.Comm_Type_IsChanged) { if (gPSRecord.Comm_Type == 0) { idb.AddParameter("@Comm_Type", 0); } else { idb.AddParameter("@Comm_Type", gPSRecord.Comm_Type); } } if(gPSRecord.MDTStatus_IsChanged) { if (gPSRecord.MDTStatus == 0) { idb.AddParameter("@MDTStatus", 0); } else { idb.AddParameter("@MDTStatus", gPSRecord.MDTStatus); } } if(gPSRecord.MDTAlarm_IsChanged) { if (gPSRecord.MDTAlarm == 0) { idb.AddParameter("@MDTAlarm", 0); } else { idb.AddParameter("@MDTAlarm", gPSRecord.MDTAlarm); } } if(gPSRecord.Data_Length_IsChanged) { if (gPSRecord.Data_Length == 0) { idb.AddParameter("@Data_Length", 0); } else { idb.AddParameter("@Data_Length", gPSRecord.Data_Length); } } if(gPSRecord.DataContend_IsChanged) { if (string.IsNullOrEmpty(gPSRecord.DataContend)) { idb.AddParameter("@DataContend", DBNull.Value); } else { idb.AddParameter("@DataContend", gPSRecord.DataContend); } } if(gPSRecord.Stat_IsChanged) { if (gPSRecord.Stat == 0) { idb.AddParameter("@Stat", 0); } else { idb.AddParameter("@Stat", gPSRecord.Stat); } } if(gPSRecord.CreateTime_IsChanged) { if (gPSRecord.CreateTime == DateTime.MinValue) { idb.AddParameter("@CreateTime", DBNull.Value); } else { idb.AddParameter("@CreateTime", gPSRecord.CreateTime); } } idb.AddParameter("@Record_ID", gPSRecord.Record_ID); return idb.ExeCmd(sql); }
public List<GPSRecord> GetMax(string car) { List<GPSRecord> ret = new List<GPSRecord>(); string sql = "SELECT top 1 Record_ID,License_Plate,Terminal_ID,PlateColor,DataType,GPSTime,Longitude,Latitude,GPSFlag,Speed,Direction,Comm_Type,MDTStatus,MDTAlarm,Data_Length,DataContend,Stat,CreateTime FROM GPSRecord where 1=1 AND ((Stat is null) or (Stat=0) ) and License_Plate='"+car+"' ORDER BY Record_ID desc "; SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { GPSRecord gPSRecord = new GPSRecord(); if (dr["Record_ID"] != DBNull.Value) gPSRecord.Record_ID = Convert.ToDecimal(dr["Record_ID"]); if (dr["License_Plate"] != DBNull.Value) gPSRecord.License_Plate = Convert.ToString(dr["License_Plate"]); if (dr["Terminal_ID"] != DBNull.Value) gPSRecord.Terminal_ID = Convert.ToString(dr["Terminal_ID"]); if (dr["PlateColor"] != DBNull.Value) gPSRecord.PlateColor = Convert.ToInt32(dr["PlateColor"]); if (dr["DataType"] != DBNull.Value) gPSRecord.DataType = Convert.ToInt32(dr["DataType"]); if (dr["GPSTime"] != DBNull.Value) gPSRecord.GPSTime = Convert.ToDateTime(dr["GPSTime"]); if (dr["Longitude"] != DBNull.Value) gPSRecord.Longitude = Convert.ToDecimal(dr["Longitude"]); if (dr["Latitude"] != DBNull.Value) gPSRecord.Latitude = Convert.ToDecimal(dr["Latitude"]); if (dr["GPSFlag"] != DBNull.Value) gPSRecord.GPSFlag = Convert.ToInt32(dr["GPSFlag"]); if (dr["Speed"] != DBNull.Value) gPSRecord.Speed = Convert.ToInt32(dr["Speed"]); if (dr["Direction"] != DBNull.Value) gPSRecord.Direction = Convert.ToInt32(dr["Direction"]); if (dr["Comm_Type"] != DBNull.Value) gPSRecord.Comm_Type = Convert.ToInt32(dr["Comm_Type"]); if (dr["MDTStatus"] != DBNull.Value) gPSRecord.MDTStatus = Convert.ToInt32(dr["MDTStatus"]); if (dr["MDTAlarm"] != DBNull.Value) gPSRecord.MDTAlarm = Convert.ToInt32(dr["MDTAlarm"]); if (dr["Data_Length"] != DBNull.Value) gPSRecord.Data_Length = Convert.ToInt32(dr["Data_Length"]); if (dr["DataContend"] != DBNull.Value) gPSRecord.DataContend = Convert.ToString(dr["DataContend"]); if (dr["Stat"] != DBNull.Value) gPSRecord.Stat = Convert.ToInt32(dr["Stat"]); if (dr["CreateTime"] != DBNull.Value) gPSRecord.CreateTime = Convert.ToDateTime(dr["CreateTime"]); ret.Add(gPSRecord); } } catch (System.Exception ex) { throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return ret; }
/// <summary> /// 获取指定的GPSRecord对象(即:一条记录 /// </summary> public GPSRecord GetByKey(decimal record_ID) { GPSRecord gPSRecord = new GPSRecord(); string sql = "SELECT Record_ID,License_Plate,Terminal_ID,PlateColor,DataType,GPSTime,Longitude,Latitude,GPSFlag,Speed,Direction,Comm_Type,MDTStatus,MDTAlarm,Data_Length,DataContend,Stat,CreateTime FROM GPSRecord WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND Record_ID=@Record_ID "; idb.AddParameter("@Record_ID", record_ID); SqlDataReader dr=null; try { dr=(SqlDataReader)idb.ReturnReader(sql); while(dr.Read()) { if (dr["Record_ID"] != DBNull.Value) gPSRecord.Record_ID = Convert.ToDecimal(dr["Record_ID"]); if (dr["License_Plate"] != DBNull.Value) gPSRecord.License_Plate = Convert.ToString(dr["License_Plate"]); if (dr["Terminal_ID"] != DBNull.Value) gPSRecord.Terminal_ID = Convert.ToString(dr["Terminal_ID"]); if (dr["PlateColor"] != DBNull.Value) gPSRecord.PlateColor = Convert.ToInt32(dr["PlateColor"]); if (dr["DataType"] != DBNull.Value) gPSRecord.DataType = Convert.ToInt32(dr["DataType"]); if (dr["GPSTime"] != DBNull.Value) gPSRecord.GPSTime = Convert.ToDateTime(dr["GPSTime"]); if (dr["Longitude"] != DBNull.Value) gPSRecord.Longitude = Convert.ToDecimal(dr["Longitude"]); if (dr["Latitude"] != DBNull.Value) gPSRecord.Latitude = Convert.ToDecimal(dr["Latitude"]); if (dr["GPSFlag"] != DBNull.Value) gPSRecord.GPSFlag = Convert.ToInt32(dr["GPSFlag"]); if (dr["Speed"] != DBNull.Value) gPSRecord.Speed = Convert.ToInt32(dr["Speed"]); if (dr["Direction"] != DBNull.Value) gPSRecord.Direction = Convert.ToInt32(dr["Direction"]); if (dr["Comm_Type"] != DBNull.Value) gPSRecord.Comm_Type = Convert.ToInt32(dr["Comm_Type"]); if (dr["MDTStatus"] != DBNull.Value) gPSRecord.MDTStatus = Convert.ToInt32(dr["MDTStatus"]); if (dr["MDTAlarm"] != DBNull.Value) gPSRecord.MDTAlarm = Convert.ToInt32(dr["MDTAlarm"]); if (dr["Data_Length"] != DBNull.Value) gPSRecord.Data_Length = Convert.ToInt32(dr["Data_Length"]); if (dr["DataContend"] != DBNull.Value) gPSRecord.DataContend = Convert.ToString(dr["DataContend"]); if (dr["Stat"] != DBNull.Value) gPSRecord.Stat = Convert.ToInt32(dr["Stat"]); if (dr["CreateTime"] != DBNull.Value) gPSRecord.CreateTime = Convert.ToDateTime(dr["CreateTime"]); } }catch (System.Exception ex){ throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return gPSRecord; }
/// <summary> /// 添加GPSRecord对象(即:一条记录) /// </summary> public int Add(GPSRecord gPSRecord) { string sql = "INSERT INTO GPSRecord (License_Plate,Terminal_ID,PlateColor,DataType,GPSTime,Longitude,Latitude,GPSFlag,Speed,Direction,Comm_Type,MDTStatus,MDTAlarm,Data_Length,DataContend,Stat,CreateTime) VALUES (@License_Plate,@Terminal_ID,@PlateColor,@DataType,@GPSTime,@Longitude,@Latitude,@GPSFlag,@Speed,@Direction,@Comm_Type,@MDTStatus,@MDTAlarm,@Data_Length,@DataContend,@Stat,@CreateTime)"; if (string.IsNullOrEmpty(gPSRecord.License_Plate)) { idb.AddParameter("@License_Plate", DBNull.Value); } else { idb.AddParameter("@License_Plate", gPSRecord.License_Plate); } if (string.IsNullOrEmpty(gPSRecord.Terminal_ID)) { idb.AddParameter("@Terminal_ID", DBNull.Value); } else { idb.AddParameter("@Terminal_ID", gPSRecord.Terminal_ID); } if (gPSRecord.PlateColor == 0) { idb.AddParameter("@PlateColor", 0); } else { idb.AddParameter("@PlateColor", gPSRecord.PlateColor); } if (gPSRecord.DataType == 0) { idb.AddParameter("@DataType", 0); } else { idb.AddParameter("@DataType", gPSRecord.DataType); } if (gPSRecord.GPSTime == DateTime.MinValue) { idb.AddParameter("@GPSTime", DBNull.Value); } else { idb.AddParameter("@GPSTime", gPSRecord.GPSTime); } if (gPSRecord.Longitude == 0) { idb.AddParameter("@Longitude", 0); } else { idb.AddParameter("@Longitude", gPSRecord.Longitude); } if (gPSRecord.Latitude == 0) { idb.AddParameter("@Latitude", 0); } else { idb.AddParameter("@Latitude", gPSRecord.Latitude); } if (gPSRecord.GPSFlag == 0) { idb.AddParameter("@GPSFlag", 0); } else { idb.AddParameter("@GPSFlag", gPSRecord.GPSFlag); } if (gPSRecord.Speed == 0) { idb.AddParameter("@Speed", 0); } else { idb.AddParameter("@Speed", gPSRecord.Speed); } if (gPSRecord.Direction == 0) { idb.AddParameter("@Direction", 0); } else { idb.AddParameter("@Direction", gPSRecord.Direction); } if (gPSRecord.Comm_Type == 0) { idb.AddParameter("@Comm_Type", 0); } else { idb.AddParameter("@Comm_Type", gPSRecord.Comm_Type); } if (gPSRecord.MDTStatus == 0) { idb.AddParameter("@MDTStatus", 0); } else { idb.AddParameter("@MDTStatus", gPSRecord.MDTStatus); } if (gPSRecord.MDTAlarm == 0) { idb.AddParameter("@MDTAlarm", 0); } else { idb.AddParameter("@MDTAlarm", gPSRecord.MDTAlarm); } if (gPSRecord.Data_Length == 0) { idb.AddParameter("@Data_Length", 0); } else { idb.AddParameter("@Data_Length", gPSRecord.Data_Length); } if (string.IsNullOrEmpty(gPSRecord.DataContend)) { idb.AddParameter("@DataContend", DBNull.Value); } else { idb.AddParameter("@DataContend", gPSRecord.DataContend); } if (gPSRecord.Stat == 0) { idb.AddParameter("@Stat", 0); } else { idb.AddParameter("@Stat", gPSRecord.Stat); } if (gPSRecord.CreateTime == DateTime.MinValue) { idb.AddParameter("@CreateTime", DBNull.Value); } else { idb.AddParameter("@CreateTime", gPSRecord.CreateTime); } return idb.ExeCmd(sql); }