62,046
社区成员
发帖
与我相关
我的任务
分享
<div class="div_PD_Data" runat="server" id="div_PD_Data"></div>
protected void DataBind() {
StringBuilder strSQL = new StringBuilder();
strSQL.Clear();
strSQL.Append("select name from syscolumns where id = object_id(N'data_table');");
string strsql = strSQL.ToString();
DataTable dt = DB.GetDataBySQL(strsql);
StringBuilder strSQL1 = new StringBuilder();
strSQL1.Clear();
strSQL1.Append("select * from data_table");
string strsql1 = strSQL1.ToString();
DataTable dt1 = DB.GetDataBySQL(strsql1);
#region 自动添加LS数据表
for (int i = 0; i < dt.Rows.Count; i++)
{
#region 自动添加div
HtmlContainerControl Div = new HtmlGenericControl("div");
Div.ID = "PD_table" + (i+1);
Div.Attributes.Add("class", "div_table");
Div.Style.Add("position", "absolute");
Div.Style.Add("left", (i*100)+"px");
div_PD_Data.Controls.Add(Div);
#endregion
#region 添加table
HtmlContainerControl tb = new HtmlGenericControl("table");
tb.ID = "table" + (i + 1);
tb.Attributes.Add("cellspacing", "0");
tb.Attributes.Add("cellpadding", "0");
tb.Style.Add("height", "88px");
tb.Style.Add("width", "92px");
tb.Style.Add("border-collapse", "collapse");
Div.Controls.Add(tb);
#endregion
#region 添加行
HtmlContainerControl tr1 = new HtmlGenericControl("tr");
tb.Controls.Add(tr1);
HtmlContainerControl tr2 = new HtmlGenericControl("tr");
tb.Controls.Add(tr2);
HtmlContainerControl tr3 = new HtmlGenericControl("tr");
tb.Controls.Add(tr3);
HtmlContainerControl tr4 = new HtmlGenericControl("tr");
tb.Controls.Add(tr4);
#endregion
#region 添加th,td
//表头
HtmlContainerControl th = new HtmlGenericControl("th");
th.Attributes.Add("align", "center");
th.Attributes.Add("valign", "middle");
th.Attributes.Add("colspan", "2");
tr1.Controls.Add(th);
//第一行,A相
HtmlContainerControl td1 = new HtmlGenericControl("td");
td1.Attributes.Add("align", "center");
td1.Attributes.Add("valign", "middle");
td1.Style.Add("width", "40px");
tr2.Controls.Add(td1);
HtmlContainerControl td2 = new HtmlGenericControl("td");
td2.Attributes.Add("align", "center");
td2.Attributes.Add("valign", "middle");
td2.Style.Add("width", "52px");
tr2.Controls.Add(td2);
//第二行,B相
HtmlContainerControl td3 = new HtmlGenericControl("td");
td3.Attributes.Add("align", "center");
td3.Attributes.Add("valign", "middle");
td3.Style.Add("width", "40px");
tr3.Controls.Add(td3);
HtmlContainerControl td4 = new HtmlGenericControl("td");
td4.Attributes.Add("align", "center");
td4.Attributes.Add("valign", "middle");
td4.Style.Add("width", "52px");
tr3.Controls.Add(td4);
//第三行,C相
HtmlContainerControl td5 = new HtmlGenericControl("td");
td5.Attributes.Add("align", "center");
td5.Attributes.Add("valign", "middle");
td5.Style.Add("width", "40px");
tr4.Controls.Add(td5);
HtmlContainerControl td6 = new HtmlGenericControl("td");
td6.Attributes.Add("align", "center");
td6.Attributes.Add("valign", "middle");
td6.Style.Add("width", "52px");
tr4.Controls.Add(td6);
#endregion
#region 数据
//表头
LinkButton ltn1 = new LinkButton();
ltn1.ID = "table_top" + (i + 1);
ltn1.CssClass = "lkbtn";
ltn1.Style.Add("width", "100%");
ltn1.Style.Add("display", "inline-block");
ltn1.Text = dt.Rows[i][0].ToString();
ltn1.ToolTip = "查看详情";
ltn1.Command += new CommandEventHandler(table_top1_Click);
th.Controls.Add(ltn1);
// A相
Label lb1 = new Label();
lb1.ID = "table" + i + "_left_1";
lb1.ForeColor = System.Drawing.Color.Yellow;
lb1.Font.Bold = true;
lb1.Text = "A相";
td1.Controls.Add(lb1);
Label lb2 = new Label();
lb2.ID = "table" + i + "_right_1";
lb2.ForeColor = System.Drawing.Color.Yellow;
lb2.Font.Bold = true;
lb2.Text = dt1.Rows[0][i + 1].ToString();
td2.Controls.Add(lb2);
// B相
Label lb3 = new Label();
lb3.ID = "table" + i + "_left_2";
lb3.ForeColor = System.Drawing.Color.Yellow;
lb3.Font.Bold = true;
lb3.Text = "B相";
td3.Controls.Add(lb3);
Label lb4 = new Label();
lb4.ID = "table" + i + "_right_2";
lb4.ForeColor = System.Drawing.Color.Yellow;
lb4.Font.Bold = true;
lb4.Text = dt1.Rows[1][i + 1].ToString();
td4.Controls.Add(lb4);
// C相
Label lb5 = new Label();
lb5.ID = "table" + i + "_left_3";
lb5.ForeColor = System.Drawing.Color.Yellow;
lb5.Font.Bold = true;
lb5.Text = "C相";
td5.Controls.Add(lb5);
Label lb6 = new Label();
lb6.ID = "table" + i + "_right_3";
lb6.ForeColor = System.Drawing.Color.Yellow;
lb6.Font.Bold = true;
lb6.Text = dt1.Rows[2][i + 1].ToString();
td6.Controls.Add(lb6);
#endregion
}
#endregion
dt.Dispose();
dt1.Dispose();
}