public IList <TrainCourse> GetTrainCourseInfo(int trainCourseID,
int standardID,
int courseNo,
string courseName,
string description,
string studyDemand,
decimal studyHours,
bool hasExam,
string examForm,
int requireCourseID,
string memo,
int startRowIndex,
int maximumRows,
string orderBy)
{
IList <TrainCourse> objCourseList = new List <TrainCourse>();
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_TRAIN_COURSE_S";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
if (standardID != 0)
{
db.AddInParameter(dbCommand, "p_standard_id", DbType.Int32, standardID);
}
if (courseNo != 0)
{
db.AddInParameter(dbCommand, "p_course_no", DbType.Int32, courseNo);
}
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())
{
TrainCourse obj = CreateModelObject(dataReader);
objCourseList.Add(obj);
}
}
_recordCount = Convert.ToInt32(db.GetParameterValue(dbCommand, "p_count"));
return(objCourseList);
}
private void MapTrainCourse(TrainCourse trainCourse, TrainCourseFormViewModel model, OptionsViewModel moreInfo)
{
model.Branches = model.IBranches == null ? null : string.Join(",", model.IBranches.ToArray());
model.Jobs = model.IJobs == null ? null : string.Join(",", model.IJobs.ToArray());
model.Employments = model.IEmployments == null ? null : string.Join(",", model.IEmployments.ToArray());
model.PeopleGroups = model.IPeopleGroups == null ? null : string.Join(",", model.IPeopleGroups.ToArray());
model.Payrolls = model.IPayrolls == null ? null : string.Join(",", model.IPayrolls.ToArray());
model.PayrollGrades = model.IPayrollGrades == null ? null : string.Join(",", model.IPayrollGrades.ToArray());
model.CompanyStuctures = model.ICompanyStuctures == null ? null : string.Join(",", model.ICompanyStuctures.ToArray());
model.Positions = model.IPositions == null ? null : string.Join(",", model.IPositions.ToArray());
model.PrevCourses = model.IPrevCourses == null ? null : string.Join(",", model.IPrevCourses.ToArray());
moreInfo.VisibleColumns.Add("Branches");
moreInfo.VisibleColumns.Add("Jobs");
moreInfo.VisibleColumns.Add("Employments");
moreInfo.VisibleColumns.Add("PeopleGroups");
moreInfo.VisibleColumns.Add("Payrolls");
moreInfo.VisibleColumns.Add("PayrollGrades");
moreInfo.VisibleColumns.Add("CompanyStuctures");
moreInfo.VisibleColumns.Add("Positions");
moreInfo.VisibleColumns.Add("PrevCourses");
_hrUnitOfWork.LeaveRepository.AddLName(Language, trainCourse.Name, model.Name, model.LocalName);
if (trainCourse.Id == 0)
{
AutoMapper(new Models.AutoMapperParm
{
Destination = trainCourse,
Source = model,
ObjectName = "TrainCourse",
Options = moreInfo,
Transtype = TransType.Insert
});
}
else
{
AutoMapper(new Models.AutoMapperParm
{
Destination = trainCourse,
Source = model,
ObjectName = "TrainCourse",
Options = moreInfo,
Transtype = TransType.Update
});
}
}
/// <summary>
/// 更新培训课程
/// </summary>
/// <param name="obj"></param>
public void UpdateTrainCourse(TrainCourse obj)
{
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_TRAIN_COURSE_U";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_train_course_id", DbType.Int32, obj.TrainCourseID);
db.AddInParameter(dbCommand, "p_standard_id", DbType.Int32, obj.StandardID);
db.AddInParameter(dbCommand, "p_course_no", DbType.Int32, obj.CourseNo);
db.AddInParameter(dbCommand, "p_course_name", DbType.String, obj.CourseName);
db.AddInParameter(dbCommand, "p_description", DbType.String, obj.Description);
db.AddInParameter(dbCommand, "p_study_demand", DbType.String, obj.StudyDemand);
db.AddInParameter(dbCommand, "p_study_hours", DbType.VarNumeric, obj.StudyHours);
db.AddInParameter(dbCommand, "p_has_exam", DbType.Int32, obj.HasExam ? 1 : 0);
db.AddInParameter(dbCommand, "p_exam_form", DbType.String, obj.ExamForm);
db.AddInParameter(dbCommand, "p_require_course_id", DbType.Int32, obj.RequireCourseID);
db.AddInParameter(dbCommand, "p_memo", DbType.String, obj.Memo);
db.ExecuteNonQuery(dbCommand);
}
public IList <TrainCourse> GetTrainCommondCourseInfo()
{
IList <TrainCourse> objCourseList = new List <TrainCourse>();
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_TRAIN_COMMON_COURSE_G";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
TrainCourse obj = CreateModelObject(dataReader);
objCourseList.Add(obj);
}
}
return(objCourseList);
}
public TrainCourse GetTrainCourseInfo(int trainCourseID)
{
TrainCourse obj = new TrainCourse();
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_TRAIN_COURSE_G";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_train_course_id", DbType.Int32, trainCourseID);
db.AddInParameter(dbCommand, "p_standard_id", DbType.Int32, 0);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
obj = CreateModelObject(dataReader);
}
}
return(obj);
}
public IList <TrainCourse> GetTrainCourseQueryInfo(string strSql)
{
IList <TrainCourse> objCourseList = new List <TrainCourse>();
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_TRAIN_COURSE_Q";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_strSql", DbType.String, strSql);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
TrainCourse obj = CreateModelObject(dataReader);
objCourseList.Add(obj);
}
}
return(objCourseList);
}
public ActionResult DeleteTrainCourse(int id)
{
var message = "OK";
var Source = new DataSource <TrainCourseViewModel>();
Source.Errors = new List <Error>();
TrainCourse trainCourse = _hrUnitOfWork.TrainingRepository.GetTrainCourse(id);
bool Exist = false;
var ExistData = _hrUnitOfWork.Repository <TrainCourse>().Select(a => new { a.Id, a.PrevCourses }).ToList();
foreach (var item in ExistData)
{
if (item.PrevCourses != null)
{
if (item.PrevCourses.Split(',').Contains(trainCourse.Id.ToString()))
{
Exist = true;
break;
}
}
}
if (!Exist)
{
if (trainCourse != null)
{
AutoMapper(new Models.AutoMapperParm
{
Source = trainCourse,
ObjectName = "TrainCourses",
Transtype = TransType.Delete
});
_hrUnitOfWork.TrainingRepository.Remove(trainCourse);
_hrUnitOfWork.TrainingRepository.RemoveLName(Language, trainCourse.Name);
}
Source.Errors = SaveChanges(Language);
}
else
{
Source.Errors.Add(new Error()
{
errors = new List <ErrorMessage>()
{
new ErrorMessage()
{
message = MsgUtils.Instance.Trls("connectwithData")
}
}
});
}
if (Source.Errors.Count() > 0)
{
return(Json(Source));
}
else
{
return(Json(message));
}
}
public ActionResult Details(TrainCourseFormViewModel model, OptionsViewModel moreInfo)
{
List <Error> errors = new List <Error>();
if (ModelState.IsValid)
{
if (ServerValidationEnabled)
{
errors = _hrUnitOfWork.SiteRepository.CheckForm(new CheckParm
{
CompanyId = CompanyId,
ObjectName = "TrainCourse",
TableName = "TrainCourses",
Columns = Models.Utils.GetColumnViews(ModelState.Where(a => !a.Key.Contains('.'))),
Culture = Language
});
if (errors.Count() > 0)
{
foreach (var e in errors)
{
foreach (var errorMsg in e.errors)
{
ModelState.AddModelError(errorMsg.field, errorMsg.message);
}
}
return(Json(Models.Utils.ParseFormErrors(ModelState)));
}
}
//insert
if (model.Id == 0)
{
var record = new TrainCourse();
MapTrainCourse(record, model, moreInfo);
record.CreatedUser = UserName;
record.CreatedTime = DateTime.Now;
record.CompanyId = model.IsLocal ? CompanyId : (int?)null;
if (record.StartDate > record.EndDate)
{
ModelState.AddModelError("EndDate", MsgUtils.Instance.Trls("EndDateGthanStartDate"));
return(Json(Models.Utils.ParseFormErrors(ModelState)));
}
_hrUnitOfWork.TrainingRepository.Add(record);
}
//update
else
{
var record = _hrUnitOfWork.Repository <TrainCourse>().FirstOrDefault(a => a.Id == model.Id);
MapTrainCourse(record, model, moreInfo);
record.ModifiedTime = DateTime.Now;
record.ModifiedUser = UserName;
record.CompanyId = model.IsLocal ? CompanyId : (int?)null;
if (record.StartDate > record.EndDate)
{
ModelState.AddModelError("EndDate", MsgUtils.Instance.Trls("EndDateGthanStartDate"));
return(Json(Models.Utils.ParseFormErrors(ModelState)));
}
_hrUnitOfWork.TrainingRepository.Attach(record);
_hrUnitOfWork.TrainingRepository.Entry(record).State = EntityState.Modified;
}
var Errors = SaveChanges(Language);
var message = "OK";
if (Errors.Count > 0)
{
message = Errors.First().errors.First().message;
}
return(Json(message));
}
return(Json(Models.Utils.ParseFormErrors(ModelState)));
}
/// <summary>
/// 更新培训课程
/// </summary>
/// <param name="trainCourse"></param>
public void UpdateTrainCourse(TrainCourse trainCourse)
{
dal.UpdateTrainCourse(trainCourse);
}
public void DeleteTrainCourse(TrainCourse trainCourse)
{
dal.DeleteTrainCourse(trainCourse.TrainCourseID);
}
/// <summary>
/// 新增培训课程
/// </summary>
/// <param name="trainCourse"></param>
public void AddTrainCourse(TrainCourse trainCourse)
{
dal.AddTrainCourse(trainCourse);
}
