总结起来东西集合.doc

1、DataTable添加行的方法方法一:DataTable tblDatas = new DataTable(Datas);DataColumn dc = null;dc = tblDatas.Columns.Add(ID, Type.GetType(System.Int32);dc.AutoIncrement = true;/自动增加dc.AutoIncrementSeed = 1;/起始为1dc.AutoIncrementStep = 1;/步长为1dc.AllowDBNull = false;/dc = tblDatas.Columns.Add(Product, Type.GetType(System.String);dc = tblDatas.Columns.Add(Version, Type.GetType(System.String);dc = tblDatas.Columns.Add(Description, Type.GetType(System.String);DataRow newRow;newRow = tblDatas.NewRow();newRowProduct = 水果刀;newRowVersion = 2.0;newRowDescription = 打架专用;tblDatas.Rows.Add(newRow);newRow = tblDatas.NewRow();newRowProduct = 折叠凳;newRowVersion = 3.0;newRowDescription = 行走江湖七武器之一;tblDatas.Rows.Add(newRow);方法二: DataTable tblDatas = new DataTable(Datas);tblDatas.Columns.Add(ID, Type.GetType(System.Int32);tblDatas.Columns0.AutoIncrement = true;tblDatas.Columns0.AutoIncrementSeed = 1;tblDatas.Columns0.AutoIncrementStep = 1;tblDatas.Columns.Add(Product, Type.GetType(System.String);tblDatas.Columns.Add(Version, Type.GetType(System.String);tblDatas.Columns.Add(Description, Type.GetType(System.String);tblDatas.Rows.Add(new objectnull,a,b,c);tblDatas.Rows.Add(new object null, a, b, c );tblDatas.Rows.Add(new object null, a, b, c );tblDatas.Rows.Add(new object null, a, b, c );tblDatas.Rows.Add(new object null, a, b, c );2、添加一个表的时候在数据库里面添加了一个新表那么需要在一下每个地方添加一些方法Facade.Public.PublicManage 操作账户信息 删除账户信息Business.Public.PublicManage 操作账户信息 删除账户信息Common.Const.SequenceNames 生成表名(表名生成器)Facade.Public.PublicQuery 获取账号扩展信息 Business.Public.PublicQuery 获取账号扩展信息3、 添加模块：/对模块进行添加 *【SYSTEM_MODULE_INFO 】* 在这儿添加的时候一般修改一下路径 一般改变：【812 讲师管理 D1121 ETDFSource/Teacher.aspx】这四个地方INSERT INTO SYSTEM_MODULE_INFO (MODULE_ID,ICON_ID,MODULE_NAME,MODULE_ICON,MODULE_SORT,MODULE_URL,MODULE_TARGET,MODULE_PID) VALUES (812,NULL,讲师管理, ui-icon person,D1121,ETDFSource/Teacher.aspx,main,150);/对添加后的系统模块进行更新 一般改变的地方:【812】UPDATE SYS_SEQUENCE SET SEQUENCE_VALUE=812 WHERE SEQUENCE_NAME=SEQ_SYSTEM_MODULE_INFO;/对权限操作的时候先打开权限 处理完了之后再删除权限SET IDENTITY_INSERT SYSTEM_LIMIT_INFO ON/插入系统权限 *【SYSTEM_LIMIT_INFO】* 一般情况下只用添加一个查看的权限就可以了，如果是修改页面就需要再加上修改权限 一般改变的地方：【812 ET_DFSource_Teacher_View这个是表名一定要改】INSERT INTO SYSTEM_LIMIT_INFO (LIMIT_ID,MODULE_ID,LIMIT_NAME,LIMIT_KEY,ISUN_VISIBLE) VALUES (81201,812,查看,ET_DFSource_Teacher_View,1);INSERT INTO SYSTEM_LIMIT_INFO (LIMIT_ID,MODULE_ID,LIMIT_NAME,LIMIT_KEY,ISUN_VISIBLE) VALUES (81201,812,修改,ET_DFSource_Teacher_View,1);INSERT INTO SYSTEM_LIMIT_INFO (LIMIT_ID,MODULE_ID,LIMIT_NAME,LIMIT_KEY,ISUN_VISIBLE) VALUES (81201,812,删除,ET_DFSource_Teacher_View,1);SET IDENTITY_INSERT SYSTEM_LIMIT_INFO OFFUPDATE SYS_SEQUENCE SET SEQUENCE_VALUE=81201 WHERE SEQUENCE_NAME=SEQ_SYSTEM_LIMIT_INFO;INSERT INTO SYSTEM_ROLE_LIMIT (LINK_ID,ROLE_ID,LIMIT_ID) VALUES (3181201,31,81201); - 查看4、用HTMLupload控件实现多文件上传.txtprivate bool SaveImages() HttpFileCollection files = HttpContext.Current.Request.Files; System.Text.StringBuilder strMsg = new System.Text.StringBuilder(); strMsg.Append(上传的文件分别是：); try for (int i = 0; i files.Count; i+) HttpPostedFile postedFile = filesi; string filename, fileExt, filesize; filename = System.IO.Path.GetFileName(postedFile.FileName); filesize = postedFile.ContentLength.ToString(); if (filename != ) fileExt = System.IO.Path.GetExtension(filename); strMsg.Append(上传的文件类型： + postedFile.ContentType.ToString() + ); strMsg.Append(客户端的文件地址： + postedFile.FileName + ); strMsg.Append(上传文件的文件名： + filename + ); strMsg.Append(上传文件的文件大小： + filesize + 字节); strMsg.Append(上传文件的扩展名： + fileExt + ); System.IO.DirectoryInfo dir = new System.IO.DirectoryInfo(C:testFile); if (!dir.Exists) dir.Create(); postedFile.SaveAs(dir + filename); strStatus.Text = strMsg.ToString(); return true; catch (Exception ex) strStatus.Text = ex.Message; return false; 5、 在服务器端实现文件上传（在文件夹里面有个详细的过程，多文件上传的详细过程）int FileNum = 0; string filepath = Server.MapPath(./) + upfile; string filename = DateTime.Now.ToString(yyyyMMddHHmmss); HttpFileCollection hfc = Request.Files; for (int i = 0; i 0) hpf.SaveAs(filepath + / + filename + System.IO.Path.GetFileName(hpf.FileName); FileNum+; else Response.Write(alert(请选择你要上传的文件); i = hfc.Count; break; Response.Write(alert(上传成功); Response.Write(共上传的文件个数为： + FileNum + 个); FileNum = 0;6、在服务器里面将文件压缩、public partial class _Default2 : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) protected void Button1_Click(object sender, EventArgs e) string Path = c:de; string resultPath = string.Empty; bool rel =false; TimeSpan nowTimeSpan=new TimeSpan(); resultPath=YaSuo(out rel, out nowTimeSpan); ResponseFile(resultPath); / / 压缩文件 / / 返回压缩后的路径 public string YaSuo(out bool bo, out TimeSpan times) string rarurlPath = string.Empty; bo = false; /压缩文件 string yasuoPathSave = c:deTZ.rar; string yasuoPath = c:detemp; System.Diagnostics.Process pro = new System.Diagnostics.Process(); pro.StartInfo.FileName = C:Program FilesWinRARWinRAR.exe;/WinRAR所在路径 /pro.StartInfo.Arguments = a + yasuoPathSave + + yasuoPath + -r ;/dir是你的目录名 pro.StartInfo.Arguments = string.Format(a 0 1 -r,yasuoPathSave,yasuoPath); pro.Start(); times = pro.TotalProcessorTime; bo = pro.WaitForExit(60000);/设定一分钟 if (!bo) pro.Kill(); pro.Close(); pro.Dispose(); rarurlPath = yasuoPathSave; return rarurlPath; protected void ResponseFile(string filename) FileInfo file = new FileInfo(filename);/创建一个文件对象 Response.Clear();/清除所有缓存区的内容 Response.Charset = GB2312;/定义输出字符集 Response.ContentEncoding = Encoding.Default;/输出内容的编码为默认编码 Response.AddHeader(Content-Disposition,attachment;filename=+file.Name); /添加头信息。为“文件下载/另存为”指定默认文件名称 Response.AddHeader(Content-Length,file.Length.ToString(); /添加头文件，指定文件的大小，让浏览器显示文件下载的速度 Response.WriteFile(file.FullName);/ 把文件流发送到客户端 Response.End(); 7、Web 传文件发送方： String uriString = http:/localhost:11078/WebSite/1.aspx; System.Net.WebClient myWebClient = new System.Net.WebClient(); string fileName = Server.MapPath(/Upload/Bak/sql.bak); byte responseArray = myWebClient.UploadFile(uriString, POST, fileName);接收发： if (!IsPostBack) foreach (string f in Request.Files.AllKeys) HttpPostedFile file = Request.Filesf; file.SaveAs(Server.MapPath(/Upload/getBak/ + file.FileName); 8、这个可以实现在winform里面将客户端的东西拖拽之后自动上传到服务器aspx:XML/HTML code?1234567891011121314151617181920212223242526 $(function () $(#dropbox).filedrop( paramname: myfile, maxfiles: 5, maxfilesize: 5, url: webform1.aspx, error: function (err, file) alert(err); ); ); 服务端：C# code?12345678910111213141516 pr