//@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) {
}
}
