public Models.UpdateMenuCategoryResultDo CreateMenuCategory(Models.MenuCategoryDo entity) { Models.UpdateMenuCategoryResultDo result = new Models.UpdateMenuCategoryResultDo(); db.CreateCommand(new Utils.SQL.SQLCommandHandler((Utils.SQL.ASQLDbCommand command) => { command.CommandText = "[dbo].[sp_Create_MenuCategory]"; command.CommandType = System.Data.CommandType.StoredProcedure; command.AddParameter(typeof(int), "GroupID", entity.GroupID); command.AddParameter(typeof(string), "Code", entity.Code); command.AddParameter(typeof(string), "Name", entity.Name); command.AddParameter(typeof(DateTime), "CreateDate", entity.CreateDate); command.AddParameter(typeof(string), "CreateUser", entity.CreateUser); Utils.SQL.ISQLDbParameter error = command.AddErrorParameter(); List <Models.MenuCategoryDo> list = command.ToList <Models.MenuCategoryDo>(); if (list != null) { if (list.Count > 0) { result.Category = list[0]; } } result.ErrorParameter(error); })); return(result); }
public void DeleteMenuCategory(Models.MenuCategoryDo entity) { db.CreateCommand(new Utils.SQL.SQLCommandHandler((Utils.SQL.ASQLDbCommand command) => { command.CommandText = "[dbo].[sp_Delete_MenuCategory]"; command.CommandType = System.Data.CommandType.StoredProcedure; command.AddParameter(typeof(int), "GroupID", entity.GroupID); command.AddParameter(typeof(int), "CategoryID", entity.CategoryID); command.AddParameter(typeof(DateTime), "UpdateDate", entity.UpdateDate); command.AddParameter(typeof(string), "UpdateUser", entity.UpdateUser); command.ExecuteNonQuery(); })); }