public bool DeleteOId(string OId)//#223韦 { using (var ctx = new OracleDbContext()) { try { FreightOrder F = new FreightOrder() { OrderID = OId }; ctx.FreightOrder.Attach(F); ctx.FreightOrder.Remove(F); ctx.SaveChanges(); return(true); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { System.Diagnostics.Debug.WriteLine("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } return(false); } } }
public void Upload(FreightOrder fo) { var existFo = this.Query(fo.Id); fo.NewAmount = existFo.Amount + fo.Amount; //Implement other logic here this.Update(fo); }
private void button1_Click(object sender, EventArgs e) { List <FreightOrder> freightOrders = new List <FreightOrder>(); DateTime today = new DateTime(); String dateString = Convert.ToString(today.Date); FreightOrder freightOrder; int random_id; int random_postalcode; Random random = new Random(); int amount = 1; for (int i = 0; i < amount; i++) { random_id = random.Next(1, 100000000); random_postalcode = random.Next(10000, 99999); // FreightOrder(string id, string companyName, string description, EnumFreightOrderStatus freightOrderStatus, string date, string postalCode, string country, string city, string streetName, string streetNumber, string signatureTagPacker, string feedbackPacker, List<string> photoTagsPacker, string signatureTagDriver, string feedbackDriver, List<string> photoTagsDriver) freightOrder = new FreightOrder(Convert.ToString(random_id), "Mustermann Company", "Construction Elements", EnumFreightOrderStatus.BEFORE_PACKING, dateString, Convert.ToString(random_postalcode), "Germany", "Berlin", "Mustermannstreet", "99", "sign_Packer_MaxMustermann" + Convert.ToString(random_id), "FeedbackPacker Text", "PhotoTagsPacker Tag1, Tag2, Tagn", "sign_Driver_MaxMustermann" + Convert.ToString(random_id), "FeedbackDriver Text", "PhotoTagsDriver Tag1, Tag2, Tagn"); freightOrders.Add(freightOrder); } Console.WriteLine(freightOrders); ListViewItem listViewItem_FreightOrder = new ListViewItem(); for (int i = 0; i < freightOrders.Count; i++) { listView_FreightOrders.Items.Add(freightOrders.ElementAt(i).getCompanyName() + " ID: " + freightOrders.ElementAt(i).getId()); // -----------------------------------------------------------------------------------------S Q L ---------------------------------------------------------------------------------------------------------------------- // Insert SQL Statements for transfering freightOrders to database // Example accessing ID of FreightOrder String test_id = freightOrders.ElementAt(i).getId(); con = new SqlConnection(@"data source=bsspublic.database.windows.net; Initial catalog=HTW; user id=HTW; Password=u3Q9##X6&I;"); cmd = new SqlCommand("INSERT INTO SmartLoadAppData(id,companyName, description,freightOrderStatus,date,postalCode,country,city,streetName,streetNumber,signatureTagPacker,feedbackPacker,photoTagsPacker,signatureTagDriver,feedbackDriver,photoTagsDriver) VALUES (150,'" + this.CompanyName + "','description','BEFORE_PACKING','17.06.2019','10318','Germany','Berlin',1,1,1,1,1,1,1,1)", con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); // -----------------------------------------------------------------------------------------S Q L ---------------------------------------------------------------------------------------------------------------------- } }
public bool ChangeOrder(FreightOrder F) { using (var ctx = new OracleDbContext()) { try { var FO = ctx.FreightOrder.Where(x => x.OrderID == F.OrderID).FirstOrDefault(); FO.SenderName = F.SenderName; FO.SenderPhoneNumber = F.SenderPhoneNumber; FO.SenderID = F.SenderID; FO.ReceiverName = F.ReceiverName; FO.ReceiverPhoneNumber = F.ReceiverPhoneNumber; FO.StartStation = F.StartStation; FO.CarriageNumber = F.CarriageNumber; FO.CreateDate = F.CreateDate; FO.DueDate = F.DueDate; FO.EndStation = F.EndStation; FO.OrderBill = F.OrderBill; FO.State = F.State; FO.PackgeID = F.PackgeID; FO.TrainID = F.TrainID; FO.OrderCapacity = F.OrderCapacity; ctx.SaveChanges(); return(true); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { System.Diagnostics.Debug.WriteLine("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } return(false); } } }
public IActionResult Index(string fileType, FreightOrder fo) { ModelState.Clear(); IFoStrategy stg = null; if (fileType.Equals("1")) { stg = new FoStrategyAppend(); ViewBag.Strategy = "採用策略:累加原單之數量"; } else { stg = new FoStrategyReplace(); ViewBag.Strategy = "採用策略:覆蓋原單之數量"; } stg.Query = DataAccessService.Query; stg.Update = DataAccessService.Update; updateFreightOrder(fo, stg); return(View(fo)); }
private void updateFreightOrder(FreightOrder fo, IFoStrategy stg) { stg.Upload(fo); }
public IActionResult Index() { FreightOrder fo = DataAccessService.Query(1); return(View(fo)); }
public static void Update(FreightOrder fo) { Trace.WriteLine("==>更新資料庫..."); }