//Bind Line
#region BindLineInfo
public void BindLineInfo()
{
DBFun dbFun = new DBFun();
StringBuilder sbSQL = new StringBuilder();
sbSQL.Append("SELECT PART_NO,REF_EOL_NO,REF_EOL_TYPE,REF_EOL_STATUS,GPOS_STATUS ");
sbSQL.Append(" FROM EOL_LINE");
sbSQL.Append(" WHERE EOL_NO = '" + lblNO.Text.ToString().Trim() + "'");
sbSQL.Append(" AND WEBSITE= '" + reqWebsite.Trim() + "'"); //2019-03-11 mosslin 加卡BU,避免出現重複資料
DataTable dt = dbFun.GetDataTableBySql(sbSQL.ToString(), "BU_DB");
if (dt.Rows.Count > 0)
{
gvPartNo.DataSource = dt;
}
else
{
gvPartNo.DataSource = null;
}
gvPartNo.DataBind();
}
