private void ButtonSubmit_Click(object sender, EventArgs e) { if (TextBoxHandlePerson.Text != String.Empty && TextBoxHandleDate.Text != String.Empty && TextBoxName.Text != String.Empty && (RadioButtonMan.Checked != false || RadioButtonWoman.Checked != false) && TextBoxPassword.Text != String.Empty && TextBoxIDCardNo.Text != String.Empty && TextBoxTel.Text != String.Empty && TextBoxAddress.Text != String.Empty && TextBoxBalance.Text != String.Empty /*&& TextBoxRemark.Text != String.Empty*/) { try { if (GlobalClass.Connection.State == ConnectionState.Open) { GlobalClass.Connection.Close(); } GlobalClass.Connection.Open(); SqlCommand SubmitCmd = new SqlCommand("SubmitMemberEdit", GlobalClass.Connection); SubmitCmd.CommandType = CommandType.StoredProcedure; SubmitCmd.Parameters.Add("@CardNo", SqlDbType.NChar, 6); SubmitCmd.Parameters.Add("@Name", SqlDbType.NVarChar, 8); SubmitCmd.Parameters.Add("@Password", SqlDbType.NChar, 32); SubmitCmd.Parameters.Add("@Sex", SqlDbType.NChar, 2); SubmitCmd.Parameters.Add("@IDCardNo", SqlDbType.NChar, 18); SubmitCmd.Parameters.Add("@Tel", SqlDbType.NChar, 11); SubmitCmd.Parameters.Add("@Address", SqlDbType.VarChar, 32); SubmitCmd.Parameters.Add("@Balance", SqlDbType.Int); SubmitCmd.Parameters.Add("@Remark", SqlDbType.Text); SubmitCmd.Parameters[0].Value = TempRef.Text.Substring(7); SubmitCmd.Parameters[1].Value = TextBoxName.Text; SubmitCmd.Parameters[2].Value = GlobalClass.MD5(TextBoxPassword.Text); if (RadioButtonMan.Checked == true) { SubmitCmd.Parameters[3].Value = "男"; } else { SubmitCmd.Parameters[3].Value = "女"; } SubmitCmd.Parameters[4].Value = TextBoxIDCardNo.Text; SubmitCmd.Parameters[5].Value = TextBoxTel.Text; SubmitCmd.Parameters[6].Value = TextBoxAddress.Text; SubmitCmd.Parameters[7].Value = TextBoxBalance.Text; SubmitCmd.Parameters[8].Value = TextBoxRemark.Text; if (SubmitCmd.ExecuteNonQuery() == 1) { MessageBox.Show("提交成功,请刷新页面!", "消息", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } else { MessageBox.Show("提交失败!", "消息", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show(ex.Message, "消息", MessageBoxButtons.OK, MessageBoxIcon.Error); GlobalClass.Connection.Close(); } } else { MessageBox.Show("信息不完整!", "消息", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void ButtonSubmit_Click(object sender, EventArgs e) { if (TextBoxName.Text != String.Empty && (RadioButtonMan.Checked != false || RadioButtonWoman.Checked != false) && TextBoxPassword.Text != String.Empty && ComboBoxPrivilegeLevel.SelectedIndex != 0 && TextBoxPolitical.Text != String.Empty && ComboBoxClass.SelectedIndex != 0 && TextBoxBirthDay.Text != String.Empty && TextBoxIDCardNo.Text != String.Empty && TextBoxNation.Text != String.Empty && TextBoxNativePlace.Text != String.Empty && TextBoxTel.Text != String.Empty && TextBoxAddress.Text != String.Empty && ComboBoxShift.SelectedIndex != 0 && TextBoxSalary.Text != String.Empty && TextBoxBankCardNo.Text != String.Empty && ComboBoxMaritalStatus.SelectedIndex != 0 && TextBoxDateOfEmployment.Text != String.Empty) { try { if (GlobalClass.Connection.State == ConnectionState.Open) { GlobalClass.Connection.Close(); } GlobalClass.Connection.Open(); SqlCommand SubmitCmd = new SqlCommand("SubmitEntryHandle", GlobalClass.Connection); SubmitCmd.CommandType = CommandType.StoredProcedure; SubmitCmd.Parameters.Add("@No", SqlDbType.NChar, 6); SubmitCmd.Parameters.Add("@Password", SqlDbType.NChar, 32); SubmitCmd.Parameters.Add("@Name", SqlDbType.VarChar, 8); SubmitCmd.Parameters.Add("@Sex", SqlDbType.NChar, 2); SubmitCmd.Parameters.Add("@Nation", SqlDbType.VarChar, 8); SubmitCmd.Parameters.Add("@NativePlace", SqlDbType.VarChar, 16); SubmitCmd.Parameters.Add("@Political", SqlDbType.VarChar, 8); SubmitCmd.Parameters.Add("@Class", SqlDbType.VarChar, 8); SubmitCmd.Parameters.Add("@Shift", SqlDbType.Int); SubmitCmd.Parameters.Add("@Salary", SqlDbType.Int); SubmitCmd.Parameters.Add("@Tel", SqlDbType.NChar, 11); SubmitCmd.Parameters.Add("@Address", SqlDbType.VarChar, 32); SubmitCmd.Parameters.Add("@PrivilegeLevel", SqlDbType.Int); SubmitCmd.Parameters.Add("@IDCardNo", SqlDbType.NChar, 18); SubmitCmd.Parameters.Add("@BankCardNo", SqlDbType.NChar, 19); SubmitCmd.Parameters.Add("@BirthDay", SqlDbType.Date); SubmitCmd.Parameters.Add("@MaritalStatus", SqlDbType.Int); SubmitCmd.Parameters.Add("@DateOfEmployment", SqlDbType.Date); SubmitCmd.Parameters[0].Value = (LastNo + 1).ToString(); SubmitCmd.Parameters[1].Value = GlobalClass.MD5(TextBoxPassword.Text); SubmitCmd.Parameters[2].Value = TextBoxName.Text; if (RadioButtonMan.Checked == true) { SubmitCmd.Parameters[3].Value = "男"; } else { SubmitCmd.Parameters[3].Value = "女"; } SubmitCmd.Parameters[4].Value = TextBoxNation.Text; SubmitCmd.Parameters[5].Value = TextBoxNativePlace.Text; SubmitCmd.Parameters[6].Value = TextBoxPolitical.Text; SubmitCmd.Parameters[7].Value = ComboBoxClass.Text; if (ComboBoxShift.Text == "日班") { SubmitCmd.Parameters[8].Value = 0; } else if (ComboBoxShift.Text == "夜班") { SubmitCmd.Parameters[8].Value = 1; } SubmitCmd.Parameters[9].Value = TextBoxSalary.Text; SubmitCmd.Parameters[10].Value = TextBoxTel.Text; SubmitCmd.Parameters[11].Value = TextBoxAddress.Text; SubmitCmd.Parameters[12].Value = ComboBoxPrivilegeLevel.Text; SubmitCmd.Parameters[13].Value = TextBoxIDCardNo.Text; SubmitCmd.Parameters[14].Value = TextBoxBankCardNo.Text; SubmitCmd.Parameters[15].Value = TextBoxBirthDay.Text; if (ComboBoxMaritalStatus.Text == "未婚") { SubmitCmd.Parameters[16].Value = 0; } else if (ComboBoxMaritalStatus.Text == "已婚") { SubmitCmd.Parameters[16].Value = 1; } SubmitCmd.Parameters[17].Value = TextBoxDateOfEmployment.Text; if (SubmitCmd.ExecuteNonQuery() == 1) { MessageBox.Show("提交成功,请刷新页面!", "消息", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } else { MessageBox.Show("提交失败!", "消息", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show(ex.Message, "消息", MessageBoxButtons.OK, MessageBoxIcon.Error); GlobalClass.Connection.Close(); } } else { MessageBox.Show("信息不完整!", "消息", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }