public US_RPT_THONG_TIN_TONG_HOP(decimal i_dbID)
{
pm_objDS = new DS_RPT_THONG_TIN_TONG_HOP();
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 tong_hop_bao_cao(DS_RPT_THONG_TIN_TONG_HOP ip_ds, BackgroundWorker ip_bgw)
{
var ip_dt = ip_ds.Tables[0];
for(int i = 0; i < ip_dt.Rows.Count; i++)
{
DataRow v_dr = ip_dt.Rows[i];
decimal v_id_nhan_vien = CIPConvert.ToDecimal(v_dr["ID_NHAN_VIEN"]);
//B1: Tong hop thong tin 1 nhan vien
DataRow v_dr_thong_tin_tong_hop = get_thong_tin_tong_hop_1_nhan_vien(v_id_nhan_vien, int.Parse(m_txt_thang.Text.Trim()), int.Parse(m_txt_nam.Text.Trim()));
//B2: Insert vao Rpt
insertThongTinTongHopNV2RPT(v_dr_thong_tin_tong_hop);
ip_bgw.ReportProgress((i + 1) * 100 / ip_dt.Rows.Count);
}
}
private DS_RPT_THONG_TIN_TONG_HOP lay_danh_sach_nhan_vien_can_tong_hop_thong_tin()
{
US_RPT_THONG_TIN_TONG_HOP v_us = new US_RPT_THONG_TIN_TONG_HOP();
DS_RPT_THONG_TIN_TONG_HOP v_ds = new DS_RPT_THONG_TIN_TONG_HOP();
v_us.Get_tat_ca_nhan_vien_can_tong_hop_thong_tin(v_ds, CIPConvert.ToDecimal(m_txt_thang.Text.Trim()), CIPConvert.ToDecimal(m_txt_nam.Text.Trim()));
return v_ds;
}
public void Get_tat_ca_nhan_vien_can_tong_hop_thong_tin(DS_RPT_THONG_TIN_TONG_HOP op_ds, decimal ip_thang, decimal ip_nam)
{
op_ds.EnforceConstraints = false;
CStoredProc v_sp = new CStoredProc("pr_old_GET_DANH_SACH_NHAN_VIEN_CAN_TONG_HOP_THONG_TIN");
v_sp.addDecimalInputParam("@THANG", ip_thang);
v_sp.addDecimalInputParam("@NAM", ip_nam);
v_sp.fillDataSetByCommand(this, op_ds);
}
public US_RPT_THONG_TIN_TONG_HOP()
{
pm_objDS = new DS_RPT_THONG_TIN_TONG_HOP();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
