62,071
社区成员
发帖
与我相关
我的任务
分享
<asp:GridView ID="gv_LtxList_ZC" runat="server" Width="90%" AutoGenerateColumns="False">
<Columns>
<asp:BoundField DataField="Sm.Number" HeaderText="编码" >
<ItemStyle HorizontalAlign="Center" />
</asp:BoundField>
<asp:BoundField DataField="Sm.xm" HeaderText="姓名" >
<ItemStyle HorizontalAlign="Center" />
</asp:BoundField>
<asp:BoundField DataField="sm.xb" HeaderText="性别" >
<ItemStyle HorizontalAlign="Center" />
</asp:BoundField>
<asp:BoundField DataField="sm.deptName" HeaderText="部门名称" >
<ItemStyle HorizontalAlign="Center" />
</asp:BoundField>
<asp:BoundField DataField="dwName" HeaderText="单位名称" >
<ItemStyle HorizontalAlign="Center" />
</asp:BoundField>
<asp:TemplateField HeaderText="还原">
<ItemTemplate>
<a href='#' onclick='return huanyun(<%#Eval("sm.id") %>)'>
<img src="../../images/export.gif" border=0px /></a>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
<asp:TemplateField HeaderText="删除">
<ItemTemplate>
<a href='#' onclick=''>
<img src="../../images/delete.gif" border=0px /></a>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
</Columns>
</asp:GridView>
/// <summary>
/// 初始化
/// </summary>
private void InitLTX()
{
MemberDAL md = new MemberDAL();
//找到转出的
gv_LtxList_ZC.DataSource= md.findLtx("2");
gv_LtxList_ZC.DataBind();
}
/// <summary>
/// 查找指定状态的离退休人员,0-表示未审核 1- 表示已通过审核 2- 已转出 3- 已删除
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
public List<MemberInfo> findLtx(string state)
{
var member = from p in db.szb_member
join d in db.sys_dw on p.dwId equals d.id
where p.state.Equals(state)
select new MemberInfo
{
Sm = p,
DwName = d.dwName
};
return member.ToList();
}
/// <summary>
///MemberInfo 的摘要说明
/// </summary>
public class MemberInfo
{
public MemberInfo()
{
//
//TODO: 在此处添加构造函数逻辑
//
}
private szb_member _sm;
public szb_member Sm
{
get { return _sm; }
set { _sm = value; }
}
private string _dwName;
public string DwName
{
get { return _dwName; }
set { _dwName = value; }
}
}
<asp:BoundField DataField="Sm.Number" HeaderText="编码" >
<ItemStyle HorizontalAlign="Center" />
</asp:BoundField>
[Column(Storage="_Number", DbType="NVarChar(20) NOT NULL", CanBeNull=false, IsPrimaryKey=true)]
public string Number
{
get
{
return this._Number;
}
set
{
if ((this._Number != value))
{
this.OnNumberChanging(value);
this.SendPropertyChanging();
this._Number = value;
this.SendPropertyChanged("Number");
this.OnNumberChanged();
}
}
}
private szb_member _sm;
public szb_member Sm
{
get { return _sm; }
set { _sm = value; }
}
<asp:GridView ID="gv_LtxList_ZC" runat="server" Width="90%" AutoGenerateColumns="False">
<Columns>
<asp:BoundField DataField="Number" HeaderText="编码" >
<ItemStyle HorizontalAlign="Center" />
</asp:BoundField>
<asp:BoundField DataField="xm" HeaderText="姓名" >
<ItemStyle HorizontalAlign="Center" />
</asp:BoundField>
<asp:BoundField DataField="xb" HeaderText="性别" >
<ItemStyle HorizontalAlign="Center" />
</asp:BoundField>
<asp:BoundField DataField="deptName" HeaderText="部门名称" >
<ItemStyle HorizontalAlign="Center" />
</asp:BoundField>
<asp:BoundField DataField="dwName" HeaderText="单位名称" >
<ItemStyle HorizontalAlign="Center" />
</asp:BoundField>
<asp:TemplateField HeaderText="还原">
<ItemTemplate>
<a href='#' onclick='return huanyun(<%#Eval("id") %>)'>
<img src="../../images/export.gif" border=0px /></a>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
<asp:TemplateField HeaderText="删除">
<ItemTemplate>
<a href='#' onclick=''>
<img src="../../images/delete.gif" border=0px /></a>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
</Columns>
</asp:GridView>