ASP.NAT代码.docVIP

public class SqlHelper private SqlConnection conn = null; private SqlCommand cmd = null; private SqlDataReader sdr = null; public SqlHelper() string connStr = ConfigurationManager.ConnectionStringsxufang.ConnectionString.ToString(); conn = new SqlConnection(connStr); private SqlConnection GetConn() if (conn.State = ConnectionState.Closed) conn.Open(); return conn; / / 该方法执行传入的SQL语句，主要包括增删改SQL语句 / / / public int ExecuteNonQuery(string sql) int res; try cmd = new SqlCommand(sql, GetConn(); res = cmd.ExecuteNonQuery(); catch (Exception ex) throw ex; finally if (conn.State = ConnectionState.Open) conn.Close(); return res; / / 执行带参数的增删改SQL语句 / / 增删改SQL语句或存储过程 / 参数集合 / public int ExecuteNonQuery(string sql, SqlParameter paras) int res; using (cmd = new SqlCommand(sql, GetConn() cmd.Parameters.AddRange(paras); res = cmd.ExecuteNonQuery(); return res; / / 执行传入的SQL语句，主要包括查询 / / / public DataTable ExecuteQuery(string sql) DataTable dt = new DataTable(); cmd = new SqlCommand(sql, GetConn(); using (sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection) dt.Load(sdr); return dt; / / 执行带参数的查询SQL语句 / / 查询SQL语句 / 参数集合 / public DataTable ExecuteQuery(string cmdText, SqlParameter paras) DataTable dt = new DataTable(); cmd = new SqlCommand(cmdText, GetConn(); cmd.Parameters.AddRange(paras); using (sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection) dt.Load(sdr); return dt; / / 根据学生ID取出学生的基本信息 / / 学生ID / public Student SelectById(string id) Student n = new Student(); DataTable dt = new DataTable(); string cmdText = select * from TabStudent where s_id = id; SqlParameter paras = new SqlParameter new SqlParameter(id, id) ; dt = sqlhelper.ExecuteQuery(cmdText,paras); n.Id = id; n.Name = dt.Rows0s_name.ToString(); n.Sex = dt.Rows0s_sex.ToString(); n.Mobile = dt.Rows0s_mobile.ToString(); n.Telephone = dt.Rows0s_telephone.ToString(); n.Shortmobile = dt.Rows0s_shortmobile.ToString(); n.Qq = dt.Rows0s_qq.ToString(); n.Classno = dt.Rows0s_classno.ToString(); n.Password = dt.Rows0s_password.ToString(); return n; / / 利用bcp实现从excel表中导入数据到数据库中，对原始的数据表格式有要求，同时列要对起来 / / / protected void btnBcpImpout_Click(object sender, EventArgs e) SqlHelper myDemo = new SqlHelper(); string genExeclComm = EXEC master.xp_cmdshell bcp GraduationManage.dbo.TabStudent in d:demogdesignstu.xls -c -q -SXU -Usa -Psa; int result = myDemo.ExecuteNonQuery(genExeclComm); Response.Write(result.ToString(); / / 利用bcp实现把数据从数据库导出到execl表中 / / / protected void btnBcpExport_Click(object sender, EventArgs e) SqlHelper myDemo = new SqlHelper(); string genExeclComm = EXEC master.xp_cmdshell bcp select s_id,s_name,s_classno from GraduationManage.dbo.TabStudent queryout d:demogdesignstuout.xls -c -q -SXU -Usa -Psa; int result = myDemo.ExecuteNonQuery(genExeclComm); Response.Write(result.ToString(); 文件夹的创建：using System.IO;/ / 为班级创建目录 / / / protected void Button1_Click(object sender, EventArgs e) string strClassPath = Server.MapPath(/file/) + txtClass.Text;/获得班级目录 if (Directory.Exists(strClassPath) = false)/目录不存在 Directory.CreateDirectory(strClassPath);/创建目录 else ScriptManager.RegisterClientScriptBlock(UpdatePanel1, 文件夹的压缩并下载：首先添加引用：ICSharpCode.SharpZipLib.dll；（FTP:/50上课程文件夹中下载）using System.IO;using System.Text;using ICSharpCode.SharpZipLib.Checksums;using ICSharpCode.SharpZipLib.Zip;using ICSharpCode.SharpZipLib.GZip; / / 实现文件夹先压缩后下载 / / / protected void Button1_Click(object sender, EventArgs e) string filePath = System.Web.HttpContext.Current.Request.MapPath(/file/public/); string fileName = xufang; dlZipDir(filePath,fileName); #region 下列为压缩文件并下载代码 ZipOutputStream zos = null; String strBaseDir = ; / / / / 需要压缩的文件路径 / 压缩后产生的文件名 void dlZipDir(string strPath, string strFileName) MemoryStream ms = null; Response.ContentType = application/octet-stream; strFileName = HttpUtility.UrlEncode(strFileName).Replace(+, ); Response.AddHeader(Content-Disposition, attachment; filename= + strFileName + .zip); ms = new MemoryStream(); zos = new ZipOutputStream(ms); strBaseDir = strPath + ; addZipEntry(strBaseDir); zos.Finish(); zos.Close(); Response.Clear(); Response.BinaryWrite(ms.ToArray(); Response.End(); void addZipEntry(string PathStr) DirectoryInfo di = new DirectoryInfo(PathStr); foreach (DirectoryInfo item in di.GetDirectories() addZipEntry(item.FullName); /循环提取文件夹下每一个文件信息 foreach (FileInfo item in di.GetFiles() FileStream fs = File.OpenRead(item.FullName); byte buffer = new bytefs.Length; fs.Read(buffer, 0, buffer.Length); string strEntryName = item.FullName.Replace(strBaseDir, ); ZipEntry entry = new ZipEntry(strEntryName); zos.PutNextEntry(entry); zos.Write(buffer, 0, buffer.Length); fs.Close(); #endregion对文件的浏览和管理 无标题页 文件管理演示二：不用数据库 using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.IO;/需要添加该命名空间namespace gdesign public partial class FileManageBrowse : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) if (Sessionxufang != null) BindFile(Sessionxufang.ToString(); protected void Button1_Click(object sender, EventArgs e) string fileStr = file + TextBox1.Text.Trim(); Sessionxufang = fileStr; BindFile(fileStr); / / 读取指定文件夹下面的文件，并把结果填入表格单元 / / 文件夹的路径采用相对路径 public void BindFile(string strPath) /浏览strPath所指路径下的文件 tbFile.Rows.Clear();/清空tbFile.Rows中的所有行 NewTableTitle();/生成表格中的标题行 TableCell td; TableRow tr; string fName = ;/文件名 string fSize = ;/文件大小 string fType = ;/文件类型 string fTime = ;/文件发布时间 DirectoryInfo di = new DirectoryInfo(Server.MapPath(strPath);/用于创建、移动和枚举目录和子目录的实例方法 foreach (FileSystemInfo fsi in di.GetFileSystemInfos() / FileSystemInfo是文件类型和目录类型的基类;GetFileSystemInfos()用于检索表示当前目录的文件和子目录 tr = new TableRow();/新建一行 td = new TableCell();/新建第一个单元格 if (fsi is FileInfo) /如果检索到的是文件，则获取文件相关信息 FileInfo fi = (FileInfo)fsi;/强制转化成文件类型 /获取文件基本信息 fName = fi.Name; fSize = fi.Length.ToString(); fType = fi.Extension.Length 0 ? : fi.Extension.Remove(0, 1); fTime = fi.LastWriteTime.ToString(); td.Text = fName;/如果是普通文件，则直接将文件夹名写入单元格 /向表格中增加新行，添加文件信息 tr.Cells.Add(td); td = new TableCell(); td.Text = fSize; tr.Cells.Add(td); td = new TableCell(); td.Text = fType; tr.Cells.Add(td); td = new TableCell(); td.Text = fTime; tr.Cells.Add(td); if (fsi is FileInfo) td = new TableCell(); /文件下载 HyperLink lnkDownload = new HyperLink(); lnkDownload.Text = 点击下载; lnkDownload.NavigateUrl = strPath + + fName; td.Controls.Add(lnkDownload); Label lb = new Label(); lb.Text =      td.Controls.Add(lb);/两个LinkButton之间留一个空 /文件删除 LinkButton lnkDelete = new LinkButton(); lnkDelete.Text = 删除; /通过给按钮添加属性，设置删除前需要再次确认 lnkDelete.AttributesOnClick = return confirm(确认删除吗?); /把文件的完整路径定义为事件的参数 lnkDelete.CommandArgument = Server.MapPath(strPath) + + fName; /定义单击该按钮时的执行事件名称为lnkDelete_Command lnkDelete.Command += new CommandEventHandler(lnkDelete_Command); td.Controls.Add(lnkDelete); tr.Cells.Add(td); tbFile.Rows.Add(tr); / / 生成表格的标题行 / public void NewTableTitle() TableCell td;/表示表格中的单元格 TableRow tr;/表示表格中的行 tr = new TableRow();/动态生成一行 td = new TableCell();/动态生成一个单元格 /生成表格中的标题行 td.Text = 文件名; td.Width = 300; tr.Cells.Add(td); td = new TableCell(); td.Text = 大小; td.Width = 100; tr.Cells.Add(td); td = new TableCell(); td.Text = 类型; td.Width = 100; tr.Cells.Add(td); td = new TableCell(); td.Text = 发布时间; td.Width = 200; tr.Cells.Add(td); td = new TableCell(); td.Text = 操作; td.Width = 200; tr.Cells.Add(td); tbFile.Rows.Add(tr); protected void lnkDelete_Command(object sender, CommandEventArgs e) /文件删除 string strFilePath = e.CommandArgument.ToString(); /删除指定路径的文件 File.Delete(strFilePath); /页面刷新 Response.Redirect(Request.Url.ToString(); 利用插件进行统计图表制作 / / 利用图表插件显示统计图表 / / / protected void Button2_Click(object sender, EventArgs e) /从数据库学生表中获取班级不同答辩人数的统计数据 StudentManager stu = new StudentManager(); DataTable demoResult = stu.SelectByClassState(TextBox1.Text.Trim(); /把查询获得的DataTable作为图表的数据源 Chart1.DataSource = demoResult; /绑定X轴数据，该数据是DataTable的某一列列名 Chart1.Series0.XValueMember = s_state; /绑定Y轴，该数据是DataTable的某一列列名 Chart1.Series0.YValueMembers = Expr1; /标识X轴和Y轴上显示的文字 Chart1.ChartAreasChartArea1.AxisX.Title