/// <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()); }