private void GeneralFriendlyList_BindGrid() { zlzw.BLL.GeneralFriendlyLinkBLL generalFriendlyLinkBLL = new zlzw.BLL.GeneralFriendlyLinkBLL(); DataTable dt = generalFriendlyLinkBLL.GetList(grid1.PageSize, grid1.PageIndex + 1, "*", "PublishDate", 0, "desc", "CanUsable=1").Tables[0]; grid1.DataSource = dt; grid1.DataBind(); }
/// <summary> /// 获取总页数 /// </summary> /// <returns></returns> private int Get_GeneralFriendlyListTotalCount() { zlzw.BLL.GeneralFriendlyLinkBLL generalFriendlyLinkBLL = new zlzw.BLL.GeneralFriendlyLinkBLL(); DataTable dt = generalFriendlyLinkBLL.GetList("CanUsable=1").Tables[0]; if (dt.Rows.Count > 0) { return dt.Rows.Count; } else { return 0; } }
protected void btnDel_Click(object sender, EventArgs e) { if (grid1.SelectedRowIndexArray != null && grid1.SelectedRowIndexArray.Length > 0) { string strSelectID = "0"; for (int i = 0, count = grid1.SelectedRowIndexArray.Length; i < count; i++) { int rowIndex = grid1.SelectedRowIndexArray[i]; foreach (object key in grid1.DataKeys[rowIndex]) { strSelectID = key.ToString(); } } #region 删除逻辑 zlzw.BLL.GeneralFriendlyLinkBLL generalFriendlyLinkBLL = new zlzw.BLL.GeneralFriendlyLinkBLL(); DataTable dt = generalFriendlyLinkBLL.GetList("LinkGuid='" + strSelectID + "'").Tables[0]; zlzw.Model.GeneralFriendlyLinkModel generalFriendlyLinkModel = generalFriendlyLinkBLL.GetModel(int.Parse(dt.Rows[0]["LinkID"].ToString())); generalFriendlyLinkModel.CanUsable = 0; generalFriendlyLinkBLL.Update(generalFriendlyLinkModel); GeneralFriendlyList_BindGrid(); #endregion } else { return; } }
private void Load_FriendlyLinkList() { zlzw.BLL.GeneralFriendlyLinkBLL generalFriendlyLinkBLL = new zlzw.BLL.GeneralFriendlyLinkBLL(); DataTable dt = generalFriendlyLinkBLL.GetList("LinkType=0 and CanUsable=1 order by LinkOrderNumber asc").Tables[0]; for (int nCount = 0; nCount < dt.Rows.Count; nCount++) { if (nCount < 7) { labLink.Text += "<a target='_blank' style='text-decoration:none;color:#6e6e6e;' href='" + dt.Rows[nCount]["LinkTargetUrl"].ToString() + "'>" + dt.Rows[nCount]["LinkTitle"].ToString() + "</a> "; } else if (nCount > 7 && nCount <= 14) { labLink01.Text += "<a target='_blank' style='text-decoration:none;color:#6e6e6e;' href='" + dt.Rows[nCount]["LinkTargetUrl"].ToString() + "'>" + dt.Rows[nCount]["LinkTitle"].ToString() + "</a> "; } else if (nCount > 14 && nCount <= 21) { labLink02.Text += "<a target='_blank' style='text-decoration:none;color:#6e6e6e;' href='" + dt.Rows[nCount]["LinkTargetUrl"].ToString() + "'>" + dt.Rows[nCount]["LinkTitle"].ToString() + "</a> "; } else if (nCount > 21 && nCount <= 28) { labLink03.Text += "<a target='_blank' style='text-decoration:none;color:#6e6e6e;' href='" + dt.Rows[nCount]["LinkTargetUrl"].ToString() + "'>" + dt.Rows[nCount]["LinkTitle"].ToString() + "</a> "; } else if (nCount > 28 && nCount <= 35) { labLink04.Text += "<a target='_blank' style='text-decoration:none;color:#6e6e6e;' href='" + dt.Rows[nCount]["LinkTargetUrl"].ToString() + "'>" + dt.Rows[nCount]["LinkTitle"].ToString() + "</a> "; } } }