private static List <ActivityEquipment> LoadActivityEquipments(DataTable[] tables, string activityguid, string placeguid, string orgguid)
{
StringBuilder errormsg = new StringBuilder();
List <ActivityEquipment> equipments = new List <ActivityEquipment>();
//0:单位信息
//1:业务类型
for (int i = 0; i < tables.Length; i++)
{
DataTable table = tables[i];
string tablename = table.TableName;
if (tablename == "单位信息" || tablename == "业务类型")
{
continue;
}
string tabname = ExcelImportHelper.TableNameConvert(table.TableName);
string classId = ExcelImportHelper.GetEquipmentClassId(tabname);
if (!string.IsNullOrEmpty(classId))
{
List <ActivityEquipment> equs = LoadActivityEquFromTable(table, activityguid, placeguid, orgguid, classId);
equipments.AddRange(equs);
}
}
return(equipments);
}
/// <summary>
/// 创建ActivityEquipment对象
/// </summary>
/// <param name="dr"></param>
/// <param name="activityguid"></param>
/// <param name="placeguid"></param>
/// <param name="orgguid"></param>
/// <param name="classId"></param>
/// <returns></returns>
private ActivityEquipment CreateActivityEquipment(DataRow dr, string activityguid, string placeguid, string orgguid)
{
ActivityEquipment equ = new ActivityEquipment();
equ.Key = System.Guid.NewGuid().ToString();
equ.OrgInfo.Guid = orgguid;
equ.ActivityGuid = activityguid;
equ.PlaceGuid = placeguid;
equ.Name = dr["设备名称"].ToString();
equ.EquipmentClassID = ExcelImportHelper.GetEquipmentClassId(dr["业务类型"].ToString());
equ.EQUCount = Int32.Parse(dr["数量"].ToString()); //设备数量
equ.EquModel = dr["设备型号"].ToString(); //设备型号
equ.SeriesNumber = dr["设备编号"].ToString(); //设备编号
equ.IsMobile = dr["移动设备"].ToString() == "是" ? true : false; //移动设备
if (!equ.IsMobile)
{
equ.Longitude = double.Parse(dr["经度"].ToString());
equ.Latitude = double.Parse(dr["纬度"].ToString());
equ.Address = dr["地点"].ToString();
}
equ.IsStation = dr["已建站"].ToString() == "是" ? true : false;
if (equ.IsStation)
{
equ.StationName = dr["已建站名称"].ToString();
equ.StationTDI = dr["台站编号"].ToString();
}
else
{
equ.StationName = string.Empty;
equ.StationTDI = string.Empty;
}
equ.SendFreq = double.Parse(dr["发射频率(MHz)"].ToString()); //发射频率
if (string.IsNullOrWhiteSpace(dr["接收频率(MHz)"].ToString()))
{
equ.ReceiveFreq = null;//接收频率
}
else
{
equ.ReceiveFreq = double.Parse(dr["接收频率(MHz)"].ToString());//接收频率
}
if (string.IsNullOrEmpty(dr["备用频率(MHz)"].ToString()))
{
equ.SpareFreq = null;//备用频率
}
else
{
equ.SpareFreq = double.Parse(dr["备用频率(MHz)"].ToString());//接收频率
}
equ.IsTunable = dr["频率可调"].ToString() == "是" ? true : false;//频率可调
if (equ.IsTunable)
{
if (string.IsNullOrEmpty(dr["频率范围起始(MHz)"].ToString()))
{
equ.FreqRange.Little = null;//发射频率范围起始
}
else
{
equ.FreqRange.Little = double.Parse(dr["频率范围起始(MHz)"].ToString());//发射频率范围起始
}
if (string.IsNullOrEmpty(dr["频率范围终止(MHz)"].ToString()))
{
equ.FreqRange.Great = null;//发射频率范围终止
}
else
{
equ.FreqRange.Great = double.Parse(dr["频率范围终止(MHz)"].ToString());//发射频率范围终止
}
}
else
{
equ.FreqRange = new Range <double?>();
}
equ.Band_kHz = double.Parse(dr["波道带宽(kHz)"].ToString()); //必要带宽
equ.Power_W = double.Parse(dr["发射功率(W)"].ToString()); //发射功率
EMCS.Types.EMCModulationEnum modulat;
if (Enum.TryParse(dr["调制方式"].ToString(), out modulat))
{
equ.Modulation = modulat;
}
equ.Remark = dr["备注"].ToString();
return(equ);
}