dmain.cpp

物流综合管理系统

		rst.Open(sSQL,adCmdText);
		if(rst.GetRecordCount()<1)
		{
			nJCXX=1;
			nCKGL=1;
			nYSGL=1;
			nXSGL=1;
			nPSGL=1;
			nXTGL=1;
		}
		else
		{
			nJCXX=atoi(rst.GetFieldValue("基础信息"));
			nCKGL=atoi(rst.GetFieldValue("仓库管理"));
			nYSGL=atoi(rst.GetFieldValue("运输管理"));
			nXSGL=atoi(rst.GetFieldValue("销售管理"));
			nPSGL=atoi(rst.GetFieldValue("配送管理"));
			nXTGL=atoi(rst.GetFieldValue("系统管理"));
		}
		if(pMsg->wParam==VK_F2 && nJCXX!=0)
			PostMessage(WM_COMMAND,IDM_JCXX_HPXXWH);
		if(pMsg->wParam==VK_F3 && nXSGL!=0)
			PostMessage(WM_COMMAND,IDM_XSGL_XSKP);
		if(pMsg->wParam==VK_F4 && nCKGL!=0)
			PostMessage(WM_COMMAND,IDM_CCGL_CKDJ);
		if(pMsg->wParam==VK_F5 && nCKGL!=0)
			PostMessage(WM_COMMAND,IDM_CCGL_RKDJ);
		if(pMsg->wParam==VK_F6 && nCKGL!=0)
			PostMessage(WM_COMMAND,IDM_CCGL_CCZBB);
		if(pMsg->wParam==VK_F7 && nPSGL!=0)
			PostMessage(WM_COMMAND,IDM_PSGL_PSSQ);
		if(pMsg->wParam==VK_F8 && nPSGL!=0)
			PostMessage(WM_COMMAND,IDM_PSGL_ZTFK);
		if(pMsg->wParam==VK_F9)
			PostMessage(WM_COMMAND,IDM_YSGL_HCQRGL);
		if(pMsg->wParam==VK_F11 && nXTGL!=0)
			PostMessage(WM_COMMAND,IDM_SJGL_SJBF);
		if(pMsg->wParam==VK_F12)
			PostMessage(WM_COMMAND,IDM_ZYPX_SPJZ);
	}
	return CDialog::PreTranslateMessage(pMsg);
}

void CDMain::OnJcxxWldw() 
{
	CString sSQL;
	sSQL.Format("SELECT * FROM 往来单位信息表");
	CDBaseQuery dlg("往来单位信息查询",sSQL,"编号",2);
	dlg.DoModal();
}
void CDMain::OnJcxxHpxxwh() 
{
	CString sSQL;
	sSQL.Format("SELECT * FROM 商品信息表");
	CDBaseQuery dlg("商品信息查询",sSQL,"编号",1);
	dlg.DoModal();
}

void CDMain::OnJcxxCkxx() 
{
	CString sSQL;
	sSQL.Format("SELECT * FROM 仓库信息表");
	CDBaseQuery dlg("仓库信息查询",sSQL,"编号",1);
	dlg.DoModal();
}

void CDMain::OnJcxxYgxx() 
{
	CString sSQL;
	sSQL.Format("SELECT * FROM 员工信息表");
	CDBaseQuery dlg("员工信息查询",sSQL,"编号",1);
	dlg.DoModal();
	
}

void CDMain::OnXsglXskp() 
{
	CDSell dlg;
	dlg.DoModal();
}

void CDMain::OnXsglXsjk() 
{
	CDCheck dlg;
	dlg.SetCaption("销售结款");
	dlg.DoModal();
	
}

void CDMain::OnXsglKpcx() 
{
	SellQuery dlg;
	dlg.DoModal();
}

void CDMain::OnXsglJkcx() 
{
	CDCheckQuery dlg;
	dlg.DoModal();
	
}

void CDMain::OnXsglWfkcx() 
{
	NoPayQuery	dlg;
	dlg.DoModal();
}

void CDMain::OnCcglRkdj() 
{

	CDInput dlg;
	dlg.DoModal();
}

void CDMain::OnCcglCkdj() 
{
	CDOutPut	dlg;
	dlg.DoModal();
	
}

void CDMain::OnCcglCksh() 
{
	COutPutAuditing	dlg;
	dlg.DoModal();
}

void CDMain::OnCcglRksh() 
{
	CInPutAuditing	dlg;
	dlg.DoModal();
	
}

void CDMain::OnCcglCkhzcx() 
{
	COutPutQuery dlg;
	dlg.DoModal();
}

void CDMain::OnCcglRkhzcx() 
{
	CInputQuery	dlg;
	dlg.DoModal();
}

void CDMain::OnCcglCkzbb() 
{
	CDOutPutReport dlg;
	dlg.DoModal();
}

void CDMain::OnCcglRkzbb() 
{
	CInputReport dlg;
	dlg.DoModal();
}

void CDMain::OnCcglKccx() 
{
	CString sSQL;
	sSQL.Format("SELECT b.条形码,b.名称,b.规格,b.产地 ,c.仓库名称,str(货位_排)+'-'+Ltrim(str(货位_号)) AS 货位,库存数量,库存上限,库存下限 FROM 库存信息表 a INNER JOIN 商品信息表 b ON a.商品条形码=b.条形码 inner join 仓库信息表 c ON a.仓库编号=c.编号 ");
	CStoreQuery	dlg("库存查询",sSQL,"",0);
	dlg.DoModal();
}

void CDMain::OnCcglKcpd() 
{
	CDInventory	dlg;
	dlg.DoModal();
}

void CDMain::OnCcglKnyd() 
{
	CDAdjust dlg;
	dlg.DoModal();
}
void CDMain::OnCcglCczbb() 
{
	CDStoreReport dlg;
	dlg.DoModal();
}
void CDMain::OnPaint() 
{
	CPaintDC dc(this); // device context for painting
	
	//根据分辩率画背景
	CBitmap bit;
	CDC memDC;
	CRect rect;
	this->GetClientRect(&rect);
	int xpos=::GetSystemMetrics(SM_CXSCREEN);
	if(xpos==1024)
		bit.LoadBitmap(IDB_BLK_BIG);
	else
		bit.LoadBitmap(IDB_BLK_SML);
	memDC.CreateCompatibleDC(&dc);
	memDC.SelectObject(&bit);
	dc.BitBlt(0,55,rect.Width(),rect.Height(),&memDC,0,0,SRCCOPY);
	memDC.DeleteDC();
	::DeleteObject(&bit);	
	// Do not call CDialog::OnPaint() for painting messages
}



void CDMain::OnPsglPssq() 
{
	CDDelever dlg;
	dlg.DoModal();
}

void CDMain::OnPsglPssh() 
{
	CDDelverAuditing dlg;
	dlg.DoModal();
}

void CDMain::OnPsglShpj() 
{
	CString sSQL;
	sSQL.Format("SELECT * FROM 配送反馈信息表");
	CDBaseQuery dlg("配送反馈信息查询",sSQL,"编号",1);
	dlg.DoModal();

}


void CDMain::OnPsglZtfk() 
{
	CDWay dlg;
	dlg.DoModal();
}

void CDMain::OnPsglPscx() 
{
	CDDeleverQuery dlg;
	dlg.DoModal();

}
void CDMain::OnPsglZtfkcx() 
{
	CString sSQL;
	sSQL.Format("SELECT b.姓名 AS 驾驶员,a.反馈时间,a.反馈内容 FROM 在途反馈表 a  INNER JOIN 驾驶员信息表 b ON a.司机编号=b.编号 ");
	CStoreQuery	dlg("在途反馈查询",sSQL,"",0);
	dlg.DoModal();	
}

void CDMain::OnYsglHcqrgl() 
{
	CDCarBack dlg;
	dlg.DoModal();
}
void CDMain::OnYsglClzlwh() 
{
	CString sSQL;
	sSQL.Format("SELECT 编号,车辆类型,车型,生产厂牌,主车牌照,载重吨位,年检日期,批准文号,发证日期 FROM 车辆信息表");
	CDBaseQuery dlg("车辆信息查询",sSQL,"编号",1);
	dlg.DoModal();
}

void CDMain::OnYsglJsygl() 
{
	CString sSQL;
	sSQL.Format("SELECT 编号,姓名,性别,出生日期,身份证号,家庭住址,电话,驾驶证号,技术等级,准驾车型,审证日期,备注 FROM 驾驶员信息表");
	CDBaseQuery dlg("驾驶员信息查询",sSQL,"编号",1);
	dlg.DoModal();	
}

void CDMain::OnBgglBaqd() 
{
	CDCustoms dlg(0);
	dlg.DoModal();
	
}

void CDMain::OnJcglCkph() 
{
	CDOutPutTotalReport dlg;
	dlg.DoModal();
	
}

void CDMain::OnJcglKhxydfx() 
{
	CDCreditReport dlg;
	dlg.DoModal();

}

void CDMain::OnJcglRkph() 
{
	CDInPutReport dlg;
	dlg.DoModal();
}

void CDMain::OnJcglYsgzlfx() 
{
	CDWorkload dlg;
	dlg.DoModal();	
}

void CDMain::OnSjglsjbf()
{
	CDBack dlg;
	dlg.DoModal();
}

void CDMain::OnSjglsjhf()
{
	CDRestore dlg;
	dlg.DoModal();
}

void CDMain::OnXtglxtcsh()
{
	CDFormat dlg;
	dlg.DoModal();
}

void CDMain::OnXtglczygl()
{
	CString sSQL;
	sSQL.Format("SELECT * FROM 操作员信息表 WHERE 操作员编号!=1");
	CDBaseQuery dlg("操作员信息查询",sSQL,"操作员编号",1);
	dlg.DoModal();
}

void CDMain::OnXtglgssz()
{
	CDCompany dlg;
	dlg.DoModal();
}

void CDMain::OnBgglbgdgl()
{
	CDCustoms dlg(1);
	dlg.DoModal();

}
void CDMain::OnBgglbgdsh()
{
	CDCustomsAuditing dlg;
	dlg.DoModal();

}
void CDMain::OnBgglsjgl()
{
	CDExamine dlg;
	dlg.DoModal();

}
void CDMain::OnBgglcyagl()
{
	CDExamine_cy dlg;
	dlg.DoModal();
}
void CDMain::OnBggltggl()
{
	CDPass dlg;
	dlg.DoModal();
}
void CDMain::OnBgglbggcjk()
{
	CDSuperVisory dlg;
	dlg.DoModal();
}
void CDMain::OnZcRjzc()
{
	CDialog::OnCancel();
	CDRegedit dlg;
	dlg.DoModal();
}
void CDMain::OnZypxspjz()
{
	ShellExecute(NULL, "open", "RXMediaPlayer.exe", NULL, NULL, SW_SHOWNORMAL);
}
void CDMain::Onxtglqxgl()
{
	CDCurView dlg;
	dlg.DoModal();
}
void CDMain::OnXsglwfkjk()
{
	CDPay dlg;
	dlg.DoModal();

}

void CDMain::OnYsglPcdxick() 
{
	CDWriteIC	dlg;
	dlg.DoModal();
}