提交

username@email.com

2025-05-21 a980cd04341d71216e0f59bd4b7327fe9fc50032

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using CY.IDAL.Inquiry;
using CY.Infrastructure.Common;
using System.Transactions;
using CY.Model;
using System.Data.SqlClient;
using System.Data;
using CY.Model.Inquiry;
 
namespace CY.SQLDAL
{
    /// <summary>
    /// 粘信封操作接口--SQL实现
    /// </summary>
    public class StickEnvelopeCostDAL : IStickEnvelopeCostDAL
    {
        Database _dataBase = null;
 
        public StickEnvelopeCostDAL()
        {
            _dataBase = new Database();
        }
 
        public IList<Model.Inquiry_StickEnvelopeCost> GetModelList(Guid inquiryId, int printingTyId, int afterParameterId)
        {
            string selectTarget = "  a.EnvelopeModeTypeId,b.Name AS EnvelopeModeTypeName,a.Price,a.StartPrice ";
            string fromSouce = " Inquiry_StickEnvelopeCost a INNER JOIN  SysInquiry_PaperSizeDetail b ON a.EnvelopeModeTypeId=b.KeyId ";
            string condition = "  a.FirmId='" + inquiryId.ToString() + "' and a.PrintingTypeId='" + printingTyId + "' and a.afterParameterId=" + afterParameterId + " ORDER BY b.Name DESC ";
            IList<Model.Inquiry_StickEnvelopeCost> result = _dataBase.SelectModel<Model.Inquiry_StickEnvelopeCost>(selectTarget, fromSouce, condition);
            return result;
        }
 
        public bool SaveModelList(IList<Model.Inquiry_StickEnvelopeCost> list, InquiryCondition inquiryCondition, int printingTyId)
        {
            bool isSuccess = true;
            using (TransactionScope scope = new TransactionScope())
            {
                //执行复制全部询价参数数据
                if (inquiryCondition.IsFirstSave())
                {
                    new CommonInquiryHelper(_dataBase).CopyALLInquiryParameter(inquiryCondition);
                }
 
                foreach (Inquiry_StickEnvelopeCost model in list)
                {
                    isSuccess = UpdateModel(model);
                    if (!isSuccess)
                        break;
                }
                if (isSuccess)
                    scope.Complete();
            }
            return isSuccess;
 
        }
 
        /// <summary>
        /// 判断是否存在粘信封设置
        /// </summary>
        /// <param name="model"></param>
        /// <param name="firmId"></param>
        /// <param name="customerId"></param>
        /// <returns></returns>
        public bool IsExitsModel(Guid firmId, Guid customerId, int printingTypeId)
        {
            string selectTarget = " KeyId ";
            string fromSouce = " Inquiry_StickEnvelopeCost ";
            string condition = string.Empty;
            if (customerId == Guid.Empty)
            {
                condition = " FirmId='" + firmId.ToString() + "' AND CostomerId  is null and PrintingTypeId='" + printingTypeId + "' ";
            }
            else
            {
                condition = " FirmId='" + firmId.ToString() + "' AND CostomerId ='" + customerId.ToString() + "' and PrintingTypeId='" + printingTypeId + "' ";
            }
            IList<Model.Inquiry_StickEnvelopeCost> result = _dataBase.SelectModel<Model.Inquiry_StickEnvelopeCost>(selectTarget, fromSouce, condition);
            if (result == null || result.Count == 0)
                return false;
            else
                return true;
        }
 
        public bool InserModel(Infrastructure.Domain.IAggregateRoot model)
        {
            return true;
        }
 
        public bool UpdateModel(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.Inquiry_StickEnvelopeCost trueModel = model as Model.Inquiry_StickEnvelopeCost;
            if (trueModel == null)
            {
                return false;
            }
            SqlParameter[] parameters = {
                    new SqlParameter("@FirmId", SqlDbType.UniqueIdentifier,16),
                    new SqlParameter("@PrintingTypeId", SqlDbType.Int,4),
                    new SqlParameter("@EnvelopeModeTypeId", SqlDbType.Int,4),
                    new SqlParameter("@Price", SqlDbType.Money,8),
                    new SqlParameter("@StartPrice", SqlDbType.Money,8),
                    new SqlParameter("@Operater", SqlDbType.VarChar,20),
                    new SqlParameter("@LastUpdateTime", SqlDbType.DateTime),
                    new SqlParameter("@AfterParameterId", SqlDbType.Int,4) 
            };
            parameters[0].Value = trueModel.FirmId;
            parameters[1].Value = trueModel.PrintingTypeId;
            parameters[2].Value = trueModel.EnvelopeModeTypeId;
            parameters[3].Value = trueModel.Price;
            parameters[4].Value = trueModel.StartPrice;
            parameters[5].Value = trueModel.Operater;
            parameters[6].Value = trueModel.LastUpdateTime;
            parameters[7].Value = trueModel.AfterParameterId;
            try
            {
                _dataBase.Query("Inquiry_StickEnvelopeCost_Update", CommandType.StoredProcedure, parameters);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }
 
        public bool DeleteModel(Infrastructure.Domain.IAggregateRoot model)
        {
            throw new NotImplementedException();
        }
    }
}