public DiscountSearchView(DISCOUNT discount) { this.DISCOUNTID = discount.DISCOUNTID; this.DISCOUNTYEAR = discount.DISCOUNTYEAR; this.DESCRIPTION = discount.DESCRIPTION; this.AMOUNT = discount.AMOUNT; }
//建立一条新的优惠信息 public bool insertNewDiscount(DiscountDTO discountDTO) { try { Db.Ado.BeginTran(); DISCOUNT discount = new DISCOUNT { DISCOUNT_PRICE = discountDTO._amount, START_TIME = discountDTO._start_time, END_TIME = discountDTO._end_time, CONTEXT = discountDTO._context }; var existId = Db.Queryable <SET_DISCOUNT>().Where(it => it.MEDICINE_ID == discountDTO._medicine_id && it.BATCH_ID == discountDTO._batch_id).Select(it => it.DISCOUNT_ID).ToList(); var cId = 0; if (existId.Count == 0) { Db.Insertable <DISCOUNT>(discount). IgnoreColumns(it => new { it.DISCOUNT_ID }). ExecuteCommandIdentityIntoEntity(); var id = Db.Ado.SqlQuery <int>("select ISEQ$$_75598.currval from dual"); cId = id[0]; SET_DISCOUNT setDiscount = new SET_DISCOUNT { BATCH_ID = discountDTO._batch_id, MEDICINE_ID = discountDTO._medicine_id, DISCOUNT_ID = cId }; Db.Insertable(setDiscount).ExecuteCommand(); } else { cId = existId[0]; discount.DISCOUNT_ID = cId; Db.Updateable(discount).ExecuteCommand(); } Db.Ado.CommitTran(); return(true); }catch (Exception ex) { Db.Ado.RollbackTran(); return(false); } }
public static bool InsertDiscount(int storeID, double discountValue, TimeSpan start, TimeSpan end, DateTime from, DateTime to, string description, int times) { //bool result = false; DISCOUNT discount = new DISCOUNT() { VALUE = discountValue, START_TIME = start, END_TIME = end, AVAILABLE_FROM = from, AVAILABLE_TO = to, DESCRIPTION = description, TIMES = times, STORE_ID = storeID , AVAILABLE="YES", POPULAR=0}; try { mydb.DISCOUNTs.InsertOnSubmit(discount); mydb.SubmitChanges(); return true; } catch { return false; } }
private static void CreateFamilyDiscount(EGOEntities _EGOEntities) { List <FAMILY> Familys = _EGOEntities.FAMILY.ToList(); foreach (var Family in Familys) { if (Family.PERSON.Count > 1) { DISCOUNT Discount = new DISCOUNT(); Discount.FAMILYID = Family.FAMILYID; Discount.DISCOUNTYEAR = Common.CurrentStartYear(); Discount.DESCRIPTION = "Réduction familiale"; Discount.AMOUNT = 10; _EGOEntities.DISCOUNT.Add(Discount); } } }
public OrderBag BuyCart(CartBag cartBag, IProductProvider provider) { cartBag.CartItems.ForEach(a => { //---------查询折扣和价格------------------ const double PRICE = -999; const string BENEFITDESC = ""; const double DISCOUNT = 1; //---------查询折扣和价格------------------ Order.order_item.Add(new order_item() { OrderID = Order.OrderID, ProductID = a.ProductId, SellOrderItemID = Order.OrderID + "-" + a.ProductId, Num = a.Num, PriceInOrder = provider.GetPromotionPrice(_dataContext, a.ProductId).EncodeingPrice(), TotalPrice = (a.Num * provider.GetPromotionPrice(_dataContext, a.ProductId)).EncodeingPrice(), BenefitDesc = BENEFITDESC, Discount = DISCOUNT.EncodeingPrice() }); }); return(this); }
protected object GetObjectById(int _id, bool _master, string _slaveType, string _masterType) { switch (typeof(T).Name) { case "FAMILY": FAMILY family = null; if (_id == 0) { family = egoEntities.FAMILY.FirstOrDefault(); } else { family = egoEntities.FAMILY.FirstOrDefault(x => x.FAMILYID == _id); } return(family == null ? new FAMILY() : family); case "PERSON": PERSON person = null; if (_master) { person = _id == 0 ? egoEntities.PERSON.FirstOrDefault() : egoEntities.PERSON.FirstOrDefault(x => x.PERSONID == _id); } else { if (_masterType == "GYMGROUP") { PERSON_GYMGROUP person_gymGroup = new PERSON_GYMGROUP(); person_gymGroup = _id == 0 ? egoEntities.PERSON_GYMGROUP.FirstOrDefault() : egoEntities.PERSON_GYMGROUP.FirstOrDefault(x => x.PERSON_GYMGROUP_ID == _id); return(person_gymGroup == null ? new PERSON_GYMGROUP() : person_gymGroup); } else if (_masterType == "FAMILY") { person = _id == 0 ? egoEntities.PERSON.FirstOrDefault() : egoEntities.PERSON.FirstOrDefault(x => x.PERSONID == _id); } } return(person == null ? new PERSON() : person); case "PHONE": PHONE Phone = null; Phone = _id == 0 ? egoEntities.PHONE.FirstOrDefault() : egoEntities.PHONE.FirstOrDefault(x => x.PHONEID == _id); return(Phone == null ? new PHONE() : Phone); case "DISCOUNT": DISCOUNT Discount = null; Discount = _id == 0 ? egoEntities.DISCOUNT.FirstOrDefault() : egoEntities.DISCOUNT.FirstOrDefault(x => x.DISCOUNTID == _id); return(Discount == null ? new DISCOUNT() : Discount); case "PAYMENT": PAYMENT Payment = null; Payment = _id == 0 ? egoEntities.PAYMENT.FirstOrDefault() : egoEntities.PAYMENT.FirstOrDefault(x => x.PAYMENTID == _id); return(Payment == null ? new PAYMENT() : Payment); case "DOCUMENT": DOCUMENT Document = null; Document = _id == 0 ? egoEntities.DOCUMENT.FirstOrDefault() : egoEntities.DOCUMENT.FirstOrDefault(x => x.DOCUMENTID == _id); return(Document == null ? new DOCUMENT() : Document); case "GYMGROUP": if (_master) { GYMGROUP GymGroup = null; GymGroup = _id == 0 ? egoEntities.GYMGROUP.FirstOrDefault() : egoEntities.GYMGROUP.FirstOrDefault(x => x.GYMGROUPID == _id); return(GymGroup == null ? new GYMGROUP() : GymGroup); } else { PERSON_GYMGROUP Person_GymGroup = new PERSON_GYMGROUP(); Person_GymGroup = _id == 0 ? egoEntities.PERSON_GYMGROUP.FirstOrDefault() : egoEntities.PERSON_GYMGROUP.First(x => x.PERSON_GYMGROUP_ID == _id); return(Person_GymGroup == null ? new PERSON_GYMGROUP() : Person_GymGroup); } } return(null); }
private static void CreatePerson(List <ExcelModel> _ExcelModel, EGOEntities _EGOEntities, FrmSetting _FrmSetting) { _FrmSetting.progressBar.Value = 0; _FrmSetting.progressBar.Maximum = _ExcelModel.Count; int i = 0; try { foreach (var ExcelModel in _ExcelModel) { i++; _FrmSetting.label1.Text = "Création de l'adhérent:" + ExcelModel.NOM + " " + ExcelModel.PRENOM + i + "/" + _ExcelModel.Count; _FrmSetting.label1.Refresh(); _FrmSetting.progressBar.Value = i; _FrmSetting.progressBar.Refresh(); FAMILY Family; if (!_EGOEntities.FAMILY.Any(x => x.LASTNAME == ExcelModel.NOM && x.ZIPCODE == ExcelModel.CP)) { Family = CreateFamily(ExcelModel, _EGOEntities); } else { Family = _EGOEntities.FAMILY.First(x => x.LASTNAME == ExcelModel.NOM && x.ZIPCODE == ExcelModel.CP); } PERSON Person = new PERSON(); Person.FAMILYID = Family.FAMILYID; Person.LASTNAME = ExcelModel.NOM.ToUpper(); Person.FIRSTNAME = ExcelModel.PRENOM.ToUpper(); Person.BIRTHDATE = ExcelModel.NEELE; Person.HOURLYRATE = 0; _EGOEntities.PERSON.Add(Person); GYMGROUP GymGroup; if (!_EGOEntities.GYMGROUP.Any(x => x.GYMGROUPNAME == ExcelModel.GROUPE)) { GymGroup = CreateGymGroup(ExcelModel, _EGOEntities); } else { GymGroup = _EGOEntities.GYMGROUP.First(x => x.GYMGROUPNAME == ExcelModel.GROUPE); } PERSON_GYMGROUP Person_GymGroup = new PERSON_GYMGROUP(); Person_GymGroup.GYMGROUPID = GymGroup.GYMGROUPID; Person_GymGroup.PERSONID = Person.PERSONID; Person_GymGroup.KINDID = 1; _EGOEntities.PERSON_GYMGROUP.Add(Person_GymGroup); if (!_EGOEntities.PHONE.Any(x => x.FAMILYID == Family.FAMILYID && x.PHONENUMBER == ExcelModel.TELEPHONE)) { PHONE Phone = new PHONE(); Phone.FAMILYID = Family.FAMILYID; Phone.PHONENUMBER = ExcelModel.TELEPHONE; _EGOEntities.PHONE.Add(Phone); } if (!_EGOEntities.PHONE.Any(x => x.FAMILYID == Family.FAMILYID && x.PHONENUMBER == ExcelModel.PORTABLE)) { PHONE Phone = new PHONE(); Phone.FAMILYID = Family.FAMILYID; Phone.PHONENUMBER = ExcelModel.PORTABLE; _EGOEntities.PHONE.Add(Phone); } DOCUMENT Document; if (ExcelModel.FICHE) { Document = new DOCUMENT(); Document.DOCUMENTTYPEID = 1; Document.PERSONID = Person.PERSONID; Document.DOCUMENTYEAR = Common.CurrentStartYear(); _EGOEntities.DOCUMENT.Add(Document); } if (ExcelModel.AUTPAR) { Document = new DOCUMENT(); Document.DOCUMENTTYPEID = 2; Document.PERSONID = Person.PERSONID; Document.DOCUMENTYEAR = Common.CurrentStartYear(); _EGOEntities.DOCUMENT.Add(Document); } if (ExcelModel.PHOTO) { Document = new DOCUMENT(); Document.DOCUMENTTYPEID = 3; Document.PERSONID = Person.PERSONID; Document.DOCUMENTYEAR = Common.CurrentStartYear(); _EGOEntities.DOCUMENT.Add(Document); } if (ExcelModel.CM) { Document = new DOCUMENT(); Document.DOCUMENTTYPEID = 4; Document.PERSONID = Person.PERSONID; Document.DOCUMENTYEAR = Common.CurrentStartYear(); _EGOEntities.DOCUMENT.Add(Document); } PAYMENT Payment; if (ExcelModel.ECH1MONTANT != 0) { Payment = new PAYMENT(); if (ExcelModel.ECH1NUMCHEQUE != 0) { Payment.PAYMENTTYPEID = 2; } else { Payment.PAYMENTTYPEID = 1; } Payment.FAMILYID = Family.FAMILYID; Payment.GYMYEAR = Common.CurrentStartYear(); Payment.PAYMENTDATE = DateTime.ParseExact("30/09/2020", "dd/MM/yyyy", CultureInfo.InvariantCulture); Payment.CHECKNUMBER = ExcelModel.ECH1NUMCHEQUE; Payment.AMOUNT = ExcelModel.ECH1MONTANT; _EGOEntities.PAYMENT.Add(Payment); } if (ExcelModel.ECH2MONTANT != 0) { Payment = new PAYMENT(); if (ExcelModel.ECH2NUMCHEQUE != 0) { Payment.PAYMENTTYPEID = 2; } else { Payment.PAYMENTTYPEID = 1; } Payment.FAMILYID = Family.FAMILYID; Payment.GYMYEAR = Common.CurrentStartYear(); Payment.PAYMENTDATE = DateTime.ParseExact("30/11/2020", "dd/MM/yyyy", CultureInfo.InvariantCulture); Payment.CHECKNUMBER = ExcelModel.ECH2NUMCHEQUE; Payment.AMOUNT = ExcelModel.ECH2MONTANT; _EGOEntities.PAYMENT.Add(Payment); } if (ExcelModel.ECH3MONTANT != 0) { Payment = new PAYMENT(); if (ExcelModel.ECH3NUMCHEQUE != 0) { Payment.PAYMENTTYPEID = 2; } else { Payment.PAYMENTTYPEID = 1; } Payment.FAMILYID = Family.FAMILYID; Payment.GYMYEAR = Common.CurrentStartYear(); Payment.PAYMENTDATE = DateTime.ParseExact("28/02/2021", "dd/MM/yyyy", CultureInfo.InvariantCulture); Payment.CHECKNUMBER = ExcelModel.ECH3NUMCHEQUE; Payment.AMOUNT = ExcelModel.ECH3MONTANT; _EGOEntities.PAYMENT.Add(Payment); } if (ExcelModel.ECH4MONTANT != 0) { Payment = new PAYMENT(); if (ExcelModel.ECH4NUMCHEQUE != 0) { Payment.PAYMENTTYPEID = 2; } else { Payment.PAYMENTTYPEID = 1; } Payment.FAMILYID = Family.FAMILYID; Payment.GYMYEAR = Common.CurrentStartYear(); Payment.PAYMENTDATE = DateTime.ParseExact("30/04/2021", "dd/MM/yyyy", CultureInfo.InvariantCulture); Payment.CHECKNUMBER = ExcelModel.ECH4NUMCHEQUE; Payment.AMOUNT = ExcelModel.ECH4MONTANT; _EGOEntities.PAYMENT.Add(Payment); } if (ExcelModel.COTISLICENCE != 0) { Payment = new PAYMENT(); Payment.PAYMENTTYPEID = 2; Payment.FAMILYID = Family.FAMILYID; Payment.GYMYEAR = Common.CurrentStartYear(); Payment.PAYMENTDATE = DateTime.ParseExact("28/09/2020", "dd/MM/yyyy", CultureInfo.InvariantCulture); Payment.CHECKNUMBER = ExcelModel.ECH4NUMCHEQUE; Payment.AMOUNT = ExcelModel.COTISLICENCE; _EGOEntities.PAYMENT.Add(Payment); } if (!ExcelModel.Nouvelle) { DISCOUNT Discount = new DISCOUNT(); Discount.FAMILYID = Family.FAMILYID; Discount.DISCOUNTYEAR = Common.CurrentStartYear(); Discount.DESCRIPTION = "Cotisation"; Discount.AMOUNT = 35; _EGOEntities.DISCOUNT.Add(Discount); Discount = new DISCOUNT(); Discount.FAMILYID = Family.FAMILYID; Discount.DISCOUNTYEAR = Common.CurrentStartYear(); Discount.DESCRIPTION = "Ancienneté"; Discount.AMOUNT = ExcelModel.REDUCANCIEN; _EGOEntities.DISCOUNT.Add(Discount); } _EGOEntities.SaveChanges(); } _FrmSetting.label1.Text = "Création des réductions familiales"; CreateFamilyDiscount(_EGOEntities); _EGOEntities.SaveChanges(); _FrmSetting.label1.Text = "Fin"; _FrmSetting.progressBar.Value = 0; } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }