private void datagrid_SelectionChanged(object sender, System.Windows.Controls.SelectionChangedEventArgs e)
{
log.Debug("Datagrid selected.");
try
{
//History Purchase
string sqlVendorHis = "SELECT PRODUCT_CODE,PURCHASE_DATE,VENDOR_CODE,VENDOR_NAME,QTY,PRICE,DISCOUNT_STR,VAT_RATE FROM V_PURCHASE_HISTORY_ATF where 1=1 ";
string cond = "";
string groupby = " GROUP BY PRODUCT_CODE,PURCHASE_DATE,VENDOR_CODE,VENDOR_NAME,QTY,PRICE,DISCOUNT_STR,VAT_RATE ";
string orderBy = " ORDER BY PURCHASE_DATE DESC ";
//History Order
string sqlHisOrder = "select a.CreateDate,b.* from Product_Order_Report a"
+ " INNER JOIN Product_Order_Report_Details b "
+ " ON a.Order_ID = b.Order_ID"
+ " where 1=1 AND b.Product_Code = @Product_Code "
+ " ORDER BY CreateDate DESC,b.List_Num_Order DESC";
if (DataGridPrducts.SelectedItem != null)
{
if (DataGridPrducts.SelectedItem is ProductsModel)
{
var row = (ProductsModel)DataGridPrducts.SelectedItem;
if (row != null)
{
txtDatailSelect.Text = row.Product_Name;
txtUseDetail.Text = row.Use;
log.Debug("Insert data to Text box Success.");
cond = " AND PRODUCT_CODE = '" + (row.Product_Code.ToLower()) + "'";
sqlVendorHis += cond + groupby + orderBy;
log.Debug("Sql Vendor History : " + sqlVendorHis);
List <PurchaseHistoryModel> lsPurchaseHis = new List <PurchaseHistoryModel>();
List <OrderHistoryStock> lsOrderHisStock = new List <OrderHistoryStock>();
using (SqlConnection cnn = new SqlConnection(Utility.ConnectionDb.connectString))
{
cnn.Open();
using (SqlCommand cmd = new SqlCommand(sqlVendorHis, cnn), cmd2 = new SqlCommand(sqlHisOrder, cnn))
{
cmd2.Parameters.AddWithValue("@Product_Code", row.Product_Code.Trim());
using (SqlDataReader dataReader = cmd.ExecuteReader(), dataReader2 = cmd2.ExecuteReader())
{
int i = 0;
while (dataReader.Read())
{
PurchaseHistoryModel pch = new PurchaseHistoryModel();
pch.RowNum = ++i;
pch.PRODUCT_CODE = dataReader["PRODUCT_CODE"].ToString().Trim();
pch.PURCHASE_DATE = comm.convertIntToShortDate(dataReader["PURCHASE_DATE"].ToString().Trim());
pch.VENDOR_CODE = dataReader["VENDOR_CODE"].ToString().Trim();
pch.VENDOR_NAME = dataReader["VENDOR_NAME"].ToString().Trim();
pch.QTY = comm.convertShowNumber2Point(dataReader["QTY"].ToString());
pch.PRICE = comm.convertShowNumber2Point(dataReader["PRICE"].ToString());
pch.VAT_RATE = comm.convertShowNumber2Point(dataReader["VAT_RATE"].ToString().Trim());
pch.DISCOUNT_STR = dataReader["DISCOUNT_STR"].ToString().Trim();
lsPurchaseHis.Add(pch);
}
while (dataReader2.Read())
{
OrderHistoryStock ohs = new OrderHistoryStock();
ohs.docDate = comm.convertIntToShortDate(dataReader2["CreateDate"].ToString());
ohs.orderId = dataReader2["Order_ID"].ToString();
ohs.list_Num_Order = dataReader2["List_Num_Order"].ToString().PadLeft(4, '0');
ohs.topic = dataReader2["Vendor"].ToString();
ohs.suggestOrder = comm.convertShowNumber2Point(dataReader2["Suggest_Order"].ToString());
ohs.orderStatus = (dataReader2["Order_Status"].ToString().Equals("1")) ? "ปิดงาน" : "รอปิดงาน";
lsOrderHisStock.Add(ohs);
}
}
}
}
dataGridHistoryOrder.ItemsSource = lsOrderHisStock;
dataGridPurHis.ItemsSource = lsPurchaseHis;
log.Debug("Insert List Vendor History to Datagrid success.");
}
}
}
}
catch (Exception ex)
{
log.Error(ex);
throw ex;
}
}
