//@SearchAutocomplete public void SearchByAutoComplete(string selectItem) { DateTime myDate = SellDate.Value.Date; try { var search_ = "SELECT * FROM Sell_BillMember WHERE S_ID='" + selectItem + "'"; var da_search = Module1.getSqlDataAdapter(search_); DataSet dS_Bill = new DataSet(); Module1.ClearTables(dS_Bill, "Bill_Member"); da_search.Fill(dS_Bill, "Bill_Member"); var dtS = dS_Bill.Tables["Bill_Member"]; if ((dtS.Rows.Count > 0)) { txtSellID.Text = dtS.Rows[0][0].ToString(); txtSellMID.Text = dtS.Rows[0][1].ToString(); cbPackageID.SelectedValue = dtS.Rows[0][2].ToString(); SellDate.Text = dtS.Rows[0][3].ToString(); SellTime.Text = dtS.Rows[0][4].ToString(); OldID = dtS.Rows[0][1].ToString(); setPrice(); } else { Interaction.MsgBox("ບໍ່ມີຂໍ້ມູນໃນລະບົບ", MsgBoxStyle.Information, "ແຈ້ງເຕືອນ"); My.MyProject.Forms.MainComponentForm.txtSearch.Clear(); My.MyProject.Forms.MainComponentForm.txtSearch.Focus(); } } catch (Exception ex) { } }
//@SearchAutocompleteMember public void SearchByAutoComplete(string selectItem) { try { var search_ = "SELECT * FROM Member_Detail WHERE MID LIKE '%" + selectItem + "%' OR [Licence] LIKE N'%" + selectItem + "%' OR [LicenceName] LIKE N'%" + selectItem + "%'"; var da_meb_search = Module1.getSqlDataAdapter(search_); DataSet dtSet_meb = new DataSet(); Module1.ClearTables(dtSet_meb, "res_member"); da_meb_search.Fill(dtSet_meb, "res_member"); var dt_data = dtSet_meb.Tables["res_member"]; if ((dt_data.Rows.Count > 0)) { txtMemberID.Text = dt_data.Rows[0][0].ToString(); txtMemberBikeID.Text = dt_data.Rows[0][1].ToString(); cbBikeIDname.Text = dt_data.Rows[0][2].ToString(); txtBName.Text = dt_data.Rows[0][3].ToString(); txtBModel.Text = dt_data.Rows[0][4].ToString(); txtBMachineNumber.Text = dt_data.Rows[0][5].ToString(); txtBcolor.Text = dt_data.Rows[0][6].ToString(); txtMName.Text = dt_data.Rows[0][7].ToString(); txtMLName.Text = dt_data.Rows[0][8].ToString(); txtMCardID.Text = dt_data.Rows[0][9].ToString(); txtMembrAdress.Text = dt_data.Rows[0][10].ToString(); txtMphone.Text = dt_data.Rows[0][11].ToString(); txtMEmail.Text = dt_data.Rows[0][12].ToString(); } else { Interaction.MsgBox("ບໍ່ມີຂໍ້ມູນໃນລະບົບ", MsgBoxStyle.Information, "ແຂ້ງເຕືອນ"); My.MyProject.Forms.MainComponentForm.txtSearch.Clear(); My.MyProject.Forms.MainComponentForm.txtSearch.Focus(); } } catch (Exception ex) { } }
//@SetSearchAutocomplete public void setSearchAutoCompletion() { //@reset try { //dr.Close() My.MyProject.Forms.MainComponentForm.AutocompleteSearch.Items = new string[] { "" }; My.MyProject.Forms.MainComponentForm.AutocompleteSearch.SetAutocompleteMenu(My.MyProject.Forms.MainComponentForm.txtSearch, My.MyProject.Forms.MainComponentForm.AutocompleteSearch); var da_meb = Module1.getSqlDataAdapter("Select [S_ID] from Sell_BillMember"); DataSet ds_meb = new DataSet(); Module1.ClearTables(ds_meb, "Search_Bill_Member"); da_meb.Fill(ds_meb, "Search_Bill_Member"); if (ds_meb.Tables["Search_Bill_Member"].Rows.Count > 0) { for (int i = 0; i <= ds_meb.Tables["Search_Bill_Member"].Rows.Count - 1; i++) { AutocompleteMenuNS.AutocompleteItem itemAuto = new AutocompleteMenuNS.AutocompleteItem(); var dtSet = ds_meb.Tables["Search_Bill_Member"].Rows[i]; itemAuto.Text = dtSet[0].ToString(); itemAuto.ToolTipText = "Search By Sell Package ID " + itemAuto.Text; itemAuto.ToolTipTitle = "Search A Sell Package By ID"; My.MyProject.Forms.MainComponentForm.AutocompleteSearch.AddItem(itemAuto); } } My.MyProject.Forms.MainComponentForm.AutocompleteSearch.Update(); Module1.ClearReader(ds_meb, da_meb); } catch (Exception ex) { } }
public void setSearchAutoCompletion() { //@reset //dr.Close() try { My.MyProject.Forms.MainComponentForm.AutocompleteSearch.Items = new string[] { "" }; My.MyProject.Forms.MainComponentForm.AutocompleteSearch.SetAutocompleteMenu(My.MyProject.Forms.MainComponentForm.txtSearch, My.MyProject.Forms.MainComponentForm.AutocompleteSearch); var da_meb = Module1.getSqlDataAdapter("Select [MID] , [Licence] , [LicenceName] from Member_Detail"); DataSet ds_meb = new DataSet(); Module1.ClearTables(ds_meb, "Search_members"); da_meb.Fill(ds_meb, "Search_members"); if (ds_meb.Tables["Search_members"].Rows.Count > 0) { for (int i = 0; i <= ds_meb.Tables["Search_members"].Rows.Count - 1; i++) { AutocompleteMenuNS.AutocompleteItem itemAuto = new AutocompleteMenuNS.AutocompleteItem(); var dtSet = ds_meb.Tables["Search_members"].Rows[i]; itemAuto.Text = dtSet[0].ToString(); itemAuto.ToolTipText = "Search By ID " + itemAuto.Text; itemAuto.ToolTipTitle = "Search A Member By ID"; My.MyProject.Forms.MainComponentForm.AutocompleteSearch.AddItem(itemAuto); itemAuto = new AutocompleteMenuNS.AutocompleteItem(); //license itemAuto.Text = dtSet[1].ToString(); itemAuto.ToolTipText = "Search By Licence " + itemAuto.Text; itemAuto.ToolTipTitle = "Search A Member By Licence"; My.MyProject.Forms.MainComponentForm.AutocompleteSearch.AddItem(itemAuto); //license name itemAuto = new AutocompleteMenuNS.AutocompleteItem(); //license itemAuto.Text = dtSet[2].ToString(); itemAuto.ToolTipText = "Search By LicenceName " + itemAuto.Text; itemAuto.ToolTipTitle = "Search A Member By LicenceName"; My.MyProject.Forms.MainComponentForm.AutocompleteSearch.AddItem(itemAuto); } } My.MyProject.Forms.MainComponentForm.AutocompleteSearch.Update(); Module1.ClearReader(ds_meb, da_meb); } catch (Exception ex) { } }