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