/// <summary>
/// 增加一条数据
/// </summary>
public void Add(MobileSoft.Model.Equipment.Tb_Equipment_Device model)
{
dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(MobileSoft.Model.Equipment.Tb_Equipment_Device model)
{
dal.Update(model);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <MobileSoft.Model.Equipment.Tb_Equipment_Device> DataTableToList(DataTable dt)
{
List <MobileSoft.Model.Equipment.Tb_Equipment_Device> modelList = new List <MobileSoft.Model.Equipment.Tb_Equipment_Device>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
MobileSoft.Model.Equipment.Tb_Equipment_Device model;
for (int n = 0; n < rowsCount; n++)
{
model = new MobileSoft.Model.Equipment.Tb_Equipment_Device();
//model.DeviceID=dt.Rows[n]["DeviceID"].ToString();
if (dt.Rows[n]["CommID"].ToString() != "")
{
model.CommID = int.Parse(dt.Rows[n]["CommID"].ToString());
}
//model.DeviceTypeID=dt.Rows[n]["DeviceTypeID"].ToString();
model.DeviceModel = dt.Rows[n]["DeviceModel"].ToString();
model.SetPlace = dt.Rows[n]["SetPlace"].ToString();
model.DeviceOrigin = dt.Rows[n]["DeviceOrigin"].ToString();
model.DevicePrice = dt.Rows[n]["DevicePrice"].ToString();
if (dt.Rows[n]["DepreciationRate"].ToString() != "")
{
model.DepreciationRate = decimal.Parse(dt.Rows[n]["DepreciationRate"].ToString());
}
if (dt.Rows[n]["DepreciationPeriod"].ToString() != "")
{
model.DepreciationPeriod = int.Parse(dt.Rows[n]["DepreciationPeriod"].ToString());
}
model.UseLife = dt.Rows[n]["UseLife"].ToString();
if (dt.Rows[n]["FactoryTime"].ToString() != "")
{
model.FactoryTime = DateTime.Parse(dt.Rows[n]["FactoryTime"].ToString());
}
model.FactoryNumber = dt.Rows[n]["FactoryNumber"].ToString();
model.ProductionStard = dt.Rows[n]["ProductionStard"].ToString();
if (dt.Rows[n]["UseTime"].ToString() != "")
{
model.UseTime = DateTime.Parse(dt.Rows[n]["UseTime"].ToString());
}
model.DeviceSign = dt.Rows[n]["DeviceSign"].ToString();
model.CardNumber = dt.Rows[n]["CardNumber"].ToString();
model.Responsible = dt.Rows[n]["Responsible"].ToString();
model.PrepareAccounts = dt.Rows[n]["PrepareAccounts"].ToString();
if (dt.Rows[n]["PrepareTime"].ToString() != "")
{
model.PrepareTime = DateTime.Parse(dt.Rows[n]["PrepareTime"].ToString());
}
model.Memo = dt.Rows[n]["Memo"].ToString();
model.MasterOutputPower = dt.Rows[n]["MasterOutputPower"].ToString();
model.MasterInputPower = dt.Rows[n]["MasterInputPower"].ToString();
model.MasterGeometry = dt.Rows[n]["MasterGeometry"].ToString();
model.MasterEnergyConsumption = dt.Rows[n]["MasterEnergyConsumption"].ToString();
model.MasterOther = dt.Rows[n]["MasterOther"].ToString();
model.MotorPower = dt.Rows[n]["MotorPower"].ToString();
model.MotorRatedVoltage = dt.Rows[n]["MotorRatedVoltage"].ToString();
model.MotorRatedCurrent = dt.Rows[n]["MotorRatedCurrent"].ToString();
model.MotorOrigin = dt.Rows[n]["MotorOrigin"].ToString();
model.MotorOther = dt.Rows[n]["MotorOther"].ToString();
model.ControlGeometry = dt.Rows[n]["ControlGeometry"].ToString();
model.ControlRatedVoltage = dt.Rows[n]["ControlRatedVoltage"].ToString();
model.ControlRatedCurrent = dt.Rows[n]["ControlRatedCurrent"].ToString();
model.ControlOrigin = dt.Rows[n]["ControlOrigin"].ToString();
model.ControlOther = dt.Rows[n]["ControlOther"].ToString();
model.FactoryInformation1 = dt.Rows[n]["FactoryInformation1"].ToString();
model.FactoryInformation2 = dt.Rows[n]["FactoryInformation2"].ToString();
model.FactoryInformation3 = dt.Rows[n]["FactoryInformation3"].ToString();
model.TestData1 = dt.Rows[n]["TestData1"].ToString();
model.TestData2 = dt.Rows[n]["TestData2"].ToString();
model.TestData3 = dt.Rows[n]["TestData3"].ToString();
model.ManuName = dt.Rows[n]["ManuName"].ToString();
model.ManuLinkMan = dt.Rows[n]["ManuLinkMan"].ToString();
model.ManuLinkTel = dt.Rows[n]["ManuLinkTel"].ToString();
model.DealerName = dt.Rows[n]["DealerName"].ToString();
model.DealerLinkMan = dt.Rows[n]["DealerLinkMan"].ToString();
model.DealerLinkTel = dt.Rows[n]["DealerLinkTel"].ToString();
model.ErectName = dt.Rows[n]["ErectName"].ToString();
model.ErectLinkMan = dt.Rows[n]["ErectLinkMan"].ToString();
model.ErectLinkTel = dt.Rows[n]["ErectLinkTel"].ToString();
if (dt.Rows[n]["IsDelete"].ToString() != "")
{
model.IsDelete = int.Parse(dt.Rows[n]["IsDelete"].ToString());
}
model.Identification = dt.Rows[n]["Identification"].ToString();
//model.GenreID=dt.Rows[n]["GenreID"].ToString();
//model.GenreUnitID=dt.Rows[n]["GenreUnitID"].ToString();
model.GenreLinkTel = dt.Rows[n]["GenreLinkTel"].ToString();
if (dt.Rows[n]["GenreStartDate"].ToString() != "")
{
model.GenreStartDate = DateTime.Parse(dt.Rows[n]["GenreStartDate"].ToString());
}
if (dt.Rows[n]["GenreCalcBeginDate"].ToString() != "")
{
model.GenreCalcBeginDate = DateTime.Parse(dt.Rows[n]["GenreCalcBeginDate"].ToString());
}
if (dt.Rows[n]["GenrePeriod"].ToString() != "")
{
model.GenrePeriod = int.Parse(dt.Rows[n]["GenrePeriod"].ToString());
}
if (dt.Rows[n]["GenreTimes"].ToString() != "")
{
model.GenreTimes = int.Parse(dt.Rows[n]["GenreTimes"].ToString());
}
if (dt.Rows[n]["FixGenreMonth1"].ToString() != "")
{
model.FixGenreMonth1 = int.Parse(dt.Rows[n]["FixGenreMonth1"].ToString());
}
if (dt.Rows[n]["FixGenreDay1"].ToString() != "")
{
model.FixGenreDay1 = int.Parse(dt.Rows[n]["FixGenreDay1"].ToString());
}
if (dt.Rows[n]["FixGenreMonth2"].ToString() != "")
{
model.FixGenreMonth2 = int.Parse(dt.Rows[n]["FixGenreMonth2"].ToString());
}
if (dt.Rows[n]["FixGenreDay2"].ToString() != "")
{
model.FixGenreDay2 = int.Parse(dt.Rows[n]["FixGenreDay2"].ToString());
}
if (dt.Rows[n]["FixGenreMonth3"].ToString() != "")
{
model.FixGenreMonth3 = int.Parse(dt.Rows[n]["FixGenreMonth3"].ToString());
}
if (dt.Rows[n]["FixGenreDay3"].ToString() != "")
{
model.FixGenreDay3 = int.Parse(dt.Rows[n]["FixGenreDay3"].ToString());
}
if (dt.Rows[n]["FixGenreMonth4"].ToString() != "")
{
model.FixGenreMonth4 = int.Parse(dt.Rows[n]["FixGenreMonth4"].ToString());
}
if (dt.Rows[n]["FixGenreDay4"].ToString() != "")
{
model.FixGenreDay4 = int.Parse(dt.Rows[n]["FixGenreDay4"].ToString());
}
model.GenreReason = dt.Rows[n]["GenreReason"].ToString();
if (dt.Rows[n]["DeviceStatus"].ToString() != "")
{
model.DeviceStatus = int.Parse(dt.Rows[n]["DeviceStatus"].ToString());
}
modelList.Add(model);
}
}
return(modelList);
}
