protected void ButtonViewLog_Click(object sender, EventArgs e)
{
string from = this.CADateTimeFrom.IsDateEmpty ? string.Empty : this.CADateTimeFrom.SelectedDate.ToString("yyyy-MM-dd");
string to = this.CADateTimeTo.IsDateEmpty ? string.Empty : this.CADateTimeTo.SelectedDate.ToString("yyyy-MM-dd");
DataTable dtLinq = GetQueryListData(from, to);
if (null == dtLinq || dtLinq.Rows.Count <= 0)
{
return;
}
StringBuilder sb = new StringBuilder();
var ItemCalculate = from dr in dtLinq.AsEnumerable()
orderby dr["CostCenter"] ascending
group dr by new { CostCenter = dr["CostCenter"], CostCenterName = dr["CostCenterName"], ItemCode = dr["ItemCode"], PackagedRegulation = dr["PackagedRegulation"], Title = dr["Title"], PONumber = dr["PONumber"] } into g
select new
{
CostCenter = g.Key.CostCenter,
CostCenterName = g.Key.CostCenterName,
ItemCode = g.Key.ItemCode,
TotalQuantity = g.Sum(row => Convert.ToDouble(row["TotalQuantity"])),
PackagedRegulation = g.Key.PackagedRegulation,
TotalPrice = g.Sum(row => Convert.ToDouble(row["TotalPrice"])),
PRNO = g.Key.Title,
PONO = g.Key.PONumber
};
foreach (var item in ItemCalculate)
{
string sItemCode = item.ItemCode.ToString();
if (sItemCode.StartsWith("X", StringComparison.InvariantCultureIgnoreCase))
{
continue;
}
PurchaseRequest.PaperBagForVendor pbv = new PaperBagForVendor();
string sTotalQuantity = pbv.GetCount(item.PackagedRegulation.ToString(), item.TotalQuantity.ToString()).ToString();
sb.AppendFormat("PRNO: {0} ", item.PRNO);
sb.AppendFormat("PONO: {0} ", item.PONO);
sb.AppendFormat("TotalPrice: {0} ", item.TotalPrice);
sb.AppendFormat("ItemCode: {0} ", item.ItemCode);
sb.AppendFormat("TotalQuantity: {0} ", item.TotalQuantity);
sb.AppendFormat("CostCenter: {0} ", item.CostCenter);
sb.Append("<br /><br />");
}
LiteralLog.Text = sb.ToString();
}
/// <summary>
/// 得到纸袋所有记录
/// </summary>
/// <param name="from"></param>
/// <param name="to"></param>
/// <returns></returns>
DataTable GetPaperBagData(string from, string to)
{
DataTable dtLinq = GetQueryListData(from, to);
if (null == dtLinq||dtLinq.Rows.Count<=0)
{
return null;
}
DataTable dt = new DataTable();
dt.Columns.Add("CostCenter");
dt.Columns.Add("CostCenterName");
dt.Columns.Add("ItemCode");
dt.Columns.Add("TotalQuantity");
dt.Columns.Add("TotalPrice");
var ItemCalculate = from dr in dtLinq.AsEnumerable()
orderby dr["CostCenter"] ascending
group dr by new { CostCenter = dr["CostCenter"], CostCenterName = dr["CostCenterName"], ItemCode = dr["ItemCode"], PackagedRegulation = dr["PackagedRegulation"]} into g
select new
{
CostCenter = g.Key.CostCenter,
CostCenterName = g.Key.CostCenterName,
ItemCode = g.Key.ItemCode,
TotalQuantity = g.Sum(row => Convert.ToDouble(row["TotalQuantity"])),
PackagedRegulation = g.Key.PackagedRegulation,
TotalPrice = g.Sum(row => Convert.ToDouble(row["TotalPrice"]))
};
foreach (var item in ItemCalculate)
{
string sItemCode = item.ItemCode.ToString();
if (sItemCode.StartsWith("X", StringComparison.InvariantCultureIgnoreCase))
{
continue;
}
PurchaseRequest.PaperBagForVendor pbv = new PaperBagForVendor();
string sTotalQuantity= pbv.GetCount(item.PackagedRegulation.ToString(), item.TotalQuantity.ToString()).ToString();
DataRow dr = dt.NewRow();
dr["CostCenter"] = item.CostCenter;
dr["CostCenterName"] = item.CostCenterName;
dr["ItemCode"] = sItemCode;
dr["TotalQuantity"] = sTotalQuantity.ToString();
dr["TotalPrice"] = item.TotalPrice;
dt.Rows.Add(dr);
}
return dt;
}