private void Bind() { ColumnDal dblm = new ColumnDal(); var list = dblm.FindAll(); ddllm.DataSource = list; ddllm.DataValueField = "ID"; ddllm.DataTextField = "Title"; ddllm.DataBind(); ListItem item1 = new ListItem(); item1.Text = "请选择"; item1.Value = ""; ddllm.Items.Insert(0, item1); if (Request["type"] == "Edit") { long Id = Convert.ToInt64(Request["ID"]); var item = db.Find(Id); if (item != null) { txtbt.Text = item.Title; img1.ImageUrl = item.ImgStr; txtbz.Text = item.ShortTxt; txtnr.Text = item.Content; ddllm.SelectedValue = item.CID.ToString(); } else { //找不到数据就返回列表 Response.Redirect("ColumnListPG.aspx"); } } }
private void Bind() { int pageindex = Convert.ToInt32(Request["page"]); int pagesize = Convert.ToInt32(Request["pagesize"]) == 0 ? 10 : Convert.ToInt32(Request["pagesize"]); int pagecount = 0; List <Column> list = new List <Column>(); ColumnDal db = new ColumnDal(); list = db.FindPaging(ref pagecount, pageindex, pagesize); if (list.Count == 0 && pageindex > 1) { //大于一页的最后一条被删除,页数-1 重新加载 list = db.FindPaging(ref pagecount, pageindex - 1, pagesize); } hfcount.Value = pagecount.ToString(); rptlist.DataSource = list; rptlist.DataBind(); }
public void GetColumns() { //Arrange var mockHelper = MockRepository.GenerateMock <IDalHelper>(); mockHelper.Stub(x => x.RetrieveList( Arg <DalHelperModel <ColumnModel> > .Is.Anything )).Return(new List <ColumnModel> { new ColumnModel() }); var mapperStub = MockRepository.GenerateStub <IColumnMapper>(); var columnDal = new ColumnDal(mapperStub, mockHelper); //Act var dalResponse = columnDal.GetColumns(0, _connectionString); //Assert Assert.IsFalse(dalResponse.HasError); Assert.IsNotNull(dalResponse.Result); }
//删除栏目 private void DeleteColumnById() { long Id = Convert.ToInt64(HttpContext.Current.Request["ColumnId"]); ColumnDal db = new ColumnDal(); int zlm = db.FindCountByPID(Id); ArticleDal db2 = new ArticleDal(); int z2 = db2.FindCountByCID(Id); if (zlm == 0 && z2 == 0)//是否有子栏目或者文章/产品 { if (db.Delete(Id)) { result = "OK"; } else { result = "NO"; } } else { result = "NO"; } }