public DataTable GetMinimumStockList(ToDoListMinimumStockData data)
{
string where = "";
if (data.ORDERTYPE.Trim() != "")
where += (where == "" ? "" : "AND ") + "ORDERTYPE = '" + data.ORDERTYPE + "' ";
if (data.PRODUCTNAME.Trim() != "")
where += (where == "" ? "" : "AND ") + "UPPER(NAME) LIKE '%" + data.PRODUCTNAME.Trim().ToUpper() + "%' ";
if (data.STATUS.Trim() != "")
where += (where == "" ? "" : "AND ") + "STATUS = '" + data.STATUS + "' ";
if (data.WAREHOUSE != 0)
where += (where == "" ? "" : "AND ") + "WAREHOUSE = " + data.WAREHOUSE.ToString() + " ";
string sql = "SELECT WAREHOUSE, LOID, BARCODE, NAME, QTY, UNITNAME, LEADTIME, LOTSIZE, MINIMUM, REQUESTID, REQUESTCODE, ORDERTYPE, UNIT, REFTABLE, ";
sql += "CASE ORDERTYPE WHEN '" + Constz.OrderType.PD.Code + "' THEN '" + Constz.OrderType.PD.Name + "' ";
sql += "WHEN '" + Constz.OrderType.PO.Code + "' THEN '" + Constz.OrderType.PO.Name + "' ";
sql += "ELSE '' END ORDERTYPENAME, CASE STATUS WHEN '" + Constz.Requisition.Status.Approved.Code + "' THEN '" + Constz.Requisition.Status.Approved.Name + "' ";
sql += "WHEN '" + Constz.Requisition.Status.Finish.Code + "' THEN '" + Constz.Requisition.Status.Finish.Name + "' ";
sql += "WHEN '" + Constz.Requisition.Status.Void.Code + "' THEN '" + Constz.Requisition.Status.Void.Name + "' ";
sql += "WHEN '" + Constz.Requisition.Status.Waiting.Code + "' THEN '" + Constz.Requisition.Status.Waiting.Name + "' ";
sql += "ELSE '' END STATUS ";
sql += "FROM V_TODOLIST_WH_MINSTOCK ";
sql += (where == "" ? "" : " WHERE ") + where;
sql += "ORDER BY BARCODE, REQUESTCODE ";
return OracleDB.ExecListCmd(sql);
}
private ToDoListMinimumStockData GetSearchData()
{
ToDoListMinimumStockData data = new ToDoListMinimumStockData();
data.ORDERTYPE = this.cmbOrderType.SelectedItem.Value;
data.PRODUCTNAME = this.txtName.Text.Trim();
data.STATUS = this.cmbStatus.SelectedItem.Value;
data.WAREHOUSE = Authz.CurrentUserInfo.Warehouse;
return data;
}
public DataTable GetMinimumStockList(ToDoListMinimumStockData data)
{
return DALObj.GetMinimumStockList(data);
}