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;
}
public StockInShopData GetStockInData(double stockIn)
{
StockInShopData data = new StockInShopData();
DALObj.GetDataByLOID(stockIn, null);
data.CODE = DALObj.CODE;
data.CREATEBY = DALObj.CREATEBY;
data.GRANDTOT = DALObj.GRANDTOT;
data.LOID = DALObj.LOID;
data.RECEIVEDATE = DALObj.RECEIVEDATE;
data.RECEIVER = DALObj.RECEIVER;
data.REFLOID = DALObj.REFLOID;
data.REMARK = DALObj.REMARK;
data.SENDER = DALObj.SENDER;
data.STATUS = DALObj.STATUS;
data.REQUISITIONCODE = DALObj.REFCODE;
//StockOutDAL sDAL = new StockOutDAL();
//sDAL.TableName = "STOCKOUT" + Constz.ABBSERV + "";
//sDAL.GetDataByLOID(DALObj.REFLOID, null);
//RequisitionDAL rDAL = new RequisitionDAL();
//rDAL.TableName = "REQUISITION" + Constz.ABBSERV + "";
//rDAL.GetDataByLOID(sDAL.REFLOID, null);
//data.REQUISITIONCODE = rDAL.CODE;
DataTable dt = SearchObj.GetStockInProductList(stockIn);
int i = 1;
foreach (DataRow dRow in dt.Rows)
{
dRow["ORDERNO"] = i;
i += 1;
}
data.ITEM = dt;
return data;
}
public StockInShopData GetStockOutData(double 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;
}
private void SetData(StockInShopData data)
{
this.txtRequisitionCode.Text = data.REQUISITIONCODE;
this.txtLOID.Text = data.LOID.ToString();
this.txtReceiver.Text = "3";
this.txtSender.Text = "1";
this.txtStatus.Text = data.STATUS;
this.txtCode.Text = data.CODE;
this.txtReceiveDate.Text = data.RECEIVEDATE.ToString(Constz.DateFormat);
this.dtpReceiveDate.Value = data.RECEIVEDATE;
this.txtCreateBy.Text = data.CREATEBY;
this.txtGrandTot.Text = data.GRANDTOT.ToString(Constz.DblFormat);
this.txtRemark.Text = data.REMARK;
this.grvStockin.Rows.Clear();
for (int i = 0; i < data.ITEM.Rows.Count; ++i)
{
DataRow itemRow = data.ITEM.Rows[i];
DataGridViewRow gRow = (DataGridViewRow)this.grvStockin.Rows[this.grvStockin.NewRowIndex].Clone();
gRow.Cells[indexPRODUCT].Value = Convert.ToDouble(itemRow["PRODUCT"]);
gRow.Cells[indexUNIT].Value = Convert.ToDouble(itemRow["UNIT"]);
gRow.Cells[indexORDERNO].Value = i + 1;
gRow.Cells[indexBARCODE].Value = itemRow["BARCODE"].ToString();
gRow.Cells[indexNAME].Value = itemRow["NAME"].ToString();
gRow.Cells[indexQTY].Value = Convert.ToDouble(itemRow["QTY"]);
gRow.Cells[indexUNITNAME].Value = itemRow["UNITNAME"].ToString();
gRow.Cells[indexPRICE].Value = Convert.ToDouble(itemRow["PRICE"]);
gRow.Cells[indexNETPRICE].Value = Convert.ToDouble(itemRow["PRICE"]) * Convert.ToDouble(itemRow["QTY"]);
gRow.Cells[indexORDERNO].ReadOnly = true;
gRow.Cells[indexNAME].ReadOnly = true;
gRow.Cells[indexUNITNAME].ReadOnly = true;
gRow.Cells[indexPRICE].ReadOnly = true;
gRow.Cells[indexNETPRICE].ReadOnly = true;
this.grvStockin.Rows.Add(gRow);
}
if (data.STATUS != Constz.Requisition.Status.Waiting.Code)
{
this.btnSave.Visible = false;
this.btnSubmit.Visible = false;
this.txtRequisitionCode.ReadOnly = true;
this.txtRequisitionCode.Enabled = false;
Appz.FormatDataGridView(this.grvStockin, false, false, true);
this.grvStockin.Columns[indexSEARCH].Visible = false;
}
else
{
Appz.FormatDataGridView(this.grvStockin, true, true, false);
}
}
