acc_input.aspx.cs

毕业设计关系b/s系统 毕业设计管理工作 毕业设计管理数据

					Response.Write ("<script>");
					Response.Write ("alert('删除成功！');");
					Response.Write("</script>");

					td_trans2.Visible =true;
					td_trans1.Visible =false;
					
				}
				catch(SqlException ex)
				{
					Response.Write ("<script>");
					Response.Write ("alert('数据库连接出错！')");
					Response.Write ("</script>");
				}
				finally
				{
					conn.Close ();
				}

			}
			else
			{
				Response.Write ("<script>");
				Response.Write ("alert('文件不存在！!')");
				Response.Write ("</script>");
			}

		}

		private void bt_thesis_Click(object sender, System.EventArgs e)
		{
			if(fp_thesis.PostedFile.ContentLength!=0)
			{
				url0=fp_thesis.PostedFile.FileName.Trim ();
				if (gain_name()==true)                  //判断上传文本类型，记录文件名
				{
					//上传文件
					classname = Convert.ToString (ViewState["classname"]);
					url0="data/"+classname+"/"+studentid+"/"+studentid+"_thesis_"+url0;   //带存储文件夹名字,url是纯文件名字  
					
					//将文件上传至服务器
					if (!Directory.Exists(Server.MapPath("../")+"/data/"+classname+"/"+studentid+"/")) 
					{
						Directory.CreateDirectory(Server.MapPath("../")+"/data/"+classname+"/"+studentid+"/");
					}
					try
					{
						fp_thesis.PostedFile.SaveAs(Server.MapPath("../")+"/"+url0);
					}
					catch(Exception ex)
					{
						Response.Write(" <font color='Red' size='2'>'上传不成功 ' </font>;");
					}

					SqlConnection conn = new SqlConnection(myConnString);
					try
					{
						conn.Open();
						DateTime dt=new DateTime ();
						dt=DateTime.Now ;

						key=Convert.ToString (ViewState["key"]);
						thesis = studentid+"_thesis_"+url;
						ViewState["thesis"] = thesis;
						suresubjectid = Convert.ToString (ViewState["suresubjectid"]);

						if (key == "0")
							sql="insert into bysj.accessory (suresubjectid,papercommiturl) values('"+suresubjectid+"','"+thesis+"')";
						else
							sql="update bysj.accessory set papercommiturl='"+thesis+"' where suresubjectid='"+suresubjectid+"'";
						SqlCommand cmd = new  SqlCommand (sql,conn);
						cmd.CommandText =sql;
						cmd.ExecuteNonQuery ();

						sql="select  * from bysj.flowmonitor where suresubjectid='"+suresubjectid+"'";
						SqlDataAdapter adapter3 = new  SqlDataAdapter(sql, conn);
						DataSet cla2=new DataSet ();
						adapter3.Fill(cla2);
						if (cla2.Tables ["table"].Rows.Count ==0)
							sql="insert into bysj.flowmonitor (suresubjectid,papercommitflag,papercommittime)values('"+suresubjectid+"','"+1+"','"+dt+"')";
						else
							sql="update bysj.flowmonitor set papercommitflag='1' ,papercommittime='"+dt+"' where suresubjectid='"+suresubjectid+"'";
						cmd.CommandText =sql;
						cmd.ExecuteNonQuery ();
					
						Response.Write ("<script>");
						Response.Write ("alert('提交成功！');");
						Response.Write("</script>");

						td_thesis1.Visible =true;
						td_thesis2.Visible =false;
						hyp_thesis.Text = "毕业论文文件名为："+thesis;
						url0="data/"+classname+"/"+studentid+"/"+thesis;   //带存储文件夹名字,url是纯文件名字  
						hyp_thesis.NavigateUrl = "../"+url0;
						ViewState["key"]="2";
					
					}
					catch(SqlException ex)
					{
						Response.Write ("<script>");
						Response.Write ("alert('数据库连接出错！')");
						Response.Write ("</script>");
					}
					finally
					{
						conn.Close ();
					}



					
				}
				
			}
			
			else
			{
				Response.Write ("<script>");
				Response.Write ("alert('请选择word文本！!')");
				Response.Write ("</script>");
			
			}
		}

		private void btn_thesis_Click(object sender, System.EventArgs e)
		{
			td_thesis2.Visible =true;
		}

		private void btn_dthesis_Click(object sender, System.EventArgs e)
		{
			classname = Convert.ToString (ViewState["classname"]);
			thesis = Convert.ToString (ViewState["thesis"]);
			suresubjectid = Convert.ToString (ViewState["suresubjectid"]);
			url0="data/"+classname+"/"+studentid+"/"+thesis;   //带存储文件夹名字,url是纯文件名字  

			FileInfo file=new FileInfo(Server.MapPath("../")+url0);
			if(file.Exists )
			{
				file.Delete ( );

				SqlConnection conn = new SqlConnection(myConnString);
				try
				{
					conn.Open();
					DateTime dt=new DateTime ();
					dt=DateTime.Now ;

					sql="update bysj.accessory set papercommiturl='' where suresubjectid='"+suresubjectid+"'";
					SqlCommand cmd = new  SqlCommand (sql,conn);
					cmd.CommandText =sql;
					cmd.ExecuteNonQuery ();
					sql="update bysj.flowmonitor set papercommitflag='0' where suresubjectid='"+suresubjectid+"'";
					cmd.CommandText =sql;
					cmd.ExecuteNonQuery ();

					Response.Write ("<script>");
					Response.Write ("alert('删除成功！');");
					Response.Write("</script>");

					td_thesis2.Visible =true;
					td_thesis1.Visible =false;
					
				}
				catch(SqlException ex)
				{
					Response.Write ("<script>");
					Response.Write ("alert('数据库连接出错！')");
					Response.Write ("</script>");
				}
				finally
				{
					conn.Close ();
				}

			}
			else
			{
				Response.Write ("<script>");
				Response.Write ("alert('文件不存在！!')");
				Response.Write ("</script>");
			}
		}

		private void bt_code_Click(object sender, System.EventArgs e)
		{
			if(fp_code.PostedFile.ContentLength!=0)
			{
				url0=fp_code.PostedFile.FileName.Trim ();
				ftype=url0.Substring (url0.Length -3,3);    //type
				string[] tt=url0.Split('\\');
				url0=tt[tt.Length-1];
				url=url0;	                                //纯filename(带type)
				
					//上传文件
					classname = Convert.ToString (ViewState["classname"]);
					url0="data/"+classname+"/"+studentid+"/"+studentid+"_code_"+url0;   //带存储文件夹名字,url是纯文件名字  
					
					//将文件上传至服务器
					if (!Directory.Exists(Server.MapPath("../")+"/data/"+classname+"/"+studentid+"/")) 
					{
						Directory.CreateDirectory(Server.MapPath("../")+"/data/"+classname+"/"+studentid+"/");
					}
					try
					{
						fp_code.PostedFile.SaveAs(Server.MapPath("../")+"/"+url0);
					}
					catch(Exception ex)
					{
						Response.Write(" <font color='Red' size='2'>'上传不成功 ' </font>;");
					}

					SqlConnection conn = new SqlConnection(myConnString);
					try
					{
						conn.Open();
						DateTime dt=new DateTime ();
						dt=DateTime.Now ;

						key=Convert.ToString (ViewState["key"]);
						code = studentid+"_code_"+url;
						ViewState["code"] = code;
						suresubjectid = Convert.ToString (ViewState["suresubjectid"]);

						if (key == "0")
							sql="insert into bysj.accessory (suresubjectid,codecommiturl) values('"+suresubjectid+"','"+code+"')";
						else
							sql="update bysj.accessory set codecommiturl='"+code+"' where suresubjectid='"+suresubjectid+"'";
						SqlCommand cmd = new  SqlCommand (sql,conn);
						cmd.CommandText =sql;
						cmd.ExecuteNonQuery ();

						sql="select  * from bysj.flowmonitor where suresubjectid='"+suresubjectid+"'";
						SqlDataAdapter adapter3 = new  SqlDataAdapter(sql, conn);
						DataSet cla2=new DataSet ();
						adapter3.Fill(cla2);
						if (cla2.Tables ["table"].Rows.Count ==0)
							sql="insert into bysj.flowmonitor (suresubjectid,codecommitflag,codecommittime)values('"+suresubjectid+"','"+1+"','"+dt+"')";
						else
							sql="update bysj.flowmonitor set codecommitflag='1' ,codecommittime='"+dt+"' where suresubjectid='"+suresubjectid+"'";
						cmd.CommandText =sql;
						cmd.ExecuteNonQuery ();
					
						Response.Write ("<script>");
						Response.Write ("alert('提交成功！');");
						Response.Write("</script>");

						td_code1.Visible =true;
						td_code2.Visible =false;
						hyp_code.Text = "代码文件名为："+code;
						url0="data/"+classname+"/"+studentid+"/"+code;   //带存储文件夹名字,url是纯文件名字  
						hyp_code.NavigateUrl = "../"+url0;
						ViewState["key"]="2";
					
					}
					catch(SqlException ex)
					{
						Response.Write ("<script>");
						Response.Write ("alert('数据库连接出错！')");
						Response.Write ("</script>");
					}
					finally
					{
						conn.Close ();
					}



					
				}
				
			
		}

		private void btn_code_Click(object sender, System.EventArgs e)
		{
			td_code2.Visible =true;
		}

		private void btn_dcode_Click(object sender, System.EventArgs e)
		{
			classname = Convert.ToString (ViewState["classname"]);
			code = Convert.ToString (ViewState["code"]);
			suresubjectid = Convert.ToString (ViewState["suresubjectid"]);
			url0="data/"+classname+"/"+studentid+"/"+code;   //带存储文件夹名字,url是纯文件名字  

			FileInfo file=new FileInfo(Server.MapPath("../")+url0);
			if(file.Exists )
			{
				file.Delete ( );

				SqlConnection conn = new SqlConnection(myConnString);
				try
				{
					conn.Open();
					DateTime dt=new DateTime ();
					dt=DateTime.Now ;

					sql="update bysj.accessory set codecommiturl='' where suresubjectid='"+suresubjectid+"'";
					SqlCommand cmd = new  SqlCommand (sql,conn);
					cmd.CommandText =sql;
					cmd.ExecuteNonQuery ();
					sql="update bysj.flowmonitor set codecommitflag='0' where suresubjectid='"+suresubjectid+"'";
					cmd.CommandText =sql;
					cmd.ExecuteNonQuery ();

					Response.Write ("<script>");
					Response.Write ("alert('删除成功！');");
					Response.Write("</script>");

					td_code2.Visible =true;
					td_code1.Visible =false;
					
				}
				catch(SqlException ex)
				{
					Response.Write ("<script>");
					Response.Write ("alert('数据库连接出错！')");
					Response.Write ("</script>");
				}
				finally
				{
					conn.Close ();
				}

			}
			else
			{
				Response.Write ("<script>");
				Response.Write ("alert('文件不存在！!')");
				Response.Write ("</script>");
			}
		}

		
	}
}