lyfz_repos/经典版源码/多多福版本/Client/XTable.cpp

// XTable.cpp : implementation file
#include "stdafx.h"
#include "YLGL.h"
#include "XTable.h"
#include "InputDate.h"
#include "MemDC.h"
#include "TodayForm2.h"
#include "TodayForm.h"
#define XTABLE_CLASSNAME    _T("XTableCtrl")  // Window class name

#ifdef _DEBUG
#define new DEBUG_NEW
#endif
// XTable

IMPLEMENT_DYNAMIC(XTable, CWnd)
BEGIN_MESSAGE_MAP(XTable, CWnd)
	ON_WM_PAINT()
	ON_WM_KEYDOWN()
	ON_WM_LBUTTONDOWN()
	ON_WM_LBUTTONDBLCLK()
	ON_MESSAGE(WM_USER_EDIT_END,OnEditEnd) 
	ON_WM_ERASEBKGND()
END_MESSAGE_MAP()
XTable::XTable(int rows, int cols)
{
	RegisterWindowClass ();

	defaultCell.table = this;

	defaultHeight = 20;
	defaultWidth = 80;

	cells = NULL;
	rowHeight = NULL;
	colWidth = NULL;

	this->rows = 0;
	this->cols = 0;
	SetRows (rows);
	SetCols (cols);	

	focusRow = 0;
	focusCol = 0;
	m_bFocusFrame=1;
	m_nCurShow=-1;
	m_nticks=::GetTickCount ();
	m_mode=0;
	m_pComboBox=NULL;
}

XTable::~XTable()
{
	if(cells)delete [] cells;
	if(rowHeight)delete [] rowHeight;
	if(colWidth)delete [] colWidth;
}

// creates the control - use like any other window create control
BOOL XTable::Create(const RECT& rect, CWnd* pParentWnd, UINT nID, DWORD dwStyle)
{
    ASSERT(pParentWnd->GetSafeHwnd());

    if (!CWnd::Create(XTABLE_CLASSNAME, NULL, dwStyle, rect, pParentWnd, nID))
        return FALSE;

    return TRUE;
}

int XTable::ToXML (CMarkup& markup)
{
	markup.AddChildElem ("table");
	markup.AddChildAttr("border", "1"); 

	markup.IntoElem (); 

	for (int i = 0; i < GetRows (); i ++)
	{
		markup.AddChildElem ("tr");
		markup.IntoElem(); 
		for (int j = 0; j < GetCols (); j ++)
		{
			XCell* cell = GetCells (i, j);

			if (cell->colSpan > 0 && cell->rowSpan > 0)
			{
				markup.AddChildElem ("td");

				if (cell->colSpan == 1 && i == 0)
					markup.AddChildAttr ("width", GetColWidth (j));

				if (cell->rowSpan == 1 && j == 0)
					markup.AddChildAttr ("height", GetRowHeight (i));

				cell->ToXML (markup);
			}
		}
		markup.OutOfElem();
	}

	markup.OutOfElem();

	return 0;
}

int XTable::FromXML (CMarkup& markup)
{
	markup.IntoElem ();

	int maxCol = 0;
	int maxRow = 0;
	int row = 0;
	int col = 0;

	SetCols (MAX_COLS);
	SetRows (MAX_ROWS);
	while (markup.FindChildElem("tr"))
	{
		markup.IntoElem();

		col = 0;
		while (markup.FindChildElem("td"))
		{
			XCell* cell;
			
			while (true)
			{
				cell = GetCells (row, col);

				if (!cell) 
					break;

				if (cell->colSpan >= 1 && cell->rowSpan >= 1)
					break;

				col ++;
			}

			cell->FromXML (markup);

			if (cell->colSpan > 1 || cell->rowSpan > 1)
				JoinCells (row, col, row+cell->rowSpan-1, col+cell->colSpan-1);

			if (cell->colSpan == 1 && markup.GetChildAttr("width") != "")
			{
				int width = atoi (markup.GetChildAttr("width"));
				if (row == 0 || width > GetColWidth(col))
					SetColWidth (col, width);
			}
			if (cell->rowSpan == 1 && markup.GetChildAttr("height") != "")
			{
				int height = atoi (markup.GetChildAttr("height"));
				if (col == 0 || height > GetRowHeight(row))
					SetRowHeight (row, height);
			}

			col += cell->colSpan;
			if (col > maxCol) maxCol = col;

			if (row + cell->rowSpan > maxRow) maxRow = row + cell->rowSpan;
		}

		markup.OutOfElem();

		row ++;
	}

	markup.OutOfElem();
	
	SetRows (maxRow);
	SetCols (maxCol);

	return 0;
}

int XTable::SetRows(int newRows)
{
	if (rows < 0 || rows > MAX_ROWS) return -1;
	
	if (rows == newRows) return 0;

	int cellsSize = cols * rows;

	XCell* newCells =  cells;
	int* newRowHeight = new int [newRows];

	if ( rows < newRows)
	{
		if (cellsSize < newRows * cols)
		{
			cellsSize *= 2;
			if (cellsSize < newRows * cols)
				cellsSize = newRows * cols;

			newCells = new XCell [cellsSize];

			//复制旧数据
			for (int i = 0; i < rows; i++)
			{
				for(int j = 0; j < cols ; j++)
				{
					newCells [i * cols +j] = cells [i * cols +j];
				}

				newRowHeight [i] = rowHeight [i];
			}
		}

		//初始化新数据
		for (int i = rows; i < newRows; i++)
		{
			for (int j = 0; j < cols; j++)
			{
				newCells [i * cols + j] = defaultCell;
				newCells [i * cols + j].SetSpan (1, 1);
			}

			newRowHeight [i] = defaultHeight; 
		}

		delete [] rowHeight;
		rowHeight = newRowHeight;
	}
	else
	{
		if (cellsSize > newRows * cols * 2) 
		{
			cellsSize = newRows * cols;

			newCells = new XCell [cellsSize];
		}

		//复制数据
		for (int i = 0; i < newRows; i ++)
		{
			for (int j = 0; j < cols; j++)
				newCells [i * cols + j] = cells[i * cols +j];
		}
	}

	if (newCells != cells)
	{
		delete [] cells;
		cells = newCells;
	}

	rows = newRows;

	return 0;   
}

int XTable::GetRows()
{
	return rows;
}

int XTable::SetCols(int newCols)
{
	if (newCols < 0 || newCols > MAX_COLS) return -1;

	if (this->cols == newCols) return 0;

	int cellsSize = cols * rows;

	XCell* newCells =  cells;
	int* newColWidth = new int [newCols];

	if ( cols < newCols)
	{
		if (cellsSize < newCols * rows)
		{
			cellsSize *= 2;
			if (cellsSize < newCols * rows)
				cellsSize = newCols * rows;

			newCells = new XCell [cellsSize];

			//复制旧数据
			for (int i = 0; i < rows; i++)
			{
				for(int j = 0; j < cols ; j++)
				{
					newCells [i * newCols +j] = cells [i * cols +j];
					newColWidth[j] = colWidth [j];
				}
			}
		}
		//初始化新数据
		for (int i = 0; i < rows; i++)
		{
			for (int j = cols; j < newCols; j++)
			{
				newCells [i * newCols + j] = defaultCell;
				newCells [i * newCols + j].SetSpan (1, 1);
				newColWidth[j] = defaultWidth;
			}
		}

		delete [] colWidth;
		colWidth = newColWidth;
	}
	else
	{
		if (cellsSize > newCols * rows * 2) 
		{
			cellsSize = newCols * rows;

			newCells = new XCell [cellsSize];
		}

		//复制数据
 		for (int i = 0; i < rows; i ++)
		{
			for (int j = 0; j <  newCols; j++)
				newCells [i * newCols + j] = cells[i * cols +j];
		}
	}


	if (newCells != cells)
	{
		delete [] cells;
		cells = newCells;
	}

	cols = newCols;

	return 0;
}

int XTable::GetCols()
{
	return cols;
}

int XTable::JoinCells (int startRow, int startCol, int endRow, int endCol)
{
	if (startRow < 0 || startRow >= rows) return -1;
	if (endRow < 0 || startRow >= rows) return -1;

	if (startCol < 0 || startCol >= cols) return -1;
	if (endCol < 0 || endCol >= cols) return -1;

	if (startRow > endRow || startCol > endCol) return -1;

	for (int i = startRow; i <= endRow; i++)
	{
		for (int j = startCol; j <=endCol;  j++)
		{
			cells [i * cols + j].SetSpan(0,0);
		}
	}
	
	cells [startRow * cols + startCol].SetSpan(endRow - startRow+1, endCol - startCol+1);
	
	return 0;
}

int XTable::UnjoinCells (int row, int col)
{
	if (row < 0 || row >= this->rows) return -1;
	if (col < 0 || col >= this->cols) return -1;

	if (cells [row * cols + col].rowSpan <= 1 && cells [row * cols + col].colSpan <= 1 ) return -1;

	for (int i = row; i <= row + cells [row * cols + col].rowSpan; i++)
	{
		for (int j = col; j <= cells [row * cols + col].colSpan; j++)
		{
			cells[i*cols+j] = defaultCell;

			cells [i * cols + j].SetSpan(1,1);
		}
	}

	return 0;
}

int XTable::SetRowHeight(int row, int height)
{
	rowHeight [row] = height;

	return 0;
}

int XTable::GetRowHeight(int row)
{
	return rowHeight [row];
}

int XTable::SetColWidth(int col, int width)
{
	colWidth [col] = width;

	return 0;
}

int XTable::GetColWidth(int col)
{
	return colWidth [col];
}

int XTable::GetRowsHeight(int startRow, int endRow)
{
	if (startRow < 0 || startRow >= rows) return -1;
	if (endRow < 0 || endRow >= rows) return -1;
	if (startRow > endRow) return -1;

	int height = 0;
	for (int i = startRow; i <= endRow; i++)
	{
		height += rowHeight[i];
	}

	return height;
}

int XTable::GetColsWidth(int startCol, int endCol)
{
	if (startCol < 0 || startCol >= cols) return -1;
	if (endCol < 0 || endCol >= cols) return -1;
	if (startCol > endCol) return -1;

	int width = 0;
	for (int i = startCol; i <= endCol; i++)
	{
		width += colWidth[i];
	}

	return width;
}

int XTable::SetCells(int row, int col, XCell& cell)
{
	cells[row * cols + col] = cell;

	return 0;
}

XCell* XTable::GetCells(int row, int col)
{
	return &cells [row * cols + col];
}

int XTable::SetText(int row, int col, CString str)
{

	XCell* cell = GetCells (row, col);
	if (!cell) return -1;

	return cell->SetText (str);
}

CString XTable::GetText(int row, int col)
{
	return	cells[row * cols + col].GetText();
}

int XTable::SetTextColor(int row, int col, COLORREF color)
{
	cells[row * cols + col].SetTextColor(color);

	return 0;
}

COLORREF XTable::GetTextColor(int row, int col)
{
	return 	cells[row * cols + col].GetTextColor();
}

int XTable::SetTextFont(int row, int col, CFont& font)
{
	cells[row * cols + col].SetTextFont(&font);

	return 0;

}
CFont* XTable::GetTextFont(int row, int col)
{
	return	cells[row * cols + col].GetTextFont();
}

int XTable::SetTextFontSize(int row, int col, int size)
{
	cells[row * cols + col].SetTextFontSize(size);

	return 0;
}

int XTable::GetTextFontSize(int row, int col)
{
	return 	cells[row * cols + col].GetTextFontSize();
}

int XTable::SetOverlap (int row, int col, bool enable)
{
	XCell* cell = GetCells (row, col);
	if (!cell) return -1;

	return cell->SetOverlap (enable);
}

bool XTable::GetOverlap (int row, int col)
{
	XCell* cell = GetCells (row, col);
	if (!cell) return false;

	return cell->GetOverlap ();
}

int XTable::SetAlignment (int row, int col, int align)
{
	XCell* cell = GetCells (row, col);
	if (!cell) return -1;

	return cell->SetAlignment (align);
}

int XTable::GetAlignment (int row, int col)
{
	XCell* cell = GetCells (row, col);
	if (!cell) return -1;

	return cell->GetAlignment ();
}

int XTable::SetWordbreak (int row, int col, bool wordbreak)
{
	XCell* cell = GetCells (row, col);
	if (!cell) return -1;

	return cell->SetWordbreak (wordbreak);
}

bool XTable::GetWordbreak (int row, int col)
{
	XCell* cell = GetCells (row, col);
	if (!cell) return false;

	return cell->GetWordbreak ();
}

int XTable::SetBackColor(int row, int col, COLORREF color)
{
	cells[row * cols + col].SetBackColor(color);

	return 0;
}

COLORREF XTable::GetBackColor(int row, int col)
{
	return 	cells[row * cols + col].GetBackColor();
}

int XTable::SetBackMode(int row, int col, int mode)
{
	cells[row * cols + col].SetBackMode(mode);

	return 0;
}

int XTable::GetBackMode(int row, int col)
{
	return 	cells[row * cols + col].GetBackMode();
}

RECT XTable::GetRect(int row, int col)
{
	RECT rect;
	try
	{
	int rowSpan = GetCells(row, col)->rowSpan;
	int colSpan = GetCells(row, col)->colSpan;
	rect.top = GetRowsHeight(0, row-1);
	rect.left = GetColsWidth(0, col-1);

	rect.bottom = rect.top + GetRowsHeight (row, row + rowSpan-1);
	rect.right = rect.left + GetColsWidth (col, col + colSpan-1);
	}
	catch(...)
	{
	}
	return rect;
}

bool XTable::HitTest (CPoint point, int& row, int& col)
{
	try
	{
	for (int i= 0; i < rows; i++) 
	{
		for(int j=0; j < rows; j++)
		{
			RECT rect = GetRect (i,j);
			if (rect.top <= point.y && rect.bottom > point.y && rect.left <= point.x && rect.right > point.x)
			{
				row = i;
				col = j;

				return true;
			}
		}
	}
	}
	catch(...)
	{
	}
	return false;
}

void XTable::OnDraw(CDC* pDC)
{
	static bool lock = false;

	if (lock) return;

	if (!::IsWindow(m_hWnd)) return;

	lock = true;

	Draw (pDC);

	lock = false;
}

int XTable::Draw(CDC* pDC)
{
	try
	{
	for (int i = 0; i < rows; i++)
	{
		for (int j = 0; j < cols; j++)
		{
			XCell& cell = cells[i*cols+j];

			if (cell.colSpan !=0 && cell.rowSpan != 0)
			{
				RECT rect = GetRect(i,j);

				if (cell.GetOverlap())
				{
					RECT textRect = GetRect(i,j);

					cell.CalcTextRect(pDC, &textRect);

					if (textRect.right > rect.right)
					{
						for (j = j+1; j < cols; j ++)
						{
							if (cells[i*cols+j].text != "")
								break;
							rect.right += colWidth [j];
							if (rect.right > textRect.right)
								break;
						}
						j --;
					}

				}

				cell.Draw(pDC,rect);
			}
		}
	}
 
	if (focusCol && m_bFocusFrame && focusRow < rows && focusCol < cols) //**
	{
		RECT rect = GetRect (focusRow, 1);
		RECT rect2 = GetRect (focusRow, cols-1);
		RECT rect3=rect;
		if(rect2.right>rect3.right)
		rect3.right =rect2.right ;
		GetCells (focusRow, focusCol)->DrawHitBorder(pDC, rect3, RGB(255, 0, 20));
	}
	}
	catch(...)
	{
	}
	return 0;
}

// XTable message handlers
void XTable::OnPaint()
{
	CPaintDC dc(this);      // device context for painting

	CMemDC MemDC(&dc);
	OnDraw(&MemDC);
}

BOOL XTable::OnEraseBkgnd(CDC* pDC)
{
	return TRUE;
}


void XTable::OnKeyDown(UINT nChar, UINT nRepCnt, UINT nFlags)
{
	CPoint point;

	RECT rect = GetRect(focusRow,focusCol);
	point.x = rect.left;
	point.y = rect.top;

	switch (nChar)
	{
		case VK_DOWN:
			point.y =rect.bottom + 1;
			break;

		case VK_UP:
			point.y =point.y -2;
			break;

		case VK_LEFT:
			point.x = point.x - 2;
			break;

		case VK_RIGHT:
			point.x =rect.right + 1;
			break;

		default:
			return ;
	}

	HitTest (point,focusRow,focusCol);
	Invalidate();
	
	CWnd::OnKeyDown(nChar, nRepCnt, nFlags);
}

void XTable::OnLButtonDown(UINT nFlags, CPoint point)
{
	::PostMessage(this->GetSafeHwnd(),WM_USER_EDIT_END,1,1);
	if(!m_bFocusFrame)return;
	HitTest (point,focusRow,focusCol);
	
	SetFocus ();
	Invalidate();

	CWnd::OnLButtonDown(nFlags, point);
}
void XTable::OnEditEnd(WPARAM wParam,LPARAM lParam)
{
	if(m_nCurShow==-1)return;
	int nAdd=0;
	if(m_mode==4)nAdd=1;

	if(m_nCurShow==0)
	{
	if(wParam == TRUE)
	{
		CString strText(_T(""));
		m_edit.GetWindowText(strText);
		DWORD dwData = m_edit.GetCtrlData();
		int nItem= dwData>>16;
		int nIndex = dwData&0x0000ffff;
		CString oldtext=GetText(nItem,nIndex);
		SetText(nItem,nIndex,strText);
		AddName(nItem,11+nAdd, g_user.name);

		if(nIndex==9+nAdd)
		{
		if(atoi(GetText(nItem,9+nAdd))>0 )
			{
				SetBackColor (nItem,9+nAdd, RGB(255,0,0));
			}
			else  SetBackColor (nItem,9+nAdd, RGB(0,255,0));
		}
		if(nIndex==12+nAdd)
		{
		   if(GetText(nItem,12+nAdd)=="未到" )
			{
				SetBackColor (nItem,12+nAdd, RGB(255,0,0));
			}
			else  
				SetBackColor (nItem,12+nAdd, RGB(0,255,0));
		}
		if(oldtext!=strText)
		   Save(nItem);
	}
	m_edit.ShowWindow(SW_HIDE);	m_nCurShow=-1;	CalRowHeight();
	}
	else if(m_nCurShow==1)
	{
	if(wParam == TRUE)
	{
		CString strText(_T(""));
		m_combobox.GetWindowText(strText);
		if(strText.IsEmpty ())
		{
			m_combobox.ShowWindow(SW_HIDE);	m_nCurShow=-1;
			return;
		}
		int pos=m_combobox.GetCurSel ();
		if(pos==-1)
		{ 
			m_combobox.ShowWindow(SW_HIDE);	m_nCurShow=-1;
		DWORD dwData = m_combobox.GetCtrlData();
		int nItem= dwData>>16;
		int nIndex = dwData&0x0000ffff;
		CString oldtext=GetText(nItem,nIndex);
		SetText(nItem,nIndex,strText);
  
 
        AddName(nItem,11+nAdd, g_user.name);
		SetText(nItem,12+nAdd,"未到");
		if(oldtext!=strText)
		   Save(nItem);
			m_combobox.ShowWindow(SW_HIDE);	m_nCurShow=-1;	CalRowHeight();
			return;
		}
		if(m_acCombo.m_posarray.GetSize ()<=pos)
		{	 
				m_combobox.ShowWindow(SW_HIDE);	m_nCurShow=-1;

 
		DWORD dwData = m_combobox.GetCtrlData();
		int nItem= dwData>>16;
		int nIndex = dwData&0x0000ffff;
		CString oldtext=GetText(nItem,nIndex);
		SetText(nItem,nIndex,strText);
  
 
        AddName(nItem,11+nAdd, g_user.name);
		SetText(nItem,12+nAdd,"未到");
		if(oldtext!=strText)
		   Save(nItem);
		}
		else
		{
		int pos2=m_acCombo.m_posarray.ElementAt (pos);
		m_id=m_pClientArray->ElementAt (pos2).ElementAt (0);
		DWORD dwData = m_combobox.GetCtrlData();
		int nItem= dwData>>16;
		int nIndex = dwData&0x0000ffff;
		CString oldtext=GetText(nItem,nIndex);
		SetText(nItem,nIndex,strText);

		if(!m_pClientArray->ElementAt (pos2).ElementAt (3).IsEmpty ())
		    SetText(nItem,2,m_pClientArray->ElementAt (pos2).ElementAt (3)+" "+m_pClientArray->ElementAt (pos2).ElementAt (4));
		else
		    SetText(nItem,2,m_pClientArray->ElementAt (pos2).ElementAt (4));
 
		if(m_mode==4)
		{
			g_sendhead.bsql=0;
			CString filter="id='"+m_id+"' and kind<>'5'";
			g_sendhead.code[0]=56;
			g_sendhead.tabcount=1;
			g_bNoConnDlg=1;
			g_pMainWnd->ProcessChatMessageRequest2(filter);	g_bNoConnDlg=0;
		    if(g_bSendOK)
			{
				DataToArray(&g_List1array);	
				CString str;
				for(int i=0; i<g_List1array.GetSize (); i++)
				{		if(g_List1array.ElementAt (i).ElementAt (20)!="2")continue;
					str+=g_List1array.ElementAt (i).ElementAt (0);
					str+=",";
				}
				str.TrimRight (",");
				SetText(nItem,4,str);
			}
		}


		SetText(nItem,4+nAdd,m_pClientArray->ElementAt (pos2).ElementAt (5));
		SetText(nItem,5+nAdd,m_pClientArray->ElementAt (pos2).ElementAt (6));
		SetText(nItem,6+nAdd,m_pClientArray->ElementAt (pos2).ElementAt (7));
		SetText(nItem,7+nAdd,m_pClientArray->ElementAt (pos2).ElementAt (8));
		SetText(nItem,8+nAdd,m_pClientArray->ElementAt (pos2).ElementAt (9));
		SetText(nItem,9+nAdd,m_pClientArray->ElementAt (pos2).ElementAt (10));

			if(atoi(GetText(nItem,9+nAdd))>0 )
			{
				SetBackColor (nItem,9+nAdd, RGB(255,0,0));
			}
			else  SetBackColor (nItem,9+nAdd, RGB(0,255,0));


			if(!m_pClientArray->ElementAt (pos2).ElementAt (11).IsEmpty ())
				SetText(nItem,10+nAdd,"服装:"+m_pClientArray->ElementAt (pos2).ElementAt (11));
 
        AddName(nItem,11+nAdd, g_user.name);
		SetText(nItem,12+nAdd,"未到");
		if(oldtext!=strText)
		   Save(nItem);
		}
	}
	m_combobox.ShowWindow(SW_HIDE);	m_nCurShow=-1;	CalRowHeight();
	}
	else if(m_nCurShow==2)
	{
	if(wParam == TRUE)
	{
		CString strText(_T(""));
		m_combobox2.GetWindowText(strText);
		DWORD dwData = m_combobox2.GetCtrlData();
		int nItem= dwData>>16;
		int nIndex = dwData&0x0000ffff;
		CString oldtext=GetText(nItem,nIndex);
		SetText(nItem,nIndex,strText);
	//	SetText(nItem,11+nAdd, g_user.name);
		AddName(nItem,11+nAdd, g_user.name);

		if(nIndex==12+nAdd)
		{
		   if(GetText(nItem,12+nAdd)=="未到" )
			{
				SetBackColor (nItem,12+nAdd, RGB(255,0,0));
			}
			else  
				SetBackColor (nItem,12+nAdd, RGB(0,255,0));
		}

		if(oldtext!=strText)
		   Save(nItem);
	//Invalidate();
	}
	m_combobox2.ShowWindow(SW_HIDE);	m_nCurShow=-1;	CalRowHeight();
	}
	else if(m_nCurShow==3)
	{
	if(wParam == TRUE)
	{
		CString strText(_T(""));
		m_pComboBox->GetWindowText(strText);
		DWORD dwData = m_pComboBox->GetCtrlData();
		int nItem= dwData>>16;
		int nIndex = dwData&0x0000ffff;
		CString oldtext=GetText(nItem,nIndex);
		SetText(nItem,nIndex,strText);
		AddName(nItem,11+nAdd, g_user.name);

		if(nIndex==12+nAdd)
		{
		   if(GetText(nItem,12+nAdd)=="未到" )
			{
				SetBackColor (nItem,12+nAdd, RGB(255,0,0));
			}
			else  
				SetBackColor (nItem,12+nAdd, RGB(0,255,0));
		}

		if(oldtext!=strText)
		   Save(nItem);
	//Invalidate();
	}
	m_pComboBox->ShowWindow(SW_HIDE);	m_nCurShow=-1;	CalRowHeight();
	}	 

}

void XTable::ShowEdit(BOOL bShow,int nItem,int nIndex,CRect rcCtrl)
{
	try
	{
    if(m_edit.m_hWnd == NULL)
	{
		m_edit.Create(ES_AUTOHSCROLL|WS_CHILD|ES_LEFT|ES_WANTRETURN|WS_BORDER,CRect(0,0,0,0),this,IDC_EDIT1);
		m_edit.ShowWindow(SW_HIDE);

		CFont tpFont;
		tpFont.CreateStockObject(DEFAULT_GUI_FONT);
		m_edit.SetFont(&tpFont);
		tpFont.DeleteObject();
	}
	if(bShow == TRUE)
	{
	  	CString strItem = GetText(nItem,nIndex);
		m_edit.MoveWindow(rcCtrl);
		m_edit.ShowWindow(SW_SHOW);
		m_edit.SetWindowText(strItem);
		::SetFocus(m_edit.GetSafeHwnd());
		m_edit.SetSel(-1);  
		m_edit.SetCtrlData(MAKEWPARAM(nIndex,nItem)); 
	}
	else
		m_edit.ShowWindow(SW_HIDE);
	}
	catch(...)
	{
	}
}

void XTable::ShowSearchClientComboBox(BOOL bShow,int nItem,int nIndex,CRect rcCtrl)
{
	try
	{
    if(m_combobox.m_hWnd == NULL)
	{
		m_combobox.Create(WS_VSCROLL|WS_CHILD|CBS_DROPDOWN,CRect(0,0,0,0),this,100);
 	    m_combobox.ShowWindow(SW_HIDE);
		m_acCombo.m_mode =1;
		m_acCombo.Init(&m_combobox);
		m_acCombo.m_pArray=m_pClientArray;
		m_combobox.SetFocus ();
	}
	if(bShow == TRUE)
	{
	  	CString strItem = GetText(nItem,nIndex);
		rcCtrl.bottom+=300;
		m_combobox.MoveWindow(rcCtrl);
		m_combobox.ShowWindow(SW_SHOW);
		m_combobox.SetWindowText(strItem);
		::SetFocus(m_combobox.GetSafeHwnd());
 	 	m_combobox.SetCtrlData(MAKEWPARAM(nIndex,nItem)); 
	}
	else
		m_combobox.ShowWindow(SW_HIDE);
	}
	catch(...)
	{
	}
}

void XTable::ShowSearchClientComboBoxTime(BOOL bShow,int nItem,int nIndex,int type,CRect rcCtrl)
{
 	if(type>=2 && type<=4)
	{ 
		m_nCurShow=3;
		ShowSearchClientComboBoxTree( bShow, nItem, nIndex, type, rcCtrl);
		return;
	}
	try
	{
    if(m_combobox2.m_hWnd == NULL)
	{
		m_combobox2.Create(WS_VSCROLL|WS_CHILD|CBS_DROPDOWN,CRect(0,0,0,0),this,100);
 	    m_combobox2.ShowWindow(SW_HIDE);
		m_combobox2.SetFocus ();
	}
	m_combobox2.ResetContent ();
	if(type==0)
	{
		m_combobox2.AddString ("9:00");
		m_combobox2.AddString ("9:30");
		m_combobox2.AddString ("10:00");
		m_combobox2.AddString ("10:30");
		m_combobox2.AddString ("11:00");
		m_combobox2.AddString ("11:30");
		m_combobox2.AddString ("12:00");
		m_combobox2.AddString ("13:00");
		m_combobox2.AddString ("14:00");
		m_combobox2.AddString ("15:00");
		m_combobox2.AddString ("16:00");
		m_combobox2.AddString ("17:00");
		m_combobox2.AddString ("18:00");
		m_combobox2.AddString ("19:00");
		m_combobox2.AddString ("20:00");
		m_combobox2.AddString ("21:00");
	}
	else if(type==1)
	{
		for(int i=0; i<pTxtypearray->GetSize (); i++)
		   m_combobox2.AddString (pTxtypearray->ElementAt (i).ElementAt (0));
	}
	else if(type==2)
	{
		for(int ii=0; ii<g_userarray.GetSize (); ii++)
		{
			 if("摄影部"== g_userarray.ElementAt (ii).ElementAt(2) )
				 m_combobox2.AddString ( g_userarray.ElementAt (ii).ElementAt(1) );
		}
	}
	else if(type==3)
	{
		for(int ii=0; ii<g_userarray.GetSize (); ii++)
		{
			 if("化妆部"== g_userarray.ElementAt (ii).ElementAt(2) )
				 m_combobox2.AddString ( g_userarray.ElementAt (ii).ElementAt(1) );
		}
	}
	else if(type==4)
	{
		for(int ii=0; ii<g_userarray.GetSize (); ii++)
		{
		//	 if("化妆部"== g_userarray.ElementAt (ii).ElementAt(2) )
				 m_combobox2.AddString ( g_userarray.ElementAt (ii).ElementAt(1) );
		}
	}
	else if(type==5)
	{
		m_combobox2.AddString ("未到");
		m_combobox2.AddString ("已到");
	}
	if(bShow == TRUE)
	{
	  	CString strItem = GetText(nItem,nIndex);
		rcCtrl.bottom+=300;
		m_combobox2.MoveWindow(rcCtrl);
		m_combobox2.ShowWindow(SW_SHOW);
		m_combobox2.SetWindowText(strItem);
		::SetFocus(m_combobox2.GetSafeHwnd());
 	 	m_combobox2.SetCtrlData(MAKEWPARAM(nIndex,nItem)); 
	}
	else
		m_combobox2.ShowWindow(SW_HIDE);
	}
	catch(...)
	{
	}
}


void XTable::ShowSearchClientComboBoxTree(BOOL bShow,int nItem,int nIndex,int type,CRect rcCtrl)
{
	try
	{
    if(0)//m_pComboBox->m_hWnd == NULL)
	{
		m_pComboBox->Create(WS_VSCROLL|WS_CHILD|CBS_DROPDOWNLIST,CRect(0,0,100,100),this,100);
 	    m_pComboBox->ShowWindow(SW_HIDE);
		m_pComboBox->SetFocus ();
	}
 
 
	if(bShow == TRUE)
	{
			 
 
	  	CString strItem = GetText(nItem,nIndex);
		rcCtrl.bottom+=300;

	    ClientToScreen(rcCtrl);
		GetParent()->GetParent()->ScreenToClient(rcCtrl);

		m_pComboBox->MoveWindow(rcCtrl);
 
		m_pComboBox->ShowWindow(SW_SHOW);

		m_pComboBox->ResetContent();
		m_pComboBox->AddString(strItem);
		m_pComboBox->SetCurSel (0);


		::SetFocus(m_pComboBox->GetSafeHwnd());
 	 	m_pComboBox->SetCtrlData(MAKEWPARAM(nIndex,nItem)); 

		m_pComboBox->RefDroppedWidth();	
 
	}
	else
		m_pComboBox->ShowWindow(SW_HIDE);
	}
	catch(...)
	{
	}
}

void XTable::OnLButtonDblClk(UINT nFlags, CPoint point)
{
	try
	{
	if(!m_bFocusFrame)return;
	if(HitTest (point,focusRow,focusCol)==0)return;
	if(IsDateRow(focusRow))return;
	RECT rect = GetRect (focusRow,focusCol);
	if(focusCol==0)return;

	int nAdd=0;
	if(m_mode==10)
	{
	if(focusRow>0)
	{
		for(int i=0; i<focusRow; i++)
		{
		    if(""==GetText(i,1))
			{
				AfxMessageBox("请从上方空白处开始填起!", MB_ICONINFORMATION);
				return;
			}
		}
	}
	if(focusCol==1)
	{	
	//	m_nCurShow=1;
 	//    ShowSearchClientComboBox(TRUE,focusRow,focusCol,rect);
		m_nCurShow=0;
		ShowEdit(TRUE,focusRow,focusCol,rect);
	}
	else if(""==GetText(focusRow,1))		
	{
		AfxMessageBox("请先填写客人姓名!", MB_ICONINFORMATION);
		return;
	}
	if(focusCol==11+nAdd)return;

	if(focusCol==3)
	{		m_nCurShow=2;
 	    ShowSearchClientComboBoxTime(TRUE,focusRow,focusCol,0,rect);

	}
 	else if(focusCol==6+nAdd)
	{		m_nCurShow=2;
 	    ShowSearchClientComboBoxTime(TRUE,focusRow,focusCol,2,rect);

	}
 	else if(focusCol==7+nAdd)
	{	m_nCurShow=2;
 	    ShowSearchClientComboBoxTime(TRUE,focusRow,focusCol,2,rect);
	
	} 
	else if(focusCol==8+nAdd)
	{	m_nCurShow=2;
 	    ShowSearchClientComboBoxTime(TRUE,focusRow,focusCol,2,rect);
	
	}
 	else if(focusCol==12+nAdd)
	{	m_nCurShow=2;
 	    ShowSearchClientComboBoxTime(TRUE,focusRow,focusCol,5,rect);
	
	}
	else if(focusCol!=1)
	{	m_nCurShow=0;
		ShowEdit(TRUE,focusRow,focusCol,rect);
	
	}
	}
	else
	{
	if(m_mode==4)nAdd=1;
	if(focusRow>0)
	{
		for(int i=0; i<focusRow; i++)
		{
		    if(""==GetText(i,1))
			{
				AfxMessageBox("请从上方空白处开始填起!", MB_ICONINFORMATION);
				return;
			}
		}
	}
	if(focusCol==1)
	{		m_nCurShow=1;
 	    ShowSearchClientComboBox(TRUE,focusRow,focusCol,rect);

	}
	else if(""==GetText(focusRow,1))		
	{
		AfxMessageBox("请先填写客人姓名!", MB_ICONINFORMATION);
		return;
	}
	if(focusCol==11+nAdd)return;

	if(focusCol==3)
	{		m_nCurShow=2;
 	    ShowSearchClientComboBoxTime(TRUE,focusRow,focusCol,0,rect);

	}
 	else if(focusCol==4+nAdd)
	{		m_nCurShow=2;
 	    ShowSearchClientComboBoxTime(TRUE,focusRow,focusCol,1,rect);

	}
 	else if(focusCol==6+nAdd)
	{	m_nCurShow=2;
 	    ShowSearchClientComboBoxTime(TRUE,focusRow,focusCol,2,rect);
	
	}
 	else if(focusCol==7+nAdd)
	{	m_nCurShow=2;
 	    ShowSearchClientComboBoxTime(TRUE,focusRow,focusCol,3,rect);
	
	}
 	else if(focusCol==8+nAdd)
	{	m_nCurShow=2;
 	    ShowSearchClientComboBoxTime(TRUE,focusRow,focusCol,4,rect);
	
	} 
 	else if(focusCol==12+nAdd)
	{	m_nCurShow=2;
 	    ShowSearchClientComboBoxTime(TRUE,focusRow,focusCol,5,rect);
	
	}
	else if(focusCol!=1)
	{	m_nCurShow=0;
		ShowEdit(TRUE,focusRow,focusCol,rect);
	
	}
	}
	}
	catch(...)
	{
	}
	CWnd::OnLButtonDown(nFlags, point);
}

BOOL XTable::RegisterWindowClass()
{
    WNDCLASS wndcls;
    HINSTANCE hInst = AfxGetInstanceHandle();

    if (!(::GetClassInfo(hInst, XTABLE_CLASSNAME, &wndcls)))
    {
        // otherwise we need to register a new class
        wndcls.style            = CS_DBLCLKS | CS_HREDRAW | CS_VREDRAW;
        wndcls.lpfnWndProc      = ::DefWindowProc;
        wndcls.cbClsExtra       = wndcls.cbWndExtra = 0;
        wndcls.hInstance        = hInst;
        wndcls.hIcon            = NULL;
        wndcls.hCursor          = AfxGetApp()->LoadStandardCursor(IDC_ARROW);
        wndcls.hbrBackground    = (HBRUSH) (COLOR_3DFACE + 1);
        wndcls.lpszMenuName     = NULL;
        wndcls.lpszClassName    = XTABLE_CLASSNAME;

        if (!AfxRegisterClass(&wndcls))
        {
            AfxThrowResourceException();
            return FALSE;
        }
    }

    return TRUE;
}


int XTable::Test2 ()
{
	defaultHeight = 20;
	CStringArray array;

	if(m_mode==10)
	{
	array.Add ("姓名");
 	array.Add ("电话");
	array.Add ("时间");
	array.Add ("内容");
	array.Add ("价格");
 	array.Add ("摄影");
 	array.Add ("化妆");
 	array.Add ("门市");
 	array.Add ("欠款");
 	array.Add ("备注");
 	array.Add ("录入"); 
	array.Add ("是否到店");
	}
	else if(m_mode==4)
	{
	array.Add ("姓名");
 	array.Add ("电话");
	array.Add ("时间");
	array.Add ("婚庆内容");
 	array.Add ("类别");
	array.Add ("价格");
 	array.Add ("摄影");
#ifdef CHILD_VERSION
 	array.Add ("引导");
#else
 	array.Add ("化妆");
#endif
 	array.Add ("门市");
 	array.Add ("欠款");
 	array.Add ("备注");
 	array.Add ("录入"); 
	array.Add ("是否到店");
	}
	else
	{
	array.Add ("姓名");
 	array.Add ("电话");
	array.Add ("时间");
 	array.Add ("类别");
	array.Add ("价格");
 	array.Add ("摄影");
#ifdef CHILD_VERSION
 	array.Add ("引导");
#else
 	array.Add ("化妆");
#endif
 	array.Add ("门市");
 	array.Add ("欠款");
 	array.Add ("备注");
 	array.Add ("录入"); 
	array.Add ("是否到店");
	}
	int cols=array.GetSize();

	CRect rc;
	GetClientRect(rc);
	defaultWidth = (rc.Width()-10)/cols;
	SetCols (1);
	SetRows (2);
	SetCols (cols+1);

	COLORREF col1=RGB(0xC8, 0x96, 0x96);
	COLORREF col2=RGB(0x64,0x96,0xC8);
	int i = 0;
	for (/*int*/ i = 0; i < 2; i ++)
		SetBackColor (i, 0, col1);
	for (  i = 0; i < cols+1; i ++)
		SetBackColor (0, i, col1);
 
    SetRowHeight (0, 10);
 	SetColWidth (0, 10);

	for(i=0; i<cols; i++)
	{
		SetBackColor (1,i+1, col2);
		SetText (1,i+1, array.ElementAt (i));
	}

 
	Invalidate();
	return 0;
}
///edit

XTableEdit::XTableEdit()
{
}

XTableEdit::~XTableEdit()
{
}


BEGIN_MESSAGE_MAP(XTableEdit, CEdit)
	//{{AFX_MSG_MAP(XTableEdit)
	ON_WM_KILLFOCUS()
	ON_WM_SETFOCUS()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// XTableEdit message handlers
void XTableEdit::SetCtrlData(DWORD dwData)
{
	m_dwData = dwData;
}

DWORD XTableEdit::GetCtrlData()
{
   return m_dwData;
}

void XTableEdit::OnKillFocus(CWnd* pNewWnd) 
{
	CEdit::OnKillFocus(pNewWnd);
	CWnd* pParent = this->GetParent();
	::PostMessage(pParent->GetSafeHwnd(),WM_USER_EDIT_END,m_bExchange,0);
}

BOOL XTableEdit::PreTranslateMessage(MSG* pMsg) 
{
	
	if(pMsg->message == WM_KEYDOWN)
	{
		if(pMsg->wParam == VK_RETURN)
		{
			CWnd* pParent = this->GetParent();
			m_bExchange = TRUE;
			::PostMessage(pParent->GetSafeHwnd(),WM_USER_EDIT_END,m_bExchange,0);
		}
		else if(pMsg->wParam == VK_ESCAPE)
		{
           CWnd* pParent = this->GetParent();
		   m_bExchange = FALSE;
			::PostMessage(pParent->GetSafeHwnd(),WM_USER_EDIT_END,m_bExchange,0);
		}
	}
	
	return CEdit::PreTranslateMessage(pMsg);
}

void XTableEdit::OnSetFocus(CWnd* pOldWnd) 
{
	CEdit::OnSetFocus(pOldWnd);
    m_bExchange = TRUE;	
}
 
XTableComboBox::XTableComboBox()
{
}

XTableComboBox::~XTableComboBox()
{
}
BEGIN_MESSAGE_MAP(XTableComboBox, CComboBox)
	//{{AFX_MSG_MAP(XTableComboBox)
	ON_WM_KILLFOCUS()
	ON_WM_SETFOCUS()
	ON_CONTROL_REFLECT(CBN_CLOSEUP, OnCloseup)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// XTableComboBox message handlers
void XTableComboBox::SetCtrlData(DWORD dwData)
{
	m_dwData = dwData;
}

DWORD XTableComboBox::GetCtrlData()
{
   return m_dwData;
}

void XTableComboBox::OnKillFocus(CWnd* pNewWnd) 
{ 
	CComboBox::OnKillFocus(pNewWnd);
/*	CWnd* pParent = this->GetParent();
	if(((XTable*)pParent)->m_nCurShow!=-1)
	::PostMessage(pParent->GetSafeHwnd(),WM_USER_EDIT_END,m_bExchange,1);*/
}

BOOL XTableComboBox::PreTranslateMessage(MSG* pMsg) 
{
	if(pMsg->message == WM_KEYDOWN)
	{
		if(pMsg->wParam == VK_RETURN)
		{
			CWnd* pParent = this->GetParent();
			m_bExchange = TRUE;
			::PostMessage(pParent->GetSafeHwnd(),WM_USER_EDIT_END,m_bExchange,1);
		}
		else if(pMsg->wParam == VK_ESCAPE)
		{
           CWnd* pParent = this->GetParent();
		   m_bExchange = FALSE;
			::PostMessage(pParent->GetSafeHwnd(),WM_USER_EDIT_END,m_bExchange,1);
		}
	}
	
	return CComboBox::PreTranslateMessage(pMsg);
}

void XTableComboBox::OnSetFocus(CWnd* pOldWnd) 
{
 	CComboBox::OnSetFocus(pOldWnd);
    m_bExchange = TRUE;	
}

void XTableComboBox::OnCloseup() 
{
	// TODO: Add your control notification handler code here
	CWnd* pParent = this->GetParent();
	::PostMessage(pParent->GetSafeHwnd(),WM_USER_EDIT_END,m_bExchange,1);	
}

void XTable::CalRowHeight()
{ 
	CString str;		CPaintDC dc(this);  
	for(int i=0; i<GetRows(); i++)
	{
    	SetRowHeight (i, 20);
		for(int j=1; j<GetCols(); j++)
		{
			str=GetText(i, j);
		
			RECT rect = GetRect(i,j);
			RECT textRect=rect;

			this->SetWordbreak (i, j, 0);
			XCell* cell = GetCells (i, j);
			cell->CalcTextRect(&dc, &textRect);
			if (textRect.right > rect.right || textRect.bottom > rect.bottom)
			{
				this->SetWordbreak (i, j, 1);
				textRect=rect;
				cell->CalcTextRect(&dc, &textRect);
				rect.bottom =textRect.bottom+2;
			//	if(rect.bottom-rect.top>100)rect.bottom=rect.top+100;
				SetRowHeight (i, rect.bottom-rect.top); 
			}
		}
	}
	Invalidate();
}

void XTable::Save(int row)
{
	if(m_mode==4)
	{
		Save2(row);return;
	}
	if(m_mode==10)
	{
		Save3(row);return;
	}
	if(IsHasRightsnew(2)==0)return;
	if(::GetTickCount ()-m_nticks<1000)return;
	m_nticks=::GetTickCount ();

	int oldrow=row;
	BOOL bFind=0;
	for(int i=0; i<m_daterowposarray.GetSize (); i++)
	{
		if(row<m_daterowposarray.ElementAt (i))
		{
			row-=i;bFind=1;
			break;
		}
		if(row==m_daterowposarray.ElementAt (i))
			return;
	}
	if(bFind==0)row-=m_daterowposarray.GetSize ();

	if(row>=m_pListArray->GetSize())//新预约
	{
	CString	name=GetText(oldrow, 1);
	CString	phone=GetText(oldrow, 2);
	CString	time=GetText(oldrow, 3);
	CString	type=GetText(oldrow, 4);
	CString	price=GetText(oldrow, 5);
	CString	waiter1=GetText(oldrow, 6);
	CString	waiter2=GetText(oldrow, 7);
	CString	receptionist=GetText(oldrow, 8);
	CString	arrearage=GetText(oldrow, 9);
	CString	remark=GetText(oldrow, 10);

	CString	arrive=GetText(oldrow, 12);
	CString	timestamp=CTime::GetCurrentTime ().Format ("%Y%m%d%H%M%S");
	CString str=CTime::GetCurrentTime ().Format ("%Y-%m-%d %H:%M:%S");
	str.Replace("-", "");
	str=str.Left(str.GetLength()-3);
	CString	clerk=GetText(oldrow, 11)+str;
	CString	date=((TodayForm2*)(GetParent()->GetParent()))->GetDate();
	if(name.IsEmpty())return;
	CString sql,sql2;
sql.Format ("insert into [todaytake]([name],[phone],[time],[type],[price],[waiter1],[waiter2],[receptionist],[arrearage],[remark],[clerk],[timestamp],[date],[mode],[arrive],[id])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%d','%s','%s')", name,phone,time,type,price,waiter1,waiter2,receptionist,arrearage,remark,clerk,timestamp,date,m_mode,arrive,m_id);
    if(m_mode==0)
	{
		sql2.Format ("***update dindan set [time2]='%s' where [id]='%s'", date, m_id);
	}
    else if(m_mode==1)
	{
		sql2.Format ("***update dindan set [time4]='%s' where [id]='%s'", date, m_id);
	}
    else if(m_mode==2)
	{
		sql2.Format ("***update dindan set [time6]='%s' where [id]='%s'", date, m_id);
	}
    else if(m_mode==3)
	{
		sql2.Format ("***update dindan set [time5]='%s' where [id]='%s'", date, m_id);
	}
	sql+=sql2;
	g_sendhead.bsql=1;
	g_pMainWnd->ProcessChatMessageRequest2(sql); //if(g_bSendOK==0)return;
     ((TodayForm2*)(GetParent()->GetParent()))->ReLoad1();
	}
	else
	{ 
	CString	name=GetText(oldrow, 1);
	CString	phone=GetText(oldrow, 2);
	CString	time=GetText(oldrow, 3);
	CString	type=GetText(oldrow, 4);
	CString	price=GetText(oldrow, 5);
	CString	waiter1=GetText(oldrow, 6);
	CString	waiter2=GetText(oldrow, 7);
	CString	receptionist=GetText(oldrow, 8);
	CString	arrearage=GetText(oldrow, 9);
	CString	remark=GetText(oldrow, 10);
	CString	clerk=GetText(oldrow, 11);
	CString	arrive=GetText(oldrow, 12);
	CString	timestamp=m_pListArray->ElementAt(row).ElementAt(13);
 
	if(name.IsEmpty())return;
	CString sql;
sql.Format ("update [todaytake] set [name]='%s',[phone]='%s',[time]='%s',[type]='%s',[price]='%s',[waiter1]='%s',[waiter2]='%s',[receptionist]='%s',[arrearage]='%s',[remark]='%s',[clerk]='%s',[arrive]='%s' where [timestamp]='%s'", name,phone,time,type,price,waiter1,waiter2,receptionist,arrearage,remark,clerk,arrive,timestamp);
if(IsHasRights2new(31)==0)
 sql.Format ("update [todaytake] set [name]='%s',[time]='%s',[type]='%s',[waiter1]='%s',[waiter2]='%s',[receptionist]='%s',[arrearage]='%s',[remark]='%s',[clerk]='%s',[arrive]='%s' where [timestamp]='%s'", name,time,type,waiter1,waiter2,receptionist,arrearage,remark,clerk,arrive,timestamp);

	g_sendhead.bsql=1;
	g_pMainWnd->ProcessChatMessageRequest2(sql); 
	}
}
void XTable::Save2(int row)
{
	if(IsHasRightsnew(2)==0)return;
	if(::GetTickCount ()-m_nticks<1000)return;
	m_nticks=::GetTickCount ();

	int oldrow=row;
	BOOL bFind=0;
	for(int i=0; i<m_daterowposarray.GetSize (); i++)
	{
		if(row<m_daterowposarray.ElementAt (i))
		{
			row-=i;bFind=1;
			break;
		}
		if(row==m_daterowposarray.ElementAt (i))
			return;
	}
	if(bFind==0)row-=m_daterowposarray.GetSize ();

	if(row>=m_pListArray->GetSize())//新预约
	{
	CString	name=GetText(oldrow, 1);
	CString	phone=GetText(oldrow, 2);
	CString	time=GetText(oldrow, 3);
	CString	content=GetText(oldrow, 4);
	CString	type=GetText(oldrow, 5);
	CString	price=GetText(oldrow, 6);
	CString	waiter1=GetText(oldrow, 7);
	CString	waiter2=GetText(oldrow, 8);
	CString	receptionist=GetText(oldrow, 9);
	CString	arrearage=GetText(oldrow, 10);
	CString	remark=GetText(oldrow, 11);
	 

	CString str=CTime::GetCurrentTime ().Format ("%Y-%m-%d %H:%M:%S");
	str.Replace("-", "");
	str=str.Left(str.GetLength()-3);
	CString	clerk=GetText(oldrow, 12)+str;


	CString	arrive=GetText(oldrow, 13);
	CString	timestamp=CTime::GetCurrentTime ().Format ("%Y%m%d%H%M%S");
	CString	date=((TodayForm2*)(GetParent()->GetParent()))->GetDate();
	if(name.IsEmpty())return;
	CString sql;
sql.Format ("insert into [todaytake]([name],[phone],[time],[type],[price],[waiter1],[waiter2],[receptionist],[arrearage],[remark],[clerk],[timestamp],[date],[mode],[content],[arrive],[id])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%d','%s','%s','%s')", name,phone,time,type,price,waiter1,waiter2,receptionist,arrearage,remark,clerk,timestamp,date,m_mode,content,arrive,m_id);

  

	g_sendhead.bsql=1;
	g_pMainWnd->ProcessChatMessageRequest2(sql); //if(g_bSendOK==0)return;
     ((TodayForm2*)(GetParent()->GetParent()))->ReLoad1();
	}
	else
	{ 
	CString	name=GetText(oldrow, 1);
	CString	phone=GetText(oldrow, 2);
	CString	time=GetText(oldrow, 3);
	CString	content=GetText(oldrow, 4);
	CString	type=GetText(oldrow, 5);
	CString	price=GetText(oldrow, 6);
	CString	waiter1=GetText(oldrow, 7);
	CString	waiter2=GetText(oldrow, 8);
	CString	receptionist=GetText(oldrow, 9);
	CString	arrearage=GetText(oldrow, 10);
	CString	remark=GetText(oldrow, 11);
	CString	clerk=GetText(oldrow, 12);
	CString	arrive=GetText(oldrow, 13);
	CString	timestamp=m_pListArray->ElementAt(row).ElementAt(14);
 
	if(name.IsEmpty())return;
	CString sql;
sql.Format ("update [todaytake] set [name]='%s',[phone]='%s',[time]='%s',[type]='%s',[price]='%s',[waiter1]='%s',[waiter2]='%s',[receptionist]='%s',[arrearage]='%s',[remark]='%s',[clerk]='%s',[content]='%s',[arrive]='%s' where [timestamp]='%s'", name,phone,time,type,price,waiter1,waiter2,receptionist,arrearage,remark,clerk,content,arrive,timestamp);
if(IsHasRights2new(31)==0)
sql.Format ("update [todaytake] set [name]='%s',[time]='%s',[type]='%s',[waiter1]='%s',[waiter2]='%s',[receptionist]='%s',[arrearage]='%s',[remark]='%s',[clerk]='%s',[content]='%s',[arrive]='%s' where [timestamp]='%s'", name,time,type,waiter1,waiter2,receptionist,arrearage,remark,clerk,content,arrive,timestamp);


	g_sendhead.bsql=1;
	g_pMainWnd->ProcessChatMessageRequest2(sql); 
	}
}
void XTable::Save3(int row)
{
	if(IsHasRightsnew(2)==0)return;
	if(::GetTickCount ()-m_nticks<1000)return;
	m_nticks=::GetTickCount ();
 
	int oldrow=row;
	BOOL bFind=0;
	for(int i=0; i<m_daterowposarray.GetSize (); i++)
	{
		if(row<m_daterowposarray.ElementAt (i))
		{
			row-=i;bFind=1;
			break;
		}
		if(row==m_daterowposarray.ElementAt (i))
			return;
	}
 
	if(bFind==0)row-=m_daterowposarray.GetSize ();
 

	if(row>=m_pListArray->GetSize())//新预约
	{
	CString	name=GetText(oldrow, 1);
	CString	phone=GetText(oldrow, 2);
	CString	time=GetText(oldrow, 3);
	CString	content=GetText(oldrow, 4);
	CString	price=GetText(oldrow, 5);
	CString	waiter1=GetText(oldrow, 6);
	CString	waiter2=GetText(oldrow, 7);
	CString	receptionist=GetText(oldrow, 8);
	CString	arrearage=GetText(oldrow, 9);
	CString	remark=GetText(oldrow, 10);
 
	CString str=CTime::GetCurrentTime ().Format ("%Y-%m-%d %H:%M:%S");
	str.Replace("-", "");
	str=str.Left(str.GetLength()-3);
	CString	clerk=GetText(oldrow, 11)+str;

	CString	arrive=GetText(oldrow, 12);
	CString	timestamp=CTime::GetCurrentTime ().Format ("%Y%m%d%H%M%S");
	CString	date=((TodayForm*)(GetParent()->GetParent()))->GetDate();
	if(name.IsEmpty())return;
	CString sql;
sql.Format ("insert into [todaytake]([name],[phone],[time],[price],[waiter1],[waiter2],[receptionist],[arrearage],[remark],[clerk],[timestamp],[date],[mode],[content],[arrive],[id])values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%d','%s','%s','%s')", name,phone,time,price,waiter1,waiter2,receptionist,arrearage,remark,clerk,timestamp,date,m_mode,content,arrive,m_id);
	g_sendhead.bsql=1;
	g_pMainWnd->ProcessChatMessageRequest2(sql); //if(g_bSendOK==0)return;
 
     ((TodayForm*)(GetParent()->GetParent()))->ReLoad1();
 
	}
	else
	{ 
	CString	name=GetText(oldrow, 1);
	CString	phone=GetText(oldrow, 2);
	CString	time=GetText(oldrow, 3);
	CString	content=GetText(oldrow, 4);
	CString	price=GetText(oldrow, 5);
	CString	waiter1=GetText(oldrow, 6);
	CString	waiter2=GetText(oldrow, 7);
	CString	receptionist=GetText(oldrow, 8);
	CString	arrearage=GetText(oldrow, 9);
	CString	remark=GetText(oldrow, 10);
	CString	clerk=GetText(oldrow, 11);
	CString	arrive=GetText(oldrow, 12);
	CString	timestamp=m_pListArray->ElementAt(row).ElementAt(13);
 
	if(name.IsEmpty())return;
	CString sql;
sql.Format ("update [todaytake] set [name]='%s',[phone]='%s',[time]='%s',[price]='%s',[waiter1]='%s',[waiter2]='%s',[receptionist]='%s',[arrearage]='%s',[remark]='%s',[clerk]='%s',[content]='%s',[arrive]='%s' where [timestamp]='%s'", name,phone,time,price,waiter1,waiter2,receptionist,arrearage,remark,clerk,content,arrive,timestamp);
if(IsHasRights2new(31)==0)
sql.Format ("update [todaytake] set [name]='%s',[time]='%s',[waiter1]='%s',[waiter2]='%s',[receptionist]='%s',[arrearage]='%s',[remark]='%s',[clerk]='%s',[content]='%s',[arrive]='%s' where [timestamp]='%s'", name,time,waiter1,waiter2,receptionist,arrearage,remark,clerk,content,arrive,timestamp);


	g_sendhead.bsql=1;
	g_pMainWnd->ProcessChatMessageRequest2(sql); 
	}
}

void XTable::DeleteCur()
{
	int row=focusRow;
	CString	name=GetText(row, 1);
 
	BOOL bFind=0;
	for(int i=0; i<m_daterowposarray.GetSize (); i++)
	{
		if(row<m_daterowposarray.ElementAt (i))
		{
			row-=i;bFind=1;
			break;
		}
		if(row==m_daterowposarray.ElementAt (i))
			return;
	}
	if(bFind==0)row-=m_daterowposarray.GetSize ();

	if(row>=m_pListArray->GetSize())
		return;

 

	if(AfxMessageBox("确定删除客人"+name+"的预约资料吗?", MB_YESNO|MB_ICONINFORMATION)!=IDYES)return;



	int size=m_pListArray->ElementAt(row).GetSize ();
	CString	timestamp=m_pListArray->ElementAt(row).ElementAt(size-2);
	CString sql;
sql.Format ("delete from todaytake where [timestamp]='%s'", timestamp);
	g_sendhead.bsql=1;
	g_pMainWnd->ProcessChatMessageRequest2(sql);  
	if(m_mode==10)
       ((TodayForm*)(GetParent()->GetParent()))->ReLoad1();
	else
       ((TodayForm2*)(GetParent()->GetParent()))->ReLoad1();
}
CString XTable::GetCurPhone(CString &name)
{
	int row=focusRow;
	name=GetText(row, 1);
	return GetText(row, 2);
	BOOL bFind=0;
	for(int i=0; i<m_daterowposarray.GetSize (); i++)
	{
		if(row<m_daterowposarray.ElementAt (i))
		{
			row-=i;bFind=1;
			break;
		}
		if(row==m_daterowposarray.ElementAt (i))
			return "";
	}
	if(bFind==0)row-=m_daterowposarray.GetSize ();

	if(row>=m_pListArray->GetSize())
		return "";

	int size=m_pListArray->ElementAt(row).GetSize ();
	CString	date=m_pListArray->ElementAt(row).ElementAt(size-3);
	CString	timestamp=m_pListArray->ElementAt(row).ElementAt(size-2);
	CString	id=m_pListArray->ElementAt(row).ElementAt(size-1);
 
}
void XTable::OtherDate()
{
	int row=focusRow;
	CString	name=GetText(row, 1);
	BOOL bFind=0;
	for(int i=0; i<m_daterowposarray.GetSize (); i++)
	{
		if(row<m_daterowposarray.ElementAt (i))
		{
			row-=i;bFind=1;
			break;
		}
		if(row==m_daterowposarray.ElementAt (i))
			return;
	}
	if(bFind==0)row-=m_daterowposarray.GetSize ();

	if(row>=m_pListArray->GetSize())
		return;

	int size=m_pListArray->ElementAt(row).GetSize ();
	CString	date=m_pListArray->ElementAt(row).ElementAt(size-3);
	CString	timestamp=m_pListArray->ElementAt(row).ElementAt(size-2);
	CString	id=m_pListArray->ElementAt(row).ElementAt(size-1);
	InputDate dlg;
	dlg.m_date =date;
	dlg.m_name =name;
	dlg.m_name =m_pListArray->ElementAt(row).ElementAt(0);

	if(dlg.DoModal ()!=IDOK)return;

 

	CString sql,sql2;
sql.Format ("update [todaytake] set [date]='%s' where [timestamp]='%s'", dlg.m_date, timestamp);
	g_sendhead.bsql=1;

    if(m_mode==0)
	{
		sql2.Format ("***update dindan set [time2]='%s' where [id]='%s'", dlg.m_date, id);
	}
    else if(m_mode==1)
	{
		sql2.Format ("***update dindan set [time4]='%s' where [id]='%s'", dlg.m_date, id);
	}
    else if(m_mode==2)
	{
		sql2.Format ("***update dindan set [time6]='%s' where [id]='%s'", dlg.m_date, id);
	}
    else if(m_mode==3)
	{
		sql2.Format ("***update dindan set [time5]='%s' where [id]='%s'", dlg.m_date, id);
	}
	sql+=sql2;

	g_pMainWnd->ProcessChatMessageRequest2(sql);  
	if(m_mode==10)
       ((TodayForm*)(GetParent()->GetParent()))->ReLoad1();
	else
       ((TodayForm2*)(GetParent()->GetParent()))->ReLoad1();
}

BOOL XTable::IsDateRow(int row)
{
	try
	{
	for(int i=0; i<m_daterowposarray.GetSize (); i++)
	{
		if(row==m_daterowposarray.ElementAt (i))
			return 1;
	}
	}
	catch(...)
	{
	}
	return 0;
}

CString XTable::GetWeek(CString date)
{
	if(date.GetLength ()!=10)return "";
	COleDateTime   dtDay(atoi(date.Mid (0,4)),atoi(date.Mid (5,2)),atoi(date.Mid (8,2)), 0, 0, 0); 
	int nDayWeek   =   dtDay.GetDayOfWeek()-1;     //得到星期几，1=Sunday,   2=Monday, 
	CString DayOfWeek[7]={"星期日","星期一","星期二","星期三","星期四","星期五","星期六"};
	CString sdate;
	if(nDayWeek>=0 && nDayWeek<=6)
		sdate=DayOfWeek[nDayWeek];
	else
		sdate="无效日期";
	return sdate;
}

int XTable::Test()
{
	if(m_mode==10)
		return Test3();
	CStringArray array;
	if(m_mode==4)
	{
	array.Add ("姓名");
 	array.Add ("电话");
	array.Add ("时间");
	array.Add ("婚庆内容");
 	array.Add ("类别");
	array.Add ("价格");
 	array.Add ("摄影");
#ifdef CHILD_VERSION
 	array.Add ("引导");
#else
 	array.Add ("化妆");
#endif
 	array.Add ("门市");
 	array.Add ("欠款");
 	array.Add ("备注");
 	array.Add ("录入");
 	array.Add ("是否到店");
	}
	else
	{
	array.Add ("姓名");
 	array.Add ("电话");
	array.Add ("时间");
 	array.Add ("类别");
	array.Add ("价格");
 	array.Add ("摄影");
#ifdef CHILD_VERSION
 	array.Add ("引导");
#else
 	array.Add ("化妆");
#endif
 	array.Add ("门市");
 	array.Add ("欠款");
 	array.Add ("备注");
 	array.Add ("录入"); 
	array.Add ("是否到店");
	}
	HidePrice();
	int cols=array.GetSize();

	int nAdd=0;
	if(m_mode==4)nAdd=1;


	CRect rc;
	GetClientRect(rc);
	defaultWidth = (rc.Width()-10)/cols;
	int halfwid=defaultWidth;

 	SetCols (1);
	SetRows (256);
	SetCols (cols+1);

	int i = 0;
	for(/*int*/ i=0; i<rows; i++)
	{
		for(int j=0; j<cols; j++)
		{
			SetText (i, j+1, "");
		}
	}

	COLORREF col1=RGB(0xC8, 0x96, 0x96);
	COLORREF col2=RGB(0x64,0x96,0xC8);
	COLORREF yellow=RGB(255,255,0);
	COLORREF green=RGB(0,255,255);
	for (  i = 0; i < 46; i ++)
		SetBackColor (i, 0, col1);
	SetColWidth ( 0, 10);

	m_datearray.RemoveAll ();
	m_daterowposarray.RemoveAll ();
	int datesize=0;
	int aa=0;
	CString curdate;

	CStringArray typearray;
	CArray<int,int>typecountarray;
	int pos;
	int oldpos;
	for(i=0; i<m_pListArray->GetSize()+datesize; i++)
	{
		if(m_pListArray->ElementAt(aa).ElementAt(12+nAdd)!=curdate && curdate!="")
		{
			//汇总行
			CString str="    今日预约:  ";
			CString temp;
			for(int a=0; a<typearray.GetSize (); a++)
			{
				temp.Format ("%s:%d   ", typearray.ElementAt (a), typecountarray.ElementAt (a));
				str+=temp;
			} 	
			SetText (oldpos, 1, GetText(oldpos, 1)+str );
 
			typearray.RemoveAll ();	typecountarray.RemoveAll ();
		}
		if(::FindArray (&m_datearray, m_pListArray->ElementAt(aa).ElementAt(12+nAdd))==-1)
		{
			curdate=m_pListArray->ElementAt(aa).ElementAt(12+nAdd);
			m_datearray.Add ( curdate );
			m_daterowposarray.Add (i);
			datesize=m_datearray.GetSize ();
			JoinCells (i,1,i,12+nAdd);
			SetAlignment (i,1,DT_CENTER);
			SetBackColor (i,1, green);
			SetText (i, 1, curdate+" "+GetWeek(curdate) );
			oldpos=i;
			continue;
		}
		pos=::FindArray (&typearray, m_pListArray->ElementAt(aa).ElementAt(3+nAdd));
	    if(pos==-1)
		{
			typearray.Add (m_pListArray->ElementAt(aa).ElementAt(3+nAdd));
			typecountarray.Add (1);
		}
		else
		{
			int size=typecountarray.ElementAt (pos);
			typecountarray.SetAt (pos, size+1);
		}

		for(int j=0; j<cols; j++)
		{
			SetText (i, j+1, m_pListArray->ElementAt(aa).ElementAt(j));
			if(j==8+nAdd && atoi(m_pListArray->ElementAt(aa).ElementAt(j))>0 )
			{
				SetBackColor (i,j+1, RGB(255,0,0));
			}
			else if(j==8+nAdd)SetBackColor (i,j+1, RGB(0,255,0));

			if(j==11+nAdd && m_pListArray->ElementAt(aa).ElementAt(j)=="未到" )
			{
				SetBackColor (i,j+1, RGB(255,0,0));
			}
			else if(j==11+nAdd)SetBackColor (i,j+1, RGB(0,255,0));
		}
		aa++;
	}
 
	if(m_pListArray->GetSize())
	{
 			//汇总行
			CString str="    今日预约:  ";
			CString temp;
			for(int a=0; a<typearray.GetSize (); a++)
			{
				temp.Format ("%s:%d   ", typearray.ElementAt (a), typecountarray.ElementAt (a));
				str+=temp;
			} 	
			SetText (oldpos, 1, GetText(oldpos, 1)+str );
	}
    CalRowHeight();
 	return 0;


	JoinCells (3,5,4,6);
	SetText (3,5, "This cell contains multiline text, which provides multiline edit.张三, 李四, 王五Using default font张三, 李四, 王五Using default font");
	SetWordbreak (3,5,true);
return 0;
	JoinCells (3,7,5,8);
	SetText (3,7, "This cell contains multiline text, which provides multiline edit.");
	SetWordbreak (3,7,true);

	SetText (4,1, "You can even edit a long (cell overlapping) string.");
	SetOverlap(4,1,true);

	SetText (4,3, "Test");

	JoinCells (5,1,6,2);
	SetText (5,1, "Enter your name here.");

	JoinCells (5,3,5,4);
	SetText (5,3, "Enter your text here ...");

	JoinCells (8,1,8,8);
	SetBackColor (8,1, RGB(0x64,0x96,0xC8));
	SetText (8,1, "Default edit controls also allow us to customize user's editing experience by:");

	JoinCells (10,1,10,2);
	SetBackColor (10,1, RGB(0xDC,0xC8,0xB4));
	SetText (10,1, "Converting input to upper case:");

	SetText (10,3, "TYPE HERE ...");

	JoinCells (10,5,10,6);
	SetBackColor (10,5, RGB(0xDC,0xC8,0xB4));
	SetText (10,5, "Converting input to lower case:");

	SetText (10,7, "type here ...");

	JoinCells (11,1,11,2);
	SetBackColor (11,1, RGB(0xDC,0xC8,0xB4));
	SetText (11,1, "Allowing password input:");

	SetText (11,3, "*********");

	SetText (11,5, "Entered password was:*********");
	SetOverlap(11,5,true);

	JoinCells (12,1,12,2);
	SetBackColor (12,1, RGB(0xDC,0xC8,0xB4));
	SetText (12,1, "Allowing aligned input:");

	SetText (12,3, "Left aligned");
	SetText (12,5, "Centered");
	SetAlignment (12,5,DT_CENTER);
	SetText (12,7, "Right aligned");
	SetAlignment (12,7,DT_RIGHT);

	JoinCells (14,1,14,8);
	SetBackColor (14,1, RGB(0x64,0x96,0xC8));
	SetText (14,1, "Ultimate Grid allow us to process user's input with various notifications.");

	JoinCells (16,1,16,5);
	SetBackColor (16,1, RGB(0xDC,0xC8,0xB4));
	SetText (16,1, "We can verify data it is entered, for example to limit number of char to 4:");

	SetText (16,6, "<Type here>");

	JoinCells (17,1,17,5);
	SetBackColor (17,1, RGB(0xDC,0xC8,0xB4));
	SetText (17,1, "or that the numeric value entered is under 500 (number < 500):");

	SetText (17,6, "<Type here>");

	JoinCells (18,1,18,5);
	SetBackColor (18,1, RGB(0xDC,0xC8,0xB4));
	SetText (18,1, "We can also test user's input after it is completed, or force user's input:");

	SetText (18,6, "<Type here>");

	JoinCells (20,1,20,8);
	SetBackColor (20,1, RGB(0x64,0x96,0xC8));
	SetText (20,1, "The Ultimate Grid also allows us to use other edit controls when needed:");

	JoinCells (22,1,23,5);
	SetBackColor (22,1, RGB(0xDC,0xC8,0xB4));
	SetText (22,1, "Just by setting a mask on a cell, the grid will change edit controls to use a mask edit. By default Ultimate Grid creates an instance of CUGMEdit to use as mask edit control.");
	SetWordbreak (22,1,true);

	JoinCells (22,6,22,7);
	SetText (22,6, "<Select mask>");
	JoinCells (23,6,23,7);
	SetText (23,6, "<Type here>");

	JoinCells (25,1,27,5);
	SetBackColor (25,1, RGB(0xDC,0xC8,0xB4));
	SetText (25,1, "The Ultimate Grid 5 also comes with a set of advanced edit control previosly only found in Ultimate ToolBox. We can now easily incorporate powerful controls like COXMaskEdit, COXNumericEdit, and COXCurrencyEdit into our applications.");
	SetWordbreak (25,1,true);

	JoinCells (29,1,30,5);
	SetBackColor (29,1, RGB(0xDC,0xC8,0xB4));
	SetText (29,1, "The COXMaskEdit works very similarly to the default mask edit control, to use it just set a mask on a cell and inform the grid that you want to use different edit control.");
	SetWordbreak (29,1,true);

	JoinCells (29,6,29,8);
	SetText (29,6, "<Select mask>");
	JoinCells (30,6,30,8);
	SetText (30,6, "<Type here>");

	JoinCells (32,1,33,5);
	SetBackColor (32,1, RGB(0xDC,0xC8,0xB4));
	SetText (32,1, "The COXNumericEdit and COXCurrencyEdit on the other hand allow us to provide additional setup information that will drive the way the edit control will behave.");
	SetWordbreak (32,1,true);

	JoinCells (35,1,35,2);
	SetBackColor (35,1, RGB(0xDC,0xC8,0xB4));
	SetText (35,1, "Using COXNumericEdit:");

	JoinCells (35,3,35,4);
	SetText (35,3, "<Type here>");

	JoinCells (35,5,35,6);
	SetBackColor (35,5, RGB(0xDC,0xC8,0xB4));
	SetText (35,5, "Using COXCurrencyEdit:");

	JoinCells (35,7,35,8);
	SetText (35,7, "<Type here>");

	JoinCells (36,1,36,3);
	SetBackColor (36,1, RGB(0x64,0x96,0xC8));
	SetText (36,1, "Following are properties we can set.");

	JoinCells (36,5,36,7);
	SetBackColor (36,5, RGB(0x64,0x96,0xC8));
	SetText (36,5, "Following are properties we can set.");

	JoinCells (37,1,37,2);
	SetBackColor (37,1, RGB(0xDC,0xC8,0xB4));
	SetText (37,1, "Decimal digit count :");

	JoinCells (37,5,37,6);
	SetBackColor (37,5, RGB(0xDC,0xC8,0xB4));
	SetText (37,5, "Decimal digit count :");

	JoinCells (38,1,38,2);
	SetBackColor (38,1, RGB(0xDC,0xC8,0xB4));
	SetText (38,1, "Decimal Separator :");

	JoinCells (38,5,38,6);
	SetBackColor (38,5, RGB(0xDC,0xC8,0xB4));
	SetText (38,5, "Decimal Separator :");

	JoinCells (39,1,39,2);
	SetBackColor (39,1, RGB(0xDC,0xC8,0xB4));
	SetText (39,1, "Fractional digit count :");

	JoinCells (39,5,39,6);
	SetBackColor (39,5, RGB(0xDC,0xC8,0xB4));
	SetText (39,5, "Fractional digit count :");

	JoinCells (40,1,40,2);
	SetBackColor (40,1, RGB(0xDC,0xC8,0xB4));
	SetText (40,1, "Group Separator :");

	JoinCells (40,5,40,6);
	SetBackColor (40,5, RGB(0xDC,0xC8,0xB4));
	SetText (40,5, "Group Separator :");

	JoinCells (41,1,41,2);
	SetBackColor (41,1, RGB(0xDC,0xC8,0xB4));
	SetText (41,1, "Digits in group :");

	JoinCells (41,5,41,6);
	SetBackColor (41,5, RGB(0xDC,0xC8,0xB4));
	SetText (41,5, "Digits in group :");

	JoinCells (42,1,42,2);
	SetBackColor (42,1, RGB(0xDC,0xC8,0xB4));
	SetText (42,1, "Negative Format :");

	JoinCells (42,5,42,6);
	SetBackColor (42,5, RGB(0xDC,0xC8,0xB4));
	SetText (42,5, "Positive Format :");

	JoinCells (43,1,43,2);
	SetBackColor (43,1, RGB(0xDC,0xC8,0xB4));
	SetText (43,1, "Show leading zero :");

	JoinCells (43,5,43,6);
	SetBackColor (43,5, RGB(0xDC,0xC8,0xB4));
	SetText (43,5, "Negative Format :");

	JoinCells (44,5,44,6);
	SetBackColor (44,5, RGB(0xDC,0xC8,0xB4));
	SetText (44,5, "Currency name :");

	JoinCells (45,5,45,6);
	SetBackColor (45,5, RGB(0xDC,0xC8,0xB4));
	SetText (45,5, "Show leading zero :");

	return 0;
}

int XTable::Test3()
{
	CStringArray array;

	array.Add ("姓名");
 	array.Add ("电话");
	array.Add ("时间");
	array.Add ("内容");
	array.Add ("价格");
 	array.Add ("摄影");
 	array.Add ("化妆");
 	array.Add ("门市");
 	array.Add ("欠款");
 	array.Add ("备注");
 	array.Add ("录入"); 
	array.Add ("是否到店");
 
 
	int cols=array.GetSize();

	int nAdd=0;
 


	CRect rc;
	GetClientRect(rc);
	defaultWidth = (rc.Width()-10)/cols;
	int halfwid=defaultWidth;

 	SetCols (1);
	SetRows (256);
	SetCols (cols+1);
int i = 0;
	for(/*int*/ i=0; i<rows; i++)
	{
		for(int j=0; j<cols; j++)
		{
			SetText (i, j+1, "");
		}
	}

	COLORREF col1=RGB(0xC8, 0x96, 0x96);
	COLORREF col2=RGB(0x64,0x96,0xC8);
	COLORREF yellow=RGB(255,255,0);
	COLORREF green=RGB(0,255,255);
	for (  i = 0; i < 46; i ++)
		SetBackColor (i, 0, col1);
	SetColWidth ( 0, 10);

	m_datearray.RemoveAll ();
	m_daterowposarray.RemoveAll ();
	int datesize=0;
	int aa=0;
	CString curdate;

	CStringArray typearray;
	CArray<int,int>typecountarray;
	int pos;
	int oldpos;
	for(i=0; i<m_pListArray->GetSize()+datesize; i++)
	{
		if(m_pListArray->ElementAt(aa).ElementAt(12+nAdd)!=curdate && curdate!="")
		{
			//汇总行
			CString str="    今日预约:  ";
			CString temp;
			for(int a=0; a<typearray.GetSize (); a++)
			{
				temp.Format ("%d   ", typecountarray.ElementAt (a));
				str+=temp;
			} 	
			SetText (oldpos, 1, GetText(oldpos, 1)+str );
 
			typearray.RemoveAll ();	typecountarray.RemoveAll ();
		}
		if(::FindArray (&m_datearray, m_pListArray->ElementAt(aa).ElementAt(12+nAdd))==-1)
		{
			curdate=m_pListArray->ElementAt(aa).ElementAt(12+nAdd);
			m_datearray.Add ( curdate );
			m_daterowposarray.Add (i);
			datesize=m_datearray.GetSize ();
			JoinCells (i,1,i,12+nAdd);
			SetAlignment (i,1,DT_CENTER);
			SetBackColor (i,1, green);
			SetText (i, 1, curdate+" "+GetWeek(curdate) );
			oldpos=i;
			continue;
		}
 
	    if(typearray.GetSize()==0)
		{
			typearray.Add ("");
			typecountarray.Add (1);
		}
		else
		{
			int size=typecountarray.ElementAt (0);
			typecountarray.SetAt (0, size+1);
		}

		for(int j=0; j<cols; j++)
		{
			SetText (i, j+1, m_pListArray->ElementAt(aa).ElementAt(j));
			if(j==8+nAdd && atoi(m_pListArray->ElementAt(aa).ElementAt(j))>0 )
			{
				SetBackColor (i,j+1, RGB(255,0,0));
			}
			else if(j==8+nAdd)SetBackColor (i,j+1, RGB(0,255,0));

			if(j==11+nAdd && m_pListArray->ElementAt(aa).ElementAt(j)=="未到" )
			{
				SetBackColor (i,j+1, RGB(255,0,0));
			}
			else if(j==11+nAdd)SetBackColor (i,j+1, RGB(0,255,0));
		}
		aa++;
	}
 
	if(m_pListArray->GetSize())
	{
 			//汇总行
			CString str="    今日预约:  ";
			CString temp;
			for(int a=0; a<typearray.GetSize (); a++)
			{
				temp.Format ("%d   ", typecountarray.ElementAt (a));
				str+=temp;
			} 	
			SetText (oldpos, 1, GetText(oldpos, 1)+str );
	}

    CalRowHeight();
 	return 0;
}
void XTable::ModeChange(int mode)
{
	m_mode=mode;
}

void XTable::AddName(int row, int col, CString str)
{
	CString oldtext=GetText(row,col);
	if(oldtext.IsEmpty ())
	{
		SetText(row,col, str);
		return;
	}
	if(oldtext.Find (str)!=-1)return;
	SetText(row,col, oldtext+","+str);
}
//化妆师

void XTable::HidePrice()
{
	if(m_mode!=4)
	{
#ifdef LKAY_VERSION
	if(IsHasRights2new(31))return;
    for(int i=0; i<	m_pListArray->GetSize (); i++)
	{
		m_pListArray->ElementAt (i).SetAt (1, "***");
		m_pListArray->ElementAt (i).SetAt (4, "***");
	}
#else
	if(IsHasRights2new(31))return;
    for(int i=0; i<	m_pListArray->GetSize (); i++)
	{
		m_pListArray->ElementAt (i).SetAt (1, "***");
		m_pListArray->ElementAt (i).SetAt (4, "***");
	}
#endif
	}
	else
	{
#ifdef LKAY_VERSION
	if(IsHasRights2new(31))return;
    for(int i=0; i<	m_pListArray->GetSize (); i++)
	{
		m_pListArray->ElementAt (i).SetAt (1, "***");
		m_pListArray->ElementAt (i).SetAt (4, "***");
	}
#else
	if(IsHasRights2new(31))return;
    for(int i=0; i<	m_pListArray->GetSize (); i++)
	{
		m_pListArray->ElementAt (i).SetAt (1, "***");
		m_pListArray->ElementAt (i).SetAt (4, "***");
	}
#endif
	}
}