#pragma once
|
|
#include "kcontrol.hpp"
|
#include "kdwview.hpp"
|
|
namespace Hxsoft{namespace XFrame{
|
namespace XOffice {namespace XCell {
|
class IDwTable : public IDwView
|
{
|
public:
|
int GetRow_() ;//µÃµ½ÐÐ
|
int GetColumn_() ;//µÃµ½ÁÐ
|
int GetRowCount_() ; //µÃµ½ÐÐÊý
|
int GetColumnCount_() ; //µÃµ½ÁÐÊý
|
public:
|
int SetRow_(int row) ;
|
public:
|
LPCTSTR GetNote_(int nRow, int nColumn) ;//µÃµ½±¸×¢
|
bool SetNote_(int nRow, int nColumn, LPCTSTR pStrNote) ; //ÉèÖñ¸×¢
|
bool AddNote_(int nRow, int nColumn, LPCTSTR pStrNote, LPCTSTR pUser = NULL, LPCTSTR pData = NULL) ; //ÉèÖñ¸×¢
|
|
LPCTSTR GetNote1_(int nRow, int nColumn) ;//µÃµ½ÐÞ¸Ä
|
bool SetNote1_(int nRow, int nColumn, LPCTSTR pStrNote) ; //ÉèÖÃÐÞ¸Ä
|
bool AddNote1_(int nRow, int nColumn, LPCTSTR pStrNote, LPCTSTR pUser = NULL, LPCTSTR pData = NULL) ; //ÉèÖÃÐÞ¸Ä
|
|
LPCTSTR GetNote2_(int nRow, int nColumn) ;//µÃµ½Åú×¢
|
bool SetNote2_(int nRow, int nColumn, LPCTSTR pStrNote) ; //ÉèÖÃÅú×¢
|
bool AddNote2_(int nRow, int nColumn, LPCTSTR pStrNote, LPCTSTR pUser = NULL, LPCTSTR pData = NULL) ; //ÉèÖÃÅú×¢
|
|
public:
|
int InsertRow_(int nRow) ;//²åÈëÐÐ
|
int DeleteRow_(int nRow) ;//ɾ³ýÐÐ
|
int InsertRows_(int nRow, int nAmt) ;//²åÈë¶àÐÐ
|
int DeleteRows_(int nRow, int nAmt) ;//ɾ³ý¶àÐÐ
|
public:
|
LPCTSTR GetColumnName_(int nColumn) ;//µÃµ½ÁÐÃû
|
int GetColumnIndex_(LPCTSTR pColumn) ; //µÃµ½ÁкÅ
|
public:
|
LPCTSTR GetItemString_(int nRow, int nColumn, DWBuffer dwBuffer = dbuf_normal) ;//µÃµ½Êý¾ÝÖµ
|
LPCTSTR GetItemString_(int nRow, LPCTSTR ColumnName, DWBuffer dwBuffer = dbuf_normal) ;//µÃµ½Êý¾ÝÖµ
|
bool SetItemString_(int nRow, int nColumn, LPCTSTR lptStr, DWBuffer dwBuffer = dbuf_normal) ;//ÉèÖÃÊý¾ÝÖµ
|
bool SetItemString_(int nRow, LPCTSTR ColumnName, LPCTSTR lptStr, DWBuffer dwBuffer = dbuf_normal) ;//ÉèÖÃÊý¾ÝÖµ
|
public:
|
bool SetItemStatus_(int nRow, int nColumn, RowStatus status, DWBuffer dwBuffer = dbuf_normal) ;//ÉèÖÃÐÐÁÐ״̬
|
RowStatus GetItemStatus_(int nRow, int nColumn, DWBuffer dwBuffer = dbuf_normal) ;//µÃµ½ÐÐÁÐ״̬
|
|
public:
|
int SetKeyValue_(int nRow, int nKeyValue) ;//ÉèÖÃÕûÊý¹Ø½¡Öµ
|
int GetKeyValue_(int nRow) ;//µÃµ½ÕûÊý¹Ø½¡Öµ
|
bool GetGuid_(int nRow, TCHAR Guid[], int nMax) ;//ÉèÖÃguid
|
bool SetGuid_(int nRow, LPCTSTR pStrGuid) ; //ÉèÖÃguid
|
|
public:
|
int SetReadOnly_(bool bReadOnly = true) ; //ÉèÖÃÖ»¶Á
|
public:
|
int SelectRow_(int nRow, bool bSelect = true) ;//Ñ¡Öе¥ÐÐ
|
int SelectRow_(int sRow, int eRow, bool bSelect = true) ;//Ñ¡ÖжàÐÐ
|
int GetNextSelectRow_(int nStartRow) ; //µÃµ½ÏÂÀÐÞ¸ÄÐÐ
|
bool IsRowSelected_(int nRow) ; //ÅжÏÐÐÊÇ·ñ±»Ñ¡ÖÖ
|
int SetSelectBkColor_(COLORREF color) ; //ÉèÖÃÑ¡ÔñµÄ±³¾°ÑÕÉ«
|
int SetSelectionMode_(int nMode) ; //ÉèÖÃÑ¡ÔñµÄģʽ//0 unselection 1 singleSelection 2 multiselection 3 multiselectionex
|
|
public:
|
int DeletedCount_() ; //µÃµ½É¾³ýÐÐÐÐÊý
|
int ModifiedCount_() ; //µÃµ½ÐÞ¸ÄÐÐÐÐÊý
|
public:
|
int Reset_() ; //Çå³ýÊý¾Ý
|
int ResetUpdateStatus_() ;//Çå³ýÐ޸ıê¼Ç
|
public:
|
BSTR GetXml_(LPCTSTR pRoot, bool bIncludeChild) ; //»ñÈ¡XMLÊý¾Ý
|
int Load_(KXMLDOMElement pElement) ;//¶ÁÈ¡Êý¾Ý
|
int LoadXml_(BSTR bstr) ;//¶ÁÈ¡Êý¾Ý
|
public:
|
int ClearObserver_() ;//Çå³ýʼþÕìÌý¶ÔÏó
|
public:
|
int DwUpdateTo_(KXMLDOMDocument pXmlDoc) ;//°ÑÊý¾Ý¸üе½XML¶ÔÏóÖÐ
|
int DwUpdateAllTo_(KXMLDOMDocument pXmlDoc) ;//°ÑÊý¾Ý¸üе½XML¶ÔÏóÖÐ
|
public:
|
int Retrieve_(LPCTSTR pServer, LPCTSTR pDataUrl, LPCTSTR pArgStr) ;//¶ÁÈ¡Êý¾Ý
|
int Retrieve_(ITrans* pTrans, LPCTSTR pDataUrl, LPCTSTR pArgStr) ;//¶ÁÈ¡Êý¾Ý
|
int Retrieve_(LPCTSTR pDataUrl, LPCTSTR pArgStr) ;//¶ÁÈ¡Êý¾Ý
|
|
int Retrieve_(KXMLDOMElement pElement) ;//¶ÁÈ¡Êý¾Ý
|
int Retrieve_(KXMLDOMDocument& xml) ;//¶ÁÈ¡Êý¾Ý
|
|
int RetrieveEx_(LPCTSTR pServer, LPCTSTR pEntity, LPCTSTR pEntityKey) ;//¶ÁÈ¡Êý¾Ý
|
int RetrieveEx_(ITrans* pTrans, LPCTSTR pEntity, LPCTSTR pEntityKey) ;//¶ÁÈ¡Êý¾Ý
|
int RetrieveEx_(LPCTSTR pEntity, LPCTSTR pEntityKey) ;//¶ÁÈ¡Êý¾Ý
|
public:
|
int SetDataObject_(LPCTSTR pServer, LPCTSTR pUrl) ;//ÉèÖÃÄ£°å¶ÔÏó
|
int SetDataObject_(ITrans* pTrans, LPCTSTR pUrl) ;//ÉèÖÃÄ£°å¶ÔÏó
|
int SetDataObject_(LPCTSTR pUrl) ;//ÉèÖÃÄ£°å¶ÔÏó
|
|
int SetDataObject_(KXMLDOMElement pElement) ;//ÉèÖÃÄ£°å¶ÔÏó
|
int SetDataObject_(KXMLDOMDocument pDoc) ;
|
public:
|
int ImportFile_() ; //תÈëÊý¾Ý
|
int ImportFile_(LPCTSTR pStrFile, LPCTSTR pType = NULL, bool Header = false) ; //תÈëÊý¾Ý
|
int ImportString_(LPCTSTR pStr, LPCTSTR pType = NULL, bool Header = false) ; //תÈëÎı¾Êý¾Ý
|
public:
|
int SetValues_(LPCTSTR pColName, LPCTSTR pExpr) ; //ÅúÁ¿ÉèÖÃÖµ
|
int AddCalcColumn_(LPCTSTR pColName, LPCTSTR pExpr) ;//ÉèÖùØÁª¼ÆËãÁÐ
|
int ClearCalcColumn_(LPCTSTR pColName = NULL) ;//Çå³ý¹ØÁª¼ÆËãÁÐ
|
public:
|
int GetNextModifyRow_(int nStart) ; //µÃµ½ÏÂÒ»ÐÞ¸ÄÐÐ
|
public:
|
int Modify_(LPCTSTR pStr) ; //Óï·¨ÐÞ¸Ä
|
int Evaluate_(int nRow, LPCTSTR pExpr) ; //ÆÀ¹À±í´ïʽ
|
public:
|
int SetAutoFilter_(bool bAutoFilter) ; //ÉèÖÃ×Ô¶¯¹ýÂË
|
int SetFilter_(LPCTSTR pStrFilter) ; //ÉèÖùýÂËÌõ¼þ
|
int Filter_() ; //¹ýÂË
|
int SetSort_(LPCTSTR pStrSort) ; //ÉèÖÃÅÅÐò²ÎÊý
|
int Sort_() ; //ÅÅÐò
|
int Find_(LPCTSTR pCondition = NULL) ; //²éÕÒ
|
int FindNext_() ; //²éÕÒ
|
public:
|
int GetFirstVisibleRow_() ; //µÃµ½µ±Ç°ÏÔʾµÄµÚÒ»ÐÐ
|
int Expand_(bool bExpand) ;//ÊÕËõ»òÕ¹¿ªÊý¾ÝÊÓͼ
|
public:
|
int Print_(LPCTSTR pXmlArg = NULL) ; //´òÓ¡
|
int PrintPreview_(LPCTSTR pXmlArg = NULL) ; //´òÓ¡Ô¤ÀÀ
|
public:
|
int SaveAs_(LPCTSTR pXmlArg = NULL) ; //Áí´æΪ
|
int SaveAsEx_() ; //ÕûÌåÁí´æΪ
|
int SaveAsEx_(LPCTSTR pStrFile) ; //ÕûÌåÁí´æΪ
|
public:
|
LPTSTR GetColumnProps_(LPCTSTR pColName) ; //µÃµ½ÁÐÕûÌåXMLÊôÐÔ
|
int SetColumnProps_(LPCTSTR pColName, LPCTSTR pXmlProp) ; //ÉèÖÃÁÐÕûÌåXMLÊôÐÔ
|
LPTSTR GetColumnProp_(LPCTSTR pColName, LPCTSTR pItem) ; //µÃµ½ÁÐÊôÐÔ
|
int SetColumnProp_(LPCTSTR pColName, LPCTSTR pItem, LPCTSTR pProp) ;//ÉèÖÃÁÐÊôÐÔ
|
|
LPTSTR GetColumnProps_(int nCol) ; //µÃµ½ÁÐÕûÌåXMLÊôÐÔ
|
int SetColumnProps_(int nCol, LPCTSTR pXmlProp) ; //ÉèÖÃÁÐÕûÌåXMLÊôÐÔ
|
LPTSTR GetColumnProp_(int nCol, LPCTSTR pItem) ; //µÃµ½ÁÐÊôÐÔ
|
int SetColumnProp_(int nCol, LPCTSTR pItem, LPCTSTR pProp) ;//ÉèÖÃÁÐÊôÐÔ
|
public:
|
int DataBI_(LPCTSTR pSchema = NULL) ;//Êý¾ÝBI·ÖÎö
|
public:
|
int chart_(LPCTSTR pXmlArg = NULL) ;//ͼÐÎ
|
|
//send event message
|
int event_ItemFocusChanged_(int nRow, int nCol) ;
|
int event_RowFocusChanged_(int nRow, int nOldRow) ;
|
int event_GetFocus_() ;
|
int event_LoseFocus_() ;
|
int event_ItemChanged_(int nRow, int nCol, LPCTSTR pData) ;
|
int event_ItemChanging_(int nRow, int nCol, LPCTSTR pData) ;
|
|
public:
|
bool ItemChangeTo(int nRow, int nColumn, LPCTSTR lptStr, DWBuffer dwBuffer = dbuf_normal);
|
bool ItemChangeTo(int nRow, LPCTSTR ColumnName, LPCTSTR lptStr, DWBuffer dwBuffer = dbuf_normal);
|
|
public:
|
LPCTSTR GetGuid(int nRow);
|
//follow function for cell table
|
public:
|
int InsertRow_(int nGroup, int nRow) ; //²åÈë×éÐÐ
|
int DeleteRow_(int nGroup, int nRow) ; //ɾ³ý×éÐÐ
|
int InsertRows_(int nGroup, int nRow, int nAmt) ; //²åÈë×é¶àÐÐ
|
int DeleteRows_(int nGroup, int nRow, int nAmt) ;//ɾ³ý×é¶àÐÐ
|
public:
|
int GetGroupStartRow_(int nGroup) ; //µÃµ½Ö¸¶¨×éµÄ¿ªÊ¼ÐÐ
|
int GetGroupRowCount_(int nGroup) ; //µÃµ½Ö¸¶¨×éµÄ½áÊøÐÐ
|
int InsertGroupRow_(int nGroup, int nRow) ; //²åÈë×éÐÐ
|
public:
|
int GetMaxDeep_() ; //²åÈëÊý¾ÝÊÓͼµÄ×î´óÉî¶È
|
int GetLevel_() ; //µÃµ½Êý¾ÝÊÓͼµÄ¼¶ºÅ
|
LPCTSTR GetDwXPath_() ; //µÃµ½Êý¾ÝÊÓͼµÄXPATH
|
public:
|
IDwView* GetParent_() ; //µÃµ½¸¸Êý¾ÝÊÔͼ
|
public:
|
int GetChildCount_() ; //µÃµ½×ÓÊý¾ÝÊÓͼÊý
|
IDwView* GetChild_(int nIndex) ; //µÃµ½Ö¸¶¨ÐòºÅµÄ×ÓÊý¾ÝÊÓͼ
|
public:
|
LPCTSTR GetDwName_() ; //µÃµ½Êý¾ÝÊÓͼµÄÃû³Æ
|
IDwView* FindDwTable_(LPCTSTR pStrName, IDwView* pParent = NULL) ; //²éÕÒÊý¾ÝÊÔͼ
|
IDwView* GetCurTable_(int& nRow, int& nCol) ;//µÃµ½µ±Ç°Êý¾ÝÊÓͼ£¬²¢·µ»ØÐÐÁÐ
|
IDwView* GetCurTable_() ;//µÃµ½µ±Ç°Êý¾ÝÊÓͼ
|
|
public:
|
int SetRowSelectorWidth(int nWidth);
|
int ResetRowSelector();
|
int GetRowSelectorWidth();
|
int GetRowSelectorDefaultWidth();
|
|
int SetColHeaderHeight(int nHeight);
|
int GetColHeaderDefaultHeight();
|
int ResetColHeaderHeight();
|
int GetColHeaderHeight();
|
public:
|
LPTSTR GetHtml();
|
public:
|
int SetScrollState(bool both);
|
int SetHScrollState(bool bShow);
|
int SetVScrollState(bool bShow);
|
|
public:
|
COLORREF GetDirectColor();
|
void SetDirectColor(COLORREF cr);
|
COLORREF GetAdvanceColor();
|
void SetAdvanceColor(COLORREF cr);
|
public:
|
LPTSTR GetNoteString(int nRow, int nCol);
|
LPTSTR GetOriginString(int nRow, int nCol);
|
LPTSTR GetAdvanceString(int nRow, int nCol);
|
|
void SetNoteString(int nRow, int nCol, LPTSTR pStr);
|
void SetOriginString(int nRow, int nCol, LPTSTR pStr);
|
void SetAdvanceString(int nRow, int nCol, LPTSTR pStr);
|
|
void ClearNoteString(int nRow, int nCol);
|
void ClearOriginString(int nRow, int nCol);
|
void ClearAdvanceString(int nRow, int nCol);
|
public:
|
int AcceptText();
|
int getNullCell(POINT& p);
|
int ExpandRow();
|
int ExpandRow(int sRow, int eRow);
|
int ExpandCellRow(int sRow, int eRow);
|
int ExpandMarginRow(int sRow, int eRow);
|
int GetCellRowFromRowColumn(int sRow, int sCol); //µÃµ½ÐÐÁÐ
|
int SetSelectionBorder(int Flag);
|
int SetItemText(int row, int col, LPTSTR name);
|
public:
|
void SetEditUpperMode(bool upper);
|
bool GetEditUpperMode();
|
public:
|
int SetRowSort(LPTSTR colName, bool colOrder = true);
|
public:
|
LPCTSTR GetItemDisplayString(int nRow, int nColumn, DWBuffer dwBuffer = dbuf_normal);
|
LPCTSTR GetItemDisplayString(int nRow, LPCTSTR ColumnName, DWBuffer dwBuffer = dbuf_normal);
|
bool SetItemDisplayString(int nRow, int nColumn, LPCTSTR lptStr, DWBuffer dwBuffer = dbuf_normal);
|
bool SetItemDisplayString(int nRow, LPCTSTR ColumnName, LPCTSTR lptStr, DWBuffer dwBuffer = dbuf_normal);
|
|
LPCTSTR GetItemTipString(int nRow, int nColumn, DWBuffer dwBuffer = dbuf_normal);
|
LPCTSTR GetItemTipString(int nRow, LPCTSTR ColumnName, DWBuffer dwBuffer = dbuf_normal);
|
bool SetItemTipString(int nRow, int nColumn, LPCTSTR lptStr, DWBuffer dwBuffer = dbuf_normal);
|
bool SetItemTipString(int nRow, LPCTSTR ColumnName, LPCTSTR lptStr, DWBuffer dwBuffer = dbuf_normal);
|
|
};
|
}}
|
}}
|
