public static HANGKHACHHANG_DTO LAY_QUYDOI_THEOHANGKH_FROM_SQLSERVER(string MAHANGKHACHHANG)
{
HANGKHACHHANG_DTO RESULT = new HANGKHACHHANG_DTO();
try
{
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["TBNETERP_CLIENT"].ConnectionString))
{
try
{
connection.Open();
if (connection.State == ConnectionState.Open)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = connection;
cmd.CommandText = "SELECT MAHANGKH,TENHANGKH,SOTIEN,TYLEGIAMGIASN,TYLEGIAMGIA,QUYDOITIEN_THANH_DIEM,QUYDOIDIEM_THANH_TIEN FROM dbo.DM_HANGKHACHHANG WHERE TRANGTHAI = 10 AND MAHANGKH = '" + MAHANGKHACHHANG + "' AND UNITCODE = '" + Session.Session.CurrentUnitCode + "'";
cmd.CommandType = CommandType.Text;
SqlDataReader dataReader = cmd.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
decimal SOTIEN = 0;
decimal TYLEGIAMGIASN = 0;
decimal TYLEGIAMGIA = 0;
decimal QUYDOITIEN_THANH_DIEM = 0;
decimal QUYDOIDIEM_THANH_TIEN = 0;
RESULT.MAHANGKH = dataReader["MAHANGKH"] != null ? dataReader["MAHANGKH"].ToString() : "";
RESULT.TENHANGKH = dataReader["TENHANGKH"] != null ? dataReader["TENHANGKH"].ToString() : "";
decimal.TryParse(dataReader["SOTIEN"] != null ? dataReader["SOTIEN"].ToString() : "", out SOTIEN);
decimal.TryParse(dataReader["TYLEGIAMGIASN"] != null ? dataReader["TYLEGIAMGIASN"].ToString() : "", out TYLEGIAMGIASN);
decimal.TryParse(dataReader["TYLEGIAMGIA"] != null ? dataReader["TYLEGIAMGIA"].ToString() : "", out TYLEGIAMGIA);
decimal.TryParse(dataReader["QUYDOITIEN_THANH_DIEM"] != null ? dataReader["QUYDOITIEN_THANH_DIEM"].ToString() : "", out QUYDOITIEN_THANH_DIEM);
decimal.TryParse(dataReader["QUYDOIDIEM_THANH_TIEN"] != null ? dataReader["QUYDOIDIEM_THANH_TIEN"].ToString() : "", out QUYDOIDIEM_THANH_TIEN);
RESULT.SOTIEN = SOTIEN;
RESULT.TYLEGIAMGIASN = TYLEGIAMGIASN;
RESULT.TYLEGIAMGIA = TYLEGIAMGIA;
RESULT.QUYDOITIEN_THANH_DIEM = QUYDOITIEN_THANH_DIEM;
RESULT.QUYDOIDIEM_THANH_TIEN = QUYDOIDIEM_THANH_TIEN;
}
}
}
}
catch
{
NotificationLauncher.ShowNotificationWarning("THÔNG BÁO", "KHÔNG TÌM THẤY THÔNG TIN HẠNG KHÁCH HÀNG", 1, "0x1", "0x8", "normal");
}
finally
{
connection.Close();
connection.Dispose();
}
}
}
catch (Exception ex)
{
WriteLogs.LogError(ex);
NotificationLauncher.ShowNotificationError("Thông báo", "Xảy ra lỗi", 1, "0x1", "0x8", "normal");
}
return(RESULT);
}
public static HANGKHACHHANG_DTO LAY_QUYDOI_THEOHANGKH_FROM_ORACLE(string MAHANGKHACHHANG)
{
HANGKHACHHANG_DTO RESULT = new HANGKHACHHANG_DTO();
try
{
using (OracleConnection connection = new OracleConnection(ConfigurationManager.ConnectionStrings["ERBusConnection"].ConnectionString))
{
try
{
connection.Open();
if (connection.State == ConnectionState.Open)
{
OracleCommand cmd = new OracleCommand();
cmd.Connection = connection;
cmd.CommandText = string.Format(@"SELECT
MAHANG,
TENHANG,
SOTIEN_LENHANG,
TYLE_SINHNHAT,
TYLE_DACBIET,
QUYDOITIEN_THANH_DIEM,
QUYDOIDIEM_THANH_TIEN
FROM
HANGKHACHHANG WHERE TRANGTHAI = 10 AND MAHANG = '" + MAHANGKHACHHANG + "' AND UNITCODE = '" + Session.Session.CurrentUnitCode + "'");
cmd.CommandType = CommandType.Text;
OracleDataReader dataReader = cmd.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
decimal SOTIEN_LENHANG = 0;
decimal TYLE_SINHNHAT = 0;
decimal TYLE_DACBIET = 0;
decimal QUYDOITIEN_THANH_DIEM = 0;
decimal QUYDOIDIEM_THANH_TIEN = 0;
RESULT.MAHANG = dataReader["MAHANG"] != null ? dataReader["MAHANG"].ToString() : "";
RESULT.TENHANG = dataReader["TENHANG"] != null ? dataReader["TENHANG"].ToString() : "";
decimal.TryParse(dataReader["SOTIEN_LENHANG"] != null ? dataReader["SOTIEN_LENHANG"].ToString() : "", out SOTIEN_LENHANG);
decimal.TryParse(dataReader["TYLE_SINHNHAT"] != null ? dataReader["TYLE_SINHNHAT"].ToString() : "", out TYLE_SINHNHAT);
decimal.TryParse(dataReader["TYLE_DACBIET"] != null ? dataReader["TYLE_DACBIET"].ToString() : "", out TYLE_DACBIET);
decimal.TryParse(dataReader["QUYDOITIEN_THANH_DIEM"] != null ? dataReader["QUYDOITIEN_THANH_DIEM"].ToString() : "", out QUYDOITIEN_THANH_DIEM);
decimal.TryParse(dataReader["QUYDOIDIEM_THANH_TIEN"] != null ? dataReader["QUYDOIDIEM_THANH_TIEN"].ToString() : "", out QUYDOIDIEM_THANH_TIEN);
RESULT.SOTIEN_LENHANG = SOTIEN_LENHANG;
RESULT.TYLE_SINHNHAT = TYLE_SINHNHAT;
RESULT.TYLE_DACBIET = TYLE_DACBIET;
RESULT.QUYDOITIEN_THANH_DIEM = QUYDOITIEN_THANH_DIEM;
RESULT.QUYDOIDIEM_THANH_TIEN = QUYDOIDIEM_THANH_TIEN;
}
}
}
}
catch
{
NotificationLauncher.ShowNotificationWarning("THÔNG BÁO", "KHÔNG TÌM THẤY THÔNG TIN HẠNG KHÁCH HÀNG", 1, "0x1", "0x8", "normal");
}
finally
{
connection.Close();
connection.Dispose();
}
}
}
catch (Exception ex)
{
WriteLogs.LogError(ex);
NotificationLauncher.ShowNotificationError("Thông báo", "Xảy ra lỗi", 1, "0x1", "0x8", "normal");
}
return(RESULT);
}
