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