// DataCore.h : Declaration of the CDataCore

#ifndef __DATACORE_H_
#define __DATACORE_H_

#include "resource.h"       // main symbols

/////////////////////////////////////////////////////////////////////////////
// CDataCore
class ATL_NO_VTABLE CDataCore : 
	public CComObjectRootEx<CComSingleThreadModel>,
	public CComCoClass<CDataCore, &CLSID_DataCore>,
	public IDispatchImpl<IDataCore, &IID_IDataCore, &LIBID_MMCORELib>
{
public:
	CDataCore()
	{
	}

DECLARE_REGISTRY_RESOURCEID(IDR_DATACORE)

DECLARE_PROTECT_FINAL_CONSTRUCT()

BEGIN_COM_MAP(CDataCore)
	COM_INTERFACE_ENTRY(IDataCore)
	COM_INTERFACE_ENTRY(IDispatch)
END_COM_MAP()

// IDataCore
public:
	STDMETHOD(SaveToOutPut)(/*[in]*/BSTR InvoiceName,/*[in]*/BSTR Count,/*[in]*/BSTR  unit,/*[in]*/BSTR  Unitprice,/*[in]*/BSTR TotalPrice,/*[in]*/BSTR APS,/*[in]*/BSTR AllowCode,/*[in]*/BSTR AllowDate,/*[in]*/BSTR ID,/*[in]*/BSTR GoodsID,/*[out,retval]*/VARIANT_BOOL *succeed);
	STDMETHOD(ChangeCheckSheetStatus)(/*[in]*/BSTR OuPutID, /*[in]*/BSTR GoodID, /*[out,retval]*/VARIANT_BOOL *succeed);
	STDMETHOD(RtnMaxOutPutID)(/*[out,retval]*/BSTR* MaxID);
	STDMETHOD(SortOutPut)(/*[in]*/BSTR OutPutID,/*[in]*/BSTR SortID,/*[out,retval]*/VARIANT_BOOL* succeed);
	STDMETHOD(Insert_into_GoodsInfo)(/*[in]*/VARIANT_BOOL Vaild, /*[in]*/BSTR info,/*[in]*/BSTR attribute, /*[in]*/BSTR JudgeCode, /*[in]*/BSTR DocID, /*[out,retval]*/int *succeed);
	STDMETHOD(GoodsDateValid)(/*[in]*/BSTR DateID, /*[in]*/int Delay,/*[out,retval]*/VARIANT_BOOL *succeecd);
	STDMETHOD(DocDateValid)(/*[in]*/BSTR DateID,/*[in]*/int Delay,/*[out,retval]*/VARIANT_BOOL* succeecd);
	STDMETHOD(InitionConect)(/*[in]*/BSTR Constr,/*[in]*/BSTR pwd,/*[in]*/BSTR username,/*[out,retval]*/VARIANT_BOOL* Succeed);
	STDMETHOD(ProcessOutPutDetail)(/*[in]*/BSTR InVoiceName,/*[in]*/BSTR Count,/*[in]*/BSTR unit,/*[in]*/BSTR UnitPrice,/*[in]*/BSTR TotalPrice,/*[in]*/BSTR APS,/*[in]*/BSTR AllowCode,/*[in]*/BSTR AllowDate,/*[in]*/BSTR id,/*[in]*/VARIANT_BOOL NewGoods,/*[in]*/VARIANT_BOOL NewDoc,/*[in]*/VARIANT_BOOL DocVaild,/*[in]*/BSTR Information,/*[in]*/BSTR author,/*[in]*/BSTR Date,/*[in]*/BSTR RelationShip,/*[in]*/BSTR DocID,/*[in]*/VARIANT_BOOL GoodValid,/*[in]*/BSTR Info,/*[in]*/BSTR attribute,/*[in]*/BSTR JodgeDate,/*[in]*/BSTR JudgeCode,/*[in]*/BSTR GoodID,/*[out,retval]*/VARIANT_BOOL* Succeed);
	STDMETHOD(Updae_OutPutTwo)(/*[in]*/BSTR InvoiceName,/*[in]*/BSTR Count,/*[in]*/BSTR  unit,/*[in]*/BSTR  Unitprice,/*[in]*/BSTR TotalPrice,/*[in]*/BSTR APS,/*[in]*/BSTR AllowCode,/*[in]*/BSTR ID,/*[out,retval]*/VARIANT_BOOL *succeed);
	STDMETHOD(Delete_users)(/*[in]*/BSTR id,/*[out,retval]*/VARIANT_BOOL* succeed);
	STDMETHOD(Update_Users)(/*[in]*/BSTR username,/*[in]*/BSTR pwd,/*[in]*/BSTR level,/*[in]*/BSTR id,/*[out,retval]*/VARIANT_BOOL* succeed);
	STDMETHOD(Insert_Users)(/*[in]*/BSTR usersname,/*[in]*/BSTR pwd,/*[in]*/BSTR level,/*[out,retval]*/int* succeed);
	CString RtnMaxInvoiceID();
	STDMETHOD(OutMaxInvoiceID)(/*[out,retval]*/BSTR* ID);
	BSTR RtnInvoidID();
	STDMETHOD(ExcuteThreeSqlTran)(/*[in]*/BSTR sqlstr1,/*[in]*/BSTR sqlstr2,/*[in]*/BSTR sqlstr3,/*[out,retval]*/VARIANT_BOOL* succeed);
	STDMETHOD(ExcuteTwoSqlTran)(/*[in]*/BSTR sqlstr1,/*[in]*/BSTR sqlstr2,/*[out,retval]*/VARIANT_BOOL* succeed);
	STDMETHOD(Update_PastOrgian)(/*[in]*/VARIANT_BOOL Vaild,/*[in]*/BSTR name,/*[in]*/BSTR Content,/*[in]*/BSTR address,/*[in]*/BSTR Link,/*[in]*/BSTR TermsOfPayment,/*[in]*/BSTR PortOfShipment,/*[in]*/BSTR PortOfDestination,/*[in]*/BSTR Incoterms,/*[in]*/BSTR ID,/*[out,retval]*/VARIANT_BOOL* SUCCEED);
	STDMETHOD(Delete_PastOrgian)(/*[in]*/BSTR ID,/*[out,retval]*/VARIANT_BOOL* SUCCEED);
	STDMETHOD(Insert_PastOrgian)(/*[in]*/VARIANT_BOOL Vaild,/*[in]*/BSTR name,/*[in]*/BSTR Content,/*[in]*/BSTR address,/*[in]*/BSTR Link,/*[in]*/BSTR TermsOfPayment,/*[in]*/BSTR PortOfShipment,/*[in]*/BSTR PortOfDestination,/*[in]*/BSTR Incoterms,/*[out,retval]*/int* SUCCEED);
	STDMETHOD(Update_Invoice)(/*[in]*/BSTR InvoiceNO,/*[in]*/BSTR InvoiceDate,/*[in]*/BSTR OrgainID,/*[in]*/BSTR title,/*[in]*/BSTR ShippedPer,/*[in]*/BSTR DateOfShipment,/*[in]*/BSTR PortOfShipment,/*[in]*/BSTR Via,/*[in]*/BSTR PortOfDestination,/*[in]*/BSTR TermsOfPayment,/*[in]*/BSTR OrderNo,/*[in]*/BSTR CommercialTems,/*[in]*/BSTR settleCurrency,/*[in]*/VARIANT_BOOL InCommecial,/*[in]*/BSTR MarksAndNos,/*[in]*/BSTR Notes,/*[in]*/BSTR Freight,/*[in]*/BSTR CountryOfOrigin,/*[in]*/BSTR TotalPacking,/*[in]*/BSTR ChargeManID,/*[in]*/BSTR address,/*[in]*/BSTR InvoiceID,/*[out,retval]*/VARIANT_BOOL* SUCCEED);
	STDMETHOD(Delete_Invoice)(/*[in]*/BSTR InvoiceID,/*[out,retval]*/VARIANT_BOOL* succeed);
	STDMETHOD(Insert_Invoice)(/*[in]*/BSTR InvoiceDate,/*[in]*/BSTR OrgainID,/*[in]*/BSTR title,/*[in]*/BSTR ShippedPer,/*[in]*/BSTR DateOfShipment,/*[in]*/BSTR PortOfShipment,/*[in]*/BSTR Via,/*[in]*/BSTR PortOfDestination,/*[in]*/BSTR TermsOfPayment,/*[in]*/BSTR OrderNo,/*[in]*/BSTR CommercialTems,/*[in]*/BSTR settleCurrency,/*[in]*/VARIANT_BOOL InCommecial,/*[in]*/BSTR MarksAndNos,/*[in]*/BSTR Notes,/*[in]*/BSTR Freight,/*[in]*/BSTR CountryOfOrigin,/*[in]*/BSTR TotalPacking,/*[in]*/BSTR ChargeManID,/*[in]*/BSTR address,/*[in]*/BSTR InvoiceNO,/*[out,retval]*/int* SUCCEED);
	STDMETHOD(Delete_AllowCode)(/*[in]*/BSTR code,/*[out,retval]*/VARIANT_BOOL* succeed);
	STDMETHOD(Update_AllowCode)(/*[in]*/BSTR CODE,/*[in]*/BSTR content,/*[out,retval]*/VARIANT_BOOL* succeed);
	STDMETHOD(Insert_AllowCode)(/*[in]*/BSTR code,/*[in]*/BSTR content,/*[out,retval]*/VARIANT_BOOL* succeed);
	STDMETHOD(Delete_GoodsInfo)(/*[in]*/BSTR ID,/*[out,retval]*/VARIANT_BOOL* succeed);
	STDMETHOD(Update_GoodsInfo)(/*[in]*/VARIANT_BOOL Vaild,/*[in]*/BSTR info,/*[in]*/BSTR attribute,/*[in]*/BSTR JudgeCode,/*[in]*/BSTR JodgeDate,/*[in]*/BSTR DocID,/*[in]*/BSTR ID,/*[out,retval]*/VARIANT_BOOL* succeed);
	STDMETHOD(Insert_GoodsInfo)(/*[in]*/VARIANT_BOOL Vaild,/*[in]*/BSTR info,/*[in]*/BSTR attribute,/*[in]*/BSTR JudgeCode,/*[in]*/BSTR JodgeDate,/*[in]*/BSTR DocID,/*[out,retval]*/int* succeed);
	STDMETHOD(Delete_Doucment)(/*[in]*/BSTR ID,/*[out,retval]*/VARIANT_BOOL* succeed);
	STDMETHOD(Update_Doucment)(/*[in]*/VARIANT_BOOL vaild,/*[in]*/BSTR information,/*[in]*/BSTR author,/*[in]*/BSTR date,/*[in]*/BSTR RelationShip,/*[in]*/BSTR ID,/*[out,retval]*/VARIANT_BOOL* succeed);
	STDMETHOD(inset_Document)(/*[in]*/VARIANT_BOOL vaild,/*[in]*/BSTR information,/*[in]*/BSTR author,/*[in]*/BSTR date,/*[in]*/BSTR RelationShip,/*[out,retval]*/int* succeed);
	STDMETHOD(Delete_OutPutChargeMan)(/*[in]*/BSTR ID,/*[out,retval]*/VARIANT_BOOL* succeed);
	STDMETHOD(Update_OutputChargeMan)(/*[in]*/BSTR Dept,/*[in]*/BSTR name,/*[in]*/BSTR ID,/*[out,retval]*/VARIANT_BOOL* succeed);
	STDMETHOD(Insert_OutputChargeMan)(/*[in]*/BSTR Dept,/*[in]*/BSTR name,/*[out,retval]*/int* succeed);
	STDMETHOD(Delete_Output)(/*[in]*/BSTR ID,/*[out,retval]*/VARIANT_BOOL* succeed);
	STDMETHOD(Update_Output)(/*[in]*/BSTR InvoiceName,/*[in]*/BSTR Count,/*[in]*/BSTR  unit,/*[in]*/BSTR  Unitprice,/*[in]*/BSTR TotalPrice,/*[in]*/BSTR APS,/*[in]*/BSTR AllowCode,/*[in]*/BSTR AllowDate,/*[in]*/BSTR ID,/*[out,retval]*/VARIANT_BOOL *succeed);
	STDMETHOD(Insert_Output)(/*[in]*/BSTR InvoiceID,/*[in]*/BSTR InvoiceName,/*[in]*/BSTR Count,/*[in]*/BSTR  unit,/*[in]*/BSTR  Unitprice,/*[in]*/BSTR TotalPrice,/*[in]*/BSTR APS,/*[in]*/BSTR AllowCode,/*[in]*/BSTR AllowDate,/*[in]*/BSTR GoodsID,/*[out,retval]*/int *succeed);
	STDMETHOD(Delete_JudgeMentCode)(/*[in]*/BSTR judgeCode,/*[out,retval]*/VARIANT_BOOL *succeed);
	STDMETHOD(Update_JudgeMentCode)(/*[in]*/BSTR judgeCode,/*[in]*/BSTR judegStatus,/*[out,retval]*/VARIANT_BOOL* succeed);
	STDMETHOD(Insert_JudgeMentCode)(/*[in]*/BSTR judgeCode,/*[in]*/BSTR JudgeMentStatus,/*[out,retval]*/VARIANT_BOOL* succeed);
	STDMETHOD(SearchRtnRs)(/*[in]*/BSTR sqlstr,/*[out,retval]*/_Recordset **ptr);
	STDMETHOD(ExcuteSql)(/*[in]*/BSTR Sqlstr,/*[out,retval]*/VARIANT_BOOL* Succeed);
	_ConnectionPtr ConPtr;
	STDMETHOD(InitionConnection)(/*[in]*/BSTR ConnectionStr,/*[out,retval]*/VARIANT_BOOL* Succeed);
private:
	BSTR MaxOutPutID();
	int GetTheYear(int year,int month);
	COleDateTime RtnGoodsDate(BSTR ID);
	COleDateTime RtnPublishDate(BSTR ID);
	long GetDaysOfMonth(int month,int year);
	BSTR RtnMaxGoodID();
	BSTR RtnMaxDocID();
};

#endif //__DATACORE_H_