public IHttpActionResult GetMatHangTheoDieuKien(MatHangViewModel.PARAM_NHAPMUA_OBJ param)
{
var result = new TransferObj <MatHangViewModel.VIEW_MODEL>();
var viewModel = new MatHangViewModel.VIEW_MODEL();
if (string.IsNullOrEmpty(param.MAHANG))
{
return(BadRequest("Mã hàng không chính xác"));
}
else
{
var unitCode = _service.GetCurrentUnitCode();
var listSearched = _service.TimKiemMatHang_NhieuDieuKien(param.MAHANG, unitCode, _service.GetConnectionString());
if (listSearched != null && listSearched.Count == 1)
{
result.Data = listSearched[0];
result.Status = true;
result.Message = "Oke";
}
else
{
result.Data = null;
result.Status = false;
result.Message = "NotFound";
}
}
return(Ok(result));
}
public IHttpActionResult GetMatHangXuatBanTheoMaKho(MatHangViewModel.PARAM_NHAPMUA_OBJ param)
{
var result = new TransferObj <MatHangViewModel.VIEW_MODEL>();
var viewModel = new MatHangViewModel.VIEW_MODEL();
if (string.IsNullOrEmpty(param.MAHANG))
{
result.Data = null;
result.Message = "NOTEXISTS_MAHANG";
result.Status = false;
}
else if (string.IsNullOrEmpty(param.MAKHO_XUAT))
{
result.Data = null;
result.Message = "NOTEXISTS_MAKHO_XUAT";
result.Status = false;
}
else if (string.IsNullOrEmpty(param.TABLE_NAME))
{
result.Data = null;
result.Message = "NOTEXISTS_TABLE_NAME";
result.Status = false;
}
else
{
var unitCode = _service.GetCurrentUnitCode();
var listSearched = _service.TimKiemMatHang_TonKho_NhieuDieuKien(param.MAHANG, unitCode, _service.GetConnectionString(), param.TABLE_NAME, param.MAKHO_XUAT);
if (listSearched != null && listSearched.Count == 1)
{
result.Data = listSearched[0];
result.Status = true;
result.Message = "Oke";
}
else
{
result.Data = null;
result.Status = false;
result.Message = "NotFound";
}
}
return(Ok(result));
}
public virtual List <MatHangViewModel.VIEW_MODEL> GetDataMatHang(string ListMatHang, string UnitCode, string StringConnect)
{
List <MatHangViewModel.VIEW_MODEL> result = new List <MatHangViewModel.VIEW_MODEL>();
if (!string.IsNullOrEmpty(ListMatHang))
{
using (OracleConnection connection = new OracleConnection(StringConnect))
{
try
{
connection.Open();
if (connection.State == ConnectionState.Open)
{
OracleCommand command = new OracleCommand();
command.Connection = connection;
command.CommandType = CommandType.Text;
command.CommandText = @"SELECT a.MAHANG,a.TENHANG,a.MANHACUNGCAP,a.MATHUE_VAO,a.MATHUE_RA,a.MADONVITINH,
a.BARCODE,b.GIAMUA,b.GIAMUA_VAT,b.TYLE_LAILE,b.TYLE_LAIBUON,b.GIABANLE_VAT
FROM MATHANG a INNER JOIN MATHANG_GIA b ON a.MAHANG = b.MAHANG AND a.UNITCODE = b.UNITCODE
AND a.MAHANG IN (" + ListMatHang.ToUpper() + ") AND a.UNITCODE = '" + UnitCode + "'";
OracleDataReader dataReader = command.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
MatHangViewModel.VIEW_MODEL ViewModel = new MatHangViewModel.VIEW_MODEL();
if (dataReader["MAHANG"] != null)
{
ViewModel.MAHANG = dataReader["MAHANG"].ToString();
}
if (dataReader["TENHANG"] != null)
{
ViewModel.TENHANG = dataReader["TENHANG"].ToString();
}
if (dataReader["MADONVITINH"] != null)
{
ViewModel.MADONVITINH = dataReader["MADONVITINH"].ToString();
}
if (dataReader["MANHACUNGCAP"] != null)
{
ViewModel.MANHACUNGCAP = dataReader["MANHACUNGCAP"].ToString();
}
if (dataReader["MATHUE_VAO"] != null)
{
ViewModel.MATHUE_VAO = dataReader["MATHUE_VAO"].ToString();
}
if (dataReader["MATHUE_RA"] != null)
{
ViewModel.MATHUE_RA = dataReader["MATHUE_RA"].ToString();
}
if (dataReader["BARCODE"] != null)
{
ViewModel.BARCODE = dataReader["BARCODE"].ToString();
}
decimal TYLE_LAILE = 0;
if (dataReader["TYLE_LAILE"] != DBNull.Value)
{
decimal.TryParse(dataReader["TYLE_LAILE"].ToString(), out TYLE_LAILE);
}
ViewModel.TYLE_LAILE = TYLE_LAILE;
decimal TYLE_LAIBUON = 0;
if (dataReader["TYLE_LAIBUON"] != DBNull.Value)
{
decimal.TryParse(dataReader["TYLE_LAIBUON"].ToString(), out TYLE_LAIBUON);
}
ViewModel.TYLE_LAIBUON = TYLE_LAIBUON;
decimal GIAMUA = 0;
if (dataReader["GIAMUA"] != DBNull.Value)
{
decimal.TryParse(dataReader["GIAMUA"].ToString(), out GIAMUA);
}
ViewModel.GIAMUA = GIAMUA;
decimal GIAMUA_VAT = 0;
if (dataReader["GIAMUA_VAT"] != DBNull.Value)
{
decimal.TryParse(dataReader["GIAMUA_VAT"].ToString(), out GIAMUA_VAT);
}
ViewModel.GIAMUA_VAT = GIAMUA_VAT;
decimal GIABANLE_VAT = 0;
if (dataReader["GIABANLE_VAT"] != DBNull.Value)
{
decimal.TryParse(dataReader["GIABANLE_VAT"].ToString(), out GIABANLE_VAT);
}
ViewModel.GIABANLE_VAT = GIABANLE_VAT;
result.Add(ViewModel);
}
}
}
}
catch
{
result = null;
}
finally
{
connection.Close();
connection.Dispose();
}
}
}
return(result);
}
