public AdminItem1Info getAll(int id)
{
AdminItem1Info info = new AdminItem1Info();
IDataReader reader = db.GetDataByfiNo1(id).CreateDataReader();
while (reader.Read())
{
info = AdminItem1Info.Populate(reader);
}
return(info);
}
public List <AdminItem1Info> getAll()
{
List <AdminItem1Info> infos = new List <AdminItem1Info>();
IDataReader reader = db.GetData().CreateDataReader();
while (reader.Read())
{
infos.Add(AdminItem1Info.Populate(reader));
}
return(infos);
}
public int InsertForSort()
{
AdminItem1Info info = new AdminItem1Info();
IDataReader reader = db.InsertForSort().CreateDataReader();
if (reader.Read())
{
info = AdminItem1Info.Populate(reader);
return(info.ai1_sort + 1);
}
return(1);
}
protected void Button1_Click(object sender, EventArgs e)
{
AdminItem1Info info = new AdminItem1Info();
info.ai1_name = TextBox_Name.Text;
info.ai1_nickname = txtNickname.Text;
info.ai1_visible = true;
if (ai1BLL.Insert(info) > 0)
{
ShowMessage("新增主項目: " + TextBox_Name.Text + " 成功");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
bool isOk = false;
for (int i = 0; i < GridView1.Rows.Count; i++)
{
RadioButtonList rdList = (RadioButtonList)GridView1.Rows[i].FindControl("raIsVisable");
TextBox txt_name = (TextBox)GridView1.Rows[i].FindControl("txtFi_name1");
TextBox txt_nickname = (TextBox)GridView1.Rows[i].FindControl("txtFi_nickname");
TextBox txt_sort = (TextBox)GridView1.Rows[i].FindControl("txtFi_sort1");
Label lb_fi_no1 = (Label)GridView1.Rows[i].FindControl("lbfiNo1");
AdminItem1Info info = ai1BLL.getAll(int.Parse(lb_fi_no1.Text));
info.ai1_visible = bool.Parse(rdList.SelectedValue);
info.ai1_name = txt_name.Text;
info.ai1_nickname = txt_nickname.Text;
info.ai1_sort = int.Parse(txt_sort.Text);
if (ai1BLL.Update(info.ai1_id, info) > 0)
{
isOk = true;
}
}
if (isOk == true)
{
Response.Redirect("SuperItemEditList.aspx?header=修改成功!", true);
}
else
{
Response.Redirect("SuperItemEditList.aspx?header=修改失敗!", true);
}
}
catch (Exception ex)
{
Response.Redirect("SuperItemEditList.aspx?header=" + ex.Message.ToString(), true);
}
}
public int Insert(AdminItem1Info info)
{
info.ai1_sort = InsertForSort();
return(db.Insert(info.ai1_name, info.ai1_sort, info.ai1_visible, info.ai1_nickname));
}
public int Update(int id, AdminItem1Info info)
{
return(db.Update(info.ai1_name, info.ai1_sort, info.ai1_visible, info.ai1_nickname, info.ai1_id));
}
