1 using System;
2 using System.Collections;
3 using System.Configuration;
4 using System.Data;
5 using System.Linq;
6 using System.Web;
7 using System.Web.Security;
8 using System.Web.UI;
9 using System.Web.UI.HtmlControls;
10 using System.Web.UI.WebControls;
11 using System.Web.UI.WebControls.WebParts;
12 using System.Xml.Linq;
13 using System.Data.SqlClient;
14 using SchoolCrm.DBUtility;
15
16 namespace SchoolCrm.Web
17 {
18 public partial class WebForm1 : System.Web.UI.Page
19 {
20 protected void Page_Load(object sender, EventArgs e)
21 {
22
23
24 }
25
26 protected void Button1_Click(object sender, EventArgs e)
27 {
28 //string str =@"E:\文档\查询系统\源码\SchoolCrm\Admin\AnLi_Schoolhttp://www.cnblogs.com/../AnLiFile\20121224634919572560504783_安一娜华大I-20.pdf";
29
30 int count = 1;
31 DataSet ds = DbHelperSQL.Query(" SELECT f.* FROM AnLi_ApplySchoolFiles f ");
32 foreach (DataRow item in ds.Tables[0].Rows)
33 {
34 string str = item["FilesName"].ToString();
35 string str2 = str.Substring(str.LastIndexOf("\\") + 1);
36 SqlParameter[] parameters = {
37 new SqlParameter("@FilesName1", SqlDbType.NVarChar),
38 new SqlParameter("@FilesId", SqlDbType.NVarChar)};
39 parameters[0].Value = str2;
40 parameters[1].Value = item["FilesId"].ToString();
41 string sqlstr = " update AnLi_ApplySchoolFiles set FilesName=@FilesName1 where FilesId=@FilesId ";
42 int rows = DbHelperSQL.ExecuteSql(sqlstr, parameters);
43 if (rows > 0)
44 {
45 count++;
46 }
47 }
48 Response.Write(" 成功" + count);
49
50 }
51
52
53 }
54 }
