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