/// <summary> /// 获取数据库中该角色全部的权限菜单 /// </summary> /// <returns></returns> public List <Model.Menu> GetList(int RoleId) { List <Model.Menu> list = new List <Model.Menu>(); SqlConnection co = SQLSeverOpen(); SqlCommand cmd = new SqlCommand(); cmd.Connection = co; cmd.CommandText = "select * from V_Role_Menu where roleId = " + RoleId; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Model.Menu menu = new Model.Menu(); menu.Id = Convert.ToInt32(reader["Id"]); menu.Controller = Convert.ToString(reader["Controller"]); menu.Action = Convert.ToString(reader["Action"]); menu.Display = Convert.ToString(reader["Display"]); menu.Type = Convert.ToInt32(reader["Type"]); menu.ParentId = Convert.ToInt32(reader["ParentId"]); list.Add(menu); } reader.Close(); co.Close(); return(list); }
private void listBox1_Click(object sender, EventArgs e) { MenuBusinessLogic menuBusinessLogic = new MenuBusinessLogic(); int index = listBox1.SelectedIndex; if (listBox1.SelectedIndex != -1) { string menuname = listBox1.SelectedItem.ToString(); Model.Menu menu = menuBusinessLogic.GetMenuByName(menuname); dgvOrderCheck.Rows[cellRowIndex].Cells[3].Value = menuname; dgvOrderCheck.Rows[cellRowIndex].Cells[4].Value = menu.Unit; dgvOrderCheck.Rows[cellRowIndex].Cells[5].Value = menu.MenuQuote; dgvOrderCheck.Rows[cellRowIndex].Cells[6].Value = menu.MenuRate; dgvOrderCheck.Rows[cellRowIndex].Cells[7].Value = menu.MenuPrice; } if (dgvOrderCheck.Rows[cellRowIndex].Cells[8].Value != null && dgvOrderCheck.Rows[cellRowIndex].Cells[8].Value.ToString() != "") { string a = dgvOrderCheck.Rows[cellRowIndex].Cells[8].Value.ToString(); Console.Write(dgvOrderCheck.Rows[cellRowIndex].Cells[8].Value); double count = Convert.ToDouble(dgvOrderCheck.Rows[cellRowIndex].Cells[8].Value); double price = Convert.ToDouble(dgvOrderCheck.Rows[cellRowIndex].Cells[7].Value); double money = count * price; dgvOrderCheck.Rows[cellRowIndex].Cells[9].Value = money; computertotalMoney(); } this.listBox1.DataSource = null; listBox1.Visible = false; }
//管理员添加新菜 public bool addFood(Model.Menu m) { bool flag = false; IDataParameter[] parameter = { new SqlParameter("@foodno", SqlDbType.Int), new SqlParameter("@foodname", SqlDbType.VarChar, 50), new SqlParameter("@foodprice", SqlDbType.Int), new SqlParameter("@foodimage", SqlDbType.VarChar, 50) }; parameter[0].Value = m.Foodno; parameter[1].Value = m.Foodname; parameter[2].Value = m.Foodprice; parameter[3].Value = m.FoodImage; pr.ExcutePro("addFood", parameter); //string SQL = "insert into [menu](foodno,foodname,foodprice,foodimage)values('"+m.Foodno+"','"+m.Foodname+"','"+m.Foodprice+"','"+m.FoodImage+"')"; //db.SQLExecute(SQL); flag = true; return(flag); //bool flag = false; //string SQL = "insert into [menu](foodno,foodname,foodprice,foodimage)values('"+m.Foodno+"','"+m.Foodname+"','"+m.Foodprice+"','"+m.FoodImage+"')"; //db.SQLExecute(SQL); //flag = true; //return flag; }
public async Task SaveTableItemAsync(Model.Menu item, bool isNewItem = false) { try { var json = JsonConvert.SerializeObject(item); var content = new StringContent(json, Encoding.UTF8, "application/json"); HttpResponseMessage response = null; if (isNewItem) { var uri = new Uri("https://postalwebapi.azurewebsites.net/api/Menus"); response = await client.PostAsync(uri, content); } else { var uri = new Uri($"https://postalwebapi.azurewebsites.net/api/Menus/{item.Id}"); response = await client.PutAsync(uri, content); } if (response.IsSuccessStatusCode) { } } catch (Exception ex) { } }
protected void rptMenu_ItemCommand(object source, RepeaterCommandEventArgs e) { HiddenField hidid = (HiddenField)e.Item.FindControl("hidid"); int menu_id = Convert.ToInt32(hidid.Value); if (e.CommandName == "delete") { DataTable dt = menubll.GetList("parent_id =" + menu_id).Tables[0]; if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { //删除图片(子菜单) File.Delete(Server.MapPath(dt.Rows[i]["imgurl"].ToString())); //删除数据 menubll.Delete(Convert.ToInt32(dt.Rows[i]["menu_id"].ToString())); } } //删除图片 Model.Menu model = menubll.GetModel(menu_id); File.Delete(Server.MapPath(model.imgurl)); //删除数据 menubll.Delete(menu_id); } if (e.CommandName == "look") { ViewState["pid"] = e.CommandArgument; } buildGrid(pageSize, Pager.CurrentPageIndex); }
private void listBox1_Click(object sender, EventArgs e) { MenuBusinessLogic menuBusinessLogic = new MenuBusinessLogic(); int index = listBox1.SelectedIndex; if (listBox1.SelectedIndex != -1) { string menuname = listBox1.SelectedItem.ToString(); Model.Menu menu = menuBusinessLogic.GetMenuByName(menuname); dataGridView1.Rows[cellRowIndex].Cells[0].Value = menuname; dataGridView1.Rows[cellRowIndex].Cells[2].Value = menu.Unit; dataGridView1.Rows[cellRowIndex].Cells[4].Value = menu.MenuQuote; dataGridView1.Rows[cellRowIndex].Cells[5].Value = menu.MenuRate; dataGridView1.Rows[cellRowIndex].Cells[6].Value = menu.MenuPrice; } if (dataGridView1.Rows[cellRowIndex].Cells[3].Value != null) { double totalMoney = 0; double count = Convert.ToDouble(dataGridView1.Rows[cellRowIndex].Cells[3].Value); double price = Convert.ToDouble(dataGridView1.Rows[cellRowIndex].Cells[6].Value); double money = count * price; dataGridView1.Rows[cellRowIndex].Cells[7].Value = money; for (int i = 0; i < dataGridView1.Rows.Count - 1; i++) { if (dataGridView1.Rows[i].Cells[7].Value != null) { money = Convert.ToDouble(dataGridView1.Rows[i].Cells[7].Value); totalMoney += money; } } this.dataGridView1.Rows[this.dataGridView1.Rows.Count - 1].Cells[7].Value = totalMoney.ToString(); } this.listBox1.DataSource = null; listBox1.Visible = false; }
protected void btnSubmit_Click(object sender, EventArgs e) { int _RowEffects = 0; Model.Menu model = new Model.Menu(); model = bll.GetModel(this.id, -1, -1, -1, 1, 1); model.MenuName = txtMenuName.Text.Trim(); model.MenuUrl = txtMenuUrl.Text.Trim(); model.ParentId = Convert.ToInt16(ddlParent.SelectedValue); model.Lang = Convert.ToInt16(ddlLang.SelectedValue); model.MenuStatus = Convert.ToInt16(rbMenuStatus.SelectedValue); model.MenuOrder = Convert.ToInt16(txtMenuOrder.Text.Trim()); model.ShowFooter = Convert.ToInt16(rbShowFooter.SelectedValue); bll.Update(model, ref _RowEffects); if (_RowEffects > 0) { JscriptMsg(_RowEffects.ToString(), "List.aspx", "Success"); //reload menu in memory bll.LoadMenuHeaderFooter(); } else { JscriptMsg(_RowEffects.ToString(), "", "Error"); } }
//--------------------------------Facade Menu-----------------------------------------------// public static List <Model.Menu> GetSearchMenu(string lRoleID, string lType) { List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter() { ParameterName = "@RoleID", SqlDbType = SqlDbType.NVarChar, Value = lRoleID }, new SqlParameter() { ParameterName = "@Type", SqlDbType = SqlDbType.NVarChar, Value = lType }, }; DataTable dtMenu = DataFacade.DTSQLCommand("SELECT a.MenuUrl,a.MenuName FROM menu a INNER JOIN AccessRole b ON a.MenuID = b.MenuID WHERE b.RoleID = @RoleID AND b.IsAccess = 1 AND a.Type = @Type;", sp); var mdlMenuList = new List <Model.Menu>(); foreach (DataRow row in dtMenu.Rows) { var mdlMenu = new Model.Menu(); mdlMenu.MenuUrl = row["MenuUrl"].ToString(); mdlMenu.MenuName = row["MenuName"].ToString(); mdlMenuList.Add(mdlMenu); } return(mdlMenuList); }
public static List <Model.Menu> GetAccessMobileMenu(string lRoleID, string lIsAccess) { List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter() { ParameterName = "@RoleID", SqlDbType = SqlDbType.NVarChar, Value = lRoleID }, new SqlParameter() { ParameterName = "@IsAccess", SqlDbType = SqlDbType.NVarChar, Value = Convert.ToBoolean(lIsAccess) }, }; DataTable dtAccess = DataFacade.DTSQLCommand(@"SELECT a.RoleID,b.ModuleID,b.ModuleType FROM AccessRoleMobile a INNER JOIN MenuMobile b ON a.MenuID = b.ModuleID WHERE a.RoleID = @RoleID AND IsActive = 1", sp); var mdlMenuList = new List <Model.Menu>(); foreach (DataRow row in dtAccess.Rows) { var mdlMenu = new Model.Menu(); mdlMenu.MenuID = row["ModuleID"].ToString(); mdlMenu.MenuName = row["ModuleID"].ToString(); mdlMenuList.Add(mdlMenu); } return(mdlMenuList); }
public static List <Model.Menu> GetAccessMenu(string lRoleID, string lIsAccess) { List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter() { ParameterName = "@RoleID", SqlDbType = SqlDbType.NVarChar, Value = lRoleID }, new SqlParameter() { ParameterName = "@IsAccess", SqlDbType = SqlDbType.NVarChar, Value = Convert.ToBoolean(lIsAccess) }, }; DataTable dtAccess = DataFacade.DTSQLCommand(@"SELECT MenuID,MenuName FROM Menu WHERE MenuID IN (SELECT MenuID FROM AccessRole WHERE RoleID = @RoleID AND IsAccess = @IsAccess AND MenuID LIKE 'M%')", sp); var mdlMenuList = new List <Model.Menu>(); foreach (DataRow row in dtAccess.Rows) { var mdlMenu = new Model.Menu(); mdlMenu.MenuID = row["MenuID"].ToString(); mdlMenu.MenuName = row["MenuName"].ToString(); mdlMenuList.Add(mdlMenu); } return(mdlMenuList); }
public WPFUserInterface() { Debug.WriteLine("WPFUserInterface"); loginScreen = new LoginScreen(); menuScreen = new HomeScreen(); MyMenu = Model.Menu.Instance; }
public bool Add(Model.Menu entity) { Menu m = new Menu() { IsEnable = true }; string insert = SqlCmdHelper.GenerateInsertSql <Menu>();// m.InserSql(); return(CommonRepository.ExtInsert <Menu>(insert, SqlConnString, entity)); }
public WPFUserInterface() { Debug.WriteLine("WPFUserInterface"); loginScreen = new LoginScreen(); menuScreen = new HomeScreen(); mainView = new MainView(); otherView = new OtherView(); recordView = new RecordView(); MyMenu = Model.Menu.Instance; }
public UpdataMenuForm(string MenuID) { InitializeComponent(); menuBusinessLogic = new MenuBusinessLogic(); menu = menuBusinessLogic.GetMenuByID(MenuID); txbMenuName.Text = menu.MenuName; txbUint.Text = menu.Unit; txbQuote.Text = menu.MenuQuote.ToString(); txbRate.Text = menu.MenuRate.ToString(); txbInputDate.Text = menu.InputDate.ToString(); }
public static Area construiract(Model.Menu nueva, string usuarioId) { try { Model.UnitOfWork.UnitOfWork uow = new Model.UnitOfWork.UnitOfWork(); Area area = new Area(); area.id = nueva.MenuId.ToString(); area.text = nueva.NombreMenu; area.parent = nueva.MenuPadreId == null ? "#" : nueva.MenuPadreId.ToString(); int iduser = int.Parse(usuarioId); int idar = int.Parse(area.id); var usuario = uow.MenuUsuarioRepository.GetBy(x => x.IdUsuario == iduser && x.IdMenu == idar); int contar = 0; if (usuario.Count > 0) { int menuid = usuario[0].IdMenu != null?Int32.Parse(usuario[0].IdMenu.ToString()) : 0; var usuario1 = uow.MenuRepository.GetBy(x => x.MenuPadreId == menuid); contar = usuario1.Count; } state st = new state(); if (usuario.Count > 0) { if (area.parent == "#" && contar > 0) { //st.opened = "True"; st.selected = null; } else { st.selected = "True"; } } else { st.selected = null; //st.opened = null; //st.disabled = null; } st.loaded = "True"; st.opened = "True"; area.state = st; return(area); } catch (Exception e) { _Log.Error("[ System ] " + " [ Page ] " + "[ Areas ] [ construiract ] [ Fin ]", e); return(new Area { }); } }
protected void btn_save_Click(object sender, EventArgs e) { try { Model.Menu model = new Model.Menu(); model.title = this.txttitle.Text.Trim(); model.parent_id = Convert.ToInt32(this.drpMenu.SelectedValue); model.url = this.txturl.Text.Trim(); if (this.UpIcon.PostedFile.FileName != "") { if (Upload("MenuIcon", "filetype", UpIcon, labmenuname)) { model.imgurl = "/Upload/MenuIcon/" + guid + Path.GetExtension(UpIcon.PostedFile.FileName).ToLower(); } else { this.labmenuname.Text = "文件上传失败!"; return; } } else { model.imgurl = ""; } if (this.txtsort.Text.Trim() != null && this.txtsort.Text.Trim() != "") { if (fornumber(this.txtsort)) { model.sortId = Convert.ToInt32(this.txtsort.Text.Trim()); } else { this.labsort.Text = "请输入有效的信息!"; return; } } else { model.sortId = 0; } model.isable = this.radable.SelectedValue == "1" ? true : false; if (menubll.Add(model) != 0) { ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript' defer>alert('提交成功');parent.Window_Close();</script>"); } } catch { Maticsoft.Common.MessageBox.ShowAndRedirect(this, "系统繁忙,请稍后再试!", ""); } }
//管理员删除菜 public void DeleteFood(Model.Menu m) { IDataParameter[] parameter = { new SqlParameter("@foodno", SqlDbType.Int) }; parameter[0].Value = m.Foodno; pr.ExcutePro("DeleteFood", parameter); /*---------------------------------------------------------------------------------------------------------*/ //string SQL = "delete from [menu] where foodno='" + m.Foodno + "'"; //db.SQLExecute(SQL); }
public Index(Controller.Index index = null) { if (index == null) { Cin = new View.ConsoleIn(); Cout = new View.ConsoleOut(); MemberCatalog = new Model.MemberCatalog(); MemberCatalog.Create(); IMenus = new List<View.IMenu>(); ModelMenus = new List<Model.Menu>(); MenuBoat = new Model.Menu(); // Default Setup! MenuMain = new Model.Menu(true); MenuMain.State = Model.Menu.MainMenu.MenuMain; MenuMember = new Model.Menu(); MenuQuit = new Model.Menu(); MenuSave = new Model.Menu(); // For easier resetting from index. ViewMenuMain = new View.MenuMain(Cin, Cout, MenuMain); ViewMenuMember = new View.MenuMember(Cin, Cout, MenuMember); ViewMenuBoat = new View.MenuBoat(Cin, Cout, MenuBoat); ViewMenuQuit = new View.MenuQuit(Cin, Cout, MenuBoat); ViewMenuSave = new View.MenuSave(Cin, Cout, MenuBoat); IMenus.Add(ViewMenuBoat); IMenus.Add(ViewMenuMain); IMenus.Add(ViewMenuMember); IMenus.Add(ViewMenuQuit); IMenus.Add(ViewMenuSave); FileDal = new WS_2_NYAST.MODEL.ToFileDAL(); } else { this.Cin = index.Cin; this.Cout = index.Cout; this.MemberCatalog = index.MemberCatalog; this.IMenus = index.IMenus; this.ModelMenus = index.ModelMenus; this.MenuBoat = index.MenuBoat; this.MenuMain = index.MenuMain; this.MenuMember = index.MenuMember; this.MenuQuit = index.MenuQuit; this.MenuSave = index.MenuSave; this.ViewMenuMain = index.ViewMenuMain; this.ViewMenuMember = index.ViewMenuMember; this.ViewMenuBoat = index.ViewMenuBoat; this.ViewMenuQuit = index.ViewMenuQuit; this.ViewMenuSave = index.ViewMenuSave; this.IMenus = index.IMenus; this.FileDal = index.FileDal; } }
private void btnOk_Click(object sender, EventArgs e) { { if (textBox1.Text != "" && textBox2.Text != "") { string ban = ""; if (comboBox1.Text == "Bàn số 1") { ban = "TB1"; } else if (comboBox1.Text == "Bàn số 2") { ban = "TB2"; } else if (comboBox1.Text == "Bàn số 3") { ban = "TB3"; } else if (comboBox1.Text == "Bàn số 4") { ban = "TB4"; } else if (comboBox1.Text == "Bàn số 5") { ban = "TB5"; } else if (comboBox1.Text == "Bàn số 6") { ban = "TB6"; } var rs = new Model.Menu() { Food = comboBox2.Text, QuantityofFood = int.Parse(textBox1.Text), PriceofFood = int.Parse(textBox3.Text), Drink = comboBox3.Text, QuantityofDrink = int.Parse(textBox2.Text), PriceofDrink = int.Parse(textBox4.Text), Total = int.Parse(textBox5.Text), ID_Table = ban, }; db.Menu.Add(rs); db.SaveChanges(); this.Close(); } else { MessageBox.Show("Chưa nhập số lượng"); } } }
public ActionResult Edit(Model.Menu Menu) { ViewData["deptSelectItems"] = GetdeptSelectItems(); Business.Sys_Menu Sys_Menu = new Business.Sys_Menu(); Menu.Terminal = Request["deptSelectItems"]; if (Sys_Menu.EditMenu(Menu)) { Response.Write("<script>parent.layer.alert('修改成功!');</script>"); } else { Response.Write("<script>parent.layer.alert('修改失败!');</script>"); } return(View()); }
public bool EditMenu(Model.Menu Menu) { const string sql = @"UPDATE Menu SET MenuCode=@MenuCode,MenuName=@MenuName,UrlPath=@UrlPath,OrderBy=@OrderBy,Hierarchy=@Hierarchy,SuperiorMenuID=@SuperiorMenuID,Terminal=@Terminal WHERE ID=@id"; return(Factory.DBHelper.ExecSQL(SQLConString, sql.ToString(), new DynamicParameters(new { Menu.MenuCode, Menu.MenuName, Menu.UrlPath, Menu.OrderBy, Menu.Hierarchy, Menu.SuperiorMenuID, Menu.Terminal, Menu.id }))); }
private void btnUpdate_Click(object sender, EventArgs e) { string name = txtname.Text; decimal price = Convert.ToDecimal(txtPrice.Text); Model.Menu menu = new Model.Menu(); menu.name = name; menu.price = price; int us = new MenuManager().updatemenu(menu); if (us > 0) { // MessageBox.Show("1"); Menu_Load(null, null); } }
public bool InsertMenu(Model.Menu Menu) { const string sql = @"INSERT INTO Menu(MenuCode,MenuName,UrlPath,OrderBy,Hierarchy,SuperiorMenuID,Terminal) VALUES(@MenuCode,@MenuName,@UrlPath,@OrderBy,@Hierarchy,@SuperiorMenuID,@Terminal)"; return(Factory.DBHelper.ExecSQL(SQLConString, sql.ToString(), new DynamicParameters(new { Menu.MenuCode, Menu.MenuName, Menu.UrlPath, Menu.OrderBy, Menu.Hierarchy, Menu.SuperiorMenuID, Menu.Terminal }))); }
private void BindMenu(int menu_id) { if (menu_id != 0) { Model.Menu model = menubll.GetModel(menu_id); if (model != null) { this.txttitle.Text = model.title; this.txtsort.Text = model.sortId.ToString(); this.txturl.Text = model.url; this.drpMenu.SelectedValue = model.parent_id.ToString(); ViewState["imgurl"] = model.imgurl; this.radable.SelectedValue = model.isable == true ? "1" : "0"; } } }
private void ShowInfo() { Model.Menu model = new Model.Menu(); model = bll.GetModel(this.id, -1, -1, -1, 1, 1); if (null != model && model.MenuId > 0) { txtMenuName.Text = model.MenuName; txtMenuUrl.Text = model.MenuUrl; ddlParent.SelectedValue = model.ParentId.ToString(); ddlLang.SelectedValue = model.Lang.ToString(); rbMenuStatus.SelectedValue = model.MenuStatus.ToString(); txtMenuOrder.Text = model.MenuOrder.ToString(); rbShowFooter.SelectedValue = model.ShowFooter.ToString(); } }
public static Area construir(Model.Menu nueva) { try { Area area = new Area(); area.id = nueva.MenuId.ToString(); area.text = nueva.NombreMenu; area.parent = nueva.MenuPadreId == null ? "#" : nueva.MenuPadreId.ToString(); state st = new state(); st.loaded = "True"; st.opened = "True"; area.state = st; return(area); } catch (Exception e) { _Log.Error("[ System ] " + " [ Page ] " + "[ Areas ] [ construir ] [ Fin ]", e); return(new Area { }); } }
//搜索menu表显示在网页上 public DataTable searchMenu(Model.Menu m) { DataTable dt = new DataTable(); IDataParameter[] parameter = { }; dt = pr.GetDataTable("searchMenu", parameter); //string SQL = "select * from [menu]"; //dt = db.SQLGetDataTable(SQL); return(dt); /*---------------------------------------------------------------------------------------------------------*/ //DataTable dt = new DataTable(); //string SQL = "select * from [menu]"; //dt = db.SQLGetDataTable(SQL); //return dt; }
//根据搜索条件显示表格 public DataTable point_searchMenu(Model.Menu m) { DataTable dt = new DataTable(); IDataParameter[] parameter = { new SqlParameter("@foodname", SqlDbType.VarChar, 50) }; parameter[0].Value = m.Foodname; dt = pr.GetDataTable("point_searchMenu", parameter); return(dt); /*---------------------------------------------------------------------------------------------------------*/ //DataTable dt = new DataTable(); //string SQL = "select foodno,foodname,foodprice from [menu] where foodname='"+m.Foodname+"'"; //dt = db.SQLGetDataTable(SQL); //return dt; }
public static List <Model.Menu> GetMenu() { List <SqlParameter> sp = new List <SqlParameter>() { }; DataTable dtMenu = DataFacade.DTSQLCommand("SELECT MenuID,MenuName FROM Menu where MenuID LIKE 'M%'", sp); var mdlMenuList = new List <Model.Menu>(); foreach (DataRow row in dtMenu.Rows) { var mdlMenu = new Model.Menu(); mdlMenu.MenuID = row["MenuID"].ToString(); mdlMenu.MenuName = row["MenuName"].ToString(); mdlMenuList.Add(mdlMenu); } return(mdlMenuList); }
public JsonResult SaveMenu(EnumRequestParam param) { Common.Data.JsonData json = new Common.Data.JsonData() { Result = true }; IMenuService ms = IocMvcFactoryHelper.GetInterface <IMenuService>(); Menu m = new Model.Menu() { Name = param.Name, Code = param.Code, Remark = param.Desc, Url = param.Value, MenuType = (short)EMenuType.MenuNode.GetHashCode() }; string et = param.EnumMember; if (string.IsNullOrEmpty(et)) { m.MenuType = (short)EMenuType.MenuRoot.GetHashCode(); } else { //提取转换 EMenuType t; if (!Enum.TryParse(et, out t)) { json.Message = AppLanguage.Lang.Tip_MenuTypeValidInMenu; return(Json(json)); } m.MenuType = (short)t.GetHashCode(); } if (m.MenuType == (short)EMenuType.MenuNode.GetHashCode() && string.IsNullOrEmpty(param.Value)) { json.Success = false; json.Message = AppLanguage.Lang.Tip_MenuUrlIsRequired; return(Json(json)); } json = ms.Add(m); return(Json(json)); }
//获取第一个子菜单 public string[] GetChildMenu(string menu_id) { string [] childinfo = new string[2]; if (menu_id != "0") { DataTable dt = rolemenubll.GetSingleOrderByMenuId(menu_id, ViewState["roleid"].ToString()).Tables[0]; if (dt != null) { int mid = Convert.ToInt32(dt.Rows[0]["Menu_id"].ToString()); Model.Menu model = menubll.GetModel(mid); childinfo[0] = model.title; childinfo[1] = model.url; } else { childinfo[0] = ""; childinfo[1] = ""; } } return(childinfo); }
//将Add菜的信息录入到datatable,为生成订单表里的记录做准备 public DataTable AddInfo(Model.Menu m) { DataTable dt = new DataTable(); IDataParameter[] parameter = { new SqlParameter("@foodno", SqlDbType.Int) }; parameter[0].Value = m.Foodno; dt = pr.GetDataTable("AddInfo", parameter); //String SQL = "select foodname,foodprice from [menu] where foodno='" + m.Foodno + "'"; //dt = db.SQLGetDataTable(SQL); return(dt); /*---------------------------------------------------------------------------------------------------------*/ //DataTable dt = new DataTable(); //String SQL = "select foodname,foodprice from [menu] where foodno='" + m.Foodno + "'"; //dt = db.SQLGetDataTable(SQL); //return dt; }
//获取名称 public string GetName(string did) { string name = ""; if (did == "0") { name = "无"; } else { Model.Menu d = menubll.GetModel(int.Parse(did)); if (d != null) { name = d.title; } else { name = "不存在"; } } return(name); }
/// <summary> /// 获得数据列表 /// </summary> public List<Model.Menu> DataTableToList(DataTable dt) { List<Model.Menu> modelList = new List<Model.Menu>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Model.Menu model; for (int n = 0; n < rowsCount; n++) { model = new Model.Menu(); if (dt.Rows[n]["M_ID"] != null && dt.Rows[n]["M_ID"].ToString() != "") { model.M_ID = decimal.Parse(dt.Rows[n]["M_ID"].ToString()); } if (dt.Rows[n]["M_Name"] != null && dt.Rows[n]["M_Name"].ToString() != "") { model.M_Name = dt.Rows[n]["M_Name"].ToString(); } if (dt.Rows[n]["M_path"] != null && dt.Rows[n]["M_path"].ToString() != "") { model.M_path = dt.Rows[n]["M_path"].ToString(); } if (dt.Rows[n]["M_PID"] != null && dt.Rows[n]["M_PID"].ToString() != "") { model.M_PID = Convert.ToDecimal(dt.Rows[n]["M_PID"]); } if (dt.Rows[n]["M_Level"] != null && dt.Rows[n]["M_Level"].ToString() != "") { model.M_Level = int.Parse(dt.Rows[n]["M_Level"].ToString()); } if (dt.Rows[n]["M_enable"] != null && dt.Rows[n]["M_enable"].ToString() != "") { model.M_enable = int.Parse(dt.Rows[n]["M_enable"].ToString()); } modelList.Add(model); } } return modelList; }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.Menu GetModel(decimal M_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 M_ID,M_Name,M_path,M_PID,M_Level,M_enable from tbl_Menu "); strSql.Append(" where M_ID=@M_ID"); SqlParameter[] parameters = { new SqlParameter("@M_ID", SqlDbType.Decimal) }; parameters[0].Value = M_ID; Model.Menu model = new Model.Menu(); DataSet ds = SqlHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["M_ID"] != null && ds.Tables[0].Rows[0]["M_ID"].ToString() != "") { model.M_ID = decimal.Parse(ds.Tables[0].Rows[0]["M_ID"].ToString()); } if (ds.Tables[0].Rows[0]["M_Name"] != null && ds.Tables[0].Rows[0]["M_Name"].ToString() != "") { model.M_Name = ds.Tables[0].Rows[0]["M_Name"].ToString(); } if (ds.Tables[0].Rows[0]["M_path"] != null && ds.Tables[0].Rows[0]["M_path"].ToString() != "") { model.M_path = ds.Tables[0].Rows[0]["M_path"].ToString(); } if (ds.Tables[0].Rows[0]["M_PID"] != null && ds.Tables[0].Rows[0]["M_PID"].ToString() != "") { model.M_PID = decimal.Parse(ds.Tables[0].Rows[0]["M_PID"].ToString()); } if (ds.Tables[0].Rows[0]["M_Level"] != null && ds.Tables[0].Rows[0]["M_Level"].ToString() != "") { model.M_Level = int.Parse(ds.Tables[0].Rows[0]["M_Level"].ToString()); } if (ds.Tables[0].Rows[0]["M_enable"] != null && ds.Tables[0].Rows[0]["M_enable"].ToString() != "") { model.M_enable = int.Parse(ds.Tables[0].Rows[0]["M_enable"].ToString()); } return model; } else { return null; } }
/// <summary> /// 获取子节点连接 /// </summary> /// <param name="id"></param> /// <param name="title"></param> /// <param name="layer"></param> /// <returns></returns> protected string getMenuName(object id) { int Id = int.Parse(id.ToString()); Model.Menu modelMenu=new Model.Menu(); modelMenu = bllMenu.GetModel(Id); if (modelMenu!=null) { return modelMenu.Title; } else { return ""; } }
public List<Model.Menu> GetList(int _MenuId, int _ParentId, int _MenuStatus, int _LanguageId, int _Start, int _Limit) { List<Model.Menu> ModelList = new List<Model.Menu>(); try { SqlParameter[] p = { new SqlParameter("@MenuId", SqlDbType.Int, 4), new SqlParameter("@ParentID", SqlDbType.Int, 4), new SqlParameter("@MenuStatus", SqlDbType.Int, 4), new SqlParameter("@Lang", SqlDbType.Int, 4), new SqlParameter("@Start", SqlDbType.Int, 4), new SqlParameter("@Limit", SqlDbType.Int, 4) }; p[0].Value = _MenuId; p[1].Value = _ParentId; p[2].Value = _MenuStatus; p[3].Value = _LanguageId; p[4].Value = _Start; p[5].Value = _Limit; DataTable dt = db.ExcuteSelectReturnDataTable("Menu_Select", CommandType.StoredProcedure, p); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { Model.Menu model = new Model.Menu(); model.Ind = Convert.ToInt32(dr["Ind"]); model.MenuId = Convert.ToInt16(dr["MenuId"]); model.ParentId = Convert.ToInt16(dr["ParentId"]); model.MenuName = dr["MenuName"].ToString(); model.MenuUrl = dr["MenuUrl"].ToString(); model.MenuStatus = Convert.ToInt32(dr["MenuStatus"]); model.MenuOrder = Convert.ToInt16(dr["MenuOrder"]); model.ShowFooter = Convert.ToInt16(dr["ShowFooter"]); model.Lang = Convert.ToInt16(dr["Lang"]); model.TotalRow = Convert.ToInt16(dr["TotalRow"]); ModelList.Add(model); } } } catch (Exception ex) { PTSLog.Error(ex.Message); } return ModelList; }