Esempio n. 1
0
        public US_TBL_GD_THANH_TOAN(decimal i_dbID)
        {
            pm_objDS        = new DS_TBL_GD_THANH_TOAN();
            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]);
        }
Esempio n. 2
0
        public void fill_dataset_tongho_thanhtaon_by_id_giang_vien_thang_nam_dot_va_dv_thanh_toan(
            decimal ip_dc_id_giang_vien,
            decimal ip_dc_id_dv_tt,
            decimal ip_dc_thang_tt,
            decimal ip_dc_nam_tt,
            DS_TBL_GD_THANH_TOAN op_ds_tbl_gd_thanh_toan)
        {
            CStoredProc v_cstore = new CStoredProc("pr_V_GD_THANH_TOAN_GetTongHopThanhToanByGiangVienvaDVThanhToan");

            v_cstore.addDecimalInputParam("@ID_GIANG_VIEN", ip_dc_id_giang_vien);
            v_cstore.addDecimalInputParam("@ID_DON_VI_TT", ip_dc_id_dv_tt);
            v_cstore.addDecimalInputParam("@NAM_TT", ip_dc_nam_tt);
            v_cstore.addDecimalInputParam("@THANG_TT", ip_dc_thang_tt);
            v_cstore.fillDataSetByCommand(this, op_ds_tbl_gd_thanh_toan);
        }
Esempio n. 3
0
 public US_TBL_GD_THANH_TOAN()
 {
     pm_objDS        = new DS_TBL_GD_THANH_TOAN();
     pm_strTableName = c_TableName;
     pm_objDR        = pm_objDS.Tables[pm_strTableName].NewRow();
 }