📄 clientproductform.cpp

📁 关于客户关系管理系统的源码
💻 CPP
📖 第 1 页 / 共 2 页
字号:
上一页 12
	
	UpdateData(false);	
}

void CClientProductForm::OnModify() 
{
	tx_beginDate->EnableWindow(true);
	tx_endDate->EnableWindow(true);
	tx_productID->EnableWindow(false);
	tx_productName->EnableWindow(true);
	tx_standard->EnableWindow(true);
	tx_price->EnableWindow(true);
	tx_num->EnableWindow(true);
	tx_unit->EnableWindow(true);
	tx_total->EnableWindow(true);
	tx_manageRange->EnableWindow(true);
	tx_ourStaff->EnableWindow(true);
	tx_clientStaff->EnableWindow(true);
	tx_remark->EnableWindow(true);

	bt_add->EnableWindow(false);
	bt_delete->EnableWindow(false);
	bt_modify->EnableWindow(false);
	bt_cancelation->EnableWindow(false);
	bt_save->EnableWindow(true);

	flag=2;

	UpdateData(false);
	
}

void CClientProductForm::OnSave() 
{
	UpdateData(true);
	CClientProduct clientProduct;

	clientProduct.SetBeginDate(m_beginDate);
	clientProduct.SetEndDate(m_endDate);
	clientProduct.SetClientID(m_clientID);
	clientProduct.SetProductID(m_productID);
	clientProduct.SetProductName(m_productName);
	clientProduct.SetStandard(m_standard);
	clientProduct.SetPrice(m_price);
	clientProduct.SetNum(m_num);
	clientProduct.SetUnit(m_unit);
	clientProduct.SetTotal(m_total);
	clientProduct.SetManageRange(m_manageRange );
	clientProduct.SetOurStaff(m_ourStaff);
	clientProduct.SetClientStaff(m_clientStaff);
	clientProduct.SetRemark(m_remark);

	if(flag==1)
	{
		clientProduct.sqlInsert();

		int i=m_productList.GetItemCount();
		CString str;
		m_productList.InsertItem(i,m_productID);
		m_productList.SetItemText(i,1,m_productName);
		m_productList.SetItemText(i,4,m_standard);
//		m_productList.SetItemText(i,3,m_model);
		str.Format("%d-%d-%d",m_beginDate.GetYear(),m_beginDate.GetMonth(),m_beginDate.GetDay());
		m_productList.SetItemText(i,2,str);
		str.Format("%d-%d-%d",m_endDate.GetYear(),m_endDate.GetMonth(),m_endDate.GetDay());
		m_productList.SetItemText(i,3,str);
		str.Format("%f",m_price);
		m_productList.SetItemText(i,5,str);
		str.Format("%d",m_num);
		m_productList.SetItemText(i,6,str);
		m_productList.SetItemText(i,7,m_unit);
		str.Format("%f",m_total);
		m_productList.SetItemText(i,8,str);
		m_productList.SetItemText(i,9,m_manageRange);
		m_productList.SetItemText(i,10,m_ourStaff);
		m_productList.SetItemText(i,11,m_clientStaff);
		m_productList.SetItemText(i,12,m_remark);
	}
	else if(flag==2)
	{
		clientProduct.sqlUpdate(m_clientID,m_productID);
		Refresh();
	}

	tx_beginDate->EnableWindow(false);
	tx_endDate->EnableWindow(false);
	tx_productID->EnableWindow(false);
	tx_productName->EnableWindow(false);
	tx_standard->EnableWindow(false);
	tx_price->EnableWindow(false);
	tx_num->EnableWindow(false);
	tx_unit->EnableWindow(false);
	tx_total->EnableWindow(false);
	tx_manageRange->EnableWindow(false);
	tx_ourStaff->EnableWindow(false);
	tx_clientStaff->EnableWindow(false);
	tx_remark->EnableWindow(false);

	bt_add->EnableWindow(true);
	bt_delete->EnableWindow(true);
	bt_modify->EnableWindow(true);
	bt_cancelation->EnableWindow(false);
	bt_save->EnableWindow(false);
	

	
}

void CClientProductForm::OnCancelation() 
{
	tx_beginDate->EnableWindow(false);
	tx_endDate->EnableWindow(false);
	tx_productID->EnableWindow(false);
	tx_productName->EnableWindow(false);
	tx_standard->EnableWindow(false);
	tx_price->EnableWindow(false);
	tx_num->EnableWindow(false);
	tx_unit->EnableWindow(false);
	tx_total->EnableWindow(false);
	tx_manageRange->EnableWindow(false);
	tx_ourStaff->EnableWindow(false);
	tx_clientStaff->EnableWindow(false);
	tx_remark->EnableWindow(false);

	bt_add->EnableWindow(true);
	bt_delete->EnableWindow(false);
	bt_modify->EnableWindow(false);
	bt_cancelation->EnableWindow(false);
	bt_save->EnableWindow(false);

	CString m_formID;
	int formID=((CClientRelationshipApp*)AfxGetApp())->m_pIDRecordset->GetCollect("clientProductID").intVal;
	if(formID<10)
		m_formID.Format("KHCP0000%d",formID);
	else if(formID<100&&formID>9)
		m_formID.Format("KHCP000%d",formID);
	else if(formID<1000&&formID>99)
		m_formID.Format("KHCP00%d",formID);

	CString str;
	str.Format("%d",formID-1);
	((CClientRelationshipApp*)AfxGetApp())->m_pIDRecordset->PutCollect("clientProductID",_variant_t(str));
	((CClientRelationshipApp*)AfxGetApp())->m_pIDRecordset->Update();

	m_productID=m_formID;

	m_beginDate = COleDateTime::GetCurrentTime();
	m_endDate = COleDateTime::GetCurrentTime();
	m_productName = _T("");
	m_standard = _T("");
	m_price = 0.0f;
	m_num = 0;
	m_unit = _T("");
	m_total = 0.0f;
	m_manageRange = _T("");
	m_ourStaff = _T("");
	m_clientStaff = _T("");
	m_remark = _T("");
	
	UpdateData(false);	
	
}

void CClientProductForm::OnExit() 
{
	this->OnCancel();
	
}

void CClientProductForm::OnClickList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	UpdateData(true);
	POSITION pos = m_clientList.GetFirstSelectedItemPosition();
	if(pos)
	{
		int nFirstSelItem = m_clientList.GetNextSelectedItem(pos);
		m_clientID=m_clientList.GetItemText(nFirstSelItem,0);
	}

	CString strSQL;
	strSQL="select * from clientProduct where clientID='";
	strSQL=strSQL+m_clientID+"'";
	_RecordsetPtr m_pRecordset;
	HRESULT hTRes;
	hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));				
	hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
			((CClientRelationshipApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
			adOpenDynamic,adLockPessimistic,adCmdText);
	int i=0;
	m_productList.DeleteAllItems();
	while(!(m_pRecordset->adoEOF))
	{
		CString str;
		
		m_productList.InsertItem(i, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("productID")));
		m_productList.SetItemText(i,1, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("productName")));
		COleDateTime beginDate= m_pRecordset->GetCollect("beginDate");
		str.Format("%d-%d-%d",beginDate.GetYear(),beginDate.GetMonth(),beginDate.GetDay());
		m_productList.SetItemText(i,2,str);
		COleDateTime endDate= m_pRecordset->GetCollect("endDate");
		str.Format("%d-%d-%d",endDate.GetYear(),endDate.GetMonth(),endDate.GetDay());
		m_productList.SetItemText(i,3,str);
		m_productList.SetItemText(i,4, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("standard")));
//		m_productList.SetItemText(i,6, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("model")));
		float price= m_pRecordset->GetCollect("price");
		str.Format("%f",price);
		m_productList.SetItemText(i,5,str);
		int num= (m_pRecordset->GetCollect("num")).intVal;
		str.Format("%d",num);
		m_productList.SetItemText(i,6,str);
		m_productList.SetItemText(i,7, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("unit")));
		float total= m_pRecordset->GetCollect("total");
		str.Format("%f",total);
		m_productList.SetItemText(i,8,str);
		m_productList.SetItemText(i,9, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("range")));
		m_productList.SetItemText(i,10, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("ourStaff")));
		m_productList.SetItemText(i,11, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("clientStaff")));
		m_productList.SetItemText(i,12, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("remark")));

		m_pRecordset->MoveNext();
		i++;
	}

	UpdateData(false);
	
	*pResult = 0;
}

void CClientProductForm::OnClickList2(NMHDR* pNMHDR, LRESULT* pResult) 
{
	UpdateData(true);

	POSITION pos = m_productList.GetFirstSelectedItemPosition();
	if(pos)
	{
		int nFirstSelItem = m_productList.GetNextSelectedItem(pos);
		m_productID=m_productList.GetItemText(nFirstSelItem,0);
	}

	CClientProduct clientProduct;
	clientProduct.GetData(m_clientID,m_productID);

	
	m_beginDate = clientProduct.GetBeginDate();
	m_endDate = clientProduct.GetEndDate();
	m_productName = clientProduct.GetProductName();
	m_standard = clientProduct.GetStandard();
	m_price = clientProduct.GetPrice();
	m_num = clientProduct.GetNum();
	m_unit = clientProduct.GetUnit();
	m_total = clientProduct.GetTotal();
	m_manageRange = clientProduct.GetManageRange();
	m_ourStaff = clientProduct.GetOurStaff();
	m_clientStaff = clientProduct.GetClientStaff();
	m_remark = clientProduct.GetRemark();

	tx_beginDate->EnableWindow(false);
	tx_endDate->EnableWindow(false);
	tx_productID->EnableWindow(false);
	tx_productName->EnableWindow(false);
	tx_standard->EnableWindow(false);
	tx_price->EnableWindow(false);
	tx_num->EnableWindow(false);
	tx_unit->EnableWindow(false);
	tx_total->EnableWindow(false);
	tx_manageRange->EnableWindow(false);
	tx_ourStaff->EnableWindow(false);
	tx_clientStaff->EnableWindow(false);
	tx_remark->EnableWindow(false);

	bt_add->EnableWindow(true);
	bt_delete->EnableWindow(true);
	bt_modify->EnableWindow(true);
	bt_cancelation->EnableWindow(false);
	bt_save->EnableWindow(false);

	

	UpdateData(false);
	
	*pResult = 0;
	
}


void CClientProductForm::Refresh()
{
	m_productList.DeleteAllItems();

	CString strSQL;
	strSQL="select * from clientProduct where clientID='";
	strSQL=strSQL+m_clientID+"'";
	_RecordsetPtr m_pRecordset;
	HRESULT hTRes;
	hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));				
	hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
			((CClientRelationshipApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
			adOpenDynamic,adLockPessimistic,adCmdText);
	int i=0;
	while(!(m_pRecordset->adoEOF))
	{
		CString str;
		
		m_productList.InsertItem(i, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("productID")));
		m_productList.SetItemText(i,1, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("productName")));
		COleDateTime beginDate= m_pRecordset->GetCollect("beginDate");
		str.Format("%d-%d-%d",beginDate.GetYear(),beginDate.GetMonth(),beginDate.GetDay());
		m_productList.SetItemText(i,2,str);
		COleDateTime endDate= m_pRecordset->GetCollect("endDate");
		str.Format("%d-%d-%d",endDate.GetYear(),endDate.GetMonth(),endDate.GetDay());
		m_productList.SetItemText(i,3,str);
		m_productList.SetItemText(i,4, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("standard")));
//		m_productList.SetItemText(i,6, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("model")));
		float price= m_pRecordset->GetCollect("price");
		str.Format("%f",price);
		m_productList.SetItemText(i,5,str);
		int num= (m_pRecordset->GetCollect("num")).intVal;
		str.Format("%d",num);
		m_productList.SetItemText(i,6,str);
		m_productList.SetItemText(i,7, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("unit")));
		float total= m_pRecordset->GetCollect("total");
		str.Format("%f",total);
		m_productList.SetItemText(i,8,str);
		m_productList.SetItemText(i,9, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("range")));
		m_productList.SetItemText(i,10, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("ourStaff")));
		m_productList.SetItemText(i,11, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("clientStaff")));
		m_productList.SetItemText(i,12, ((CClientRelationshipApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("remark")));

		m_pRecordset->MoveNext();
		i++;
	}
}
上一页 12
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -