影院售票dlg.cpp

影院前台售票系统、模拟电影院的功能

	else
	{
	 pDC->SetTextColor(RGB(0,50,18));
	}
	pDC->TextOut(100,120,"13");
    if((atoi)(Seat14)!=0)
	{
	 pDC->SetTextColor(RGB(255,50,18));
	}
	else
	{
	 pDC->SetTextColor(RGB(0,50,18));
	}
	
	pDC->TextOut(140,120,"14");
	if((atoi)(Seat15)!=0)
	{
	 pDC->SetTextColor(RGB(255,50,18));
	}
	else
	{
	 pDC->SetTextColor(RGB(0,50,18));
	}
	pDC->TextOut(180,120,"15");
    if((atoi)(Seat16)!=0)
	{
	 pDC->SetTextColor(RGB(255,50,18));
	}
	else
	{
	 pDC->SetTextColor(RGB(0,50,18));
	}

	pDC->TextOut(20,170,"16");
	
	if((atoi)(Seat17)!=0)
	{
	 pDC->SetTextColor(RGB(255,50,18));
	}
	else
	{
	 pDC->SetTextColor(RGB(0,50,18));
	}
	
	pDC->TextOut(60,170,"18");
    if((atoi)(Seat5)!=0)
	{
	 pDC->SetTextColor(RGB(255,50,18));
	}
	else
	{
	 pDC->SetTextColor(RGB(0,50,18));
	}

	pDC->TextOut(100,170,"18");
	
	if((atoi)(Seat19)!=0)
	{
	 pDC->SetTextColor(RGB(255,50,18));
	}
	else
	{
	 pDC->SetTextColor(RGB(0,50,18));
	}
	pDC->TextOut(140,170,"19");
	
	if((atoi)(Seat20)!=0)
	{
	 pDC->SetTextColor(RGB(255,50,18));
	}
	else
	{
	 pDC->SetTextColor(RGB(0,50,18));
	}
	pDC->TextOut(180,170,"20");

    if((atoi)(Seat21)!=0)
	{
	 pDC->SetTextColor(RGB(255,50,18));
	}
	else
	{
	 pDC->SetTextColor(RGB(0,50,18));
	}
	pDC->TextOut(20,120,"21");
	
	
	if((atoi)(Seat22)!=0)
	{
	 pDC->SetTextColor(RGB(255,50,18));
	}
	else
	{
	 pDC->SetTextColor(RGB(0,50,18));
	}
	pDC->TextOut(60,120,"22");

	if((atoi)(Seat23)!=0)
	{
	 pDC->SetTextColor(RGB(255,50,18));
	}
	else
	{
	 pDC->SetTextColor(RGB(0,50,18));
	}
	pDC->TextOut(100,120,"23");
	if((atoi)(Seat24)!=0)
	{
	 pDC->SetTextColor(RGB(255,50,18));
	}
	else
	{
	 pDC->SetTextColor(RGB(0,50,18));
	}
	
	pDC->TextOut(140,120,"24");
	if((atoi)(Seat25)!=0)
	{
	 pDC->SetTextColor(RGB(255,50,18));
	}
	else
	{
	 pDC->SetTextColor(RGB(0,50,18));
	}
	
	pDC->TextOut(180,120,"26");
  	if((atoi)(Seat26)!=0)
	{
	 pDC->SetTextColor(RGB(255,50,18));
	}
	else
	{
	 pDC->SetTextColor(RGB(0,50,18));
	}  


	pDC->TextOut(20,170,"26");
    
	if((atoi)(Seat27)!=0)
	{
	 pDC->SetTextColor(RGB(255,50,18));
	}
	else
	{
	 pDC->SetTextColor(RGB(0,50,18));
	}
	
	
	pDC->TextOut(60,170,"27");
	
	if((atoi)(Seat28)!=0)
	{
	 pDC->SetTextColor(RGB(255,50,18));
	}
	else
	{
	 pDC->SetTextColor(RGB(0,50,18));
	}
	
	pDC->TextOut(100,170,"28");
	if((atoi)(Seat29)!=0)
	{
	 pDC->SetTextColor(RGB(255,50,18));
	}
	else
	{
	 pDC->SetTextColor(RGB(0,50,18));
	}
	
	
	pDC->TextOut(140,170,"29");
	
	if((atoi)(Seat30)!=0)
	{
	 pDC->SetTextColor(RGB(255,50,18));
	}
	else
	{
	 pDC->SetTextColor(RGB(0,50,18));
	}
	
	pDC->TextOut(180,170,"30");
    
    pDC->SetTextColor(RGB(150,150,180));
	
	pDC->TextOut(20,280,"放映大厅  一 ");
	/*
	pDC->TextOut(10,10,ss_day);
	pDC->TextOut(10,50,ss_mouth);
	pDC->TextOut(10,10,str);
	*/
	
	m_font.DeleteObject();
	if (IsIconic())
	{
		CPaintDC dc(this); // device context for painting
		
		SendMessage(WM_ICONERASEBKGND, (WPARAM) dc.GetSafeHdc(), 0);
		
		// Center icon in client rectangle
		int cxIcon = GetSystemMetrics(SM_CXICON);
		int cyIcon = GetSystemMetrics(SM_CYICON);
		CRect rect;
		GetClientRect(&rect);
		int x = (rect.Width() - cxIcon + 1) / 2;
		int y = (rect.Height() - cyIcon + 1) / 2;
		
		// Draw the icon
		dc.DrawIcon(x, y, m_hIcon);
		
	}
	else
	{
		CDialog::OnPaint();
	}
}

// The system calls this to obtain the cursor to display while the user drags
//  the minimized window.
HCURSOR CMyDlg::OnQueryDragIcon()
{
	return (HCURSOR) m_hIcon;
}

//void CMyDlg::OnCncel() 
//{
// TODO: Add your control notification handler code here

//}

void CMyDlg::OnCancel() 
{
	// TODO: Add extra cleanup here
	CDialog::OnCancel();
}

void CMyDlg::OnSellButton() 
{
	// TODO: Add your control notification handler code here
	CString mouth;
	CString day;
	CString film;
	CString date="";
	int i_day,i_mouth;
	GetDlgItem(IDC_MOUTH_COMBO)->GetWindowText(mouth);
	GetDlgItem(IDC_DAY_COMBO)->GetWindowText(day);
	GetDlgItem(IDC_EDIT_NAME)->GetWindowText(film);
	i_day=atoi(day);
	i_mouth=atoi(mouth);
	date=mouth;
	date+=day;	
    ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	CString cSQL;
	cSQL.Format("select *from sell where (Film_day = %d and Film_mouth = %d and Film_name = '%s')",i_day,i_mouth,film);
	
	_bstr_t vSQL;
	vSQL=(_bstr_t)cSQL;
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	CString Field,Sell_num;
	CString Seat1,Seat2,Seat3,Seat4,Seat5,Seat6,Seat7,Seat8,Seat9,Seat10;
	CString Seat11,Seat12,Seat13,Seat14,Seat15,Seat16,Seat17,Seat18,Seat19,Seat20;
	CString Seat21,Seat22,Seat23,Seat24,Seat25,Seat26,Seat27,Seat28,Seat29,Seat30;
	CString Seat31,Seat32,Seat33,Seat34,Seat35,Seat36,Seat37,Seat38,Seat39,Seat40;
	CString Seat41,Seat42,Seat43,Seat44,Seat45,Seat46,Seat47,Seat48,Seat49,Seat50;
	CString Seat51,Seat52,Seat53,Seat54,Seat55,Seat56,Seat57,Seat58,Seat59,Seat60;
	if(!m_pRecordset->adoEOF)
	{
		Seat1 =  (CString)(char *)(_bstr_t)m_pRecordset->GetCollect("seat1");
		Seat2 =  (CString)(char *)(_bstr_t)m_pRecordset->GetCollect("seat2");
		Seat3 =  (CString)(char *)(_bstr_t)m_pRecordset->GetCollect("seat3");
		Seat4 =  (CString)(char *)(_bstr_t)m_pRecordset->GetCollect("seat4");
		Seat5 =  (CString)(char *)(_bstr_t)m_pRecordset->GetCollect("seat5");
		Seat6 =  (CString)(char *)(_bstr_t)m_pRecordset->GetCollect("seat6");
		Seat7 =  (CString)(char *)(_bstr_t)m_pRecordset->GetCollect("seat7");
		Seat8 =  (CString)(char *)(_bstr_t)m_pRecordset->GetCollect("seat8");
		Seat9 =  (CString)(char *)(_bstr_t)m_pRecordset->GetCollect("seat9");
		Seat10 = (CString)(char *)(_bstr_t)m_pRecordset->GetCollect("seat10");
		Seat11 = (CString)(char *)(_bstr_t)m_pRecordset->GetCollect("seat11");
		Seat12 = (CString)(char *)(_bstr_t)m_pRecordset->GetCollect("seat12");
		Seat13=  (CString)(char *)(_bstr_t)m_pRecordset->GetCollect("seat13");
		Seat14 = (CString)(char *)(_bstr_t)m_pRecordset->GetCollect("seat14");
		Seat15 = (CString)(char *)(_bstr_t)m_pRecordset->GetCollect("seat15");
		Seat16 = (CString)(char *)(_bstr_t)m_pRecordset->GetCollect("seat16");
		Seat17 = (CString)(char *)(_bstr_t)m_pRecordset->GetCollect("seat17");
		Seat18 = (CString)(char *)(_bstr_t)m_pRecordset->GetCollect("seat18");
		Seat19 = (CString)(char *)(_bstr_t)m_pRecordset->GetCollect("seat19");
		Seat20 = (CString)(char *)(_bstr_t)m_pRecordset->GetCollect("seat20");
		Seat21 = (CString)(char *)(_bstr_t)m_pRecordset->GetCollect("seat21");
		Seat22 = (CString)(char *)(_bstr_t)m_pRecordset->GetCollect("seat22");
		Seat23 = (CString)(char *)(_bstr_t)m_pRecordset->GetCollect("seat23");
		Seat24 = (CString)(char *)(_bstr_t)m_pRecordset->GetCollect("seat24");
		Seat25 = (CString)(char *)(_bstr_t)m_pRecordset->GetCollect("seat25");
		Seat26 = (CString)(char *)(_bstr_t)m_pRecordset->GetCollect("seat26");
		Seat27 = (CString)(char *)(_bstr_t)m_pRecordset->GetCollect("seat27");
		Seat28 = (CString)(char *)(_bstr_t)m_pRecordset->GetCollect("seat28");
		Seat29 = (CString)(char *)(_bstr_t)m_pRecordset->GetCollect("seat29");
		Seat30 = (CString)(char *)(_bstr_t)m_pRecordset->GetCollect("seat30");
		Field =  (CString)(char *)(_bstr_t)m_pRecordset->GetCollect("Film_field");
		Sell_num =  (CString)(char *)(_bstr_t)m_pRecordset->GetCollect("sell_num");
		
	}
	else
	{
		MessageBox("数据库中没有相应时间相应影片信息");
		return;
	}
	int num;
	num = atoi(Sell_num);
	if(num>=30)
	{
		MessageBox("电影票已经全部售完，请选择其它时间或者其它电影");
		return;
	}
	else
	{
		s_film=film;
		s_day=i_day;
		s_mouth=i_mouth;
		s_num=++num;
		CString cuSQL;
		switch(s_num)
		{
		case 1: cuSQL.Format("UPDATE sell set sell_num = %d, seat1 = 1  where (Film_day = %d and Film_mouth = %d and Film_name = '%s') ",s_num,i_day,i_mouth,film); break;
		case 2: cuSQL.Format("UPDATE sell set sell_num = %d, seat2 = 1  where (Film_day = %d and Film_mouth = %d and Film_name = '%s') ",s_num,i_day,i_mouth,film); break;
		case 3: cuSQL.Format("UPDATE sell set sell_num = %d, seat3 = 1  where (Film_day = %d and Film_mouth = %d and Film_name = '%s') ",s_num,i_day,i_mouth,film); break;
		case 4: cuSQL.Format("UPDATE sell set sell_num = %d, seat4 = 1  where (Film_day = %d and Film_mouth = %d and Film_name = '%s') ",s_num,i_day,i_mouth,film); break;
		case 5: cuSQL.Format("UPDATE sell set sell_num = %d, seat5 = 1  where (Film_day = %d and Film_mouth = %d and Film_name = '%s') ",s_num,i_day,i_mouth,film); break;
		case 6: cuSQL.Format("UPDATE sell set sell_num = %d, seat6 = 1  where (Film_day = %d and Film_mouth = %d and Film_name = '%s') ",s_num,i_day,i_mouth,film); break;
		case 7: cuSQL.Format("UPDATE sell set sell_num = %d, seat7 = 1  where (Film_day = %d and Film_mouth = %d and Film_name = '%s') ",s_num,i_day,i_mouth,film); break;
		case 8: cuSQL.Format("UPDATE sell set sell_num = %d, seat8 = 1  where (Film_day = %d and Film_mouth = %d and Film_name = '%s') ",s_num,i_day,i_mouth,film); break;
		case 9: cuSQL.Format("UPDATE sell set sell_num = %d, seat9 = 1  where (Film_day = %d and Film_mouth = %d and Film_name = '%s') ",s_num,i_day,i_mouth,film); break;
		case 10: cuSQL.Format("UPDATE sell set sell_num = %d, seat10 = 1  where (Film_day = %d and Film_mouth = %d and Film_name = '%s') ",s_num,i_day,i_mouth,film); break;
		case 11: cuSQL.Format("UPDATE sell set sell_num = %d, seat11 = 1  where (Film_day = %d and Film_mouth = %d and Film_name = '%s') ",s_num,i_day,i_mouth,film); break;
		case 12: cuSQL.Format("UPDATE sell set sell_num = %d, seat12 = 1  where (Film_day = %d and Film_mouth = %d and Film_name = '%s') ",s_num,i_day,i_mouth,film); break;
		case 13: cuSQL.Format("UPDATE sell set sell_num = %d, seat13 = 1  where (Film_day = %d and Film_mouth = %d and Film_name = '%s') ",s_num,i_day,i_mouth,film); break;
		case 14: cuSQL.Format("UPDATE sell set sell_num = %d, seat14 = 1  where (Film_day = %d and Film_mouth = %d and Film_name = '%s') ",s_num,i_day,i_mouth,film); break;
		case 15: cuSQL.Format("UPDATE sell set sell_num = %d, seat15 = 1  where (Film_day = %d and Film_mouth = %d and Film_name = '%s') ",s_num,i_day,i_mouth,film); break;
		case 16: cuSQL.Format("UPDATE sell set sell_num = %d, seat16 = 1  where (Film_day = %d and Film_mouth = %d and Film_name = '%s') ",s_num,i_day,i_mouth,film); break;
		case 17: cuSQL.Format("UPDATE sell set sell_num = %d, seat17 = 1  where (Film_day = %d and Film_mouth = %d and Film_name = '%s') ",s_num,i_day,i_mouth,film); break;
		case 18: cuSQL.Format("UPDATE sell set sell_num = %d, seat18 = 1  where (Film_day = %d and Film_mouth = %d and Film_name = '%s') ",s_num,i_day,i_mouth,film); break;
		case 19: cuSQL.Format("UPDATE sell set sell_num = %d, seat19 = 1  where (Film_day = %d and Film_mouth = %d and Film_name = '%s') ",s_num,i_day,i_mouth,film); break;
		case 20: cuSQL.Format("UPDATE sell set sell_num = %d, seat20 = 1  where (Film_day = %d and Film_mouth = %d and Film_name = '%s') ",s_num,i_day,i_mouth,film); break;
		case 21: cuSQL.Format("UPDATE sell set sell_num = %d, seat21 = 1  where (Film_day = %d and Film_mouth = %d and Film_name = '%s') ",s_num,i_day,i_mouth,film); break;
		case 22: cuSQL.Format("UPDATE sell set sell_num = %d, seat22 = 1  where (Film_day = %d and Film_mouth = %d and Film_name = '%s') ",s_num,i_day,i_mouth,film); break;
		case 23: cuSQL.Format("UPDATE sell set sell_num = %d, seat23 = 1  where (Film_day = %d and Film_mouth = %d and Film_name = '%s') ",s_num,i_day,i_mouth,film); break;
		case 24: cuSQL.Format("UPDATE sell set sell_num = %d, seat24 = 1  where (Film_day = %d and Film_mouth = %d and Film_name = '%s') ",s_num,i_day,i_mouth,film); break;
		case 25: cuSQL.Format("UPDATE sell set sell_num = %d, seat25 = 1  where (Film_day = %d and Film_mouth = %d and Film_name = '%s') ",s_num,i_day,i_mouth,film); break;
		case 26: cuSQL.Format("UPDATE sell set sell_num = %d, seat26 = 1  where (Film_day = %d and Film_mouth = %d and Film_name = '%s') ",s_num,i_day,i_mouth,film); break;
		case 27: cuSQL.Format("UPDATE sell set sell_num = %d, seat27 = 1  where (Film_day = %d and Film_mouth = %d and Film_name = '%s') ",s_num,i_day,i_mouth,film); break;
		case 28: cuSQL.Format("UPDATE sell set sell_num = %d, seat28 = 1  where (Film_day = %d and Film_mouth = %d and Film_name = '%s') ",s_num,i_day,i_mouth,film); break;
		case 29: cuSQL.Format("UPDATE sell set sell_num = %d, seat29 = 1  where (Film_day = %d and Film_mouth = %d and Film_name = '%s') ",s_num,i_day,i_mouth,film); break;
		case 30: cuSQL.Format("UPDATE sell set sell_num = %d, seat30 = 1  where (Film_day = %d and Film_mouth = %d and Film_name = '%s') ",s_num,i_day,i_mouth,film); break;    		   		   		     		                          
		}
		m_AdoConn.ExecuteSQL((_bstr_t)cuSQL);
		OnPaint();
	}
	m_AdoConn.ExitConnect();
}

void CMyDlg::OnChangeEditName() 
{
	// 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
	UpdateData(TRUE);
	CString vSQL;
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//m_AdoConn.ExecuteSQL((_bstr_t)vSQL);
    vSQL.Format("SELECT *FROM Film WHERE Film_name = '%s'",m_Name);
	//	AfxMessageBox(vSQL);
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet((_bstr_t)vSQL);
	CString str="",temp,temp1,temp2;
	if (!m_pRecordset->adoEOF)
	{
		temp=(CString)(char*)((_bstr_t)m_pRecordset->GetCollect("Film_type"));
		GetDlgItem(IDC_EDIT_TYPE)->SetWindowText(temp);
	}
    
}

void CMyDlg::OnHejiButton() 
{
	// TODO: Add your control notification handler code here
	CString str;
	GetDlgItem(IDC_EDIT1)->GetWindowText(str);
	if(str=="")
	{
	 MessageBox("请输入座位号");
	 return;
	}
	if((atoi)(str)>30)
	{
	 MessageBox("输入错误");
	 return;
	}
	if((atoi)(str)<=10)
	{
	 price+=8;
	}
    if (MessageBox("是否团体购票","请确认", MB_YESNO + MB_ICONQUESTION) == IDYES)
	{
	 price=price*0.8;
	}
    //GetDlgItem(IDC_MOUTH_COMBO)->SetWindowText(str);
    int num = atoi(str);
	switch(num)
	{
	 case 8:  price-=10;break;
	 case 11: price-=5;break;
     case 13: break;
	 case 16: price+=5;break;
	 case 20: price+=10;break;
	 case 22: price+=15;break;
	}
	str.Format("%f",price);
	GetDlgItem(IDC_EDIT_PRICE)->SetWindowText(str);
  
	
}