62,268
社区成员
发帖
与我相关
我的任务
分享 private MySqlConnection con = null;
private int page = 1;
private int totalPage;
private int count = 3;
protected void Page_Load(object sender, EventArgs e)
{
this.getTotalPage();
if(!Page.IsPostBack)
{
last_Click(null, null);
}
if (!IsPostBack)
{
DrLB();
DrHD();
DrPP();
DrHS();
DrNMC();
}
}
public void DrLB() //类别
{
DB db = new DB();
string sqlstr = "SELECT CategoryID,Category FROM Category ";
DataTable dt = db.reDt(sqlstr);
LB.DataSource = dt;
LB.DataBind();
}
public void DrPP() //品牌
{
DB db = new DB();
string sqlstr = "SELECT VarietiesID,Varieties,VCID FROM Varieties ";
DataTable dt = db.reDt(sqlstr);
PP.DataSource = dt;
PP.DataBind();
}
public void DrHS() //花色
{
DB db = new DB();
string sqlstr = "SELECT ColorID,Color,CVID FROM Color ";
DataTable dt = db.reDt(sqlstr);
HS.DataSource = dt;
HS.DataBind();
}
public void DrNMC() //耐磨层
{
DB db = new DB();
string sqlstr = "SELECT LayerID,Layer,LCID FROM Layer ";
DataTable dt = db.reDt(sqlstr);
NMC.DataSource = dt;
NMC.DataBind();
}
public void DrHD() //厚度
{
DB db = new DB();
string sqlstr = "SELECT ThicknessID,Thickness,TLID FROM Thickness ";
DataTable dt = db.reDt(sqlstr);
HD.DataSource = dt;
HD.DataBind();
}
public void GVxs() //GridView显示
{
DB db = new DB();
string sqlstr = "select ID,category,varieties,type,color,layer,thickness,SPECIFICATION,METER,Square,Data,Number,Remark,Nmb FROM category,varieties,color,layer,thickness,kc where Category.CategoryID=kc.CategoryID and Varieties.VarietiesID=kc.VarietiesID AND Color.ColorID=kc.ColorID AND Layer.LayerID = kc.LayerID and Thickness.ThicknessID = kc.ThicknessID ORDER BY KC.ID ASC LIMIT " + (page - 1) * count + "," + count;
DataTable dt = db.reDt(sqlstr);
XS.DataSource = dt;
XS.DataBind();
}
private void getTotalPage()
{
try
{
con.Open();
string sql = "SELECT count(*) cou FROM KC";
MySqlCommand command = new MySqlCommand(sql, con);
MySqlDataReader mdr = command.ExecuteReader();
mdr.Read();
double totalCount = Convert.ToDouble(mdr[0]);
this.totalPage = Convert.ToInt16(Math.Ceiling(totalCount / this.count));
con.Close();
}
catch (Exception) { }
if (con != null && con.State == ConnectionState.Open)
con.Close();
}
//类别下拉框事件
protected void LB_SelectedIndexChanged(object sender, EventArgs e)
{
DB db = new DB();
string sqlstr = "SELECT VarietiesID,Varieties,VCID FROM Varieties where VCID ='" + this.LB.SelectedValue + "' ";
DataTable dt = db.reDt(sqlstr);
PP.DataSource = dt;
PP.DataBind();
}
//品牌下拉框事件
protected void PP_SelectedIndexChanged(object sender, EventArgs e)
{
DB db = new DB();
string sqlstr = "SELECT ColorID,Color,CVID FROM Color where CVID='" + this.PP.SelectedValue + "'";
DataTable dt = db.reDt(sqlstr);
HS.DataSource = dt;
HS.DataBind();
string sqlstr1 = "SELECT LayerID,Layer,typeID FROM Layer where typeID = '" + this.PP.SelectedValue + "'";
DataTable dt1 = db.reDt(sqlstr1);
NMC.DataSource = dt1;
NMC.DataBind();
}
//花色下拉框事件
protected void HS_SelectedIndexChanged(object sender, EventArgs e)
{
//DB db = new DB();
//string sqlstr = "SELECT LayerID,Layer,LCID FROM Layer where LCID = '" + this.HS.SelectedValue + "'";
//DataTable dt = db.reDt(sqlstr);
//NMC.DataSource = dt;
//NMC.DataBind();
}
//耐磨层下拉框事件
protected void NMC_SelectedIndexChanged(object sender, EventArgs e)
{
DB db = new DB();
string sqlstr = "SELECT ThicknessID,Thickness,TLID FROM Thickness where TLID = '" + this.NMC.SelectedValue + "' ";
DataTable dt = db.reDt(sqlstr);
HD.DataSource = dt;
HD.DataBind();
}
//查询按钮事件
protected void CX_Click(object sender, EventArgs e)
{
if (this.XH.Text == "" || this.XH.Text.Length == 0)
{
//打开就弹出这个.我查询事件点击才会发生的把.
Response.Write("<script>alert('型号不能为空')</script>");
}
else
{
DB db = new DB();
string sqlstr = "select ID,category,varieties,type,color,layer,thickness,SPECIFICATION,METER,Square,Data,Number,Remark,Nmb FROM category,varieties,color,layer,thickness,kc where kc.CategoryID = '" + this.LB.SelectedValue + "'and kc.VarietiesID = '" + this.PP.SelectedValue + "' AND kc.ColorID = '" + this.HS.SelectedValue + "'AND kc.LayerID = '" + this.NMC.SelectedValue + "' and kc.ThicknessID = '" + this.HD.SelectedValue + "'and kc.type like '%" + this.XH.Text + "%' and kc.Number >= '" + this.KC1.Text + "'and Category.CategoryID=kc.CategoryID and Varieties.VarietiesID=kc.VarietiesID AND Color.ColorID=kc.ColorID AND Layer.LayerID = kc.LayerID and Thickness.ThicknessID = kc.ThicknessID ORDER BY KC.ID ASC LIMIT " + (page - 1) * count + "," + count;
DataTable dt = db.reDt(sqlstr);
XS.DataSource = dt;
XS.DataBind();
if (XS.Rows.Count == 0)
{
Response.Write("<script>alert('没有此类型')</script>");
}
}
}
//首页
//protected void first_Click(object sender, EventArgs e)
//{
// this.page = 1;
// this.nowPage.Value = "1";
// GVxs();
// CX_Click(null,null);
//}
//!//上一页
protected void last_Click(object sender, EventArgs e)
{
this.page = Convert.ToInt16(this.nowPage.Value);
this.page = this.page - 1;
if (this.page < 1)
{
this.page = 1;
}
this.nowPage.Value = Convert.ToString(this.page);
GVxs();
CX_Click(null, null);
}
//下一页
protected void next_Click(object sender, EventArgs e)
{
this.page = Convert.ToInt16(this.nowPage.Value);
this.page = this.page + 1;
this.nowPage.Value = Convert.ToString(this.page);
GVxs();
CX_Click(null, null);
}
protected void Button1_Click(object sender, EventArgs e)
{
}
//尾页
//protected void end_Click(object sender, EventArgs e)
//{
// this.page = this.totalPage;
// this.nowPage.Value = Convert.ToString(this.totalPage);
// GVxs();
// CX_Click(null, null);
//}
}
}