#pragma once
|
|
#include "wobject/xcontrol.hpp"
|
#include "kobject/kdwgrid.hpp"
|
#include "wobject/xurl.hpp"
|
#include "wobject/xaserverarg.hpp"
|
|
|
using kdwgrid = Hxsoft::XFrame::XOffice::XCell::IGridReport;
|
class xdwgrid : public xcontrol
|
{
|
public:
|
xdwgrid() :xcontrol(nullptr) {}
|
xdwgrid(void * implptr):xcontrol(implptr){}
|
public:
|
xdwgrid & operator =(const kcontrol* pcontrol)
|
{
|
this->setNativePointer((void *)pcontrol);
|
return *this;
|
}
|
public:
|
kdwgrid* getKReport() { return (kdwgrid*)this->GetNativePtr(); }
|
public:
|
int GetRow() { return getKReport()->GetRow_(); }
|
int GetColumn() { return getKReport()->GetColumn_(); }
|
|
int GetRowCount() { return getKReport()->GetRowCount_(); }
|
int SetRow(int row) { return getKReport()->SetRow_(row); }
|
public:
|
int GetColumnCount() { return getKReport()->GetColumnCount_(); }
|
LPCTSTR GetColumnName(int col) { return getKReport()->GetColumnName_(col); }
|
int GetColumnIndex(LPCTSTR pColumn) { return getKReport()->GetColumnIndex_(pColumn); }
|
public:
|
xstring GetItemString(int nRow, int nColumn, kdwgrid::DWBuffer dwBuffer = kdwgrid::dbuf_normal)
|
{
|
return getKReport()->GetItemString_(nRow, nColumn, dwBuffer);
|
}
|
xstring GetItemString(int nRow, LPCTSTR ColumnName, kdwgrid::DWBuffer dwBuffer = kdwgrid::dbuf_normal)
|
{
|
return getKReport()->GetItemString_(nRow, ColumnName, dwBuffer);
|
}
|
bool SetItemString(int nRow, int nColumn, LPCTSTR lptStr, kdwgrid::DWBuffer dwBuffer = kdwgrid::dbuf_normal)
|
{
|
return getKReport()->SetItemString_(nRow, nColumn, lptStr, dwBuffer);
|
}
|
bool SetItemString(int nRow, LPCTSTR ColumnName, LPCTSTR lptStr, kdwgrid::DWBuffer dwBuffer = kdwgrid::dbuf_normal)
|
{
|
return getKReport()->SetItemString_(nRow, ColumnName, lptStr, dwBuffer);
|
}
|
public:
|
int SaveAs(LPCTSTR pXmlArg = NULL) //另存为
|
{
|
return getKReport()->SaveAs_(pXmlArg);
|
}
|
int SaveAs(KXMLDOMDocument& xml, LPCTSTR pFileName = NULL) //另存为
|
{
|
return getKReport()->SaveAs_(xml,pFileName);
|
}
|
|
public:
|
int InsertRow(int nRow) { return getKReport()->InsertRow_(nRow); }
|
int DeleteRow(int nRow) { return getKReport()->DeleteRow_(nRow); }
|
public:
|
int GetXml(BSTR& bstr) { return getKReport()->GetXml_(bstr); }
|
int GetXml(BSTR& bstr, LPCTSTR pGuid) { return getKReport()->GetXml_(bstr, pGuid); }
|
int LoadXml(BSTR bstr) { return getKReport()->LoadXml_(bstr); }
|
int Load(KXMLDOMElement pElement) { return getKReport()->Load_(pElement); }
|
public:
|
int SetReadOnly(bool bReadOnly = true) { return getKReport()->SetReadOnly_(bReadOnly); }
|
public:
|
int SelectRow(int nRow, bool bSelect = true) { return getKReport()->SelectRow_(nRow, bSelect); }
|
int SelectRow(int sRow, int eRow, bool bSelect = true) { return getKReport()->SelectRow_(sRow, eRow, bSelect); }
|
int GetNextSelectRow(int nStartRow) { return getKReport()->GetNextSelectRow_(nStartRow); }
|
bool IsRowSelected(int nRow) { return getKReport()->IsRowSelected_(nRow); }
|
//int SetSelectBkColor(COLORREF color){return getKReport()->SetSelectBkColor_(color);}
|
int SetSelectionMode(int nMode) { return getKReport()->SetSelectionMode_(nMode); } //0 unselection 1 singleSelection 2 multiselection 3 multiselectionex
|
|
public:
|
int DwUpdateTo(KXMLDOMDocument pXmlDoc) { return getKReport()->DwUpdateTo_(pXmlDoc); }
|
int DwUpdateAllTo(KXMLDOMDocument pXmlDoc) { return getKReport()->DwUpdateAllTo_(pXmlDoc); }
|
public:
|
int Retrieve(LPCTSTR pServer, LPCTSTR pDataUrl, LPCTSTR pArgStr) { return getKReport()->Retrieve_(pServer, pDataUrl, pArgStr); }//读取数据
|
//int Retrieve(ITrans *pTrans,LPCTSTR pDataUrl, LPCTSTR pArgStr);//读取数据
|
int Retrieve(LPCTSTR pDataUrl, LPCTSTR pArgStr) { return getKReport()->Retrieve_(pDataUrl, pArgStr); }//读取数据
|
|
int Retrieve(KXMLDOMElement pElement) { return getKReport()->Retrieve_(pElement); }//读取数据
|
int Retrieve(KXMLDOMDocument& xml) { return getKReport()->Retrieve_(xml); }//读取数据
|
|
public:
|
int SetDataObject(LPCTSTR pServer, LPCTSTR pUrl) { return getKReport()->SetDataObject_(pServer, pUrl); }//设置模板对象
|
//virtual int SetDataObject(ITrans *pTrans,LPCTSTR pUrl) ;//设置模板对象
|
int SetDataObject(LPCTSTR pUrl) { return getKReport()->SetDataObject_(pUrl); }//设置模板对象
|
|
int SetDataObject(KXMLDOMElement pElement) { return getKReport()->SetDataObject_(pElement); }//设置模板对象
|
int SetDataObject(KXMLDOMDocument pDoc) { return getKReport()->SetDataObject_(pDoc); }
|
public:
|
int ImportFile() { return getKReport()->ImportFile_(); }
|
int ImportFile(LPCTSTR pStrFile, LPCTSTR pType = NULL, bool Header = false) { return getKReport()->ImportFile_(pStrFile, pType, Header); }
|
int ImportString(LPCTSTR pStr, LPCTSTR pType = NULL, bool Header = false) { return getKReport()->ImportString_(pStr, pType, Header); }
|
|
public:
|
int Reset() { return getKReport()->Reset_(); }
|
int ResetUpdateStatus() { return getKReport()->ResetUpdateStatus_(); }
|
|
public:
|
int event_ItemFocusChanged(int nRow, int nCol) { return getKReport()->event_ItemFocusChanged_(nRow, nCol); }
|
int event_RowFocusChanged(int nRow, int nOldRow) { return getKReport()->event_RowFocusChanged_(nRow, nOldRow); }
|
int event_GetFocus() { return getKReport()->event_GetFocus_(); }
|
int event_LoseFocus() { return getKReport()->event_LoseFocus_(); }
|
int event_ItemChanged(int nRow, int nCol, LPCTSTR pData) { return getKReport()->event_ItemChanged_(nRow, nCol, pData); }
|
int event_ItemChanging(int nRow, int nCol, LPCTSTR pData) { return getKReport()->event_ItemChanging_(nRow, nCol, pData); }
|
public:
|
int GetDwType() { return getKReport()->GetDwType_(); }
|
public:
|
KXMLDOMElement GetRowElement(int nRow) { return getKReport()->GetRowElement(nRow); }
|
public:
|
int InsertCol(int nCol, LPCTSTR pCaption, LPCTSTR pColName, int nWidth, LPCTSTR pColPath = NULL, LPCTSTR pStyleClass = NULL,
|
LPCTSTR pEditClass = NULL, LPCTSTR pFormatClass = NULL)
|
{
|
return getKReport()->InsertCol(nCol, pCaption, pColName, nWidth, pColPath, pStyleClass, pEditClass, pFormatClass);
|
}
|
int RemoveCol(int nCol) { return getKReport()->RemoveCol(nCol); }
|
int RemoveVCol(int nCol) { return getKReport()->RemoveVCol(nCol); }
|
int RemoveCol(LPCTSTR pColName) { return getKReport()->RemoveCol(pColName); }
|
|
int AddEditStyle(LPCTSTR pName, LPCTSTR pStr) { return getKReport()->AddEditStyle(pName, pStr); }
|
int RemoveEditStyle(LPCTSTR pName, LPCTSTR pStr) { return getKReport()->RemoveEditStyle(pName, pStr); }
|
int SetColEditStyle(LPCTSTR pColName, LPCTSTR pClassName) { return getKReport()->SetColEditStyle(pColName, pClassName); }
|
int SetDDLBData(LPCTSTR pColName, LPCTSTR pData) { return getKReport()->SetDDLBData(pColName, pData); }
|
LPCTSTR GetDDLBData(LPCTSTR pColName) { return getKReport()->GetDDLBData(pColName); }
|
public:
|
bool ItemChangeTo(int nRow, int nColumn, LPCTSTR lptStr, kdwgrid::DWBuffer dwBuffer = kdwgrid::dbuf_normal)
|
{
|
return getKReport()->ItemChangeTo(nRow, nColumn, lptStr, dwBuffer);
|
}
|
bool ItemChangeTo(int nRow, LPCTSTR ColumnName, LPCTSTR lptStr, kdwgrid::DWBuffer dwBuffer = kdwgrid::dbuf_normal)
|
{
|
return getKReport()->ItemChangeTo(nRow, ColumnName, lptStr, dwBuffer);
|
}
|
|
public:
|
int CreateTree(LPCWSTR pPath, int nCol, int nImage1, int nImage2)
|
{
|
return getKReport()->CreateTree(pPath, nCol, nImage1, nImage2);
|
}
|
int GetContentRow(int nRow)
|
{
|
return getKReport()->GetContentRow(nRow);
|
}
|
public:
|
int DwUpdateAllToEx(KXMLDOMDocument pXmlDoc)
|
{
|
return getKReport()->DwUpdateAllToEx(pXmlDoc);
|
}
|
public:
|
int DwShareTo(kdwgrid* pPrimaryReport)
|
{
|
return getKReport()->DwShareTo(pPrimaryReport);
|
}
|
public:
|
int SetAskStyle(bool bAskStyle)
|
{
|
return getKReport()->SetAskStyle(bAskStyle);
|
}
|
int CreateTreeEx(LPCTSTR pPath, int nCol, int nImage1, int nImage2)
|
{
|
return getKReport()->CreateTreeEx(pPath, nCol,nImage1, nImage2);
|
}
|
public:
|
LPCTSTR GetItemDisplayString(int nRow, int nColumn, kdwgrid::DWBuffer dwBuffer = kdwgrid::dbuf_normal)
|
{
|
return getKReport() -> GetItemDisplayString(nRow, nColumn, dwBuffer);
|
}
|
LPCTSTR GetItemDisplayString(int nRow, LPCTSTR ColumnName, kdwgrid::DWBuffer dwBuffer = kdwgrid::dbuf_normal)
|
{
|
return getKReport()->GetItemDisplayString(nRow, ColumnName, dwBuffer);
|
}
|
bool SetItemDisplayString(int nRow, int nColumn, LPCTSTR lptStr, kdwgrid::DWBuffer dwBuffer = kdwgrid::dbuf_normal)
|
{
|
return getKReport()->SetItemDisplayString(nRow, nColumn, lptStr, dwBuffer);
|
}
|
bool SetItemDisplayString(int nRow, LPCTSTR ColumnName, LPCTSTR lptStr, kdwgrid::DWBuffer dwBuffer = kdwgrid::dbuf_normal)
|
{
|
return getKReport()->SetItemDisplayString(nRow, ColumnName, lptStr, dwBuffer);
|
}
|
|
LPCTSTR GetItemTipString(int nRow, int nColumn, kdwgrid::DWBuffer dwBuffer = kdwgrid::dbuf_normal)
|
{
|
return getKReport()->GetItemTipString(nRow, nColumn, dwBuffer);
|
}
|
LPCTSTR GetItemTipString(int nRow, LPCTSTR ColumnName, kdwgrid::DWBuffer dwBuffer = kdwgrid::dbuf_normal)
|
{
|
return getKReport()->GetItemTipString(nRow, ColumnName, dwBuffer);
|
}
|
bool SetItemTipString(int nRow, int nColumn, LPCTSTR lptStr, kdwgrid::DWBuffer dwBuffer = kdwgrid::dbuf_normal)
|
{
|
return getKReport()->SetItemTipString(nRow, nColumn, lptStr, dwBuffer);
|
}
|
bool SetItemTipString(int nRow, LPCTSTR ColumnName, LPCTSTR lptStr, kdwgrid::DWBuffer dwBuffer = kdwgrid::dbuf_normal)
|
{
|
return getKReport()->SetItemTipString(nRow, ColumnName, lptStr, dwBuffer);
|
}
|
public:
|
int AllowSort(bool sort)
|
{
|
return getKReport()->AllowSort(sort);
|
}
|
public:
|
int FindByColumn(int startRow, int columnIndex, LPCTSTR columnValue)
|
{
|
return getKReport()->FindByColumn(startRow, columnIndex, columnValue);
|
}
|
int FindByColumn(int startRow, LPCTSTR column, LPCTSTR columnValue)
|
{
|
return getKReport()->FindByColumn(startRow,column,columnValue);
|
}
|
|
int SetReadOnlyColumn(int columnIndex, bool flag = true)
|
{
|
return getKReport()->SetReadOnlyColumn(columnIndex, flag);
|
}
|
int SetReadOnlyColumn(LPCTSTR column, bool flag = true)
|
{
|
return getKReport()->SetReadOnlyColumn(column, flag);
|
}
|
|
int SetColumnWidth(int columnIndex, int width = 1)
|
{
|
return getKReport()->SetColumnWidth(columnIndex, width);
|
}
|
int SetColumnWidth(LPCTSTR column, int width = 1)
|
{
|
return getKReport()->SetColumnWidth(column, width);
|
}
|
int GetColumnWidth(int columnIndex)
|
{
|
return getKReport()->GetColumnWidth(columnIndex);
|
}
|
int GetColumnWidth(LPCTSTR column)
|
{
|
return getKReport()->GetColumnWidth(column);
|
}
|
int SetColumnState(int columnIndex, bool state)
|
{
|
return getKReport()->SetColumnState(columnIndex, state);
|
}
|
int SetColumnState(LPCTSTR column, bool state)
|
{
|
return getKReport()->SetColumnState(column, state);
|
}
|
|
void SetDataToClip(LPCTSTR DataStr)
|
{
|
return getKReport()->SetDataToClip(DataStr);
|
}
|
int AcceptText()
|
{
|
return getKReport()->AcceptText();
|
}
|
int ShowRowTo(int row)
|
{
|
return getKReport()->ShowRowTo(row);
|
}
|
int GetShowRow()
|
{
|
return getKReport()->GetShowRow();
|
}
|
LPCTSTR GetTitleName(int col)
|
{
|
return getKReport()->GetTitleName(col);
|
}
|
public:
|
int SetRowSort(LPTSTR colName, bool colOrder = true)
|
{
|
return getKReport()->SetRowSort(colName, colOrder);
|
}
|
int SetClickEditFlag(bool f)
|
{
|
return getKReport()->SetClickEditFlag(f);
|
}
|
int Redraw()
|
{
|
return getKReport()->RedrawEx();
|
}
|
bool SetRowMove(int row, int movecount)
|
{
|
return getKReport()->SetRowMove(row, movecount);
|
}
|
int GetTreeRow(int row)
|
{
|
return getKReport()->GetTreeRow( row);
|
}
|
int GetTreeRowCount()
|
{
|
return getKReport()->GetTreeRowCount();
|
}
|
int TreeRowExpand(int row, bool exp)
|
{
|
return getKReport()->TreeRowExpand(row, exp);
|
}
|
int RetrieveDiff(KXMLDOMDocument& xml)//读取数据
|
{
|
return getKReport()->RetrieveDiff(xml);
|
}
|
int Filter(LPTSTR pColumn, LPTSTR pStr)
|
{
|
return getKReport()->Filter(pColumn, pStr);
|
}
|
public:
|
int SetHeaderText(int row, int col, LPTSTR name)
|
{
|
return getKReport()->SetHeaderText(row, col, name);
|
}
|
int MoveColumnTo(int fromcolumn, int tocolumn)
|
{
|
return getKReport()->MoveColumnTo(fromcolumn, tocolumn);
|
}
|
public:
|
void SetEditUpperMode(bool upper)
|
{
|
return getKReport()->SetEditUpperMode(upper);
|
}
|
bool GetEditUpperMode()
|
{
|
return getKReport()->GetEditUpperMode();
|
}
|
public:
|
void ResetRepeats()
|
{
|
return getKReport()->ResetRepeats();
|
}
|
void AddRepeats(wchar_t* colName)
|
{
|
return getKReport()->AddRepeats(colName);
|
}
|
public:
|
LPCTSTR GetColumnProp(int nCol, LPCTSTR pItem)
|
{
|
return L"";
|
//return getKReport()->GetColumnProp(nCol, pItem);
|
}
|
|
LPCTSTR GetColumnProp(LPCTSTR pColName, LPCTSTR pItem)
|
{
|
return L"";
|
//return getKReport()->GetColumnProp(pColName, pItem);
|
}
|
|
int GetItemInt(int row, int col)
|
{
|
xstring str = GetItemString(row, col);
|
return str.toInt();
|
}
|
|
int GetItemInt(int row, xstring col)
|
{
|
xstring str = GetItemString(row, col.c_str());
|
return str.toInt();
|
}
|
|
double GetItemDouble(int row, int col)
|
{
|
xstring str = GetItemString(row, col);
|
return str.toDouble();
|
}
|
|
double GetItemDouble(int row, string col)
|
{
|
xstring str = GetItemString(row, col);
|
return str.toDouble();
|
}
|
|
bool SetItemInt(int row, int col, int str)
|
{
|
return SetItemString(row, col, xstring(str));
|
}
|
|
bool SetItemInt(int row, xstring col, int str)
|
{
|
return SetItemString(row, col.c_str(), xstring(str));
|
}
|
|
bool SetItemDouble(int row, int col, double str)
|
{
|
return SetItemString(row, col, xstring(str));
|
}
|
|
bool SetItemDouble(int row, xstring col, double str)
|
{
|
return SetItemString(row, col.c_str(), xstring(str));
|
}
|
|
public:
|
int openUrl(string aurl)
|
{
|
KXMLDOMDocument x;
|
xurl::get(aurl, L"", x);
|
return SetDataObject(x);
|
}
|
|
int openUrl(string ServerUrl, string aurl)
|
{
|
KXMLDOMDocument x;
|
xurl::get(ServerUrl, aurl, L"", x);
|
return SetDataObject(x);
|
}
|
|
int openSheet(string sheet)
|
{
|
KXMLDOMDocument x;
|
xaserver::LoadUrl(L"", sheet, L"", x);
|
SetDataObject(x);
|
return 1;
|
}
|
|
int UnDeleteRow(int row)
|
{
|
KXMLDOMElement e = GetRowElement(row);
|
if (e.selectSingleNode(L"@update.modify"))
|
e.removeAttribute(L"update.delete");
|
return 1;
|
}
|
|
int LookUpRow(string col, string value, int startRow = 1)
|
{
|
for (int i = startRow; i <= GetRowCount(); i++)
|
{
|
if (GetItemString(i, col) == value) return i;
|
}
|
return 0;
|
}
|
|
int IsRowModified(int row)
|
{
|
KXMLDOMElement e = GetRowElement(row);
|
if (e.selectSingleNode(L"@update.modify")) return true;
|
return false;
|
}
|
|
//cwd
|
double GetItemSumDouble(string col)
|
{
|
double dItemSum = 0.0;
|
int i;
|
int icnt = GetRowCount();
|
if (icnt < 1) return 0.0;
|
for (i = 1; i <= icnt; i++)
|
{
|
double d = GetItemDouble(i, col);
|
dItemSum = dItemSum + d;
|
}
|
//alert(dItemSum.toString());
|
return dItemSum;
|
}
|
|
xstring GetGuid(int row)
|
{
|
KXMLDOMElement e = GetRowElement(row);
|
if (e) return e.getAttribute(L"guid");
|
return L"";
|
}
|
|
public:
|
|
int DwRetrieve(string ServerUrl, string src, string argstr)
|
{
|
KXMLDOMDocument x;
|
xaserver::ExecXQuery(ServerUrl, src, argstr, x);
|
Retrieve(x);
|
Redraw();
|
return 1;
|
}
|
|
int DwRetrieve(string ServerUrl, string src, string arg0, string value0)
|
{
|
xaserverarg arg;
|
arg.AddArg(arg0, value0);
|
DwRetrieve(ServerUrl, src, arg.GetString());
|
return 1;
|
}
|
|
int DwRetrieve(string ServerUrl, string src, string arg0, string value0, string arg1, string value1)
|
{
|
xaserverarg arg;
|
arg.AddArg(arg0, value0);
|
arg.AddArg(arg1, value1);
|
DwRetrieve(ServerUrl, src, arg.GetString());
|
return 1;
|
}
|
};
|
