Ejemplo n.º 1
0
        /*進貨明細*/
        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();
        }