public CDM_Nhom_Hang_Hoa Get_DM_Nhom_Hang_Hoa_By_ID(Int64 p_iID)
{
CDM_Nhom_Hang_Hoa v_objRes = null;
DataTable v_dt = new DataTable();
try
{
CSqlHelper.FillDataTable(CConfig.g_strVTNN_Conn_String, v_dt, "sp_sel_Get_DM_Nhom_Hang_Hoa_By_ID", p_iID);
if (v_dt.Rows.Count > 0)
{
v_objRes = new CDM_Nhom_Hang_Hoa();
MapDM_Nhom_Hang_Hoa(v_dt.Rows[0], v_objRes);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
v_dt.Dispose();
}
return(v_objRes);
}
public IList <CDM_Dieu_Khoan_Thanh_Toan> List_DM_Dieu_Khoan_Thanh_Toan()
{
IList <CDM_Dieu_Khoan_Thanh_Toan> v_arrRes = new List <CDM_Dieu_Khoan_Thanh_Toan>();
DataTable v_dt = new DataTable();
try
{
CSqlHelper.FillDataTable(CConfig.g_strVTNN_Conn_String, v_dt, "sp_sel_List_DM_Dieu_Khoan_Thanh_Toan");
foreach (DataRow v_row in v_dt.Rows)
{
CDM_Dieu_Khoan_Thanh_Toan v_objRes = new CDM_Dieu_Khoan_Thanh_Toan();
MapDM_Dieu_Khoan_Thanh_Toan(v_row, v_objRes);
v_arrRes.Add(v_objRes);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
v_dt.Dispose();
}
return(v_arrRes);
}
public CDM_Phep_Tinh_Chuyen_Doi Get_DM_Phep_Tinh_Chuyen_Doi_By_ID(long p_iID)
{
CDM_Phep_Tinh_Chuyen_Doi v_objRes = null;
DataTable v_dt = new DataTable();
try
{
CSqlHelper.FillDataTable(CConfig.g_strVTNN_Conn_String, v_dt, "sp_sel_Get_DM_Phep_Tinh_Chuyen_Doi_By_ID", p_iID);
if (v_dt.Rows.Count > 0)
{
v_objRes = new CDM_Phep_Tinh_Chuyen_Doi();
MapDM_Phep_Tinh_Chuyen_Doi(v_dt.Rows[0], v_objRes);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
v_dt.Dispose();
}
return(v_objRes);
}
public IList <CDM_Phep_Tinh_Chuyen_Doi> List_DM_Phep_Tinh_Chuyen_Doi()
{
IList <CDM_Phep_Tinh_Chuyen_Doi> v_arrRes = new List <CDM_Phep_Tinh_Chuyen_Doi>();
DataTable v_dt = new DataTable();
try
{
CSqlHelper.FillDataTable(CConfig.g_strVTNN_Conn_String, v_dt, "sp_sel_List_DM_Phep_Tinh_Chuyen_Doi");
foreach (DataRow v_row in v_dt.Rows)
{
CDM_Phep_Tinh_Chuyen_Doi v_objRes = new CDM_Phep_Tinh_Chuyen_Doi();
MapDM_Phep_Tinh_Chuyen_Doi(v_row, v_objRes);
v_arrRes.Add(v_objRes);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
v_dt.Dispose();
}
return(v_arrRes);
}
public void Delete_DM_Dieu_Khoan_Thanh_Toan(long p_iAuto_ID, string p_strLast_Updated_By)
{
try
{
CSqlHelper.ExecuteNonquery(CConfig.g_strVTNN_Conn_String, "sp_del_DM_Dieu_Khoan_Thanh_Toan", p_iAuto_ID, p_strLast_Updated_By);
}
catch (Exception ex)
{
throw ex;
}
}
public void Delete_DM_Ky(Int64 p_iAuto_ID, string p_strLast_Updated_By)
{
try
{
CSqlHelper.ExecuteNonquery(CConfig.g_strVTNN_Conn_String, "sp_del_DM_Ky", p_iAuto_ID, p_strLast_Updated_By);
}
catch (Exception ex)
{
throw ex;
}
}
public void Delete_DM_Phep_Tinh_Chuyen_Doi(long p_iAuto_ID, string p_strLast_Updated_By)
{
try
{
CSqlHelper.ExecuteNonquery(CConfig.g_strVTNN_Conn_String, "sp_del_DM_Phep_Tinh_Chuyen_Doi", p_iAuto_ID, p_strLast_Updated_By);
}
catch (Exception ex)
{
throw ex;
}
}
public void Update_DM_Nhan_Vien(CDM_Nhan_Vien p_objData)
{
try
{
CSqlHelper.ExecuteNonquery(CConfig.g_strVTNN_Conn_String, "sp_upd_DM_Nhan_Vien", p_objData.Auto_ID,
p_objData.Ma_Nhan_Vien, p_objData.Ten_Nhan_Vien, p_objData.Dien_Thoai, p_objData.Dia_Chi, p_objData.Last_Updated_By);
}
catch (Exception ex)
{
throw ex;
}
}
public void FHH0002_Update_DM_Hang_Hoa(SqlConnection p_Cons, SqlTransaction p_Trans, CDM_Hang_Hoa p_objData)
{
try
{
CSqlHelper.ExecuteNonquery(p_Cons, p_Trans, CConfig.g_strVTNN_Conn_String, "sp_upd_DM_Hang_Hoa", p_objData.Auto_ID,
p_objData.Ma_Hang_Hoa, p_objData.Ten_Hang_Hoa, p_objData.Don_Vi_Tinh_ID, p_objData.Nhom_Hang_Hoa_ID, p_objData.Gia_Nhap, p_objData.Gia_Ban_Si, p_objData.Gia_Ban_Le, p_objData.Gia_Ban_Tien_Mat, p_objData.Gia_Ban_No, p_objData.Gia_Ban_Dac_Biet, p_objData.Nha_San_Xuat_ID, p_objData.Nguon_Goc, p_objData.Mo_Ta, p_objData.Last_Updated_By);
}
catch (Exception ex)
{
throw ex;
}
}
public void Update_DM_Khach_Hang(CDM_Khach_Hang p_objData)
{
try
{
CSqlHelper.ExecuteNonquery(CConfig.g_strVTNN_Conn_String, "sp_upd_DM_Khach_Hang", p_objData.Auto_ID,
p_objData.Ma_Khach_Hang, p_objData.Ten_Khach_Hang, p_objData.Dia_Chi, p_objData.Dien_Thoai, p_objData.Ma_So_Thue, p_objData.Last_Updated_By);
}
catch (Exception ex)
{
throw ex;
}
}
public void Update_DM_Hang_Hoa(CDM_Hang_Hoa p_objData)
{
try
{
CSqlHelper.ExecuteNonquery(CConfig.g_strVTNN_Conn_String, "sp_ins_DM_Hang_Hoa",
p_objData.Ma_Hang_Hoa, p_objData.Ten_Hang_Hoa, p_objData.Don_Vi_Tinh_ID, p_objData.Nhom_Hang_Hoa_ID, p_objData.Gia_Nhap, p_objData.Gia_Ban_Si, p_objData.Gia_Ban_Le, p_objData.Gia_Ban_Tien_Mat, p_objData.Gia_Ban_No, p_objData.Gia_Ban_Dac_Biet, p_objData.Nha_San_Xuat_ID, p_objData.Nguon_Goc, p_objData.Mo_Ta, p_objData.Last_Updated_By);
}
catch (Exception ex)
{
throw ex;
}
}
public void Update_DM_Ky(CDM_Ky p_objData)
{
try
{
CSqlHelper.ExecuteNonquery(CConfig.g_strVTNN_Conn_String, "sp_upd_DM_Ky", p_objData.Auto_ID,
p_objData.Ten_Ky, p_objData.Last_Updated_By);
}
catch (Exception ex)
{
throw ex;
}
}
public void FDVTCD_0002_Update_DM_Don_Vi_Tinh_Chuyen_Doi(SqlConnection p_Cons, SqlTransaction p_Trans, CDM_Don_Vi_Tinh_Chuyen_Doi p_objData)
{
try
{
CSqlHelper.ExecuteNonquery(p_Cons, p_Trans, CConfig.g_strVTNN_Conn_String, "sp_upd_DM_Don_Vi_Tinh_Chuyen_Doi", p_objData.Auto_ID,
p_objData.Don_Vi_Tinh_ID, p_objData.Hang_Hoa_ID, p_objData.Ty_Le_Chuyen_Doi, p_objData.Phep_Tinh_Chuyen_ID, p_objData.Mo_Ta, p_objData.Gia_Ban_Si, p_objData.Gia_Ban_Le, p_objData.Gia_Ban_Dac_Biet, p_objData.Last_Updated_By);
}
catch (Exception ex)
{
throw ex;
}
}
public void Update_DM_Phep_Tinh_Chuyen_Doi(CDM_Phep_Tinh_Chuyen_Doi p_objData)
{
try
{
CSqlHelper.ExecuteNonquery(CConfig.g_strVTNN_Conn_String, "sp_upd_DM_Phep_Tinh_Chuyen_Doi", p_objData.Auto_ID,
p_objData.Ma_Chuyen_Doi, p_objData.Ten_Chuyen_Doi, p_objData.Last_Updated_By);
}
catch (Exception ex)
{
throw ex;
}
}
public void Update_DM_Dieu_Khoan_Thanh_Toan(CDM_Dieu_Khoan_Thanh_Toan p_objData)
{
try
{
CSqlHelper.ExecuteNonquery(CConfig.g_strVTNN_Conn_String, "sp_upd_DM_Dieu_Khoan_Thanh_Toan", p_objData.Auto_ID,
p_objData.Ma_Dieu_Khoan, p_objData.Ten_Dieu_Khoan, p_objData.Last_Updated_By);
}
catch (Exception ex)
{
throw ex;
}
}
public void Update_DM_Nhom_Hang_Hoa(CDM_Nhom_Hang_Hoa p_objData)
{
try
{
CSqlHelper.ExecuteNonquery(CConfig.g_strVTNN_Conn_String, "sp_upd_DM_Nhom_Hang_Hoa", p_objData.Auto_ID,
p_objData.Ma_Nhom_Hang, p_objData.Ten_Nhom_Hang, p_objData.Ghi_Chu, p_objData.Last_Updated_By);
}
catch (Exception ex)
{
throw ex;
}
}
public void Update_DM_Don_Vi_Tinh(CDM_Don_Vi_Tinh p_objData)
{
try
{
CSqlHelper.ExecuteNonquery(CConfig.g_strVTNN_Conn_String, "sp_upd_DM_Don_Vi_Tinh", p_objData.Auto_ID,
p_objData.Ma_Don_Vi_Tinh, p_objData.Ten_Don_Vi_Tinh, p_objData.Ghi_Chu, p_objData.Last_Updated_By);
}
catch (Exception ex)
{
throw ex;
}
}
public void Update_DM_Kho(CDM_Kho p_objData)
{
try
{
CSqlHelper.ExecuteNonquery(CConfig.g_strVTNN_Conn_String, "sp_upd_DM_Kho", p_objData.Auto_ID,
p_objData.Ma_Kho, p_objData.Ten_Kho, p_objData.Dien_Thoai, p_objData.Dia_Chi, p_objData.Nguoi_Lien_He, p_objData.Ghi_Chu, p_objData.Last_Updated_By);
}
catch (Exception ex)
{
throw ex;
}
}
public Int64 Insert_DM_Don_Vi_Tinh_Chuyen_Doi(CDM_Don_Vi_Tinh_Chuyen_Doi p_objData)
{
int v_iRes = CConst.INT_VALUE_NULL;
try
{
v_iRes = Convert.ToInt32(CSqlHelper.ExecuteScalar(CConfig.g_strVTNN_Conn_String, "sp_ins_DM_Don_Vi_Tinh_Chuyen_Doi",
p_objData.Don_Vi_Tinh_ID, p_objData.Hang_Hoa_ID, p_objData.Ty_Le_Chuyen_Doi, p_objData.Phep_Tinh_Chuyen_ID, p_objData.Mo_Ta, p_objData.Gia_Ban_Si, p_objData.Gia_Ban_Le, p_objData.Gia_Ban_Dac_Biet, p_objData.Last_Updated_By));
}
catch (Exception ex)
{
throw ex;
}
return(v_iRes);
}
public int Insert_DM_Nhom_Hang_Hoa(CDM_Nhom_Hang_Hoa p_objData)
{
int v_iRes = CConst.INT_VALUE_NULL;
try
{
v_iRes = Convert.ToInt32(CSqlHelper.ExecuteScalar(CConfig.g_strVTNN_Conn_String, "sp_ins_DM_Nhom_Hang_Hoa",
p_objData.Ma_Nhom_Hang, p_objData.Ten_Nhom_Hang, p_objData.Ghi_Chu, p_objData.Last_Updated_By));
}
catch (Exception ex)
{
throw ex;
}
return(v_iRes);
}
public int Insert_DM_Kho(CDM_Kho p_objData)
{
int v_iRes = CConst.INT_VALUE_NULL;
try
{
v_iRes = Convert.ToInt32(CSqlHelper.ExecuteScalar(CConfig.g_strVTNN_Conn_String, "sp_ins_DM_Kho",
p_objData.Ma_Kho, p_objData.Ten_Kho, p_objData.Dien_Thoai, p_objData.Dia_Chi, p_objData.Nguoi_Lien_He, p_objData.Ghi_Chu, p_objData.Last_Updated_By));
}
catch (Exception ex)
{
throw ex;
}
return(v_iRes);
}
public Int64 FHH0001_Insert_DM_Hang_Hoa(SqlConnection p_Cons, SqlTransaction p_Trans, CDM_Hang_Hoa p_objData)
{
Int64 v_iRes = CConst.INT64_VALUE_NULL;
try
{
v_iRes = Convert.ToInt64(CSqlHelper.ExecuteScalar(p_Cons, p_Trans, CConfig.g_strVTNN_Conn_String, "sp_ins_DM_Hang_Hoa",
p_objData.Ma_Hang_Hoa, p_objData.Ten_Hang_Hoa, p_objData.Don_Vi_Tinh_ID, p_objData.Nhom_Hang_Hoa_ID, p_objData.Gia_Nhap, p_objData.Gia_Ban_Si, p_objData.Gia_Ban_Le, p_objData.Gia_Ban_Tien_Mat, p_objData.Gia_Ban_No, p_objData.Gia_Ban_Dac_Biet, p_objData.Nha_San_Xuat_ID, p_objData.Nguon_Goc, p_objData.Mo_Ta, p_objData.Last_Updated_By));
}
catch (Exception ex)
{
throw ex;
}
return(v_iRes);
}
public int Insert_DM_Dieu_Khoan_Thanh_Toan(CDM_Dieu_Khoan_Thanh_Toan p_objData)
{
int v_iRes = CConst.INT_VALUE_NULL;
try
{
v_iRes = Convert.ToInt32(CSqlHelper.ExecuteScalar(CConfig.g_strVTNN_Conn_String, "sp_ins_DM_Dieu_Khoan_Thanh_Toan",
p_objData.Ma_Dieu_Khoan, p_objData.Ten_Dieu_Khoan, p_objData.Last_Updated_By));
}
catch (Exception ex)
{
throw ex;
}
return(v_iRes);
}
public int Insert_DM_Phep_Tinh_Chuyen_Doi(CDM_Phep_Tinh_Chuyen_Doi p_objData)
{
int v_iRes = CConst.INT_VALUE_NULL;
try
{
v_iRes = Convert.ToInt32(CSqlHelper.ExecuteScalar(CConfig.g_strVTNN_Conn_String, "sp_ins_DM_Phep_Tinh_Chuyen_Doi",
p_objData.Ma_Chuyen_Doi, p_objData.Ten_Chuyen_Doi, p_objData.Last_Updated_By));
}
catch (Exception ex)
{
throw ex;
}
return(v_iRes);
}
public Int64 FDVTCD_0001_Insert_DM_Don_Vi_Tinh_Chuyen_Doi(SqlConnection p_Cons, SqlTransaction p_Trans, CDM_Don_Vi_Tinh_Chuyen_Doi p_objData)
{
Int64 v_iRes = CConst.INT64_VALUE_NULL;
try
{
v_iRes = Convert.ToInt64(CSqlHelper.ExecuteScalar(p_Cons, p_Trans, CConfig.g_strVTNN_Conn_String, "sp_ins_DM_Don_Vi_Tinh_Chuyen_Doi",
p_objData.Don_Vi_Tinh_ID, p_objData.Hang_Hoa_ID, p_objData.Ty_Le_Chuyen_Doi, p_objData.Phep_Tinh_Chuyen_ID, p_objData.Mo_Ta, p_objData.Gia_Ban_Si, p_objData.Gia_Ban_Le, p_objData.Gia_Ban_Dac_Biet, p_objData.Last_Updated_By));
}
catch (Exception ex)
{
throw ex;
}
return(v_iRes);
}
public int Insert_DM_Nha_San_Xuat(CDM_Nha_San_Xuat p_objData)
{
int v_iRes = CConst.INT_VALUE_NULL;
try
{
v_iRes = Convert.ToInt32(CSqlHelper.ExecuteScalar(CConfig.g_strVTNN_Conn_String, "sp_ins_DM_Nha_San_Xuat",
p_objData.Ma_Nha_San_Xuat, p_objData.Ten_Nha_San_Xuat, p_objData.So_Dien_Thoai, p_objData.Dia_Chi, p_objData.Last_Updated_By, p_objData.Ghi_Chu));
}
catch (Exception ex)
{
throw ex;
}
return(v_iRes);
}
public void FHH_0002_Updated(CDM_Hang_Hoa p_objHangHoa, List <CDM_Don_Vi_Tinh_Chuyen_Doi> p_arrDVTChuyenDoi)
{
SqlConnection v_conn = null;
SqlTransaction v_trans = null;
try
{
v_conn = CSqlHelper.CreateConnection(CConfig.g_strVTNN_Conn_String);
v_conn.Open();
v_trans = v_conn.BeginTransaction();
_objHangHoaDAO.FHH0002_Update_DM_Hang_Hoa(v_conn, v_trans, p_objHangHoa);
foreach (CDM_Don_Vi_Tinh_Chuyen_Doi v_obj in p_arrDVTChuyenDoi)
{
if (v_obj.Auto_ID <= 0)
{
v_obj.Hang_Hoa_ID = p_objHangHoa.Auto_ID;
_objDVTChuyenDoiDAO.FDVTCD_0001_Insert_DM_Don_Vi_Tinh_Chuyen_Doi(v_conn, v_trans, v_obj);
}
if (v_obj.Auto_ID > 0)
{
_objDVTChuyenDoiDAO.FDVTCD_0002_Update_DM_Don_Vi_Tinh_Chuyen_Doi(v_conn, v_trans, v_obj);
}
}
v_trans.Commit();
}
catch (Exception ex)
{
throw ex;
}
finally
{
v_trans.Dispose();
if (v_conn != null)
{
v_conn.Close();
}
}
}
public bool FHH_0001_Insert(CDM_Hang_Hoa p_objHangHoa, List <CDM_Don_Vi_Tinh_Chuyen_Doi> p_arrDVTChuyenDoi)
{
bool v_blResul = true;
SqlConnection v_conn = null;
SqlTransaction v_trans = null;
try
{
v_conn = CSqlHelper.CreateConnection(CConfig.g_strVTNN_Conn_String);
v_conn.Open();
v_trans = v_conn.BeginTransaction();
Int64 v_iHangHoaID = _objHangHoaDAO.FHH0001_Insert_DM_Hang_Hoa(v_conn, v_trans, p_objHangHoa);
foreach (CDM_Don_Vi_Tinh_Chuyen_Doi v_obj in p_arrDVTChuyenDoi)
{
v_obj.Hang_Hoa_ID = v_iHangHoaID;
_objDVTChuyenDoiDAO.FDVTCD_0001_Insert_DM_Don_Vi_Tinh_Chuyen_Doi(v_conn, v_trans, v_obj);
}
v_trans.Commit();
}
catch (Exception ex)
{
v_blResul = false;
throw ex;
}
finally
{
v_trans.Dispose();
if (v_conn != null)
{
v_conn.Close();
}
}
return(v_blResul);
//return _objHangHoaDAO.FHH0001_Insert_DM_Hang_Hoa(p_Cons, p_Trans, p_objHangHoa);
}
