public JiaoGeFee UpdateSingle(int id, JiaoGeFeeReq data)
{
JiaoGeFee model = db.JiaoGeFee.Find(id);
SetJiaoGeFee(model, data);
db.SaveChanges();
return(model);
}
/// <summary>
/// 设置model，如果不为空就设置,如果为空则和之前一样
/// </summary>
/// <param name="target"></param>
/// <param name="source"></param>
/// <returns></returns>
public JiaoGeFee SetJiaoGeFee(JiaoGeFee model, JiaoGeFeeReq data)
{
if (!string.IsNullOrEmpty(data.SearchDateInfo))
{
model.SearchDateInfo = data.SearchDateInfo;
}
if (!string.IsNullOrEmpty(data.ShouKuanInfos))
{
model.ShouKuanInfos = data.ShouKuanInfos;
}
if (!string.IsNullOrEmpty(data.State))
{
model.State = data.State;
}
if (data.CheckerId != null)
{
model.CheckerId = data.CheckerId.Value;
}
if (!string.IsNullOrEmpty(data.CheckerName))
{
model.CheckerName = data.CheckerName;
}
if (data.CreaterId != null)
{
model.CreaterId = data.CreaterId.Value;
}
if (!string.IsNullOrEmpty(data.CreaterName))
{
model.CreaterName = data.CreaterName;
}
if (data.projectid != null)
{
model.projectid = data.projectid.Value;
}
if (!string.IsNullOrEmpty(data.ProjectName))
{
model.ProjectName = data.ProjectName;
}
if (data.CheckDate != null && data.CheckDate != DateTime.MinValue &&
data.CheckDate != SqlDateTime.MinValue.Value)
{
model.CheckDate = data.CheckDate.Value;
}
if (data.CreateDate != null && data.CreateDate != DateTime.MinValue &&
data.CreateDate != SqlDateTime.MinValue.Value)
{
model.CreateDate = data.CreateDate.Value;
}
if (data.BeiYongMoney != null)
{
model.BeiYongMoney = data.BeiYongMoney.Value;
}
return(model);
}
/// <summary>
/// 查询JiaoGeFee
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public SearchListResult <JiaoGeFee> SearchList(JiaoGeFeeReq req)
{
var query = from source in db.JiaoGeFee select source;
if (!string.IsNullOrEmpty(req.SearchDateInfo))
{
query = query.Where(d => d.SearchDateInfo.Contains(req.SearchDateInfo));
}
if (!string.IsNullOrEmpty(req.ShouKuanInfos))
{
query = query.Where(d => d.ShouKuanInfos.Contains(req.ShouKuanInfos));
}
if (!string.IsNullOrEmpty(req.State))
{
query = query.Where(d => d.State.Contains(req.State));
}
if (req.CheckerId != null)
{
query = query.Where(d => d.CheckerId == req.CheckerId);
}
if (!string.IsNullOrEmpty(req.CheckerName))
{
query = query.Where(d => d.CheckerName.Contains(req.CheckerName));
}
if (req.CreaterId != null)
{
query = query.Where(d => d.CreaterId == req.CreaterId);
}
if (!string.IsNullOrEmpty(req.CreaterName))
{
query = query.Where(d => d.CreaterName.Contains(req.CreaterName));
}
if (!string.IsNullOrEmpty(req.projectids))
{
List <int> projectids =
req.projectids.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries)
.Select(s => Convert.ToInt32(s))
.ToList();
query = query.Where(d => d.projectid != null && projectids.Contains(d.projectid.Value));
}
if (req.projectid != null && req.projectid != 0)
{
query = query.Where(d => d.projectid == req.projectid);
}
if (!string.IsNullOrEmpty(req.ProjectName))
{
query = query.Where(d => d.ProjectName.Contains(req.ProjectName));
}
if (req.CheckDateStart != DateTime.MinValue && req.CheckDateStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.CheckDate >= req.CheckDateStart);
}
if (req.CheckDateEnd != DateTime.MinValue && req.CheckDateEnd != SqlDateTime.MinValue.Value)
{
DateTime CheckDateTemp = req.CheckDateEnd.AddDays(1);
query = query.Where(d => d.CheckDate < CheckDateTemp);
}
if (req.CreateDateStart != DateTime.MinValue && req.CreateDateStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.CreateDate >= req.CreateDateStart);
}
if (req.CreateDateEnd != DateTime.MinValue && req.CreateDateEnd != SqlDateTime.MinValue.Value)
{
DateTime CreateDateTemp = req.CreateDateEnd.AddDays(1);
query = query.Where(d => d.CreateDate < CreateDateTemp);
}
if (req.BeiYongMoney != null && req.BeiYongMoney != 0)
{
query = query.Where(d => d.BeiYongMoney == req.BeiYongMoney);
}
query = query.Where(d => d.ValidState != "InValid");
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "id";
req.sord = "desc";
}
SearchListResult <JiaoGeFee> retListResult = query.ToSearchList(req);
return(retListResult);
}