Esempio n. 1
0
        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);
        }
Esempio n. 2
0
        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);
        }
Esempio n. 3
0
        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);
        }
Esempio n. 4
0
        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);
        }