/*進貨明細*/ void prepareStatusList() { string sqlstr = "select '' as status_id, '請選擇驗貨情況' as Status union(select status_id, Status from status where class='Material') order by status_id"; StatusList.DataSource = mydb.GetDataTable(sqlstr); StatusList.DataBind(); }
/*進貨明細*/ void prepareStatusList() { string sqlstr = "select '' as status_id, '' as comment union(select status_id, comment from status where class='Reserve') order by status_id"; StatusList.DataSource = mydb.GetDataTable(sqlstr); StatusList.DataBind(); }