public US_V_GD_THONG_KE(decimal i_dbID)
{
pm_objDS = new DS_V_GD_THONG_KE();
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]);
}
public void FillDatasetSearch_hocvien_tuyenmoi(DS_V_GD_THONG_KE ip_m_ds, string ip_v_str_tim_kiem, DateTime ip_dat_tu_ngay, DateTime ip_dat_den_ngay, decimal v_id_loai_dinh_muc)
{
CStoredProc v_stored_proc = new CStoredProc("pr_V_GD_THONG_KE_Search_hocvien_tuyenmoi");
v_stored_proc.addNVarcharInputParam("@TU_KHOA", ip_v_str_tim_kiem);
v_stored_proc.addDatetimeInputParam("@TU_NGAY", ip_dat_tu_ngay);
v_stored_proc.addDatetimeInputParam("@DEN_NGAY", ip_dat_den_ngay);
v_stored_proc.addDecimalInputParam("@ID_LOAI_DINH_MUC", v_id_loai_dinh_muc);
v_stored_proc.fillDataSetByCommand(this, ip_m_ds);
}
public US_V_GD_THONG_KE()
{
pm_objDS = new DS_V_GD_THONG_KE();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
public void FillDataset(DS_V_GD_THONG_KE ip_v_ds, decimal ip_id_phong_ban)
{
CStoredProc v_stored_proc = new CStoredProc("pr_get_thong_ke_nhan_su_trung_tam_vpp");
v_stored_proc.addDecimalInputParam("@ID_PHONG_BAN", ip_id_phong_ban);
v_stored_proc.fillDataSetByCommand(this, ip_v_ds);
}
private void load_cbo_loai_dinh_muc()
{
m_trang_thai = false;
BCTKUS.US_CM_DM_TU_DIEN v_us = new BCTKUS.US_CM_DM_TU_DIEN();
BCTKDS.DS_CM_DM_TU_DIEN v_ds = new BCTKDS.DS_CM_DM_TU_DIEN();
v_us.FillDataset(v_ds, "where id_loai_tu_dien =" + 17);
m_cbo_loai_dm.DataSource = v_ds.CM_DM_TU_DIEN;
m_cbo_loai_dm.ValueMember = CM_DM_TU_DIEN.ID;
m_cbo_loai_dm.DisplayMember = CM_DM_TU_DIEN.TEN;
//DataRow v_dr = v_ds.CM_DM_TU_DIEN.NewRow();
//v_dr[CM_DM_TU_DIEN.ID] = -1;
//v_dr[CM_DM_TU_DIEN.ID_LOAI_TU_DIEN] = 17;
//v_dr[CM_DM_TU_DIEN.MA_TU_DIEN] = " ";
//v_dr[CM_DM_TU_DIEN.TEN] = "Tất cả";
//v_dr[CM_DM_TU_DIEN.TEN_NGAN] = "Tất cả";
//v_ds.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0);
//m_cbo_loai_dm.SelectedIndex = 0;
m_trang_thai = true;
}
private void load_data_2_grid()
{
DateTime v_dat_tu_ngay = m_dtp_tu_ngay.Value.Date.AddDays(- m_dtp_tu_ngay.Value.Date.Day + 1);
DateTime v_dat_den_ngay = m_dtp_den_ngay.Value.Date;
DateTime temp = m_dtp_den_ngay.Value.Date;
decimal v_id_loai_dinh_muc = CIPConvert.ToDecimal(m_cbo_loai_dm.SelectedValue);
temp = temp.AddMonths(1);
temp = temp.AddDays(-(temp.Day));
v_dat_den_ngay = temp;
string v_str_tu_khoa = m_txt_tu_khoa.Text;
if (v_str_tu_khoa == m_str_goi_y_tim_kiem) v_str_tu_khoa = "";
m_ds = new DS_V_GD_THONG_KE();
m_ds.Clear();
if (m_cbo_loai_tk.SelectedIndex == 0)
{
m_grv_thong_ke_hoc_vien.Cols[(int)e_col_Number.TU_NGAY].Visible = true;
m_grv_thong_ke_hoc_vien.Cols[(int)e_col_Number.DEN_NGAY].Caption = "Đến ngày";
m_grv_thong_ke_hoc_vien.Cols[(int)e_col_Number.GHI_CHU_1].Width = 125;
m_us.FillDatasetSearch_hocvien(m_ds, v_str_tu_khoa, v_dat_tu_ngay, v_dat_den_ngay,v_id_loai_dinh_muc);
}
else if (m_cbo_loai_tk.SelectedIndex == 1)
{
m_grv_thong_ke_hoc_vien.Cols[(int)e_col_Number.TU_NGAY].Visible = false;
m_grv_thong_ke_hoc_vien.Cols[(int)e_col_Number.DEN_NGAY].Caption = "Tại ngày";
m_grv_thong_ke_hoc_vien.Cols[(int)e_col_Number.GHI_CHU_1].Width = 240;
m_us.FillDatasetSearch_hocvien_danghoc(m_ds, v_str_tu_khoa, v_dat_tu_ngay, v_dat_den_ngay,v_id_loai_dinh_muc);
}
private void load_so_luong_nhan_su()
{
decimal v_tong_dinh_muc;
US_V_GD_THONG_KE v_us = new US_V_GD_THONG_KE();
DS_V_GD_THONG_KE v_ds = new DS_V_GD_THONG_KE();
US_DM_CO_SO_DINH_MUC v_us_cs_dm = new US_DM_CO_SO_DINH_MUC();
DS_DM_CO_SO_DINH_MUC v_ds_cs_dm = new DS_DM_CO_SO_DINH_MUC();
v_us.FillDataset(v_ds,CIPConvert.ToDecimal(m_hdf_id_trung_tam.Value));
if (v_ds.Tables[0].Rows.Count > 0)
{
m_lbl_tong_nhan_su.Text = v_ds.Tables[0].Rows[0]["GIA_TRI_THONG_KE"].ToString() +" ("+ v_ds.Tables[0].Rows[0]["TEN"].ToString() + ")";
v_us_cs_dm.FillDataset(v_ds_cs_dm, "where ID =" + CIPConvert.ToDecimal(v_ds.Tables[0].Rows[0]["ID_CO_SO_DINH_MUC"]));
m_lbl_dinh_muc_dau_nguoi.Text = CIPConvert.ToStr(v_ds_cs_dm.Tables[0].Rows[0]["DON_GIA_DINH_MUC"], "#,##0") +" (VNĐ)" + "/" + v_ds.Tables[0].Rows[0]["TEN"].ToString();
v_tong_dinh_muc = (CIPConvert.ToDecimal(v_ds_cs_dm.Tables[0].Rows[0]["DON_GIA_DINH_MUC"])) * (CIPConvert.ToDecimal(v_ds.Tables[0].Rows[0]["GIA_TRI_THONG_KE"]));
m_lbl_tong_dinh_muc.Text = v_tong_dinh_muc.ToString("#,##0") + " (VNĐ)";
}
else
{
m_lbl_tong_nhan_su.Text = "?";
m_lbl_dinh_muc_dau_nguoi.Text = "?";
m_lbl_tong_dinh_muc.Text = "?";
}
}
