plnhdl.h

邮 电 公 司 erp源码

//---------------------------------------------------------------------------
#ifndef PlnhdlH
#define PlnhdlH
#include "sdbaselib.h"
#include "SdEnumType.h"
#include <ADODB.hpp>
#include <db.hpp>
class _EXPORT_TYPE TsdForeCasth;
class _EXPORT_TYPE TsdForeCastd;
class _EXPORT_TYPE TsdMps;
class _EXPORT_TYPE TsdMir;
class _EXPORT_TYPE TsdMrp;
//---------------------------------------------------------------------------
//**************************************
//  ClassName:TsdForeCastd            //
//  Description:计划预测单行          //
//  Created on:20001/01/03            //
//**************************************

class _EXPORT_TYPE TsdForeCastd: public TsdDetail
{
private:
    AnsiString m_ForeCastdCode;    //预测单号
    int        m_ForeCastdLine;    //行号
    AnsiString m_ForeCastdGoods;   //物料编码
    double     m_ForeCastdQty;     //需求数量
    AnsiString m_ForeCastdDate;    //需求日期
    double     m_ForeCastdGQty;    //生成数量
    AnsiString m_ForeCastdDesc;    //备注

//Backup
    AnsiString b_ForeCastdCode;
    int        b_ForeCastdLine;
    AnsiString b_ForeCastdGoods;
    double     b_ForeCastdQty;
    AnsiString b_ForeCastdDate;
    double     b_ForeCastdGQty;
    AnsiString b_ForeCastdDesc;

    void __fastcall SetForeCastdCode(AnsiString value);
    void __fastcall SetForeCastdLine(int value);
    void __fastcall SetForeCastdGoods(AnsiString value);
    void __fastcall SetForeCastdQty(double value);
    void __fastcall SetForeCastdDate(AnsiString value);
    void __fastcall SetForeCastdDesc(AnsiString value);

    __property  AnsiString ForeCastdCode={read=m_ForeCastdCode,write=SetForeCastdCode};
    __property  int        ForeCastdLine={read=m_ForeCastdLine,write=SetForeCastdLine};
    __property  AnsiString ForeCastdGoods={read=m_ForeCastdGoods,write=SetForeCastdGoods};
    __property  double     ForeCastdQty={read=m_ForeCastdQty,write=SetForeCastdQty};
    __property  AnsiString ForeCastdDate={read=m_ForeCastdDate,write=SetForeCastdDate};
    __property  double     ForeCastdGQty={read=m_ForeCastdGQty};
    __property  AnsiString ForeCastdDesc={read=m_ForeCastdDesc,write=SetForeCastdDesc};

public:
    TsdForeCastd(TDataComm *DC);
    TsdForeCastd();
    ~TsdForeCastd();
    TsdForeCasth *sdParent;

    void BackupValue();
    void RestoreValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();

    void Update();
    void Delete();
    void Assign(TsdForeCastd *p);
    int  Query();
    bool Find(AnsiString WhereStr);

    AnsiString GetFieldValue(euForeCastd sdFieldName);
    AnsiString GetOldFieldValue(euForeCastd sdFieldName);
    void SetFieldValue(euForeCastd sdFieldName, AnsiString value);
};

//**************************************
//  ClassName:TsdForeCasth            //
//  Description:计划预测单头          //
//  Created on:20001/01/03            //
//**************************************
class _EXPORT_TYPE TsdForeCasth: public TsdHead
{
private:
    TsdForeCastd *m_sdForeCastd;
    TsdForeCastd *b_sdForeCastd;

    AnsiString   m_ForeCasthCode;      //预测单号
    AnsiString   m_ForeCasthDate;      //预测日期
    AnsiString   m_ForeCasthPlanner;   //计划员
    int          m_ForeCasthCheck;     //审核标志
    AnsiString   m_ForeCasthChecker;   //审核人
    AnsiString   m_ForeCasthCheckDate; //审核日期
    AnsiString   m_ForeCasthDesc;      //备注
    AnsiString   m_ForeCasthSysDate;   //系统日期
//backup

    AnsiString   b_ForeCasthCode;
    AnsiString   b_ForeCasthDate;
    AnsiString   b_ForeCasthPlanner;
    int          b_ForeCasthCheck;
    AnsiString   b_ForeCasthChecker;
    AnsiString   b_ForeCasthCheckDate;
    AnsiString   b_ForeCasthDesc;
    AnsiString   b_ForeCasthSysDate;

    void __fastcall SetForeCasthCode(AnsiString value);
    void __fastcall SetForeCasthDate(AnsiString value);
    void __fastcall SetForeCasthPlanner(AnsiString value);
    void __fastcall SetForeCasthCheck(int value);
    void __fastcall SetForeCasthChecker(AnsiString value);
    void __fastcall SetForeCasthCheckDate(AnsiString value);
    void __fastcall SetForeCasthDesc(AnsiString value);

    __property  AnsiString ForeCasthCode={read=m_ForeCasthCode,write=SetForeCasthCode};
    __property  AnsiString ForeCasthDate={read=m_ForeCasthDate,write=SetForeCasthDate};
    __property  AnsiString ForeCasthPlanner={read=m_ForeCasthPlanner,write=SetForeCasthPlanner};
    __property  int        ForeCasthCheck={read=m_ForeCasthCheck,write=SetForeCasthCheck};
    __property  AnsiString ForeCasthChecker={read=m_ForeCasthChecker,write=SetForeCasthChecker};
    __property  AnsiString ForeCasthCheckDate={read=m_ForeCasthCheckDate,write=SetForeCasthCheckDate};
    __property  AnsiString ForeCasthDesc={read=m_ForeCasthDesc,write=SetForeCasthDesc};
    __property  AnsiString ForeCasthSysDate={read=m_ForeCasthSysDate};

private:
    void BackupValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();
    int __fastcall GetItemCount();
    int __fastcall GetCurItemNo();
    char __fastcall GetCurItemStatus();
    AnsiString __fastcall GetItemBookMark();

public:
    TsdForeCasth(TDataComm *DC);
    TsdForeCasth();
    ~TsdForeCasth();

    void RestoreValue();
    void RestoreItem();
    void Update();
    void Delete();
    void Check(int IsCheck);
    void AddItem();
    void InsertItem();
    void EditItem();
    void NewDetail();
    void DeleteDetail();
    void DeleteItem();
    void RemoveItem();
    void ClearItem();
    void CancelItem();
    void AddToObject();
    bool LocateItemByIndex(int Index);
    bool LocateItemByKey(AnsiString Key);
    void Assign(TsdForeCasth *p);
    int  Query();
    bool Find(AnsiString WhereStr);

    AnsiString GetFieldValue(euForeCasth sdFieldName);
    void SetFieldValue(euForeCasth sdFieldName, AnsiString value);

    AnsiString GetItemValue(euForeCastd FieldName);
    void SetItemValue(euForeCastd FieldName, AnsiString value);
    __property int ItemCount  = { read = GetItemCount };
    __property int CurItemNo  = { read = GetCurItemNo };
    __property int  CurItemStatus  = { read = GetCurItemStatus };
    __property AnsiString ItemBookMark  = { read = GetItemBookMark };
};

//*********************************
//  ClassName:TsdMps             //
//  Description:主生产计划       //
//  Created on:20001/01/03       //
//*********************************
//--------------------------------------------------------------
class _EXPORT_TYPE TsdMps: public TsdStandard
{
private:

    AnsiString m_MpsGoods;    //物料编码
    AnsiString m_MpsRDate;    //需求日期
    double     m_MpsRQty;     //需求数量
    double     m_MpsGQty;     //已生成数
    AnsiString m_MpsDate;     //操作日期
    AnsiString m_MpsPlanner;  //计划员
    int        m_MpsCheck;    //审核标志
    AnsiString m_MpsChecker;  //审核人
    AnsiString m_MpsCheckDate;//审核日期
    int        m_MpsState;    //状态
    AnsiString m_MpsSysDate;  //系统日期
//backup
    AnsiString b_MpsGoods;
    AnsiString b_MpsRDate;
    double     b_MpsRQty;
    double     b_MpsGQty;
    AnsiString b_MpsDate;
    AnsiString b_MpsPlanner;
    int        b_MpsCheck;
    AnsiString b_MpsChecker;
    AnsiString b_MpsCheckDate;
    int        b_MpsState;
    AnsiString b_MpsSysDate;

    void __fastcall SetMpsGoods(AnsiString value);
    void __fastcall SetMpsRDate(AnsiString value);
    void __fastcall SetMpsRQty(double value);
    void __fastcall SetMpsGQty(double value);
    void __fastcall SetMpsDate(AnsiString value);
    void __fastcall SetMpsPlanner(AnsiString value);
    void __fastcall SetMpsCheck(int value);
    void __fastcall SetMpsChecker(AnsiString value);
    void __fastcall SetMpsCheckDate(AnsiString value);
    void __fastcall SetMpsState(int value);

    __property  AnsiString MpsGoods={read=m_MpsGoods,write=SetMpsGoods};
    __property  AnsiString MpsRDate={read=m_MpsRDate,write=SetMpsRDate};
    __property  double     MpsRQty={read=m_MpsRQty,write=SetMpsRQty};
    __property  double     MpsGQty={read=m_MpsGQty,write=SetMpsGQty};
    __property  AnsiString MpsDate={read=m_MpsDate,write=SetMpsDate};
    __property  AnsiString MpsPlanner={read=m_MpsPlanner,write=SetMpsPlanner};
    __property  int        MpsCheck={read=m_MpsCheck,write=SetMpsCheck};
    __property  AnsiString MpsChecker={read=m_MpsChecker,write=SetMpsChecker};
    __property  AnsiString MpsCheckDate={read=m_MpsCheckDate,write=SetMpsCheckDate};
    __property  int        MpsState={read=m_MpsState,write=SetMpsState};
    __property  AnsiString MpsSysDate={read=m_MpsSysDate};
    void BackupValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();


public:
    TsdMps(TDataComm *DC);
    TsdMps();
    ~TsdMps();


    void RestoreValue();
    void Update();
    void Delete();
    void Check(int IsCheck);
    void Assign(TsdMps *p);
    int  Query();
    bool Find(AnsiString WhereStr);

    AnsiString GetFieldValue(euMps sdFieldName);
    void SetFieldValue(euMps sdFieldName, AnsiString value);
};

//*********************************
//  ClassName:TsdMir             //
//  Description:独立需求计划     //
//  Created on:20001/01/03       //
//*********************************
class _EXPORT_TYPE TsdMir: public TsdStandard
{
private:

    AnsiString m_MirGoods;    //物料编码
    AnsiString m_MirRDate;    //需求日期
    double     m_MirRQty;     //需求数量
    double     m_MirGQty;     //生成数量
    AnsiString m_MirDate;     //操作日期
    AnsiString m_MirPlanner;  //计划员
    int        m_MirCheck;    //审核标志
    AnsiString m_MirChecker;  //审核人
    AnsiString m_MirCheckDate;//审核日期
    AnsiString m_MirDesc;     //备注
    int        m_MirState;    //状态
    AnsiString m_MirSysDate;  //系统日期

//backup
    AnsiString b_MirGoods;
    AnsiString b_MirRDate;
    double     b_MirRQty;
    double     b_MirGQty;
    AnsiString b_MirDate;
    AnsiString b_MirPlanner;
    int        b_MirCheck;
    AnsiString b_MirChecker;
    AnsiString b_MirCheckDate;
    AnsiString b_MirDesc;
    int        b_MirState;
    AnsiString b_MirSysDate;

    void __fastcall SetMirGoods(AnsiString value);
    void __fastcall SetMirRDate(AnsiString value);
    void __fastcall SetMirRQty(double value);
    void __fastcall SetMirGQty(double value);
    void __fastcall SetMirDate(AnsiString value);
    void __fastcall SetMirPlanner(AnsiString value);
    void __fastcall SetMirCheck(int value);
    void __fastcall SetMirChecker(AnsiString value);
    void __fastcall SetMirCheckDate(AnsiString value);
    void __fastcall SetMirDesc(AnsiString value);
    void __fastcall SetMirState(int value);
    void __fastcall SetMirSysDate(AnsiString value);

    __property  AnsiString MirGoods={read=m_MirGoods,write=SetMirGoods};
    __property  AnsiString MirRDate={read=m_MirRDate,write=SetMirRDate};
    __property  double     MirRQty={read=m_MirRQty,write=SetMirRQty};
    __property  double     MirGQty={read=m_MirGQty,write=SetMirGQty};
    __property  AnsiString MirDate={read=m_MirDate,write=SetMirDate};
    __property  AnsiString MirPlanner={read=m_MirPlanner,write=SetMirPlanner};
    __property  int        MirCheck={read=m_MirCheck,write=SetMirCheck};
    __property  AnsiString MirChecker={read=m_MirChecker,write=SetMirChecker};
    __property  AnsiString MirCheckDate={read=m_MirCheckDate,write=SetMirCheckDate};
    __property  AnsiString MirDesc={read=m_MirDesc,write=SetMirDesc};
    __property  int        MirState={read=m_MirState,write=SetMirState};
    __property  AnsiString MirSysDate={read=m_MirSysDate,write=SetMirSysDate};
    void BackupValue();
    void EmptyValue(int Index);
    void BatchLetValue();
    void AssignValue();


public:
    TsdMir(TDataComm *DC);
    TsdMir();
    ~TsdMir();

    void RestoreValue();
    void Update();
    void Delete();
    void Assign(TsdMir *p);
    int  Query();
    bool Find(AnsiString WhereStr);
    void Check(int IsCheck);

    AnsiString GetFieldValue(euMir sdFieldName);
    void SetFieldValue(euMir sdFieldName, AnsiString value);
};

//类头
//**************************************
//     TsdMrp
//**************************************
//--------------------------------------------------------------
class _EXPORT_TYPE TsdMrp
{
private:
    TDataComm *m_DataComm;

    AnsiString CurDate;
    AnsiString CurFmonth;
    AnsiString EndDate;
    int PlanLen;
    AnsiString Planner;
    
    void __fastcall DecBom(AnsiString BomGoods,double BomQty,AnsiString RDate,bool NeedUpdate=true);
    void __fastcall CalcMrp();
    int  __fastcall InitMrp(AnsiString GoodsCode);
    void __fastcall PlanIn(AnsiString GoodsCode);
    void __fastcall PlanNet();
    void __fastcall BalanceMrp();

public:
    TsdMrp(TDataComm *DC);
    ~TsdMrp();

    void __fastcall GenMrp(AnsiString FPlanner);
};



#endif