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();
}
}
