//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(); }