SalesOrder inquiry
public void init() //in data source level
{
super();
delete_from M_SalesTemp;
}
------------------------------------------------------------------------------------
void clicked()
{
SalesTable salesTable;
M_SalesTemp obj;
SalesStatus salesStatus;
CustAccount custAccount;
super();
delete_from M_SalesTemp;
custAccount = M_SalesTemp_CustAccount1.valueStr();
salesStatus = M_SalesTemp_SalesStatus1.selection();
if (custAccount&&salesStatus)
{
ttsBegin;
while select salesTable where salesTable.CustAccount == custAccount
&& salesTable.SalesStatus == salesStatus
{
obj.SalesId = salesTable.SalesId;
obj.CustAccount = salesTable.CustAccount;
obj.CustGroup = salesTable.CustGroup;
obj.SalesStatus = salesTable.SalesStatus;
obj.DocumentStatus = salesTable.DocumentStatus;
obj.DeloveryDate = salesTable.DeliveryDate;
obj.insert();
}
ttsCommit;
}
else if(custAccount)
{
ttsBegin;
while select salesTable where
salesTable.CustAccount == custAccount
{
obj.SalesId = salesTable.SalesId;
obj.CustAccount = salesTable.CustAccount;
obj.CustGroup = salesTable.CustGroup;
obj.SalesStatus = salesTable.SalesStatus;
obj.DocumentStatus = salesTable.DocumentStatus;
obj.DeloveryDate = salesTable.DeliveryDate;
obj.insert();
}
ttsCommit;
}
else if (salesStatus)
{
ttsBegin;
while select salesTable where
salesTable.SalesStatus == salesStatus
{
obj.SalesId = salesTable.SalesId;
obj.CustAccount = salesTable.CustAccount;
obj.CustGroup = salesTable.CustGroup;
obj.SalesStatus = salesTable.SalesStatus;
obj.DocumentStatus = salesTable.DocumentStatus;
obj.DeloveryDate = salesTable.DeliveryDate;
obj.insert();
}
ttsCommit;
}
M_SalesTemp_ds.refresh();
M_SalesTemp_ds.research();
}
public void init() //in data source level
{
super();
delete_from M_SalesTemp;
}
------------------------------------------------------------------------------------
void clicked()
{
SalesTable salesTable;
M_SalesTemp obj;
SalesStatus salesStatus;
CustAccount custAccount;
super();
delete_from M_SalesTemp;
custAccount = M_SalesTemp_CustAccount1.valueStr();
salesStatus = M_SalesTemp_SalesStatus1.selection();
if (custAccount&&salesStatus)
{
ttsBegin;
while select salesTable where salesTable.CustAccount == custAccount
&& salesTable.SalesStatus == salesStatus
{
obj.SalesId = salesTable.SalesId;
obj.CustAccount = salesTable.CustAccount;
obj.CustGroup = salesTable.CustGroup;
obj.SalesStatus = salesTable.SalesStatus;
obj.DocumentStatus = salesTable.DocumentStatus;
obj.DeloveryDate = salesTable.DeliveryDate;
obj.insert();
}
ttsCommit;
}
else if(custAccount)
{
ttsBegin;
while select salesTable where
salesTable.CustAccount == custAccount
{
obj.SalesId = salesTable.SalesId;
obj.CustAccount = salesTable.CustAccount;
obj.CustGroup = salesTable.CustGroup;
obj.SalesStatus = salesTable.SalesStatus;
obj.DocumentStatus = salesTable.DocumentStatus;
obj.DeloveryDate = salesTable.DeliveryDate;
obj.insert();
}
ttsCommit;
}
else if (salesStatus)
{
ttsBegin;
while select salesTable where
salesTable.SalesStatus == salesStatus
{
obj.SalesId = salesTable.SalesId;
obj.CustAccount = salesTable.CustAccount;
obj.CustGroup = salesTable.CustGroup;
obj.SalesStatus = salesTable.SalesStatus;
obj.DocumentStatus = salesTable.DocumentStatus;
obj.DeloveryDate = salesTable.DeliveryDate;
obj.insert();
}
ttsCommit;
}
M_SalesTemp_ds.refresh();
M_SalesTemp_ds.research();
}
No comments:
Post a Comment