/// <summary>
/// ¸ù¾ÝÅàѵ¹æ·¶IDÈ·¶¨Î¨Ò»µÄÅàѵ¹æ·¶
/// </summary>
/// <param name="trainstandardid">Åàѵ¹æ·¶ID</param>
/// <returns></returns>
public TrainStandard GetTrainStandardInfo(int trainstandardid)
{
TrainStandard obj = new TrainStandard();
TrainTypeDAL objTrainType = new TrainTypeDAL();
PostDAL objPost = new PostDAL();
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_TRAIN_STANDARD_G";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_train_standard_id", DbType.Int32, trainstandardid);
db.AddInParameter(dbCommand, "p_post_id", DbType.Int32, 0);
db.AddInParameter(dbCommand, "p_type_id", DbType.Int32, 0);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
obj = CreateModelObject(dataReader);
obj.PostName = objPost.GetPost(obj.PostID).PostName;
obj.TypeName = objTrainType.GetTrainTypeInfo(obj.TypeID).TypeName;
}
}
return(obj);
}
/// <summary>
/// ¸üÐÂÅàѵ¹æ·¶
/// </summary>
public void UpdateTrainStandard(TrainStandard obj)
{
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_TRAIN_STANDARD_U";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_train_standard_id", DbType.Int32, obj.TrainStandardID);
db.AddInParameter(dbCommand, "p_train_time", DbType.String, obj.TrainTime);
db.AddInParameter(dbCommand, "p_train_content", DbType.String, obj.TrainContent);
db.AddInParameter(dbCommand, "p_train_form", DbType.String, obj.TrainForm);
db.AddInParameter(dbCommand, "p_exam_form", DbType.String, obj.ExamForm);
db.AddInParameter(dbCommand, "p_description", DbType.String, obj.Description);
db.AddInParameter(dbCommand, "p_memo", DbType.String, obj.Memo);
db.ExecuteNonQuery(dbCommand);
}
public IList <TrainStandard> GetTrainStandardInfo(int trainStandardID,
int postID,
int typeID,
string trainTime,
string trainContent,
string trainForm,
string examForm,
string description,
string memo,
int startRowIndex,
int maximumRows,
string orderBy)
{
IList <TrainStandard> train = new List <TrainStandard>();
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_TRAIN_STANDARD_S";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_post_id", DbType.Int32, postID);
db.AddInParameter(dbCommand, "p_type_id", DbType.Int32, typeID);
db.AddInParameter(dbCommand, "p_start_row_index", DbType.Int32, startRowIndex);
db.AddInParameter(dbCommand, "p_page_size", DbType.Int32, maximumRows);
db.AddInParameter(dbCommand, "p_order_by", DbType.String, GetMappingOrderBy(orderBy));
db.AddOutParameter(dbCommand, "p_count", DbType.Int32, 4);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
TrainStandard obj = CreateModelObject(dataReader);
train.Add(obj);
}
}
_recordCount = Convert.ToInt32(db.GetParameterValue(dbCommand, "p_count"));
return(train);
}
/// <summary>
/// ¸ù¾ÝÅàѵ¸ÚλID£¬ÅàѵÀà±ðIDÈ·¶¨Î¨Ò»µÄÅàѵ¹æ·¶
/// </summary>
/// <param name="postid">Åàѵ¸ÚλID</param>
/// <param name="typeid">ÅàѵÀà±ðID</param>
/// <returns></returns>
public TrainStandard GetTrainStandardInfo(int postid, int typeid)
{
TrainStandard obj = new TrainStandard();
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_TRAIN_STANDARD_G";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_train_standard_id", DbType.Int32, 0);
db.AddInParameter(dbCommand, "p_post_id", DbType.Int32, postid);
db.AddInParameter(dbCommand, "p_type_id", DbType.Int32, typeid);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
obj = CreateModelObject(dataReader);
}
}
return(obj);
}
/// <summary>
/// 更新培训规范
/// </summary>
/// <param name="trainStandard"></param>
public void UpdateTrainStandard(TrainStandard trainStandard)
{
dal.UpdateTrainStandard(trainStandard);
}
public void DeleteTrainStandard(TrainStandard trainStandard)
{
dal.DeleteTrainStandard(trainStandard.TrainStandardID);
}
/// <summary>
/// 新增培训规范
/// </summary>
/// <param name="trainStandard"></param>
public void AddTrainStandard(TrainStandard trainStandard)
{
dal.AddTrainStandard(trainStandard);
}
