public JArray Query(JObject form)
{
//TODO。。。判空
//太慢
//Dictionary<string, string> formdata = form.ToObject<Dictionary<string, string>>();
//return JArray.FromObject(_tdsAupoRepository.GetMainpo(formdata));
v_sIFREupoMain queryForm = new v_sIFREupoMain();
queryForm.BUKRS = form["BUKRS"].ToString().Trim();
queryForm.EBELN = form["EBELN"].ToString().Trim();
queryForm.matnrE = form["matnrE"].ToString().Trim();
queryForm.TXZ01 = form["TXZ01"].ToString().Trim();
queryForm.DECLITEM = form["DECLITEM"].ToString().Trim();
queryForm.STATUS = form["STATUS"].ToString().Trim();
queryForm.LIFNR = form["LIFNR"].ToString().Trim();
queryForm.vendortype = form["vendortype"].ToString().Trim();
queryForm.CHNAME = form["CHNAME"].ToString().Trim();
queryForm.BRGEW = form["BRGEW"].ToString().Trim();
queryForm.CHType = form["CHType"].ToString().Trim();
queryForm.MARK = form["MARK"].ToString().Trim();
string purchdateFrom = form["purchdateFrom"].ToString().Trim();
string purchdateTo = form["purchdateTo"].ToString().Trim();
var results = JArray.FromObject(_tdsAupoRepository.GetMainpo(queryForm, purchdateFrom, purchdateTo));
if (results == null)
{
return(null);
}
else
{
var tcurr = string.Empty;
if (results.First["BUKRS"].ToString().Equals("9000"))
{
results[0]["vendorname"] = _tdsAupoRepository.GetVendorname(results.First["LIFNR"].ToString());
}
if (!results.First["WAERS"].ToString().Equals("RMB"))
{
tcurr = _tdsAupoRepository.GetTcurr(results.First["BUKRS"].ToString(), results.First["WAERS"].ToString());
}
foreach (var result in results)
{
result["MARK"] = string.IsNullOrEmpty(result["MARK"].ToString()) ? "0" : result["MARK"];
result["TCURR"] = tcurr;
}
return(results);
}
}
/// <summary>
/// 查询
/// </summary>
/// <param name="form"></param>
/// <param name="purchdateFrom"></param>
/// <param name="purchdateTo"></param>
/// <returns></returns>
public IEnumerable <v_sIFREupoMain> GetMainpo(v_sIFREupoMain form, string purchdateFrom = null, string purchdateTo = null)
{
var data = _context.v_sIFREupoMains;
var result = form.BUKRS.Equals("Company") ? data : data.Where(x => x.BUKRS == form.BUKRS);
result = string.IsNullOrEmpty(form.BOITYP) ? result : result.Where(x => x.BOITYP == form.BOITYP);
result = string.IsNullOrEmpty(form.EBELN) ? result : result.Where(x => x.EBELN == form.EBELN);
result = string.IsNullOrEmpty(form.matnrE) ? result : result.Where(x => x.matnrE == form.matnrE);
result = string.IsNullOrEmpty(form.TXZ01) ? result : result.Where(x => x.TXZ01.Contains(form.TXZ01));
result = string.IsNullOrEmpty(form.DECLITEM) ? result : result.Where(x => x.DECLITEM == form.DECLITEM);
result = string.IsNullOrEmpty(form.STATUS) ? result : result.Where(x => x.STATUS == form.STATUS);
result = string.IsNullOrEmpty(form.LIFNR) ? result : result.Where(x => x.LIFNR == form.LIFNR);
result = string.IsNullOrEmpty(form.vendortype) ? result : result.Where(x => x.vendortype == form.vendortype);
result = string.IsNullOrEmpty(form.CHNAME) ? result : result.Where(x => x.CHNAME == form.CHNAME);
result = string.IsNullOrEmpty(form.BRGEW) ? result : result.Where(x => x.BRGEW == form.BRGEW);
result = string.IsNullOrEmpty(form.CHType) ? result : result.Where(x => x.CHType == form.CHType);
result = string.IsNullOrEmpty(form.MARK) ? result : result.Where(x => x.MARK == form.MARK);
result = string.IsNullOrEmpty(purchdateFrom) ? result : result.Where(x => String.Compare(x.purchdate, purchdateFrom) >= 0);
result = string.IsNullOrEmpty(purchdateTo) ? result : result.Where(x => String.Compare(x.purchdate, purchdateTo) <= 0);
return(result.OrderBy(x => x.EBELN).ThenBy(x => x.EBELP));
}
