public Models.MemberTypeDo GetMemberType(Models.MemberTypeCriteriaDo criteria) { Models.MemberTypeDo result = null; db.CreateCommand(new Utils.SQL.SQLCommandHandler((Utils.SQL.ASQLDbCommand command) => { command.CommandText = "[dbo].[sp_Get_MemberType]"; command.CommandType = System.Data.CommandType.StoredProcedure; command.AddParameter(typeof(int), "MemberTypeID", criteria.MemberTypeID); System.Collections.IList[] dbls = command.ToList(typeof(Models.MemberTypeDo), typeof(Models.MemberTypeBrandDo)); if (dbls != null) { List <Models.MemberTypeDo> dbmts = dbls[0] as List <Models.MemberTypeDo>; List <Models.MemberTypeBrandDo> dbmtbs = dbls[1] as List <Models.MemberTypeBrandDo>; if (dbmts != null) { if (dbmts.Count > 0) { result = dbmts[0]; if (dbmtbs != null) { result.Brands = dbmtbs; } } } } })); return(result); }
public Models.UpdateMemberTypeResultDo CreateMemberType(Models.MemberTypeDo entity) { Models.UpdateMemberTypeResultDo result = new Models.UpdateMemberTypeResultDo(); db.CreateCommand(new Utils.SQL.SQLCommandHandler((Utils.SQL.ASQLDbCommand command) => { command.CommandText = "[dbo].[sp_Create_MemberType]"; command.CommandType = System.Data.CommandType.StoredProcedure; command.AddParameter(typeof(string), "MemberTypeName", entity.MemberTypeName); command.AddParameter(typeof(string), "Remark", entity.Remark); command.AddParameter(typeof(decimal), "CreditDiscountValue", entity.CreditDiscountValue); command.AddParameter(typeof(string), "CreditDiscountType", entity.CreditDiscountType); command.AddParameter(typeof(decimal), "CashDiscountValue", entity.CashDiscountValue); command.AddParameter(typeof(string), "CashDiscountType", entity.CashDiscountType); command.AddParameter(typeof(int), "MemberLifeType", entity.MemberLifeType); command.AddParameter(typeof(DateTime), "StartPeriod", entity.StartPeriod); command.AddParameter(typeof(DateTime), "EndPeriod", entity.EndPeriod); command.AddParameter(typeof(bool), "FlagActive", entity.FlagActive); command.AddParameter(typeof(decimal), "Lifetime", entity.Lifetime); command.AddParameter(typeof(decimal), "Price", entity.Price); string brandXml = Utils.ConvertUtil.ConvertToXml_Store <Models.MemberTypeBrandDo>(entity.Brands); command.AddParameter(typeof(string), "BrandXML", brandXml); command.AddParameter(typeof(DateTime), "CreateDate", entity.CreateDate); command.AddParameter(typeof(string), "CreateUser", entity.CreateUser); Utils.SQL.ISQLDbParameter error = command.AddErrorParameter(); System.Collections.IList[] dbls = command.ToList(typeof(Models.MemberTypeDo), typeof(Models.MemberTypeBrandDo)); if (dbls != null) { List <Models.MemberTypeDo> dbmts = dbls[0] as List <Models.MemberTypeDo>; List <Models.MemberTypeBrandDo> dbmtbs = dbls[1] as List <Models.MemberTypeBrandDo>; if (dbmts != null) { if (dbmts.Count > 0) { result.MemberType = dbmts[0]; if (dbmtbs != null) { result.MemberType.Brands = dbmtbs; } } } } result.ErrorParameter(error); })); return(result); }
public void DeleteMemberType(Models.MemberTypeDo entity) { db.CreateCommand(new Utils.SQL.SQLCommandHandler((Utils.SQL.ASQLDbCommand command) => { command.CommandText = "[dbo].[sp_Delete_MemberType]"; command.CommandType = System.Data.CommandType.StoredProcedure; command.AddParameter(typeof(int), "MemberTypeID", entity.MemberTypeID); command.ExecuteNonQuery(); })); }