test/Member/CoreEntity/DAL/PushOrderDAL.cs

using Common.Wechat;
using CoreEntity.Entity;
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Text;
using ZcPeng.PublicLibrary;

namespace CoreEntity.DAL
{
    public class PushOrderDAL
    {
        public static int AddPushOrderMT(string PushAccountId,PurOrderMTEx PurOrderMT,ref List<DataAccessCommand> listcmd ,out string Id,string LoginAccountId = "1")
        {
            #region 添加推送记录
            string commandTextRecord = "INSERT INTO " + Config.TablePrefix
            + "PushOrderMT (" +
            "Id," +
            "EntId," +
            "Remark,PushAccountId,K_ContactId,BillCode,BillNo,IsConfirm,PushDate,PushTime,CreationPerson)"
            + " VALUES (" +
            "@Id," +
            "@EntId," +
            "@Remark,@PushAccountId,@K_ContactId,@BillCode,@BillNo,@IsConfirm,@PushDate,@PushTime,@CreationPerson)";

            //准备参数
            Guid PushRecordId = Guid.NewGuid();
            List<List<Object>> parametersRecord = new List<List<Object>>();
            Id = Guid.NewGuid().ToString();
            parametersRecord.Add(new List<Object>(2) { "Id", Id });
            parametersRecord.Add(new List<Object>(2) { "EntId", PurOrderMT.EntId });

            parametersRecord.Add(new List<Object>(2) { "Remark", "" });
            parametersRecord.Add(new List<Object>(2) { "PushAccountId", PushAccountId });
            parametersRecord.Add(new List<Object>(2) { "K_ContactId", PurOrderMT.K_ContactId});
            parametersRecord.Add(new List<Object>(2) { "BillCode", PurOrderMT.BillCode });
            parametersRecord.Add(new List<Object>(2) { "BillNo", PurOrderMT.BillNo });
            parametersRecord.Add(new List<Object>(2) { "IsConfirm", 'N' });
            parametersRecord.Add(new List<Object>(2) { "PushDate", DateTime.Now.ToString("yyyy-MM-dd") });
            parametersRecord.Add(new List<Object>(2) { "PushTime", DateTime.Now.ToString("T") });
            parametersRecord.Add(new List<Object>(2) { "CreationPerson", LoginAccountId });

            List<SqlParameter> parametersRecord1 = DataAccess.ToParameters(parametersRecord);
            listcmd.Add(new DataAccessCommand(commandTextRecord, parametersRecord1,System.Data.CommandType.Text,true));
            #endregion
            return 1;
        }

        public static int AddPushOrderDT(string PushAccountId,string OrderMTId, PurOrderMTEx PurOrderMT, PurOrderDTEx PurOrderDT, ref List<DataAccessCommand> listcmd, string LoginAccountId = "1") {
            //添加推送明细
            #region 添加推送明细
            string commandText = "INSERT INTO " + Config.TablePrefix
            + "PushOrderDT (Id," +
            "EntId," +
            "PushOrderMTId," +
            "PushAccountId,K_ContactId," +
            "BillNo,BillSn," +
            "BusinessId,BusinessName," +
            "GoodsId" +
            ",GoodsName,GoodsCode" +
            ",GoodsSpec,Manufacturer" +
            ",Num,Amount,Price,TaxPrice" +
            ",Remark" +
            ",CreationPerson)"
            + " VALUES (@Id," +
            "@EntId," +
            "@PushOrderMTId," +
            "@PushAccountId,@K_ContactId," +
            "@BillNo,@BillSn," +
            "@BusinessId,@BusinessName" +
            ",@GoodsId" +
            ",@GoodsName,@GoodsCode" +
            ",@GoodsSpec,@Manufacturer" +
            ",@Num,@Amount,@Price,@TaxPrice" +
            ",@Remark" +
            ",@CreationPerson)";

            //准备参数
            List<List<Object>> parameters = new List<List<Object>>();
            parameters.Add(new List<Object>() { "Id", Guid.NewGuid() });
            parameters.Add(new List<Object>() { "EntId", PurOrderDT.EntId });
            parameters.Add(new List<Object>() { "PushOrderMTId", OrderMTId });

            parameters.Add(new List<Object>() { "PushAccountId", PushAccountId });
            parameters.Add(new List<Object>() { "K_ContactId", PurOrderMT.K_ContactId });

            parameters.Add(new List<Object>() { "BillNo", PurOrderDT.BillNo });
            parameters.Add(new List<Object>() { "BillSn", PurOrderDT.BillSn });

            parameters.Add(new List<Object>() { "BusinessId", PurOrderMT.SuppliersId });
            parameters.Add(new List<Object>() { "BusinessName", PurOrderMT.BusinessName });

            parameters.Add(new List<Object>() { "GoodsId", PurOrderDT.GoodsId });
            parameters.Add(new List<Object>() { "GoodsName", PurOrderDT.GoodsName });
            parameters.Add(new List<Object>() { "GoodsCode", PurOrderDT.GoodsCode });
            parameters.Add(new List<Object>() { "GoodsSpec", PurOrderDT.GoodsSpec });
            parameters.Add(new List<Object>() { "Manufacturer", PurOrderDT.Manufacturer });

            parameters.Add(new List<Object>() { "Num", PurOrderDT.Num });
            parameters.Add(new List<Object>() { "Amount", PurOrderDT.Amount });
            parameters.Add(new List<Object>() { "Price", PurOrderDT.Price });
            parameters.Add(new List<Object>() { "TaxPrice", PurOrderDT.Taxprice });

            parameters.Add(new List<Object>() { "Remark", PurOrderDT.Remark });
            parameters.Add(new List<Object>() { "CreationPerson", LoginAccountId });

            List<SqlParameter> parameters1 = DataAccess.ToParameters(parameters);
            listcmd.Add(new DataAccessCommand(commandText, parameters1, System.Data.CommandType.Text, true));
            #endregion
            return 1;
        }


        public static int AddPaidBackMsg(string PushAccountId, sup_PushPaidBackMsg paidBackMsg, ref List<DataAccessCommand> listcmd, out int Id, string LoginAccountId = "1")
        {
            #region 添加推送记录
            string commandTextRecord = "INSERT INTO " + Config.TablePrefix
            + "PaidBackMsg (" +
            "EntId,PushAccountId," +
            "AttachId,PicName,PicTypeId,K_OnlyId,K_ContactId,IsConfirm,ReBillNo,PushDate,PushTime,CreationPerson)"
            + " VALUES (" +
            "@EntId,@PushAccountId," +
            "@AttachId,@PicName,@PicTypeId,@K_OnlyId,@K_ContactId,@IsConfirm,@ReBillNo,@PushDate,@PushTime,@CreationPerson)";

            //准备参数
            List<List<Object>> parametersRecord = new List<List<Object>>();
            parametersRecord.Add(new List<Object>(2) { "EntId", paidBackMsg.ENTID });

            parametersRecord.Add(new List<Object>(2) { "PushAccountId", PushAccountId });
            parametersRecord.Add(new List<Object>(2) { "AttachId", paidBackMsg.ATTACHID });
            parametersRecord.Add(new List<Object>(2) { "PicName", paidBackMsg.PICNAME });
            parametersRecord.Add(new List<Object>(2) { "PicTypeId", paidBackMsg.PICTYPEID });
            parametersRecord.Add(new List<Object>(2) { "K_OnlyId", paidBackMsg.K_OnlyId });
            parametersRecord.Add(new List<Object>(2) { "K_ContactId", paidBackMsg.K_ContactId });
            parametersRecord.Add(new List<Object>(2) { "IsConfirm", 'N' });
            parametersRecord.Add(new List<Object>(2) { "ReBillNo", paidBackMsg.ReBillNo });
            parametersRecord.Add(new List<Object>(2) { "PushDate", DateTime.Now.ToString("yyyy-MM-dd") });
            parametersRecord.Add(new List<Object>(2) { "PushTime", DateTime.Now.ToString("T") });
            parametersRecord.Add(new List<Object>(2) { "CreationPerson", LoginAccountId });

            List<SqlParameter> parametersRecord1 = DataAccess.ToParameters(parametersRecord);
            listcmd.Add(new DataAccessCommand(commandTextRecord, parametersRecord1, System.Data.CommandType.Text, true));
            #endregion
            Id = BaseDAL.GetId("sup_PaidBackMsg");
            return 1;
        }
    }
}