---

01/10/2020- duocnt    868 Views    

---

NỘI DUNG

-    Giả sử đã tạo 1 View với datasource là table ProductInternalTransferLine.     -    Tạo New Method với name transferedDateTime.     -    Tạo Utc Date Time Computed Column và setup properties như sau:         *    Name: transferedDateTime.         *    Label: Transfered DateTime.         *    View Method: transferedDateTime (method đã tạo ở trên).

HÌNH MINH HỌA.

CODE X++

    -    Nội dung code cho method transferedDateTime() của View.

public class ProductInternalTransferBookView extends common
{
    public static server  str transferedDateTime()
    {
        SysDictTable _header = new SysDictTable(tableNum(ProductInternalTransferBookHeader));
        DictView dv = new DictView(tableNum(ProductInternalTransferBookView));
        str selectstatement = strFmt('SELECT TOP 1 %1 FROM %2 WHERE %2.%3 = %4',
            _header.fieldName(fieldNum(ProductInternalTransferBookHeader,CreatedDateTime), DbBackend::Sql),
            _header.name(DbBackend::Sql),
            _header.fieldName(fieldNum(ProductInternalTransferBookHeader,BookId), DbBackend::Sql),
            dv.computedColumnString(tableStr(ProductInternalTransferBookLine), 
                                    fieldStr(ProductInternalTransferBookLine, BookId), 
                                    FieldNameGenerationMode::WhereClause));               
        return strFmt('ISNULL((%1), \'\')', selectstatement);
    }
 
}