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