private void btnLogOn_Click(object sender, EventArgs e) { string account = txtAccount.Text.Trim(); string password = txtPassword.Text.Trim(); password = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(password, "SHA1"); member = memberModel.LogOncheck(account, password); if (member != null) { this.txtAccount.Text = ""; this.txtPassword.Text = ""; FrmHomePage frm = new FrmHomePage(); frm.Tag = member; if (this.cbox.Checked) { this.txtAccount.Text = member.account; } else { this.txtAccount.Text = ""; } frm.ShowDialog(); } else { MessageBox.Show("請重新輸入帳號或密碼", "登入訊息", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } }
private void btnOK_Click(object sender, EventArgs e) { try { members member = this.member; if (string.IsNullOrEmpty(this.txtNum.Text) || this.txtNum.Text == "0") { MessageBox.Show("請輸入賣出張數!!"); this.txtMoney.Text = "0"; return; } else if (int.Parse(this.txtNum.Text) > int.Parse(buttonRow.Cells[6].Value.ToString())) { MessageBox.Show("賣出張數超出庫存張數@@,請重新輸入!!"); this.txtNum.Text = ""; this.txtMoney.Text = "0"; return; } else { MessageBox.Show("賣出成功!!"); } //賣出張數,修改資料表 if (int.Parse(this.txtNum.Text) == int.Parse(buttonRow.Cells[6].Value.ToString())) { stocksave save = db.stocksave.AsEnumerable().Where(s => s.證券代號 == buttonRow.Cells[3].Value.ToString() && s.account == member.account).FirstOrDefault(); datamodel.Delete(save); stockremain remain = db.stockremain.AsEnumerable().Where(r => r.證券代號 == buttonRow.Cells[3].Value.ToString() && r.account == member.account).FirstOrDefault(); datamodel.Delete(remain); } else if (int.Parse(this.txtNum.Text) < int.Parse(buttonRow.Cells[6].Value.ToString())) { stocksave save = db.stocksave.AsEnumerable().Where(s => s.證券代號 == buttonRow.Cells[3].Value.ToString() && s.account == member.account).FirstOrDefault(); datamodel.Updatestocksave(save, int.Parse(this.txtNum.Text)); stockremain remainsave = db.stockremain.AsEnumerable().Where(r => r.證券代號 == buttonRow.Cells[3].Value.ToString() && r.account == member.account).FirstOrDefault(); datamodel.Updatestockremain(remainsave, int.Parse(this.txtNum.Text)); } double remainmoney = (double)member.bankmoney + double.Parse(txtMoney.Text); member.bankmoney = (int)remainmoney; var mem = (from m in db.members where m.account == member.account select m).FirstOrDefault(); if (mem == null) { return; } mem.bankmoney = member.bankmoney; db.SaveChanges(); //frmHomePage傳值 FrmHomePage frmHomePage = this.frmHomePage; frmHomePage.lblbankmoney.Text = member.bankmoney.ToString(); frmHomePage.lblmoney.Text = member.bankmoney.ToString(); frmHomePage.lblbank.Text = member.bankmoney.ToString(); //frmHomePage.dataGridView3.DataSource = null; //frmHomePage.dataGridView4.DataSource = null; frmHomePage.dataGridView4.DataSource = db.stockremain.Where(s => s.account == member.account).ToList(); frmHomePage.dataGridView4.Columns["id"].Visible = false; frmHomePage.dataGridView3.DataSource = db.stocksave.Where(s => s.account == member.account).ToList(); frmHomePage.dataGridView3.Columns["id"].Visible = false; this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnOK_Click(object sender, EventArgs e) { try { //member傳值 members member = this.member; if (string.IsNullOrEmpty(this.txtNum.Text) || this.txtNum.Text == "0") { MessageBox.Show("請輸入購買張數!!"); this.txtMoney.Text = "0"; return; } else if (double.Parse(txtMoney.Text) > member.bankmoney) { MessageBox.Show("買進總金額超過帳戶金額QQ,請重新輸入!!"); this.txtNum.Text = ""; this.txtMoney.Text = "0"; return; } else { MessageBox.Show("買入成功!!"); } double remainmoney = (double)member.bankmoney - double.Parse(txtMoney.Text); member.bankmoney = (int)remainmoney; var mem = (from m in db.members where m.account == member.account select m).FirstOrDefault(); if (mem == null) { return; } mem.bankmoney = member.bankmoney; db.SaveChanges(); //frmHomePage傳值 FrmHomePage frmHomePage = this.frmHomePage; frmHomePage.lblbankmoney.Text = member.bankmoney.ToString(); frmHomePage.lblmoney.Text = member.bankmoney.ToString(); frmHomePage.lblbank.Text = member.bankmoney.ToString(); //存入我的庫存 stocksave stock.account = this.txtAccount.Text; stock.證券代號 = this.txtStocknum.Text; stock.證券名稱 = this.txtStockName.Text; stock.買進價格 = this.txtPrice.Text; stock.張數 = this.txtNum.Text; stock.總金額 = this.txtMoney.Text; db.stocksave.Add(stock); db.SaveChanges(); //取得收盤價,存入未實現損益 var price = (from d in db.data join s in db.stocksave.Where(s => s.account == member.account) on d.證券代號 equals s.證券代號 select d.收盤價).ToList(); stockRemain.account = member.account; stockRemain.證券代號 = stock.證券代號; stockRemain.證券名稱 = stock.證券名稱; stockRemain.成交均價 = stock.買進價格; stockRemain.張數 = stock.張數; stockRemain.持有成本 = stock.總金額; for (int i = 0; i < price.Count(); i++) { var code = (from d in db.data join s in db.stocksave.Where(s => s.account == member.account) on d.證券代號 equals s.證券代號 select d.證券代號).ToList(); if (stockRemain.證券代號 == code[i]) { stockRemain.現價 = price[i].ToString(); } } stockRemain.現值 = (double.Parse(stockRemain.現價) * double.Parse(stock.張數.ToString()) * number).ToString(); stockRemain.預估收入 = (double.Parse(stockRemain.現價) * double.Parse(stock.張數.ToString()) * number).ToString(); stockRemain.預估損益 = (double.Parse(stockRemain.預估收入) - double.Parse(stockRemain.持有成本)).ToString(); stockRemain.預估獲利率 = ((double.Parse(stockRemain.預估損益) / double.Parse(stockRemain.持有成本)) * 100).ToString("f2") + "%"; db.stockremain.Add(stockRemain); db.SaveChanges(); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }