public string Data(int page = 1, int rows = 15, string productname = null, string stockname = null, string productnumber = null, string wdr = null, string batchno = null, string brand = null, string mode = null, string colorno = null) { if (!string.IsNullOrEmpty(brand) && (!string.IsNullOrEmpty(productname) || !string.IsNullOrEmpty(mode) || !string.IsNullOrEmpty(stockname) || !string.IsNullOrEmpty(colorno))) { int pagecount = 0; APIService.APIServiceClient api = new APIService.APIServiceClient(); DataTable table = api.WmStock( out pagecount, productnumber, productname, stockname, brand, batchno, wdr, mode, colorno, rows, page, true, false); return(JSONhelper.FormatJSONForEasyuiDataGrid(pagecount, table)); } return(null); }
public string SRCData(string itemid = null, string ICPRBILLNO = null, string FICPRENTRYID = null, string FSTOCK = null) { List <object> list = new List <object>(); List <string> srcnumbers = new List <string>(); var srclist = SRCDal.Instance.GetWhere(new { FPRODUCTID = itemid }).ToList(); foreach (var model in srclist) { srcnumbers.Add(model.FSRCCODE); } int pagecount = 0; APIService.APIServiceClient api = new APIService.APIServiceClient(); DataTable table = api.WmStock(out pagecount, string.Join(",", srcnumbers.ToArray()), "", FSTOCK, "", "", "", "", "", 1000, 1, true, false); foreach (var model in srclist) { var query = table.AsEnumerable().Where <DataRow>(m => m["FNumber"].ToString() == model.FSRCCODE); foreach (var row in query) { list.Add(new { FID = model.FID, FPRODUCTID = model.FPRODUCTID, FSRCNAME = model.FSRCNAME, FSRCCODE = model.FSRCCODE, FSRCMODEL = model.FSRCMODEL, FSRCUNIT = model.FUNIT, FORDERUNIT = model.FORDERUNIT, FRATE = model.FRATE, FBATCHNO = row["FBatchNo"], FCOLORNO = row["FColorNo"], FSTOCK = row["FStockName"], FSTOCKPLACE = row["FSPName"], FQTY = row["FBasicQty"], FLEVEL = row["FGrade"], FWDR = row["FWDRID"], FCOMMITQTY = System.DBNull.Value, FHNAMOUNT = 0, ICPRBILLNO = ICPRBILLNO, FICPRENTRYID = FICPRENTRYID, FREMARK = "" }); } } return(JSONhelper.FormatJSONForEasyuiDataGrid(list.Count, list)); }