c# - 在c#中从查找服务当前年份和上一年获取并绑定
问题描述
我已经有查找服务来获取年份列表
private void LoadDropDownList()
{
ddlTahunPrestasi.DataSource =
LookupManager.GetLookupTahunPrestasi(string.Empty);
ddlTahunPrestasi.DataBind();
ddlTahunPrestasi.SelectedValue =
TahunPrestasiManager.GetSingleRecordFromDate(DateTime.Now).ToString();
}
这是查找服务
public List<LookupModel<string>> GetLookupTahunPrestasi()
{
List<LookupModel<string>> list = new List<LookupModel<string>>();
using (PrestasiEntities context = new PrestasiEntities())
{
var entities = from p in context.TahunPrestasis
orderby p.startDate descending
select new LookupModel<string>
{
Value = p.tahunPrestasi_PK.ToString(),
Text = p.description
};
list = entities.ToList();
}
return list;
}
这是页面加载时默认当前年份的 TahunPrestasiManager.GetSingleRecordFromDate
public int GetSingleRecordFromDate(DateTime date)
{
var entity = this.Context.TahunPrestasis.SingleOrDefault(p => p.startDate <= date && p.endDate >= date);
if (entity != null)
{
var model = new TahunPrestasiModel()
{
TahunPrestasi_PK = entity.tahunPrestasi_PK,
Code = entity.code,
Description = entity.description,
StartDate = entity.startDate,
EndDate = entity.endDate,
KendiriMark_Ind = entity.kendiriMark_Ind,
PrestasiSelesai_Ind = entity.prestasiSelesai_Ind,
SuratKeputusanDate = entity.suratKeputusanDate
};
return model.TahunPrestasi_PK;
}
return 0;
}
这是输出
但是..我只想要当年和上一年的输出列表。注意:英语中的tahun是年。
解决方案
推荐阅读
- sass - 0.625rem 不是有效的 CSS 值
- nodes - Hyperledger cost of peers for an organization
- java - 使用oracle函数时如何在mybatis中将参数作为CLOB传递?
- javascript - Can't find application.js with javascript_pack_tag(Webpacker)
- angular - angular json schema form remove selected options from select options
- perl - 网络上的官方 Perl 文档是什么?
- java - How to use @Id of one @Entity in another @Entity in a @OneToOne relationship in Hibernate
- c# - How to use multiple PUT fuctions in Web api C#
- javascript - Making server-side rendered content interactive on the client (SSR + Client-Side JS)
- android - Unity 2018.4 Android Black Screen Issue