public void ClearText(MenuItemEntity menuItemEntity)
{
foreach (var item in menuItemEntity.SubItems)
{
item.FieldValue = "";
}
}
public void UpdateText(MenuItemEntity menuItemEntity, string text)
{
foreach (var item in menuItemEntity.SubItems)
{
item.FieldValue = text;
}
}
public MenuItem(MenuItemEntity menuItem)
: base(menuItem)
{
Name = menuItem.Name;
Description = menuItem.Description;
Category = new MenuItemCategory(menuItem.Category);
Price = menuItem.Price;
}
public MenuItem(MenuItemEntity menuItem)
: base(menuItem)
{
Name = menuItem.Name;
Description = menuItem.Description;
Category = new MenuItemCategory(menuItem.Category);
Price = menuItem.Price;
}
public ActionResult DeleteConfirmed(int id)
{
MenuItemEntity menuItemEntity = db.MenuItems.Find(id);
db.MenuItems.Remove(menuItemEntity);
db.SaveChanges();
return(RedirectToAction("Index"));
}
/// <summary>
/// 导航菜单选中事件，跳转到各个页面
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void SettingsMenu_SelectedItem(object sender, EventArgs e)
{
if (sender is UCMenuChildrenItem)
{
UCMenuChildrenItem ucci = (UCMenuChildrenItem)sender;
MenuItemEntity mie = ucci.DataSource;
switch (mie.Key)
{
case "c1":
SettingsTabControl.SelectedIndex = 2;
break;
case "c2":
SettingsTabControl.SelectedIndex = 3;
break;
case "c3":
SettingsTabControl.SelectedIndex = 4;
break;
case "c4":
SettingsTabControl.SelectedIndex = 5;
break;
case "c5":
SettingsTabControl.SelectedIndex = 7;
break;
}
}
else if (sender is UCMenuParentItem)
{
UCMenuParentItem ucpi = (UCMenuParentItem)sender;
MenuItemEntity mie = ucpi.DataSource;
switch (mie.Key)
{
case "p1":
SettingsTabControl.SelectedIndex = 0;
break;
case "p2":
SettingsTabControl.SelectedIndex = 1;
break;
case "p3":
break;
case "p4":
SettingsTabControl.SelectedIndex = 6;
break;
}
}
}
public ActionResult Edit([Bind(Include = "Id,Heading,Description,Price,ImgUrl,MenuCategoryRefId")] MenuItemEntity menuItemEntity)
{
if (ModelState.IsValid)
{
db.Entry(menuItemEntity).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MenuCategoryRefId = new SelectList(db.MenuCategories, "Id", "Category", menuItemEntity.MenuCategoryRefId);
return(View(menuItemEntity));
}
// GET: MenuItemEntities/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MenuItemEntity menuItemEntity = db.MenuItems.Find(id);
if (menuItemEntity == null)
{
return(HttpNotFound());
}
return(View(menuItemEntity));
}
public void DeleteMenu(string menuId)
{
try
{
MenuItemEntity entity = new MenuItemEntity();
entity.Id = menuId;
PageManager manager = new PageManager(DbAccess);
manager.DeleteEntity <MenuItemEntity>(entity);
}
catch (Exception ex)
{
throw HandleException("Page", "DeleteMenu - " + menuId, ex);
}
}
// GET: MenuItemEntities/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MenuItemEntity menuItemEntity = db.MenuItems.Find(id);
if (menuItemEntity == null)
{
return(HttpNotFound());
}
ViewBag.MenuCategoryRefId = new SelectList(db.MenuCategories, "Id", "Category", menuItemEntity.MenuCategoryRefId);
return(View(menuItemEntity));
}
private void CustomPopWindowShow(Dictionary <string, object> datas)
{
MenuItemEntity menuItem = datas["MenuItem"] as MenuItemEntity;
Dictionary <string, object> args = null;
if (datas.ContainsKey("Args"))
{
args = datas["Args"] as Dictionary <string, object>;
}
this.IsShowRightInfo = false;
this.BacklogIsChecked = false;
this.AlertListIsChecked = false;
this.SystemNoticeIsChecked = false;
this.WorkScheduleIsChecked = false;
LoadPopWindow(menuItem, args);
}
public MainPageOfflineDetail(MenuItemEntity menuItemEntity)
{
InitializeComponent();
MainPageDetailViewModelOffline mainPageDetailViewModelOffline = new MainPageDetailViewModelOffline();
mainPageDetailViewModelOffline.Reset(menuItemEntity);
BindingContext = mainPageDetailViewModelOffline;
mBarcodeReaders = new Dictionary <string, BarcodeReader>();
_parentMenuItem = menuItemEntity;
var counter = mainPageDetailViewModelOffline.Registrations.Count;
Device.BeginInvokeOnMainThread(() =>
{
LabelQueue.Text = string.Format("{0} items in queue", counter);
});
}
private ICollection <MenuItemEntity> ConvertToEntity(ICollection <MenuItemEntityModel> items)
{
var entities = new List <MenuItemEntity>();
foreach (var item in items)
{
var x = new MenuItemEntity();
x.Id = item.Id;
x.Header = item.Header;
x.IsMenuEnabled = item.IsMenuEnabled;
x.IsMenuEnabledAsBool = item.IsMenuEnabledAsBool;
x.SubItems = ConvertToSubListEntity(item.SubItems);
entities.Add(x);
}
return(entities);
}
public static MenuItemViewModel ToModel(this MenuItemEntity entity, MenuCategoryEntity category)
{
var model = new MenuItemViewModel()
{
Id = entity.Id,
Heading = entity.Heading,
Description = entity.Description,
ImgUrl = entity.ImgUrl,
Price = entity.Price,
ExtrasModalModel = new ExtrasModalViewModel()
{
ItemId = entity.Id,
Heading = category.ItemAddonHeading,
ProductPrice = entity.Price,
Extras = category.ItemAdds.Where(x => x.MenuCategoryRefId == entity.MenuCategoryRefId).ToList().ToModel()
},
};
return(model);
}
private void UpdateBarcodeInfo(string data, MenuItemEntity menuItemEntity)
{
var scanData = data;
foreach (var item in menuItemEntity.SubItems)
{
if (item.ScanEnabled)
{
if (scanData.Length == item.Length && scanData.StartsWith(item.StartWith))
{
var resultData = scanData.Substring(item.Offset, item.ValueLength);
Device.BeginInvokeOnMainThread(() =>
{
item.FieldValue = resultData;
});
}
}
}
}
private void InitialUserMenuList()
{
MenuItemEntity childMenuItemEntity = new MenuItemEntity();
childMenuItemEntity.id = Convert.ToInt32(2);
childMenuItemEntity.code = "PasswordSettings";
childMenuItemEntity.name = "修改密码";
MenuItemEntity childMenuItemEntity1 = new MenuItemEntity();
childMenuItemEntity1.id = Convert.ToInt32(1);
childMenuItemEntity1.code = "PersonalInfo";
childMenuItemEntity1.name = "修改资料";
MenuItemEntity menuItemEntity = new MenuItemEntity();
menuItemEntity.id = Convert.ToInt32(0);
menuItemEntity.code = "currentUser";
menuItemEntity.name = "管理员";
menuItemEntity.children.Add(childMenuItemEntity);
menuItemEntity.children.Add(childMenuItemEntity1);
UserMenuList.Add(menuItemEntity);
RaisePropertyChanged("UserMenuList");
Application.Current.Dispatcher.Invoke(() =>
{
//获取菜单
_menuService.GetMenu <MenuEntity>((ret) =>
{
if (ret.state.code != StateCodeEnum.Success)
{
LogHelper.Error(ret.state.msg);
}
(ret as MenuEntity).menus.ForEach(p =>
{
p.SetUpdateNotify(UpdateMenuItemHeight);
MenuList.Add(p);
});
this.MenuList = MenuList;
RaisePropertyChanged("MenuList");
});
});
}
private void LoadPopWindow(MenuItemEntity menuItem, Dictionary <string, object> args = null)
{
//设置弹出Action
if (!this.CustomPopupViewRequestDict.ContainsKey(menuItem.code))
{
InteractionRequestTrigger interactionRequestTrigger = new InteractionRequestTrigger();
CustomPopupWindowAction customPopupWindowAction = new CustomPopupWindowAction()
{
CenterOverAssociatedObject = true, IsModal = false
};
ContentControl contentControl = new ContentControl();
RegionManager.SetRegionName(contentControl, menuItem.code + "Region");
customPopupWindowAction.WindowContent = contentControl;
interactionRequestTrigger.Actions.Add(customPopupWindowAction);
InteractionRequest <INotification> request = new InteractionRequest <INotification>();
this.CustomPopupViewRequestDict.Add(menuItem.code, request);
interactionRequestTrigger.SourceObject = this.CustomPopupViewRequestDict[menuItem.code];
System.Windows.Interactivity.Interaction.GetTriggers(Application.Current.MainWindow).Add(interactionRequestTrigger);//这里必须把MainWindow设置为Application.cureent
this._windowActions.Add(customPopupWindowAction);
}
PopWindowInfoEntity popWindowInfo = _container.Resolve <PopWindowInfoEntity>(menuItem.code);
popWindowInfo.RegionName = menuItem.code + "Region";
popWindowInfo.HomePath = menuItem.code;
if (args == null)
{
args = new Dictionary <string, object>();
}
args.Add(ParameterNames.PopWindowInfo, popWindowInfo);
this.CustomPopupViewRequestDict[menuItem.code].Raise(
new Notification {
Content = args, Title = menuItem.name
}, (r) =>
{
});
_eventAggregator.GetEvent <PopWindowActivateEvents>().Publish(menuItem.code + "Region");
}
private void UCTestMenu_Load(object sender, EventArgs e)
{
List <MenuItemEntity> lstMenu1 = new List <MenuItemEntity>();
for (int i = 0; i < 2; i++)
{
MenuItemEntity item = new MenuItemEntity()
{
Key = "p" + i.ToString(),
Text = "菜单项" + i,
DataSource = "这里编写一些自定义的数据源，用于扩展"
};
item.Childrens = new List <MenuItemEntity>();
for (int j = 0; j < 5; j++)
{
MenuItemEntity item2 = new MenuItemEntity()
{
Key = "c" + i.ToString(),
Text = "菜单子项" + i + "-" + j,
DataSource = "这里编写一些自定义的数据源，用于扩展"
};
item.Childrens.Add(item2);
}
lstMenu1.Add(item);
}
for (int i = 2; i < 4; i++)
{
MenuItemEntity item = new MenuItemEntity()
{
Key = "p" + i.ToString(),
Text = "菜单项" + i,
DataSource = "这里编写一些自定义的数据源，用于扩展"
};
lstMenu1.Add(item);
}
this.ucMenu1.DataSource = lstMenu1;
this.ucMenu2.DataSource = lstMenu1;
}
private async Task ImportMenuItemDefinition(MenuItem menuDef)
{
var menu = await _menuEntityRepo.FirstOrDefaultAsync(x => x.Feature == menuDef.Feature && x.Name == menuDef.Name);
var parent = menuDef.Parent != null ? await _menuEntityRepo.SingleAsync(x => x.Name == menuDef.Parent) : null;
var action = menuDef.Action != null ? await _actionRepo.SingleAsync(x => x.Name == menuDef.Action) : null;
if (menu == null)
{
menu = new MenuItemEntity();
menu.Feature = menuDef.Feature;
menu.Name = menuDef.Name;
}
menu.Action = action;
menu.Order = menuDef.Order;
menu.Text = menuDef.Text;
menu.BackgroundColor = menuDef.BackgroundColor;
menu.Icon = menuDef.Icon;
menu._Parent = parent;
await _menuEntityRepo.InsertOrUpdateAsync(menu);
}
public void ModifyMenu(MenuItemInfo menu)
{
try
{
MenuItemEntity entity = new MenuItemEntity();
entity.Id = menu.Id;
entity.Index = menu.Index;
entity.InnerId = menu.InnerId;
entity.IsInner = menu.IsInner;
entity.IsListType = menu.IsListType;
entity.IsOpenNewWindow = menu.IsOpenNewWindow;
entity.Level = menu.Level;
entity.Name = menu.Name;
entity.OuterUrl = menu.OuterUrl;
entity.ParentId = menu.ParentId;
PageManager manager = new PageManager(DbAccess);
manager.ModifyEntity <MenuItemEntity>(entity);
}
catch (Exception ex)
{
throw HandleException("Page", "AddMenu - " + menu.Name, ex);
}
}
public void AddMenu(MenuItemInfo menu)
{
try
{
MenuItemEntity entity = new MenuItemEntity();
entity.Index = menu.Index;
entity.InnerId = menu.InnerId;
entity.IsInner = menu.IsInner;
entity.IsListType = menu.IsListType;
entity.IsOpenNewWindow = menu.IsOpenNewWindow;
entity.Level = menu.Level;
entity.Name = menu.Name;
entity.OuterUrl = menu.OuterUrl;
entity.ParentId = menu.ParentId;
PageManager manager = new PageManager(DbAccess);
manager.AddEntity<MenuItemEntity>(entity);
menu.Id = entity.Id;
}
catch (Exception ex)
{
throw HandleException("Page", "AddMenu - " + menu.Name, ex);
}
}
public static object AddNew(MenuItemEntity entity)
{
return(new MenuItemDal().Insert(entity));
}
private void Form1_Load(object sender, EventArgs e)
{
for (int i = 0; i < 3; i++)
{
TreeNode tn = new TreeNode(" 父节点" + i);
for (int j = 0; j < 3; j++)
{
tn.Nodes.Add(" 子节点" + j);
}
this.treeViewEx1.Nodes.Add(tn);
}
List <KeyValuePair <string, string> > lstCom = new List <KeyValuePair <string, string> >();
for (int i = 0; i < 5; i++)
{
lstCom.Add(new KeyValuePair <string, string>(i.ToString(), "选项" + i));
}
this.ucComboBox1.Source = lstCom;
this.ucComboBox2.Source = lstCom;
this.ucComboBox1.SelectedIndex = 1;
this.ucComboBox2.SelectedIndex = 1;
List <ListEntity> lst = new List <ListEntity>();
for (int i = 0; i < 5; i++)
{
lst.Add(new ListEntity()
{
ID = i.ToString(),
Title = "选项" + i,
ShowMoreBtn = true,
Source = i
});
}
this.ucListExt1.SetList(lst);
List <KeyValuePair <string, string> > lstHL = new List <KeyValuePair <string, string> >();
for (int i = 0; i < 30; i++)
{
lstHL.Add(new KeyValuePair <string, string>(i.ToString(), "选项" + i));
}
this.ucHorizontalList1.DataSource = lstHL;
List <MenuItemEntity> lstMenu = new List <MenuItemEntity>();
for (int i = 0; i < 2; i++)
{
MenuItemEntity item = new MenuItemEntity()
{
Key = "p" + i.ToString(),
Text = "菜单项" + i,
DataSource = "这里编写一些自定义的数据源，用于扩展"
};
item.Childrens = new List <MenuItemEntity>();
for (int j = 0; j < 5; j++)
{
MenuItemEntity item2 = new MenuItemEntity()
{
Key = "c" + i.ToString(),
Text = "菜单子项" + i + "-" + j,
DataSource = "这里编写一些自定义的数据源，用于扩展"
};
item.Childrens.Add(item2);
}
lstMenu.Add(item);
}
for (int i = 2; i < 4; i++)
{
MenuItemEntity item = new MenuItemEntity()
{
Key = "p" + i.ToString(),
Text = "菜单项" + i,
DataSource = "这里编写一些自定义的数据源，用于扩展"
};
lstMenu.Add(item);
}
this.ucMenu1.MenuStyle = MenuStyle.Top;
this.ucMenu1.DataSource = lstMenu;
List <object> lstPage2 = new List <object>();
for (int i = 0; i < 1000; i++)
{
lstPage2.Add(i);
}
ucPagerControl21.PageSize = 10;
ucPagerControl21.DataSource = lstPage2;
ucBtnsGroup1.DataSource = new Dictionary <string, string>()
{
{ "1", "男" }, { "0", "女" }
};
ucBtnsGroup2.IsMultiple = true;
ucBtnsGroup2.DataSource = new Dictionary <string, string>()
{
{ "1", "河南" }, { "2", "北京" }, { "3", "湖南" }, { "4", "上海" }
};
ucBtnsGroup2.SelectItem = new List <string>()
{
"2", "3"
};
this.processExt1.Value = 50;
}
private void Form1_Load(object sender, EventArgs e)
{
for (int i = 0; i < 3; i++)
{
TreeNode tn = new TreeNode(" 父节点" + i);
for (int j = 0; j < 3; j++)
{
tn.Nodes.Add(" 子节点" + j);
}
this.treeViewEx1.Nodes.Add(tn);
}
List <KeyValuePair <string, string> > lstCom = new List <KeyValuePair <string, string> >();
for (int i = 0; i < 5; i++)
{
lstCom.Add(new KeyValuePair <string, string>(i.ToString(), "选项" + i));
}
this.ucComboBox1.Source = lstCom;
this.ucComboBox2.Source = lstCom;
this.ucComboBox1.SelectedIndex = 1;
this.ucComboBox2.SelectedIndex = 1;
List <ListEntity> lst = new List <ListEntity>();
for (int i = 0; i < 5; i++)
{
lst.Add(new ListEntity()
{
ID = i.ToString(),
Title = "选项" + i,
ShowMoreBtn = true,
Source = i
});
}
this.ucListExt1.SetList(lst);
List <KeyValuePair <string, string> > lstHL = new List <KeyValuePair <string, string> >();
for (int i = 0; i < 30; i++)
{
lstHL.Add(new KeyValuePair <string, string>(i.ToString(), "选项" + i));
}
this.ucHorizontalList1.DataSource = lstHL;
List <MenuItemEntity> lstMenu = new List <MenuItemEntity>();
for (int i = 0; i < 2; i++)
{
MenuItemEntity item = new MenuItemEntity()
{
Key = "p" + i.ToString(),
Text = "菜单项" + i,
DataSource = "这里编写一些自定义的数据源，用于扩展"
};
item.Childrens = new List <MenuItemEntity>();
for (int j = 0; j < 5; j++)
{
MenuItemEntity item2 = new MenuItemEntity()
{
Key = "c" + i.ToString(),
Text = "菜单子项" + i + "-" + j,
DataSource = "这里编写一些自定义的数据源，用于扩展"
};
item.Childrens.Add(item2);
}
lstMenu.Add(item);
}
for (int i = 2; i < 4; i++)
{
MenuItemEntity item = new MenuItemEntity()
{
Key = "p" + i.ToString(),
Text = "菜单项" + i,
DataSource = "这里编写一些自定义的数据源，用于扩展"
};
lstMenu.Add(item);
}
this.ucMenu1.MenuStyle = MenuStyle.Top;
this.ucMenu1.DataSource = lstMenu;
List <object> lstPage2 = new List <object>();
for (int i = 0; i < 1000; i++)
{
lstPage2.Add(i);
}
ucPagerControl21.PageSize = 10;
ucPagerControl21.DataSource = lstPage2;
ucBtnsGroup1.DataSource = new Dictionary <string, string>()
{
{ "1", "男" }, { "0", "女" }
};
ucBtnsGroup2.IsMultiple = true;
ucBtnsGroup2.DataSource = new Dictionary <string, string>()
{
{ "1", "河南" }, { "2", "北京" }, { "3", "湖南" }, { "4", "上海" }
};
ucBtnsGroup2.SelectItem = new List <string>()
{
"2", "3"
};
List <DataGridViewColumnEntity> lstCulumns = new List <DataGridViewColumnEntity>();
lstCulumns.Add(new DataGridViewColumnEntity()
{
DataField = "ID", HeadText = "编号", Width = 70, WidthType = SizeType.Absolute
});
lstCulumns.Add(new DataGridViewColumnEntity()
{
DataField = "Name", HeadText = "姓名", Width = 100, WidthType = SizeType.Absolute
});
lstCulumns.Add(new DataGridViewColumnEntity()
{
DataField = "Age", HeadText = "年龄", Width = 100, WidthType = SizeType.Absolute
});
lstCulumns.Add(new DataGridViewColumnEntity()
{
DataField = "Birthday", HeadText = "生日", Width = 120, WidthType = SizeType.Absolute, Format = (a) => { return(((DateTime)a).ToString("yyyy-MM-dd")); }
});
lstCulumns.Add(new DataGridViewColumnEntity()
{
DataField = "Sex", HeadText = "性别", Width = 100, WidthType = SizeType.Absolute, Format = (a) => { return(((int)a) == 0 ? "女" : "男"); }
});
this.ucComboxGrid1.GridColumns = lstCulumns;
List <object> lstSourceGrid = new List <object>();
for (int i = 0; i < 100; i++)
{
TestModel model = new TestModel()
{
ID = i.ToString(),
Age = 3 * i,
Name = "姓名——" + i,
Birthday = DateTime.Now.AddYears(-10),
Sex = i % 2
};
lstSourceGrid.Add(model);
}
this.ucComboxGrid1.GridDataSource = lstSourceGrid;
}
private void MenuItemExcute(MenuItemEntity menuItem)
{
//特殊的不走Action方式弹出
LoadPopWindow(menuItem);
}
public static int Update(MenuItemEntity entity)
{
return(new MenuItemDal().Update(entity));
}
public static int Remove(MenuItemEntity entity)
{
return(RemoveByKey(entity.MENU_CODE));
}
/// <summary>
/// 左部导航菜单初始化
/// </summary>
private void MenuInit()
{
List <MenuItemEntity> lstMenu = new List <MenuItemEntity>();
MenuItemEntity item1 = new MenuItemEntity()
{
Key = "p1",
Text = "MisakaTranslator"
};
lstMenu.Add(item1);
//=======================================================
MenuItemEntity item2 = new MenuItemEntity()
{
Key = "p2",
Text = "Textrator相关设置"
};
lstMenu.Add(item2);
//=======================================================
MenuItemEntity item3 = new MenuItemEntity()
{
Key = "p3",
Text = "OCR文字识别设置"
};
item3.Childrens = new List <MenuItemEntity>();
MenuItemEntity item4 = new MenuItemEntity()
{
Key = "c1",
Text = "百度OCR API"
};
item3.Childrens.Add(item4);
lstMenu.Add(item3);
//=======================================================
MenuItemEntity item5 = new MenuItemEntity()
{
Key = "p4",
Text = "翻译API设置"
};
item5.Childrens = new List <MenuItemEntity>();
MenuItemEntity item6 = new MenuItemEntity()
{
Key = "c2",
Text = "百度翻译 API"
};
item5.Childrens.Add(item6);
MenuItemEntity item7 = new MenuItemEntity()
{
Key = "c3",
Text = "腾讯翻译 API"
};
item5.Childrens.Add(item7);
MenuItemEntity item8 = new MenuItemEntity()
{
Key = "c4",
Text = "JBeijing API"
};
item5.Childrens.Add(item8);
MenuItemEntity item9 = new MenuItemEntity()
{
Key = "c5",
Text = "腾讯私人 API"
};
item5.Childrens.Add(item9);
lstMenu.Add(item5);
//=======================================================
SettingsMenu.MenuStyle = MenuStyle.Top;
SettingsMenu.DataSource = lstMenu;
}
public void DeleteMenu(string menuId)
{
try
{
MenuItemEntity entity = new MenuItemEntity();
entity.Id = menuId;
PageManager manager = new PageManager(DbAccess);
manager.DeleteEntity<MenuItemEntity>(entity);
}
catch (Exception ex)
{
throw HandleException("Page", "DeleteMenu - " + menuId, ex);
}
}
public MenuItem AddMenuItem(int managerId, string name, string description, int categoryId, Money price)
{
if (!CheckHasUserRole(managerId, UserRole.Manager))
throw new SecurityException(String.Format("User id = {0} is not logged in or is no manager", managerId));
if (String.IsNullOrEmpty(name))
throw new ArgumentNullException("name");
if (String.IsNullOrEmpty(description))
throw new ArgumentNullException("description");
MenuItemEntity newMenuItemEntity = null;
using (var db = new DataAccessProvider())
{
MenuItemCategoryEntity category = null;
category = db.MenuItemCategories.Find(categoryId);
if (category == null)
return null;
var menuItemToAdd = new MenuItemEntity() { Name = name, Description = description, Category = category, Price = price };
var menuItemsSameName = db.MenuItems.Where(mI => mI.Name.Equals(name));
if( menuItemsSameName.Any())
foreach(MenuItemEntity menuItem in menuItemsSameName)
if(menuItem.Equals(menuItemToAdd))
{
if (menuItem.IsDeleted)
menuItem.IsDeleted = false;
newMenuItemEntity = menuItem;
break;
}
if(newMenuItemEntity == null)
newMenuItemEntity = db.MenuItems.Add(menuItemToAdd);
db.SaveChanges();
}
return new MenuItem(newMenuItemEntity);
}
private string parseMenuData(bool OnlyCheck, operate operatit, string companycode, string menucode, string menuname, string menunameEN, string menucodefather, string menulevel, string menuindex, string leafflag, string programcode)
{ //COMPANY_CODE,MENU_CODE, MENU_NAME,MENU_NAME_EN, MENU_CODE_FATHER, MENU_LEVEL, MENU_INDEX, LEAF_FLAG,PROGRAM_CODE
//进行菜单数据CRUD之前的检查。
companycode = companycode == null ? "" : companycode.Trim();
menucode = menucode == null ? "" : menucode.Trim();
menuname = menuname == null ? "" : menuname.Trim();
menunameEN = menunameEN == null ? "" : menunameEN.Trim();
menucodefather = menucodefather == null ? "" : menucodefather.Trim();
menulevel = menulevel == null ? "" : menulevel.Trim();
menuindex = menuindex == null ? "" : menuindex.Trim();
programcode = programcode == null ? "" : programcode.Trim();
leafflag = programcode.Equals("") ? "N" : "Y";
if (string.Empty.Equals(companycode))
{
return("公司代码为空，您的Session可能已经过期，请重新登录");
}
if (string.Empty.Equals(menucode))
{
return("菜单代码为空，请重新输入");
}
if (string.Empty.Equals(menuname))
{
return("菜单标题为空，请重新输入");
}
if (string.Empty.Equals(menunameEN))
{
return("菜单英文标题为空，请重新输入");
}
if (string.Empty.Equals(menuindex))
{
return("菜单索引为空，请重新输入");
}
//if (string.Empty.Equals(menucodefather)) return "上级菜单为空，请重新输入";
//if (string.Empty.Equals(menulevel)) return "菜单层级为空，请重新输入";
//if (string.Empty.Equals(programcode)) return "为空，请重新输入";
string sql = "";
if (operatit == operate.AddNew)
{
sql = "select count(*) from CODE_MENU where MENU_CODE='" + menucode + "' and COMPANY_CODE='" + companycode + "'";
DataTable dt = conn.GetTable(sql);
if (Convert.ToInt32(dt.Rows[0][0]) > 0)
{
return("已有相同的菜单编码\"" + menucode + "\"，请重新输入。");
}
}
//CRUD
if (!OnlyCheck)//如果不仅仅是检查数据，则进行CRUD操作，否则只执行上面的语句，进行数据检查。
{
if (string.Empty.Equals(menulevel))
{
menulevel = ASPxTreeList1.FocusedNode.HasChildren ? (ASPxTreeList1.FocusedNode.Level + 1).ToString() : ASPxTreeList1.FocusedNode.Level.ToString();
}
if (string.Empty.Equals(menuindex))
{
menuindex = "99";
}
MenuItemEntity menu1 = new MenuItemEntity()
{
COMPANY_CODE = companycode,
MENU_CODE = menucode,
MENU_CODE_FATHER = menucodefather,
LEAF_FLAG = leafflag,
MENU_INDEX = Convert.ToInt32(menuindex),
MENU_LEVEL = Convert.ToInt32(menulevel),
MENU_NAME = menuname,
MENU_NAME_EN = menunameEN,
PROGRAM_CODE = programcode
};
int ret = 0;
object obj = null;
string strReturn = "未知操作！";
switch (operatit)
{
case operate.AddNew:
obj = MenuItemFactory.AddNew(menu1);
if (obj != null)
{
strReturn = "";
}
else
{
strReturn = "添加失败！";
}
//sql = "INSERT INTO CODE_MENU (COMPANY_CODE, MENU_CODE, MENU_NAME, MENU_NAME_EN, MENU_CODE_FATHER, MENU_LEVEL,MENU_INDEX, LEAF_FLAG, PROGRAM_CODE) VALUES (:COMPANY_CODE, :MENU_CODE, :MENU_NAME, :MENU_NAME_EN, :MENU_CODE_FATHER, :MENU_LEVEL, :MENU_INDEX, :LEAF_FLAG, :PROGRAM_CODE)";
break;
case operate.Update:
ret = MenuItemFactory.Update(menu1);
if (ret == 1)
{
strReturn = "";
}
else
{
strReturn = "修改失败！";
}
//sql = "UPDATE CODE_MENU SET MENU_NAME = :MENU_NAME, MENU_NAME_EN = :MENU_NAME_EN, MENU_CODE_FATHER = :MENU_CODE_FATHER, MENU_LEVEL = :MENU_LEVEL, MENU_INDEX = :MENU_INDEX, LEAF_FLAG = :LEAF_FLAG, PROGRAM_CODE = :PROGRAM_CODE WHERE COMPANY_CODE = :COMPANY_CODE AND MENU_CODE = :MENU_CODE";
break;
case operate.Delete:
ret = MenuItemFactory.Remove(menu1);
if (ret == 1)
{
strReturn = "";
}
else
{
strReturn = "移除失败！";
}
//sql = "DELETE FROM CODE_MENU WHERE COMPANY_CODE = :COMPANY_CODE AND MENU_CODE = :MENU_CODE";
break;
default: sql = ""; strReturn = "无效的操作"; break;
}
return(strReturn);
///以前用的是下面的sql方式，现在改为上面的Entity方式。
//if (sql == "") return "错误的SQL语句。";
//if (conn.theComd.Connection.State == ConnectionState.Closed) conn.theComd.Connection.Open();
//conn.theComd.CommandText = sql;
//conn.theComd.Parameters.Clear();
//conn.theComd.Parameters.Add("COMPANY_CODE", Oracle.DataAccess.Client.OracleDbType.Varchar2).Value = companycode;
//conn.theComd.Parameters.Add("MENU_CODE", Oracle.DataAccess.Client.OracleDbType.Varchar2).Value = menucode;
//if (operatit != operate.Delete)
//{
// conn.theComd.Parameters.Add("MENU_NAME", Oracle.DataAccess.Client.OracleDbType.Varchar2).Value = menuname;
// conn.theComd.Parameters.Add("MENU_NAME_EN", Oracle.DataAccess.Client.OracleDbType.Varchar2).Value = menunameEN;
// conn.theComd.Parameters.Add("MENU_CODE_FATHER", Oracle.DataAccess.Client.OracleDbType.Varchar2).Value = menucodefather;
// conn.theComd.Parameters.Add("MENU_LEVEL", Oracle.DataAccess.Client.OracleDbType.Int32).Value = menulevel;
// conn.theComd.Parameters.Add("MENU_INDEX", Oracle.DataAccess.Client.OracleDbType.Int32).Value = menuindex;
// conn.theComd.Parameters.Add("LEAF_FLAG", Oracle.DataAccess.Client.OracleDbType.Varchar2).Value = leafflag;
// conn.theComd.Parameters.Add("PROGRAM_CODE", Oracle.DataAccess.Client.OracleDbType.Varchar2).Value = programcode;
//}
//if (conn.theComd.ExecuteNonQuery() == 1)
//{
// conn.theComd.Parameters.Clear();
// conn.theComd.Connection.Close();
// return "";
//}
//else
//{
// conn.theComd.Parameters.Clear();
// conn.theComd.Connection.Close();
// return "执行SQL出错!!";
//}
}
return("");
}