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));
}
