Quản lý website giới thiệu và bán điện thoại di động ASP.net
20.634 lượt xem;
1 using System;
2 using System.Data;
3 using System.Configuration;
4 using System.Linq;
5 using System.Web;
6 using System.Web.Security;
7 using System.Data.OleDb;
8 using System.Web.UI;
9 using System.Web.UI.HtmlControls;
10 using System.Web.UI.WebControls;
11 using System.Web.UI.WebControls.WebParts;
12 using System.Xml.Linq;
13
14 /// <summary>
15 /// Summary description for GioHang
16 /// </summary>
17 public class GioHangData
18 {
19 DataTable dt;
20 public GioHangData()
21 {
22 dt = new DataTable();
23 dt.Columns.Add("Anh");
24 dt.Columns.Add("TenSP");
25 dt.Columns.Add("SoLuong");
26 dt.Columns.Add("Gia");
27 dt.Columns.Add("TongGia");
28 dt.Columns.Add("masp");
29 }
30
31 public DataTable setTable()
32 {
33 return this.dt;
34 }
35
36 public DataTable dienVaoBang(DataTable tb, string Anh, string TenSP, double soluong, double gia, string masp)
37 {
38 if (tb.Rows.Count != 0)
39 {
40 bool kiemtra = false;
41 foreach (DataRow dr in tb.Rows)
42 {
43 if (dr[1].ToString().Equals(TenSP))
44 {
45 dr[2] = Convert.ToDouble(dr[2].ToString()) + 1;
46 dr[4] = Convert.ToDouble(dr[2].ToString()) * gia;
47 kiemtra = true;
48 }
49 }
50 if (!kiemtra)
51 {
52 DataRow dr = tb.NewRow();
53 dr[0] = Anh;
54 dr[1] = TenSP;
55 dr[2] = soluong;
56 dr[3] = gia;
57 dr[4] = soluong * gia;
58 dr[5] = masp;
59 tb.Rows.Add(dr);
60 }
61 }
62 else
63 {
64 DataRow dr = tb.NewRow();
65 dr[0] = Anh;
66 dr[1] = TenSP;
67 dr[2] = soluong;
68 dr[3] = gia;
69 dr[4] = soluong * gia;
70 dr[5] = masp;
71 tb.Rows.Add(dr);
72 }
73 return tb;
74 }
75
76 public DataTable xoaDong(DataTable tb, string tensp)
77 {
78 foreach (DataRow dr in tb.Rows)
79 {
80 if (dr[1].ToString().Equals(tensp))
81 {
82 tb.Rows.Remove(dr);
83 break;
84 }
85 }
86 return tb;
87 }
88
89 public DataTable capNhatlai(DataTable tb, double soluong, string tensp)
90 {
91 DataTable td = tb;
92 foreach (DataRow dr in td.Rows)
93 {
94 if (tensp.Trim().Equals(dr[1].ToString().Trim()))
95 {
96 dr[2] = soluong;
97 dr[4] = double.Parse(dr[3].ToString()) * soluong;
98 }
99 }
100 return td;
101 }
102 }
2 using System.Data;
3 using System.Configuration;
4 using System.Linq;
5 using System.Web;
6 using System.Web.Security;
7 using System.Data.OleDb;
8 using System.Web.UI;
9 using System.Web.UI.HtmlControls;
10 using System.Web.UI.WebControls;
11 using System.Web.UI.WebControls.WebParts;
12 using System.Xml.Linq;
13
14 /// <summary>
15 /// Summary description for GioHang
16 /// </summary>
17 public class GioHangData
18 {
19 DataTable dt;
20 public GioHangData()
21 {
22 dt = new DataTable();
23 dt.Columns.Add("Anh");
24 dt.Columns.Add("TenSP");
25 dt.Columns.Add("SoLuong");
26 dt.Columns.Add("Gia");
27 dt.Columns.Add("TongGia");
28 dt.Columns.Add("masp");
29 }
30
31 public DataTable setTable()
32 {
33 return this.dt;
34 }
35
36 public DataTable dienVaoBang(DataTable tb, string Anh, string TenSP, double soluong, double gia, string masp)
37 {
38 if (tb.Rows.Count != 0)
39 {
40 bool kiemtra = false;
41 foreach (DataRow dr in tb.Rows)
42 {
43 if (dr[1].ToString().Equals(TenSP))
44 {
45 dr[2] = Convert.ToDouble(dr[2].ToString()) + 1;
46 dr[4] = Convert.ToDouble(dr[2].ToString()) * gia;
47 kiemtra = true;
48 }
49 }
50 if (!kiemtra)
51 {
52 DataRow dr = tb.NewRow();
53 dr[0] = Anh;
54 dr[1] = TenSP;
55 dr[2] = soluong;
56 dr[3] = gia;
57 dr[4] = soluong * gia;
58 dr[5] = masp;
59 tb.Rows.Add(dr);
60 }
61 }
62 else
63 {
64 DataRow dr = tb.NewRow();
65 dr[0] = Anh;
66 dr[1] = TenSP;
67 dr[2] = soluong;
68 dr[3] = gia;
69 dr[4] = soluong * gia;
70 dr[5] = masp;
71 tb.Rows.Add(dr);
72 }
73 return tb;
74 }
75
76 public DataTable xoaDong(DataTable tb, string tensp)
77 {
78 foreach (DataRow dr in tb.Rows)
79 {
80 if (dr[1].ToString().Equals(tensp))
81 {
82 tb.Rows.Remove(dr);
83 break;
84 }
85 }
86 return tb;
87 }
88
89 public DataTable capNhatlai(DataTable tb, double soluong, string tensp)
90 {
91 DataTable td = tb;
92 foreach (DataRow dr in td.Rows)
93 {
94 if (tensp.Trim().Equals(dr[1].ToString().Trim()))
95 {
96 dr[2] = soluong;
97 dr[4] = double.Parse(dr[3].ToString()) * soluong;
98 }
99 }
100 return td;
101 }
102 }