📄 dlgrj.cpp
字号:
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.intVal;
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.intVal;
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.intVal;
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 + -