public void BindGVYPDetail()
{
string userid = Request.QueryString["userid"].Trim();
string sql = string.Format(" select YFKCID,YFID,YPName,YFKCResidueNum,YFKCPrice,YFKCBuildTime,YFKCQualityGuauaPeriod,YFKCOutsideTimeUp,YFKCExceedQGP,YFKCShare,ROW_NUMBER() OVER(ORDER BY YFID asc) as SerialN " +
" from(select * from ZYF_JG_YFKC where YFID in (select YFID from ZYF_QT_YFPZ where USERID = '{0}')) as AAAA" +
" inner join(select YPName, YPID from ZYF_JG_YP ) as bbbb on AAAA.YPID = bbbb.YPID ", userid);
string YPNum = "";
SqlHelper shr = new SqlHelper();
DataTable dt = shr.Query(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
if (Convert.ToInt32(dt.Rows[i][3].ToString()) < 50)
{
YPNum = YPNum + dt.Rows[i][2].ToString() + ",";
}
}
GVYPDetail.DataSource = dt;
GVYPDetail.DataBind();
Response.Write(string.Format("<script language='javascript'>alert('{0}数目少于50')</script>", YPNum));
shr.CloseConn();
}
protected void BtnQuerykc_Click(object sender, EventArgs e)
{
GVYPDetail.Visible = true;
GVDD.Visible = false;
string userid = Request.QueryString["userid"].Trim();
string sqls = string.Format(" select YFKCID,YFID,YPName,YFKCResidueNum,YFKCPrice," +
"YFKCBuildTime,YFKCQualityGuauaPeriod,YFKCOutsideTimeUp,YFKCExceedQGP,YFKCShare," +
"ROW_NUMBER() OVER(ORDER BY YFID asc) as SerialN from(select * from ZYF_JG_YFKC where YFID" +
" in (select YFID from ZYF_QT_YFPZ )) as AAAA inner join(select YPName, YPID " +
"from ZYF_JG_YP where YPName like '%{0}%') as bbbb on AAAA.YPID = bbbb.YPID ", DDLYP.SelectedItem.Text.ToString());
//清除数据+保持列
DataTable dtClear = (DataTable)GVYPDetail.DataSource;
dtClear.Rows.Clear();
GVYPDetail.DataSource = dtClear;
//重新赋值
SqlHelper shr = new SqlHelper();
DataTable dt = shr.Query(sqls);
GVYPDetail.DataSource = dt;
GVYPDetail.DataBind();
shr.CloseConn();
}
