/// <summary>
/// 根据主键删除培训计划信息
/// </summary>
/// <param name="planId"></param>
public static void DeletePlanById(string planId)
{
Model.Training_Plan plan = Funs.DB.Training_Plan.FirstOrDefault(e => e.PlanId == planId);
if (plan != null)
{
Funs.DB.Training_Plan.DeleteOnSubmit(plan);
Funs.DB.SubmitChanges();
}
}
/// <summary>
/// 修改培训计划
/// </summary>
/// <param name="plan"></param>
public static void UpdatePlan(Model.Training_Plan plan)
{
Model.Training_Plan newPlan = Funs.DB.Training_Plan.FirstOrDefault(e => e.PlanId == plan.PlanId);
if (newPlan != null)
{
newPlan.PlanCode = plan.PlanCode;
newPlan.PlanName = plan.PlanName;
newPlan.DesignerId = plan.DesignerId;
newPlan.DesignerDate = plan.DesignerDate;
newPlan.WorkPostId = plan.WorkPostId;
newPlan.QRCodeUrl = plan.QRCodeUrl;
newPlan.States = plan.States;
Funs.DB.SubmitChanges();
}
}
/// <summary>
/// 添加培训计划
/// </summary>
/// <param name="plan"></param>
public static void AddPlan(Model.Training_Plan plan)
{
Model.Training_Plan newPlan = new Model.Training_Plan
{
PlanId = plan.PlanId,
PlanCode = plan.PlanCode,
PlanName = plan.PlanName,
DesignerId = plan.DesignerId,
DesignerDate = plan.DesignerDate,
WorkPostId = plan.WorkPostId,
States = plan.States
};
db.Training_Plan.InsertOnSubmit(newPlan);
db.SubmitChanges();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.Training_Plan GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id, PartitionId, Title, IsOpen, Sort, Display, Delflag, CreateDate,SignUpStartTime,SignUpEndTime,OpenClassFrom,OpenClassTo ");
strSql.Append(" from Training_Plan ");
strSql.Append(" where ");
strSql.Append(" Id = @Id ");
SqlParameter[] parameters = {
new SqlParameter("@Id", SqlDbType.Int,4)
};
parameters[0].Value = Id;
Model.Training_Plan model = new Model.Training_Plan();
DataSet ds = MSEntLibSqlHelper.ExecuteDataSetBySql(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Id"].ToString() != "")
{
model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
}
if (ds.Tables[0].Rows[0]["PartitionId"].ToString() != "")
{
model.PartitionId = int.Parse(ds.Tables[0].Rows[0]["PartitionId"].ToString());
}
model.Title = ds.Tables[0].Rows[0]["Title"].ToString();
if (ds.Tables[0].Rows[0]["IsOpen"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["IsOpen"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsOpen"].ToString().ToLower() == "true"))
{
model.IsOpen = true;
}
else
{
model.IsOpen = false;
}
}
if (ds.Tables[0].Rows[0]["Sort"].ToString() != "")
{
model.Sort = int.Parse(ds.Tables[0].Rows[0]["Sort"].ToString());
}
if (ds.Tables[0].Rows[0]["Display"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["Display"].ToString() == "1") || (ds.Tables[0].Rows[0]["Display"].ToString().ToLower() == "true"))
{
model.Display = true;
}
else
{
model.Display = false;
}
}
if (ds.Tables[0].Rows[0]["Delflag"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["Delflag"].ToString() == "1") || (ds.Tables[0].Rows[0]["Delflag"].ToString().ToLower() == "true"))
{
model.Delflag = true;
}
else
{
model.Delflag = false;
}
}
if (ds.Tables[0].Rows[0]["CreateDate"].ToString() != "")
{
model.CreateDate = DateTime.Parse(ds.Tables[0].Rows[0]["CreateDate"].ToString());
}
if (ds.Tables[0].Rows[0]["SignUpStartTime"].ToString() != "")
{
model.SignUpStartTime = DateTime.Parse(ds.Tables[0].Rows[0]["SignUpStartTime"].ToString());
}
if (ds.Tables[0].Rows[0]["SignUpEndTime"].ToString() != "")
{
model.SignUpEndTime = DateTime.Parse(ds.Tables[0].Rows[0]["SignUpEndTime"].ToString());
}
if (ds.Tables[0].Rows[0]["OpenClassFrom"].ToString() != "")
{
model.OpenClassFrom = DateTime.Parse(ds.Tables[0].Rows[0]["OpenClassFrom"].ToString());
}
if (ds.Tables[0].Rows[0]["OpenClassTo"].ToString() != "")
{
model.OpenClassTo = DateTime.Parse(ds.Tables[0].Rows[0]["OpenClassTo"].ToString());
}
return model;
}
else
{
return null;
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public List<Model.Training_Plan> DataTableToList(DataTable dt)
{
List<Model.Training_Plan> modelList = new List<Model.Training_Plan>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Model.Training_Plan model;
for (int n = 0; n < rowsCount; n++)
{
model = new Model.Training_Plan();
if (dt.Rows[n]["Id"].ToString() != "")
{
model.Id = int.Parse(dt.Rows[n]["Id"].ToString());
}
if (dt.Rows[n]["PartitionId"].ToString() != "")
{
model.PartitionId = int.Parse(dt.Rows[n]["PartitionId"].ToString());
}
model.Title = dt.Rows[n]["Title"].ToString();
if (dt.Rows[n]["IsOpen"].ToString() != "")
{
if ((dt.Rows[n]["IsOpen"].ToString() == "1") || (dt.Rows[n]["IsOpen"].ToString().ToLower() == "true"))
{
model.IsOpen = true;
}
else
{
model.IsOpen = false;
}
}
if (dt.Rows[n]["Sort"].ToString() != "")
{
model.Sort = int.Parse(dt.Rows[n]["Sort"].ToString());
}
if (dt.Rows[n]["Display"].ToString() != "")
{
if ((dt.Rows[n]["Display"].ToString() == "1") || (dt.Rows[n]["Display"].ToString().ToLower() == "true"))
{
model.Display = true;
}
else
{
model.Display = false;
}
}
if (dt.Rows[n]["Delflag"].ToString() != "")
{
if ((dt.Rows[n]["Delflag"].ToString() == "1") || (dt.Rows[n]["Delflag"].ToString().ToLower() == "true"))
{
model.Delflag = true;
}
else
{
model.Delflag = false;
}
}
if (dt.Rows[n]["CreateDate"].ToString() != "")
{
model.CreateDate = DateTime.Parse(dt.Rows[n]["CreateDate"].ToString());
}
modelList.Add(model);
}
}
return modelList;
}
/// <summary>
/// 保存TrainingPlan
/// </summary>
/// <param name="trainingPlan">培训计划记录</param>
/// <param name="trainingTasks">培训人员list</param>
/// <param name="trainingPlanItems">培训教材类型list</param>
public static void SaveTrainingPlan(Model.TrainingPlanItem trainingPlan)
{
using (Model.SUBHSSEDB db = new Model.SUBHSSEDB(Funs.ConnString))
{
Model.Training_Plan newTrainingPlan = new Model.Training_Plan
{
PlanId = trainingPlan.PlanId,
PlanCode = trainingPlan.PlanCode,
ProjectId = trainingPlan.ProjectId,
DesignerId = trainingPlan.DesignerId,
PlanName = trainingPlan.PlanName,
TrainContent = trainingPlan.TrainContent,
TrainStartDate = Funs.GetNewDateTime(trainingPlan.TrainStartDate),
TeachHour = trainingPlan.TeachHour,
TeachMan = trainingPlan.TeachMan,
TeachAddress = trainingPlan.TeachAddress,
TrainTypeId = trainingPlan.TrainTypeId,
UnitIds = trainingPlan.UnitIds,
WorkPostId = trainingPlan.WorkPostId,
States = trainingPlan.States,
};
if (!string.IsNullOrEmpty(trainingPlan.TrainLevelId))
{
newTrainingPlan.TrainLevelId = trainingPlan.TrainLevelId;
}
if (newTrainingPlan.TrainStartDate.HasValue && newTrainingPlan.TeachHour.HasValue)
{
double dd = (double)((decimal)newTrainingPlan.TeachHour.Value);
newTrainingPlan.TrainEndDate = newTrainingPlan.TrainStartDate.Value.AddHours(dd);
}
List <Model.TrainingTaskItem> trainingTasks = trainingPlan.TrainingTasks;
List <Model.TrainingPlanItemItem> trainingPlanItems = trainingPlan.TrainingPlanItems;
var isUpdate = db.Training_Plan.FirstOrDefault(x => x.PlanId == newTrainingPlan.PlanId);
if (isUpdate == null)
{
newTrainingPlan.DesignerDate = DateTime.Now;
string unitId = string.Empty;
var user = UserService.GetUserByUserId(newTrainingPlan.DesignerId);
if (user != null)
{
unitId = user.UnitId;
}
newTrainingPlan.PlanCode = CodeRecordsService.ReturnCodeByMenuIdProjectId(Const.ProjectTrainingPlanMenuId, newTrainingPlan.ProjectId, unitId);
if (string.IsNullOrEmpty(newTrainingPlan.PlanId))
{
newTrainingPlan.PlanId = SQLHelper.GetNewID();
}
db.Training_Plan.InsertOnSubmit(newTrainingPlan);
db.SubmitChanges();
CodeRecordsService.InsertCodeRecordsByMenuIdProjectIdUnitId(Const.ProjectTrainingPlanMenuId, newTrainingPlan.ProjectId, null, newTrainingPlan.PlanId, newTrainingPlan.DesignerDate);
}
else
{
if (newTrainingPlan.States == "0" || newTrainingPlan.States == "1")
{
isUpdate.PlanName = newTrainingPlan.PlanName;
isUpdate.TrainContent = newTrainingPlan.TrainContent;
isUpdate.TrainStartDate = newTrainingPlan.TrainStartDate;
isUpdate.TeachHour = newTrainingPlan.TeachHour;
isUpdate.TrainEndDate = newTrainingPlan.TrainEndDate;
isUpdate.TeachMan = newTrainingPlan.TeachMan;
isUpdate.TeachAddress = newTrainingPlan.TeachAddress;
isUpdate.TrainTypeId = newTrainingPlan.TrainTypeId;
isUpdate.TrainLevelId = newTrainingPlan.TrainLevelId;
isUpdate.UnitIds = newTrainingPlan.UnitIds;
isUpdate.WorkPostId = newTrainingPlan.WorkPostId;
isUpdate.States = newTrainingPlan.States;
db.SubmitChanges();
}
////删除培训任务
var tasks = from x in db.Training_Task where x.PlanId == newTrainingPlan.PlanId select x;
if (tasks.Count() > 0)
{
var taskItems = from x in db.Training_TaskItem where x.PlanId == newTrainingPlan.PlanId select x;
if (tasks.Count() > 0)
{
db.Training_TaskItem.DeleteAllOnSubmit(taskItems);
db.SubmitChanges();
}
db.Training_Task.DeleteAllOnSubmit(tasks);
db.SubmitChanges();
}
////删除培训教材类型
var planItem = (from x in db.Training_PlanItem where x.PlanId == newTrainingPlan.PlanId select x).ToList();
if (planItem.Count() > 0)
{
db.Training_PlanItem.DeleteAllOnSubmit(planItem);
db.SubmitChanges();
}
}
if (trainingTasks.Count() > 0)
{
////新增培训人员明细
foreach (var item in trainingTasks)
{
if (!string.IsNullOrEmpty(item.PersonId))
{
Model.Training_Task newTrainDetail = new Model.Training_Task
{
TaskId = SQLHelper.GetNewID(),
ProjectId = newTrainingPlan.ProjectId,
PlanId = newTrainingPlan.PlanId,
UserId = item.PersonId,
TaskDate = DateTime.Now,
States = Const.State_0, ////未生成培训教材明细
};
db.Training_Task.InsertOnSubmit(newTrainDetail);
db.SubmitChanges();
}
}
}
if (trainingPlanItems.Count() > 0)
{
////新增培训教材类型明细
foreach (var item in trainingPlanItems)
{
if (!string.IsNullOrEmpty(item.CompanyTrainingId) || !string.IsNullOrEmpty(item.CompanyTrainingItemId))
{
Model.Training_PlanItem newPlanItem = new Model.Training_PlanItem
{
PlanItemId = SQLHelper.GetNewID(),
PlanId = newTrainingPlan.PlanId,
};
if (!string.IsNullOrEmpty(item.CompanyTrainingId))
{
newPlanItem.CompanyTrainingId = item.CompanyTrainingId;
}
if (!string.IsNullOrEmpty(item.CompanyTrainingItemId))
{
newPlanItem.CompanyTrainingItemId = item.CompanyTrainingItemId;
}
db.Training_PlanItem.InsertOnSubmit(newPlanItem);
db.SubmitChanges();
}
}
}
}
}
