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); } } }