?? dlgrj.cpp
字號:
m_list.InsertItem(i,"");
if(m_bRj)
m_list.SetItemText(i,0,"銷售日結：");
else
m_list.SetItemText(i,0,"銷售月結：");
m_list.SetItemText(i,1,"銷售商品編號");
m_list.SetItemText(i,2,"銷售商品名稱");
m_list.SetItemText(i,3,"銷售商品數量");
m_list.SetItemText(i,4,"銷售商品金額");
m_list.SetItemText(i,5,"銷售商品利潤");
i++;
_variant_t value;
double je=0,profit=0;
long pzs=0 ,sl=0;
while(!m_runsql.m_recordset->adoEOF)
{
m_list.InsertItem(i,"");
value=m_runsql.m_recordset->GetCollect("yp_id");
if(value.vt!=VT_NULL)
m_list.SetItemText(i,1,(char*)(_bstr_t)value);
value=m_runsql.m_recordset->GetCollect("yp_name");
if(value.vt!=VT_NULL)
m_list.SetItemText(i,2,(char*)(_bstr_t)value);
value=m_runsql.m_recordset->GetCollect("sumsl");
if(value.vt!=VT_NULL)
m_list.SetItemText(i,3,(char*)(_bstr_t)value);
sl=sl+value.dblVal;
value=m_runsql.m_recordset->GetCollect("sumje");
if(value.vt!=VT_NULL)
m_list.SetItemText(i,4,(char*)(_bstr_t)value);
je=je+value.dblVal;
value=m_runsql.m_recordset->GetCollect("profit");
if(value.vt!=VT_NULL)
m_list.SetItemText(i,5,(char*)(_bstr_t)value);
profit=profit+value.dblVal;
i++;pzs++;
m_runsql.m_recordset->MoveNext();
}
m_list.InsertItem(i,"");
CString a;
a.Format("%d",pzs);
m_list.SetItemText(i,0,"匯總：");
a.Format("%d",pzs);
m_list.SetItemText(i,1,a);
m_list.SetItemText(i,2,a);
a.Format("%d",sl);
m_list.SetItemText(i,3,a);
a.Format("%0.2f",je);a+="元";
m_list.SetItemText(i,4,a);
a.Format("%0.2f",profit);a+="元";
m_list.SetItemText(i,5,a);
i++;
return i;
}
int CDlgRj::RefreshRKList(int i)
{
CString sql;
sql=this->PrepareRKSQL();
if(!m_runsql.CheckSQLResult(sql))
{
m_list.SetRedraw(true);
return --i;
}
m_list.InsertItem(i,"");
if(m_bRj)
m_list.SetItemText(i,0,"入庫日結：");
else
m_list.SetItemText(i,0,"入庫月結：");
m_list.SetItemText(i,1,"入庫商品編號");
m_list.SetItemText(i,2,"入庫商品名稱");
m_list.SetItemText(i,3,"入庫商品數量");
m_list.SetItemText(i,4,"入庫商品金額");
i++;
_variant_t value;
double je=0;
long pzs=0 ,sl=0;
while(!m_runsql.m_recordset->adoEOF)
{
m_list.InsertItem(i,"");
value=m_runsql.m_recordset->GetCollect("yp_id");
if(value.vt!=VT_NULL)
m_list.SetItemText(i,1,(char*)(_bstr_t)value);
value=m_runsql.m_recordset->GetCollect("yp_name");
if(value.vt!=VT_NULL)
m_list.SetItemText(i,2,(char*)(_bstr_t)value);
value=m_runsql.m_recordset->GetCollect("sumsl");
if(value.vt!=VT_NULL)
m_list.SetItemText(i,3,(char*)(_bstr_t)value);
sl=sl+value.dblVal;
value=m_runsql.m_recordset->GetCollect("sumje");
if(value.vt!=VT_NULL)
m_list.SetItemText(i,4,(char*)(_bstr_t)value);
je=je+value.dblVal;
i++;pzs++;
m_runsql.m_recordset->MoveNext();
}
m_list.InsertItem(i,"");
CString a;
a.Format("%d",pzs);
m_list.SetItemText(i,0,"匯總：");
a.Format("%d",pzs);a="種數："+a;
m_list.SetItemText(i,1,a);
m_list.SetItemText(i,2,a);
a.Format("%d",sl);a="總數量："+a;
m_list.SetItemText(i,3,a);
a.Format("%f",je);a="總金額："+a;
m_list.SetItemText(i,4,a);
i++;
return i;
}
int CDlgRj::RefreshXSTHList(int i)
{
CString sql;
sql=this->PrepareRKSQL();
if(!m_runsql.CheckSQLResult(sql))
{
m_list.SetRedraw(true);
return --i;
}
m_list.InsertItem(i,"");
if(m_bRj)
m_list.SetItemText(i,0,"銷售退貨日結：");
else
m_list.SetItemText(i,0,"銷售退貨月結：");
m_list.SetItemText(i,1,"銷售退貨商品編號");
m_list.SetItemText(i,2,"銷售退貨商品名稱");
m_list.SetItemText(i,3,"銷售退貨商品數量");
m_list.SetItemText(i,4,"銷售退貨商品金額");
i++;
_variant_t value;
double je=0;
long pzs=0 ,sl=0;
while(!m_runsql.m_recordset->adoEOF)
{
m_list.InsertItem(i,"");
value=m_runsql.m_recordset->GetCollect("yp_id");
if(value.vt!=VT_NULL)
m_list.SetItemText(i,1,(char*)(_bstr_t)value);
value=m_runsql.m_recordset->GetCollect("yp_name");
if(value.vt!=VT_NULL)
m_list.SetItemText(i,2,(char*)(_bstr_t)value);
value=m_runsql.m_recordset->GetCollect("sumsl");
if(value.vt!=VT_NULL)
m_list.SetItemText(i,3,(char*)(_bstr_t)value);
sl=sl+value.dblVal;
value=m_runsql.m_recordset->GetCollect("sumje");
if(value.vt!=VT_NULL)
m_list.SetItemText(i,4,(char*)(_bstr_t)value);
je=je+value.dblVal;
i++;pzs++;
m_runsql.m_recordset->MoveNext();
}
m_list.InsertItem(i,"");
CString a;
a.Format("%d",pzs);
m_list.SetItemText(i,0,"匯總：");
a.Format("%d",pzs);a="種數："+a;
m_list.SetItemText(i,1,a);
m_list.SetItemText(i,2,a);
a.Format("%d",sl);a="總數量："+a;
m_list.SetItemText(i,3,a);
a.Format("%f",je);a="總金額："+a;
m_list.SetItemText(i,4,a);
i++;
return i;
}
int CDlgRj::RefreshRKTHList(int i)
{
CString sql;
sql=this->PrepareRKTHSQL();
if(!m_runsql.CheckSQLResult(sql))
{
m_list.SetRedraw(true);
return --i;
}
m_list.InsertItem(i,"");
if(m_bRj)
m_list.SetItemText(i,0,"入庫退貨日結：");
else
m_list.SetItemText(i,0,"入庫退貨月結：");
m_list.SetItemText(i,1,"入庫退貨商品編號");
m_list.SetItemText(i,2,"入庫退貨商品名稱");
m_list.SetItemText(i,3,"入庫退貨商品數量");
m_list.SetItemText(i,4,"入庫退貨商品金額");
i++;
_variant_t value;
double je=0;
long pzs=0 ,sl=0;
while(!m_runsql.m_recordset->adoEOF)
{
m_list.InsertItem(i,"");
value=m_runsql.m_recordset->GetCollect("yp_id");
if(value.vt!=VT_NULL)
m_list.SetItemText(i,1,(char*)(_bstr_t)value);
value=m_runsql.m_recordset->GetCollect("yp_name");
if(value.vt!=VT_NULL)
m_list.SetItemText(i,2,(char*)(_bstr_t)value);
value=m_runsql.m_recordset->GetCollect("sumsl");
if(value.vt!=VT_NULL)
m_list.SetItemText(i,3,(char*)(_bstr_t)value);
sl=sl+value.dblVal;
value=m_runsql.m_recordset->GetCollect("sumje");
if(value.vt!=VT_NULL)
m_list.SetItemText(i,4,(char*)(_bstr_t)value);
je=je+value.dblVal;
i++;pzs++;
m_runsql.m_recordset->MoveNext();
}
m_list.InsertItem(i,"");
CString a;
a.Format("%d",pzs);
m_list.SetItemText(i,0,"匯總：");
a.Format("%d",pzs);a="種數："+a;
m_list.SetItemText(i,1,a);
m_list.SetItemText(i,2,a);
a.Format("%d",sl);a="總數量："+a;
m_list.SetItemText(i,3,a);
a.Format("%f",je);a="總金額："+a;
m_list.SetItemText(i,4,a);
i++;
return i;
}
void CDlgRj::OnSelendokCombo1()
{
m_iYue=this->m_comboYue.GetCurSel();
if(m_iOldYue==m_iYue)return ;
CString yue;
yue.Format("%d",m_iYue+1);
CString next_yue;
next_yue.Format("%d",m_iYue+2);
CTime t=CTime::GetCurrentTime();
CString y=t.Format("%Y");
if(this->m_iYue==11)
{
int l_y=atoi(y);
l_y++;
CString upy;
upy.Format("%d",l_y);
this->m_strRqUp=upy+'-'+'1'+'-'+'1';
}
else
{
m_strRqUp=y+'-'+next_yue+'-'+'1';
}
m_strRqDown=y+'-'+yue+'-'+'1';
m_iOldYue=m_iYue;
this->RefreshListView(CString(""));
}
//////////////////////////////////////////////////////////////////////
// CDrawJZ Class
//////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////
CDrawJZ::CDrawJZ(CDlgRj* dlg)
{
this->parent=dlg;
m_nColumns=6;
m_iHaveColumnsTitle=0;
m_nSmallTilte=1;
m_piCharsColumns=new int[m_nColumns];
m_piWidthColumns=new int[m_nColumns]; //每列寬度
}
CDrawJZ::~CDrawJZ()
{
}
void CDrawJZ::PrintDlg(CDC* pDC, CPrintInfo* pInfo)
{
m_pOldFont = (CFont*) (pDC->SelectObject(m_pGeneralFont));
CPoint ptLeftCurPos(pInfo->m_rectDraw.TopLeft());
CPoint ptRightCurPos(pInfo->m_rectDraw.right,pInfo->m_rectDraw.top);
ptLeftCurPos.Offset(this->m_iLeftMargin,2*this->m_iLineHeight);
ptRightCurPos.Offset(-this->m_iRightMargin,2*this->m_iLineHeight);
int iCurPage=pInfo->m_nCurPage;
if(iCurPage==pInfo->GetMinPage())
{
ptLeftCurPos.Offset(0,this->m_iLineHeight/4);//開始寫字的起始坐標
CString str;
CSize size;
//左邊一行:
if(parent->m_bRj)
{
parent->m_tcRq.GetWindowText(str);
str="日期: "+str;
}
else
{
parent->m_comboYue.GetWindowText(str);
str="日期: "+str;
}
pDC->TextOut(ptLeftCurPos.x,ptLeftCurPos.y,str);
ptLeftCurPos.Offset(0,m_iLineHeight*3/4);
ptRightCurPos.Offset(0,m_iLineHeight);
}
int n=this->parent->m_list.GetItemCount();
if(n==0) return ;
this->DrawListItems(pDC,iCurPage,ptLeftCurPos,ptRightCurPos,&parent->m_list);
pDC->SelectObject(m_pOldFont);
}
void CDrawJZ::PrintPageHeader(CDC* pDC, CPrintInfo* pInfo)
{
CDrawDlg::PrintPageHeader(pDC,pInfo,(parent->m_bRj)?"日結表":"月結表");
}
void CDlgRj::OnButtonPrint()
{
for(int i=this->m_list.GetItemCount()-1;i>=0;i--)
if(m_list.GetItemText(i,0)==""&&
m_list.GetItemText(i,1)==""&&
m_list.GetItemText(i,2)=="")
{
m_list.DeleteItem(i);
}
if(!::OpenPrintFrame(this,m_draw))
{
MessageBox("打開打印框架錯誤","錯誤！");
}
}
CListCtrl* CDrawJZ::GetListCtrl()
{
return &this->parent->m_list;
}
BOOL CDlgRj::DestroyWindow()
{
delete m_draw;
m_draw=NULL;
return CDialog::DestroyWindow();
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -