public static DEVICE_STATUS Get(int primaryKeyId, string tableName) { Hashtable inparam = new Hashtable(); inparam.Add("GPSIndex", primaryKeyId); inparam.Add("tableName", tableName); return(BaseDA.QueryForObject <DEVICE_STATUS>("SelectDEVICE_STATUSById", inparam)); }
public static int Delete(int primaryKeyId, string tableName) { Hashtable inparam = new Hashtable(); inparam.Add("GPSIndex", primaryKeyId); inparam.Add("tableName", tableName); return(BaseDA.Delete2("DeleteDEVICE_STATUSById", inparam)); }
public static IList <DEVICE_STATUS> QueryForList(string tableName, DEVICE_STATUS parameterObject = null) { Hashtable inparam = new Hashtable(); if (parameterObject != null) { if (parameterObject.aDatetime != null) { inparam.Add("aDatetime", parameterObject.aDatetime); } } inparam.Add("tableName", tableName); return(BaseDA.QueryForList <DEVICE_STATUS>("SelectDEVICE_STATUSQuery", inparam)); }
public static int Update(DEVICE_STATUS_CLEAN parameterObject, string tableName) { Hashtable inparam = new Hashtable(); if (parameterObject != null) { if (parameterObject.aDatetime != null) { inparam.Add("aDatetime", parameterObject.aDatetime); } if (parameterObject.GPSIndex != null) { inparam.Add("GPSIndex", parameterObject.GPSIndex); } if (parameterObject.Height != null) { inparam.Add("Height", parameterObject.Height); } if (parameterObject.Hspeed != null) { inparam.Add("Hspeed", parameterObject.Hspeed); } if (parameterObject.Style != null) { inparam.Add("Style", parameterObject.Style); } if (parameterObject.X != null) { inparam.Add("X", parameterObject.X); } if (parameterObject.XSpeed != null) { inparam.Add("XSpeed", parameterObject.XSpeed); } if (parameterObject.Y != null) { inparam.Add("Y", parameterObject.Y); } if (parameterObject.YSpeed != null) { inparam.Add("YSpeed", parameterObject.YSpeed); } } inparam.Add("tableName", tableName); return(BaseDA.Update2("UpdateDEVICE_STATUS_CLEAN", inparam)); }
public static IList <DEVICE_STATUS_CLEAN> QueryForList(string tableName, DEVICE_STATUS_CLEAN parameterObject = null) { Hashtable inparam = new Hashtable(); if (parameterObject != null) { if (parameterObject.aDatetime.HasValue) { inparam.Add("aDatetime", parameterObject.aDatetime.Value); } if (parameterObject.Style.HasValue) { inparam.Add("Style", parameterObject.Style.Value); } } inparam.Add("tableName", tableName); return(BaseDA.QueryForList <DEVICE_STATUS_CLEAN>("SelectDEVICE_STATUS_CLEANQuery", inparam)); }
public static object Insert(DEVICE_STATUS parameterObject, string tableName) { Hashtable inparam = new Hashtable(); if (parameterObject != null) { if (parameterObject.aDatetime != null) { inparam.Add("aDatetime", parameterObject.aDatetime); } if (parameterObject.dltaH != null) { inparam.Add("dltaH", parameterObject.dltaH); } if (parameterObject.dltaX != null) { inparam.Add("dltaX", parameterObject.dltaX); } if (parameterObject.dltaY != null) { inparam.Add("dltaY", parameterObject.dltaY); } if (parameterObject.GPSIndex != null) { inparam.Add("GPSIndex", parameterObject.GPSIndex); } if (parameterObject.Height != null) { inparam.Add("Height", parameterObject.Height); } if (parameterObject.X != null) { inparam.Add("X", parameterObject.X); } if (parameterObject.Y != null) { inparam.Add("Y", parameterObject.Y); } } inparam.Add("tableName", tableName); return(BaseDA.Insert2("InsertDEVICE_STATUS", inparam)); }
public static int GetNewId() { return(BaseDA.QueryForObject <int>("SelectUSERMaxID", null)); }
public static USER Get(int primaryKeyId) { return(BaseDA.Get <USER>("SelectUSERById", primaryKeyId)); }
public static int Update(USER t) { return(BaseDA.Update <USER>("UpdateUSER", t)); }
public static IList <RIGHT> QueryForList(object parameterObject = null) { return(BaseDA.QueryForList <RIGHT>("SelectAllRIGHT", parameterObject)); }
public static int Update(RIGHT t) { return(BaseDA.Update <RIGHT>("UpdateRIGHT", t)); }
public static IList <T_STATION> QueryForList(object parameterObject = null) { return(BaseDA.QueryForList <T_STATION>("SelectAllT_STATION", parameterObject)); }
public static SB_STATUS Get(int primaryKeyId) { return(BaseDA.Get <SB_STATUS>("SelectSB_STATUSById", primaryKeyId)); }
public static int Update(SB_STATUS t) { return(BaseDA.Update <SB_STATUS>("UpdateSB_STATUS", t)); }
public static object Insert(sat t) { return(BaseDA.Insert <sat>("Insertsat", t)); }
public static int Delete(int primaryKeyId) { return(BaseDA.Delete("DeleteT_STATIONById", primaryKeyId)); }
public static T_STATION Get(int primaryKeyId) { return(BaseDA.Get <T_STATION>("SelectT_STATIONById", primaryKeyId)); }
public static IList <SB_STATUS> QueryForList(object parameterObject = null) { return(BaseDA.QueryForList <SB_STATUS>("SelectAllSB_STATUS", parameterObject)); }
public static object Insert(T_STATION t) { return(BaseDA.Insert <T_STATION>("InsertT_STATION", t)); }
public static object Insert(SB_STATUS t) { return(BaseDA.Insert <SB_STATUS>("InsertSB_STATUS", t)); }
public static RIGHT Get(int primaryKeyId) { return(BaseDA.Get <RIGHT>("SelectRIGHTById", primaryKeyId)); }
public static int Update(STATION_ACCESS t) { return(BaseDA.Update <STATION_ACCESS>("UpdateSTATION_ACCESS", t)); }
public static object Insert(RIGHT t) { return(BaseDA.Insert <RIGHT>("InsertRIGHT", t)); }
public static STATION_ACCESS Get(int primaryKeyId) { return(BaseDA.Get <STATION_ACCESS>("SelectSTATION_ACCESSById", primaryKeyId)); }
public static int Delete(int primaryKeyId) { return(BaseDA.Delete("DeleteUSERById", primaryKeyId)); }
public static IList <STATION_ACCESS> QueryForList(object parameterObject = null) { return(BaseDA.QueryForList <STATION_ACCESS>("SelectAllSTATION_ACCESS", parameterObject)); }
public static IList <USER> QueryForList(object parameterObject = null) { return(BaseDA.QueryForList <USER>("SelectAllUSER", parameterObject)); }
public static object Insert(STATION_ACCESS t) { return(BaseDA.Insert <STATION_ACCESS>("InsertSTATION_ACCESS", t)); }
public static object Insert(USER t) { return(BaseDA.Insert <USER>("InsertUSER", t)); }
public static int Update(T_STATION t) { return(BaseDA.Update <T_STATION>("UpdateT_STATION", t)); }