/// <summary>
///
/// </summary>
/// <param name="levelEnum"></param>
/// <returns></returns>
static public DataTable GetWaterUserDataTable(WaterUserLevelEnum levelEnum)
{
int levelID = WaterUserLevelDBI.GetWaterUserLevelID(levelEnum);
string s = string.Format("select * from tblWaterUser where deleted = 0 and waterUserLevelID = {0}",
levelID);
DataTable tbl = DBI.GetDBI().ExecuteDataTable(s);
return(tbl);
}
/// <summary>
///
/// </summary>
/// <param name="wulEnum"></param>
/// <returns></returns>
public static WaterUserLevel CreateWaterLevel(WaterUserLevelEnum wulEnum)
{
DataTable tbl = WaterUserLevelDBI.GetWaterUserLevelDataTableByOrdinal((int)wulEnum);
if (tbl.Rows.Count > 0)
{
int wulID = Convert.ToInt32(tbl.Rows[0]["WaterUserlevelID"]);
WaterUserLevel l = WaterUserLevelFactory.CreateWaterUserLevelByID(wulID);
return l;
}
return null;
}
/// <summary>
///
/// </summary>
/// <param name="le"></param>
/// <returns></returns>
public static int GetWaterUserLevelID(WaterUserLevelEnum le)
{
DataTable tbl = GetWaterUserLevelDataTableByOrdinal((int)le);
if (tbl.Rows.Count > 0)
{
return Convert.ToInt32(tbl.Rows[0][DBNames.tblWaterUserLevel.WaterUserLevelID]);
}
else
{
return 0;
}
}
/// <summary>
///
/// </summary>
/// <param name="wulEnum"></param>
/// <returns></returns>
static public WaterUserLevel CreateWaterLevel(WaterUserLevelEnum wulEnum)
{
DataTable tbl = WaterUserLevelDBI.GetWaterUserLevelDataTableByOrdinal((int)wulEnum);
if (tbl.Rows.Count > 0)
{
int wulID = Convert.ToInt32(tbl.Rows[0]["WaterUserlevelID"]);
WaterUserLevel l = WaterUserLevelFactory.CreateWaterUserLevelByID(wulID);
return(l);
}
return(null);
}
/// <summary>
///
/// </summary>
/// <param name="e"></param>
/// <returns></returns>
static public WaterUserLevel GetWaterUserLevel(WaterUserLevelEnum e)
{
foreach (WaterUserLevel l in All)
{
if (l.LevelOrdinal == (int)e)
{
return(l);
}
}
return(null);
}
/// <summary>
///
/// </summary>
/// <param name="le"></param>
/// <returns></returns>
static public int GetWaterUserLevelID(WaterUserLevelEnum le)
{
DataTable tbl = GetWaterUserLevelDataTableByOrdinal((int)le);
if (tbl.Rows.Count > 0)
{
return(Convert.ToInt32(tbl.Rows[0][DBNames.tblWaterUserLevel.WaterUserLevelID]));
}
else
{
return(0);
}
}
/// <summary>
///
/// </summary>
/// <param name="le"></param>
/// <returns></returns>
static public bool HasWaterUser(WaterUserLevelEnum le)
{
DataTable tbl = GetWaterUserDataTable(le);
return(tbl.Rows.Count > 0);
}
/// <summary>
///
/// </summary>
/// <param name="e"></param>
/// <returns></returns>
public static WaterUserLevel GetWaterUserLevel(WaterUserLevelEnum e)
{
foreach (WaterUserLevel l in All)
{
if (l.LevelOrdinal == (int)e)
{
return l;
}
}
return null;
}
/// <summary>
///
/// </summary>
/// <param name="le"></param>
/// <returns></returns>
public static bool HasWaterUser(WaterUserLevelEnum le)
{
DataTable tbl = GetWaterUserDataTable(le);
return tbl.Rows.Count > 0;
}
/// <summary>
///
/// </summary>
/// <param name="levelEnum"></param>
/// <returns></returns>
public static DataTable GetWaterUserDataTable(WaterUserLevelEnum levelEnum)
{
int levelID = WaterUserLevelDBI.GetWaterUserLevelID(levelEnum);
string s = string.Format ("select * from tblWaterUser where deleted = 0 and waterUserLevelID = {0}",
levelID);
DataTable tbl = DBI.GetDBI().ExecuteDataTable(s);
return tbl;
}
