public US_RPT_BC_TINH_HINH_GIAI_NGAN(decimal i_dbID)
{
pm_objDS = new DS_RPT_BC_TINH_HINH_GIAI_NGAN();
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_2_grid()
{
US_RPT_BC_TINH_HINH_GIAI_NGAN v_us = new US_RPT_BC_TINH_HINH_GIAI_NGAN();
DS_RPT_BC_TINH_HINH_GIAI_NGAN v_ds = new DS_RPT_BC_TINH_HINH_GIAI_NGAN();
//v_us.bc_tinh_hinh_giai_ngan_tong_cuc(
// v_ds,
// CIPConvert.ToDatetime(m_txt_tu_ngay.Text, c_configuration.DEFAULT_DATETIME_FORMAT),
// CIPConvert.ToDatetime(m_txt_den_ngay.Text, c_configuration.DEFAULT_DATETIME_FORMAT),
// m_txt_tu_khoa_tim_kiem.Text
//);
m_grv_bao_cao_giai_ngan.DataSource = v_ds.RPT_BC_TINH_HINH_GIAI_NGAN;
m_grv_bao_cao_giai_ngan.DataBind();
}
public void bc_tinh_hinh_giai_ngan_theo_don_vi(DS_RPT_BC_TINH_HINH_GIAI_NGAN op_ds
, DateTime ip_dat_tu_ngay
, DateTime ip_dat_den_ngay
, DateTime ip_dat_dau_nam
, decimal ip_dc_id_don_vi
, decimal ip_dc_user_id
, decimal ip_dc_id_du_an
, decimal ip_dc_id_cong_trinh
, decimal ip_dc_id_loai_nhiem_vu
, string ip_str_tu_khoa
, string ip_str_nguon_ns)
{
CStoredProc v_sp = new CStoredProc("pr_F350_tinh_hinh_giai_ngan");
v_sp.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
v_sp.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
v_sp.addDatetimeInputParam("@ip_dat_dau_nam", ip_dat_dau_nam);
v_sp.addDecimalInputParam("@ip_dc_id_don_vi", ip_dc_id_don_vi);
v_sp.addDecimalInputParam("@ip_dc_id_user", ip_dc_user_id);
v_sp.addDecimalInputParam("@ip_dc_id_du_an", ip_dc_id_du_an);
v_sp.addDecimalInputParam("@ip_dc_id_cong_trinh", ip_dc_id_cong_trinh);
v_sp.addDecimalInputParam("@ip_dc_id_loai_nhiem_vu", ip_dc_id_loai_nhiem_vu);
v_sp.addNVarcharInputParam("@ip_str_tu_khoa", ip_str_tu_khoa);
v_sp.addNVarcharInputParam("@ip_nguon_ns", ip_str_nguon_ns);
v_sp.fillDataSetByCommand(this, op_ds);
}
public void bc_tinh_hinh_giai_ngan_don_vi(DS_RPT_BC_TINH_HINH_GIAI_NGAN op_ds
, DateTime ip_dat_tu_ngay
, DateTime ip_dat_den_ngay
, decimal ip_dc_id_don_vi
, decimal ip_dc_user_id)
{
CStoredProc v_sp = new CStoredProc("pr_A350_Bao_cao_tinh_hinh_giai_ngan_cua_don_vi");
v_sp.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
v_sp.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
v_sp.addDecimalInputParam("@ip_dc_id_don_vi", ip_dc_id_don_vi);
v_sp.addDecimalInputParam("@ip_dc_id_user", ip_dc_user_id);
v_sp.fillDataSetByCommand(this, op_ds);
}
public US_RPT_BC_TINH_HINH_GIAI_NGAN()
{
pm_objDS = new DS_RPT_BC_TINH_HINH_GIAI_NGAN();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
private void load_data_to_grid()
{
US_RPT_BC_TINH_HINH_GIAI_NGAN v_us = new US_RPT_BC_TINH_HINH_GIAI_NGAN();
DS_RPT_BC_TINH_HINH_GIAI_NGAN v_ds = new DS_RPT_BC_TINH_HINH_GIAI_NGAN();
v_ds.EnforceConstraints = false;
v_ds.AcceptChanges();
v_us.bc_tinh_hinh_giai_ngan_don_vi(v_ds
, CIPConvert.ToDatetime(m_txt_tu_ngay.Text, "dd/MM/yyyy")
, CIPConvert.ToDatetime(m_txt_den_ngay.Text, "dd/MM/yyyy")
, Person.get_id_don_vi()
, Person.get_user_id());
m_grv.DataSource = v_ds.Tables[0];
m_grv.DataBind();
DateTime v_dat_den_ngay=CIPConvert.ToDatetime(m_txt_den_ngay.Text,"dd/MM/yyyy");
m_lbl_thang.Text = v_dat_den_ngay.Month.ToString();
m_lbl_nam.Text = v_dat_den_ngay.Year.ToString();
}
