private void ScoreWindow_Load(object sender, EventArgs e)
{
YourScore.AppendText(" " + score.ToString());
using (StreamReader sr = File.OpenText(path))
{
int count = 0;
string s = "";
while ((s = sr.ReadLine()) != null && count < 8)
{
TextBoxNumbers.AppendText(s);
TextBoxNumbers.AppendText(Environment.NewLine);
count++;
}
}
}
private void ButtonOK_Click(object sender, EventArgs e)
{
try
{
if (GlobalClass.Connection.State == ConnectionState.Open)
{
GlobalClass.Connection.Close();
}
GlobalClass.Connection.Open();
if (Regex.IsMatch(TextBoxNumbers.Text, @"\d+"))
{
SqlCommand AddLeafletCmd = new SqlCommand("AddLeaflet", GlobalClass.Connection);
AddLeafletCmd.CommandType = CommandType.StoredProcedure;
AddLeafletCmd.Parameters.Add("@Class", SqlDbType.VarChar, 8);
AddLeafletCmd.Parameters.Add("@HandlePerson", SqlDbType.Char, 6);
AddLeafletCmd.Parameters.Add("@Numbers", SqlDbType.Int);
AddLeafletCmd.Parameters[0].Value = LabelLeaflet.Text;
AddLeafletCmd.Parameters[1].Value = GlobalClass.EmployeeNo;
AddLeafletCmd.Parameters[2].Value = Convert.ToInt32(TextBoxNumbers.Text);
if (AddLeafletCmd.ExecuteNonQuery() == 1)
{
MessageBox.Show("添加成功,请刷新页面!", "消息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("添加失败!", "消息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
this.Close();
}
else
{
MessageBox.Show("输入不合法!", "消息", MessageBoxButtons.OK, MessageBoxIcon.Error);
TextBoxNumbers.Text = String.Empty;
TextBoxNumbers.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "消息", MessageBoxButtons.OK, MessageBoxIcon.Error);
GlobalClass.Connection.Close();
}
}
