/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MobileSoft.Model.Sys.Tb_Sys_TakePicRoomState model)
{
return(dal.Add(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(MobileSoft.Model.Sys.Tb_Sys_TakePicRoomState model)
{
dal.Update(model);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <MobileSoft.Model.Sys.Tb_Sys_TakePicRoomState> DataTableToList(DataTable dt)
{
List <MobileSoft.Model.Sys.Tb_Sys_TakePicRoomState> modelList = new List <MobileSoft.Model.Sys.Tb_Sys_TakePicRoomState>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
MobileSoft.Model.Sys.Tb_Sys_TakePicRoomState model;
for (int n = 0; n < rowsCount; n++)
{
model = new MobileSoft.Model.Sys.Tb_Sys_TakePicRoomState();
//model.StatID=dt.Rows[n]["StatID"].ToString();
if (dt.Rows[n]["StatType"].ToString() != "")
{
model.StatType = int.Parse(dt.Rows[n]["StatType"].ToString());
}
if (dt.Rows[n]["CommID"].ToString() != "")
{
model.CommID = int.Parse(dt.Rows[n]["CommID"].ToString());
}
model.OrganCode = dt.Rows[n]["OrganCode"].ToString();
if (dt.Rows[n]["StatDate"].ToString() != "")
{
model.StatDate = DateTime.Parse(dt.Rows[n]["StatDate"].ToString());
}
if (dt.Rows[n]["RoomState"].ToString() != "")
{
model.RoomState = int.Parse(dt.Rows[n]["RoomState"].ToString());
}
if (dt.Rows[n]["Counts"].ToString() != "")
{
model.Counts = int.Parse(dt.Rows[n]["Counts"].ToString());
}
if (dt.Rows[n]["Counts0"].ToString() != "")
{
model.Counts0 = int.Parse(dt.Rows[n]["Counts0"].ToString());
}
if (dt.Rows[n]["Counts1"].ToString() != "")
{
model.Counts1 = int.Parse(dt.Rows[n]["Counts1"].ToString());
}
if (dt.Rows[n]["Counts2"].ToString() != "")
{
model.Counts2 = int.Parse(dt.Rows[n]["Counts2"].ToString());
}
if (dt.Rows[n]["Counts3"].ToString() != "")
{
model.Counts3 = int.Parse(dt.Rows[n]["Counts3"].ToString());
}
if (dt.Rows[n]["Counts4"].ToString() != "")
{
model.Counts4 = int.Parse(dt.Rows[n]["Counts4"].ToString());
}
if (dt.Rows[n]["Counts5"].ToString() != "")
{
model.Counts5 = int.Parse(dt.Rows[n]["Counts5"].ToString());
}
if (dt.Rows[n]["Counts6"].ToString() != "")
{
model.Counts6 = int.Parse(dt.Rows[n]["Counts6"].ToString());
}
if (dt.Rows[n]["Counts7"].ToString() != "")
{
model.Counts7 = int.Parse(dt.Rows[n]["Counts7"].ToString());
}
if (dt.Rows[n]["Counts8"].ToString() != "")
{
model.Counts8 = int.Parse(dt.Rows[n]["Counts8"].ToString());
}
if (dt.Rows[n]["Area"].ToString() != "")
{
model.Area = decimal.Parse(dt.Rows[n]["Area"].ToString());
}
if (dt.Rows[n]["Area0"].ToString() != "")
{
model.Area0 = decimal.Parse(dt.Rows[n]["Area0"].ToString());
}
if (dt.Rows[n]["Area1"].ToString() != "")
{
model.Area1 = decimal.Parse(dt.Rows[n]["Area1"].ToString());
}
if (dt.Rows[n]["Area2"].ToString() != "")
{
model.Area2 = decimal.Parse(dt.Rows[n]["Area2"].ToString());
}
if (dt.Rows[n]["Area3"].ToString() != "")
{
model.Area3 = decimal.Parse(dt.Rows[n]["Area3"].ToString());
}
if (dt.Rows[n]["Area4"].ToString() != "")
{
model.Area4 = decimal.Parse(dt.Rows[n]["Area4"].ToString());
}
if (dt.Rows[n]["Area5"].ToString() != "")
{
model.Area5 = decimal.Parse(dt.Rows[n]["Area5"].ToString());
}
if (dt.Rows[n]["Area6"].ToString() != "")
{
model.Area6 = decimal.Parse(dt.Rows[n]["Area6"].ToString());
}
if (dt.Rows[n]["Area7"].ToString() != "")
{
model.Area7 = decimal.Parse(dt.Rows[n]["Area7"].ToString());
}
if (dt.Rows[n]["Area8"].ToString() != "")
{
model.Area8 = decimal.Parse(dt.Rows[n]["Area8"].ToString());
}
modelList.Add(model);
}
}
return(modelList);
}