/// <summary>
///
/// </summary>
/// <param name="row"></param>
/// <returns></returns>
private static WaterUserClass CreateWaterUser(DataRow row)
{
int waterUserID = Convert.ToInt32(row["WaterUserID"]);
int waterUserLevelID = Convert.ToInt32(row["WaterUserLevelID"]);
int wuTypeID = Convert.ToInt32(row["WaterUserTypeID"]);
string name = row["WaterUserName"].ToString();
string remark = row["remark"].ToString();
float unitPrice = GetUnitPriceFromDataRow(row);
// TODO: 2011-04-08
// parent wateruser, wulevel, indevice ...
// init at get property
//
// 2. dead loop
//
//WaterUserClass parentWaterUser = null;
//object parentObject = row["ParentWaterUserID"];
//if (parentObject != DBNull.Value)
//{
// int parentID = Convert.ToInt32(row["ParentWaterUserID"]);
// if (parentID != waterUserID)
// {
// parentWaterUser = CreateWaterUserByID(parentID);
// }
//}
//wu.ParentWaterUser = CreateWaterUserByID(parentID);
//wu.ParentWaterUser = parentWaterUser;
WaterUserLevel wuLevel = WaterUserLevelFactory.CreateWaterUserLevelByID(waterUserLevelID);
//WaterUserType
WaterUserType wuType = WaterUserTypeFactory.CreateWaterUserTypeByID(wuTypeID);
WaterUserClass wu = new WaterUserClass();
wu.Name = name;
wu.WaterUserID = waterUserID;
wu.WaterUserLevel = wuLevel;
wu.WaterUserType = wuType;
wu.Remark = remark;
wu.UnitPrice = unitPrice;
wu.ChannelCollection = ChannelFactory.CreateChannelCollection(waterUserID);
//wu.InStationCollection
//wu.InDeviceCollection = CreateInDevice
//wu.OutStationCollection
//wu.InDeviceCollection = DeviceFactory.CreateInDeviceCollection(waterUserID);
//wu.OutDeviceCollection = DeviceFactory.CreateOutDeviceCollection(waterUserID);
return(wu);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
internal static WaterUserTypeCollection CreateWaterUserTypeCollection()
{
WaterUserTypeCollection wutc = new WaterUserTypeCollection();
DataTable tbl = WaterUserTypeDBI.GetWaterUserTypeDataTable();
foreach (DataRow row in tbl.Rows)
{
WaterUserType t = CreateWaterUserType(row);
wutc.Add(t);
}
return(wutc);
}
/// <summary>
///
/// </summary>
internal static WaterUserType CreateManagerWaterUserType()
{
WaterUserType t = null;
DataTable tbl = WaterUserTypeDBI.GetManagerWaterUserDataTable();
if (tbl.Rows.Count > 0)
{
DataRow row = tbl.Rows[0];
t = CreateWaterUserType(row);
}
return(t);
}
/// <summary>
///
/// </summary>
/// <param name="row"></param>
/// <returns></returns>
private static WaterUserType CreateWaterUserType(DataRow row)
{
WaterUserType wut = new WaterUserType();
int id = Convert.ToInt32(row["waterUserTypeID"]);
string n = row["WaterUserTypeName"].ToString();
string remark = row["WaterUserTypeRemark"].ToString();
//int isManager = Convert.ToInt32(row["IsManager"]);
wut.WaterUserTypeID = id;
wut.WaterUserTypeName = n;
wut.WaterUserTypeRemark = remark;
//wut.IsManager = isManager;
return(wut);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
static public WaterUserType CreateDefaultWaterUserType()
{
DataTable tbl = WaterUserTypeDBI.GetDefaultWaterUserTypeDataTable();
if (tbl.Rows.Count > 0)
{
WaterUserType t = CreateWaterUserType(tbl.Rows[0]);
return(t);
}
else
{
string exmsg = "cannot find default water user type";
throw new InvalidOperationException(exmsg);
}
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
static public WaterUserType CreateWaterUserTypeByID(int id)
{
WaterUserType wut = null;
DataTable tbl = WaterUserTypeDBI.GetWaterUserTypeDataTable(id);
if (tbl.Rows.Count > 0)
{
DataRow row = tbl.Rows[0];
wut = CreateWaterUserType(row);
}
else
{
string err = string.Format("not find water user type by id '{0}'", id);
log.Error(err);
}
return(wut);
}
/// <summary>
///
/// </summary>
/// <param name="row"></param>
/// <returns></returns>
private static WaterUserType CreateWaterUserType(DataRow row)
{
WaterUserType wut = new WaterUserType();
int id = Convert.ToInt32(row["waterUserTypeID"]);
string n = row["WaterUserTypeName"].ToString();
string remark = row["WaterUserTypeRemark"].ToString();
//int isManager = Convert.ToInt32(row["IsManager"]);
wut.WaterUserTypeID = id;
wut.WaterUserTypeName = n;
wut.WaterUserTypeRemark = remark;
//wut.IsManager = isManager;
return wut;
}
