コード例 #1
0
    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"));
    }
コード例 #2
0
    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"));
    }
コード例 #3
0
    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"));
    }