html:
<div class="lists-table">
<table cellpadding="0" cellspacing="0" border="0">
<thead>
<tr>
<th class="tabSort-header">
<a class="tabSort-header-inner" list="name">
<p>
下架单号 <span class="sort"></span>
</p>
</a>
</th>
<th class="tabSort-header">
<a class="tabSort-header-inner" list="ip">
<p>
药柜名称<span class="sort"></span></p>
</a>
</th>
<th class="tabSort-header">
<a class="tabSort-header-inner" list="examtimediget">
<p>
操作人<span class="sort"></span></p>
</a>
</th>
<th class="tabSort-header">
<a class="tabSort-header-inner" list="examtimediget">
<p>
创建时间<span class="sort"></span></p>
</a>
</th>
<th class="tabSort-header">
<a class="tabSort-header-inner" list="leak">
<p>
状态<span class="sort"></span></p>
</a>
</th>
</tr>
</thead>
<tbody id="safeOpr">
<asp:Repeater ID="RepeaterUnshelveRe" runat="server" OnItemDataBound="RepeaterUnshelveRe_ItemDataBound">
<ItemTemplate>
<tr>
<td>
<a href="UnShelveRecordDetailMgr.aspx?UnShelveRecordKey=<%#Eval("UnShelveRecordKey") %>"><%#Eval("UnShelveRecordNo")%></a>
</td>
<td>
<div class="tdof" title="<%#Eval("NameText")%>" style="width: 250px;">
<%#Eval("NameText")%></div>
</td>
<td>
<%#Eval("OperatorName")%>
</td>
<td><%#Eval("UnShelveTime","{0:yyyy-MM-dd HH:mm}")%></td>
<td><asp:Label Text='<%#Eval("State") %>' ID="lblState" runat="server"></asp:Label></td>
</tr>
</ItemTemplate>
</asp:Repeater>
</tbody>
<%if (RepeaterUnshelveRe.Items.Count == 0)
{%>
<tr>
<td colspan="6" class="nodata">
没有数据可供显示
</td>
</tr>
<%} %>
</table>
</div>
<webdiyer:AspNetPager ID="AspNetPager1" runat="server" CssClass="paginator" CurrentPageButtonClass="cpb"
EnableTheming="true" FirstPageText="首页" HorizontalAlign="right" LastPageText="尾页"
NextPageText="下一页" PageIndexBoxType="DropDownList" PageSize="15" PrevPageText="上一页"
ShowPageIndexBox="Always" TextBeforePageIndexBox="跳转到: " UrlPaging="false" Width="100%"
OnPageChanged="PageChanged">
</webdiyer:AspNetPager>
后台方法:
if (!IsPostBack)
{
SelectUSR();
}
private void SelectUSR()
{
var usrs = new UnShelveRecordServices();
int count = 0;
AnesMS.DataModel.Entity.UnShelveState? unshelState = null;
if (status != "-1")
{
int usrstatus = 0;
int.TryParse(status, out usrstatus);
unshelState = (AnesMS.DataModel.Entity.UnShelveState)usrstatus;
}
if (!string.IsNullOrEmpty(ddl_yg.SelectedValue))
{
chestkey = ddl_yg.SelectedValue;
}
var ds = usrs.GetUnShelveRecordList((string.IsNullOrEmpty(ddl_yg.SelectedValue) ? "0" : ddl_yg.SelectedValue),
unshelState,
string.IsNullOrEmpty(tbStart.Text) ? DateTime.Now.AddHours(-24) : Convert.ToDateTime(tbStart.Text + " 00:00"),
string.IsNullOrEmpty(tbEnd.Text) ? DateTime.Now.AddHours(24) : Convert.ToDateTime(tbEnd.Text + " 23:59"),
out count, (IsPostBack? this.AspNetPager1.CurrentPageIndex:pagenum), this.AspNetPager1.PageSize);
if (ds == null) return;
//分页控件初始参数
this.AspNetPager1.RecordCount = count;
if (IsPostBack)
pagenum = this.AspNetPager1.CurrentPageIndex;
if (ds != null && ds.Count > 0)
{
RepeaterUnshelveRe.DataSource = ds;
}
RepeaterUnshelveRe.DataBind();
}
protected void RepeaterUnshelveRe_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
DataRowView drv = e.Item.DataItem as DataRowView;
//获取状态
((Label)e.Item.FindControl("lblState")).Text = GetEnumDesc(typeof(UnShelveState), Enum.Parse(typeof(UnShelveState), ((Label)e.Item.FindControl("lblState")).Text));
if (((Label)e.Item.FindControl("lblState")).Text == "已完成")
{
((Label)e.Item.FindControl("lblState")).ForeColor = System.Drawing.Color.FromName("#174B73");
}
else if (((Label)e.Item.FindControl("lblState")).Text == "待下架")
{
((Label)e.Item.FindControl("lblState")).ForeColor = System.Drawing.Color.Red;
}
else if (((Label)e.Item.FindControl("lblState")).Text == "处理中")
{
((Label)e.Item.FindControl("lblState")).ForeColor = System.Drawing.Color.Green;
}
else if (((Label)e.Item.FindControl("lblState")).Text == "已下架")
{
((Label)e.Item.FindControl("lblState")).ForeColor = System.Drawing.Color.FromName("#8CC852");
}
//else
//{
// ((Label)e.Item.FindControl("lblState")).ForeColor = System.Drawing.Color.FromName("#FF007F");//#FF00FF 8CC852 174B73
//}
}
}
protected void PageChanged(object sender, EventArgs e)
{
SelectUSR();
}
linq:
/// <summary>
/// 下架单页面:列表
/// </summary>
public IList<USRChInfo> GetUnShelveRecordList(string chestkey,UnShelveState? state, DateTime dtFrom, DateTime dtTo, out int count, int curPage = 1, int pageSize = 15)
{
try
{
var entity = MyDynEntities;
count = 0;
var status_Int = state.GetHashCode();
IQueryable<USRChInfo> query = entity.UnShelveRecord.Join<UnShelveRecord, Chest, string, USRChInfo>(entity.Chest, x => x.ChestKey, c => c.ChestKey, (x, y) =>
new USRChInfo
{
UnShelveRecordKey=x.UnShelveRecordKey,
UnShelveRecordNo = x.UnShelveRecordNo,
ChestKey=x.ChestKey,
NameText = y.NameText,
ChestType=y.ChestType,
OperatorKey = x.OperatorKey,
OperatorName=x.OperatorName,
UnShelveTime = x.UnShelveTime,
State = x.State
}).Where(c => c.UnShelveTime >= dtFrom && c.UnShelveTime <= dtTo && c.ChestType!=-1);
if (chestkey != "0")
query = query.Where(c => chestkey.Contains(c.ChestKey));
if (state != null && status_Int!=-1)
query = query.Where(c => c.State == status_Int);
count = query.Count();
if (curPage > 0 && pageSize > 0)
{
query = query.OrderByDescending(c => c.UnShelveTime).Skip((curPage - 1) * pageSize).Take(pageSize);
}
else
query = query.OrderByDescending(c => c.UnShelveTime);
var QueryResult = query.OrderByDescending(c=>c.UnShelveTime).ToList();
return QueryResult;
}
catch (Exception ex)
{
count = 0;
LogHelper.Instance.CreateLog(ex);
return null;
}
}
声明:此文系舞林cuzn(www.wulinlw.org)原创稿件,转载请保留版权