private ABB.Data.Search.StockOutProductSearchData GetSearchData() { ABB.Data.Search.StockOutProductSearchData data = new ABB.Data.Search.StockOutProductSearchData(); data.REQUISITIONCODEFROM = this.txtCodeFrom.Text.Trim(); data.REQUISITIONCODETO = this.txtCodeTo.Text.Trim(); data.RESERVEDATEFROM = this.dtpDateFrom.Value.Date; data.RESERVEDATETO = this.dtpDateTo.Value.Date; return data; }
public StockInShopData GetStockOutData(string requisitionCode, double currentStockIn) { double stockOut = 0; ABB.Data.Search.StockOutProductSearchData searchData = new ABB.Data.Search.StockOutProductSearchData(); searchData.REQUISITIONCODEFROM = requisitionCode; searchData.REQUISITIONCODETO = requisitionCode; DataTable dtSearch = GetStockOutList(searchData, currentStockIn); if (dtSearch.Rows.Count == 1) { stockOut = Convert.ToDouble(dtSearch.Rows[0]["STOCKOUT"]); } StockInShopData data = new StockInShopData(); StockOutDAL sDAL = new StockOutDAL(); sDAL.TableName = "STOCKOUT" + Constz.ABBSERV + ""; sDAL.GetDataByLOID(stockOut, null); data.CODE = sDAL.CODE; data.RECEIVER = sDAL.RECEIVER; data.REFLOID = sDAL.LOID; data.SENDER = sDAL.RECEIVER; RequisitionDAL rDAL = new RequisitionDAL(); rDAL.TableName = "REQUISITION" + Constz.ABBSERV + ""; rDAL.GetDataByLOID(sDAL.REFLOID, null); data.REQUISITIONCODE = rDAL.CODE; DataTable dt = SearchObj.GetStockOutProductList(stockOut); int i = 1; foreach (DataRow dRow in dt.Rows) { dRow["ORDERNO"] = i; i += 1; } data.ITEM = dt; return data; }