/// <summary>
/// 新增课程呈现
/// </summary>
public ViewResult AddYearCourse(string type, int ccid, string str)
{
ViewBag.year = Request.QueryString["year"] ?? DateTime.Now.Year.ToString();
ViewBag.month = Request.QueryString["month"] ?? DateTime.Now.Month.ToString();
ViewBag.trainGrade = trainBL.GetAllTrainGrade();
Tr_YearPlanCourse model = new Tr_YearPlanCourse();
if (!string.IsNullOrEmpty(str))
{
str = str.Replace(" ", "+");
string strr = System.Text.Encoding.UTF8.GetString(Convert.FromBase64String(str));
strr = System.Web.HttpUtility.HtmlDecode(strr);
string[] coList = strr.Split('♣');
model = new Tr_YearPlanCourse
{
CourseId = Convert.ToInt32(coList[0]),
CourseName = coList[1],
Code = coList[2],
Year = Convert.ToInt32(coList[3]),
Month = coList[4],
Day = Convert.ToInt32(coList[5]),
OpenLevel = coList[6],
IsMust = Convert.ToInt32(coList[7]),
Way = Convert.ToInt32(coList[8]),
Teacher = coList[9],
Realname = coList[10],
PayGrade = coList[11],
IsSystem = Convert.ToInt32(coList[12]),
IsCPA = Convert.ToInt32(coList[13]),
CourseLength = Convert.ToDecimal(coList[14])
};
}
else
{
model.CourseId = 0;
model.Code = "";
if (!string.IsNullOrEmpty(type) && ccid > 0)
{
model.CourseName = type;
model.IsSystem = ccid;
}
else
{
model.CourseName = "";
model.IsSystem = 0;
}
}
ViewData["model"] = model;
return(View());
}
/// <summary>
/// 增加
/// </summary>
/// <param name="model">实体</param>
public bool AddYearCourse(Tr_YearPlanCourse model)
{
using (IDbConnection conn = OpenConnection())
{
const string sqlwhere = @"INSERT INTO Tr_YearPlanCourse (YearId,CourseId,IsSystem) VALUES (@YearId,@CourseId,@IsSystem)";
var param = new
{
YearId = model.YearId,
CourseId = model.CourseId,
IsSystem = model.IsSystem
};
int result = conn.Execute(sqlwhere, param);
return(result > 0);
}
}
/// <summary>
/// 添加年计划课程
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool InsertYearCourse(Tr_YearPlanCourse model)
{
return(YearCourseDB.AddYearCourse(model));
}
