public void UpdateTrainEmployee(TrainEmployee obj)
{
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_TRAIN_EMPLOYEE_U";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_train_employee_id", DbType.Int32, obj.TrainEmployeeID);
db.AddInParameter(dbCommand, "p_employee_id", DbType.Int32, obj.EmployeeID);
db.AddInParameter(dbCommand, "p_train_type_id", DbType.Int32, obj.TrainTypeID);
db.ExecuteNonQuery(dbCommand);
}
public TrainEmployee GetTrainEmployeeByEmployee(int employeeID)
{
TrainEmployee obj = new TrainEmployee();
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_TRAIN_EMPLOYEE_G";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_employee_id", DbType.Int32, employeeID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
obj = CreateModelObject(dataReader);
}
}
return(obj);
}
protected void btnOk_Click(object sender, EventArgs e)
{
if (tvType.SelectedNode == null)
{
SessionSet.PageMessage = "请选择培训类别！";
return;
}
if (tvType.SelectedNode.Nodes.Count > 0)
{
SessionSet.PageMessage = "请选择叶子节点！";
return;
}
int nEmpID;
nEmpID = PrjPub.CurrentStudent.EmployeeID;
TrainEmployeeBLL objBll = new TrainEmployeeBLL();
TrainEmployee objNow = objBll.GetTrainEmployeeByEmployeeID(nEmpID);
TrainEmployee obj = new TrainEmployee();
obj.EmployeeID = nEmpID;
obj.TrainTypeID = Convert.ToInt32(tvType.SelectedNode.ID);
if (objNow.EmployeeID == 0)
{
objBll.AddTrainEmployee(obj);
}
else
{
obj.TrainEmployeeID = objNow.TrainEmployeeID;
objBll.UpdateTrainEmployee(obj);
}
Response.Write("<script>window.opener.form1.submit();window.close();</script>");
}
public void UpdateTrainEmployee(TrainEmployee trainEmployee)
{
dal.UpdateTrainEmployee(trainEmployee);
}
public void AddTrainEmployee(TrainEmployee trainEmployee)
{
dal.AddTrainEmployee(trainEmployee);
}
