public DataTable GetStockOutList(ToDoListStockOutData data)
{
string where = "";
if (data.CODE.Trim() != "")
where += (where == "" ? "" : "AND ") + "UPPER(CODE) LIKE '%" + data.CODE.Trim().ToUpper() + "%' ";
if (data.REQDATE.Year != 1)
where += (where == "" ? "" : "AND ") + "TO_DATE(REQDATE, 'DDMMYYYY') = " + OracleDB.QRDate(data.REQDATE) + " ";
if (data.REQUISITIONTYPE != 0)
where += (where == "" ? "" : "AND ") + "REQUISITIONTYPE = " + data.REQUISITIONTYPE.ToString() + " ";
if (data.PRODUCTNAME.Trim() != "")
where += (where == "" ? "" : "AND ") + "UPPER(PRODUCTNAME) 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 DISTINCT LOID, REQUISITIONTYPE, TYPENAME, CODE, REQDATE, WAREHOUSE, CREATEON, STOID, STOCODE, SENDERNAME, SENDER, ";
sql += "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_STOCKOUT ";
sql += (where == "" ? "" : " WHERE ") + where;
sql += "ORDER BY TYPENAME, CODE, STOCODE ";
return OracleDB.ExecListCmd(sql);
}
private ToDoListStockOutData GetSearchData()
{
ToDoListStockOutData data = new ToDoListStockOutData();
data.CODE = this.txtCode.Text.Trim();
data.REQDATE = this.dtpReqDate.DateValue;
data.REQUISITIONTYPE = Convert.ToDouble(this.cmbRequisitionType.SelectedItem.Value);
data.PRODUCTNAME = this.txtProductName.Text.Trim();
data.STATUS = this.cmbStatus.SelectedItem.Value;
data.WAREHOUSE = Authz.CurrentUserInfo.Warehouse;
return data;
}
public DataTable GetStockOutkList(ToDoListStockOutData data)
{
return DALObj.GetStockOutList(data);
}
