/// <summary> /// 库存状况分析--导出 /// </summary> /// <param name="QueryStr"></param> /// <returns></returns> public static DataTable GetSotrageAccountAnalysis(string QueryStr) { try { string point = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).SelPoint; DataTable dt = StorageAccountAnalysisDBHelper.GetSotrageAccountAnalysis(QueryStr); DataTable dtnew = dt.Clone(); for (int i = 0; i < dt.Rows.Count; i++) { DataRow row = dtnew.NewRow(); row["ProductCount"] = Decimal.Round(Decimal.Parse(dt.Rows[i]["ProductCount"].ToString()), int.Parse(point)).ToString(); row["Chaochu"] = Decimal.Round(Decimal.Parse(dt.Rows[i]["Chaochu"].ToString()), int.Parse(point)).ToString(); row["Duanque"] = Decimal.Round(Decimal.Parse(dt.Rows[i]["Duanque"].ToString()), int.Parse(point)).ToString(); row["MaxStockNum"] = Decimal.Round(Decimal.Parse(dt.Rows[i]["MaxStockNum"].ToString()), int.Parse(point)).ToString(); row["MinStockNum"] = Decimal.Round(Decimal.Parse(dt.Rows[i]["MinStockNum"].ToString()), int.Parse(point)).ToString(); row["ColorName"] = dt.Rows[i]["ColorName"].ToString(); row["UnitName"] = dt.Rows[i]["UnitName"].ToString(); row["ProductName"] = dt.Rows[i]["ProductName"].ToString(); row["ProductNo"] = dt.Rows[i]["ProductNo"].ToString(); row["Specification"] = dt.Rows[i]["Specification"].ToString(); dtnew.Rows.Add(row); } return(dtnew); } catch (Exception ex) { throw ex; } }
/// <summary> /// 库存状况分析--分页查询 /// </summary> /// <param name="QueryStr">查询条件</param> /// <param name="pageIndex">页数</param> /// <param name="pageSize">每页记录数</param> /// <param name="OrderBy">排序</param> /// <param name="totalCount">总记录数</param> /// <returns></returns> public static DataTable GetSotrageAccountAnalysis(string QueryStr, int pageIndex, int pageSize, string OrderBy, ref int totalCount) { try { return(StorageAccountAnalysisDBHelper.GetSotrageAccountAnalysis(QueryStr, pageIndex, pageSize, OrderBy, ref totalCount)); } catch (Exception ex) { throw ex; } }