修改测试

bklLiudl

2024-07-23 675b8bcc4a3630d95e3d0b97d933e63442075ecb

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
134
135
136
137
138
139
140
141
142
143
144
145
146
147
using Common;
using Model;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
 
namespace BLL.DAL
{
  public  class DALPltOutDetail
    {
        public bool Add(List<StorePalno> EMats)
        {
            bool result = false;
            try
            {
                //IList<ErpMat> ls = new List<ErpMat>();
                List<SqlParam> para = new List<SqlParam>();
                StringBuilder strSql = new StringBuilder();
 
                strSql.Append(" Insert into ErpOutDetail (OrdNo,Palno,Addre,CurQuant,Demo,Lever) values ");
 
 
                for (int i = 0; i < EMats.Count; i++)
                {
                    strSql.Append("(@OrdNo" + i + ",");
                    para.Add(new SqlParam("@OrdNO" + i, EMats[i].OrdNo));
 
                   
 
                    strSql.Append("@Palno" + i + ",");
                    para.Add(new SqlParam("@Palno" + i, EMats[i].Palno));
 
                    strSql.Append("@Addre" + i + ",");
                    para.Add(new SqlParam("@Addre" + i, EMats[i].Addre));
 
                    //lijiangang新增：更改货位状态为待出库
                    StringBuilder Sql = new StringBuilder();
                    Sql.Append("update DepotsLocation set TurnoverDemand='04' where LocationCode='" + EMats[i].Addre + "'");
                    DataFactory.SqlDataBase().ExecuteBySql(Sql);
 
                    strSql.Append("@CurQuant" + i + ",");
                    para.Add(new SqlParam("@CurQuant" + i, EMats[i].CurQuant));
 
                    strSql.Append("@Demo" + i + ",");
                    para.Add(new SqlParam("@Demo" + i, EMats[i].Demo));
 
                    strSql.Append("@Lever" + i + "),");
                    para.Add(new SqlParam("@Lever" + i, EMats[i].Lever));
 
                  
                }
 
                SqlParam[] param = null;
                if (para != null)
                {
 
                    strSql.Remove(strSql.Length - 1, 1);
                    param = para.ToArray();
                }
                int dt = DataFactory.SqlDataBase().ExecuteBySql(strSql, param);
 
 
                if (EMats.Count == dt) result = true;
 
                return result;
            }
            catch
            {
                return result;
            }
        }
        public bool Update(List<StorePalno> model)
        {
            bool result = false;
            try
            {
 
                if (!this.Delete(model)) return false;
 
                if (!this.Add(model)) return false;
 
                return true;
 
            }
            catch
            {
                return result;
            }
        }
        public bool Delete(List<StorePalno> EMats)
        {
            bool result = false;
            try
            {
                List<SqlParam> para = new List<SqlParam>();
                StringBuilder strSql = new StringBuilder();
                StringBuilder sp1 = new StringBuilder();
                StringBuilder sp2 = new StringBuilder();
 
                strSql.Append(" DELETE FROM ErpOutDetail where ");
 
                int i;
                sp1.Append(" OrdNo =  ");
                //sp2.Append("  Palno in ( ");
                for (i = 0; i < EMats.Count; i++)
                {
                    if (i == 0)
                    {
                        sp1.Append(" @OrdNo ");
                        para.Add(new SqlParam("@OrdNO", EMats[i].OrdNo));
                    }
 
                    //sp2.Append("@Palno" + i + ",");
                    //para.Add(new SqlParam("@Palno" + i, EMats[i].Palno));
                }
 
 
 
                if (i > 0)
                {
                    //sp1.Append(" and  ");
                    //sp2.Append(" )");
                    strSql.Append(sp1);
 
                    //strSql.Append(sp2.Remove(sp2.Length - 3, 1));
 
                    SqlParam[] param = null;
                    param = para.ToArray();
                  
                    int dt = DataFactory.SqlDataBase().ExecuteBySql(strSql, param);
 
 
                    if (EMats.Count == dt) result = true;
 
                }
                return true;
            }
            catch
            {
                return result;
            }
        }
    }
}