public static AutoCompleteStringCollection LoadAutoComplete(DS_RPT_LUONG_THEO_QD ip_ds) { AutoCompleteStringCollection stringCol = new AutoCompleteStringCollection(); //for(int v_col = 0; v_col < ip_ds.RPT_LUONG_THEO_QD.Columns.Count -1; v_col++) { // stringCol.Add(Convert.ToString(ip_ds.RPT_LUONG_THEO_QD.Rows[0])); // stringCol.Add(Convert.ToString(ip_ds.RPT_LUONG_THEO_QD.Rows[1]) + Convert.ToString(ip_ds.RPT_LUONG_THEO_QD.Rows[2])); //} foreach (DataRow row in ip_ds.RPT_LUONG_THEO_QD) { for (int v_col = 0; v_col < ip_ds.RPT_LUONG_THEO_QD.Columns.Count - 1; v_col++) { if (v_col == 1) { continue; } if (v_col == 2) { stringCol.Add(Convert.ToString(row[1]) + " " + Convert.ToString(row[2])); continue; } stringCol.Add(Convert.ToString(row[v_col])); } } return(stringCol); //return the string collection with added records }
public void FillDatasetByProc(DS_RPT_LUONG_THEO_QD op_ds_rpt, DateTime ip_dau_nam, decimal ip_dc_phap_nhan) { CStoredProc v_sp = new CStoredProc("pr_v_gd_luong_theo_qd"); v_sp.addDatetimeInputParam("@IP_DAU_NAM", ip_dau_nam); v_sp.addDecimalInputParam("@ID_PHAP_NHAN", ip_dc_phap_nhan); v_sp.fillDataSetByCommand(this, op_ds_rpt); }
public US_RPT_LUONG_THEO_QD(decimal i_dbID) { pm_objDS = new DS_RPT_LUONG_THEO_QD(); 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() { //Lay ngay dau nam string v_str_dau_nam = "01/01/" + m_dat_nam.Value.Year; DateTime v_dat = CIPConvert.ToDatetime(v_str_dau_nam); m_ds = new DS_RPT_LUONG_THEO_QD(); m_us.FillDatasetByProc(m_ds, v_dat, CAppContext_201.getCurrentIDPhapnhan()); m_fg.Redraw = false; CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans); m_fg.Redraw = true; wrap_text_all_cells(); CGridUtils.MakeSoTT(0, m_fg); }
private void tim_kiem(DS_RPT_LUONG_THEO_QD ip_ds, string ip_search_text) { DataView v_dv = new DataView(ip_ds.RPT_LUONG_THEO_QD); v_dv.RowFilter = string.Format("MA_NV like '%{0}%' or " + //"NGAY_AP_DUNG_KY_II like '%{0}%' or " + "MA_QD_DAU_KY_I like '%{0}%' or " + //"NGAY_AP_DUNG_GIUA_KY_II like '%{0}%' or " + //"LUONG_CUOI_KY_I = '{0}' or " + "TEN like '%{0}%' or " + //"LUONG_CUOI_KY_II = '{0}' or " + "MA_DON_VI like '%{0}%' or " + "HO_DEM like '%{0}%' or " + "MA_QD_GIUA_KI_I like '%{0}%' or " + "MA_QD_GIUA_KI_II like '%{0}%' or " + //"LUONG_DAU_KY_II like '%{0}%' or " + //"LUONG_DAU_KY_I like '%{0}%' or " + //"LUONG_GIUA_KY_II like '%{0}%' or " + "TRANG_THAI_LD_HIEN_TAI like '%{0}%' or " + "MA_QD_DAU_KY_II like '%{0}%' or " + "HO_DEM + ' '+ TEN like '%{0}%' or " + //"NGAY_AP_DUNG_KY_I like '%{0}%' or " + "MA_CV like '%{0}%'", ip_search_text); //"NGAY_AP_DUNG_GIUA_KY_I like '%{0}%'", ip_search_text); //"LUONG_GIUA_KY_I like '%{0}%'", ip_search_text); DataTable v_dt = v_dv.ToTable(); DataSet v_ds = new DataSet(); v_ds.Tables.Add(v_dt); CGridUtils.Dataset2C1Grid(v_ds, m_fg, m_obj_trans); m_fg.Redraw = true; format_fixed_rows_in_grid(); CGridUtils.MakeSoTT(0, m_fg); }
public US_RPT_LUONG_THEO_QD() { pm_objDS = new DS_RPT_LUONG_THEO_QD(); pm_strTableName = c_TableName; pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow(); }