public string fnDelete(ReceiveM receiveM, string sIP)
{
string sSql =
" UPDATE [MNDTreceive_master] " +
" SET [status] = 'D' " +
" WHERE [order_id] = '" + receiveM.order_id + "' ";
ReceiveMTran receiveMTran = new ReceiveMTran();
receiveMTran.OrderId(receiveM.order_id)
.IP(sIP)
.Status("D")
.CreateId(receiveM.create_id);
sSql += fnInsertSql(receiveMTran);
return(PublicApi.fnExecuteSQL(sSql, "MNDT"));
}
public string fnUpdate(ReceiveM receiveM, string sIP)
{
string sSql = " UPDATE [dbo].[MNDTreceive_master] " +
" SET [id] = '" + receiveM.id + "' " +
" ,[datetime] = '" + receiveM.datetime + "' " +
" ,[complete] = '" + receiveM.complete + "' " +
" ,[status] = '" + receiveM.status + "' " +
" ,[description] = '" + receiveM.description + "' " +
" WHERE [order_id] = '" + receiveM.order_id + "' ";
ReceiveMTran receiveMTran = new ReceiveMTran();
receiveMTran.OrderId(receiveM.order_id)
.IP(sIP)
.Status("M")
.CreateId(receiveM.create_id);
sSql += fnInsertSql(receiveMTran);
return(PublicApi.fnExecuteSQL(sSql, "MNDT"));
}
public string fnChange(ReceiveM receiveM, string sIP)
{
string sSql =
" UPDATE [dbo].[MNDTreceive_master] " +
" SET [complete] = 'Y' " +
" WHERE [order_id] = '" + receiveM.order_id + "' " +
" UPDATE [dbo].[MNDTreceive_details] " +
" SET [complete] = 'Y' " +
" WHERE [order_id] = '" + receiveM.order_id + "' ";
ReceiveMTran receiveMTran = new ReceiveMTran();
receiveMTran.OrderId(receiveM.order_id)
.IP(sIP)
.Status("M")
.CreateId(receiveM.create_id);
sSql += fnInsertSql(receiveMTran);
return(PublicApi.fnExecuteSQL(sSql, "MNDT"));
}