private void ConvertToModel2(IDataReader reader, PracticalCourseEdit model)
{
if (reader["Id"] != DBNull.Value)
model.Id = Convert.ToInt32(reader["Id"]);
if (reader["Title"] != DBNull.Value)
model.Title = reader["Title"].ToString();
if (reader["TraingField"] != DBNull.Value)
model.TraingField = Convert.ToInt32(reader["TraingField"]);
if (reader["Content"] != DBNull.Value)
model.Content = reader["Content"].ToString();
if (reader["IsBatch"] != DBNull.Value)
model.IsBatch = Convert.ToBoolean(reader["IsBatch"]);
if (reader["OrganId"] != DBNull.Value)
model.OrganId = Convert.ToInt32(reader["OrganId"]);
if (reader["AccountId"] != DBNull.Value)
model.AccountId = Convert.ToInt32(reader["AccountId"]);
if (reader["PlanId"] != DBNull.Value)
model.PlanId = Convert.ToInt32(reader["PlanId"]);
if (reader["People"] != DBNull.Value)
model.People = Convert.ToInt32(reader["People"]);
if (reader["Display"] != DBNull.Value)
model.Display = Convert.ToBoolean(reader["Display"]);
if (reader["Delflag"] != DBNull.Value)
model.Delflag = Convert.ToBoolean(reader["Delflag"]);
if (reader["CreateDate"] != DBNull.Value)
model.CreateDate = Convert.ToDateTime(reader["CreateDate"]);
if (reader["TraingCategory"] != DBNull.Value)
model.TraingCategory = Convert.ToInt32(reader["TraingCategory"]);
if (reader["TraingTopic"] != DBNull.Value)
model.TraingTopic = Convert.ToInt32(reader["TraingTopic"]);
if (reader["RoleId"] != DBNull.Value)
model.Role = Convert.ToInt32(reader["RoleId"]);
if (reader["memberPCourseid"] != DBNull.Value)
model.MemberPCourseid = Convert.ToInt32(reader["memberPCourseid"]);
if (reader["NationalCoursId"] != DBNull.Value)
model.NationalCoursId = Convert.ToInt32(reader["NationalCoursId"]);
if (reader["Status"] != DBNull.Value)
model.Status = Convert.ToInt32(reader["Status"]);
if (reader["ApplyRemark"] != DBNull.Value)
model.ApplyRemark = reader["ApplyRemark"].ToString();
}
public PracticalCourseEdit GetPracticeModel(int MemberPracticeId)
{
string sql = "select pcd.*,mpc.RoleId,mpc.Id as MemberPCourseid,mpc.Status,mpc.ApplyRemark from Member_PracticalCourse mpc left join [PracticalCourse_Detail] pcd on mpc.PracticalCourseId=pcd.Id where mpc.Id=@Id";
SqlParameter[] cmdParams = new SqlParameter[]{
new SqlParameter("@Id", SqlDbType.Int, 4) { Value = MemberPracticeId }
};
using (IDataReader reader = MSEntLibSqlHelper.ExecuteDataReaderBySql(sql, cmdParams))
{
if (reader.Read())
{
PracticalCourseEdit model = new PracticalCourseEdit();
ConvertToModel2(reader, model);
return model;
}
else
{
return null;
}
}
}
public ActionResult PracticalCourseEditSingle(int? Type,int? memberPCourseid)
{
ViewBag.Type = Type;
//小类
Traning_CategoryBLL traning_CategoryBLL = new Traning_CategoryBLL();
ViewBag.TraingCategoryList = traning_CategoryBLL.GetList(" Field=3 and Delflag='false' and Display='true'", " Sort");
//初始化model
PracticalCourse_DetailBLL pcBLL = new PracticalCourse_DetailBLL();
PracticalCourseEdit data = new PracticalCourseEdit();
PracticalCourse_AttachmentBLL practicalCourse_AttachmentBLL = new PracticalCourse_AttachmentBLL();
if (memberPCourseid != null && memberPCourseid > 0)
{
ViewBag.Group = Code.SiteCache.Instance.GroupId;
ViewBag.Title = "修改实践记录";
data = pcBLL.GetPracticeModel((int)memberPCourseid);
ViewBag.AttachData = practicalCourse_AttachmentBLL.GetTable("Delflag=0 and Display=1 and PracticalCourseId=" + data.Id, "");
}
//Member_PracticalCourseApplicationBLL member_PracticalCourseApplicationBLL = new Member_PracticalCourseApplicationBLL();
//List<Member_PracticalCourseApplication> mPcaList = member_PracticalCourseApplicationBLL.GetList("Delflag='false' and FlowId='" + memberPCourseid + "'", "CreateDate");
//ViewBag.mPcaList = mPcaList;
return View(data);
}
public ActionResult PracticalCourseVerifyPage(int memberPCourseid)
{
ViewBag.Title = "实践审核";
//小类
Traning_CategoryBLL traning_CategoryBLL = new Traning_CategoryBLL();
ViewBag.TraingCategoryList = traning_CategoryBLL.GetList(" Field=3 and Delflag='false' and Display='true'", " Sort");
//初始化model
PracticalCourse_DetailBLL pcBLL = new PracticalCourse_DetailBLL();
PracticalCourseEdit data = new PracticalCourseEdit();
PracticalCourse_AttachmentBLL practicalCourse_AttachmentBLL = new PracticalCourse_AttachmentBLL();
if ( memberPCourseid > 0)
{
ViewBag.Title = "实践审核";
data = pcBLL.GetPracticeModel((int)memberPCourseid);
ViewBag.AttachData = practicalCourse_AttachmentBLL.GetTable("Delflag=0 and Display=1 and PracticalCourseId=" + data.Id, "");
}
else
{
return RedirectToAction("PracticalCourseList", "PracticalCourse", new { area = "Practice" });
}
return View(data);
}
public ActionResult PracticalCourseAddSingle(int? memberPCourseid)
{
//小类
Traning_CategoryBLL traning_CategoryBLL = new Traning_CategoryBLL();
ViewBag.TraingCategoryList = traning_CategoryBLL.GetList(" Field=3 and Delflag='false' and Display='true'", " Sort");
//初始化model
PracticalCourse_DetailBLL pcBLL = new PracticalCourse_DetailBLL();
PracticalCourseEdit data = new PracticalCourseEdit();
PracticalCourse_AttachmentBLL practicalCourse_AttachmentBLL = new PracticalCourse_AttachmentBLL();
if (memberPCourseid != null && memberPCourseid > 0)
{
ViewBag.Type = "update";
ViewBag.Title = "修改实践记录";
data = pcBLL.GetPracticeModel((int)memberPCourseid);
ViewBag.AttachData = practicalCourse_AttachmentBLL.GetTable("Delflag=0 and Display=1 and PracticalCourseId=" + data.Id, "");
}
else
{
ViewBag.Type = "insert";
ViewBag.Title = "新增实践记录";
ViewBag.AttachData = null;
}
return View(data);
}
