private void btnModify_Click(object sender, EventArgs e)
{
if (txtTeaNum.Text == "" || txtTeaName.Text == "")
{
MessageBox.Show("工号和姓名都不能为空！\n 请重新输入！");
}
else
{
TeacherBLL objTeacherBLL = new TeacherBLL();
TeacherModel objTeacherModel = new TeacherModel();
objTeacherModel.TeaAdress = txtTeaAddress.Text;
objTeacherModel.TeaName = txtTeaName.Text;
objTeacherModel.TeaNum = txtTeaNum.Text;
objTeacherModel.TeaPhone = txtTeaPhone.Text;
objTeacherModel.TeaTitle = txtTeaTitle.Text;
objTeacherModel.TeaSex = cbxTeaSex.Text;
objTeacherModel.TeaTitle = txtTeaTitle.Text;
if (objTeacherBLL.ChangeTeacher(objTeacherModel)==true)
{
MessageBox.Show("增加成功！");
}
else
MessageBox.Show("增加失败！");
}
ShowTable();
}
private void btnAdd_Click(object sender, EventArgs e)
{
#region sql语句进行添加，已注释
//TeacherBLL objTeacherBLL = new TeacherBLL();
//TeacherModel Teacher = new TeacherModel();
//Teacher.TeaNum = txtNum.Text ;
//Teacher.TeaName = txtName.Text;
//Teacher.TeaSex = cmbSex.Text;
//Teacher.TeaAdress = txtAdress.Text;
//Teacher.TeaPhone = txtPhone.Text;
//Teacher.TeaTitle = txtTitle.Text;
//if(objTeacherBLL.AddTeacher(Teacher)==true)
// MessageBox.Show("数据添加成功");
//else
// MessageBox.Show("数据添加失败");
//dgvTeacherInfo.DataSource = objTeacherBLL.ShowTeacher();
#endregion
#region //存储过程 已注释
////SqlConnection objConn = new SqlConnection("Data Source=.\\SQLExpress;Initial Catalog=StuManageSystem_2008;Integrated Security=True");
////objConn.Open();
////SqlCommand objSqlCommand = new SqlCommand();
//objSqlCommand.Connection = objConn;
//objSqlCommand.CommandType = CommandType.StoredProcedure;
//objSqlCommand.CommandText = "Teachers";
//objSqlCommand.Parameters.Add("@TeaName", SqlDbType.NChar, 10);
//objSqlCommand.Parameters["@TeaName"].Value = txtName.Text;
//objSqlCommand.Parameters.Add("@Sex", SqlDbType.NChar, 10);
//objSqlCommand.Parameters["@TeaSex"].Value = txtSex.Text;
//objSqlCommand.Parameters.Add("@TeaAdress", SqlDbType.NChar, 10);
//objSqlCommand.Parameters["@TeaAdress"].Value = txtAdress.Text;
//objSqlCommand.Parameters.Add("@TeaPhone", SqlDbType.NChar, 10);
//objSqlCommand.Parameters["@TeaPhone"].Value = txtPhone.Text;
//objSqlCommand.Parameters.Add("@TeaTitle", SqlDbType.NChar, 10);
//objSqlCommand.Parameters["@TeaTitle"].Value = txtTitle.Text;
//if (objSqlCommand.EndExecuteNonQuery() > 0)
// MessageBox.Show("添加成功");
//else MessageBox.Show("添加失败");
//objConn.Close();
//调用类的后半段
//string SqlString = "select*from dbo.Teacher";
// dgvTeacherInfo.DataSource = objDataBase.GetDataSet(SqlString).Tables[0];
//SqlCommand objSqlCommand = new SqlCommand();
//objSqlCommand.CommandType = CommandType.StoredProcedure;
//objSqlCommand.CommandText = "studentInsert";
//objSqlCommand.Parameters.AddWithValue("@TeaNum", txtNum.Text);
//objSqlCommand.Parameters.AddWithValue("@TeaName", txtName.Text);
//objSqlCommand.Parameters.AddWithValue("@TeaSex", cmbSex.Text);
//objSqlCommand.Parameters.AddWithValue("@TeaAdress ", txtAdress.Text);
//objSqlCommand.Parameters.AddWithValue("@TeaPhone", txtPhone.Text);
//objSqlCommand.Parameters.AddWithValue("@TeaTitle", txtTitle.Text);
//SQLClass1 objdatabase = new SQLClass1();
//if (objdatabase.GetExecute1(objSqlCommand))
// MessageBox.Show("添加成功");
//else
// MessageBox.Show("添加失败");
//showDGV();
#endregion
if (txtTeaNum.Text=="" || txtTeaName.Text == "")
{
MessageBox.Show("工号和姓名都不能为空！\n 请重新输入！");
}
else
{
TeacherBLL objTeacherBLL = new TeacherBLL();
TeacherModel objTeacherModel = new TeacherModel();
objTeacherModel.TeaAdress = txtTeaAddress.Text;
objTeacherModel.TeaName = txtTeaName.Text;
objTeacherModel.TeaNum = txtTeaNum.Text;
objTeacherModel.TeaPhone = txtTeaPhone.Text;
objTeacherModel.TeaTitle = txtTeaTitle.Text;
objTeacherModel.TeaSex = cbxTeaSex.Text;
objTeacherModel.TeaTitle = txtTeaTitle.Text;
if (objTeacherBLL.AddTeacher(objTeacherModel) == true)
{
MessageBox.Show("增加成功！");
}
else
MessageBox.Show("增加失败！");
}
}
private void btnDel_Click(object sender, EventArgs e)
{
TeacherBLL objTeacherBLL = new TeacherBLL();
TeacherModel objTeacherModel = new TeacherModel();
objTeacherModel.TeaNum = txtTeaNum.Text;
if (objTeacherBLL.DeleteTeacher(objTeacherModel)==true)
{ MessageBox.Show("数据删除成功"); }
else
{ MessageBox.Show("数据删除失败"); }
ShowTable();
}
public JsonResult New()
{
TeacherModel teacherModel = new TeacherModel();
return(Json(teacherModel, JsonRequestBehavior.AllowGet));
}
public TeacherModel Put(int id, [FromBody] TeacherModel teacher)
{
return(_factory.Create(teacher));
}
public TeacherModel Post([FromBody] TeacherModel model)
{
return(_factory.Update(model));
}
//Get Teacher Details By ID
//Shows Name, Username, Password, Address, PhoneNumber, Permission, Status, DateIn, DateOut
//Stored Procedure Name: sp_GetTeacherDetails
//Parameters : @teacher_id
private TeacherModel _find(int teacher_id = 0, string username = null)
{
TeacherModel teacher = null;
try
{
using (var connection = new SqlConnection(_connectionString))
{
using (SqlCommand command = new SqlCommand())
{
//Create Command With Existing Connection with Stored Procedure Type
command.Connection = connection;
command.CommandTimeout = 60;
command.CommandType = CommandType.StoredProcedure;
//Check Parameters
if (!string.IsNullOrEmpty(username))
{
command.CommandText = GetTeacherDetailsByUsername;
command.Parameters.AddWithValue("@username", username);
}
else
{
command.CommandText = GetTeacherDetails;
command.Parameters.AddWithValue("@teacher_id", teacher_id);
}
//Open Connection
connection.Open();
//Execute The Query
SqlDataReader result = command.ExecuteReader();
//Fetch Result
if (result.HasRows)
{
result.Read();
teacher = new TeacherModel()
{
Teacher_ID = teacher_id,
Username = result.GetString(0),
Password = result.IsDBNull(1) ? null : result.GetString(1),
Name = result.GetString(2),
Address = result.GetString(3),
PhoneNumber = result.GetString(4),
Permission = result.GetString(5),
Status = result.GetString(6),
DateIn = result.GetDateTime(7),
DateOut = result.IsDBNull(8) ? null : (DateTime?)result.GetDateTime(8)
};
}
//Close the Connection
connection.Close();
}
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message + "\nError Code:" + ex.Number + "ConString: " + _connectionString, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
return(null);
}
catch (Exception ex)
{
MessageBox.Show(ex.StackTrace + "\nMessage:\n" + ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
return(null);
}
return(teacher);
}
