/// <summary> /// 插入一条课程归档记录 /// </summary> /// <param name="archives">课程归档实体</param> public void AddArchives(Archives archives) { try { string cmdstring = "INSERT INTO [USTA].[dbo].[usta_Archives] ([attachmentIds],[courseNo],classID,termTag,teacherType,archiveItemId) VALUES ( @attachmentIds,@courseNo,@classId,@termtag,@teacherType,@archiveItemId)"; SqlParameter[] parameters = { new SqlParameter("@attachmentIds", SqlDbType.NVarChar,200), new SqlParameter("@courseNo", SqlDbType.NChar,20), new SqlParameter("@classId", SqlDbType.NVarChar,50), new SqlParameter("@termtag", SqlDbType.NVarChar,50), new SqlParameter("@teacherType", SqlDbType.NChar,10) , new SqlParameter("@archiveItemId", SqlDbType.Int,4) }; parameters[0].Value = archives.attachmentIds; parameters[1].Value = archives.courseNo; parameters[2].Value = archives.classID; parameters[3].Value = archives.termTag; parameters[4].Value = archives.teacherType; parameters[5].Value = archives.archiveItemId; SqlHelper.ExecuteNonQuery(conn, CommandType.Text, cmdstring, parameters); } catch (Exception ex) { MongoDBLog.LogRecord(ex); CommonUtility.RedirectUrl(); } finally { conn.Close(); } }
/// <summary> /// 更新课程归档 /// </summary> /// <param name="archives">课程归档实体</param> public void UpdateArchives(Archives archives) { try { string cmdstring = "UPDATE [USTA].[dbo].[usta_Archives] SET [attachmentIds] = @attachmentIds WHERE archiveId=@archiveId"; SqlParameter[] parameters = { new SqlParameter("@archiveId", SqlDbType.Int,4), new SqlParameter("@attachmentIds", SqlDbType.NVarChar,200) }; parameters[0].Value = archives.archiveId; parameters[1].Value = archives.attachmentIds; SqlHelper.ExecuteNonQuery(conn, CommandType.Text, cmdstring, parameters); } catch (Exception ex) { MongoDBLog.LogRecord(ex); CommonUtility.RedirectUrl(); } finally { conn.Close(); } }
/// <summary> /// 获取课程归档() /// </summary> /// <param name="courseNo">课程编号</param> /// <param name="classId">classId</param> /// <param name="termtag">termtag</param> /// <param name="termtag">teacherType</param> /// <returns>课程归档实体</returns> public Archives FindArchivesByCourseNoCompatible(string courseNo, string classId, string termtag) { Archives archives = new Archives { attachmentIds = string.Empty }; string cmdstring = "SELECT [archiveId],[archiveItemId],[attachmentIds],[courseNo],[teacherType],[classID],[termTag] FROM [USTA].[dbo].[usta_Archives] WHERE courseNo=@courseNo AND classID=@classID AND termTag=@termTag"; SqlParameter[] parameters = new SqlParameter[]{ new SqlParameter("@courseNo",courseNo), new SqlParameter("@classID",classId), new SqlParameter("@termTag",termtag) }; SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, cmdstring, parameters); if (dr.Read()) { archives = new Archives { archiveId = int.Parse(dr["archiveId"].ToString()), attachmentIds = dr["attachmentIds"].ToString().Trim(), courseNo = dr["courseNo"].ToString().Trim(), classID = dr["classID"].ToString().Trim(), termTag = dr["termTag"].ToString().Trim() }; } dr.Close(); conn.Close(); return archives; }
/// <summary> /// 获得课程归档 /// </summary> /// <param name="archiveId">课程归档主键</param> /// <returns>课程归档对象</returns> public Archives FindArchivesById(int archiveId) { Archives archives = null; string cmdstring = "SELECT [archiveId],[attachmentIds],[usta_Archives].[courseNo],[courseName] FROM [USTA].[dbo].[usta_Archives],usta_Courses WHERE archiveId=@archiveId AND usta_Courses.courseNo=usta_Archives.courseNo"; SqlParameter[] parameters = new SqlParameter[1]{ new SqlParameter("@archiveId",archiveId) }; SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, cmdstring, parameters); if (dr.Read()) { archives = new Archives { archiveId = int.Parse(dr["archiveId"].ToString()), attachmentIds = dr["attachmentIds"].ToString().Trim(), courseNo = dr["courseNo"].ToString().Trim(), }; } dr.Close(); conn.Close(); return archives; }
//结课资料 protected void btnUpload_Click(object sender, EventArgs e) { List<int> listArchiveItemIds = new List<int>(); List<string> listArchivesAttachmentIds = new List<string>(); DalOperationAboutArchives doaa = new DalOperationAboutArchives(); foreach (Control ctlTable in phUpload.Controls) { foreach (Control ctlTableRow in ctlTable.Controls) { foreach (Control ctlTableCell in ctlTableRow.Controls) { foreach (Control ctl in ctlTableCell.Controls) { string _type = ctl.GetType().ToString(); if (_type == "System.Web.UI.WebControls.HiddenField") { if (ctl.ID.StartsWith("hid_")) { listArchiveItemIds.Add(int.Parse(ctl.ID.Split("_".ToCharArray())[1])); } else if (ctl.ID.StartsWith("hidAttachmentId")) { listArchivesAttachmentIds.Add(((HiddenField)ctl).Value); } } } } } } Archives archives = new Archives { courseNo = Request["courseNo"], classID = Server.UrlDecode(Request["classID"]), termTag = Request["termTag"].Trim(), teacherType = teacherType }; for (int i = 0; i < listArchiveItemIds.Count; i++) { archives.archiveItemId = listArchiveItemIds[i]; archives.attachmentIds = listArchivesAttachmentIds[i]; //判断是否存在课程结课资料记录,并返回archiveId int archiveId = doaa.IsExistArchivesBycourseNo(courseNo, classID, termtag, teacherType, archives.archiveItemId); if (archiveId != 0) { archives.archiveId = archiveId; doaa.UpdateArchives(archives); Javascript.RefreshParentWindow("上传成功!", "/Administrator/ArchivesManage.aspx?fragment=1&termTag=" + termtag + "&locale=" + Server.UrlEncode(locale) + "&keyword=" + Server.UrlEncode(keyword) + "#archive_" + anchor, Page); } else { doaa.AddArchives(archives); Javascript.RefreshParentWindow("上传成功!", "/Administrator/ArchivesManage.aspx?fragment=1&termTag=" + termtag + "&locale=" + Server.UrlEncode(locale) + "&keyword=" + Server.UrlEncode(keyword) + "#archive_" + anchor, Page); } } }