/// <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);
}
