public void UpdateStockTakingEntry(StockTakingDetailDTO dtoUpdate)
{
Database db = m_db;
DataRequest req = new DataRequest();
req.CommandText = "S_STK030_UpdateStockTakingEntry";
req.Parameters.Add("@pDtm_StockTakingDate", dtoUpdate.STOCK_TAKING_DATE);
req.Parameters.Add("@pNum_ID", dtoUpdate.ID);
if (dtoUpdate.COUNT_QTY == null)
{
req.Parameters.Add("@pNum_CountQty", DBNull.Value);
}
else
{
req.Parameters.Add("@pNum_CountQty", dtoUpdate.COUNT_QTY);
}
//req.Parameters.Add("@pVar_ExternalLotNo", dtoUpdate.EXTERNAL_LOT_NO);
req.Parameters.Add("@pInt_EffectInventoryFlag", dtoUpdate.EFFECT_INVENTORY_FLAG);
req.Parameters.Add("@pVar_FGNo", dtoUpdate.FG_NO);
req.Parameters.Add("@pVar_TagNo", dtoUpdate.TAG_NO);
req.Parameters.Add("@pVar_Remark", dtoUpdate.REMARK);
req.Parameters.Add("@pVar_UpdateBy", dtoUpdate.UPD_BY);
req.Parameters.Add("@pVar_UpdateMachine", dtoUpdate.UPD_MACHINE);
req.CommandType = System.Data.CommandType.StoredProcedure;
db.ExecuteNonQuery(req);
}
public void InsertStockTakingEntry(StockTakingDetailDTO dtoInsert)
{
Database db = m_db;
DataRequest req = new DataRequest();
req.CommandText = "S_STK030_InsertStockTakingEntry";
req.Parameters.Add("@pDtm_StockTakingDate", dtoInsert.STOCK_TAKING_DATE);
req.Parameters.Add("@pVar_ItemCode", dtoInsert.ITEM_CD);
req.Parameters.Add("@pVar_LocationCode", dtoInsert.LOC_CD);
req.Parameters.Add("@pVar_LotNo", dtoInsert.LOT_NO);
req.Parameters.Add("@pVar_ExternalLotNo", dtoInsert.EXTERNAL_LOT_NO);
req.Parameters.Add("@pVar_PackNo", dtoInsert.PACK_NO);
req.Parameters.Add("@pVar_FGNo", dtoInsert.FG_NO);
req.Parameters.Add("@pNum_CountQty", dtoInsert.COUNT_QTY);
req.Parameters.Add("@pInt_EffectInventoryFlag", dtoInsert.EFFECT_INVENTORY_FLAG);
req.Parameters.Add("@pInt_ManualAddFlag", dtoInsert.MANUAL_ADD_FLAG);
req.Parameters.Add("@pVar_TagNo", dtoInsert.TAG_NO);
req.Parameters.Add("@pVar_Remark", dtoInsert.REMARK);
req.Parameters.Add("@pVar_UpdateBy", dtoInsert.UPD_BY);
req.Parameters.Add("@pVar_UpdateMachine", dtoInsert.UPD_MACHINE);
req.CommandType = System.Data.CommandType.StoredProcedure;
db.ExecuteNonQuery(req);
}
public void DeleteStockTakingEntry(StockTakingDetailDTO dtoDelete)
{
Database db = m_db;
DataRequest req = new DataRequest();
req.CommandText = "S_STK030_DeleteStockTakingEntry";
req.Parameters.Add("@pDtm_StockTakingDate", dtoDelete.STOCK_TAKING_DATE);
req.Parameters.Add("@pNum_ID", dtoDelete.ID);
req.Parameters.Add("@pVar_UpdateBy", dtoDelete.UPD_BY);
req.Parameters.Add("@pVar_UpdateMachine", dtoDelete.UPD_MACHINE);
req.CommandType = System.Data.CommandType.StoredProcedure;
db.ExecuteNonQuery(req);
}
