public US_V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU(decimal i_dbID)
{
pm_objDS = new DS_V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU();
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 US_V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU()
{
pm_objDS = new DS_V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU();
pm_strTableName = c_TableName;
pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
}
public void FillDatasetNguoiThu(
DS_V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU op_ds
, DateTime ip_dat_tu_ngay
, DateTime ip_dat_den_ngay
, decimal ip_dc_id_nguoi_thu)
{
CStoredProc v_obj_spr = new CStoredProc("f360_danh_sach_phieu_thuc_thu_chua_ban_giao");
v_obj_spr.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
v_obj_spr.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
v_obj_spr.addDecimalInputParam("@ip_dc_id_nguoi_thu", ip_dc_id_nguoi_thu);
v_obj_spr.fillDataSetByCommand(this, op_ds);
}
public void FillThongTinHS(DS_V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU op_ds, decimal ip_dc_id_lop_mon)
{
CStoredProc v_csp = new CStoredProc("pr_gen_thong_tin_hoc_sinh_theo_lop");
v_csp.addDecimalInputParam("@ip_dc_id_lop_mon", ip_dc_id_lop_mon);
v_csp.fillDataSetByCommand(this, op_ds);
}
public void FillDataset(
DS_V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU op_ds
, decimal ip_dc_id_hoc_sinh
, DateTime ip_dat_tu_ngay
, DateTime ip_dat_den_ngay
, decimal ip_dc_id_nguoi_thu
, decimal ip_dc_id_loai_phieu_thu
, string ip_str_search)
{
CStoredProc v_obj_spr = new CStoredProc("f430_bao_cao_danh_sach_phieu_thuc_thu");
v_obj_spr.addDecimalInputParam("@ip_dc_id_hoc_sinh", ip_dc_id_hoc_sinh);
v_obj_spr.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
v_obj_spr.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
v_obj_spr.addDecimalInputParam("@ip_dc_id_nguoi_thu", ip_dc_id_nguoi_thu);
v_obj_spr.addNVarcharInputParam("@ip_str_search", ip_str_search);
v_obj_spr.addDecimalInputParam("@ip_dc_id_loai_phieu_thu", ip_dc_id_loai_phieu_thu);
v_obj_spr.fillDataSetByCommand(this, op_ds);
}
private void load_data_2_grid()
{
DS_V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU v_ds = new DS_V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU();
v_ds.Clear();
v_ds.EnforceConstraints = false;
m_us.FillDataset(
v_ds
, m_us_bc_tinh_hinh_tc.dcID
, m_dat_tu_ngay.Value.Date
, m_dat_den_ngay.Value.Date
, CIPConvert.ToDecimal(m_cbo_nhan_vien_thu.SelectedValue)
, CIPConvert.ToDecimal(m_cbo_loai_phieu.SelectedValue)
, m_txt_tim_kien.Text.Trim());
CGridUtils.Dataset2C1Grid(v_ds, m_fg, m_obj_trans);
m_fg.Redraw = true;
create_tree_2grid();
wrap_text_cell();
}
private ITransferDataRow get_trans_object(C1.Win.C1FlexGrid.C1FlexGrid i_fg)
{
DS_V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU v_ds = new DS_V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU();
Hashtable v_htb = new Hashtable();
v_htb.Add(V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU.NGUOI_THU, e_col_Number.NGUOI_THU);
v_htb.Add(V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU.TEN_LOAI_PHIEU_THU, e_col_Number.LOAI_PHIEU);
v_htb.Add(V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU.SO_PHIEU, e_col_Number.SO_PHIEU);
v_htb.Add(V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU.HO_TEN_PH, e_col_Number.HO_TEN_PH);
v_htb.Add(V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU.TIEN_THUC_THU, e_col_Number.TIEN_THUC_THU);
v_htb.Add(V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU.NGAY_THU, e_col_Number.NGAY_THU);
v_htb.Add(V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU.MA_HOC_SINH, e_col_Number.MA_HOC_SINH);
v_htb.Add(V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU.NOI_DUNG, e_col_Number.NOI_DUNG);
v_htb.Add(V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU.TIEN_CON_PHAI_THU, e_col_Number.TIEN_CON_PHAI_THU);
v_htb.Add(V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU.TIEN_GIAM_TRU, e_col_Number.TIEN_GIAM_TRU);
v_htb.Add(V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU.TIEN_PHAI_THU, e_col_Number.TIEN_PHAI_THU);
v_htb.Add(V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU.HO_TEN_HS, e_col_Number.HO_TEN_HS);
ITransferDataRow v_obj_trans = new CC1TransferDataRow(i_fg, v_htb, v_ds.V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU.NewRow());
return v_obj_trans;
}
private void load_data_2_grid()
{
DS_V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU v_ds_ds_pt = new DS_V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU();
US_V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU v_us_ds_pt = new US_V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU();
v_ds_ds_pt.EnforceConstraints = false;
v_ds_ds_pt.Clear();
v_us_ds_pt.FillThongTinHS(v_ds_ds_pt, CIPConvert.ToDecimal(m_cbo_lop_mon.SelectedValue));
CGridUtils.Dataset2C1Grid(v_ds_ds_pt, m_fg, m_obj_trans);
CGridUtils.MakeSoTT(0, m_fg);
//Fill cac cot con lai
for (int v_i_cur_row = m_fg.Rows.Fixed; v_i_cur_row < m_fg.Rows.Count; v_i_cur_row++)
{
m_fg.Rows[v_i_cur_row][(int)e_col_Number.NGAY_THU] = m_dat_tai_ngay.Value.Date;
m_fg.Rows[v_i_cur_row][(int)e_col_Number.NOI_DUNG] = m_txt_noi_dung.Text.Trim();
m_fg.Rows[v_i_cur_row][(int)e_col_Number.HO_TEN_PH] = "PH " + m_fg.Rows[v_i_cur_row][(int)e_col_Number.HO_TEN_HS];
US_V_HT_NGUOI_SU_DUNG v_us_ht_nsd = new US_V_HT_NGUOI_SU_DUNG(CAppContext_201.getCurrentUserID());
m_fg.Rows[v_i_cur_row][(int)e_col_Number.NGUOI_THU] = v_us_ht_nsd.strTEN;
m_fg.Rows[v_i_cur_row][(int)e_col_Number.SO_PHIEU] = "PPT" + m_cbo_lop_mon.SelectedValue.ToString() + "_" + m_fg.Rows[v_i_cur_row][(int)e_col_Number.MA_HOC_SINH];
m_fg.Rows[v_i_cur_row][(int)e_col_Number.TIEN_PHAI_THU] = m_txt_thanh_tien.Text;
}
}
private void load_data_2_grid()
{
m_ds = new DS_V_RPT_BAO_CAO_DANH_SACH_PHIEU_THU();
m_ds.Clear();
m_ds.EnforceConstraints = false;
m_us.FillDatasetNguoiThu(
m_ds
, m_dat_tu_ngay.Value.Date
, m_dat_den_ngay.Value.Date
, CIPConvert.ToDecimal(m_cbo_nhan_vien_thu.SelectedValue));
m_fg.Redraw = true;
create_tree_2grid();
CGridUtils.MakeSoTT(0, m_fg);
wrap_text_cell();
}
