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); }