try
{
DataTable dt = new DataTable();
//获取Utility_Pre.aspx多个ID Session
string[] strArrUtilizeID = Session["utilizeID"].ToString().Split(';');
//ID循环
for (int i = 0; i < strArrUtilizeID.Length-1; i++)
{
//获取数据库
SqlParameter[] sqlParam = new SqlParameter[1];
sqlParam[0] = new SqlParameter("@utilizeID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "@utilizeID", DataRowVersion.Default,strArrUtilizeID
.ToString());
ds = db.GetDataSet("procUtility", sqlParam);
//DataTable初始化
# region dt Column
if (i == 0)
{
for (int intColumn = 0; intColumn < ds.Tables[0].Columns.Count; intColumn++)
{
dt.Columns.Add(ds.Tables[0].Columns[intColumn].ColumnName);
}
}
# endregion
//DataRow 初始化
DataRow dr = dt.NewRow();
for (int intCol = 0; intCol < ds.Tables[0].Columns.Count; intCol++)
{
#region dr
if (ds.Tables[0].Columns[intCol].ColumnName == "M_Piece" || ds.Tables[0].Columns[intCol].ColumnName == "M_Utilize")
{
try
{
dr[intCol] = decimal.Parse(ds.Tables[0].Rows[0][intCol].ToString());
}
catch
{
dr[intCol] = 0;
}
}
else if (ds.Tables[0].Columns[intCol].ColumnName == "UpdateDate")
{
try
{
dr[intCol] = DateTime.Parse(ds.Tables[0].Rows[0][intCol].ToString());
}
catch
{
dr[intCol] = DateTime.Now;
}
}
else
{
dr[intCol] = ds.Tables[0].Rows[0][intCol].ToString();
}
# endregion
}
dt.Rows.Add(dr);
}
grdUtility.DataSource = dt;
grdUtility.DataBind();
}
catch (Exception e)
{
string strEX = e.ToString();
}
Utility_Pre.aspx.cs
Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--> protected void btnOK_Click(object sender, EventArgs e)
{
string strUID = "";
for (int i = 0; i < grdPre.Rows.Count; i++)
{
if (((CheckBox)grdPre.Rows.Cells[0].FindControl("item")).Checked == true)
{
string strD = ((Label)grdPre.Rows[0].Cells[10].FindControl("Label1")).Text;
string strM = ((Label)grdPre.Rows[0].Cells[11].FindControl("Label2")).Text;
string strSql = "select max(utilizeID) from t_bputilize";
DataSet ds = db.GetDataSet(strSql);
int intU = int.Parse(ds.Tables[0].Rows[0][0].ToString())+1;
strSql = "insert into t_bputilize(utilizeID,MoelGroupID,DetailID) values('"+intU+"','" + strM + "','" + strD + "')";
db.ExecuteNonQuery(strSql);
strUID = strUID+intU.ToString()+";";
}
}
Session["utilizeID"] = strUID;
Response.Write("<script>window.opener.refresh();window.close()</script>");
}
Utility_Pre.aspx:
Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--> <yyc:SmartGridView ID="grdPre" runat='server' AutoGenerateColumns="False">
<HeaderStyle CssClass="grid_head" />
<Columns>
<asp:TemplateField>
<headertemplate>
<asp:CheckBox ID="all" runat="server" />
</headertemplate>
<itemtemplate>
<asp:CheckBox ID="item" runat="server" />
</itemtemplate>
<itemstyle width="50px" />
</asp:TemplateField>
<asp:BoundField DataField="CMALPH" HeaderText="Customer" />
<asp:BoundField DataField="Size" HeaderText="Size" />
<asp:BoundField DataField="TACFilm" HeaderText="TACFilm" />
<asp:BoundField DataField="Treatment" HeaderText="Treatment" />
<asp:BoundField DataField="thickness" HeaderText="Thickness" />
<asp:BoundField DataField="Tablets" HeaderText="T/B" />
<asp:BoundField DataField="AbsorAngle" HeaderText="Absorption Angle" />
<asp:BoundField DataField="DimensionX" HeaderText="Dimension_X" />
<asp:BoundField DataField="DimensionY" HeaderText="Dimension_Y" />
<asp:TemplateField HeaderText="DetailID" visible="false">
<edititemtemplate>
<asp:TextBox runat="server" Text='<%# Bind("DetailID") %>' id="TextBox1"></asp:TextBox>
</edititemtemplate>
<itemtemplate>
<asp:Label runat="server" Text='<%# Bind("DetailID") %>' id="Label1"></asp:Label>
</itemtemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="ModelGroupID" visible="false">
<edititemtemplate>
<asp:TextBox runat="server" Text='<%# Bind("ModelGroupID") %>' id="TextBox2"></asp:TextBox>
</edititemtemplate>
<itemtemplate>
<asp:Label runat="server" Text='<%# Bind("ModelGroupID") %>' id="Label2"></asp:Label>
</itemtemplate>
</asp:TemplateField>
</Columns>
<CascadeCheckboxes >
<yyc:CascadeCheckbox ChildCheckboxID="item" ParentCheckboxID="all" />
</CascadeCheckboxes>
</yyc:SmartGridView>
<asp:Button ID="btnOK" runat="server" OnClick="btnOK_Click" Text="确定" /></div>
转载于:https://www.cnblogs.com/freedom831215/archive/2009/10/03/1577635.html