62,046
社区成员
发帖
与我相关
我的任务
分享
private void bindData()
{
string SupplierNO = "SS110422001";// Session["SupplierNO"];
string ProNO = this.txtProNo.Value;
string ColourNO = this.txtColorNo.Value;
string sql = "usp_ProStock_Sup_Select";
SqlParameter[] myParam = new SqlParameter[] {
new SqlParameter("SupplierNO",SqlDbType.VarChar),
new SqlParameter("@ProNO",SqlDbType.VarChar),
new SqlParameter("@ColourNO",SqlDbType.VarChar),
};
myParam[0].Value = SupplierNO;
myParam[1].Value = ProNO;
myParam[2].Value = ColourNO;
DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.conStr, CommandType.StoredProcedure, sql, myParam);
AspNetPager1.RecordCount = ds.Tables[0].Rows.Count;
int pageSize = AspNetPager1.PageSize = 5;
int pageIndex = AspNetPager1.CurrentPageIndex - 1;
DataSet dd = GVBind(sql, pageIndex, pageSize, SupplierNO, ProNO, ColourNO);
this.rptPD.DataSource = dd.Tables[0];
this.rptPD.DataBind();
}
public static DataSet GVBind(string sqlstring, int page_index, int page_size, string SupplierNO, string ProNO, string ColourNO)
{
int firstPage = page_index * page_size;
SqlConnection conn = new SqlConnection(SqlHelper.conStr);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand();
da.SelectCommand.Connection = conn;
da.SelectCommand.CommandText = sqlstring;
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.Add("@SupplierNO", SqlDbType.VarChar, 50).Value = SupplierNO;
da.SelectCommand.Parameters.Add("@ProNO", SqlDbType.VarChar, 50).Value = ProNO;
da.SelectCommand.Parameters.Add("@ColourNO", SqlDbType.VarChar, 50).Value = ColourNO;
da.Fill(ds, firstPage, page_size, "article");
conn.Close();
return ds;
}
protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
{
AspNetPager1.CurrentPageIndex = e.NewPageIndex;
bindData();
}