private void BindDataMenu()
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "SELECT * from menuItems WITH (NOLOCK) where restaurantID=" + Request.QueryString["ID"];
cmd.CommandType = CommandType.Text;
DataSet objDS = new DataSet();
SqlDataAdapter objDA = new SqlDataAdapter();
objDA.SelectCommand = cmd;
con.Open();
objDA.Fill(objDS);
con.Close();
RepeaterMenu.DataSource = objDS;
RepeaterMenu.DataBind();
SqlCommand cmd2 = new SqlCommand();
cmd2.Connection = con;
cmd2.CommandText = "INSERT into orderDetails(restaurantID, quantity) values('" + Request.QueryString["ID"] + "')";
cmd2.CommandType = CommandType.Text;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public void BindMenu()
{
//类别
IList <lgk.Model.tb_produceType> iList = new lgk.BLL.tb_produceType().GetModelList(" ParentID=0 and IsDeleted=0");
RepeaterMenu.DataSource = iList;
RepeaterMenu.DataBind();
}
private void GetMenu()
{
if (ViewState["MenuList"] == null)
{
var list = new LogonService().GetMenuItems(SessionClass.LoginUserEntity.RoleId);
ViewState["MenuList"] = list;
RepeaterMenu.DataSource = list.Where(x => x.ParentId == 0).ToList();
RepeaterMenu.DataBind();
}
}
private void LoadData()
{
using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext())
{
Menubar_Class ClassMenubar = new Menubar_Class(db);
RepeaterMenu.DataSource = ClassMenubar.Data();
RepeaterMenu.DataBind();
RepeaterMenuDefault.DataSource = ClassMenubar.Data();
RepeaterMenuDefault.DataBind();
LoadRole();
}
}
protected void DropDownListGrupPengguna_SelectedIndexChanged(object sender, EventArgs e)
{
if (DropDownListGrupPengguna.SelectedValue != "0")
{
LoadRole(DropDownListGrupPengguna.SelectedValue.ToInt());
}
else
{
using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext())
{
Menubar_Class ClassMenubar = new Menubar_Class(db);
RepeaterMenu.DataSource = ClassMenubar.Administrator();
RepeaterMenu.DataBind();
}
}
}
private void BindDataMenu()
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "SELECT * from menuItems where restaurantID=" + Request.QueryString["ID"];
cmd.CommandType = CommandType.Text;
DataSet objDS = new DataSet();
SqlDataAdapter objDA = new SqlDataAdapter();
objDA.SelectCommand = cmd;
con.Open();
objDA.Fill(objDS);
con.Close();
RepeaterMenu.DataSource = objDS;
RepeaterMenu.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext())
{
DropDownListGrupPengguna.DataSource = db.TBGrupPenggunas.Where(item => item.IDGrupPengguna > 2).OrderBy(item => item.Nama).ToArray();
DropDownListGrupPengguna.DataTextField = "Nama";
DropDownListGrupPengguna.DataValueField = "IDGrupPengguna";
DropDownListGrupPengguna.DataBind();
Menubar_Class ClassMenubar = new Menubar_Class(db);
RepeaterMenu.DataSource = ClassMenubar.Administrator();
RepeaterMenu.DataBind();
LoadRole(DropDownListGrupPengguna.SelectedValue.ToInt());
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext())
{
Menubar_Class ClassMenubar = new Menubar_Class(db);
DropDownListGrupPengguna.DataSource = db.TBGrupPenggunas.ToArray();
DropDownListGrupPengguna.DataTextField = "Nama";
DropDownListGrupPengguna.DataValueField = "IDGrupPengguna";
DropDownListGrupPengguna.DataBind();
RepeaterMenu.DataSource = ClassMenubar.Data();
RepeaterMenu.DataBind();
PengaturanHakAkses();
}
}
}
