public void UpdateOPCOfflineTransactionBySysNo(OPCOfflineTransactionInfo info)
{
DataCommand command = DataCommandManager.GetDataCommand("SO_Update_OPCOfflineTransaction");
command.SetParameterValue(info);
command.ExecuteNonQuery();
}
public OPCOfflineTransactionInfo GetOPCOfflineTransactionBySysNo(int sysNo)
{
DataCommand command = DataCommandManager.GetDataCommand("SO_Get_OPCOfflineTransaction");
command.SetParameterValue("@SysNo", sysNo);
OPCOfflineTransactionInfo OPCTransactionInfo = command.ExecuteEntity <OPCOfflineTransactionInfo>();
return(OPCTransactionInfo);
}
public int InsertOPCOfflineTransaction(OPCOfflineTransactionInfo info)
{
DataCommand command = DataCommandManager.GetDataCommand("SO_Insert_OPCOfflineTransaction");
command.SetParameterValue(info);
command.ExecuteNonQuery();
int result = command.ExecuteScalar <int>();
return(result);
}
private int SaveOPCTransaction(int soSysNo, int stockSysNo, int OPCOfflineMasterID, string companyCode)
{
OPCOfflineTransactionInfo info = new OPCOfflineTransactionInfo();
info.StockSysNo = stockSysNo;
info.Status = OPCTransStatus.Origin;
info.SOSysNo = soSysNo;
info.InUser = string.Empty;
info.OperationFlag = string.Empty;
info.MasterID = OPCOfflineMasterID;
info.InDate = DateTime.Now;
info.CompanyCode = companyCode;
return(OPCDA.InsertOPCOfflineTransaction(info));
}