partial void DeleteOrders(Orders instance);
partial void UpdateOrders(Orders instance);
public int Insert(DeliveryModel.OrdersModel item) { s26webDataContext db = new s26webDataContext(); try { Orders orders = new Orders { VolunteersId = item.VolunteersId, Osid = DateTime.UtcNow.AddHours(8).ToString("yyyyMMddHHmm"), ProductId = item.ProductId, Order_Quantity = item.Order_Quantity, TotalPrice = item.TotalPrice, Name = item.Name, Mobile = item.Mobile, CityId = item.CityId, AreaId = item.AreaId, Address = item.Address, SharePoint= true, Remarks = item.Remarks, OrdersStates = 22, OrdersTime = DateTime.UtcNow, ReciveTimeChoice = 15, OrdersFrom = 0, }; db.Orders.InsertOnSubmit(orders); db.SubmitChanges(); Invoice invoice = new Invoice { OrdersId = db.Orders.OrderByDescending(o => o.Id).FirstOrDefault(f => f.Id != null).Id, InvoiceCategory = item.InvoiceCategory }; if (item.InvoiceCategory == db.Category.FirstOrDefault(w => w.Fun_Id == 5 && w.Memo.Equals("Invoice")).Id) { invoice.InvoiceName = item.InvoiceName; invoice.InvoiceNo = item.InvoiceNo; } db.Invoice.InsertOnSubmit(invoice); db.SubmitChanges(); db.Connection.Close(); return orders.Id; } catch { return -1; } }
partial void InsertOrders(Orders instance);
public OrdersModelShow Set_Info(Orders source) { try { OrdersModelShow rlt = new OrdersModelShow() { Id = source.Id, Osid = source.Osid, VolunteersId = source.VolunteersId.Value, OrdersProduct = source.ProductId, Quantity = source.Order_Quantity, TotalPrice = source.TotalPrice, Name = source.Name, Mobile = source.Mobile, CityId = source.CityId, AreaId = source.AreaId, Address = source.Address, SharePoint = source.SharePoint, Remarks = source.Remarks, OrdersStates = source.OrdersStates, States = Get_State(source.OrdersStates), OrdersTime = source.OrdersTime, ReciveTimeChoice = source.ReciveTimeChoice, UpdateUserId = source.UpdateUserId, }; if (rlt.UpdateUserId != null) { rlt.UpdateUserName = Get_UserName(rlt.UpdateUserId.Value); } rlt.Set_Other(); return rlt; } catch { return new OrdersModelShow(); } }