private void InitializeData()
{
this.dataGridView1.AutoGenerateColumns = true;
DTds = SceneryAccess.selectForDistributor(DTId);
if (DTds != null)
{
dataGridView1.DataSource = DTds.Tables[0];
}
this.dataGridView2.AutoGenerateColumns = true;
OAds = OrderAccess.ShowOrderForDistributor(DTId);
if (OAds != null)
{
this.dataGridView2.DataSource = OAds.Tables[0];
}
this.dataGridView3.AutoGenerateColumns = true;
SYds = SceneryAccess.ShowScenery();
if (SYds != null)
{
this.dataGridView3.DataSource = SYds.Tables[0];
}
this.dataGridView4.AutoGenerateColumns = true;
ASds1 = ApplySceneryAccess.selectForApply(DTId);
if (ASds1 != null)
{
this.dataGridView4.DataSource = ASds1.Tables[0];
}
}
/// <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("请选择要删除的景点....");
}
}
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 + "";
}
// public static int count;
public Homepage()
{
InitializeComponent();
Sum = SceneryAccess.SceneryCount();
if (Sum % 12 == 0)
{
Sum = Sum / 12;
}
else
{
Sum = Sum / 12 + 1;
}
}
/// <summary>
/// 景点更新或添加
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button2_Click(object sender, EventArgs e)
{
string SceneryName = this.tbSceneryName.Text;
int Supplier = Convert.ToInt32(this.tbSupplierId.Text);
int price = Convert.ToInt32(this.tbPrice.Text);
string Introduce = this.tbIntroduce.Text;
int TotalNum = Convert.ToInt32(this.tbTKTotalNum.Text);
DateTime useTime = Convert.ToDateTime(this.dtpTKUseTime.Text);
string path = Path;
if (this.button2.Text == "更新")
{
Scenery scenery = new Scenery();
scenery.SYName = SceneryName;
scenery.SYSupplier = Supplier;
scenery.SYPrice = price;
scenery.SYIntroduec = Introduce;
scenery.SYImagSrc = path;
scenery.SYTotal = TotalNum;
scenery.SYUseTime = useTime;
scenery.SYId = SYId;
if (SceneryAccess.SceneryUpdateForSupplier(scenery))
{
MessageBox.Show("更新成功");
}
else
{
MessageBox.Show("更新失败！");
}
}
else
{
Scenery scenery = new Scenery();
scenery.SYName = SceneryName;
scenery.SYSupplier = Supplier;
scenery.SYPrice = price;
scenery.SYIntroduec = Introduce;
scenery.SYImagSrc = path;
scenery.SYTotal = TotalNum;
scenery.SYUseTime = useTime;
if (SceneryAccess.SceneryAdd(scenery))
{
MessageBox.Show("添加成功");
}
else
{
MessageBox.Show("添加失败！");
}
}
}
/// <summary>
/// 界面初始化
/// </summary>
private void Initlize()
{
scenery = SceneryAccess.SelectById(SYId);
this.tbSceneryName.Text = scenery.SYName;
this.tbIntroduce.Text = scenery.SYIntroduec;
this.tbPrice.Text = scenery.SYPrice + "";
this.tbSupplierId.Text = scenery.SYSupplier + "";
this.tbTKTotalNum.Text = scenery.SYTotal + "";
this.dtpTKUseTime.Text = scenery.SYUseTime + "";
Path = scenery.SYImagSrc;
if (Path != null)
{
pictureBox1.Image = Image.FromFile(Path);
}
}
public Homepage(int userID)
{
InitializeComponent();
UserId = userID;
this.lbLoginstate.Text = userID + "";
Sum = SceneryAccess.SceneryCount();
if (Sum % 12 == 0)
{
Sum = Sum / 12;
}
else
{
Sum = Sum / 12 + 1;
}
}
private void label1_Click_1(object sender, EventArgs e)
{
this.Visible = false;
if (indexer != -1)
{
Scenery scenery = new Scenery();
scenery = SceneryAccess.SelectById(SYId);
TicketInfo ticketInfo = new TicketInfo(scenery, DTId);
ticketInfo.Show();
}
else
{
MessageBox.Show("请选择要预订的门票");
DistributorUser distributor = new DistributorUser(DTId);
distributor.Show();
}
}
/// <summary>
/// 界面显示初始化
/// </summary>
private void InitializeDataSet()
{
this.dataGridView1.AutoGenerateColumns = true;
this.dataGridView2.AutoGenerateColumns = true;
this.dataGridView3.AutoGenerateColumns = true;
this.dataGridView4.AutoGenerateColumns = true;
this.dataGridView5.AutoGenerateColumns = true;
this.dataGridView6.AutoGenerateColumns = true;
this.dataGridView7.AutoGenerateColumns = true;
SPds = SupplierAccess.Select();
DTds = DistributorAccess.Select();
ACds = AdminAccess.ShowSupperUser();
RLds = RoleAccess.ShowRole();
ASds = ApplySceneryAccess.selectForApply();
RPds = RoleProductAccess.ShowRoleProduct();
SYds = SceneryAccess.ShowSceneryForSupper();
if (SPds != null)
{
dataGridView1.DataSource = SPds.Tables[0];
}
if (DTds != null)
{
dataGridView2.DataSource = DTds.Tables[0];
}
if (RLds != null)
{
dataGridView3.DataSource = RLds.Tables[0];
}
if (ACds != null)
{
dataGridView4.DataSource = ACds.Tables[0];
}
if (RPds != null)
{
dataGridView5.DataSource = RPds.Tables[0];
}
if (ASds != null)
{
dataGridView6.DataSource = ASds.Tables[0];
}
if (SYds != null)
{
dataGridView7.DataSource = SYds.Tables[0];
}
}
/// <summary>
/// 景点审核
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void label13_Click(object sender, EventArgs e)
{
if (SYId != 0)
{
if (SceneryAccess.SceneryPass(SYId))
{
MessageBox.Show("审核通过");
}
else
{
MessageBox.Show("审核失败");
}
}
else
{
MessageBox.Show("请选择景点ID，然后进行审核....");
}
}
private void showScenery(string sceneryName)
{
Scenery scenery = new Scenery();
List <Scenery> sceneryList = new List <Scenery>();
sceneryList = SceneryAccess.Search(sceneryName);
if (sceneryList.Count != 0 && sceneryList != null)
{
for (int i = 0; i < sceneryList.Count; i++)
{
scenery = sceneryList[i];
}
this.Visible = false;
TicketInfo ticketInfo = new TicketInfo(scenery, UserId);
ticketInfo.Show();
}
else
{
MessageBox.Show("暂时没有您要找的景点");
}
}
/// <summary>
/// 门票预订
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btBook_Click(object sender, EventArgs e)
{
if (scenery.SYUseNum >= scenery.SYTotal)
{
MessageBox.Show("当前时间的门票已售罄！");
}
else
{
Oreder order = new Oreder();
order.TKType = this.cbTicketType.SelectedIndex;
order.TKReserveTime = DateTime.Now;
order.TKUseTime = Convert.ToDateTime(this.dtpUseTime.Text);
order.TKNum = Convert.ToInt32(this.nudTicketNum.Value);
order.TKUserId = UserId;
order.TKSupplier = scenery.SYSupplier;
order.TKImagSrc = scenery.SYImagSrc;
order.TKPrice = Convert.ToInt32(this.lbPrice2.Text);
order.TKSYId = scenery.SYId;
#region 订票验证
if (order.TKNum != 0)
{
if (UserId != -1)
{
if (SceneryAccess.ShowSceneryByUseTime(order.TKUseTime))
{
if (this.cbTicketType.SelectedIndex != -1)
{
if (OrderAccess.AddOrder(order))
{
#region MyRegion
if (DistributorAccess.SelectById(UserId))
{
this.Visible = false;
DistributorUser distributorUser = new DistributorUser(UserId);
distributorUser.Show();
}
else
{
MessageBox.Show("预订成功！");
this.Visible = false;
Homepage homePage = new Homepage(UserId);
homePage.Show();
}
}
else
{
MessageBox.Show("订票失败！");
}
#endregion
}
else
{
MessageBox.Show("请选择票型");
}
}
else
{
MessageBox.Show("当前门票暂时没有上线，请晚些时候再来！");
}
}
else
{
MessageBox.Show("请登录后再订票！");
}
#endregion
}
else
{
MessageBox.Show("请选择预订数量！");
}
}
}
private void SceneryShow_Load(object sender, EventArgs e)
{
BindTreeView();
if (treeView1.Nodes.Count > 0)
{
treeView1.Nodes[0].Expand();
}
List <Scenery> sceneryList = new List <Scenery>();
sceneryList = SceneryAccess.ShowImag(1);
if (sceneryList.Count != 0 && sceneryList != null)
{
for (int i = 0; i < sceneryList.Count; i++)
{
Scenery scenery = new Scenery();
scenery = sceneryList[i];
switch (i)
{
case 0: this.pictureBox1.Image = Image.FromFile(scenery.SYImagSrc, false);
label1.Text = scenery.SYName;
break;
case 1: this.pictureBox2.Image = Image.FromFile(scenery.SYImagSrc, false);
label2.Text = scenery.SYName;
break;
case 2: this.pictureBox3.Image = Image.FromFile(scenery.SYImagSrc, false);
label3.Text = scenery.SYName;
break;
case 3: this.pictureBox4.Image = Image.FromFile(scenery.SYImagSrc, false);
label4.Text = scenery.SYName;
break;
case 4: this.pictureBox5.Image = Image.FromFile(scenery.SYImagSrc, false);
label5.Text = scenery.SYName;
break;
case 5: this.pictureBox6.Image = Image.FromFile(scenery.SYImagSrc, false);
label6.Text = scenery.SYName;
break;
case 6: this.pictureBox7.Image = Image.FromFile(scenery.SYImagSrc, false);
label7.Text = scenery.SYName;
break;
case 7: this.pictureBox8.Image = Image.FromFile(scenery.SYImagSrc, false);
label8.Text = scenery.SYName;
break;
case 8: this.pictureBox9.Image = Image.FromFile(scenery.SYImagSrc, false);
label9.Text = scenery.SYName;
break;
case 9: this.pictureBox10.Image = Image.FromFile(scenery.SYImagSrc, false);
label10.Text = scenery.SYName;
break;
case 10: this.pictureBox11.Image = Image.FromFile(scenery.SYImagSrc, false);
label11.Text = scenery.SYName; break;
case 11: this.pictureBox12.Image = Image.FromFile(scenery.SYImagSrc, false);
label12.Text = scenery.SYName;
break;
}
this.pictureBox1.Image = Image.FromFile(scenery.SYImagSrc, false);
}
}
}
private void ShowImage(int pageNum)
{
List <Scenery> sceneryList = new List <Scenery>();
sceneryList = SceneryAccess.ShowImag(pageNum);
if (sceneryList.Count != 0 && sceneryList != null)
{
for (int i = 0; i < sceneryList.Count; i++)
{
Scenery scenery = new Scenery();
scenery = sceneryList[i];
switch (i)
{
case 0: this.pictureBox1.Image = Image.FromFile(scenery.SYImagSrc, false);
label1.Text = scenery.SYName;
break;
case 1: this.pictureBox2.Image = Image.FromFile(scenery.SYImagSrc, false);
label2.Text = scenery.SYName;
break;
case 2: this.pictureBox3.Image = Image.FromFile(scenery.SYImagSrc, false);
label3.Text = scenery.SYName;
break;
case 3: this.pictureBox4.Image = Image.FromFile(scenery.SYImagSrc, false);
label4.Text = scenery.SYName;
break;
case 4: this.pictureBox5.Image = Image.FromFile(scenery.SYImagSrc, false);
label5.Text = scenery.SYName;
break;
case 5: this.pictureBox6.Image = Image.FromFile(scenery.SYImagSrc, false);
label6.Text = scenery.SYName;
break;
case 6: this.pictureBox7.Image = Image.FromFile(scenery.SYImagSrc, false);
label7.Text = scenery.SYName;
break;
case 7: this.pictureBox8.Image = Image.FromFile(scenery.SYImagSrc, false);
label8.Text = scenery.SYName;
break;
case 8: this.pictureBox9.Image = Image.FromFile(scenery.SYImagSrc, false);
label9.Text = scenery.SYName;
break;
case 9: this.pictureBox10.Image = Image.FromFile(scenery.SYImagSrc, false);
label10.Text = scenery.SYName;
break;
case 10: this.pictureBox11.Image = Image.FromFile(scenery.SYImagSrc, false);
label11.Text = scenery.SYName; break;
case 11: this.pictureBox12.Image = Image.FromFile(scenery.SYImagSrc, false);
label12.Text = scenery.SYName;
break;
}
this.pictureBox1.Image = Image.FromFile(scenery.SYImagSrc, false);
}
}
}
