1
using System;
2
using System.Data;
3
using System.Configuration;
4
using System.Collections;
5
using System.Web;
6
using System.Web.Security;
7
using System.Web.UI;
8
using System.Web.UI.WebControls;
9
using System.Web.UI.WebControls.WebParts;
10
using System.Web.UI.HtmlControls;
11
12
using Expert.BLL;
13
using System.Collections.Generic;
14
using Expert.Model;
15
using System.Text;
16
using Expert.Common.MyFunction;
17
using Expert.Common;
18
using Expert.DAL;
19
using System.Text.RegularExpressions;
20
21
public partial class Excel_inout_ExportInfo : System.Web.UI.Page
22
{
23
private string string_sql = "select name as 名称,xb as 性别,dz as 地址 from USER";
24
25
List<ZDMC> ZDMCS = new List<ZDMC>();
26
27
protected void Page_Load(object sender, EventArgs e)
28
{
29
get_col(string_sql);
30
}
31
private void get_col(string sql)
32
{
33
string sqllabel="";
34
string[] resultString = Regex.Split(sql, "select", RegexOptions.IgnoreCase);
35
string[] resultString1 = Regex.Split(resultString[1], "from", RegexOptions.IgnoreCase);
36
37
string[] strname = resultString1[0].Split(',');
38
StringBuilder StringBuilder = new StringBuilder();
39
StringBuilder.Append("<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">");
40
int a=0;
41
42
foreach (string tr in strname)
43
{
44
string[] sArray = Regex.Split(tr, "as", RegexOptions.IgnoreCase);
45
StringBuilder.Append(" <tr>");
46
StringBuilder.Append(" <td><input type=\"checkbox\" id=\"chk\" runat=\"server\" name=\"chk\" value=\"" + sArray[0].ToString().Trim() + "\" checked=\"checked\" />");
47
StringBuilder.Append(" " + sArray[1].ToString().Trim() + "");
48
StringBuilder.Append(" </tr>");
49
ZDMC ZDMC = new ZDMC();
50
ZDMC.ZDYW = sArray[0].ToString().Trim();
51
ZDMC.ZDZW = sArray[1].ToString().Trim();
52
ZDMCS.Add(ZDMC);
53
54
}
55
StringBuilder.Append("</table>");
56
57
this.Label2.Text = StringBuilder.ToString();
58
59
}
60
61
protected void Button1_Click(object sender, EventArgs e)
62
{
63
64
string StringZDMC = "";
65
foreach (ZDMC ZDMC in ZDMCS)
66
{
67
if (Request.Form["chk"].ToString().IndexOf(ZDMC.ZDYW) >= 0)
68
{
69
StringZDMC += ZDMC.ZDYW + " as " + ZDMC.ZDZW + " , ";
70
}
71
}
72
this.Label1.Text = StringZDMC;
73
}
74
public struct ZDMC
75
{
76
public string ZDYW;
77
public string ZDZW;
78
public bool choose;
79
}
80
}
81
//方法一
82
//TextBox tb = (TextBox)Page.FindControl("TextBox" + i.ToString());
83
//if (tb != null)
84
//{
85
//string temp = tb.Text + i.ToString() ;
86
//}
87
88
//方法二
89
// string temp = Request.Form["TextBox"+i.ToString());
90
using System;2
using System.Data;3
using System.Configuration;4
using System.Collections;5
using System.Web;6
using System.Web.Security;7
using System.Web.UI;8
using System.Web.UI.WebControls;9
using System.Web.UI.WebControls.WebParts;10
using System.Web.UI.HtmlControls;11

12
using Expert.BLL;13
using System.Collections.Generic;14
using Expert.Model;15
using System.Text;16
using Expert.Common.MyFunction;17
using Expert.Common;18
using Expert.DAL;19
using System.Text.RegularExpressions;20

21
public partial class Excel_inout_ExportInfo : System.Web.UI.Page22
{23
private string string_sql = "select name as 名称,xb as 性别,dz as 地址 from USER";24

25
List<ZDMC> ZDMCS = new List<ZDMC>();26

27
protected void Page_Load(object sender, EventArgs e)28
{29
get_col(string_sql);30
}31
private void get_col(string sql)32
{33
string sqllabel="";34
string[] resultString = Regex.Split(sql, "select", RegexOptions.IgnoreCase);35
string[] resultString1 = Regex.Split(resultString[1], "from", RegexOptions.IgnoreCase);36

37
string[] strname = resultString1[0].Split(',');38
StringBuilder StringBuilder = new StringBuilder();39
StringBuilder.Append("<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">");40
int a=0;41

42
foreach (string tr in strname)43
{44
string[] sArray = Regex.Split(tr, "as", RegexOptions.IgnoreCase); 45
StringBuilder.Append(" <tr>");46
StringBuilder.Append(" <td><input type=\"checkbox\" id=\"chk\" runat=\"server\" name=\"chk\" value=\"" + sArray[0].ToString().Trim() + "\" checked=\"checked\" />");47
StringBuilder.Append(" " + sArray[1].ToString().Trim() + "");48
StringBuilder.Append(" </tr>");49
ZDMC ZDMC = new ZDMC();50
ZDMC.ZDYW = sArray[0].ToString().Trim();51
ZDMC.ZDZW = sArray[1].ToString().Trim();52
ZDMCS.Add(ZDMC);53
54
}55
StringBuilder.Append("</table>");56

57
this.Label2.Text = StringBuilder.ToString(); 58
59
}60

61
protected void Button1_Click(object sender, EventArgs e)62
{63
64
string StringZDMC = "";65
foreach (ZDMC ZDMC in ZDMCS)66
{67
if (Request.Form["chk"].ToString().IndexOf(ZDMC.ZDYW) >= 0)68
{69
StringZDMC += ZDMC.ZDYW + " as " + ZDMC.ZDZW + " , ";70
}71
}72
this.Label1.Text = StringZDMC;73
}74
public struct ZDMC75
{76
public string ZDYW;77
public string ZDZW;78
public bool choose;79
}80
}81
//方法一82
//TextBox tb = (TextBox)Page.FindControl("TextBox" + i.ToString());83
//if (tb != null)84
//{85
//string temp = tb.Text + i.ToString() ;86
//}87

88
//方法二89
// string temp = Request.Form["TextBox"+i.ToString());90

.Net 的學習中


浙公网安备 33010602011771号