public US_V_F340_LOP_MON_CUA_HS(decimal i_dbID) { pm_objDS = new DS_V_F340_LOP_MON_CUA_HS(); 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 ITransferDataRow get_trans_object(C1.Win.C1FlexGrid.C1FlexGrid i_fg) { DS_V_F340_LOP_MON_CUA_HS v_ds = new DS_V_F340_LOP_MON_CUA_HS(); Hashtable v_htb = new Hashtable(); v_htb.Add(V_F340_LOP_MON_CUA_HS.TRANG_THAI_YN, e_col_Number.TRANG_THAI_YN); v_htb.Add(V_F340_LOP_MON_CUA_HS.SO_TIEN, e_col_Number.SO_TIEN); v_htb.Add(V_F340_LOP_MON_CUA_HS.NGAY_BAT_DAU, e_col_Number.NGAY_BAT_DAU); v_htb.Add(V_F340_LOP_MON_CUA_HS.NGAY_KET_THUC, e_col_Number.NGAY_KET_THUC); v_htb.Add(V_F340_LOP_MON_CUA_HS.MO_TA, e_col_Number.MO_TA); v_htb.Add(V_F340_LOP_MON_CUA_HS.HO_TEN, e_col_Number.HO_TEN); v_htb.Add(V_F340_LOP_MON_CUA_HS.MA_HOC_SINH, e_col_Number.MA_HOC_SINH); v_htb.Add(V_F340_LOP_MON_CUA_HS.DON_GIA_BUOI_HOC, e_col_Number.DON_GIA_BUOI_HOC); ITransferDataRow v_obj_trans = new CC1TransferDataRow(i_fg, v_htb, v_ds.V_F340_LOP_MON_CUA_HS.NewRow()); return v_obj_trans; }
private void load_data_2_grid() { m_obj_trans = get_trans_object(m_fg); DS_V_F340_LOP_MON_CUA_HS v_ds = new DS_V_F340_LOP_MON_CUA_HS(); US_V_F340_LOP_MON_CUA_HS v_us = new US_V_F340_LOP_MON_CUA_HS(); v_ds.Clear(); v_ds.EnforceConstraints = false; if (m_str_trang_thai_phieu != "F430") { v_us.FillDatasetByIdHS(v_ds, m_us_v_hoc_sinh.dcID); } else { v_us.FillDatasetDuLieuDaCo(v_ds, m_id_gd_phieu_thu); } m_fg.Redraw = false; CGridUtils.Dataset2C1Grid(v_ds, m_fg, m_obj_trans); CGridUtils.MakeSoTT(0, m_fg); m_fg.Redraw = true; }
public US_V_F340_LOP_MON_CUA_HS() { pm_objDS = new DS_V_F340_LOP_MON_CUA_HS(); pm_strTableName = c_TableName; pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow(); }
public void FillDatasetDuLieuDaCo(DS_V_F340_LOP_MON_CUA_HS v_ds, decimal ip_dc_id_gd_phieu_thu) { CStoredProc v_csp = new CStoredProc("pr_f340_get_so_tien_hoc_sinh_theo_phieu"); v_csp.addDecimalInputParam("@ip_dc_id_gd_phieu_thu", ip_dc_id_gd_phieu_thu); v_csp.fillDataSetByCommand(this, v_ds); }
public void FillDatasetByIdHS(DS_V_F340_LOP_MON_CUA_HS v_ds, decimal ip_dc_id_hoc_sinh) { CStoredProc v_csp = new CStoredProc("pr_f430_get_lop_mon_cua_hs"); v_csp.addDecimalInputParam("@ip_dc_id_hoc_sinh", ip_dc_id_hoc_sinh); v_csp.fillDataSetByCommand(this, v_ds); }