/// <summary> /// 绑定结课资料规则数据 /// </summary> public void DataBindArchivesItems() { DalOperationAboutArchivesItems doac = new DalOperationAboutArchivesItems(); UserCookiesInfo user = new UserCookiesInfo(); DataView dv = doac.GetAllArchivesItem().Tables[0].DefaultView; this.dlstArchivesItems.DataSource = dv; this.dlstArchivesItems.DataBind(); if (dv.Count == 0) { this.dlstArchivesItems.ShowFooter = true; } else { this.dlstArchivesItems.ShowFooter = false; } }
/// <summary> /// 文件上传 /// </summary> /// <param name="file">要上传的文件</param> /// <param name="fileFolderType">要上传的文件目录</param> /// <param name="userCookiesInfo">用户Cookies实体类</param> /// <returns>返回附件实体类</returns> public static Attachments doUpload(HttpPostedFile file, int fileFolderType, UserCookiesInfo userCookiesInfo) { //上传文件子目录,根据传入的枚举值进行获取 string fileFolderName = GetFileFolderName(fileFolderType); string fileFolderNameOnDate = GetSaveFilePath(); Attachments attachments = null; if (!Directory.Exists(uploadFileServerPath + fileFolderName + fileFolderNameOnDate)) { Directory.CreateDirectory(uploadFileServerPath + fileFolderName + fileFolderNameOnDate); } string strNewPath = string.Empty; string strFileName = file.FileName; strNewPath = fileFolderName + fileFolderNameOnDate + GetCorrectFileName(file.FileName).Replace(GetExtension(file.FileName), "") +"_"+ DateTimeString() + GetExtension(file.FileName); ////为作业或实验上传文件重命名文件名称 //if (fileFolderType == (int)FileFolderType.experiments || fileFolderType == (int)FileFolderType.schoolWorks) //{ // strNewPath = fileFolderName + fileFolderNameOnDate + UploadFileRename.RenameExperimentsOrSchoolWorks(userCookiesInfo) + GetExtension(file.FileName); //} ////为批改后的作业或实验上传文件重命名文件名称 //if (fileFolderType == (int)FileFolderType.remarkExperimentsAndSchoolWorks) //{ // strNewPath = fileFolderName + fileFolderNameOnDate + UploadFileRename.RenameRemarkExperimentsAndSchoolWorks(userCookiesInfo) + GetExtension(file.FileName); //} ////为作业或实验上传文件重命名附件名称 //if (fileFolderType == (int)FileFolderType.experiments || fileFolderType == (int)FileFolderType.schoolWorks) //{ // attachments.attachmentTitle = UploadFileRename.RenameExperimentsOrSchoolWorks(userCookiesInfo) + GetExtension(file.FileName); //} file.SaveAs(uploadFileServerPath + strNewPath); attachments = new Attachments { attachmentUrl = uploadFileFolderName + strNewPath, attachmentTitle = GetCorrectFileName(file.FileName) }; return attachments; }
/// <summary> /// 检测用户登录合法性 /// </summary> /// <param name="CheckUserLogin">用户登陆实体</param> /// <returns>用户登陆信息实体</returns> public UserCookiesInfo CheckUserLogin(CheckUserLogin CheckUserLogin) { UserCookiesInfo UserCookiesInfo = null; SqlDataReader dr = SqlHelper.ExecuteReader(conn, CheckUserLogin.spName, CheckUserLogin.sqlParammeters); while (dr.Read()) { UserCookiesInfo = new UserCookiesInfo { userNo = dr[0].ToString(), userName = dr[2].ToString() }; UserCookiesInfo.userType = ((dr["isAdmin"] != null && bool.Parse(dr["isAdmin"].ToString().Trim())) ? 0 : CheckUserLogin.userType); UserCookiesInfo.teacherType = (dr.FieldCount !=6 ? "student" : dr["TeacherType"].ToString().Trim()); UserCookiesInfo.Sex = (dr.FieldCount != 6 ? "student" : dr["Sex"].ToString().Trim()); ; } dr.Close(); conn.Close(); return UserCookiesInfo; }
/// <summary> /// 回传文件命名方法 /// </summary> /// <param name="userCookiesInfo">用户Cookie信息</param> /// <returns>规范后的命名格式</returns> public static string RenameRemarkExperimentsAndSchoolWorks(UserCookiesInfo userCookiesInfo) { return userCookiesInfo.userNo.Trim() + "_" + userCookiesInfo.userName.Trim() + "(已批阅)" + "_" + UploadFiles.DateTimeString(); }
/// <summary> ///作业及实验报告命名方法 /// </summary> /// <param name="userCookiesInfo">用户Cookie信息</param> /// <returns>规范后的命名格式</returns> public static string RenameExperimentsOrSchoolWorks(UserCookiesInfo userCookiesInfo) { return String.Format("{0}_{1}_{2}", userCookiesInfo.userNo.Trim(), userCookiesInfo.userName.Trim(), UploadFiles.DateTimeString()); }
/// <summary> /// 通过登录用户查找此用户的反馈 /// </summary> /// <param name="user">用户登陆系统实体</param> /// <returns>数据集</returns> public DataSet FindByUser(UserCookiesInfo user) { string sql = "SELECT [feedBackId],[feedBackTitle],[feedBackContent],[feedBackContactTo],[isRead],[updateTime],[backInfo],[backTime],[backUserNo],[backUserType],type FROM [USTA].[dbo].[usta_FeedBack] WHERE backUserNo=@backUser AND backUserType=@backUserType"; SqlParameter[] parameters = { new SqlParameter("@backUser", SqlDbType.NVarChar,50), new SqlParameter("@backUserType", SqlDbType.Int)}; parameters[0].Value = user.userNo; parameters[1].Value = user.userType; return SqlHelper.ExecuteDataset(conn, CommandType.Text, sql, parameters); }