?? user.cpp
字號:
// User.cpp : 實現文件
//
#include "stdafx.h"
#include "ProjectManage.h"
#include "User.h"
//CADOStorage
CADOStorage::CADOStorage():CADODataset()
{
this->SetConnection(theApp.m_pDBCon);
}
CADOStorage::~CADOStorage()
{
}
void CADOStorage::ExecInsertSql(CString TblName,CString Fldlist,CString ValueList)
{
CString Sqlstr;
Sqlstr="Insert into "+TblName+" ("+Fldlist+") values("+ValueList+")";
this->ExecSql(Sqlstr);
}
void CADOStorage::ExecUpdateSql(CString TblName,CString UpdateStr,CString Constr)
{
CString Sqlstr;
Sqlstr="UPdate "+TblName+" set "+UpdateStr+" "+Constr;
this->ExecSql(Sqlstr);
}
void CADOStorage::ExceDeleteSql(CString TblName,CString Constr)
{
CString Sqlstr;
Sqlstr="delete from "+TblName+" "+Constr;
this->ExecSql(Sqlstr);
}
// CUser
CUser::CUser()
{
this->m_pStorage=NULL;
this->m_TblName="SysUser";
m_pStorage=new CADOStorage();
ASSERT(this->m_pStorage!=NULL);
this->m_pStorage->OpenSql(this->m_TblName);
}
CUser::~CUser()
{
if (m_pStorage!=NULL)
{
delete m_pStorage;
this->m_pStorage=NULL;
}
this->m_NameList.RemoveAll();
}
void CUser::GetUserNames()
{
CString name;
POSITION p=this->m_NameList.GetHeadPosition();
while(p)
{
delete this->m_NameList.GetNext(p);
}
this->m_NameList.RemoveAll();
this->m_pStorage->MoveFirst();
while(!this->m_pStorage->IsEof())
{
this->m_pStorage->GetFieldValue("UserName",name);
this->m_NameList.AddTail(name);
this->m_pStorage->MoveNext();
}
}
void CEmployee::GetDeptName()
{
CString name;
POSITION p=this->m_DeptList.GetHeadPosition();
/*while(p)
{
delete this->m_DeptList.GetNext(p);
}*/
this->m_DeptList.RemoveAll();
this->m_pStorage->MoveFirst();
while(!this->m_pStorage->IsEof())
{
this->m_pStorage->GetFieldValue("DeptName",name);
this->m_DeptList.AddTail(name);
this->m_pStorage->MoveNext();
}
}
CEmployee::CEmployee()
{
this->m_pStorage=NULL;
this->m_TblName="DeptClass";
m_pStorage=new CADOStorage();
ASSERT(this->m_pStorage!=NULL);
this->m_pStorage->OpenSql(this->m_TblName);
}
CEmployee::~CEmployee()
{
if (m_pStorage!=NULL)
{
delete m_pStorage;
this->m_pStorage=NULL;
}
this->m_DeptList.RemoveAll();
}
void CRegion::GetRegionName(CString FiledName)
{
CString name;
POSITION p=this->m_RegionList.GetHeadPosition();
/*while(p)
{
delete this->m_DeptList.GetNext(p);
}*/
this->m_RegionList.RemoveAll();
this->m_pStorage->MoveFirst();
while(!this->m_pStorage->IsEof())
{
this->m_pStorage->GetFieldValue(FiledName,name);
this->m_RegionList.AddTail(name);
this->m_pStorage->MoveNext();
}
}
CRegion::CRegion()
{
this->m_pStorage=NULL;
this->m_TblName="RegionTRee";
m_pStorage=new CADOStorage();
ASSERT(this->m_pStorage!=NULL);
this->m_pStorage->OpenSql(this->m_TblName,"mod_name","where mod_parent=0");
}
CRegion::~CRegion()
{
if (m_pStorage!=NULL)
{
delete m_pStorage;
this->m_pStorage=NULL;
}
this->m_RegionList.RemoveAll();
}
// CUser 成員函數
bool CUser::Check(CString UserName,CString Password)
{
this->m_pStorage->OpenSql(this->m_TblName,"*","where UserName='"+UserName+"'");
this->m_pStorage->GetFieldValue("password",this->m_Password);
if(this->m_Password.Trim()==Password.Trim())
{
this->m_pStorage->GetFieldValue("UserName",this->m_UserName);
this->m_pStorage->GetFieldValue("limit",this->m_Right);
this->m_LoginDate=CTime::GetCurrentTime();
return true;
}
else
{
return false;
}
}
//CBaseTbl
CBaseTbl::CBaseTbl()
{
this->m_TblName="表說明";
}
CBaseTbl::~CBaseTbl()
{
}
void CBaseTbl::GetTblnames()
{
this->m_TblList.RemoveAll();
this->m_Storage.OpenSql(this->m_TblName,"中文名稱","where 表屬性=0","order by 編號");
this->m_Storage.MoveFirst();
CString name;
while(!this->m_Storage.IsEof())
{
this->m_Storage.GetFieldValue(0,name);
this->m_TblList.AddTail(name);
this->m_Storage.MoveNext();
}
}
bool CBaseTbl::SelectUnionTbl(CString StrTblname,CString& Realtbl,bool ByRealTblName)
{
//1.選擇真是表名
if(!ByRealTblName)
{
this->m_Storage.OpenSql(this->m_TblName,"*","where 中文名稱='"+StrTblname+"'");
this->m_Storage.GetFieldValue("表名稱",Realtbl);
}
else
{
this->m_Storage.OpenSql(this->m_TblName,"*","where 表名稱='"+Realtbl+"'");
}
//2.生成聯合sql語句
CString sqlstr;
bool IsSingleTbl;
this->m_Storage.GetFieldValue("獨立表",IsSingleTbl);
if(IsSingleTbl)
{
sqlstr="select * from "+Realtbl;
}
else
{
CString ExtraTblname=Realtbl;//外部表字符串
CString FTblname;
CString fldname; //字段字符串
CString Dispfldname;
CString MKName,FKName; //主字段,對應字段
CString ConStr; //條件
int FKCount; //外鍵個數
this->m_Storage.GetFieldValue("外鍵個數",FKCount);
sqlstr="select "+Realtbl+".* ";
for(int i=0;i<FKCount;i++)
{
fldname="顯示字段"+IntToStr(i);
this->m_Storage.GetFieldValue(fldname,Dispfldname);
fldname="外部表"+IntToStr(i);
this->m_Storage.GetFieldValue(fldname,FTblname);
fldname="字段"+IntToStr(i);
this->m_Storage.GetFieldValue(fldname,MKName);
fldname="外鍵"+IntToStr(i);
this->m_Storage.GetFieldValue(fldname,FKName);
sqlstr=sqlstr+","+FTblname+"."+Dispfldname+" ";
ExtraTblname+=","+FTblname;
if(i==0)
{
ConStr+=Realtbl+"."+MKName+"="+FTblname+"."+FKName;
}
else
{
ConStr+=" and "+Realtbl+"."+MKName+"="+FTblname+"."+FKName;
}
}
sqlstr+=" from "+ExtraTblname+" where "+ConStr;
}
//3.查詢得出結果
if(!Realtbl.IsEmpty()&&(Realtbl.Trim()!=""))
{
this->m_Storage.Open(sqlstr,CADODataset::openQuery);
return true;
}
else
return false;
}
void CBaseTbl::RefreshList(CListCtrl& List1)
{
if(this->m_Storage.IsOpen())
{
this->m_Storage.FillList(List1);
}
}
bool CBaseTbl::GetFieldRecord(CPtrArray& FieldArray,CString ctblname,CString constr) //單表記錄數組
{
ASSERT(ctblname.Trim()!="");
//1.判斷及清理工作
if (this->m_Storage.IsOpen())
{
this->m_Storage.Close();
}
int ArrayCount=(int)FieldArray.GetSize();
for(int j=0;j<ArrayCount;j++)
{
delete FieldArray.GetAt(j);
}
FieldArray.RemoveAll();
CFieldRecord* fldrec;
CADOFieldInfo fldinfo;
CString fldvalue;
//2.判斷記錄位置
bool IsZeroRecord;//記錄數為0
if(constr.Trim() == "")//添加記錄
{
this->m_Storage.OpenSql(ctblname);
if (this->m_Storage.GetRecordCount()>0)
{
this->m_Storage.MoveLast();
IsZeroRecord=false;
}
else
IsZeroRecord=true;
}
else
{
this->m_Storage.OpenSql(ctblname,"*",constr);
if(this->m_Storage.GetRecordCount()>0)
{
this->m_Storage.MoveFirst();
IsZeroRecord=false;
}
else
{
IsZeroRecord=true;
return false;
}
}
int count=this->m_Storage.GetFieldCount();
//3.添加字段記錄到指針數組
for(int i=0;i<count;i++)
{
fldrec=new CFieldRecord();
if(IsZeroRecord)
{
fldvalue="";
}
else
{
this->m_Storage.GetFieldValue(i,fldvalue);
}
this->m_Storage.GetFieldInfo(i,&fldinfo);
strcpy(fldrec->FKtbl,ctblname);
strcpy(fldrec->FieldName,fldinfo.m_strName);
strcpy(fldrec->Value,fldvalue);
switch(fldinfo.m_nType)
{
case VT_DATE:
fldrec->IsStrType=true;
fldrec->IsBool =false;
break;
case VT_BSTR:
fldrec->IsStrType=true;
fldrec->IsBool =false;
break;
case 202:
fldrec->IsStrType=true;
fldrec->IsBool =false;
break;
case VT_BOOL:
fldrec->IsBool=true;
fldrec->IsStrType=false;
break;
default:
fldrec->IsStrType=false;
fldrec->IsBool =false;
break;
}
fldrec->pFK=NULL;
fldrec->IsVisible=true;
FieldArray.Add(fldrec);
}
//添加外鍵信息
this->AddExtraFieldRecord(FieldArray,ctblname);
return true;
}
bool CBaseTbl::RemoveRecord(int CurRecordPos)
{
if(!this->m_Storage.IsOpen())
{return false;}
ASSERT(CurRecordPos>=0);
if (this->m_Storage.GetRecordCount()>0)
{
this->m_Storage.MoveFirst();
while(CurRecordPos-->0)
{ this->m_Storage.MoveNext();}
}
this->m_Storage.Delete();
return true;
}
void CBaseTbl::ReQuery(CString TblName)
{
this->m_Storage.OpenSql(TblName);
}
void CBaseTbl::ExecSql(CString SqlStr)
{
this->m_Storage.ExecSql(SqlStr);
}
void CBaseTbl::AddExtraFieldRecord(CPtrArray& FieldArray,CString ctblname)
{
CADOStorage mk;
CFieldRecord* fldrec;//外鍵信息指針
CFieldRecord* pMfldrec;//主鍵信息指針
mk.OpenSql("表說明","*","where 表名稱='"+ctblname+"'");
if(mk.GetRecordCount()==0)
{
return ;
}
else
{
bool IsSingleTbl;
mk.GetFieldValue("獨立表",IsSingleTbl);
if(IsSingleTbl)//是獨立表
{
return ;
}
else
{
//添加外鍵列表
int fkcount=0;
mk.GetFieldValue("外鍵個數",fkcount);
CString name,value;//
char a[10];
for(int i=0;i<fkcount;i++)
{ //添加外鍵列表
fldrec=new CFieldRecord();
itoa(i,a,10);
name="外鍵";
name=name+a;
mk.GetFieldValue(name,value);
strcpy(fldrec->FieldName,value);
name="外部表";
name=name+a;
mk.GetFieldValue(name,value);
strcpy(fldrec->FKtbl,value);
name="顯示字段";
name=name+a;
mk.GetFieldValue(name,value);
strcpy(fldrec->DisplayName ,value);
//確定
name="字段";
name=name+a;
mk.GetFieldValue(name,value);
fldrec->pFK=NULL;
//確定主字段,添加到鏈表尾部
for(int j=0;j<FieldArray.GetSize();j++)
{
pMfldrec=(CFieldRecord*)FieldArray.GetAt(j);
if(_stricmp(value,pMfldrec->FieldName)==0)
{
pMfldrec->pFK=fldrec;
break;
}
}
}
}
}
}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -