示例#1
0
        internal static ObservableCollection <JournalVoucher> WhereMemberCodeIs(string memberCode)
        {
            var sqlBuilder = new StringBuilder();

            sqlBuilder.AppendFormat("SELECT * FROM `{0}` WHERE MEM_CODE = ?MEM_CODE", TABLE_NAME);
            DataTable dataTable  = DatabaseController.ExecuteSelectQuery(sqlBuilder.ToString(), new SqlParameter("?MEM_CODE", memberCode));
            var       listRecord = new ObservableCollection <JournalVoucher>();

            foreach (DataRow dataRow in dataTable.Rows)
            {
                var foundRecord = new JournalVoucher();
                foundRecord.SetPropertiesFromDataRow(dataRow);
                listRecord.Add(foundRecord);
            }
            return(listRecord);
        }
示例#2
0
        public static ObservableCollection <JournalVoucher> WhereDocumentNumberIs(int documentNo)
        {
            var sqlBuilder = new StringBuilder();

            sqlBuilder.AppendFormat("SELECT * FROM `{0}` WHERE DOC_NUM = ?DOC_NUM", TABLE_NAME);
            DataTable dataTable  = DatabaseController.ExecuteSelectQuery(sqlBuilder.ToString(), new SqlParameter("?DOC_NUM", documentNo));
            var       listRecord = new ObservableCollection <JournalVoucher>();

            foreach (DataRow dataRow in dataTable.Rows)
            {
                var foundRecord = new JournalVoucher();
                foundRecord.SetPropertiesFromDataRow(dataRow);
                listRecord.Add(foundRecord);
            }
            return(listRecord);
        }