//int fileaddress = 0; protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { LabMessage1.Text = ""; LabMessage2.Text = ""; strFId = ""; strRId = ""; if (Request.QueryString["fid"] != null) { strFId = Request.QueryString["fid"].ToString(); } if (Request.QueryString["rid"] != null) { strRId = Request.QueryString["rid"].ToString(); } if (Request.QueryString["sfile"] != null) { strSFile = HttpUtility.UrlDecode(Request.QueryString["sfile"].ToString()); } string str = "select t_Y_fileinfo.id,rid 项目编号,userid 上传者,fileName 文件名,address 文件地址,fid,name 工作环节,createdate 上传时间 from t_Y_fileinfo inner join t_Y_FlowDetail on t_Y_FlowDetail.id=t_Y_fileinfo.fid where rid='" + strRId + "' and fid<=" + strFId + ""; // string str = "select id,rid 项目编号,userid 上传者,fileName 文件名,address 文件地址,fid from t_Y_fileinfo where rid='" + strRId + "' and fid<=" + strFId + ""; DataSet ds = new MyDataOp(str).CreateDataSet(); string strtemp = "select Name,UserID from t_R_UserInfo"; DataSet ds_User = new MyDataOp(strtemp).CreateDataSet(); foreach (DataRow dr in ds.Tables[0].Rows) { foreach (DataRow drr in ds_User.Tables[0].Rows) { if (dr["上传者"].ToString() == drr["UserID"].ToString()) { dr["上传者"] = drr["Name"].ToString(); } //if (dr["ReportProofUserID"].ToString() == drr["UserID"].ToString()) // dr["ReportProofUserID"] = drr["Name"].ToString(); //if (dr["ReportSignUserID"].ToString() == drr["UserID"].ToString()) // dr["ReportSignUserID"] = drr["Name"].ToString(); } } if (ds.Tables[0].Rows.Count == 0) { //没有记录仍保留表头 ds.Tables[0].Rows.Add(ds.Tables[0].NewRow()); GridView_Report.DataSource = ds; GridView_Report.DataBind(); int intColumnCount = GridView_Report.Rows[0].Cells.Count; GridView_Report.Rows[0].Cells.Clear(); GridView_Report.Rows[0].Cells.Add(new TableCell()); GridView_Report.Rows[0].Cells[0].ColumnSpan = intColumnCount; } else { GridView_Report.DataSource = ds; GridView_Report.DataBind(); } } }
protected void GridView_Report_RowDeleting(object sender, GridViewDeleteEventArgs e) { strSelectedId = GridView_Report.Rows[e.RowIndex].Cells[1].Text; string strSql; string fileUrl = GridView_Report.Rows[e.RowIndex].Cells[4].Text; if (fileUrl != " ") { string[] deletelist = new string[2]; strSql = "update t_M_ReporInfo set ReportAddress=null,fileflag=0,ReportUploadDate=null WHERE id= '" + strSelectedId + "'"; //待修改,改项目删除后,相应要修改的信息 //deletelist.SetValue("delete from t_操作员信息 where 所属角色id=(select id from t_角色信息 where 级别id='" + strSelectedId + "')", 0); //deletelist.SetValue("delete from t_角色菜单关系表 where 角色id=(select id from t_角色信息 where 级别id='" + strSelectedId + "')", 1); // deletelist.SetValue("DELETE FROM t_角色信息 WHERE 级别id = '" + strSelectedId + "'",2); deletelist.SetValue(strSql, 0); MyDataOp mdo = new MyDataOp(strSql); if (mdo.DoTran(1, deletelist)) { try { fileUrl = fileUrl.Replace("\\", "/"); int kkp = fileUrl.LastIndexOf('/'); //string link1 = fileUrl.Substring(kkp-1, fileUrl.Length - kkp); FileInfo file = new FileInfo(fileUrl); file.Delete(); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('报告删除成功!')", true); } catch (Exception deletemsg) { WebApp.Components.Log.SaveLog("报告编制中删除报告异常:(" + strSelectedId + ")" + deletemsg, Request.Cookies["Cookies"].Values["u_id"].ToString(), 6); } } else { WebApp.Components.Log.SaveLog("报告编制中删除报告:(" + strSelectedId + ")失败!", Request.Cookies["Cookies"].Values["u_id"].ToString(), 6); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('报告删除失败!')", true); } string str = "select id,ReportNumber 报告编号,ReportUploadDate 报告上传日期,ReportAddress 报告地址 from t_M_ReporInfo where id='" + strSelectedId + "' and fileflag=1"; DataSet ds = new MyDataOp(str).CreateDataSet(); GridView_Report.DataSource = ds; GridView_Report.DataBind(); } }
//int fileaddress = 0; protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { LabMessage1.Text = ""; LabMessage2.Text = ""; if (Request.QueryString["kw"] != null && Request.QueryString["file"] != null) { strSelectedId = Request.QueryString["kw"].ToString(); filestr = Request.QueryString["file"].ToString(); } string str = "select id,ReportNumber 报告编号,ReportUploadDate 上传日期,ReportAddress 报告地址 from t_M_ReporInfo where id='" + strSelectedId + "' and fileflag=1"; DataSet ds = new MyDataOp(str).CreateDataSet(); GridView_Report.DataSource = ds; GridView_Report.DataBind(); ds.Dispose(); } }
protected void btn_upload_Click(object sender, EventArgs e) { string str1 = "select * from t_M_ReporInfo where id='" + strSelectedId + "' and ReportAddress is Null"; DataSet dss = new MyDataOp(str1).CreateDataSet(); if (dss.Tables[0].Rows.Count > 0) { bool fileOK = false; string path = filedirectory; if (FileUpload1.FileName != "") { String fileExtension = System.IO.Path.GetExtension(FileUpload1.PostedFile.FileName).ToLower(); String[] allowedExtensions = { ".doc", ".xls" }; for (int i = 0; i < allowedExtensions.Length; i++) { if (fileExtension == allowedExtensions[i]) { fileOK = true; } } if (fileOK) { string pathstr = path + "\\Report\\" + FileUpload1.FileName; try { FileUpload1.SaveAs(pathstr); LabMessage1.Text = "文件上传成功."; LabMessage2.Text = "<b>原文件路径:</b>" + FileUpload1.PostedFile.FileName + "<br />" + "<b>文件大小:</b>" + FileUpload1.PostedFile.ContentLength + "字节<br />" + "<b>文件类型:</b>" + FileUpload1.PostedFile.ContentType + "<br />"; string savestr = "update t_M_ReporInfo set ReportAddress='" + pathstr + "', ReportUploadDate=getdate(),fileflag=1 where id='" + strSelectedId + "'"; MyDataOp doobj = new MyDataOp(savestr); if (doobj.ExecuteCommand()) { WebApp.Components.Log.SaveLog("报告编制中上传报告:(" + FileUpload1.PostedFile.FileName + ")成功! " + LabMessage2.Text, Request.Cookies["Cookies"].Values["u_id"].ToString(), 6); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "window.alert('文件上传成功!');window.opener.location.href = '" + filestr + "';if(window.opener.progressWindow)window.opener.progressWindow.close();window.close();", true); } else { WebApp.Components.Log.SaveLog("报告编制中上传报告:(" + FileUpload1.PostedFile.FileName + ")文件上传成功!路径保存失败! " + LabMessage2.Text, Request.Cookies["Cookies"].Values["u_id"].ToString(), 6); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('文件上传成功!路径保存失败!')", true); } } catch (Exception ex) { WebApp.Components.Log.SaveLog("报告编制中上传报告:(" + FileUpload1.PostedFile.FileName + ")!存在异常: " + ex.Message.ToString(), Request.Cookies["Cookies"].Values["u_id"].ToString(), 6); LabMessage1.Text = "文件上传不成功."; } } else { WebApp.Components.Log.SaveLog("报告编制中上传报告:(" + FileUpload1.PostedFile.FileName + ")!存在异常: 只能够Word和Excel文件.", Request.Cookies["Cookies"].Values["u_id"].ToString(), 6); LabMessage1.Text = "只能够Word和Excel文件."; } } else { WebApp.Components.Log.SaveLog("报告编制中上传报告:(" + FileUpload1.PostedFile.FileName + ")!存在异常: 没有要上传的文件.", Request.Cookies["Cookies"].Values["u_id"].ToString(), 6); LabMessage1.Text = " 没有要上传的文件."; } string str = "select id,ReportNumber 报告编号,ReportUploadDate 报告上传日期,ReportAddress 报告地址 from t_M_ReporInfo where id='" + strSelectedId + "' and fileflag=1"; DataSet ds = new MyDataOp(str).CreateDataSet(); GridView_Report.DataSource = ds; GridView_Report.DataBind(); } else { WebApp.Components.Log.SaveLog("报告编制中上传报告:(" + FileUpload1.PostedFile.FileName + ")已存在同名样品的报告文档! " + LabMessage2.Text, Request.Cookies["Cookies"].Values["u_id"].ToString(), 6); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('已存在改报告的监测报告文档!')", true); } dss.Dispose(); }
protected void btn_upload_Click(object sender, EventArgs e) { //string str1 = "select * from t_M_SampleInfor where id='" + strSelectedId + "' and ReportAddress is Null"; //DataSet dss = new MyDataOp(str1).CreateDataSet(); //if (dss.Tables[0].Rows.Count > 0) //{ string ServerPath = Server.MapPath("~/UpLoad/"); DirectoryInfo TheFolderServer = new DirectoryInfo(ServerPath); if (!TheFolderServer.Exists) { Directory.CreateDirectory(ServerPath); } bool fileOK = false; string folder = strRId; // DateTime.Now.Date.ToString("yyyy-MM-dd"); string path = ServerPath + folder + "\\"; DirectoryInfo TheFolder = new DirectoryInfo(path); if (!TheFolder.Exists) { Directory.CreateDirectory(path); } if (FileUpload1.FileName != "") { String fileExtension = System.IO.Path.GetExtension(FileUpload1.PostedFile.FileName).ToLower(); String[] allowedExtensions = { ".doc", ".xls" }; for (int i = 0; i < allowedExtensions.Length; i++) { if (fileExtension == allowedExtensions[i]) { fileOK = true; } } if (fileOK) { string pathstr = path + FileUpload1.FileName; try { if (!File.Exists(pathstr)) { //string DBstr = "/UpLoad/" + folder + "/" + FileUpload1.FileName; FileUpload1.SaveAs(path + FileUpload1.FileName); //LabMessage1.Text = "文件上传成功."; //LabMessage2.Text = "<b>原文件路径:</b>" + FileUpload1.PostedFile.FileName + "<br />" + // "<b>文件大小:</b>" + FileUpload1.PostedFile.ContentLength + "字节<br />" + // "<b>文件类型:</b>" + FileUpload1.PostedFile.ContentType + "<br />"; string savestr = "Insert into t_Y_fileinfo(fid,rid,address,userid,createdate,filename)values(" + strFId + "," + strRId + ",'" + pathstr + "','" + Request.Cookies["Cookies"].Values["u_id"].ToString() + "',getdate(),'" + FileUpload1.FileName + "')"; MyDataOp doobj = new MyDataOp(savestr); if (doobj.ExecuteCommand()) { WebApp.Components.Log.SaveLogY("上传文件:项目编号:" + strRId + "(" + FileUpload1.PostedFile.FileName + ")成功! " + LabMessage2.Text, Request.Cookies["Cookies"].Values["u_id"].ToString(), int.Parse(strFId)); //window.opener.location.href = '" + strSFile + "';if(window.opener.progressWindow)window.opener.progressWindow.close();window.close(); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "window.alert('文件上传成功!');", true); } else { WebApp.Components.Log.SaveLogY("上传文件:项目编号:" + strRId + "(" + FileUpload1.PostedFile.FileName + ")文件上传成功!路径保存失败! " + LabMessage2.Text, Request.Cookies["Cookies"].Values["u_id"].ToString(), int.Parse(strFId)); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('文件上传成功!路径保存失败!')", true); } } else { WebApp.Components.Log.SaveLogY("上传文件:项目编号:" + strRId + "(" + FileUpload1.PostedFile.FileName + ")已存在同名文件! " + LabMessage2.Text, Request.Cookies["Cookies"].Values["u_id"].ToString(), int.Parse(strFId)); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('同名文件已存在,请重命名后上传!')", true); } } catch (Exception ex) { WebApp.Components.Log.SaveLogY("上传文件:项目编号:" + strRId + "(" + FileUpload1.PostedFile.FileName + ")!存在异常: " + ex.Message.ToString(), Request.Cookies["Cookies"].Values["u_id"].ToString(), int.Parse(strFId)); // Log.SaveLog("报告编制中上传报告:(" + FileUpload1.PostedFile.FileName + ")!存在异常: " + ex.Message.ToString(), Request.Cookies["Cookies"].Values["u_id"].ToString(), 6); LabMessage1.Text = "文件上传失败!"; } } else { WebApp.Components.Log.SaveLogY("上传文件:项目编号:" + strRId + "(" + FileUpload1.PostedFile.FileName + ")!存在异常:文件类型不匹配。 只能够Word和Excel文件.", Request.Cookies["Cookies"].Values["u_id"].ToString(), int.Parse(strFId)); LabMessage1.Text = "只能够Word和Excel文件."; } } else { WebApp.Components.Log.SaveLogY("上传文件:项目编号:" + strRId + "(" + FileUpload1.PostedFile.FileName + ")!存在异常:没有要上传的文件.", Request.Cookies["Cookies"].Values["u_id"].ToString(), int.Parse(strFId)); // Log.SaveLogY("报告编制中上传报告:(" + FileUpload1.PostedFile.FileName + ")!存在异常: 没有要上传的文件.", Request.Cookies["Cookies"].Values["u_id"].ToString(), 6); LabMessage1.Text = " 没有要上传的文件."; } string str = "select id,rid 项目编号,userid 上传者,fileName 文件名,address 文件地址,fid from t_Y_fileinfo where rid='" + strRId + "' and fid<=" + strFId + ""; DataSet ds = new MyDataOp(str).CreateDataSet(); string strtemp = "select Name,UserID from t_R_UserInfo"; DataSet ds_User = new MyDataOp(strtemp).CreateDataSet(); foreach (DataRow dr in ds.Tables[0].Rows) { foreach (DataRow drr in ds_User.Tables[0].Rows) { if (dr["上传者"].ToString() == drr["UserID"].ToString()) { dr["上传者"] = drr["Name"].ToString(); } //if (dr["ReportProofUserID"].ToString() == drr["UserID"].ToString()) // dr["ReportProofUserID"] = drr["Name"].ToString(); //if (dr["ReportSignUserID"].ToString() == drr["UserID"].ToString()) // dr["ReportSignUserID"] = drr["Name"].ToString(); } } if (ds.Tables[0].Rows.Count == 0) { //没有记录仍保留表头 ds.Tables[0].Rows.Add(ds.Tables[0].NewRow()); GridView_Report.DataSource = ds; GridView_Report.DataBind(); int intColumnCount = GridView_Report.Rows[0].Cells.Count; GridView_Report.Rows[0].Cells.Clear(); GridView_Report.Rows[0].Cells.Add(new TableCell()); GridView_Report.Rows[0].Cells[0].ColumnSpan = intColumnCount; } else { GridView_Report.DataSource = ds; GridView_Report.DataBind(); } //} //else //{ // Log.SaveLogY("报告编制中上传报告:(" + FileUpload1.PostedFile.FileName + ")已存在同名样品的报告文档! " + LabMessage2.Text, Request.Cookies["Cookies"].Values["u_id"].ToString(), 6); // ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('已存在同名样品的报告文档!')", true); //} }
protected void GridView_Report_RowDeleting(object sender, GridViewDeleteEventArgs e) { strSelectedId = GridView_Report.Rows[e.RowIndex].Cells[1].Text; string strSql; int ddfid = int.Parse(GridView_Report.Rows[e.RowIndex].Cells[6].Text); if (strSelectedId != "" && (ddfid >= int.Parse(strFId) || (int.Parse(Request.Cookies["Cookies"].Values["u_level"].ToString()) <= 6))) { string fileUrl = GridView_Report.Rows[e.RowIndex].Cells[5].Text; if (fileUrl != " ") { string[] deletelist = new string[2]; strSql = "Delete from t_Y_fileinfo WHERE id= '" + strSelectedId + "'"; //待修改,改项目删除后,相应要修改的信息 //deletelist.SetValue("delete from t_操作员信息 where 所属角色id=(select id from t_角色信息 where 级别id='" + strSelectedId + "')", 0); //deletelist.SetValue("delete from t_角色菜单关系表 where 角色id=(select id from t_角色信息 where 级别id='" + strSelectedId + "')", 1); // deletelist.SetValue("DELETE FROM t_角色信息 WHERE 级别id = '" + strSelectedId + "'",2); deletelist.SetValue(strSql, 0); MyDataOp mdo = new MyDataOp(strSql); if (mdo.DoTran(1, deletelist)) { try { fileUrl = fileUrl.Replace("\\", "/"); int kkp = fileUrl.LastIndexOf('/'); //string link1 = fileUrl.Substring(kkp-1, fileUrl.Length - kkp); FileInfo file = new FileInfo(fileUrl); file.Delete(); WebApp.Components.Log.SaveLogY("删除文件:项目编号:" + strRId + "(" + strSelectedId + ")成功!", Request.Cookies["Cookies"].Values["u_id"].ToString(), int.Parse(strFId)); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('文件删除成功!')", true); } catch (Exception deletemsg) { WebApp.Components.Log.SaveLogY("删除文件异常:项目编号:" + strRId + "(" + strSelectedId + ")" + deletemsg, Request.Cookies["Cookies"].Values["u_id"].ToString(), int.Parse(strFId)); } } else { WebApp.Components.Log.SaveLogY("删除文件异常:项目编号:" + strRId + "(" + strSelectedId + ")失败!", Request.Cookies["Cookies"].Values["u_id"].ToString(), int.Parse(strFId)); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('文件删除失败!')", true); } string str = "select id,rid 项目编号,userid 上传者,fileName 文件名,address 文件地址,fid from t_Y_fileinfo where rid='" + strRId + "' and fid<=" + strFId + ""; DataSet ds = new MyDataOp(str).CreateDataSet(); string strtemp = "select Name,UserID from t_R_UserInfo"; DataSet ds_User = new MyDataOp(strtemp).CreateDataSet(); foreach (DataRow dr in ds.Tables[0].Rows) { foreach (DataRow drr in ds_User.Tables[0].Rows) { if (dr["上传者"].ToString() == drr["UserID"].ToString()) { dr["上传者"] = drr["Name"].ToString(); } //if (dr["ReportProofUserID"].ToString() == drr["UserID"].ToString()) // dr["ReportProofUserID"] = drr["Name"].ToString(); //if (dr["ReportSignUserID"].ToString() == drr["UserID"].ToString()) // dr["ReportSignUserID"] = drr["Name"].ToString(); } } if (ds.Tables[0].Rows.Count == 0) { //没有记录仍保留表头 ds.Tables[0].Rows.Add(ds.Tables[0].NewRow()); GridView_Report.DataSource = ds; GridView_Report.DataBind(); int intColumnCount = GridView_Report.Rows[0].Cells.Count; GridView_Report.Rows[0].Cells.Clear(); GridView_Report.Rows[0].Cells.Add(new TableCell()); GridView_Report.Rows[0].Cells[0].ColumnSpan = intColumnCount; } else { GridView_Report.DataSource = ds; GridView_Report.DataBind(); } } } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('你没有权限删除该文件!')", true); } }