private void GetMainDataGridContent()
{
ProductOrderReportDetailsSearchModel search = new ProductOrderReportDetailsSearchModel();
search.Product_Code = txtProductId.Text;
search.Operation_Detail = txtProductName.Text;
search.Order_ID = txtOrderNumber.Text;
search.Order_to = txtOwner.Text;
search.Vendor = txtVender.Text;
search.OrderDateFrom = ChangeToThaiCulture(dpOrderFrom.SelectedDate);
search.OrderDateTo = ChangeToThaiCulture(dpOrderTo.SelectedDate);
search.OrderCloseDateFrom = ChangeToThaiCulture(dpOrderCloseFrom.SelectedDate);
search.OrderCloseDateTo = ChangeToThaiCulture(dpOrderCloseTo.SelectedDate);
if (rdoStatusAll.IsChecked == true)
{
search.OrderStatus = "";
}
if (rdoStatusWait.IsChecked == true)
{
search.OrderStatus = "0";
}
if (rdoStatusClose.IsChecked == true)
{
search.OrderStatus = "1";
}
dgFollowCard.ItemsSource = null;
dgMainContent.ItemsSource = jctc.GetProductOrderReportDetails(search);
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
var warningList = jctc.GetProductOrderReportWaring();
if (warningList.Count > 0)
{
JobCardWarning jcw = new JobCardWarning();
jcw.ShowDialog();
}
ProductOrderReportDetailsSearchModel search = new ProductOrderReportDetailsSearchModel();
search.OrderStatus = "0";
dgMainContent.ItemsSource = jctc.GetProductOrderReportDetails(search);
}
public List <ProductOrderReportDetailsModel> GetProductOrderReportDetails(ProductOrderReportDetailsSearchModel search)
{
string sql = query.PRODUCT_ORDER_REPORT_DETAILS_LIST;
if (search != null)
{
sql += !search.Product_Code.Equals("") ?
string.Format(" AND PORD.Product_Code LIKE '%{0}%' ", search.Product_Code) : "";
sql += !search.Operation_Detail.Equals("") ?
string.Format(" AND PORD.Operation_Detail LIKE '%{0}%' ", search.Operation_Detail) : "";
sql += !search.Order_ID.Equals("") ?
string.Format(" AND FORMAT(PORD.Order_ID, '0000') LIKE '%{0}%' ", search.Order_ID) : "";
sql += !search.Order_to.Equals("") ?
string.Format(" AND PORD.Order_to LIKE '%{0}%' ", search.Order_to) : "";
sql += !search.Vendor.Equals("") ?
string.Format(" AND PORD.Vendor LIKE '%{0}%' ", search.Vendor) : "";
sql += !search.OrderDateFrom.Equals("") ?
string.Format(" AND CAST(POR.CreateDate AS DATE) >= FORMAT(CONVERT(DATE,'{0}',103), 'yyyyMMdd') ", search.OrderDateFrom) : "";
sql += !search.OrderDateTo.Equals("") ?
string.Format(" AND CAST(POR.CreateDate AS DATE) <= FORMAT(CONVERT(DATE,'{0}',103), 'yyyyMMdd') ", search.OrderDateTo) : "";
sql += !search.OrderCloseDateFrom.Equals("") ?
string.Format(" AND CAST(PORD.closeDate AS DATE) >= FORMAT(CONVERT(DATE,'{0}',103), 'yyyyMMdd') ", search.OrderCloseDateFrom) : "";
sql += !search.OrderCloseDateTo.Equals("") ?
string.Format(" AND CAST(PORD.closeDate AS DATE) <= FORMAT(CONVERT(DATE,'{0}',103), 'yyyyMMdd') ", search.OrderCloseDateTo) : "";
sql += !search.OrderStatus.Equals("") ?
string.Format(" AND PORD.Order_Status = {0} ", search.OrderStatus) : "";
}
log.Debug("SQL[PRODUCT ORDERREPORT DETAILS LIST] : " + sql);
List <ProductOrderReportDetailsModel> orderReportList = new List <ProductOrderReportDetailsModel>();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
log.Debug("Connect to Sqlserver success.");
using (SqlCommand sqlcmd = new SqlCommand(sql, conn))
{
using (SqlDataReader dataReader = sqlcmd.ExecuteReader())
{
while (dataReader.Read())
{
ProductOrderReportDetailsModel model = new ProductOrderReportDetailsModel();
model.Order_Detail_ID = Convert.ToInt32(dataReader["Datail_ID"]);
model.RowNo = Convert.ToInt32(dataReader["RowNo"]);
model.CreateDate = dataReader["CreateDate"].ToString().Trim();
model.Order_ID = dataReader["Order_ID"].ToString().Trim();
model.OrderDayCount = dataReader["OrderDayCount"].ToString().Trim();
model.Order_to = dataReader["Order_to"].ToString().Trim();
model.Product_Code = dataReader["Product_Code"].ToString().Trim();
model.Operation_Detail = dataReader["Operation_Detail"].ToString().Trim();
model.Vendor = dataReader["Vendor"].ToString().Trim();
model.Suggest_Order = dataReader["Suggest_Order"].ToString().Trim();
model.Min_Stock = dataReader["Min_Stock"].ToString().Trim();
model.TD_QTY = dataReader["TD_QTY"].ToString().Trim();
model.LP_QTY = dataReader["LP_QTY"].ToString().Trim();
model.TOTAL_QTY = dataReader["TOTAL_QTY"].ToString().Trim();
model.Order_Status = Convert.ToInt32(dataReader["Order_Status"]) == 0 ? false : true;
model.Note_Close = dataReader["Note_Close"].ToString().Trim();
model.closeDate = dataReader["closeDate"].ToString().Trim();
orderReportList.Add(model);
}
}
}
}
log.Debug("Disconnect to Sqlserver.");
}
catch (Exception ex)
{
log.Error("Error", ex);
throw ex;
}
return(orderReportList);
}
