public string UploadFile(FileUpload Fupload, string str_mulu, string str_maxid)
{
//文件上传
string str_ParentFolder;
string str_NewFileName, str_OriginalFileName;
try
{
if (Fupload.PostedFile.FileName == "")
{
return(",");
}
str_ParentFolder = Server.MapPath(".\\" + str_mulu + "\\");
//创建文件夹
if (!Directory.Exists(str_ParentFolder))
{
Directory.CreateDirectory(str_ParentFolder);
if (!Directory.Exists(str_ParentFolder))
{
return("");
}
}
string extname;
extname = Fupload.FileName.Substring(Fupload.FileName.LastIndexOf(".") + 1).ToUpper();
str_OriginalFileName = Fupload.FileName;
str_NewFileName = str_maxid + "." + extname;
//判断上传课件类型，大小
string str_sql = "select url from t_dict where flm = 8 and bm in (4,5)";
DataView dv = DBFun.dataView(str_sql);
string str_UploadFileType = dv.Table.Rows[0]["url"].ToString();
string str_UploadFileSize = dv.Table.Rows[1]["url"].ToString();
if (str_UploadFileType.IndexOf(extname.ToLower()) == -1)
{
Response.Write("<script>alert('不允许上传 " + extname + " 类型的文件！');</script>");
return("");
}
if (Convert.ToDecimal(str_UploadFileSize) * Convert.ToDecimal(1024) < Fupload.PostedFile.ContentLength)
{
Response.Write("<script>alert('不允许上传超过 " + str_UploadFileSize + "KB的文件！');</script>");
return("");
}
Fupload.PostedFile.SaveAs(str_ParentFolder + "\\" + str_NewFileName);
Session["FilePath"] = str_ParentFolder + "\\" + str_NewFileName;
Fupload.Dispose();
return(str_OriginalFileName + "," + str_NewFileName);
}
catch
{
File.Delete(Session["FilePath"].ToString());
Response.Write("<script>alert('文件上传失败！');</script>");
return("");
}
}
protected void btn_calc_Click(object sender, EventArgs e)
{
string str_sql = "alter table cpry add column score_xmrw numeric,score_lzbg numeric,score_yjcg numeric";
try { DBFun.ExecuteSql(str_sql); }
catch { }
str_sql = "select sfzh,sbzw from cpry,t_dict " +
"where url=gzdw and edit_flag=false and cpry.tj_flag='推荐' and sh_flag='通过' and t_dict.tj_flag=true order by gzdw asc, ID asc;";
DataView dv = DBFun.dataView(str_sql);
DataView dv_zj;
for (int i = 0; i < dv.Table.Rows.Count; i++)
{
Session["sfzh"] = dv.Table.Rows[i]["sfzh"].ToString();
string str_score = "";
if (dv.Table.Rows[i]["sbzw"].ToString() == "研究员")
{
str_score = GetScore_yjy();
}
else
{
str_score = GetScore_gg();
}
string str_s1, str_s2, str_s3, str_s4;
str_s1 = str_score.Substring(0, str_score.IndexOf(","));
str_s2 = str_score.Substring(str_score.IndexOf(",") + 1, str_score.LastIndexOf(",") - str_score.IndexOf(",") - 1);
str_s3 = str_score.Substring(str_score.LastIndexOf(",") + 1);
//计算专家评分
string strqry = "select iif(isnull(fs_pjys_sum),'0',fs_pjys_sum) as fs_sum,zj_sfzh,cpry_sfzh,jypj,UserName,zjdm,iif(isnull(fs_pjys_sum),'否','是') as sfpj from zjry,pszj where sfzh = zj_sfzh and pszj.flag = 1 ";
strqry = strqry + " and cpry_sfzh = '" + dv.Table.Rows[i]["sfzh"].ToString() + "'";
dv_zj = DBFun.GetDataView(strqry);
str_s4 = PrivateFun.Get_Score_zj(dv_zj);
str_sql = "update cpry set score_xmrw = " + str_s1 + ",score_lzbg=" + str_s2 + ",score_yjcg=" + str_s3 + ",score_zj=" + str_s4 + " where sfzh = '" + Session["sfzh"].ToString() + "';";
if (!DBFun.ExecuteUpdate(str_sql))
{
Response.Write("<script>alert('计算分数失败，请重新计算！');</script>");
return;
}
}
Response.Write("<script>alert('计算分数成功！');</script>");
}
public string UploadFile(FileUpload Fupload, string str_mulu, string str_maxid)
{
//文件上传
string str_ParentFolder;
string str_NewFileName, str_OriginalFileName;
try
{
if (Fupload.PostedFile.FileName == "")
{
return(",");
}
str_ParentFolder = Server.MapPath(".\\" + str_mulu + "\\");
//创建以教师id+课程id为名的文件夹
//string str_TeacherId, str_CourseId, str_FileType;
//str_TeacherId = Session["TeacherID"].ToString();
//str_CourseId = ddlist_Course.SelectedValue;
//str_FileType = ddlist_Type.SelectedValue;
//dir = str_TeacherId + "_" + str_CourseId;
if (!Directory.Exists(str_ParentFolder))
{
Directory.CreateDirectory(str_ParentFolder);
if (!Directory.Exists(str_ParentFolder))
{
return("");
}
}
//Random rd = new Random();
string extname;
extname = Fupload.FileName.Substring(Fupload.FileName.LastIndexOf(".") + 1).ToUpper();
str_OriginalFileName = Fupload.FileName;
str_NewFileName = str_maxid + "." + extname;
//判断上传课件类型
string str_sql = "select url from t_dict where flm=8 and bm in (7,8)";
DataView dv = DBFun.dataView(str_sql);
string str_UploadFileType = dv.Table.Rows[0]["url"].ToString();
string str_UploadFileSize = dv.Table.Rows[1]["url"].ToString();
if (str_UploadFileType.IndexOf(extname.ToLower()) == -1)
{
Response.Write("<script>alert('不允许上传 " + extname + " 类型的文件！');</script>");
return("");
}
if (Convert.ToInt16(str_UploadFileSize) * 1024 < Fupload.PostedFile.ContentLength)
{
Response.Write("<script>alert('不允许上传超过 " + str_UploadFileSize + " K的文件！');</script>");
return("");
}
//string str_sql;
//str_sql = " Select iif(Max(FileID),Max(FileID)+1,1) " +
// " From CourseTeacher " +
// " Where (CourseID=" + str_CourseId + ") AND (TeacherID = " + str_TeacherId + ");";
//int i_MaxID = (int)DBFun.ExecuteScalar(str_sql);
///*判断是否更名*/
//if (tbx_Rename.Visible & tbx_Rename.Text.Trim() != "")
//{
// filename = tbx_Rename.Text.Trim() + "." + extname;
//}
//else
//{
// filename = Fupload.FileName;
//}
//if (File.Exists(str_ParentFolder + dir + "\\" + filename))
//{
// Response.Write("<script>alert('文件 " + filename + " 已存在！');</script>");
// return "";
//}
Fupload.PostedFile.SaveAs(str_ParentFolder + "\\" + str_NewFileName);
//Session["FilePath"] = str_ParentFolder + "\\" + filename;
//str_sql = "Insert Into CourseTeacher (CourseID ,TeacherID ,FileID,FilePath,FileName,FileType,Chapter,CreateDate) Values (" +
// str_CourseId + "," + str_TeacherId + "," + i_MaxID.ToString() + ",'" + dir + "','" + filename + "','" +
// str_FileType + "','" + tbx_Chapter.Text + "','" + System.DateTime.Today.ToLongDateString() + "')";
//DBFun.ExecuteUpdate(str_sql);
Fupload.Dispose();
return(str_OriginalFileName + "," + str_NewFileName);
//用文件名上传的方式
//if (tbx_Research.Text != "")
//{
// extname = System.IO.Path.GetExtension(tbx_Research.Text);
// filename = dir + "\\" + DateTime.Now.ToString("yyyyMM") + rd.Next(1000).ToString() + extname;
// System.IO.File.Copy(tbx_Research.Text, Server.MapPath(".\\kejian\\") + filename);
// return filename;
//}
//return "";
}
catch
{
File.Delete(Session["FilePath"].ToString());
Response.Write("<script>alert('文件上传失败！');</script>");
return("");
}
}
