62,025
社区成员
发帖
与我相关
我的任务
分享
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" Width="90%">
<RowStyle HorizontalAlign="Center" />
<Columns>
<asp:TemplateField HeaderText="序列">
<ItemTemplate>
<asp:Label ID="Label1" runat="server"
Text="<%# this.GridView1.PageIndex * this.GridView1.PageSize + this.GridView1.Rows.Count + 1 %>"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="positionname" HeaderText="职务" />
<asp:BoundField DataField="empname" HeaderText="姓名" />
<asp:TemplateField HeaderText="报名">
<ItemTemplate>
<asp:CheckBox ID="CheckBox15" runat="server" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
<HeaderStyle BackColor="#9ABF07" ForeColor="White" Height="30px" />
<AlternatingRowStyle BackColor="#E6EFC8" />
</asp:GridView>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" Width="90%">
<RowStyle HorizontalAlign="Center" />
<Columns>
<asp:TemplateField HeaderText="序列">
<ItemTemplate>
<asp:Label ID="Label1" runat="server"
Text="<%# this.GridView1.PageIndex * this.GridView1.PageSize + this.GridView1.Rows.Count + 1 %>"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="positionname" HeaderText="职务" />
<asp:BoundField DataField="empname" HeaderText="姓名" />
<asp:TemplateField HeaderText="报名">
<ItemTemplate>
<asp:CheckBox ID="CheckBox15" runat="server" />
</ItemTemplate>
<asp:HiddenField ID="HiddenField1" runat="server" Value='<%# Eval("员工id") %>' />
</asp:TemplateField>
</Columns>
<HeaderStyle BackColor="#9ABF07" ForeColor="White" Height="30px" />
<AlternatingRowStyle BackColor="#E6EFC8" />
</asp:GridView>
// 上面那个HiddenField里面绑定你的员工Id字段
protected void ButtonSubmit_Click(object sender, EventArgs e)
{
foreach (GridViewRow dr in GridView1.Rows)
{
if ((dr.Cells[3].FindControl("CheckBox15") as CheckBox).Checked)
{
int id= Convert.ToInt32((dr.FindControl("HiddenField1") as HiddenField).Value);
// 这个id就是你要在另一个表里添加的id,下面就是把这个id添加到另一个表里面,自己写吧
}
}
}
//删除选中的项
protected void DelAllLinkButton_Click(object sender, EventArgs e)
{
for (int i = 0; i < gvwHousehire.Rows.Count; i++)
{
CheckBox delRow = (CheckBox)gvwHousehire.Rows[i].Cells[0].FindControl("chkRow");
if (delRow != null && delRow.Checked)
{
househiresModel.ID = int.Parse(delRow.Text);
househiresBLL.Househire = househiresModel;
househiresBLL.DeleteRow();
}
}
gvwHousehire.DataBind();
}
//BLL逻辑层代码
public int DeleteRow()
{
return househireDAL.DeleteByID(_Househire.ID);
}
//DAL数据层代码
public int DeleteByID(int ID)
{
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@HouseID",ID)
};
int i=SqlHelper.Delete(parameter,"House_DeleteByID");
return i;
}