public object GetDetails(int page, int rows, string BillTypeCode, string BillTypeName, string BillClass, string IsActive)
{
IQueryable <BillType> billtypeQuery = BillTypeRepository.GetQueryable();
var billtype = billtypeQuery.Where(b => b.BillClass == BillClass && b.BillTypeCode.Contains(BillTypeCode) && b.BillTypeName.Contains(BillTypeName) && b.IsActive.Contains(IsActive)).OrderBy(b => b.BillTypeCode).AsEnumerable().Select(b => new { b.BillTypeCode, b.BillTypeName, b.BillClass, b.Description, IsActive = b.IsActive == "1" ? "可用" : "不可用", UpdateTime = b.UpdateTime.ToString("yyyy-MM-dd hh:mm:ss") });
int total = billtype.Count();
billtype = billtype.Skip((page - 1) * rows).Take(rows);
return(new { total, rows = billtype.ToArray() });
}
public bool Save(BillType billtype)
{
var br = BillTypeRepository.GetQueryable().FirstOrDefault(b => b.BillTypeCode == billtype.BillTypeCode);
br.BillTypeCode = billtype.BillTypeCode;
br.BillTypeName = billtype.BillTypeName;
br.BillClass = billtype.BillClass;
br.Description = billtype.Description;
br.IsActive = billtype.IsActive;
br.UpdateTime = DateTime.Now;
BillTypeRepository.SaveChanges();
return(true);
}
public new bool Add(BillType billtype)
{
var bi = new BillType();
bi.BillTypeCode = billtype.BillTypeCode;
bi.BillTypeName = billtype.BillTypeName;
bi.BillClass = billtype.BillClass;
bi.Description = billtype.Description;
bi.IsActive = billtype.IsActive;
bi.UpdateTime = DateTime.Now;
BillTypeRepository.Add(bi);
BillTypeRepository.SaveChanges();
return(true);
}
/// <summary>
/// 根据条件查询订单类型
/// </summary>
/// <param name="BillClass">订单类别</param>
/// <param name="IsActive">是否可用</param>
/// <returns></returns>
public object GetBillTypeDetail(string BillClass, string IsActive)
{
IQueryable <BillType> billtypeQuery = BillTypeRepository.GetQueryable();
var billtype = billtypeQuery.Where(b => b.BillClass == BillClass &&
b.IsActive.Contains(IsActive)).ToArray().OrderBy(b => b.BillTypeCode).Select(b => new
{
b.BillTypeCode,
b.BillTypeName,
b.BillClass,
b.Description,
IsActive = b.IsActive == "1" ? "可用" : "不可用",
UpdateTime = b.UpdateTime.ToString("yyyy-MM-dd hh:mm:ss")
});
return(billtype.ToArray());
}
public bool Delete(string billtypeCode)
{
var billtype = BillTypeRepository.GetQueryable()
.FirstOrDefault(b => b.BillTypeCode == billtypeCode);
if (billtypeCode != null)
{
BillTypeRepository.Delete(billtype);
BillTypeRepository.SaveChanges();
}
else
{
return(false);
}
return(true);
}
public System.Data.DataTable GetBillType(int page, int rows, string BillTypeCode, string BillTypeName, string BillClass, string IsActive)
{
IQueryable <BillType> billtypeQuery = BillTypeRepository.GetQueryable();
var billtype = billtypeQuery.Where(b => b.BillClass == BillClass &&
b.BillTypeCode.Contains(BillTypeCode) &&
b.BillTypeName.Contains(BillTypeName) &&
b.IsActive.Contains(IsActive))
.OrderBy(b => b.BillTypeCode).AsEnumerable()
.Select(b => new {
b.BillTypeCode,
b.BillTypeName,
b.BillClass,
b.Description,
IsActive = b.IsActive == "1" ? "可用" : "不可用",
UpdateTime = b.UpdateTime.ToString("yyyy-MM-dd hh:mm:ss")
});
System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.Add("订单类型编码", typeof(string));
dt.Columns.Add("订单类型名称", typeof(string));
dt.Columns.Add("订单类别", typeof(string));
dt.Columns.Add("描述", typeof(string));
dt.Columns.Add("是否可用", typeof(string));
dt.Columns.Add("更新时间", typeof(string));
foreach (var item in billtype)
{
dt.Rows.Add
(
item.BillTypeCode,
item.BillTypeName,
item.BillClass,
item.Description,
item.IsActive,
item.UpdateTime
);
}
return(dt);
}
