protected void Button1_Click(object sender, EventArgs e)
{
if (txtTitle.Text.Trim().Length > 0)
{
UserCookiesInfo UserCookiesInfo = BllOperationAboutUser.GetUserCookiesInfo();
CourseResources CourseResources = new CourseResources
{
classID = Server.UrlDecode(Request["classID"]),
termTag=Request["termtag"],
courseNo = Request["courseNo"],
updateTime = DateTime.Now,
courseResourceTitle = CommonUtility.JavascriptStringFilter(txtTitle.Text)
};
if (hidAttachmentId.Value.CompareTo(string.Empty) != 0)
{
CourseResources.attachmentIds = hidAttachmentId.Value;
}
DalOperationAboutCourseResources DalOperationAboutCourseResources = new DalOperationAboutCourseResources();
DalOperationAboutCourseResources.InsertCourseResources(CourseResources);
Javascript.RefreshParentWindow("添加成功!", "CInfoCourseResource.aspx?courseNo=" + CourseResources.courseNo + "&classID=" + Server.UrlEncode(Server.UrlDecode(Request["classID"].ToString().Trim())) + "&termtag=" + Request["termtag"].ToString().Trim(), Page);
}
else
{
Javascript.Alert("标题不能为空!", Page);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (txtTitle.Text.Trim().Length != 0)
{
UserCookiesInfo UserCookiesInfo = BllOperationAboutUser.GetUserCookiesInfo();
CourseResources CourseResources = new CourseResources
{
courseResourceId = int.Parse(Request["courseResourceId"]),
courseNo = Request["courseNo"],
attachmentIds = hidAttachmentId.Value,
updateTime = DateTime.Now,
courseResourceTitle = CommonUtility.JavascriptStringFilter(txtTitle.Text)
};
DalOperationAboutCourseResources DalOperationAboutCourseResources = new DalOperationAboutCourseResources();
DalOperationAboutCourseResources.UpdateCourseResources(CourseResources);
Javascript.RefreshParentWindow("修改成功!", "CInfoCourseResource.aspx?courseNo=" + CourseResources.courseNo+"&classID="+Server.UrlEncode(Server.UrlDecode(Request["classID"])), Page);
}
else
{
Javascript.Alert("标题不能为空！", Page);
}
}
/// <summary>
/// 通过课程资源主键查找课程资源
/// </summary>
/// <param name="CourseResourcesId">课程资源编号</param>
/// <returns>课程资源实体</returns>
public CourseResources GetCourseResourcesbyId(int CourseResourcesId)
{
CourseResources CourseResources = null;
string commandString = "SELECT [courseResourceId] ,[courseResourceTitle],[attachmentIds],[courseNo],[updateTime] FROM [usta_CourseResources] WHERE courseResourceId=@courseResourceId";
SqlParameter[] parameters = new SqlParameter[1]{new SqlParameter("@courseResourceId",CourseResourcesId)
};
SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, commandString, parameters);
while (dr.Read())
{
CourseResources = new CourseResources
{
courseResourceId = int.Parse(dr["courseResourceId"].ToString().Trim()),
courseResourceTitle = dr["courseResourceTitle"].ToString().Trim(),
attachmentIds = dr["attachmentIds"].ToString().Trim(),
courseNo = dr["courseNo"].ToString().Trim(),
updateTime = Convert.ToDateTime(dr["updateTime"].ToString().Trim())
};
}
dr.Close();
conn.Close();
return CourseResources;
}
/// <summary>
/// 更新某个课程资源
/// </summary>
/// <param name="courseResources">课程资源实体</param>
public void UpdateCourseResources(CourseResources courseResources)
{
try
{
string commandString = "UPDATE [USTA].[dbo].[usta_CourseResources] SET [courseResourceTitle] = @courseResourceTitle,[attachmentIds] = @attachmentIds ,[courseNo] = @courseNo,[updateTime] = @updateTime WHERE courseResourceId=@courseResourceId";
SqlParameter[] parameters = {
new SqlParameter("@courseResourceId", SqlDbType.Int,4),
new SqlParameter("@courseResourceTitle", SqlDbType.NChar,50),
new SqlParameter("@attachmentIds", SqlDbType.NVarChar,200),
new SqlParameter("@courseNo", SqlDbType.NChar,20),
new SqlParameter("@updateTime", SqlDbType.DateTime)};
parameters[0].Value = courseResources.courseResourceId;
parameters[1].Value = courseResources.courseResourceTitle;
parameters[2].Value = courseResources.attachmentIds;
parameters[3].Value = courseResources.courseNo;
parameters[4].Value = courseResources.updateTime;
SqlHelper.ExecuteNonQuery(conn, CommandType.Text, commandString, parameters);
}
catch (Exception ex)
{
MongoDBLog.LogRecord(ex);
CommonUtility.RedirectUrl();
}
finally
{
conn.Close();
}
}
/// <summary>
/// 插入一项课程资源
/// </summary>
/// <param name="courseResources">课程资源实体</param>
public void InsertCourseResources(CourseResources courseResources)
{
try
{
string commandString = "INSERT INTO [USTA].[dbo].[usta_CourseResources]([courseResourceTitle],[attachmentIds],[courseNo],[updateTime],classID,termTag) VALUES (@courseResourceTitle ,@attachmentIds,@courseNo,@updateTime,@classId,@termtag)";
SqlParameter[] parameters = {
new SqlParameter("@courseResourceTitle", SqlDbType.NChar,50),
new SqlParameter("@attachmentIds", SqlDbType.NVarChar,200),
new SqlParameter("@courseNo", SqlDbType.NChar,20),
new SqlParameter("@updateTime", SqlDbType.DateTime),
new SqlParameter("@classId", SqlDbType.NVarChar,50),
new SqlParameter("@termtag", SqlDbType.NVarChar,50)};
parameters[0].Value = courseResources.courseResourceTitle;
parameters[1].Value = courseResources.attachmentIds;
parameters[2].Value = courseResources.courseNo;
parameters[3].Value = courseResources.updateTime;
parameters[4].Value = courseResources.classID;
parameters[5].Value = courseResources.termTag;
SqlHelper.ExecuteNonQuery(conn, CommandType.Text, commandString, parameters);
}
catch (Exception ex)
{
MongoDBLog.LogRecord(ex);
CommonUtility.RedirectUrl();
}
finally
{
conn.Close();
}
}
