public string fnChange(PurchaseM purchaseM, string sIP)
{
string sSql = " UPDATE [dbo].[MNDTpurchase_master] " +
" SET [complete] = 'Y' " +
" WHERE [order_id] = '" + purchaseM.order_id + "' ";
PurchaseMTran purchaseMTran = new PurchaseMTran();
purchaseMTran.OrderId(purchaseM.order_id)
.IP(sIP)
.Status("M")
.CreateId(purchaseM.create_id);
sSql += fnInsertSql(purchaseMTran);
return(PublicApi.fnExecuteSQL(sSql, "MNDT"));
}
public string fnUpdate(PurchaseM purchaseM, string sIP)
{
string sSql = " UPDATE [dbo].[MNDTpurchase_master] " +
" SET [id] = '" + purchaseM.id + "' " +
" ,[datetime] = '" + purchaseM.datetime + "' " +
" ,[complete] = '" + purchaseM.complete + "' " +
" ,[status] = '" + purchaseM.status + "' " +
" ,[description] = '" + purchaseM.description + "' " +
" WHERE [order_id] = '" + purchaseM.order_id + "' ";
PurchaseMTran purchaseMTran = new PurchaseMTran();
purchaseMTran.OrderId(purchaseM.order_id)
.IP(sIP)
.Status("D")
.CreateId(purchaseM.create_id);
sSql += fnInsertSql(purchaseMTran);
return(PublicApi.fnExecuteSQL(sSql, "MNDT"));
}
