-
Notifications
You must be signed in to change notification settings - Fork 0
/
SupplierUser.cs
135 lines (132 loc) · 4.09 KB
/
SupplierUser.cs
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
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using eBooking.DBAccess;
namespace eBooking
{
/// <summary>
/// 供应商
/// </summary>
public partial class SupplierUser : Form
{
public DataSet SYds = new DataSet();
public int SYId=-1;
public int indexer = -1;
public int UserId = -1;
#region 初始化构造函数
public SupplierUser()
{
InitializeComponent();
this.dataGridView1.AutoGenerateColumns = true;
SYds = SceneryAccess.ShowScenery();
if (SYds != null)
{
this.dataGridView1.DataSource = SYds.Tables[0];
}
}
public SupplierUser(int userId)
{
InitializeComponent();
UserId = userId;
this.dataGridView1.AutoGenerateColumns = true;
SYds = SceneryAccess.ShowSceneryById(UserId);
if (SYds != null)
{
this.dataGridView1.DataSource = SYds.Tables[0];
}
this.lbUser.Text = UserId + "";
}
#endregion
/// <summary>
/// 增加景点
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void lbAdd_Click(object sender, EventArgs e)
{
this.Visible = false;
SceneryAdd sceneryAdd = new SceneryAdd(UserId);
sceneryAdd.Show();
}
/// <summary>
/// 根据鼠标的点击选出当前行的数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex == -1)
{
return;
}
else
{
int index = dataGridView1.CurrentRow.Index;
SYId = Convert.ToInt32(dataGridView1.Rows[index].Cells["景点ID"].Value);
this.tbSceneryId.Text = SYId + "";
indexer = e.RowIndex;
}
}
/// <summary>
/// 景点删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void lbDelete_Click(object sender, EventArgs e)
{
if (indexer != -1)
{
DialogResult dr = MessageBox.Show("确定删除景点ID为" + SYId + "景点吗?", "确定", MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes)
{
dataGridView1.DataSource = SYds.Tables[0];
bool isSuccess = SceneryAccess.DeleteScenery(SYId);
if (isSuccess)
{
MessageBox.Show("景点删除成功");
}
DataSet ds = SceneryAccess.ShowScenery();
dataGridView1.DataSource = ds.Tables[0];
if (ds != null)
{
this.Refresh();
}
}
}
else
{
MessageBox.Show("请选择要删除的景点....");
}
}
/// <summary>
/// 景点更新
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void lbUpdate_Click(object sender, EventArgs e)
{
if (SYId != -1)
{
this.Visible = false;
SceneryAdd sceneryAdd = new SceneryAdd(UserId,SYId);
sceneryAdd.Show();
}
}
/// <summary>
/// 返回登录界面
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void label2_Click(object sender, EventArgs e)
{
this.Visible = false;
Login login = new Login();
login.Show();
}
}
}