房地产售楼系统（VC6+SQL2005）

// MYxs.cpp : implementation file // #include "stdafx.h" #include "房地产售楼系统.h" #include "MYxs.h" #include "Payrecord.h" #include "Salerecord.h" #include "HPrice.h" #include "Edat.h" #ifdef _DEBUG #define new DEBUG_NEW #undef THIS_FILE static char THIS_FILE[] = __FILE__; #endif ///////////////////////////////////////////////////////////////////////////// // CMYxs dialog CMYxs::CMYxs(CWnd* pParent /*=NULL*/) : CDialog(CMYxs::IDD, pParent) { //{{AFX_DATA_INIT(CMYxs) m_houseno1 = _T(""); m_houseno = _T(""); m_customerno = _T(""); m_paymoney = 0.0; m_payno = _T(""); m_workerno = _T(""); m_payday = 0; m_paymonth = 0; m_saleday = 0; m_salemonth = 0; m_saleyear = 0; m_payyear = 0; //}}AFX_DATA_INIT } void CMYxs::DoDataExchange(CDataExchange* pDX) { CDialog::DoDataExchange(pDX); //{{AFX_DATA_MAP(CMYxs) DDX_Text(pDX, IDC_EDIThouseno1, m_houseno1); DDX_Text(pDX, IDC_EDIThouseno, m_houseno); DDX_Text(pDX, IDC_EDITcustomerno, m_customerno); DDX_Text(pDX, IDC_EDITpaymoney, m_paymoney); DDX_Text(pDX, IDC_EDITpayno, m_payno); DDX_Text(pDX, IDC_EDITworkerno1, m_workerno); DDX_Text(pDX, IDC_EDITpayday, m_payday); DDX_Text(pDX, IDC_EDITpaymonth, m_paymonth); DDX_Text(pDX, IDC_EDITsaleday, m_saleday); DDX_Text(pDX, IDC_EDITsalemonth, m_salemonth); DDX_Text(pDX, IDC_EDITsaleyear, m_saleyear); DDX_Text(pDX, IDC_EDITpayyear, m_payyear); //}}AFX_DATA_MAP } BEGIN_MESSAGE_MAP(CMYxs, CDialog) //{{AFX_MSG_MAP(CMYxs) ON_EN_CHANGE(IDC_EDIThouseno, OnChangeEDIThouseno) ON_BN_CLICKED(IDC_BUTTONsaleok, OnBUTTONsaleok) ON_BN_CLICKED(IDC_BUTTONpayok, OnBUTTONpayok) ON_BN_CLICKED(IDC_BUTTONadd, OnBUTTONadd) ON_BN_CLICKED(IDC_BUTTONdel, OnBUTTONdel) ON_BN_CLICKED(IDC_BUTTONadd2, OnBUTTONadd2) ON_BN_CLICKED(IDC_BUTTON6, OnButtonpayupdata) ON_BN_CLICKED(IDC_HOUSEBACK, OnHouseback) ON_BN_CLICKED(IDC_BOTTONUPDATE, OnBottonupdate) //}}AFX_MSG_MAP END_MESSAGE_MAP() ///////////////////////////////////////////////////////////////////////////// // CMYxs message handlers void CMYxs::OnChangeEDIThouseno() { // TODO: If this is a RICHEDIT control, the control will not // send this notification unless you override the CDialog::OnInitDialog() // function and call CRichEditCtrl().SetEventMask() // with the ENM_CHANGE flag ORed into the mask. // TODO: Add your control notification handler code here } void CMYxs::OnBUTTONsaleok() { UpdateData(true); //约束性 if(m_houseno==""||m_workerno==""||m_customerno=="") { MessageBox("输入信息不能为空!","销售管理"); return; } if(m_houseno.GetLength()!=8) { MessageBox("房屋编号应为八位，并且每位都是正整数 ","销售管理"); return; } if(m_workerno.GetLength()!=10) { MessageBox("员工编号应为十位，并且每位都是正整数 ","销售管理"); return; } if(m_customerno.GetLength()!=10) { MessageBox("客户编号应为十位，并且每位都是正整数 ","销售管理"); return; } if(m_saleyear<2000||m_saleyear>2099) { MessageBox("输入信息有误!年份应该在2000年到2099年之间","销售管理"); return; } if(m_salemonth<1||m_salemonth>12) { MessageBox("输入信息有误!月份应该在1月到12月之间","销售管理"); return; } if(m_saleday<1||m_saleday>31) { MessageBox("输入信息有误!日期应该在1到31之间","销售管理"); return; } CSalerecord sale; sale.Open(); CEdat work; work.Open(); work.MoveFirst(); int flag3=0; do { if(work.m_ENO==m_workerno) { flag3=1; break; } work.MoveNext(); }while(!work.IsEOF()); work.Close(); if(flag3==0) { MessageBox("没有该员工编号","销售管理"); return; } int flag1=0; bool flag2; double m_yfmoney; CHPrice p; p.Open(); p.MoveFirst(); do { if(p.m_Rnum==m_houseno) { flag1=1; flag2=p.m_flag; m_yfmoney=p.m_Sum; p.Edit(); p.m_flag=false; p.Update(); } p.MoveNext(); }while(!p.IsEOF()); if(flag1==0) { MessageBox("查无此房，请重新输入房号","销售管理"); return; } if(flag2==false) { MessageBox("此房已出售，请重新输入房号","销售管理"); return; } sale.AddNew(); sale.m_houseno=m_houseno; sale.m_customerno=m_customerno; sale.m_workerno=m_workerno; sale.m_year=m_saleyear; sale.m_month=m_salemonth; sale.m_day=m_saleday; sale.m_money=m_yfmoney; sale.Update(); sale.Close(); MessageBox("销售成功!","窗口收款管理"); } void CMYxs::OnBUTTONpayok() { UpdateData(true); if(m_payno==""||m_houseno1=="") { MessageBox("输入信息不能为空!","销售管理"); } if(m_houseno1.GetLength()!=8) { MessageBox("房屋编号应为八位，并且每位都是正整数 ","销售管理"); return; } if(m_payno.GetLength()!=10) { MessageBox("单据编号应为十位，并且每位都是正整数 ","销售管理"); return; } if(m_payyear<2000||m_payyear>2099) { MessageBox("输入信息有误!年份应该在2000年到2099年之间","销售管理"); return; } if(m_paymonth<1||m_paymonth>12) { MessageBox("输入信息有误!月份应该在1月到12月之间","销售管理"); return; } if(m_payday<1||m_payday>31) { MessageBox("输入信息有误!日期应该在1到31之间","销售管理"); return; } if(m_paymoney<=0) { MessageBox("单据金额应为正数","销售管理"); return; } CSalerecord sale; CPayrecord pay; sale.Open(); pay.Open(); pay.MoveFirst(); do { if(pay.m_payno==m_payno) { MessageBox("该单据号已存在!","销售管理"); pay.Close(); return; } pay.MoveNext(); }while(!pay.IsEOF()); int flag=0; sale.MoveFirst(); do { if(sale.m_houseno==m_houseno1) flag=1; sale.MoveNext(); }while(!sale.IsEOF()); if(flag==0) { MessageBox("销售记录中无此房，请重新输入房号","销售管理"); sale.Close(); pay.Close(); return; } sale.MoveFirst(); double money=0.0; double m_yf=0.0,m_wf=0.0; do { if(sale.m_houseno==m_houseno1) { m_yf=sale.m_money; pay.MoveFirst(); do { if(pay.m_houseno==m_houseno1) money+=pay.m_pay; pay.MoveNext(); }while(!pay.IsEOF()); m_wf=m_yf-money; break; } sale.MoveNext(); }while(!sale.IsEOF()); if(m_paymoney>m_wf) { MessageBox("单据金额应小于该客户未付款额","销售管理"); return; } pay.AddNew(); pay.m_payno=m_payno; pay.m_houseno=m_houseno1; pay.m_year=m_payyear; pay.m_month=m_paymonth; pay.m_day=m_payday; pay.m_pay=m_paymoney; pay.Update(); pay.Close(); sale.Close(); MessageBox("付款成功!","窗口收款管理"); } void CMYxs::OnBUTTONadd() { m_payno=""; m_houseno1=""; m_customerno=""; m_payyear=0; m_paymonth=0; m_payday=0; m_paymoney=0; UpdateData(false); } void CMYxs::OnBUTTONdel() { UpdateData(true); CPayrecord dle; dle.Open(); dle.MoveFirst(); do { if(dle.m_payno==m_payno) { if (MessageBox("确定删除吗？","付款记录",MB_YESNO)==IDNO) { dle.Close(); return; } dle.Delete(); m_payno=""; m_houseno1=""; m_customerno=""; m_payyear=0; m_paymonth=0; m_payday=0; m_paymoney=0; UpdateData(false); dle.Close(); MessageBox("删除成功","付款记录"); return; } dle.MoveNext(); }while(!dle.IsEOF()); dle.Close(); MessageBox("没有该单据编号","付款记录"); } void CMYxs::OnBUTTONadd2() { m_houseno=""; m_customerno=""; m_workerno=""; m_saleyear=0; m_salemonth=0; m_saleday=0; UpdateData(false); } void CMYxs::OnButtonpayupdata() { UpdateData(true); if(m_payno==""||m_houseno1=="") { MessageBox("输入信息不能为空!","销售管理"); return; } if(m_houseno1.GetLength()!=8) { MessageBox("房屋编号应为八位，并且每位都是正整数 ","销售管理"); return; } if(m_payno.GetLength()!=10) { MessageBox("单据编号应为十位，并且每位都是正整数 ","销售管理"); return; } if(m_payyear<2000||m_payyear>2099) { MessageBox("输入信息有误!年份应该在2000年到2099年之间","销售管