private void GeneralADList_BindGrid() { zlzw.BLL.GeneralADBLL generalADBLL = new zlzw.BLL.GeneralADBLL(); DataTable dt = generalADBLL.GetList(grid1.PageSize, grid1.PageIndex + 1, "*", "UpdateDate", 0, "desc", "CanUsable=1").Tables[0]; grid1.DataSource = dt; grid1.DataBind(); }
/// <summary> /// 获取总页数 /// </summary> /// <returns></returns> private int Get_GeneralADListTotalCount() { zlzw.BLL.GeneralADBLL generalADBLL = new zlzw.BLL.GeneralADBLL(); DataTable dt = generalADBLL.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.GeneralADBLL generalADBLL = new zlzw.BLL.GeneralADBLL(); DataTable dt = generalADBLL.GetList("ADGuid='" + strSelectID + "'").Tables[0]; zlzw.Model.GeneralADModel generalADModel = generalADBLL.GetModel(int.Parse(dt.Rows[0]["ADGuid"].ToString())); generalADModel.CanUsable = 0; generalADBLL.Update(generalADModel); GeneralADList_BindGrid(); #endregion } else { return; } }
private void Load_GeneralADList() { zlzw.BLL.GeneralADBLL generalADBLL = new zlzw.BLL.GeneralADBLL(); string strCurrent = DateTime.Now.ToString();//当前系统日期 DataTable dt = generalADBLL.GetList(10, "CanUsable=1 and ADStatus=1 and DisplayStartDate<='" + strCurrent + "' and DisplayEndDate >='"+strCurrent+"'", "ADOrderNumber asc").Tables[0]; Repeater2.DataSource = dt; Repeater2.DataBind(); }