/*函数重载，价格区间查询*/
public static DataTable queryByKeyword(int low,int high)
{
shopinfo_phoneinfo_query_view1TableAdapter adpter = new shopinfo_phoneinfo_query_view1TableAdapter();
DataTable table = new DataTable();
table = adpter.GetDataByprice(high ,low);
return table;
}
/*函数重载，价格区间查询*/
public static DataTable queryByKeyword(int low, int high)
{
shopinfo_phoneinfo_query_view1TableAdapter adpter = new shopinfo_phoneinfo_query_view1TableAdapter();
DataTable table = new DataTable();
table = adpter.GetDataByprice(high, low);
return(table);
}
/*函数重载，模糊查询*/
public static DataTable queryByKeyword(string keyword)
{
keyword = "%" + keyword + "%";
keyword = SubString(keyword);
shopinfo_phoneinfo_query_view1TableAdapter adpter = new shopinfo_phoneinfo_query_view1TableAdapter();
DataTable table = new DataTable();
table = adpter.GetDataByAll(keyword);
return table;
}
/*函数重载，模糊查询*/
public static DataTable queryByKeyword(string keyword)
{
keyword = "%" + keyword + "%";
keyword = SubString(keyword);
shopinfo_phoneinfo_query_view1TableAdapter adpter = new shopinfo_phoneinfo_query_view1TableAdapter();
DataTable table = new DataTable();
table = adpter.GetDataByAll(keyword);
return(table);
}
/*品牌，os,cameta,sreenSize查询*/
public static DataTable queryByKeyword(string keyword, int type)
{
int key = 0; double k;
shopinfo_phoneinfo_query_view1TableAdapter adpter = new shopinfo_phoneinfo_query_view1TableAdapter();
DataTable table = new DataTable();
switch (type)
{
case 0:
case 1: table = adpter.GetDataByphonebrand("%" + keyword + "%"); break;
case 2: table = adpter.GetDataByphoneos("%" + keyword + "%"); break;
case 3: table = adpter.GetDataBycolor("%" + keyword + "%"); break;
case 4: table = adpter.GetDataByscreensize("%" + keyword + "%"); break;
}
return table;
}
/*品牌，os,cameta,sreenSize查询*/
public static DataTable queryByKeyword(string keyword, int type)
{
int key = 0; double k;
shopinfo_phoneinfo_query_view1TableAdapter adpter = new shopinfo_phoneinfo_query_view1TableAdapter();
DataTable table = new DataTable();
switch (type)
{
case 0:
case 1: table = adpter.GetDataByphonebrand("%" + keyword + "%"); break;
case 2: table = adpter.GetDataByphoneos("%" + keyword + "%"); break;
case 3: table = adpter.GetDataBycolor("%" + keyword + "%"); break;
case 4: table = adpter.GetDataByscreensize("%" + keyword + "%"); break;
}
return(table);
}
protected void btnSearch_Click(object sender, EventArgs e)
{
if (txtSearch.Text.Trim() != null)
{
dlodsphone.Visible = true;
dlPhone.Visible = false;
keyword = txtSearch.Text.Trim();
shopinfo_phoneinfo_query_view1TableAdapter sct = new shopinfo_phoneinfo_query_view1TableAdapter();
DataTable dacondition = sct.GetDataBycondition('%' + keyword + '%');
dlodsphone.DataSource = dacondition;
dlodsphone.DataBind();
if (dacondition.Rows.Count == 0)
{
Response.Write("<Script>alert('没有找到相关商品！')</Script>");
}
}
else
{
dlodsphone.Visible = false;
dlPhone.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["name"] != null)
{
lblMsg.Text = "欢迎您，" + Session["name"].ToString();
btnQuit.Visible = true;
lblLogin.Visible = false;
lblRegister.Visible = false;
if (Session["name"].ToString().Equals("admin"))
{
publicNav.Visible = false;
adminNav.Visible = true;
}
else
{
publicNav.Visible = true;
adminNav.Visible = false;
}
}
else
{
lblMsg.Text = "亲，欢迎光临!";
btnQuit.Visible = false;
lblRegister.Visible = true;
lblLogin.Visible = true;
publicNav.Visible = false;
adminNav.Visible = false;
}
if (Request.QueryString["phonekeyword"] != null)
{
dlodsphone.Visible = true;
dlPhone.Visible = false;
keyword = Request.QueryString["phonekeyword"].ToString();
txtSearch.Text = keyword;
shopinfo_phoneinfo_query_view1TableAdapter sct = new shopinfo_phoneinfo_query_view1TableAdapter();
DataTable dacondition = sct.GetDataBycondition('%' + keyword + '%');
dlodsphone.DataSource = dacondition;
dlodsphone.DataBind();
if (dacondition.Rows.Count == 0)
{
Response.Write("<Script>alert('没有找到相关商品！')</Script>");
}
}
else
{
dlodsphone.Visible = false;
dlPhone.Visible = true ;
}
Button[] button = { Button1, Button2, Button3, Button4, Button5, Button6, Button7, Button8, Button9,Button10,Button11, Button12, Button13, Button14, Button15,
Button16, Button17, Button18, Button19, Button20, Button21, Button22, Button23, Button24, Button25, Button26, Button27, Button28, Button29, Button30,
Button31, Button32, Button33, Button34, Button35, Button36, Button37, Button38, Button39, Button40, Button41, Button42,Button43, Button44,
Button45, Button46, Button47, Button48, Button49, Button50};
/*品牌*/
DM_phonebrandTableAdapter brandDa = new DM_phonebrandTableAdapter();
DataTable brandTable = brandDa.GetData();
for (int i = 0; i < brandTable.Rows.Count; i++)
{
button[i].Visible = true;
button[i].Text = brandTable.Rows[i]["meaning"].ToString();
}
/*操作系统*/
DM_osTableAdapter osDa = new DM_osTableAdapter();
DataTable osTable = osDa.GetData();
for (int i = 0; i < osTable.Rows.Count; i++)
{
int j = 20;
button[j + i].Visible = true;
button[j + i].Text = osTable.Rows[i]["meaning"].ToString();
}
/*手机颜色*/
DM_colorTableAdapter colorDa = new DM_colorTableAdapter();
DataTable colorTable = colorDa.GetData();
for (int i = 0; i < colorTable.Rows.Count; i++)
{
int j = 30;
button[j + i].Visible = true;
button[j + i].Text = colorTable.Rows[i]["meaning"].ToString();
}
/*屏幕尺寸*/
DM_screensizeTableAdapter screenSizeDa = new DM_screensizeTableAdapter();
DataTable screenSizeTable = screenSizeDa.GetData();
for (int i = 0; i < screenSizeTable.Rows.Count; i++)
{
int j = 40;
button[j + i].Visible = true;
button[j + i].Text = screenSizeTable.Rows[i]["meaning"].ToString();
}
///*价格区间*/
//DM_priceintervalTableAdapter priceIntervalDa = new DM_priceintervalTableAdapter();
//DataTable priceIntervalTable = priceIntervalDa.GetData();
//for (int i = 0; i < priceIntervalTable.Rows.Count; i++)
//{
// int j = 50;
// button[j + i].Visible = true;
// button[j + i].Text = priceIntervalTable.Rows[i]["low"].ToString() + "-" + priceIntervalTable.Rows[i]["high"].ToString();
//}
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
if (txtSearch.Text.Trim()!=null)
{
dlodsphone.Visible = true;
dlPhone.Visible = false;
keyword = txtSearch.Text.Trim();
shopinfo_phoneinfo_query_view1TableAdapter sct = new shopinfo_phoneinfo_query_view1TableAdapter();
DataTable dacondition = sct.GetDataBycondition('%' + keyword + '%');
dlodsphone.DataSource = dacondition;
dlodsphone.DataBind();
if (dacondition.Rows.Count == 0)
{
Response.Write("<Script>alert('没有找到相关商品！')</Script>");
}
}
else
{
dlodsphone.Visible = false;
dlPhone.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["name"] != null)
{
lblMsg.Text = "欢迎您，" + Session["name"].ToString();
btnQuit.Visible = true;
lblLogin.Visible = false;
lblRegister.Visible = false;
if (Session["name"].ToString().Equals("admin"))
{
publicNav.Visible = false;
adminNav.Visible = true;
}
else
{
publicNav.Visible = true;
adminNav.Visible = false;
}
}
else
{
lblMsg.Text = "亲，欢迎光临!";
btnQuit.Visible = false;
lblRegister.Visible = true;
lblLogin.Visible = true;
publicNav.Visible = false;
adminNav.Visible = false;
}
if (Request.QueryString["phonekeyword"] != null)
{
dlodsphone.Visible = true;
dlPhone.Visible = false;
keyword = Request.QueryString["phonekeyword"].ToString();
txtSearch.Text = keyword;
shopinfo_phoneinfo_query_view1TableAdapter sct = new shopinfo_phoneinfo_query_view1TableAdapter();
DataTable dacondition = sct.GetDataBycondition('%' + keyword + '%');
dlodsphone.DataSource = dacondition;
dlodsphone.DataBind();
if (dacondition.Rows.Count == 0)
{
Response.Write("<Script>alert('没有找到相关商品！')</Script>");
}
}
else
{
dlodsphone.Visible = false;
dlPhone.Visible = true;
}
Button[] button = { Button1, Button2, Button3, Button4, Button5, Button6, Button7, Button8, Button9, Button10, Button11, Button12, Button13, Button14, Button15,
Button16, Button17, Button18, Button19, Button20, Button21, Button22, Button23, Button24, Button25, Button26, Button27, Button28, Button29, Button30,
Button31, Button32, Button33, Button34, Button35, Button36, Button37, Button38, Button39, Button40, Button41, Button42, Button43, Button44,
Button45, Button46, Button47, Button48, Button49, Button50 };
/*品牌*/
DM_phonebrandTableAdapter brandDa = new DM_phonebrandTableAdapter();
DataTable brandTable = brandDa.GetData();
for (int i = 0; i < brandTable.Rows.Count; i++)
{
button[i].Visible = true;
button[i].Text = brandTable.Rows[i]["meaning"].ToString();
}
/*操作系统*/
DM_osTableAdapter osDa = new DM_osTableAdapter();
DataTable osTable = osDa.GetData();
for (int i = 0; i < osTable.Rows.Count; i++)
{
int j = 20;
button[j + i].Visible = true;
button[j + i].Text = osTable.Rows[i]["meaning"].ToString();
}
/*手机颜色*/
DM_colorTableAdapter colorDa = new DM_colorTableAdapter();
DataTable colorTable = colorDa.GetData();
for (int i = 0; i < colorTable.Rows.Count; i++)
{
int j = 30;
button[j + i].Visible = true;
button[j + i].Text = colorTable.Rows[i]["meaning"].ToString();
}
/*屏幕尺寸*/
DM_screensizeTableAdapter screenSizeDa = new DM_screensizeTableAdapter();
DataTable screenSizeTable = screenSizeDa.GetData();
for (int i = 0; i < screenSizeTable.Rows.Count; i++)
{
int j = 40;
button[j + i].Visible = true;
button[j + i].Text = screenSizeTable.Rows[i]["meaning"].ToString();
}
///*价格区间*/
//DM_priceintervalTableAdapter priceIntervalDa = new DM_priceintervalTableAdapter();
//DataTable priceIntervalTable = priceIntervalDa.GetData();
//for (int i = 0; i < priceIntervalTable.Rows.Count; i++)
//{
// int j = 50;
// button[j + i].Visible = true;
// button[j + i].Text = priceIntervalTable.Rows[i]["low"].ToString() + "-" + priceIntervalTable.Rows[i]["high"].ToString();
//}
}
}
