?? publicquery.cpp
字號:
{softnumber=(char*)(_bstr_t)Holder;
softnumber.TrimRight(" ");}
Holder=Myset->GetCollect ("作者");
if(Holder.vt!=VT_NULL)
{softauthor=(char*)(_bstr_t)Holder;
softauthor.TrimRight(" ");}
Holder=Myset->GetCollect ("軟件類型");
if(Holder.vt!=VT_NULL)
{softtype=(char*)(_bstr_t)Holder;
softtype.TrimRight(" ");}
Holder=Myset->GetCollect ("所屬型號");
if(Holder.vt!=VT_NULL)
{softxinghao=(char*)(_bstr_t)Holder;
softxinghao.TrimRight(" ");}
Holder=Myset->GetCollect ("所屬系統");
if(Holder.vt!=VT_NULL)
{softxitong=(char*)(_bstr_t)Holder;
softxitong.TrimRight(" ");}
Holder=Myset->GetCollect ("軟件功能描述");
if(Holder.vt!=VT_NULL)
{softfunction=(char*)(_bstr_t)Holder;
softfunction.TrimRight(" ");}
Holder=Myset->GetCollect ("入庫時間");
if(Holder.vt!=VT_NULL)
{softdate=(char*)(_bstr_t)Holder;
softdate.TrimRight(" ");}
//判斷格式
for(int i=1;i<6;i++)
{ _variant_t strgeshi=geshi[i];
Holder=Myset->GetCollect (strgeshi);
if(Holder.vt!=VT_NULL)
{mystr=(char*)(_bstr_t)Holder;
mystr.TrimRight(" ");
if(mystr=="在家"){
m_List.InsertItem (j,softname);
m_List.SetItemText (j,1,softauthor);
m_List.SetItemText (j,2,geshi[i]);
m_List.SetItemText (j,3,softtype);
m_List.SetItemText (j,4,softfunction);
m_List.SetItemText (j,5,softxinghao);
m_List.SetItemText (j,6,softxitong);
m_List.SetItemText (j,7,softnumber);
m_List.SetItemText (j,8,softdate);
j++;}
}
//if
}Myset->MoveNext();}
}
void CPublicQuery::FindUserInfo()
{
// TODO: Add your control notification handler code here
InitList();
m_List.SetRedraw (false);
CString mysql;
mysql.Format("SELECT * FROM UserInfo ORDER BY 用戶名");
_bstr_t sql=mysql;
_bstr_t source=m_strSource;
_RecordsetPtr Myset;
Myset.CreateInstance (__uuidof(Recordset));
try{
Myset->Open (sql,source,adOpenDynamic,adLockOptimistic,adCmdText);}
catch(_com_error &e){
AfxMessageBox(e.ErrorMessage ());return;
}
CString str1,mystr;
_variant_t Holder;
int i=0;
while(!Myset->adoEOF ){
Holder=Myset->GetCollect ("用戶名");//
if(Holder.vt!=VT_NULL)
{mystr=(char*)(_bstr_t)Holder;
mystr.TrimRight(" ");
m_List.InsertItem (i,mystr);}
else
m_List.InsertItem (i,"未知用戶名");
Holder=Myset->GetCollect ("姓名");//
if(Holder.vt!=VT_NULL)
{mystr=(char*)(_bstr_t)Holder;
mystr.TrimRight(" ");
m_List.SetItemText (i,1,mystr);}
else
m_List.SetItemText (i,1,"未知姓名");
Holder=Myset->GetCollect ("部門");//
if(Holder.vt!=VT_NULL)
{mystr=(char*)(_bstr_t)Holder;
mystr.TrimRight(" ");
m_List.SetItemText (i,2,mystr);}
else
m_List.SetItemText (i,2,"未知部門");
Holder=Myset->GetCollect ("聯系電話");//
if(Holder.vt!=VT_NULL)
{mystr=(char*)(_bstr_t)Holder;
mystr.TrimRight(" ");
m_List.SetItemText (i,3,mystr);}
else
m_List.SetItemText (i,3,"未知電話");
Holder=Myset->GetCollect ("登記時間");//
if(Holder.vt!=VT_NULL)
{mystr=(char*)(_bstr_t)Holder;
mystr.TrimRight(" ");
m_List.SetItemText (i,4,mystr);}
else
m_List.SetItemText (i,4,"未知日期");
Holder=Myset->GetCollect ("詳細信息");//
if(Holder.vt!=VT_NULL)
{mystr=(char*)(_bstr_t)Holder;
mystr.TrimRight(" ");
m_List.SetItemText (i,5,mystr);}
else
m_List.SetItemText (i,5,"未知信息");
i++;
Myset->MoveNext();
}
Myset->Close();
m_List.SetRedraw (true);
}
void CPublicQuery::FindSoftBorrow()
{
// TODO: Add your control notification handler code here
m_List.DeleteAllItems ();
CString geshi[6];
geshi[1]="軟盤";
geshi[2]="光盤";
geshi[4]="文本";
geshi[3]="硬盤";
geshi[5]="其他";
m_List.SetRedraw (false);
CString mysql,mystr;
mysql.Format("SELECT * FROM SoftDocInfo WHERE (軟盤 <> '在家' and 軟盤 <>'無') or (光盤 <> '在家' and 光盤 <>'無') or (硬盤 <> '在家' and 硬盤<>'無') or (文本 <> '在家' and 文本 <>'無') or (其他 <> '在家' and 其他 <>'無')");
_bstr_t sql=mysql;
_bstr_t source=m_strSource;
_RecordsetPtr Myset;
Myset.CreateInstance (__uuidof(Recordset));
try{
Myset->Open (sql,source,adOpenDynamic,adLockOptimistic,adCmdText);}
catch(_com_error &e){
AfxMessageBox(e.ErrorMessage ());return;
}
_variant_t Holder;
int i=0,j=0;
int Shumu=0;
while(!Myset->adoEOF)//看是否存在紀錄
{Shumu+=1;
Myset->MoveNext ();}
if(Shumu<1)return;
Myset->MoveFirst ();
CString softnumber,softname,softtype,softgeshi,softdate,softauthor;
while(!Myset->adoEOF ){
Holder=Myset->GetCollect ("軟件名稱");
if(Holder.vt!=VT_NULL)
{softname=(char*)(_bstr_t)Holder;
softname.TrimRight(" ");}
else softname="未知軟件";
Holder=Myset->GetCollect ("軟件編號");
if(Holder.vt!=VT_NULL)
{softnumber=(char*)(_bstr_t)Holder;
softnumber.TrimRight(" ");}
else softnumber="未知編號";
Holder=Myset->GetCollect ("作者");
if(Holder.vt!=VT_NULL)
{softauthor=(char*)(_bstr_t)Holder;
softauthor.TrimRight(" ");}
else softauthor="未知作者";
Holder=Myset->GetCollect ("軟件類型");
if(Holder.vt!=VT_NULL)
{softnumber=(char*)(_bstr_t)Holder;
softnumber.TrimRight(" ");}
else softnumber="未知類型";
for(i=1;i<6;i++)
{_variant_t strgeshi=geshi[i];
Holder=Myset->GetCollect (strgeshi);
if(Holder.vt!=VT_NULL)
{mystr=(char*)(_bstr_t)Holder;
mystr.TrimRight(" ");
if(mystr!="在家" && mystr!="無"){
m_List.InsertItem (j,softname);
m_List.SetItemText (j,1,softauthor);
m_List.SetItemText (j,2,geshi[i]);
m_List.SetItemText (j,3,softtype);
m_List.SetItemText (j,4,mystr);
m_List.SetItemText (j,5,softnumber);
j++;}
}}
Myset->MoveNext ();}
m_List.SetRedraw (true);
}
void CPublicQuery::FindAbandonSoft()
{
//((CPublicQuery*)(GetDlgItem(IDC_TAB1)->GetParent()))->ShowWindow(IDC_LIST1,SW_SHOW);//先獲得父窗口指針，在使用它的函數
UpdateData();
m_List.SetRedraw (false);
_RecordsetPtr Myset;
CString sql_,mystr,strSTime,strETime;
if(!((CButton*)GetDlgItem(IDC_CHECK7))->GetCheck())//設置查詢語句
sql_="select * from DiscardSoft";
else
{
strSTime=m_Stime.Format("%Y-%m-%d");
strETime=m_Etime.Format("%Y-%m-%d");
sql_.Format(CString("select * from Discardsoft where 作廢時間 > ") +DATEFMT + CString(" and 作廢時間 < ") +DATEFMT,strSTime,strETime);
}
Myset.CreateInstance (__uuidof(Recordset));
_bstr_t Mysql=sql_;
_bstr_t source=m_strSource;
_variant_t Holder;
try{
Myset->Open (Mysql,source,adOpenDynamic,adLockOptimistic,adCmdText);
}
catch(_com_error &e){
AfxMessageBox(e.ErrorMessage());return;}
int Shumu=0;
while(!Myset->adoEOF)//記錄數
{Shumu+=1;
Myset->MoveNext ();}
if(Shumu<1)return;
Myset->MoveFirst ();
int i=0;
while(!Myset->adoEOF ){
Holder=Myset->GetCollect ("軟件名稱");
if(Holder.vt!=VT_NULL)
{mystr=(char*)(_bstr_t)Holder;
mystr.TrimRight (" ");
m_List.InsertItem (i,mystr);}
else
m_List.InsertItem(i,"未知名稱");
Holder=Myset->GetCollect ("作者");
if(Holder.vt!=VT_NULL)
{mystr=(char*)(_bstr_t)Holder;
mystr.TrimRight (" ");
m_List.SetItemText(i,1,mystr);}
else
m_List.SetItemText(i,1,"未知作者");
Holder=Myset->GetCollect ("格式");
if(Holder.vt!=VT_NULL)
{mystr=(char*)(_bstr_t)Holder;
mystr.TrimRight (" ");
m_List.SetItemText(i,2,mystr);}
else
m_List.SetItemText(i,2,"未知格式");
Holder=Myset->GetCollect ("軟件類型");
if(Holder.vt!=VT_NULL)
{mystr=(char*)(_bstr_t)Holder;
mystr.TrimRight (" ");
m_List.SetItemText(i,3,mystr);}
else
m_List.SetItemText(i,3,"未知類型");
Holder=Myset->GetCollect ("軟件功能描述");
if(Holder.vt!=VT_NULL)
{mystr=(char*)(_bstr_t)Holder;
mystr.TrimRight (" ");
m_List.SetItemText(i,4,mystr);}
else
m_List.SetItemText(i,4,"未知功能");
Holder=Myset->GetCollect ("所屬型號");
if(Holder.vt!=VT_NULL)
{mystr=(char*)(_bstr_t)Holder;
mystr.TrimRight (" ");
m_List.SetItemText(i,5,mystr);}
else
m_List.SetItemText(i,5,"未知型號");
Holder=Myset->GetCollect ("所屬系統");
if(Holder.vt!=VT_NULL)
{mystr=(char*)(_bstr_t)Holder;
mystr.TrimRight (" ");
m_List.SetItemText(i,6,mystr);}
else
m_List.SetItemText(i,6,"未知系統");
Holder=Myset->GetCollect ("軟件編號");
if(Holder.vt!=VT_NULL)
{mystr=(char*)(_bstr_t)Holder;
mystr.TrimRight (" ");
m_List.SetItemText(i,7,mystr);}
else
m_List.SetItemText(i,7,"未知編號");
Holder=Myset->GetCollect ("入庫日期");
if(Holder.vt!=VT_NULL)
{mystr=(char*)(_bstr_t)Holder;
mystr.TrimRight (" ");
m_List.SetItemText(i,8,mystr);}
else
m_List.SetItemText(i,8,"未知日期");
Holder=Myset->GetCollect ("作廢日期");
if(Holder.vt!=VT_NULL)
{mystr=(char*)(_bstr_t)Holder;
mystr.TrimRight (" ");
m_List.SetItemText(i,9,mystr);}
else
m_List.SetItemText(i,9,"未知時間");
i++;
Myset->MoveNext ();
}
m_List.SetRedraw (true);
Invalidate();//重繪窗口
}
void CPublicQuery::FindChatRecord()
{
//((CPublicQuery*)(GetDlgItem(IDC_TAB1)->GetParent()))->ShowWindow(IDC_LIST1,SW_SHOW);//先獲得父窗口指針，在使用它的函數
UpdateData();
m_List.SetRedraw (false);
CString sql_,mystr,strSTime,strETime;
if(!((CButton*)GetDlgItem(IDC_CHECK7))->GetCheck())//設置查詢語句
sql_="select * from ChatInfo";
else
{
strSTime=m_Stime.Format("%Y-%m-%d");
strETime=m_Etime.Format("%Y-%m-%d");
sql_.Format(CString("select * from ChatInfo where 交易時間 > ") +DATEFMT + CString(" and 交易時間 < ") +DATEFMT,strSTime,strETime);
}
_RecordsetPtr Myset;
Myset.CreateInstance (__uuidof(Recordset));
_bstr_t Mysql=sql_;
_bstr_t source=m_strSource;
_variant_t Holder;
try{
Myset->Open (Mysql,source,adOpenDynamic,adLockOptimistic,adCmdText);
}
catch(_com_error &e){
AfxMessageBox(e.ErrorMessage());return;}
int Shumu=0;
while(!Myset->adoEOF)//記錄數
{Shumu+=1;
Myset->MoveNext ();}
if(Shumu<1)return;
Myset->MoveFirst ();
int i=0;
while(!Myset->adoEOF ){
Holder=Myset->GetCollect ("交易編號");
if(Holder.vt!=VT_NULL)
{mystr=(char*)(_bstr_t)Holder;
mystr.TrimRight (" ");
m_List.InsertItem (i,mystr);}
else
m_List.InsertItem(i,"未知編號");
Holder=Myset->GetCollect ("用戶名");
if(Holder.vt!=VT_NULL)
{mystr=(char*)(_bstr_t)Holder;
mystr.TrimRight (" ");
m_List.SetItemText(i,1,mystr);}
else
m_List.SetItemText(i,1,"未知用戶");
Holder=Myset->GetCollect ("交易類別");
if(Holder.vt!=VT_NULL)
{mystr=(char*)(_bstr_t)Holder;
mystr.TrimRight (" ");
m_List.SetItemText(i,2,mystr);}
else
m_List.SetItemText(i,2,"未知類別");
Holder=Myset->GetCollect ("軟件名稱");
if(Holder.vt!=VT_NULL)
{mystr=(char*)(_bstr_t)Holder;
mystr.TrimRight (" ");
m_List.SetItemText(i,3,mystr);}
else
m_List.SetItemText(i,3,"未知名稱");
Holder=Myset->GetCollect ("格式");
if(Holder.vt!=VT_NULL)
{mystr=(char*)(_bstr_t)Holder;
mystr.TrimRight (" ");
m_List.SetItemText(i,4,mystr);}
else
m_List.SetItemText(i,4,"未知格式");
Holder=Myset->GetCollect ("軟件編號");
if(Holder.vt!=VT_NULL)
{mystr=(char*)(_bstr_t)Holder;
mystr.TrimRight (" ");
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -