/// <summary> /// 得到一个对象实体 /// </summary> public Model.Adert DataRowToModel(DataRow row) { Model.Adert model = new Model.Adert(); if (row != null) { if (row["a_ID"] != null && row["a_ID"].ToString() != "") { model.a_ID = int.Parse(row["a_ID"].ToString()); } if (row["a_PID"] != null && row["a_PID"].ToString() != "") { model.a_PID = int.Parse(row["a_PID"].ToString()); } if (row["a_Title"] != null) { model.a_Title = row["a_Title"].ToString(); } if (row["a_Link"] != null) { model.a_Link = row["a_Link"].ToString(); } if (row["a_Image"] != null) { model.a_Image = row["a_Image"].ToString(); } if (row["a_Sorting"] != null && row["a_Sorting"].ToString() != "") { model.a_Sorting = int.Parse(row["a_Sorting"].ToString()); } if (row["a_IsTop"] != null && row["a_IsTop"].ToString() != "") { model.a_IsTop = int.Parse(row["a_IsTop"].ToString()); } if (row["a_CreateDate"] != null && row["a_CreateDate"].ToString() != "") { model.a_CreateDate = DateTime.Parse(row["a_CreateDate"].ToString()); } if (row["a_CreateUser"] != null && row["a_CreateUser"].ToString() != "") { model.a_CreateUser = new Guid(row["a_CreateUser"].ToString()); } if (row["a_Status"] != null && row["a_Status"].ToString() != "") { model.a_Status = int.Parse(row["a_Status"].ToString()); } if (row["a_Delete"] != null && row["a_Delete"].ToString() != "") { model.a_Delete = int.Parse(row["a_Delete"].ToString()); } if (row["a_spare1"] != null) { model.a_spare1 = row["a_spare1"].ToString(); } if (row["a_spare2"] != null && row["a_spare2"].ToString() != "") { model.a_spare2 = int.Parse(row["a_spare2"].ToString()); } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.Adert GetModel(int a_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 a_ID,a_PID,a_Title,a_Link,a_Image,a_Sorting,a_IsTop,a_CreateDate,a_CreateUser,a_Status,a_Delete,a_spare1,a_spare2 from Adert "); strSql.Append(" where a_ID=@a_ID"); SqlParameter[] parameters = { new SqlParameter("@a_ID", SqlDbType.Int,4) }; parameters[0].Value = a_ID; Model.Adert model = new Model.Adert(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }
/// <summary> /// 品牌推广 /// </summary> /// <returns></returns> public object GetBrandBaseAdert() { var brandBig = GetAdertsFormServer("BrandBase", 33) as List<Model.Adert>; var brandsmall = GetAdertsFormServer("BrandBaseSpan", 35) as List<Model.Adert>; if (!brandBig.Any() && !brandsmall.Any()) {//都没有数据 ViewData["BrandBase"] = ""; ViewData["BrandBaseSpan"] = ""; } else { int bigCount = brandBig.Count; int smallCount = brandsmall.Count; int bigPage = bigCount / 3 + (bigCount % 3 == 0 ? 0 : 1); int smallPage = smallCount / 4 + (bigCount % 4 == 0 ? 0 : 1); int page = bigPage > smallPage ? bigPage : smallPage; Model.Adert adertBig = new Model.Adert (); adertBig.a_Link = "/Index/Index"; adertBig.a_Image = "/images/brand/brand_01.jpg"; while (bigCount / 3 != page) { brandBig.Add(adertBig); bigCount++; } Model.Adert adertSmall = new Model.Adert(); adertSmall.a_Link = "/Index/Index"; adertSmall.a_Image = "/images/brand/brand_03.jpg"; while (smallCount / 4 != page) { brandsmall.Add(adertSmall); smallCount++; } //广告 StringBuilder brandStr = new StringBuilder(); StringBuilder brandSpan = new StringBuilder(); //组合 for (int i = 0; i < page; i++) { brandStr.AppendFormat("<li>"); brandStr.AppendFormat("<a href='{0}' target='_blank' class='brand-pos1'><img name='page_cnt_1' src='{1}' /></a>", brandBig[i * 3 + 0].a_Link, brandBig[i * 3 + 0].a_Image); brandStr.AppendFormat("<a href='{0}' target='_blank' class='brand-pos2'><img name='page_cnt_1' src='{1}' /></a>", brandsmall[i * 4 + 0].a_Link, brandsmall[i * 4 + 0].a_Image); brandStr.AppendFormat("<a href='{0}' target='_blank' class='brand-pos3'><img name='page_cnt_1' src='{1}' /></a>", brandsmall[i * 4 + 1].a_Link, brandsmall[i * 4 + 1].a_Image); brandStr.AppendFormat("<a href='{0}' target='_blank' class='brand-pos4'><img name='page_cnt_1' src='{1}' /></a>", brandBig[i * 3 + 1].a_Link, brandBig[i * 3 + 1].a_Image); brandStr.AppendFormat("<a href='{0}' target='_blank' class='brand-pos5'><img name='page_cnt_1' src='{1}' /></a>", brandsmall[i * 4 + 2].a_Link, brandsmall[i * 4 + 2].a_Image); brandStr.AppendFormat("<a href='{0}' target='_blank' class='brand-pos6'><img name='page_cnt_1' src='{1}' /></a>", brandsmall[i * 4 + 3].a_Link, brandsmall[i * 4 + 3].a_Image); brandStr.AppendFormat("<a href='{0}' target='_blank' class='brand-pos7'><img name='page_cnt_1' src='{1}' /></a>", brandBig[i * 3 + 2].a_Link, brandBig[i * 3 + 2].a_Image); brandStr.AppendFormat("</li>"); brandSpan.AppendFormat("<span>{0}</span>", i + 1); } ViewData["BrandBase"] = brandStr.ToString(); ViewData["BrandBaseSpan"] = brandSpan.ToString(); } return ViewData["BrandBase"]; }