public void CreatePrintPreView(int Order_ID)
{
try
{
List <OrderListModel> lsOrder = new List <OrderListModel>();
string sql_Product_Report = "select a.*,b.*,c.Product_Name from Product_Order_Report a " +
" Inner join Product_Order_Report_Details b " +
" ON a.Order_ID = b.Order_ID " +
" Inner join V_PRODUCT_MONITOR_PROPERTIES c " +
" ON c.Product_Code = b.Product_Code " +
" where a.Order_ID = " + Order_ID + " " +
" ORDER BY b.List_Num_Order ";
using (SqlConnection cnn = new SqlConnection(Utility.ConnectionDb.connectString))
{
cnn.Open();
using (SqlCommand cmd = new SqlCommand(sql_Product_Report, cnn))
{
using (SqlDataReader data = cmd.ExecuteReader())
{
while (data.Read())
{
OrderListModel order = new OrderListModel();
order.CreateDate = data["CreateDate"].ToString();
order.List_Num_Order = data["List_Num_Order"].ToString();
order.MinumunStock = Convert.ToDouble(data["Min_Stock"].ToString());
order.Product_code = data["Product_Code"].ToString();
order.Product_Name = data["Product_Name"].ToString();
order.ReaminTD = Convert.ToDouble(data["TD_QTY"].ToString());
order.RemainLP = Convert.ToDouble(data["LP_QTY"].ToString());
order.RemainAll = Convert.ToDouble(data["TOTAL_QTY"].ToString());
order.Suggest_Order = Convert.ToDouble(data["Suggest_Order"].ToString());
order.ToOwner = data["Order_to"].ToString();
order.Topic = data["Vendor"].ToString();
order.Use = data["Operation_Detail"].ToString();
order.Note_Vendor = data["Note_Vendor"].ToString();
order.Purchase_Name = data["Purchase_Name"].ToString();
order.AccountCode = "ราคาตั้ง : ";
order.PUnit_Name = data["PUnit_Name"].ToString();
order.SUnit_Name = data["SUnit_Name"].ToString();
order.CreateTimestamp = data["CreateTimestamp"].ToString();
lsOrder.Add(order);
}
}
}
}
PrintDocOrderReportForm print = new PrintDocOrderReportForm();
print.print_Preview(lsOrder);
}
catch (Exception ex)
{
log.Error(ex);
}
}
private void button_Click(object sender, RoutedEventArgs e)
{
PrintDocOrderReportForm ui = new PrintDocOrderReportForm();
//ui.print_Preview();
}
