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(""); } }