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 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 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_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);
}