123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148 |
- 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;
- }
- }
- }
|