public Models.DiscountDo GetDiscount(Models.DiscountCriteriaDo criteria) { Models.DiscountDo result = null; db.CreateCommand(new Utils.SQL.SQLCommandHandler((Utils.SQL.ASQLDbCommand command) => { command.CommandText = "[dbo].[sp_Get_Discount]"; command.CommandType = System.Data.CommandType.StoredProcedure; command.AddParameter(typeof(int), "DiscountID", criteria.DiscountID); System.Collections.IList[] dbls = command.ToList( typeof(Models.DiscountDo), typeof(Models.DiscountBrandDo), typeof(Models.DiscountUserGroupDo)); if (dbls != null) { List <Models.DiscountDo> dbds = dbls[0] as List <Models.DiscountDo>; List <Models.DiscountBrandDo> dbdbs = dbls[1] as List <Models.DiscountBrandDo>; List <Models.DiscountUserGroupDo> dbdus = dbls[2] as List <Models.DiscountUserGroupDo>; if (dbds != null) { if (dbds.Count > 0) { result = dbds[0]; result.Brands = dbdbs; result.Groups = dbdus; } } } })); return(result); }
public Models.UpdateDiscountResultDo UpdateDiscount(Models.DiscountDo entity) { Models.UpdateDiscountResultDo result = new Models.UpdateDiscountResultDo(); db.CreateCommand(new Utils.SQL.SQLCommandHandler((Utils.SQL.ASQLDbCommand command) => { command.CommandText = "[dbo].[sp_Update_Discount]"; command.CommandType = System.Data.CommandType.StoredProcedure; command.AddParameter(typeof(int), "DiscountID", entity.DiscountID); command.AddParameter(typeof(string), "DiscountName", entity.DiscountName); 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(bool), "FlagDiscountAll", entity.FlagDiscountAll); command.AddParameter(typeof(DateTime), "ActiveDate", entity.ActiveDate); command.AddParameter(typeof(DateTime), "ExpireDate", entity.ExpireDate); command.AddParameter(typeof(bool), "FlagActive", entity.FlagActive); string brandXml = Utils.ConvertUtil.ConvertToXml_Store <Models.DiscountBrandDo>(entity.Brands); command.AddParameter(typeof(string), "BrandXML", brandXml); string groupXml = Utils.ConvertUtil.ConvertToXml_Store <Models.DiscountUserGroupDo>(entity.Groups); command.AddParameter(typeof(string), "UserGroupXML", groupXml); command.AddParameter(typeof(DateTime), "UpdateDate", entity.UpdateDate); command.AddParameter(typeof(string), "UpdateUser", entity.UpdateUser); Utils.SQL.ISQLDbParameter error = command.AddErrorParameter(); System.Collections.IList[] dbls = command.ToList( typeof(Models.DiscountDo), typeof(Models.DiscountBrandDo), typeof(Models.DiscountUserGroupDo)); if (dbls != null) { List <Models.DiscountDo> dbds = dbls[0] as List <Models.DiscountDo>; List <Models.DiscountBrandDo> dbdbs = dbls[1] as List <Models.DiscountBrandDo>; List <Models.DiscountUserGroupDo> dbdus = dbls[2] as List <Models.DiscountUserGroupDo>; if (dbds != null) { if (dbds.Count > 0) { result.Discount = dbds[0]; result.Discount.Brands = dbdbs; result.Discount.Groups = dbdus; } } } result.ErrorParameter(error); })); return(result); }
public void DeleteDiscount(Models.DiscountDo entity) { db.CreateCommand(new Utils.SQL.SQLCommandHandler((Utils.SQL.ASQLDbCommand command) => { command.CommandText = "[dbo].[sp_Delete_Discount]"; command.CommandType = System.Data.CommandType.StoredProcedure; command.AddParameter(typeof(int), "DiscountID", entity.DiscountID); command.ExecuteNonQuery(); })); }