//销售单
private void querySaleOrder()
{
if (this.dgvMain.SelectedRows.Count <= 0)
{
return;
}
Business.Models.DeliveryModel dm = this.dgvMain.SelectedRows[0].DataBoundItem as Business.Models.DeliveryModel;
Models.SalesOrder c = this.PharmacyDatabaseService.GetSalesOrder(out msg, dm.SalesOrderID);
Forms.SalesBusiness.FormSalesOrderEdit frm = new SalesBusiness.FormSalesOrderEdit(c, false);
frm.ShowDialog();
}
private void DiffSaleOrder()
{
if (this.dataGridView1.SelectedCells.Count <= 0)
{
return;
}
int rdx = this.dataGridView1.SelectedCells[this.dataGridView1.SelectedCells.Count - 1].RowIndex;
Models.SalesOrder c = this.PharmacyDatabaseService.GetSalesOrder(out msg, this.ListST[rdx].Id);
Forms.SalesBusiness.FormSalesOrderEdit frm = new FormSalesOrderEdit(c, true, true, Editable);
frm.ShowDialog();
}
public async Task SendToSalesOrderMessageQueue(Models.SalesOrder salesOrderData)
{
CloudStorageAccount storageAccount = CloudStorageAccount.Parse(
"DefaultEndpointsProtocol=https;AccountName=salesorderqueue;AccountKey=kz8eED0s25wezSDCyj0BmukVq2zE9puEFRVq4jIR++n8L1NNSUyAxeJXZHVN91BgsQQ9sPE2gnlsb5MWC1TsVw==;EndpointSuffix=core.windows.net");
CloudQueueClient queueClient = storageAccount.CreateCloudQueueClient();
CloudQueue queue = queueClient.GetQueueReference("salesorder");
await queue.CreateIfNotExistsAsync();
CloudQueueMessage message = new CloudQueueMessage(JsonConvert.SerializeObject(salesOrderData));
await queue.AddMessageAsync(message);
}
public List <Models.SalesOrder> GetOrdersByCondition(Models.SalesOrder arg)
{
List <Models.SalesOrder> result = new List <SalesOrder>();
result.Add(new SalesOrder()
{
OrderID = 1, CustomerID = 1, EmployeeID = 1, OrderDate = new DateTime(2018, 1, 1), RequiredDate = new DateTime(2011, 6, 10), ShippedDate = new DateTime(2011, 6, 10), ShipperID = 02555, Freight = 500, ShipCity = "hsinchu", ShipRegion = "north", ShipCountry = "china", ShipAddress = "china road 13 floor", ShipostalCode = "55156"
});
result.Add(new SalesOrder()
{
OrderID = 2, CustomerID = 2, EmployeeID = 2, OrderDate = new DateTime(2018, 1, 1), RequiredDate = new DateTime(2012, 5, 20), ShippedDate = new DateTime(2011, 6, 10), ShipperID = 02555, Freight = 500, ShipCity = "taipei", ShipRegion = "north", ShipCountry = "china", ShipAddress = "nanjing east road 13 floor", ShipostalCode = "55152"
});
return(result);
}
private void BalanceSaleOrder()
{
if (this.dataGridView1.SelectedCells.Count <= 0)
{
return;
}
int rdx = this.dataGridView1.SelectedCells[this.dataGridView1.SelectedCells.Count - 1].RowIndex;
Models.SalesOrder c = this.PharmacyDatabaseService.GetSalesOrder(out msg, this.ListST[rdx].Id);
Forms.SalesBusiness.FormSalesOrderEdit frm = new FormSalesOrderEdit(c, false);
frm.ShowDialog();
if (frm.IsBalanced)
{
this.search(this.searchMethod);
}
}
public async Task <Models.SalesOrder> Put(Models.SalesOrder Order)
{
var data = JsonConvert.SerializeObject(Order);
HttpContent content = new StringContent(data, Encoding.UTF8, "application/json");
var response = await client.PutAsync(BaseUrl, content);
if (response.IsSuccessStatusCode)
{
var result = await response.Content.ReadAsStringAsync();
Models.SalesOrder NOrder = JsonConvert.DeserializeObject <Models.SalesOrder>(result);
return(NOrder);
}
throw new Exception("Error guardar nuevo producto");
}
public void CreateSalesOrder_RepositorySaveInvoked()
{
// Arrange
var salesOrderRepository = Substitute.For <ISalesOrderRepository>();
var salesOrderService = new SalesOrderService(salesOrderRepository);
var salesOrder = new Models.SalesOrder()
{
ProductCode = "NAIL12IN",
UnitPrice = 0.23M,
Quantity = 3,
Reference = new Guid("d0d12bc2-5a1b-4147-8acb-49228ef11411")
};
// Act
salesOrderService.Create(salesOrder);
// Assert
salesOrderRepository.Received(1).Create(Arg.Is <SalesOrderEntity>(a => a.Reference == salesOrder.Reference));
}
//private Models.Product ProductDetails(string ProductName) { }
//private Models.Customer CustomerDetails(string customerName) {
// }
private async void Btn_save_Click(object sender, EventArgs e)
{
Models.SalesOrder Order = new Models.SalesOrder();
// Models.Product product = ProductDetails(CbProd.Text);
// Models.Customer ctx = CustomerDetails(CbClient.Text);
//Order.CustomerId = ctx.Id;
// Order.ProductId = product.Id;
//Order.Price= product.UnitPrice;
// Order.Amount =product.Stock;
// Order.SellerId = User.Id;
//Order.Purchase_Date = new DateTime();
Order.CustomerId = 1;
Order.ProductId = 1;
Order.Price = 12.4;
Order.Amount = 3;
Order.SellerId = 1;
Order.Purchase_Date = new DateTime();
await OrderApi.Post(Order);
}
public ActionResult SearchOrderResult(FormCollection post, Models.SalesOrder arg)
{
Models.AllService allService = new Models.AllService();
int? OrderIDint = null;
int? SelectEmployeeint = 0;
int? SelectComponyint = 0;
string OrderID = post["OrderID"];
string SelectEmployee = post["SelectEmployee"];
string SelectCompony = post["SelectCompony"];
string ContactName = post["ContactName"];
string OderDatetext = post["OderDate"];
string ShipperDatetext = post["ShipperDate"];
string RequiredDatetext = post["RequiredDate"];
//DateTime OderDate = new DateTime(1000, 1, 1);
//DateTime ShipperDate = new DateTime(1000, 1, 1);
//DateTime RequiredDate = new DateTime(1000, 1, 1);
try
{
OrderIDint = Int32.Parse(OrderID);
SelectEmployeeint = Int32.Parse(SelectEmployee);
SelectComponyint = Int32.Parse(SelectCompony);
//OderDate = DateTime.Parse(OderDatetext);
//ShipperDate = DateTime.Parse(ShipperDatetext);
//RequiredDate = DateTime.Parse(RequiredDatetext);
//String.Format("{0:yyyy/MM/dd}", OderDate);
//String.Format("{0:yyyy/MM/dd}", ShipperDate);
//String.Format("{0:yyyy/MM/dd}", RequiredDate);
}
catch (FormatException e)
{
Console.WriteLine(e.Message);
}
///待加例外處理
///var OrderResult = allService.GetOrdersByCondition(new Models.SalesOrder());
IEnumerable <Models.HrEmployees> EmployeeResult = allService.GetEmployeesByCondition(new Models.HrEmployees());
IEnumerable <Models.SalesCustomers> CustomersResult = allService.GetCustomersByCondition(new Models.SalesCustomers()
{
});
IEnumerable <Models.SalesShippers> ShiperResult = allService.GetShiperByCondition(new Models.SalesShippers());
IEnumerable <Models.SalesOrder> OrderResult = allService.GetOrdersByCondition(new Models.SalesOrder());;
IEnumerable <Models.SalesOrder> result = OrderResult;
///orderid查
if (!string.IsNullOrWhiteSpace(OrderID))
{
result = result.Where(m => OrderIDint.Equals(m.OrderID)).ToList();
}
///客戶名稱查
if (!string.IsNullOrWhiteSpace(ContactName))
{
result =
from o in result
join c in CustomersResult on o.CustomerID equals c.CustomerID
where c.CompanyName.Contains(ContactName)
select o;
///List<Models.SalesCustomers> Customername = CustomersResult.Where(m => ContactName.Contains(m.ContactName)).ToList();
///result = OrderResult.Where(m => Customername.Equals(m.CustomerID)).ToList();
}
/// 員工查
if (SelectEmployeeint != 0)
{
result = result.Where(m => SelectEmployeeint.Equals(m.EmployeeID)).ToList();
}
/// 公司查
if (SelectComponyint != 0)
{
result = result.Where(m => SelectComponyint.Equals(m.CustomerID)).ToList();
}
///// 訂購日期查
//if (OderDate !=(1000, 1, 1))
//{
// result = OrderResult.Where(m => SelectComponyint.Equals(m.CustomerID)).ToList();
//}
///// 出貨日期查
//if (SelectComponyint != 0)
//{
// result = OrderResult.Where(m => SelectComponyint.Equals(m.CustomerID)).ToList();
//}
///// 需要日期查
//if (SelectComponyint != 0)
//{
// result = OrderResult.Where(m => SelectComponyint.Equals(m.CustomerID)).ToList();
//}
ViewBag.Result = result;
ViewBag.test = OderDatetext;
return(View());
}
