test/Member/SupplierWeb/Controllers/InvoiceController.cs

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Threading.Tasks;
using Common.Wechat;
using JCSoft.WX.Framework.Api;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Caching.Memory;
using ZcPeng.PublicLibrary;

namespace SupplierWeb.Controllers
{
    /// <summary>
    /// 采购员查询发票
    /// </summary>
    [Route("web/invoice")]
    [ApiController]
    public class InvoiceController : BaseController
    {

        public InvoiceController(IMemoryCache cache, IApiClient client) : base(cache, client)
        {
        }



        ////查看发票签收状态，付款状态
        [HttpPost, Route("orderinvoice")]
        public ActionResult OrderInvoice(string echostr, string signature, string timestamp, string nonce)
        {

            return View();
        }

        ////订单发票发货后  录入物流单号
        [HttpPost, Route("addinvoiceshipment")]
        public JsonResult AddInvoiceShipment(string k_kdcode, DateTime k_qrdates,
            string BillNo,
            [FromBody] dynamic data)
        {
            if (data != null)
            {
                k_kdcode = data.k_kdcode;
                k_qrdates = data.k_qrdates == null ? DateTime.Now.ToString("yyyy-MM-dd") : data.k_qrdates.ToString("yyyy-MM-dd");
                BillNo = data.BillNo;
            }


            #region 添加发货记录
            string commandText = "INSERT INTO " + Config.TablePrefix + "PurOrderInvoice " +
                "(BillNo,k_kdcode,k_qrdates)"
                + " VALUES (@BillNo,@k_isbh,@k_kdcode,@k_qrdates,@k_xspay)";
            string resultInsert;
            //准备参数
            List<List<Object>> parameters = new List<List<Object>>(3);
            parameters.Add(new List<Object>() { "BillNo", BillNo });
            parameters.Add(new List<Object>() { "k_kdcode", k_kdcode });
            parameters.Add(new List<Object>() { "k_qrdates", k_qrdates });

            List<SqlParameter> parameters1 = DataAccess.ToParameters(parameters);
            int successInsert = DataAccess.ExecuteCommand(commandText, parameters1, out resultInsert);
            #endregion


            return Json(new
            {
                success = true,
                successInsert = successInsert,
                resultInsert = resultInsert,
            });
        }

    }
}