/// <summary>
/// 根据表格返回值，查询所有展商
/// </summary>
/// <param name="table">展商表格</param>
/// <returns>展商List集合</returns>
public List <ActivityToCustomerEntity> GetActivityEntityList(DataTable table)
{
List <ActivityToCustomerEntity> list = null;
if (table != null)
{
DataRow[] drs = table.Select("ParentID = 0");
if (drs != null)
{
if (drs.Length > 0)
{
list = new List <ActivityToCustomerEntity>();
foreach (DataRow dr in drs)
{
ActivityToCustomerEntity item = this.GetActivityToCustomerEntity(dr, table);
if (item != null)
{
list.Add(item);
}
}
}
}
}
return(list);
}
/// <summary>
/// 实例化单个返回给客户的展商信息
/// </summary>
/// <param name="dr">展场信息datarow</param>
/// <param name="table">展位的表格</param>
/// <returns>展商的信息</returns>
private ActivityToCustomerEntity GetActivityToCustomerEntity(DataRow dr, DataTable table)
{
ActivityToCustomerEntity item = null;
if (dr != null)
{
item = new ActivityToCustomerEntity();
if (dr["ActivityID"] != null && dr["ActivityID"].ToString() != "")
{
item.ActivityID = int.Parse(dr["ActivityID"].ToString());
}
if (dr["ExhibitorID"] != null && dr["ExhibitorID"].ToString() != "")
{
item.ExhibitorID = int.Parse(dr["ExhibitorID"].ToString());
}
if (dr["ActivityTitle"] != null)
{
item.ActivityTitle = dr["ActivityTitle"].ToString();
}
if (dr["ActivityStartTime"] != null && dr["ActivityStartTime"].ToString() != "")
{
item.ActivityStartTime = DateTime.Parse(dr["ActivityStartTime"].ToString());
item.FormatActivityStartTime = item.ActivityStartTime.ToString("yyyy-MM-dd HH:mm:ss");
}
if (dr["ActivityEndTime"] != null && dr["ActivityEndTime"].ToString() != "")
{
item.ActivityEndTime = DateTime.Parse(dr["ActivityEndTime"].ToString());
item.FormatActivityEndTiem = item.ActivityEndTime.ToString("yyyy-MM-dd HH:mm:ss");
}
if (dr["ActivityLocation"] != null)
{
item.ActivityLocation = dr["ActivityLocation"].ToString();
}
if (dr["ActivityHostUnit"] != null)
{
item.ActivityHostUnit = dr["ActivityHostUnit"].ToString();
}
if (dr["ActivityAbstract"] != null)
{
item.ActivityAbstract = dr["ActivityAbstract"].ToString();
}
if (dr["ActivityGuest"] != null)
{
item.ActivityGuest = dr["ActivityGuest"].ToString();
}
if (dr["ExhibitorName"] != null)
{
item.ExhibitorName = dr["ExhibitorName"].ToString();
}
if (dr["ExhibitorPinYin"] != null)
{
item.ExhibitorPinYin = dr["ExhibitorPinYin"].ToString();
}
if (dr["ActivityIsEnd"] != null && dr["ActivityIsEnd"].ToString() != "")
{
item.ActivityIsEnd = int.Parse(dr["ActivityIsEnd"].ToString()) == 1;
}
if (item.ActivityStartTime != null && item.ActivityEndTime != null)
{
if (item.ActivityStartTime.DayOfYear == item.ActivityEndTime.DayOfYear)
{
item.FormatActivityTime = item.ActivityStartTime.ToString("yyyy年MM月dd日 HH:mm") + " - " + item.ActivityEndTime.ToString("HH:mm");
}
else
{
item.FormatActivityTime = item.ActivityStartTime.ToString("yyyy年MM月dd日 HH:mm") + " - " + item.ActivityEndTime.ToString("MM月dd日 HH:mm");
}
}
item.SubactivityList = new List <ActivityToCustomerEntity>();
DataRow[] drs = table.Select("ParentID = " + item.ActivityID);
if (drs != null)
{
if (drs.Length > 0)
{
foreach (DataRow drsub in drs)
{
ActivityToCustomerEntity subItem = this.GetActivityToCustomerEntity(drsub, table);
if (subItem != null)
{
item.SubactivityList.Add(subItem);
}
}
}
}
}
return(item);
}
