username@email.com
2025-05-12 ae6e40362a745caef9ead36f81f38313fb8c2c66
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
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using CY.Model;
using CY.Infrastructure.Query;
using CY.BLL.OA;
using CY.Infrastructure.Common;
using System.Data;
 
namespace CY.WebForm.Pages.procurement
{
    public partial class SpecificationEdit : BasePage
    {
        OA_CommoditySpeciAssociateBLL _OA_CommoditySpeciAssociateBLL = null;
        OA_Specification specification = null;
        OA_SpecificationBLL _OA_SpecificationBLL = null;
        OA_CommodityBLL _OA_CommodityBLL = null;
        OA_GoodsInfoBLL _OA_GoodsInfoBLL = null;
        OA_BrandBLL _OA_BrandBLL = null;
        
        public SpecificationEdit()
        {
            _OA_BrandBLL = new OA_BrandBLL();
            _OA_CommoditySpeciAssociateBLL = new OA_CommoditySpeciAssociateBLL();
            _OA_CommodityBLL = new OA_CommodityBLL();
            specification = new OA_Specification();
            _OA_SpecificationBLL = new OA_SpecificationBLL();
            _OA_GoodsInfoBLL = new OA_GoodsInfoBLL();
        }
 
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                this.txtOrderNum.Value = _OA_BrandBLL.GetMaxOrderNum(CurrentUser.MemberId, " OA_Specification ");
                DataTable ds = _OA_CommodityBLL.SelectModelPage(CurrentUser.MemberId, "", "true");
                GetDataByLevel(dwCommity, ds, 0, 0);
                ChangeSelBrand(dwCommity.SelectedValue);
                if (Request["EditKeyid"].ToInt32() > 0)
                    InitialData();
            }
        }
 
        protected void InitialData()
        {
            specification = _OA_SpecificationBLL.getSingleSpecification(Request["EditKeyid"].ToString2());
            if (specification != null)
            {
                this.txtSpecificationName.Value = specification.Name;
                this.dwCommity.SelectedValue = specification.CommodityId.ToString2();
                ChangeSelBrand(specification.CommodityId.ToString2());
                this.dwGoodsid.SelectedValue = specification.GoodsId.ToString2();
                this.txtOrderNum.Value = specification.OrderNum.ToString2();
            }
            else
            {
                this.txtSpecificationName.Value = "";
                this.txtOrderNum.Value = _OA_BrandBLL.GetMaxOrderNum(CurrentUser.MemberId, " OA_Specification ");
            }
        }
 
        public static void GetDataByLevel(System.Web.UI.WebControls.DropDownList dwCommity, DataTable data, int parentId, int level)
        {
            DataRow[] result = data.Select(string.Format("ParentId={0}", parentId));
            int i = -1;
            while (++i < result.Length)
            {
                dwCommity.Items.Add(new ListItem(GetSplitChar(level) + result[i]["CommodityName"].ToString2(), result[i]["Keyid"].ToString2()));
                GetDataByLevel(dwCommity, data, result[i]["Keyid"].ToInt32().Value, level + 1);
 
            }
        }
 
        public static string GetSplitChar(int level)
        {
            string splitchar = "";
            int i = -1;
            while (++i < level)
            {
                splitchar += ".";
            }
            return splitchar;
        }
        
        protected void btn_Submit_Click(object sender, EventArgs e)
        {
            if (Request["EditKeyid"].ToInt32() > 0)
            {
                specification = _OA_SpecificationBLL.getSingleSpecification(Request["EditKeyid"].ToString2());
            }
            specification.FirmId = CurrentUser.MemberId;
            specification.LastUpdateTime = DateTime.Now;
            specification.Name = txtSpecificationName.Value;
            specification.Operator = CurrentUser.ShortName;
            specification.CommodityId = this.dwCommity.SelectedValue.ToInt32();
            specification.GoodsId = this.dwGoodsid.SelectedValue.ToInt32();
            specification.Remark = "";
            specification.OrderNum = this.txtOrderNum.Value.ToInt32();
            if (Request["EditKeyid"].ToInt32() > 0)
            {
                if (_OA_SpecificationBLL.UpdateModel(specification, dwCommity.SelectedValue))
                    JavaScript.MessageBoxCloseAndRefreshFirst("更新成功", this);
                else
                    JavaScript.MessageBox("更新失败", this);
            }
            else
            {
                if (_OA_SpecificationBLL.InsertModel(specification, this.dwCommity.SelectedValue))
                {
                    InitialData();
                    JavaScript.MessageBox("添加成功", this,false,true);
                }
                else
                    JavaScript.MessageBox("添加失败", this);
            }
        }
 
        protected void dwCommity_SelectedIndexChanged(object sender, EventArgs e)
        {
            this.dwGoodsid.DataSource = _OA_GoodsInfoBLL.SlectModleByCommity(this.dwCommity.SelectedValue, CurrentUser.MemberId);
            this.dwGoodsid.DataValueField = "Keyid";
            this.dwGoodsid.DataTextField = "GoodsName";
            this.dwGoodsid.DataBind();
        }
 
        protected void ChangeSelBrand(string CommodityId)
        {
            this.dwGoodsid.DataSource = _OA_GoodsInfoBLL.SlectModleByCommity(CommodityId, CurrentUser.MemberId);
            this.dwGoodsid.DataValueField = "Keyid";
            this.dwGoodsid.DataTextField = "GoodsName";
            this.dwGoodsid.DataBind();
        }
    }
}