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