/// <summary>
/// 设备对象行转换为model
/// </summary>
/// <param name="dataRow"></param>
/// <returns></returns>
private AMS_Device DataRowToDeviceModel(DataRow dataRow)
{
try
{
string tempDate = "";
AMS_Device model = new AMS_Device();
model.CampusId = int.Parse(dataRow["CampusId"].ToString().Trim());
model.CaputrePath = dataRow["CaputrePath"].ToString().Trim();
tempDate = dataRow["CaputreTime"].ToString().Trim();
if (!string.IsNullOrEmpty(tempDate))
{
model.CaputreTime = DateTime.Parse(tempDate);
}
model.Describe = dataRow["Describe"].ToString().Trim();
tempDate = dataRow["DeviceType"].ToString().Trim();
if (!string.IsNullOrEmpty(tempDate))
{
model.DeviceType = int.Parse(tempDate);
}
model.Flag = SeatManage.SeatManageComm.SeatComm.ConvertToBoolen(dataRow["Flag"].ToString().Trim());
model.Id = int.Parse(dataRow["Id"].ToString().Trim());
model.IsDel = SeatManage.SeatManageComm.SeatComm.ConvertToBoolen(dataRow["IsDel"].ToString().Trim());
model.Number = dataRow["Number"].ToString().Trim();
return(model);
}
catch (Exception ex)
{
throw ex;
}
}
public string AddDevice(Model.AMS_Device model)
{
try
{
AMS_Device device = dal_device.GetModel(string.Format(" Number='{0}'", model.Number));
if (device != null)
{
return("添加失败，设备编号已存在");
}
else
{
dal_device.Add(model);
return("");
}
}
catch (Exception ex)
{
throw new Exception(string.Format("添加设备信息失败：{0}", ex.Message));
}
}
public List <Model.AMS_ProvinceSchoolInfo> GetSchoolList()
{
try
{
List <AMS_ProvinceSchoolInfo> modelList = new List <AMS_ProvinceSchoolInfo>();
List <AMS_Province> pList = new List <AMS_Province>();
List <AMS_School> schoolList = new List <AMS_School>();
List <AMS_Campus> campusList = new List <AMS_Campus>();
List <AMS_Device> deviceList = new List <AMS_Device>();
//获取设备信息
DataSet deviceDs = dal_device.GetList("");
for (int i = 0; i < deviceDs.Tables[0].Rows.Count; i++)
{
AMS_Device model = DataRowToDeviceModel(deviceDs.Tables[0].Rows[i]);
deviceList.Add(model);
}
//获取校区信息
DataSet campusDs = dal_campus.GetList("");
for (int i = 0; i < campusDs.Tables[0].Rows.Count; i++)
{
AMS_Campus model = DataRowToCampus(campusDs.Tables[0].Rows[i]);
//遍历设备列表中所有的设备，判断所属校区Id是否为当前处理的校区Id，
//如果是就添加到校区的设备列表中，并从当前列表中移除
for (int j = 0; j < deviceList.Count;)
{
AMS_Device d = deviceList[j];
if (d.CampusId == model.Id)
{
model.Device.Add(d);
deviceList.RemoveAt(j);//如果该项符合条件，则删除，j不增加
}
else
{//如果该项不符合条件，则j+1
j++;
}
}
campusList.Add(model);
}
//获取学校信息,并把校区添加到对应的学校中
DataSet schoolDs = dal_School.GetList("");
for (int i = 0; i < schoolDs.Tables[0].Rows.Count; i++)
{
AMS_School schoolModel = DataRowToSchoolModel(schoolDs.Tables[0].Rows[i]);
for (int j = 0; j < campusList.Count;)
{
AMS_Campus c = campusList[j];
if (c.SchoolId == schoolModel.Id)
{
schoolModel.Campus.Add(c);
campusList.RemoveAt(j);
}
else
{
j++;
}
}
schoolList.Add(schoolModel);
}
//获取省份信息
DataSet provinceDs = dal_Province.GetList(null);
for (int i = 0; i < provinceDs.Tables[0].Rows.Count; i++)
{
AMS_Province pModel = DataRowToAMS_ProvinceModel(provinceDs.Tables[0].Rows[i]);//转换省份信息。
AMS_ProvinceSchoolInfo psi = new AMS_ProvinceSchoolInfo();
psi.ID = pModel.ID;
psi.ProvinceName = pModel.ProvinceName;
psi.Remark = pModel.Remark;
for (int j = 0; j < schoolList.Count;)
{
AMS_School s = schoolList[j];
if (s.ProvinceID == psi.ID)
{
psi.Schools.Add(s);
schoolList.RemoveAt(j);
}
else
{
j++;
}
}
modelList.Add(psi);
}
return(modelList);
}
catch (Exception ex)
{
throw ex;
}
}
