📄 mmhdl.cpp
字号:
WoCancelDate=g_sdCurDate;
m_StoredProc->Parameters->CreateParameter("@W_WoCode",ftString,pdInput,18,b_WoCode);
m_StoredProc->Parameters->CreateParameter("@WoCancel",ftInteger,pdInput,1,m_WoCancel);
m_StoredProc->Parameters->CreateParameter("@WoCancelDate",ftString,pdInput,10,m_WoCancelDate);
m_StoredProc->ExecProc();
m_StoredProc->Close();
}
else
{
WoCancel=0;
WoCancelDate="";
m_StoredProc->Parameters->CreateParameter("@W_WoCode",ftString,pdInput,18,b_WoCode);
m_StoredProc->Parameters->CreateParameter("@WoCancel",ftInteger,pdInput,1,m_WoCancel);
m_StoredProc->Parameters->CreateParameter("@WoCancelDate",ftString,pdInput,10,m_WoCancelDate);
m_StoredProc->ExecProc();
m_StoredProc->Close();
}
TsdWo *p=(TsdWo*)Records(CurRecNo);
p->Assign(this);
BackupValue();
}
catch(Exception &e)
{
m_WoCancel=b_WoCancel;
m_WoCancelDate=b_WoCancelDate;
throw Exception(e.Message);
}
}
}
//---------------------------------------------------------------------------
void TsdWo::Close(int IsClose)
{
if(this->Count>0)
{
try{
m_StoredProc->Close();
m_StoredProc->ProcedureName="sdWo_Close";
m_StoredProc->Parameters->Clear();
if(IsClose==1)
{
WoClose=1;
WoCloseDate=g_sdCurDate;
m_StoredProc->Parameters->CreateParameter("@W_WoCode",ftString,pdInput,18,b_WoCode);
m_StoredProc->Parameters->CreateParameter("@WoClose",ftInteger,pdInput,1,m_WoClose);
m_StoredProc->Parameters->CreateParameter("@WoCloseDate",ftString,pdInput,10,m_WoCloseDate);
m_StoredProc->Parameters->CreateParameter("@WoStatus",ftInteger,pdOutput,1,m_WoStatus);
m_StoredProc->ExecProc();
m_WoStatus=m_StoredProc->Parameters->ParamValues["@WoStatus"];
m_StoredProc->Close();
}
else
{
WoClose=0;
WoCloseDate="";
m_StoredProc->Parameters->CreateParameter("@W_WoCode",ftString,pdInput,18,b_WoCode);
m_StoredProc->Parameters->CreateParameter("@WoClose",ftInteger,pdInput,1,m_WoClose);
m_StoredProc->Parameters->CreateParameter("@WoCloseDate",ftString,pdInput,10,m_WoCloseDate);
m_StoredProc->Parameters->CreateParameter("@WoStatus",ftInteger,pdOutput,1,m_WoStatus);
m_StoredProc->ExecProc();
m_WoStatus=m_StoredProc->Parameters->ParamValues["@WoStatus"];
m_StoredProc->Close();
}
TsdWo *p=(TsdWo*)Records(CurRecNo);
p->Assign(this);
BackupValue();
}
catch(Exception &e)
{
m_WoClose=b_WoClose;
m_WoCloseDate=b_WoCloseDate;
m_WoStatus=b_WoStatus;
throw Exception(e.Message);
}
}
}
//---------------------------------------------------------------------------
void TsdWo::BackupValue()
{
b_WoCode = m_WoCode;
b_WoStatus = m_WoStatus;
b_WoType = m_WoType;
b_WoConsume = m_WoConsume;
b_WoTrace = m_WoTrace;
b_WoGoods =m_WoGoods;
b_WoUnit =m_WoUnit;
b_WoSoCode =m_WoSoCode;
b_WoSodLine =m_WoSodLine;
b_WoRoute =m_WoRoute;
b_WoBatch =m_WoBatch;
b_WoFrom =m_WoFrom;
b_WoChkFlg =m_WoChkFlg;
b_WoQty =m_WoQty;
b_WoCqty =m_WoCqty;
b_WoEqty =m_WoEqty;
b_WoWqty =m_WoWqty;
b_WoRqty =m_WoRqty;
b_WoSqty =m_WoSqty;
b_WoDate =m_WoDate;
b_WoRdate =m_WoRdate;
b_WoMdate =m_WoMdate;
b_WoSdate =m_WoSdate;
b_WoCloseDate=m_WoCloseDate;
b_WoClose =m_WoClose;
b_WoTwt =m_WoTwt;
b_WoPamt =m_WoPamt;
b_WoMamt =m_WoMamt;
b_WoEamt =m_WoEamt;
b_WoDesc =m_WoDesc;
b_WoUser =m_WoUser;
b_WoSysDate =m_WoSysDate;
b_WoCheck =m_WoCheck;
b_WoChecker =m_WoChecker;
b_WoCheckDate =m_WoCheckDate;
b_WoCancel =m_WoCancel;
b_WoCancelDate=m_WoCancelDate;
b_WoProducter =m_WoProducter;
}
//---------------------------------------------------------------------------
void TsdWo::RestoreValue()
{
m_WoCode = b_WoCode;
m_WoStatus = b_WoStatus;
m_WoType = b_WoType;
m_WoConsume = b_WoConsume;
m_WoTrace = b_WoTrace;
m_WoGoods =b_WoGoods;
m_WoUnit =b_WoUnit;
m_WoSoCode =b_WoSoCode;
m_WoSodLine =b_WoSodLine;
m_WoRoute =b_WoRoute;
m_WoBatch =b_WoBatch;
m_WoFrom =b_WoFrom;
m_WoChkFlg =b_WoChkFlg;
m_WoQty =b_WoQty;
m_WoCqty =b_WoCqty;
m_WoEqty =b_WoEqty;
m_WoWqty =b_WoWqty;
m_WoRqty =b_WoRqty;
m_WoSqty =b_WoSqty;
m_WoDate =b_WoDate;
m_WoRdate =b_WoRdate;
m_WoMdate =b_WoMdate;
m_WoSdate =b_WoSdate;
m_WoCloseDate=b_WoCloseDate;
m_WoClose =b_WoClose;
m_WoTwt =b_WoTwt;
m_WoPamt =b_WoPamt;
m_WoMamt =b_WoMamt;
m_WoEamt =b_WoEamt;
m_WoDesc =b_WoDesc;
m_WoUser =b_WoUser;
m_WoSysDate =b_WoSysDate;
m_WoCheck =b_WoCheck;
m_WoChecker =b_WoChecker;
m_WoCheckDate =b_WoCheckDate;
m_WoCancel =b_WoCancel;
m_WoCancelDate=b_WoCancelDate;
m_WoProducter =b_WoProducter;
}
//---------------------------------------------------------------------------
void TsdWo::EmptyValue(int Index)
{
switch(Index)
{
case 0:
m_WoCode ="";
m_WoStatus =0;
m_WoType =0;
m_WoConsume =0;
m_WoTrace =0;
m_WoGoods ="";
m_WoUnit ="";
m_WoSoCode ="";
m_WoSodLine =0;
m_WoRoute ="";
m_WoBatch ="";
m_WoFrom =0;
m_WoChkFlg =0;
m_WoQty =0;
m_WoCqty =0;
m_WoEqty =0;
m_WoWqty =0;
m_WoRqty =0;
m_WoSqty =0;
m_WoDate ="";
m_WoRdate ="";
m_WoMdate ="";
m_WoSdate ="";
m_WoCloseDate ="";
m_WoClose =0;
m_WoTwt =0;
m_WoPamt =0;
m_WoMamt =0;
m_WoEamt =0;
m_WoDesc ="";
m_WoUser ="";
m_WoSysDate ="";
m_WoCheck=0;
m_WoChecker="";
m_WoCheckDate="";
m_WoCancel=0;
m_WoCancelDate="";
m_WoProducter="";
break;
case 1:
b_WoCode ="";
b_WoStatus =0;
b_WoType =0;
b_WoConsume =0;
b_WoTrace =0;
b_WoGoods ="";
b_WoUnit ="";
b_WoSoCode ="";
b_WoSodLine =1;
b_WoRoute ="";
b_WoBatch ="";
b_WoFrom =0;
b_WoChkFlg =0;
b_WoQty =0;
b_WoCqty =0;
b_WoEqty =0;
b_WoWqty =0;
b_WoRqty =0;
b_WoSqty =0;
b_WoDate ="";
b_WoRdate ="";
b_WoMdate ="";
b_WoSdate ="";
b_WoCloseDate ="";
b_WoClose =0;
b_WoTwt =0;
b_WoPamt =0;
b_WoMamt =0;
b_WoEamt=0;
b_WoDesc ="";
b_WoUser ="";
b_WoSysDate ="";
b_WoCheck=0;
b_WoChecker="";
b_WoCheckDate="";
b_WoCancel=0;
b_WoCancelDate="";
b_WoProducter="";
break;
}
}
//---------------------------------------------------------------------------
void TsdWo::BatchLetValue()
{
m_WoCode =m_Query->FieldValues["WoCode"];
m_WoStatus =m_Query->FieldValues["WoStatus"];
m_WoType =m_Query->FieldValues["WoType"];
m_WoConsume =m_Query->FieldValues["WoConsume"];
m_WoTrace =m_Query->FieldValues["WoTrace"];
m_WoGoods =m_Query->FieldValues["WoGoods"];
m_WoUnit =m_Query->FieldValues["WoUnit"];
m_WoSoCode =m_Query->FieldValues["WoSoCode"];
m_WoSodLine =m_Query->FieldValues["WoSodLine"];
m_WoRoute =m_Query->FieldValues["WoRoute"];
m_WoBatch =m_Query->FieldValues["WoBatch"];
m_WoFrom =m_Query->FieldValues["WoFrom"];
m_WoChkFlg =m_Query->FieldValues["WoChkFlg"];
m_WoQty =m_Query->FieldValues["WoQty"];
m_WoCqty =m_Query->FieldValues["WoCqty"];
m_WoEqty =m_Query->FieldValues["WoEqty"];
m_WoWqty =m_Query->FieldValues["WoWqty"];
m_WoRqty =m_Query->FieldValues["WoRqty"];
m_WoSqty =m_Query->FieldValues["WoSqty"];
m_WoDate =m_Query->FieldValues["WoDate"];
m_WoRdate =m_Query->FieldValues["WoRdate"];
m_WoMdate =m_Query->FieldValues["WoMdate"];
m_WoSdate =m_Query->FieldValues["WoSdate"];
m_WoCloseDate =m_Query->FieldValues["WoCloseDate"];
m_WoClose =m_Query->FieldValues["WoClose"];
m_WoTwt =m_Query->FieldValues["WoTwt"];
m_WoPamt =m_Query->FieldValues["WoPamt"];
m_WoMamt =m_Query->FieldValues["WoMamt"];
m_WoEamt =m_Query->FieldValues["WoEamt"];
m_WoDesc =m_Query->FieldValues["WoDesc"];
m_WoUser =m_Query->FieldValues["WoUser"];
m_WoSysDate =m_Query->FieldValues["WoSysDate"];
m_WoCheck =m_Query->FieldValues["WoCheck"];
m_WoChecker =m_Query->FieldValues["WoChecker"];
m_WoCheckDate =m_Query->FieldValues["WoCheckDate"];
m_WoCancel =m_Query->FieldValues["WoCancel"];
m_WoCancelDate=m_Query->FieldValues["WoCancelDate"];
m_WoProducter =m_Query->FieldValues["WoProducter"];
BackupValue();
}
//---------------------------------------------------------------------------
void TsdWo::Assign(TsdWo *p)
{
this->SetActionID(p->CurStatus);
this->m_WoCode=p->m_WoCode;
this->m_WoStatus=p->m_WoStatus;
this->m_WoType=p->m_WoType;
this->m_WoConsume=p->m_WoConsume;
this->m_WoTrace=p->m_WoTrace;
this->m_WoGoods=p->m_WoGoods;
this->m_WoUnit=p->m_WoUnit;
this->m_WoSoCode=p->m_WoSoCode;
this->m_WoSodLine=p->m_WoSodLine;
this->m_WoRoute=p->m_WoRoute;
this->m_WoBatch=p->m_WoBatch;
this->m_WoFrom=p->m_WoFrom;
this->m_WoChkFlg=p->m_WoChkFlg;
this->m_WoQty=p->m_WoQty;
this->m_WoCqty=p->m_WoCqty;
this->m_WoEqty=p->m_WoEqty;
this->m_WoWqty=p->m_WoWqty;
this->m_WoRqty=p->m_WoRqty;
this->m_WoSqty=p->m_WoSqty;
this->m_WoDate=p->m_WoDate;
this->m_WoRdate=p->m_WoRdate;
this->m_WoMdate=p->m_WoMdate;
this->m_WoSdate=p->m_WoSdate;
this->m_WoCloseDate=p->m_WoCloseDate;
this->m_WoClose=p->m_WoClose;
this->m_WoTwt=p->m_WoTwt;
this->m_WoPamt=p->m_WoPamt;
this->m_WoMamt=p->m_WoMamt;
this->m_WoEamt=p->m_WoEamt;
this->m_WoDesc=p->m_WoDesc;
this->m_WoUser=p->m_WoUser;
this->m_WoSysDate=p->m_WoSysDate;
this->m_WoCheck=p->m_WoCheck;
this->m_WoChecker=p->m_WoChecker;
this->m_WoCheckDate=p->m_WoCheckDate;
this->m_WoCancel=p->m_WoCancel;
this->m_WoCancelDate=p->m_WoCancelDate;
this->m_WoProducter=p->WoProducter;
if(this->CurStatus==3)
{
this->b_WoCode=p->b_WoCode;
this->b_WoStatus=p->b_WoStatus;
this->b_WoType=p->b_WoType;
this->b_WoConsume=p->b_WoConsume;
this->b_WoTrace=p->b_WoTrace;
this->b_WoGoods=p->b_WoGoods;
this->b_WoUnit=p->b_WoUnit;
this->b_WoSoCode=p->b_WoSoCode;
this->b_WoSodLine=p->b_WoSodLine;
this->b_WoRoute=p->b_WoRoute;
this->b_WoBatch=p->b_WoBatch;
this->b_WoFrom=p->b_WoFrom;
this->b_WoChkFlg=p->b_WoChkFlg;
this->b_WoQty=p->b_WoQty;
this->b_WoCqty=p->b_WoCqty;
this->b_WoEqty=p->b_WoEqty;
this->b_WoWqty=p->b_WoWqty;
this->b_WoRqty=p->b_WoRqty;
this->b_WoSqty=p->b_WoSqty;
this->b_WoDate=p->b_WoDate;
this->b_WoRdate=p->b_WoRdate;
this->b_WoMdate=p->b_WoMdate;
this->b_WoSdate=p->b_WoSdate;
this->b_WoCloseDate=p->b_WoCloseDate;
this->b_WoClose=p->b_WoClose;
this->b_WoTwt=p->b_WoTwt;
this->b_WoPamt=p->b_WoPamt;
this->b_WoMamt=p->b_WoMamt;
this->b_WoEamt=p->b_WoEamt;
this->b_WoDesc=p->b_WoDesc;
this->b_WoUser=p->b_WoUser;
this->b_WoSysDate=p->b_WoSysDate;
this->b_WoCheck=p->b_WoCheck;
this->b_WoChecker=p->b_WoChecker;
this->b_WoCheckDate=p->b_WoCheckDate;
this->b_WoCancel=p->b_WoCancel;
this->b_WoCancelDate=p->b_WoCancelDate;
this->b_WoProducter=p->b_WoProducter;
}
else
this->BackupValue();
}
//---------------------------------------------------------------------------
void TsdWo::AssignValue()
{
TsdWo *p=(TsdWo *)Records(CurRecNo);
Assign(p);
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -