QVariant SqlQueryModelCustomer::data(const QModelIndex & index, int role) const
{
QVariant value = QSqlQueryModel::data(index, role);
if (value.isValid() && role == Qt::DisplayRole && index.column() == 3)
{
value = (value.toInt() == 1 ? tr("男") : tr("女"));
return value;
}
if (value.isValid() && role == Qt::DisplayRole && (index.column() == 2 || index.column() == 3))
{
value = "¥" + value.toString();
return value;
}
if (role == Qt::TextAlignmentRole && index.column() > 1 && index.column() < 5)
{
value = (Qt::AlignVCenter + Qt::AlignRight);
return value;
}
if (role == Qt::TextAlignmentRole && (index.column() == 2 || index.column() == 3 || index.column() == 6))
{
value = (Qt::AlignCenter);
return value;
}
return value;
}
这是"顾客管理"对数据处理程序,这里是没有对日期的处理,而时期是显示正确,"消费次数"和这个差不多,显示不正确,有点糊涂,麻烦老大再指点1,2.