public JsonResult GetOrder(DataTableParameters dataTableParameters, string from, string to, string cust_id, string status)
{
ORDERED order = new ORDERED();
var resultSet = new DataTableResultSet();
resultSet.draw = dataTableParameters.Draw;
var lst = order.SelectPaging(dataTableParameters.Start + 1,
dataTableParameters.Start + dataTableParameters.Length + 1, from, to, cust_id, status);
resultSet.recordsTotal = resultSet.recordsFiltered = order.GetCount(from, to, cust_id, status);
CUSTOMER cus = new CUSTOMER();
foreach (var i in lst)
{
END_USER end = cus.GetEndUserById(i.END_USER);
var columns = new List <string>();
columns.Add("<input type='checkbox' class='ckb' id='" + i.ID + "' data-cus='" + i.CUSTOMER_ID + "' data-emp='" + i.EMP_ID + "' />");
columns.Add(i.ORDED_DATE.ToShortDateString());
columns.Add(i.CUSTOMER_ID);
columns.Add(i.NAME);
columns.Add(end == null ? i.NAME.Trim() : end.NAME.Trim());
columns.Add(i.ORDER_CR_HR);
columns.Add(i.STS_ST_CLS);
columns.Add(i.STS_ST_SER);
columns.Add(i.SURFACE_CD);
columns.Add(i.ORD_THK == null ? "" : Math.Round(Convert.ToDouble(i.ORD_THK), 2, MidpointRounding.ToEven).ToString());
columns.Add(i.ORD_WTH == null ? "" : Math.Round(Convert.ToDouble(i.ORD_WTH), 2, MidpointRounding.ToEven).ToString());
columns.Add(i.ORD_EDGE == null ? "" : i.ORD_EDGE.ToString());
columns.Add(i.QUANTITY == null ? "" : Math.Round(Convert.ToDouble(i.QUANTITY), 2, MidpointRounding.ToEven).ToString());
//columns.Add(i.ORD_WGT == null ? "" : i.ORD_WGT.ToString());
columns.Add(i.BASE_PRICE == null ? "" : Math.Round(Convert.ToDouble(i.BASE_PRICE), 2, MidpointRounding.ToEven).ToString());
columns.Add(i.EFFECT_PRICE == null ? "" : Math.Round(Convert.ToDouble(i.EFFECT_PRICE), 2, MidpointRounding.ToEven).ToString());
columns.Add(i.BIDD_PRICE == null ? "" : Math.Round(Convert.ToDouble(i.BIDD_PRICE), 2, MidpointRounding.ToEven).ToString());
columns.Add(i.CONTRACT_NO == null ? "" : i.CONTRACT_NO.ToString());
columns.Add(i.ORD_USAGE);
columns.Add(i.ORD_STAT);
columns.Add(i.EMP_NAME.Trim());
columns.Add(i.DELIVERY_TIME == null ? "" : i.DELIVERY_TIME.Trim());
columns.Add(i.REMARK == null ? "" : i.REMARK.Trim());
columns.Add(i.CREATE_AT == null ? "" : i.CREATE_AT.ToString());
resultSet.data.Add(columns);
}
return(Json(resultSet));
}
