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")); }