public string fnDelete(SReturnM sreturnM, string sIP)
{
string sSql =
" UPDATE [MNDTSreturn_master] " +
" SET [status] = 'D' " +
" WHERE [return_id] = '" + sreturnM.return_id + "' ";
SReturnMTran sreturnMTran = new SReturnMTran();
sreturnMTran.ReturnId(sreturnM.return_id)
.IP(sIP)
.Status("D")
.CreateId(sreturnM.create_id);
sSql += fnInsertSql(sreturnMTran);
return(PublicApi.fnExecuteSQL(sSql, "MNDT"));
}
public string fnUpdate(SReturnM sreturnM, string sIP)
{
string sSql = " UPDATE [dbo].[MNDTSreturn_master] " +
" SET [id] = '" + sreturnM.id + "' " +
" ,[order_id] = '" + sreturnM.order_id + "' " +
" ,[datetime] = '" + sreturnM.datetime + "' " +
" ,[complete] = '" + sreturnM.complete + "' " +
" ,[status] = '" + sreturnM.status + "' " +
" ,[description] = '" + sreturnM.description + "' " +
" WHERE [return_id] = '" + sreturnM.return_id + "' ";
SReturnMTran sreturnMTran = new SReturnMTran();
sreturnMTran.ReturnId(sreturnM.return_id)
.IP(sIP)
.Status("M")
.CreateId(sreturnM.create_id);
sSql += fnInsertSql(sreturnMTran);
return(PublicApi.fnExecuteSQL(sSql, "MNDT"));
}