static public string QueryTodayRecoder(int storeID, string nowTime, out string msg, ref int totalPage, ref int currentPage) { List <Dictionary <string, string> > list = InflowDAL.QueryTodayRecoder(storeID, nowTime, out msg); if (list == null) { msg = "今日无入库记录"; totalPage = 0; currentPage = -1; return(null); } totalPage = (int)System.Math.Floor((decimal)(list.Count / 10)); if (list.Count != 0 && list.Count % 10 == 0) { --totalPage; } if (currentPage < totalPage) { ++currentPage; } try { return(JsonConvert.SerializeObject(list.GetRange(currentPage * 10, 10))); } catch { return(JsonConvert.SerializeObject(list.GetRange(currentPage * 10, list.Count - currentPage * 10))); } }
static public string queryAllInflow(int storeID, ref int inflowTotalPage, ref int inflowCurrentPage, out string msg, out decimal money) { money = 0m; List <Dictionary <string, string> > list = InflowDAL.QueryAllByStoreID(storeID, out msg); if (list == null) { inflowTotalPage = 0; inflowCurrentPage = -1; return(null); } msg = null; foreach (Dictionary <string, string> d in list) { money += decimal.Parse(d["price"]) * decimal.Parse(d["quantity"]); } inflowTotalPage = (int)System.Math.Floor((decimal)(list.Count / 10)); if (list.Count != 0 && list.Count % 10 == 0) { --inflowTotalPage; } if (inflowCurrentPage < inflowTotalPage) { ++inflowCurrentPage; } try { return(JsonConvert.SerializeObject(list.GetRange(inflowCurrentPage * 10, 10))); } catch { return(JsonConvert.SerializeObject(list.GetRange(inflowCurrentPage * 10, list.Count - inflowCurrentPage * 10))); } }
static public string InflowCombinationQuery(int storeID, string keyWords, out string msg, ref int totalPage, ref int currentPage, out decimal money) { money = 0m; JObject keys = (JObject)JsonConvert.DeserializeObject(keyWords); List <Dictionary <string, string> > list = InflowDAL.CombinationQuery(keys, storeID, out msg); if (list == null) { msg = "搜索结果为空"; totalPage = 0; currentPage = -1; return(null); } foreach (Dictionary <string, string> d in list) { money += decimal.Parse(d["price"]) * decimal.Parse(d["quantity"]); } totalPage = (int)System.Math.Floor((decimal)(list.Count / 10)); if (list.Count != 0 && list.Count % 10 == 0) { --totalPage; } if (currentPage < totalPage) { ++currentPage; } try { return(JsonConvert.SerializeObject(list.GetRange(currentPage * 10, 10))); } catch { return(JsonConvert.SerializeObject(list.GetRange(currentPage * 10, list.Count - currentPage * 10))); } }
static public string ExportInflow(int storeID, out string msg, out decimal money) { money = 0m; List <Dictionary <string, string> > list = InflowDAL.QueryAllByStoreID(storeID, out msg); if (list == null) { msg = "没有需要导出的记录"; return(null); } msg = null; foreach (Dictionary <string, string> d in list) { money += decimal.Parse(d["price"]) * decimal.Parse(d["quantity"]); } return(JsonConvert.SerializeObject(list)); }
static public string ExportConbinationInflow(int storeID, string keyWords, out string msg, out decimal money) { money = 0m; JObject keys = (JObject)JsonConvert.DeserializeObject(keyWords); List <Dictionary <string, string> > list = InflowDAL.CombinationQuery(keys, storeID, out msg); if (list == null) { msg = "没有需要导出的记录"; return(null); } msg = null; foreach (Dictionary <string, string> d in list) { money += decimal.Parse(d["price"]) * decimal.Parse(d["quantity"]); } return(JsonConvert.SerializeObject(list)); }