/// <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>
/// <returns></returns>
internal static WaterUserLevelCollection CreateWaterUserLevelCollection()
{
WaterUserLevelCollection wulc = new WaterUserLevelCollection();
DataTable tbl = WaterUserLevelDBI.GetWaterUserLevelDataTable();
foreach (DataRow row in tbl.Rows)
{
WaterUserLevel wul = CreateWaterUserLevel(row);
wulc.Add(wul);
}
return(wulc);
}
/// <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="waterUserLevelID"></param>
/// <returns></returns>
static public WaterUserLevel CreateWaterUserLevelByID(int waterUserLevelID)
{
WaterUserLevel l = null;
DataTable tbl = WaterUserLevelDBI.GetWaterUserLevelDataTable(waterUserLevelID);
if (tbl.Rows.Count > 0)
{
DataRow r = tbl.Rows[0];
l = CreateWaterUserLevel(r);
}
else
{
string err = string.Format("not find waterUserLevel by id '{0}'", waterUserLevelID);
log.Error(err);
}
return(l);
}