public List <TIMKIEM_HANGHOA_DTO> TIMKIEM_DULIEU_HANGHOA_DATABASE_SQLSERVER(string DIEUKIENLOC, int SUDUNG_TIMKIEM_ALL, int DIEUKIENCHON, string UNITCODE)
{
List <TIMKIEM_HANGHOA_DTO> LST_TIMKIEM_VATTU_DTO = new List <TIMKIEM_HANGHOA_DTO>();
if (!string.IsNullOrEmpty(DIEUKIENLOC))
{
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["ERBusCashier"].ConnectionString))
{
try
{
connection.Open();
if (connection.State == ConnectionState.Open)
{
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = @"BANLE_TIMKIEM_BOHANG_MAHANG";
command.Parameters.Clear();
command.Parameters.AddWithValue("@P_MADONVI", UNITCODE);
command.Parameters.AddWithValue("@P_TUKHOA", DIEUKIENLOC.ToString().ToUpper().Trim());
command.Parameters.AddWithValue("@P_SUDUNG_TIMKIEM_ALL", SUDUNG_TIMKIEM_ALL);
command.Parameters.AddWithValue("@P_DIEUKIENCHON", DIEUKIENCHON);
SqlDataReader dataReader = command.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
TIMKIEM_HANGHOA_DTO TIMKIEM_HANGHOA_DTO = new TIMKIEM_HANGHOA_DTO();
if (dataReader["MAHANG"] != null)
{
TIMKIEM_HANGHOA_DTO.MAHANG = dataReader["MAHANG"].ToString();
}
if (dataReader["MACON"] != null)
{
TIMKIEM_HANGHOA_DTO.MACON = dataReader["MACON"].ToString();
}
if (dataReader["TENHANG"] != null)
{
TIMKIEM_HANGHOA_DTO.TENHANG = dataReader["TENHANG"].ToString();
}
if (dataReader["MALOAI"] != null)
{
TIMKIEM_HANGHOA_DTO.MALOAI = dataReader["MALOAI"].ToString();
}
if (dataReader["MANHOM"] != null)
{
TIMKIEM_HANGHOA_DTO.MANHOM = dataReader["MANHOM"].ToString();
}
if (dataReader["DONVITINH"] != null)
{
TIMKIEM_HANGHOA_DTO.DONVITINH = dataReader["DONVITINH"].ToString();
}
if (dataReader["MANHACUNGCAP"] != null)
{
TIMKIEM_HANGHOA_DTO.MANHACUNGCAP = dataReader["MANHACUNGCAP"].ToString();
}
if (dataReader["TENNHACUNGCAP"] != null)
{
TIMKIEM_HANGHOA_DTO.TENNHACUNGCAP = dataReader["TENNHACUNGCAP"].ToString();
}
decimal GIABANLE_VAT = 0;
if (dataReader["GIABANLE_VAT"] != null)
{
decimal.TryParse(dataReader["GIABANLE_VAT"].ToString(), out GIABANLE_VAT);
}
TIMKIEM_HANGHOA_DTO.GIABANLE_VAT = GIABANLE_VAT;
if (dataReader["ITEMCODE"] != null)
{
TIMKIEM_HANGHOA_DTO.ITEMCODE = dataReader["ITEMCODE"].ToString();
}
if (dataReader["BARCODE"] != null)
{
TIMKIEM_HANGHOA_DTO.BARCODE = dataReader["BARCODE"].ToString();
}
LST_TIMKIEM_VATTU_DTO.Add(TIMKIEM_HANGHOA_DTO);
}
}
}
}
catch (Exception ex)
{
WriteLogs.LogError(ex);
}
finally
{
connection.Close();
connection.Dispose();
}
}
}
return(LST_TIMKIEM_VATTU_DTO);
}
public List <TIMKIEM_HANGHOA_DTO> TIMKIEM_DULIEU_HANGHOA_DATABASE_ORACLE(string DIEUKIENLOC, int SUDUNG_TIMKIEM_ALL, int DIEUKIENCHON, string UNITCODE)
{
List <TIMKIEM_HANGHOA_DTO> LST_TIMKIEM_VATTU_DTO = new List <TIMKIEM_HANGHOA_DTO>();
if (!string.IsNullOrEmpty(DIEUKIENLOC))
{
using (OracleConnection connection = new OracleConnection(ConfigurationManager.ConnectionStrings["ERBusConnection"].ConnectionString))
{
try
{
connection.Open();
if (connection.State == ConnectionState.Open)
{
OracleCommand command = new OracleCommand();
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = @"BANLE_TIMKIEM_BOHANG_MAHANG";
command.Parameters.Add(@"P_MADONVI", OracleDbType.NVarchar2, 50).Value = UNITCODE;
command.Parameters.Add(@"P_TUKHOA", OracleDbType.NVarchar2, 50).Value = DIEUKIENLOC.ToString().ToUpper().Trim();
command.Parameters.Add(@"P_SUDUNG_TIMKIEM_ALL", OracleDbType.Int32).Value = SUDUNG_TIMKIEM_ALL;
command.Parameters.Add(@"P_DIEUKIENCHON", OracleDbType.Int32).Value = DIEUKIENCHON;
command.Parameters.Add(@"CURSOR_RESULT", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
OracleDataReader dataReader = command.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
TIMKIEM_HANGHOA_DTO TIMKIEM_HANGHOA_DTO = new TIMKIEM_HANGHOA_DTO();
if (dataReader["MAHANG"] != null)
{
TIMKIEM_HANGHOA_DTO.MAHANG = dataReader["MAHANG"].ToString();
}
if (dataReader["MACON"] != null)
{
TIMKIEM_HANGHOA_DTO.MACON = dataReader["MACON"].ToString();
}
if (dataReader["TENHANG"] != null)
{
TIMKIEM_HANGHOA_DTO.TENHANG = dataReader["TENHANG"].ToString();
}
if (dataReader["MALOAI"] != null)
{
TIMKIEM_HANGHOA_DTO.MALOAI = dataReader["MALOAI"].ToString();
}
if (dataReader["MANHOM"] != null)
{
TIMKIEM_HANGHOA_DTO.MANHOM = dataReader["MANHOM"].ToString();
}
if (dataReader["DONVITINH"] != null)
{
TIMKIEM_HANGHOA_DTO.DONVITINH = dataReader["DONVITINH"].ToString();
}
if (dataReader["MANHACUNGCAP"] != null)
{
TIMKIEM_HANGHOA_DTO.MANHACUNGCAP = dataReader["MANHACUNGCAP"].ToString();
}
if (dataReader["TENNHACUNGCAP"] != null)
{
TIMKIEM_HANGHOA_DTO.TENNHACUNGCAP = dataReader["TENNHACUNGCAP"].ToString();
}
decimal GIABANLE_VAT = 0;
if (dataReader["GIABANLE_VAT"] != null)
{
decimal.TryParse(dataReader["GIABANLE_VAT"].ToString(), out GIABANLE_VAT);
}
TIMKIEM_HANGHOA_DTO.GIABANLE_VAT = GIABANLE_VAT;
if (dataReader["ITEMCODE"] != null)
{
TIMKIEM_HANGHOA_DTO.ITEMCODE = dataReader["ITEMCODE"].ToString();
}
if (dataReader["BARCODE"] != null)
{
TIMKIEM_HANGHOA_DTO.BARCODE = dataReader["BARCODE"].ToString();
}
LST_TIMKIEM_VATTU_DTO.Add(TIMKIEM_HANGHOA_DTO);
}
}
}
}
catch (Exception ex)
{
WriteLogs.LogError(ex);
}
finally
{
connection.Close();
connection.Dispose();
}
}
}
return(LST_TIMKIEM_VATTU_DTO);
}
