/// <summary>
/// 新增楼层
/// </summary>
/// <param name="cf"></param>
/// <returns></returns>
public static int InsertCommodifyFloor(SqlDbHelper dbhelper, CommodityFloor cf)
{
using (var cmd = new SqlCommand(@"INSERT INTO HuoDong..tbl_WebAct_CommodityFloors
( ActiveID,
FloorID,
FloorPicture,
FloorLink
)
VALUES (@ActiveID, @FloorID, @FloorPicture , @FloorLink)" ))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@ActiveID", cf.ActiveID);
cmd.Parameters.AddWithValue("@FloorID", cf.FloorID);
cmd.Parameters.AddWithValue("@FloorPicture ", cf.FloorPicture);
cmd.Parameters.AddWithValue("@FloorLink", cf.FloorLink);
return(dbhelper.ExecuteNonQuery(cmd));
}
}
/// <summary>
/// 获取每次活动的各种数据
/// </summary>
/// <param name="ActiveID"></param>
/// <returns></returns>
public static WebActive WebActivityDetail(string ActiveID)
{
var dt = DALWebActivityDetail.FetchWebActivityDetail(ActiveID);
if (dt == null || dt.Rows.Count <= 0)
{
return(new WebActive());
}
var Floors = new List <CommodityFloor>();
IEnumerable <OtherPart> otherpart = DALWebActivityDetail.FetchOtherPartForFloor(ActiveID).Rows.Cast <DataRow>().Select(row => new OtherPart(row));
foreach (DataRow dr in dt.Rows)
{
CommodityFloor cf = new CommodityFloor();
cf.FloorID = Convert.ToInt32(dr["FloorID"]);
cf.FloorLink = dr["FloorLink"].ToString();
cf.FloorPicture = dr["FloorPicture"].ToString();
cf.Products = DALWebActivityDetail.FetchProductsForFloor(ActiveID, cf.FloorID).Rows.Cast <DataRow>().Select(row => new Products(row));
Floors.Add(cf);
}
return(dt.Rows.Cast <DataRow>().Select(row => new WebActive()
{
CommodifyFloor = Floors.Distinct(),
PKID = Convert.ToInt32(row["PKID"]),
ActiveDescription = row["ActiveDescription"].ToString(),
ActiveID = row["ActiveID"].ToString(),
ActiveLink = row["ActiveLink"].ToString(),
ActiveName = row["ActiveName"].ToString(),
backgroundColor = row["backgroundColor"].ToString(),
Banner = row["Banner"].ToString(),
CornerMark = row["CornerMark"].ToString(),
CreateDateTime = Convert.ToDateTime(row["CreateDateTime"]),
EndDateTime = Convert.ToDateTime(row["EndDateTime"]),
StartDateTime = Convert.ToDateTime(row["StartDateTime"]),
OtherPart = otherpart
}).First());
}
