void CQueryDialog::refreshMaterialList()
{
CString indexName;
CString keyWord;
m_QueryIndex.GetWindowText(indexName);
m_Keyword.GetWindowText(keyWord);
CString sql("select * from materials where ");
CString csQueryCond;
if (indexName == "材料编号")
{
csQueryCond.Format(" ID = %s ", keyWord.GetBuffer(0));
}
if (indexName == "材料名称")
{
csQueryCond.Format("NAME = '%s' ", keyWord);
}
sql += csQueryCond;
//get the result data set
_RecordsetPtr& dbptr = SQLExecutor::getInstanceRef().execquery(sql);
CString headerArray[2] ={"ID", "NAME"};
std::vector<CString> headerList(headerArray, headerArray + 2);
uiutils::updatelist(dbptr, m_ResultList, headerList);
}
void CQueryDialog::refreshUserList()
{
CString indexName;
CString keyWord;
CString sql("select * from users where " );
CString csQueryCond;
if (indexName == "用户编号")
{
csQueryCond.Format("id = %s", keyWord.GetBuffer(0));
}
if (indexName == "人员姓名")
{
csQueryCond.Format("name = '%s'", keyWord);
}
if (indexName == "权限" )
{
csQueryCond.Format("permision = '%s'", keyWord);
}
sql += csQueryCond;
//get the result data set
_RecordsetPtr& dbptr = SQLExecutor::getInstanceRef().execquery(sql);
CString headerArray[3] ={"id", "name", "permission"};
std::vector<CString> headerList(headerArray, headerArray + 3);
uiutils::updatelist(dbptr, m_ResultList, headerList);
}
void FetchResponseData::populateWebServiceWorkerResponse(WebServiceWorkerResponse& response)
{
if (m_internalResponse) {
m_internalResponse->populateWebServiceWorkerResponse(response);
response.setResponseType(fetchTypeToWebType(m_type));
return;
}
response.setURL(url());
response.setStatus(status());
response.setStatusText(statusMessage());
response.setResponseType(fetchTypeToWebType(m_type));
for (size_t i = 0; i < headerList()->size(); ++i) {
const FetchHeaderList::Header* header = headerList()->list()[i].get();
response.appendHeader(header->first, header->second);
}
}
void CMaterialManagementDialog::initList()
{
_RecordsetPtr dbptr = SQLExecutor::getInstanceRef().execquery(CString("select * from materials order by id"));
CString headerArray[4] = {"id", "name","batchnumber","manufacture"};
std::vector<CString> headerList(headerArray, headerArray + 4);
uiutils::updatelist(dbptr, m_MaterialList, headerList);
}
inboxMessages::inboxMessages(account* acc, legami* boss, QWidget *parent) :
QWidget(parent), accToShow(acc), Boss(boss)
{
layout= new QVBoxLayout(this);
messVector=Boss->messageReceved(accToShow->user()->user());
showMess=0;
inboxList= new QTableView(this);
QStringList headerList(tr("Sender"));
headerList.append(tr("Object"));
inboxModel= new QStandardItemModel(this);
QStandardItem* inboxRoot= inboxModel->invisibleRootItem();
QList<QStandardItem*> senderList;
QList<QStandardItem*> objList;
QList<QStandardItem*> readList;
QVector<message*>::iterator it=messVector.begin();
for(;it<messVector.end();++it){
QStandardItem* senderItem= new QStandardItem((*it)->sender()->user()->user());
QStandardItem* objItem= new QStandardItem((*it)->object());
QStandardItem* readItem=0;
if((*it)->read()) readItem= new QStandardItem(tr("Read"));
else readItem= new QStandardItem(tr("Not Read"));
senderItem->setEnabled(false);
objItem->setEditable(false);
readItem->setEditable(false);
senderList.push_back(senderItem);
objList.push_back(objItem);
readList.push_back(readItem);
}
inboxRoot->appendColumn(senderList);
inboxRoot->appendColumn(objList);
inboxRoot->appendColumn(readList);
inboxList->setModel(inboxModel);
inboxList->resizeColumnsToContents();
connect(inboxList, SIGNAL(clicked(QModelIndex)), this, SLOT(selected(QModelIndex)));
layout->addWidget(inboxList);
setLayout(layout);
}
void FetchResponseData::populateWebServiceWorkerResponse(
WebServiceWorkerResponse& response) {
if (m_internalResponse) {
m_internalResponse->populateWebServiceWorkerResponse(response);
response.setResponseType(fetchTypeToWebType(m_type));
response.setCorsExposedHeaderNames(
headerSetToWebVector(m_corsExposedHeaderNames));
return;
}
response.setURLList(m_urlList);
response.setStatus(status());
response.setStatusText(statusMessage());
response.setResponseType(fetchTypeToWebType(m_type));
response.setResponseTime(responseTime());
response.setCacheStorageCacheName(cacheStorageCacheName());
response.setCorsExposedHeaderNames(
headerSetToWebVector(m_corsExposedHeaderNames));
for (size_t i = 0; i < headerList()->size(); ++i) {
const FetchHeaderList::Header* header = headerList()->list()[i].get();
response.appendHeader(header->first, header->second);
}
}
// -----------------------------------------------------------------------------
// CSIPMessage::AddHeaderL
// -----------------------------------------------------------------------------
//
EXPORT_C void CSIPMessage::AddHeaderL (CSIPHeaderBase* aSIPHeader)
{
__ASSERT_ALWAYS (aSIPHeader != 0, User::Leave(KErrArgument));
__ASSERT_ALWAYS (!(aSIPHeader->IsExtensionHeader() &&
SIPHeaderLookup::IsSupported(aSIPHeader->Name())),
User::Leave(KErrSipCodecNotAllowed));
// Never add the Content-Length header. Instead store its value.
if (IsContentLengthHeader(*aSIPHeader))
{
if (iAnnouncedContentLengthSet)
{
User::Leave(KErrAlreadyExists);
}
iAnnouncedContentLengthSet = ETrue;
iAnnouncedContentLength =
(static_cast<CSIPContentLengthHeader*>(aSIPHeader))->Value();
delete aSIPHeader;
return;
}
TInt index = FindHeaderListIndex (*aSIPHeader);
if (index == KErrNotFound) // Insert as the head of a new header list.
{
TSglQue<CSIPHeaderBase> headerList(KSIPHeaderOffset);
headerList.AddLast (*aSIPHeader);
InsertL (headerList);
}
else // Try to add to existing header list
{
if (!aSIPHeader->MoreThanOneAllowed())
{
User::Leave(KErrAlreadyExists);
}
iSIPHeaderListArray[index].AddLast(*aSIPHeader);
}
}
void CFetchAmountInputDialog::OnOK()
{
if (!utils::isdouble(&m_FetchAmount))
{
AfxMessageBox("请确认输入！");
return;
}
CString fetchAmount;
m_FetchAmount.GetWindowText(fetchAmount);
CString formulaName, formulaAmount;
double dFormulaAmount, dFetchAmount;
//查询formula表中成品量的多少
CString sql;
sql.Format("select name, total from formulas where id = %s ", SingletonHelper::getInstance()->getFormulaID());
//get the result data set
_RecordsetPtr& dbptr = SQLExecutor::getInstanceRef().execquery(sql);
try
{
_variant_t vFormulaName;
_variant_t vAmount;
while(!dbptr->adoEOF)
{
vFormulaName = dbptr->GetCollect("NAME");
vAmount = dbptr->GetCollect("TOTAL");
if (vFormulaName.vt != VT_NULL)
{
formulaName = (LPCTSTR)(_bstr_t)vFormulaName;
}
if (vAmount.vt != VT_NULL)
{
formulaAmount = (LPCTSTR)(_bstr_t)vAmount;
}
dbptr->MoveNext();
}
}
catch(_com_error &e)
{
AfxMessageBox(e.Description());
}
dFormulaAmount = atof(formulaAmount.GetBuffer(0));
dFetchAmount = atof(fetchAmount.GetBuffer(0));
if (dFetchAmount > dFormulaAmount)
{
AfxMessageBox("成品量不足，请确认有足够的成品");
return;
}
//更新formula表
CString newAmount(utils::double2cstr(dFormulaAmount - dFetchAmount));
sql.Format("update formulas set total = %s where id = %s", newAmount, SingletonHelper::getInstance()->getFormulaID());
dbptr = SQLExecutor::getInstanceRef().execquery(sql);
//首先取得系统时间
CTime currentTime = CTime::GetCurrentTime();
CString date = currentTime.Format("%Y-%m-%d");
CString time = currentTime.Format("%X");
CString fetchRectordID = utils::gettimestamp();
sql.Format("insert into fetchrecords(formulaid, formulaname, operatorid, operatorname, amount, odate, otime) values('%s', '%s', '%s', '%s', %s, '%s', '%s') ",
SingletonHelper::getInstance()->getFormulaID(), formulaName,
CWeightApp::getuserid(), CWeightApp::getusername(),
fetchAmount, date, time);
SQLExecutor::getInstanceRef().execquery(sql);
CFormulaDialog* pFD = (CFormulaDialog*)SingletonHelper::getInstance()->getPtrData();
pFD->initList();
if (m_PrintCheck.GetCheck())
{
//为打印做准备
printVector.push_back(fetchRectordID);
printVector.push_back(formulaName);
printVector.push_back(fetchAmount + "Kg");
printVector.push_back(CWeightApp::getusername());
printVector.push_back(CString(""));
printVector.push_back(CString(""));
printVector.push_back(CString(""));
printVector.push_back(CString(""));
CString headerArray[8] = {"生产批号","配方名称","领取重量","混料人姓名","称重日期","称重时间","领取人姓名","领料日期"};;
std::vector<CString> headerList(headerArray, headerArray + 8);
utils::printVector(CString("成品领取记录"), headerList, printVector);
printVector.clear();
}
CDialog::OnOK();
}
