public US_GD_QUY_THU_NHAP_KHAC(decimal i_dbID)
{
pm_objDS = new DS_GD_QUY_THU_NHAP_KHAC();
pm_strTableName = c_TableName;
IMakeSelectCmd v_objMkCmd = new CMakeAndSelectCmd(pm_objDS, c_TableName);
v_objMkCmd.AddCondition("ID", i_dbID, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang);
SqlCommand v_cmdSQL;
v_cmdSQL = v_objMkCmd.getSelectCmd();
this.FillDatasetByCommand(pm_objDS, v_cmdSQL);
pm_objDR = getRowClone(pm_objDS.Tables[pm_strTableName].Rows[0]);
}
private void load_data_to_sle_quy_tien()
{
DS_GD_QUY_THU_NHAP_KHAC v_ds = new DS_GD_QUY_THU_NHAP_KHAC();
US_GD_QUY_THU_NHAP_KHAC v_us = new US_GD_QUY_THU_NHAP_KHAC();
v_us.FillDatasetQuyTNKbyIDLoaiQuy(v_ds, 756);
m_sle_quy_tien.Properties.DataSource = v_ds.Tables[0];
}
private decimal get_thang_theo_quy(decimal v_id_quy)
{
US_GD_QUY_THU_NHAP_KHAC v_us = new US_GD_QUY_THU_NHAP_KHAC();
DS_GD_QUY_THU_NHAP_KHAC v_ds = new DS_GD_QUY_THU_NHAP_KHAC();
v_us.FillDataset(v_ds, "where id=" + v_id_quy);
return decimal.Parse(v_ds.Tables[0].Rows[0][2].ToString());
}
private void load_data_to_grid()
{
CHRMCommon.make_stt_indicator(m_grv);
US_GD_QUY_THU_NHAP_KHAC v_us = new US_GD_QUY_THU_NHAP_KHAC();
DS_GD_QUY_THU_NHAP_KHAC v_ds = new DS_GD_QUY_THU_NHAP_KHAC();
v_us.FillDatasetQuyTNK(v_ds, m_dat_tu_thang.DateTime, m_dat_den_thang.DateTime);
m_grc.DataSource = v_ds.Tables[0];
}
public US_GD_QUY_THU_NHAP_KHAC()
{
pm_objDS = new DS_GD_QUY_THU_NHAP_KHAC();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
public void FillDatasetQuyTNKbyIDLoaiQuy(DS_GD_QUY_THU_NHAP_KHAC v_ds, decimal ip_id_loai_quy)
{
CStoredProc v_cstore = new CStoredProc("pr_TNK_quy_tien_GetTheoIDLoaiQuy");
v_cstore.addDecimalInputParam("@id_loai_quy", ip_id_loai_quy);
v_cstore.fillDataSetByCommand(this, v_ds);
}
public void FillDatasetQuyTNK(DS_GD_QUY_THU_NHAP_KHAC v_ds, DateTime ip_dat_tu_thang, DateTime ip_dat_den_thang)
{
CStoredProc v_cstore = new CStoredProc("pr_TNK_quy_tien_GetAll");
v_cstore.addDatetimeInputParam("@ip_tu_thang", @ip_dat_tu_thang);
v_cstore.addDatetimeInputParam("@ip_den_thang", @ip_dat_den_thang);
v_cstore.fillDataSetByCommand(this, v_ds);
}
