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));
}