protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { GridView gridView = (GridView)sender; if (gridView.SortExpression.Length > 0) { int cellIndex = -1; foreach (DataControlField field in gridView.Columns) { if (field.SortExpression == gridView.SortExpression) { cellIndex = gridView.Columns.IndexOf(field); break; } } if (cellIndex > -1) { if (e.Row.RowType == DataControlRowType.Header) { // this is a header row, // set the sort style e.Row.Cells[cellIndex].CssClass = gridView.SortDirection == SortDirection.Ascending ? "sortascheaderstyle" : "sortdescheaderstyle"; } else if (e.Row.RowType == DataControlRowType.DataRow) { // this is an alternating row e.Row.Cells[cellIndex].CssClass = e.Row.RowIndex % 2 == 0 ? "sortalternatingrowstyle" : "sortrowstyle"; } } } RadioButtonList rdList = (RadioButtonList)e.Row.FindControl("raIsVisable"); Label lbfi_no1 = (Label)e.Row.FindControl("lbfi_no1"); //修改支線新增程序: //由於最初Loading已經設定aid值 //固應視目前所有物件取值都以aid的資料為主 //所以去出Power欄位的條件,只需要ID if (rdList != null && lbfi_no1 != null) { int ap_id = int.Parse(lbfi_no1.Text); AdminPowerInfo info = apBLL.getDataByID(ap_id); if (info != null) { rdList.SelectedValue = apBLL.getDataByID(ap_id).ap_enable.ToString(); } } if (e.Row.RowType == DataControlRowType.Pager) { Label lblTotalNumberOfPages = (Label)e.Row.FindControl("lblTotalNumberOfPages"); lblTotalNumberOfPages.Text = gridView.PageCount.ToString(); TextBox txtGoToPage = (TextBox)e.Row.FindControl("txtGoToPage"); txtGoToPage.Text = (gridView.PageIndex + 1).ToString(); DropDownList ddlPageSize = (DropDownList)e.Row.FindControl("ddlPageSize"); ddlPageSize.SelectedValue = gridView.PageSize.ToString(); } }
public IList <AdminPowerInfo> getDataByaId(int aId) { List <AdminPowerInfo> infos = new List <AdminPowerInfo>(); IDataReader reader = db.GetDataByaId(aId).CreateDataReader(); while (reader.Read()) { infos.Add(AdminPowerInfo.Populate(reader)); } return(infos); }
public AdminPowerInfo getDataByID(int ap_id) { AdminPowerInfo info = new AdminPowerInfo(); IDataReader reader = db.GetDataByID(ap_id).CreateDataReader(); while (reader.Read()) { info = AdminPowerInfo.Populate(reader); } return(info); }
public AdminPowerInfo getAllaIdNo1No2(int a_id, int fi_no1, int fi_no2) { AdminPowerInfo info = new AdminPowerInfo(); IDataReader reader = db.GetDataByaIdNo1No2(a_id, fi_no1, fi_no2).CreateDataReader(); while (reader.Read()) { info = AdminPowerInfo.Populate(reader); } return(info); }
protected void btSave_Click(object sender, EventArgs e) { //先刪除全部權限,在新增新的權限 apBLL.DeleteByaId(id); bool isOk = false; for (int i = 0; i < GridView1.Rows.Count; i++) { RadioButtonList rdList = (RadioButtonList)GridView1.Rows[i].FindControl("raIsVisable"); Label lbfi_no1 = (Label)GridView1.Rows[i].FindControl("lbfi_no1"); Label lbfi_no2 = (Label)GridView1.Rows[i].FindControl("lbfi_no2"); if (rdList != null && lbfi_no1 != null && lbfi_no2 != null) { int fi_no1 = int.Parse(lbfi_no1.Text); int fi_no2 = int.Parse(lbfi_no2.Text); AdminPowerInfo info = new AdminPowerInfo(); info.ap_no1 = fi_no1; info.ap_id = id; info.ap_no2 = fi_no2; info.ap_aid = id; info.ap_enable = bool.Parse(rdList.SelectedValue); if (apBLL.Insert(info) > 0) { isOk = true; } } } if (isOk == true) { Response.Redirect("List.aspx?header=修改成功!", true); } else { Response.Redirect("List.aspx?header=修改失敗!", true); } }
public int Insert(AdminPowerInfo info) { return(db.Insert(info.ap_no1, info.ap_no2, info.ap_aid, info.ap_enable)); }