public US_GD_QUA_TRINH_CONG_TAC(decimal i_dbID) { pm_objDS = new DS_GD_QUA_TRINH_CONG_TAC(); 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 FillDatasetByProc(DS_GD_QUA_TRINH_CONG_TAC op_ds_v_qua_trinh_cong_tac , string ip_str_key_word , string ip_str_lua_chon , DateTime ip_dat_tu_ngay , DateTime ip_dat_den_ngay , decimal ip_dc_id_phap_nhan) { CStoredProc v_stored_proc = new CStoredProc("pr_GD_QUA_TRINH_CONG_TAC"); v_stored_proc.addNVarcharInputParam("@ip_str_search", ip_str_key_word); v_stored_proc.addNVarcharInputParam("@ip_str_lua_chon", ip_str_lua_chon); v_stored_proc.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay); v_stored_proc.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay); v_stored_proc.addDecimalInputParam("@ip_dc_phap_nhan", ip_dc_id_phap_nhan); v_stored_proc.fillDataSetByCommand(this, op_ds_v_qua_trinh_cong_tac); }
private void load_data_2_grid() { m_ds = new DS_GD_QUA_TRINH_CONG_TAC(); m_us.FillDatasetByProc(m_ds, m_txt_tim_kiem.Text.Trim(), m_str_lua_chon, m_dtp_tu_ngay.Value, m_dtp_den_ngay.Value, CAppContext_201.getCurrentIDPhapnhan()); m_fg.Redraw = false; CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans); if (m_rdb_nhom.Checked == true) { m_fg.Subtotal(C1.Win.C1FlexGrid.AggregateEnum.Count , 0 , (int)e_col_Number.MA_NV , (int)e_col_Number.HO_DEM , "{0}" ); } m_fg.Redraw = true; }
public US_GD_QUA_TRINH_CONG_TAC() { pm_objDS = new DS_GD_QUA_TRINH_CONG_TAC(); pm_strTableName = c_TableName; pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow(); }