62,046
社区成员
发帖
与我相关
我的任务
分享
<asp:GridView ID="XS" runat="server" AutoGenerateColumns="False" Height="298px" AllowPaging="True" AllowSorting="True" EnableSortingAndPagingCallbacks="True" PageIndex="1" PageSize="3" >
<Columns>
<asp:BoundField DataField="category" HeaderText="类别" />
<asp:BoundField DataField="varieties" HeaderText="品种" />
<asp:BoundField DataField="type" HeaderText="型号" />
<asp:BoundField DataField="color" HeaderText="SKU(花色) " />
<asp:BoundField DataField="layer" HeaderText="耐磨层" />
<asp:BoundField DataField="thickness" HeaderText="总厚度" />
<asp:BoundField DataField="SPECIFICATION" HeaderText="规格(长*宽)" />
<asp:BoundField DataField="METER" HeaderText="平方米" />
<asp:BoundField DataField="Square" HeaderText="在途平方米" />
<asp:BoundField DataField="Data" HeaderText="预计到货日期" />
<asp:BoundField DataField="Number" HeaderText="库存" />
<asp:BoundField DataField="Remark" HeaderText="备注" />
<asp:BoundField DataField="Nmb" HeaderText="盒数或卷数" />
</Columns>
<PagerSettings FirstPageText="首页" LastPageText="尾页" Mode="NextPreviousFirstLast" NextPageText="下一页" PreviousPageText="上一页" />
</asp:GridView>
protected void Page_Load(object sender, EventArgs e)
{
//这个不对吗?不是这样写的吗?
//我是条件查询,查询出来的数据得显示啊.但是显示一下就没了.
if (XS.Rows.Count != 0 )
{
if (!Page.IsPostBack)
{
CX_Click(null, null);
}
}
}
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>");
}
}
}