public void UpdateGameInDB(TextBox txt, NumericUpDown up) { try { int gameIDs = 0; int gameToUpdate = 0; try { gameToUpdate = Convert.ToInt32(txt.Text); } catch (Exception) { ErrorForm frm = new ErrorForm(); frm.ShowDialog(); //MessageBox.Show("That's not a number!","Please Scan Again!", MessageBoxButtons.OK); } int valueFromIncrementor = Convert.ToInt32(up.Value); string gameOutput; SqlConnection con = new SqlConnection(); con.ConnectionString = @"Data Source=.\SQLExpress;" + "User Instance=true;" + "Integrated Security=true;" + @"AttachDbFilename=|DataDirectory|\Test_Game_DB.mdf;"; con.Open(); SqlCommand update = new SqlCommand( "update Games SET InStock = (InStock + @value) WHERE GameID = @Code and GameName not like '" + "" + "' ;", con); update.Parameters.AddWithValue("@Code", gameToUpdate); update.Parameters.AddWithValue("@value", valueFromIncrementor); update.Parameters.AddWithValue("@idCheck", gameIDs); SqlCommand gameName = new SqlCommand( "select gamename from games where gameid = @Code", con); gameName.Parameters.AddWithValue("@Code", gameToUpdate); gameOutput = gameName.ExecuteScalar().ToString(); if (gameToUpdate >= 1) { update.ExecuteNonQuery(); MessageBox.Show(gameOutput + " was Added!", " Success!", MessageBoxButtons.OK); Form.ActiveForm.Close(); con.Close(); } } catch (Exception) { Form.ActiveForm.Close(); } }
//这个按钮按下时,将触发检查事件,要根据AnswerText和ExeText获取文件路径 private void skinButton1_Click_1(object sender, EventArgs e) { try { string ExePath = ExeText.Text; string AnswerPath = AnswerText.Text; Configure con = new Configure(CoreMode.CheckMode); con.Calc(ExePath, AnswerPath); DisGradeBox.Text += "成绩已经生成到" + ReadXml("//Path//Grade") + Environment.NewLine; } catch (MyException.OwnException e1) { ErrorForm form = new ErrorForm(e1.Message); form.ShowDialog(); } }
public void Generate() { try { Configure con = new Configure(CoreMode.ExerciseMode); con.Calc(); } catch (MyException.TooManyException e1) { ErrorForm form = new ErrorForm(e1.Message); form.ShowDialog(); } finally { InvokeCall a = new InvokeCall(UpdateProgressBar); BeginInvoke(a); } }
public void Generate() { try { Configure con = new Configure(CoreMode.ExerciseMode); con.Calc(); } catch (MyException.TooManyException e1) { ErrorForm form = new ErrorForm(e1.Message); form.ShowDialog(); } finally { //这里注意一开始的允许跨线程操纵UI GenProgressIndicator.Hide(); ExeAnsTextBox.Text += "已经生成了" + ReadXml("//Count//FactCount") + "道题目与答案到指定的文件中." + Environment.NewLine; ExeAnsTextBox.Show(); } }
public void Generate() { try { Configure con = new Configure(CoreMode.ExerciseMode); con.Calc(); } catch (MyException.TooManyException e1) { ErrorForm form = new ErrorForm(e1.Message); form.ShowDialog(); } finally { //这里注意一开始的允许跨线程操纵UI GenProgressIndicator.Hide(); ExeAnsTextBox.Text += "已经生成了" + ReadXml("//Count//FactCount") + "道题目与答案到指定的文件中."+Environment.NewLine; ExeAnsTextBox.Show(); } }
//打开答案文件,并且判断文件后缀是否为txt文件,如果不是txt文件,则抛出异常。 private void AnswerButton_Click(object sender, EventArgs e) { try { string path = ""; OpenFileDialog Dialog = new OpenFileDialog(); DialogResult result = Dialog.ShowDialog(); if ((result == DialogResult.OK) || (result == DialogResult.Yes)) { path = Dialog.FileName; if (!path.EndsWith(".txt")) { throw new FileNotFoundException("文件后缀不正确,请重新打开!"); } AnswerText.Text = path; } } catch (Exception e1) { ErrorForm error = new ErrorForm(e1.Message); error.ShowDialog();//show Dialog指定只能关闭本模块后才可以关闭其他 } }
private void calcButtonResult_Click(object sender, EventArgs e) { //这里应该调用计算核心中的计算单个表达式的值,并显示在该TextBox中 ///////////////////////////////////////// // single calc expression // ///////////////////////////////////////// string Content = calcTextBox.Text; try { Configure con = new Configure(CoreMode.CalcuateMode); Content = con.Calc(calcTextBox.Text + "="); } catch (MyException.OwnException e1) { ErrorForm form = new ErrorForm(e1.Message); form.ShowDialog(); } finally { calcTextBox.Text = Content; } }
//这个按钮按下时,将触发检查事件,要根据AnswerText和ExeText获取文件路径 private void skinButton1_Click_1(object sender, EventArgs e) { try { string ExePath = ExeText.Text; string AnswerPath = AnswerText.Text; Configure con = new Configure(CoreMode.CheckMode); con.Calc(ExePath, AnswerPath); DisGradeBox.Text += "成绩已经生成到" + ReadXml("//Path//Grade") + Environment.NewLine; } catch (MyException.OwnException e1) { ErrorForm form = new ErrorForm(e1.Message); form.ShowDialog(); } }
//打开题目文件,并且判断文件后缀是否为txt文件,如果不是txt文件,则抛出异常。 private void ExeButton_Click(object sender, EventArgs e) { try { string path = ""; OpenFileDialog Dialog = new OpenFileDialog(); DialogResult result = Dialog.ShowDialog(); if ((result == DialogResult.OK) || (result == DialogResult.Yes)) { path = Dialog.FileName; if (!path.EndsWith(".txt")) throw new FileNotFoundException("文件后缀不正确,请重新打开!"); ExeText.Text = path; } } catch (Exception e1) { ErrorForm error = new ErrorForm(e1.Message); error.ShowDialog();//show Dialog指定只能关闭本模块后才可以关闭其他 } }
private void calcButtonResult_Click(object sender, EventArgs e) { //这里应该调用计算核心中的计算单个表达式的值,并显示在该TextBox中 ///////////////////////////////////////// // single calc expression // ///////////////////////////////////////// string Content = calcTextBox.Text; try { Configure con = new Configure(CoreMode.CalcuateMode); Content = con.Calc(calcTextBox.Text + "="); } catch(MyException.OwnException e1) { ErrorForm form = new ErrorForm(e1.Message); form.ShowDialog(); } finally { calcTextBox.Text = Content; } }
public void ApplyTrade(TextBox Code, ListView lst) { try { float tradeValueOut; SqlConnection con = new SqlConnection(); con.ConnectionString = @"Data Source=.\SQLExpress;" + "User Instance=true;" + "Integrated Security=true;" + @"AttachDbFilename=|DataDirectory|\Test_Game_DB.mdf;"; con.Open(); int gameToUpdate = 0; try { if (Code.Text != "") { gameToUpdate = Convert.ToInt32(Code.Text); } else { gameToUpdate = 0; } } catch (Exception) { MessageBox.Show("ktmk"); } SqlCommand customerTrade = new SqlCommand( "select TradeValue from TradeValues where CustomerID like @Code;", con); customerTrade.Parameters.AddWithValue("@Code", gameToUpdate); if (customerTrade != null) { tradeValueOut = (float)Convert.ToDouble(customerTrade.ExecuteScalar()); MessageBox.Show(tradeValueOut.ToString()); } else { tradeValueOut = 0; } if (tradeValueOut >= TotalPrice) { tradeValueOut -= this.TotalPrice; TotalPrice = 0; // tradeValueOut -= this.TotalPrice; SqlCommand TradeUpdate = new SqlCommand( "UPDATE TradeValues set TradeValue = @trade where CustomerID = @Code;", con); TradeUpdate.Parameters.AddWithValue("@Code", gameToUpdate); TradeUpdate.Parameters.AddWithValue("@trade", tradeValueOut); TradeUpdate.ExecuteNonQuery(); } else { this.TotalPrice -= tradeValueOut; SqlCommand TradeUpdate = new SqlCommand( "UPDATE TradeValues set TradeValue = 0 where CustomerID = @Code;", con); TradeUpdate.Parameters.AddWithValue("@Code", gameToUpdate); TradeUpdate.ExecuteNonQuery(); } con.Close(); lst.Items.Add("- $" + tradeValueOut.ToString()); lst.Items.Add("$" + TotalPrice.ToString()); } catch (Exception) { ErrorForm frm = new ErrorForm(); frm.ShowDialog(); } }