protected void btnSave_Click(object sender, EventArgs e)
{
bool isOk = false;
for (int i = 0; i < GridView1.Rows.Count; i++)
{
RadioButtonList rdList = (RadioButtonList)GridView1.Rows[i].FindControl("raIsVisable");
TextBox txt_Url = (TextBox)GridView1.Rows[i].FindControl("TextBox_Url");
Label lbfi_no1 = (Label)GridView1.Rows[i].FindControl("lbfi_no1");
Label lbfi_no2 = (Label)GridView1.Rows[i].FindControl("lbfi_no2");
AdminItem2Info info = ai2BLL.getAll(int.Parse(lbfi_no2.Text));
info.ai2_visible = bool.Parse(rdList.SelectedValue);
info.ai2_url = txt_Url.Text;
if (ai2BLL.Update(info.ai2_id, info) > 0)
{
isOk = true;
}
}
if (isOk == true)
{
Response.Redirect("SuperItemEditList.aspx?header=修改成功!", true);
}
else
{
Response.Redirect("SuperItemEditList.aspx?header=修改失敗!", true);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
AdminItem2Info info = new AdminItem2Info();
info.ai2_name = TextBox_Name.Text;
info.ai2_url = TextBox_Url.Text;
info.ai2_no1 = int.Parse(DropDownList_No1.SelectedValue);
info.ai2_visible = true;
ai2BLL.Insert(info);
Response.Redirect("SuperItemEditList2.aspx?id=" + id);
}
public IList <AdminItem2Info> getAllByPowerAIdWithNo1(int a_id, int ai_no2)
{
List <AdminItem2Info> infos = new List <AdminItem2Info>();
IDataReader reader = db.GetDataByPowerAIdWithNo1(a_id, ai_no2).CreateDataReader();
while (reader.Read())
{
infos.Add(AdminItem2Info.Populate(reader));
}
return(infos);
}
public AdminItem2Info getAllByPowerAIdWithNo2(int a_id, int ai2_no1)
{
AdminItem2Info info = new AdminItem2Info();
IDataReader reader = db.GetDataByPowerAIdWithNo1(a_id, ai2_no1).CreateDataReader();
while (reader.Read())
{
info = AdminItem2Info.Populate(reader);
}
return(info);
}
public AdminItem2Info getAll(int id)
{
AdminItem2Info info = new AdminItem2Info();
IDataReader reader = db.GetDataByfiNo2(id).CreateDataReader();
while (reader.Read())
{
info = AdminItem2Info.Populate(reader);
}
return(info);
}
public int InsertForSort(int ai2_no1)
{
AdminItem2Info info = new AdminItem2Info();
IDataReader reader = db.InsertForSort(ai2_no1).CreateDataReader();
if (reader.Read())
{
info = AdminItem2Info.Populate(reader);
return(info.ai2_sort + 1);
}
return(1);
}
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");
Label lbfi_no2 = (Label)e.Row.FindControl("lbfi_no2");
if (rdList != null && lbfi_no2 != null)
{
AdminItem2Info info = ai2BLL.getAll(int.Parse(lbfi_no2.Text));
rdList.SelectedValue = info.ai2_visible.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 int Update(int id, AdminItem2Info info)
{
return(db.Update(info.ai2_name, info.ai2_sort, info.ai2_visible, info.ai2_no1, info.ai2_url, info.ai2_id));
}
public int Insert(AdminItem2Info info)
{
info.ai2_sort = InsertForSort(info.ai2_no1);
return(db.Insert(info.ai2_name, info.ai2_sort, info.ai2_visible, info.ai2_no1, info.ai2_url));
}
