databinding.cpp

仓库管理系统的数据库

#include "stdafx.h"
#include "Databinding.h"

void CCPRs::FillFieldsArray(COleSafeArray& vaFieldlist, COleSafeArray& vaValuelist)
{
	vaFieldlist.CreateOneDim(VT_VARIANT,5);
	long lArrayIndex[1];

	lArrayIndex[0] = 0;
	vaFieldlist.PutElement(lArrayIndex, &(_variant_t("CP_NO")));
	lArrayIndex[0] = 1;
    vaFieldlist.PutElement(lArrayIndex, &(_variant_t("CP_NAME")));
	lArrayIndex[0] = 2;
	vaFieldlist.PutElement(lArrayIndex, &(_variant_t("CP_KIND")));
	lArrayIndex[0] = 3;
    vaFieldlist.PutElement(lArrayIndex, &(_variant_t("CP_PRICE")));
	lArrayIndex[0] = 4;
	vaFieldlist.PutElement(lArrayIndex, &(_variant_t("CP_DETAIL")));

	vaValuelist.CreateOneDim(VT_VARIANT,5);
	lArrayIndex[0] = 0;
	vaValuelist.PutElement(lArrayIndex, &(_variant_t(m_sz_no)));
	lArrayIndex[0] = 1;
	vaValuelist.PutElement(lArrayIndex, &(_variant_t(m_sz_name)));
	lArrayIndex[0] = 2;
	vaValuelist.PutElement(lArrayIndex, &(_variant_t(m_sz_kind)));
	lArrayIndex[0] = 3;
	vaValuelist.PutElement(lArrayIndex, &(_variant_t(m_f_price)));
	lArrayIndex[0] = 4;
	vaValuelist.PutElement(lArrayIndex, &(_variant_t(m_sz_detail)));
}

void CZBYRs::FillFieldsArray(COleSafeArray& vaFieldlist, COleSafeArray& vaValuelist)
{
	vaFieldlist.CreateOneDim(VT_VARIANT,2);
	long lArrayIndex[1];

	lArrayIndex[0] = 0;
	vaFieldlist.PutElement(lArrayIndex, &(_variant_t("ZBY_NAME")));
	lArrayIndex[0] = 1;
    vaFieldlist.PutElement(lArrayIndex, &(_variant_t("ZBY_PSWD")));

	vaValuelist.CreateOneDim(VT_VARIANT,2);
	lArrayIndex[0] = 0;
	vaValuelist.PutElement(lArrayIndex, &(_variant_t(m_sz_name)));
	lArrayIndex[0] = 1;
	vaValuelist.PutElement(lArrayIndex, &(_variant_t(m_sz_pswd)));
}

void CKHRs::FillFieldsArray(COleSafeArray& vaFieldlist, COleSafeArray& vaValuelist)
{
	vaFieldlist.CreateOneDim(VT_VARIANT,7);
	long lArrayIndex[1];

	lArrayIndex[0] = 0;
	vaFieldlist.PutElement(lArrayIndex, &(_variant_t("KH_NO")));
	lArrayIndex[0] = 1;
    vaFieldlist.PutElement(lArrayIndex, &(_variant_t("KH_NAME")));
	lArrayIndex[0] = 2;
	vaFieldlist.PutElement(lArrayIndex, &(_variant_t("KH_GENDER")));
	lArrayIndex[0] = 3;
    vaFieldlist.PutElement(lArrayIndex, &(_variant_t("KH_YEAR")));
	lArrayIndex[0] = 4;
	vaFieldlist.PutElement(lArrayIndex, &(_variant_t("KH_JOB")));
	lArrayIndex[0] = 5;
    vaFieldlist.PutElement(lArrayIndex, &(_variant_t("KH_TEL")));
	lArrayIndex[0] = 6;
	vaFieldlist.PutElement(lArrayIndex, &(_variant_t("KH_COMPANY")));

	vaValuelist.CreateOneDim(VT_VARIANT,7);
	lArrayIndex[0] = 0;
	vaValuelist.PutElement(lArrayIndex, &(_variant_t(m_sz_no)));
	lArrayIndex[0] = 1;
	vaValuelist.PutElement(lArrayIndex, &(_variant_t(m_sz_name)));
	lArrayIndex[0] = 2;
	vaValuelist.PutElement(lArrayIndex, &(_variant_t(m_sz_gender)));
	lArrayIndex[0] = 3;
	vaValuelist.PutElement(lArrayIndex, &(_variant_t(m_f_year)));
	lArrayIndex[0] = 4;
	vaValuelist.PutElement(lArrayIndex, &(_variant_t(m_sz_job)));
	lArrayIndex[0] = 5;
	vaValuelist.PutElement(lArrayIndex, &(_variant_t(m_sz_tel)));
	lArrayIndex[0] = 6;
	vaValuelist.PutElement(lArrayIndex, &(_variant_t(m_sz_company)));
}

void CDCRs::FillFieldsArray(COleSafeArray& vaFieldlist, COleSafeArray& vaValuelist)
{
	vaFieldlist.CreateOneDim(VT_VARIANT,5);
	long lArrayIndex[1];

	lArrayIndex[0] = 0;
	vaFieldlist.PutElement(lArrayIndex, &(_variant_t("DC_DESK")));
	lArrayIndex[0] = 1;
    vaFieldlist.PutElement(lArrayIndex, &(_variant_t("CP_NO")));
	lArrayIndex[0] = 2;
	vaFieldlist.PutElement(lArrayIndex, &(_variant_t("CP_NAME")));
	lArrayIndex[0] = 3;
    vaFieldlist.PutElement(lArrayIndex, &(_variant_t("DC_NUMBER")));
	lArrayIndex[0] = 4;
	vaFieldlist.PutElement(lArrayIndex, &(_variant_t("DC_DATE")));

	vaValuelist.CreateOneDim(VT_VARIANT,5);
	lArrayIndex[0] = 0;
	vaValuelist.PutElement(lArrayIndex, &(_variant_t(m_sz_desk)));
	lArrayIndex[0] = 1;
	vaValuelist.PutElement(lArrayIndex, &(_variant_t(m_sz_no)));
	lArrayIndex[0] = 2;
	vaValuelist.PutElement(lArrayIndex, &(_variant_t(m_sz_name)));
	lArrayIndex[0] = 3;
	vaValuelist.PutElement(lArrayIndex, &(_variant_t(m_f_number)));
	lArrayIndex[0] = 4;
	vaValuelist.PutElement(lArrayIndex, &(_variant_t(m_sz_date)));
}

void CJSRs::FillFieldsArray(COleSafeArray& vaFieldlist, COleSafeArray& vaValuelist)
{
	vaFieldlist.CreateOneDim(VT_VARIANT,5);
	long lArrayIndex[1];

	lArrayIndex[0] = 0;
	vaFieldlist.PutElement(lArrayIndex, &(_variant_t("KH_NO")));
	lArrayIndex[0] = 1;
    vaFieldlist.PutElement(lArrayIndex, &(_variant_t("DC_DESK")));
	lArrayIndex[0] = 2;
	vaFieldlist.PutElement(lArrayIndex, &(_variant_t("JS_DZ")));
	lArrayIndex[0] = 3;
    vaFieldlist.PutElement(lArrayIndex, &(_variant_t("TOTAL")));
	lArrayIndex[0] = 4;
	vaFieldlist.PutElement(lArrayIndex, &(_variant_t("JS_DATE")));

	vaValuelist.CreateOneDim(VT_VARIANT,5);
	lArrayIndex[0] = 0;
	vaValuelist.PutElement(lArrayIndex, &(_variant_t(m_sz_no)));
	lArrayIndex[0] = 1;
	vaValuelist.PutElement(lArrayIndex, &(_variant_t(m_sz_desk)));
	lArrayIndex[0] = 2;
	vaValuelist.PutElement(lArrayIndex, &(_variant_t(m_f_dz)));
	lArrayIndex[0] = 3;
	vaValuelist.PutElement(lArrayIndex, &(_variant_t(m_f_total)));
	lArrayIndex[0] = 4;
	vaValuelist.PutElement(lArrayIndex, &(_variant_t(m_sz_date)));
}