public Models.TemplateDo GetTemplate(Models.TemplateCriteriaDo criteria) { Models.TemplateDo result = null; db.CreateCommand(new Utils.SQL.SQLCommandHandler((Utils.SQL.ASQLDbCommand command) => { command.CommandText = "[dbo].[sp_Get_Template]"; command.CommandType = System.Data.CommandType.StoredProcedure; command.AddParameter(typeof(int), "TemplateID", criteria.TemplateID); command.AddParameter(typeof(string), "BrandCode", criteria.BrandCode); command.AddParameter(typeof(string), "TemplateName", criteria.TemplateName); List <Models.TemplateDo> list = command.ToList <Models.TemplateDo>(); if (list != null) { if (list.Count > 0) { result = list[0]; } } })); return(result); }
public List <Models.TemplateAutoCompleteDo> GetTemplateAutoComplete(Models.TemplateCriteriaDo criteria) { List <Models.TemplateAutoCompleteDo> result = new List <Models.TemplateAutoCompleteDo>(); db.CreateCommand(new Utils.SQL.SQLCommandHandler((Utils.SQL.ASQLDbCommand command) => { command.CommandType = System.Data.CommandType.StoredProcedure; command.CommandText = "[dbo].[sp_Get_TemplateMenuAutoComplete]"; command.AddParameter(typeof(string), "BrandCode", criteria.BrandCode); result = command.ToList <Models.TemplateAutoCompleteDo>(); })); return(result); }
public Models.TemplateResultDo GetTemplateList(Models.TemplateCriteriaDo criteria) { Models.TemplateResultDo result = new Models.TemplateResultDo(); db.CreateCommand(new Utils.SQL.SQLCommandHandler((Utils.SQL.ASQLDbCommand command) => { command.CommandType = System.Data.CommandType.StoredProcedure; command.CommandText = "[dbo].[sp_Get_TemplateList]"; command.AddParameter(typeof(string), "TemplateName", criteria.TemplateName); command.AddParameter(typeof(string), "BrandCode", criteria.BrandCode); command.AddParameter(typeof(bool), "FlagActive", criteria.FlagActive); Utils.SQL.ISQLDbParameter output = command.AddSearchParameter(criteria); result.Rows = command.ToList <Models.TemplateDo>(); result.TotalRecordParameter(output); })); return(result); }
public List <Models.TemplateMenuGroupDo> GetTemplateMenu(Models.TemplateCriteriaDo criteria) { List <Models.TemplateMenuGroupDo> result = new List <Models.TemplateMenuGroupDo>(); db.CreateCommand(new Utils.SQL.SQLCommandHandler((Utils.SQL.ASQLDbCommand command) => { command.CommandType = System.Data.CommandType.StoredProcedure; command.CommandText = "[dbo].[sp_Get_TemplateMenu]"; command.AddParameter(typeof(string), "BrandCode", criteria.BrandCode); command.AddParameter(typeof(int), "TemplateID", criteria.TemplateID); command.AddSearchParameter(criteria, false, false, true, true, false); List <Models.TemplateMenuGroupDo> groups = new List <Models.TemplateMenuGroupDo>(); List <Models.TemplateMenuDo> menus = command.ToList <Models.TemplateMenuDo>(); foreach (Models.TemplateMenuDo menu in menus) { Models.TemplateMenuGroupDo group = groups.Find(x => x.GroupID == menu.GroupID && x.FlagTakeAway == menu.FlagTakeAway); if (group == null) { group = new Models.TemplateMenuGroupDo() { GroupID = menu.GroupID, Name = menu.GroupName, FlagTakeAway = menu.FlagTakeAway, Seq = menu.GroupSeq }; group.Categories = new List <Models.TemplateMenuCategoryDo>(); groups.Add(group); } Models.TemplateMenuCategoryDo category = group.Categories.Find(x => x.GroupID == menu.GroupID && x.CategoryID == menu.CategoryID && x.FlagTakeAway == menu.FlagTakeAway); if (category == null) { category = new Models.TemplateMenuCategoryDo() { GroupID = menu.GroupID, CategoryID = menu.CategoryID, Name = menu.CategoryName, FlagTakeAway = menu.FlagTakeAway, Seq = menu.CategorySeq }; category.SubCategories = new List <Models.TemplateMenuSubCategoryDo>(); group.Categories.Add(category); } Models.TemplateMenuSubCategoryDo sub = category.SubCategories.Find(x => x.GroupID == menu.GroupID && x.CategoryID == menu.CategoryID && x.SubCategoryID == menu.SubCategoryID && x.FlagTakeAway == menu.FlagTakeAway); if (sub == null) { sub = new Models.TemplateMenuSubCategoryDo() { GroupID = menu.GroupID, CategoryID = menu.CategoryID, SubCategoryID = menu.SubCategoryID, SubCategoryCode = menu.SubCategoryCode, Name = menu.SubCategoryName, FlagTakeAway = menu.FlagTakeAway, Seq = menu.SubCategorySeq }; sub.Menus = new List <Models.TemplateMenuDo>(); category.SubCategories.Add(sub); } sub.Menus.Add(menu); } result = groups; })); return(result); }