private void RptBind() { BLL.Consumption consumptionBll = new BLL.Consumption(); DataSet consumptionDS = consumptionBll.GetList(0, "TransportOrderId = " + id + "", "Money"); this.rptList.DataSource = consumptionDS; this.rptList.DataBind(); }
protected decimal GetTotalConsumption(string transportOrderId) { decimal totalCost = 0.00M; BLL.Consumption consumptionBll = new BLL.Consumption(); DataSet consumptionDS = consumptionBll.GetList(0, "TransportOrderId = " + transportOrderId + "", "Money"); if (consumptionDS != null && consumptionDS.Tables[0].Rows.Count > 0) { foreach (DataRow dr in consumptionDS.Tables[0].Rows) { totalCost += Utils.StrToDecimal(dr["Money"].ToString(), 0.00M); } } return(totalCost); }
protected string GetTransportOrderItems(string transportOrderId, string advance, string factRepayment, string carriage) { decimal totalMoney = 0.00M; BLL.TransportOrderItem itemBll = new BLL.TransportOrderItem(); DataSet ds = itemBll.GetList(0, "TransportOrderId = " + transportOrderId + "", "TotalPrice"); if (ds != null && ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { totalMoney += Utils.StrToDecimal(dr["TotalPrice"].ToString(), 0.00M); } } decimal totalCost = 0.00M; BLL.Consumption consumptionBll = new BLL.Consumption(); DataSet consumptionDS = consumptionBll.GetList(0, "TransportOrderId = " + transportOrderId + "", "Money"); if (ds != null && consumptionDS.Tables[0].Rows.Count > 0) { foreach (DataRow dr in consumptionDS.Tables[0].Rows) { totalCost += Utils.StrToDecimal(dr["Money"].ToString(), 0.00M); } } decimal gain = totalMoney - Utils.StrToDecimal(advance, 0.00M) + Utils.StrToDecimal(factRepayment, 0.00M) - Utils.StrToDecimal(carriage, 0.00M) - totalCost; string html = string.Format("<td align=\"center\">¥{0}</td><td align=\"center\">¥{1}</td><td align=\"center\">¥{2}</td><td align=\"center\">¥{3}</td><td align=\"center\">¥{4}</td><td align=\"center\">¥{5}</td>", string.Format("{0:N2}", advance), string.Format("{0:N2}", factRepayment), string.Format("{0:N2}", carriage), string.Format("{0:N2}", totalMoney), string.Format("<a href=\"javascript:void(0);\" onclick=\"showCost(" + transportOrderId + ");\">{0:N2}</a>", totalCost), string.Format("{0:N2}", gain)); return(html); }
protected string GetTransportOrderItems(string transportOrderId, string advance, string factRepayment, string carriage) { decimal totalMoney = 0.00M; BLL.TransportOrderItem itemBll = new BLL.TransportOrderItem(); DataSet ds = itemBll.GetList(0, "TransportOrderId = " + transportOrderId + "", "TotalPrice"); if (ds != null && ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { totalMoney += Utils.StrToDecimal(dr["TotalPrice"].ToString(), 0.00M); } } decimal totalCost = 0.00M; BLL.Consumption consumptionBll = new BLL.Consumption(); DataSet consumptionDS = consumptionBll.GetList(0, "TransportOrderId = " + transportOrderId + "", "Money"); if (ds != null && consumptionDS.Tables[0].Rows.Count > 0) { foreach (DataRow dr in consumptionDS.Tables[0].Rows) { totalCost += Utils.StrToDecimal(dr["Money"].ToString(), 0.00M); } } decimal gain = totalMoney - Utils.StrToDecimal(advance, 0.00M) + Utils.StrToDecimal(factRepayment, 0.00M) - Utils.StrToDecimal(carriage, 0.00M) - totalCost; string html = string.Format("<td align=\"center\">¥{0}</td><td align=\"center\">¥{1}</td><td align=\"center\">¥{2}</td><td align=\"center\">¥{3}</td><td align=\"center\">¥{4}</td><td align=\"center\">¥{5}</td>", string.Format("{0:N2}", advance), string.Format("{0:N2}", factRepayment), string.Format("{0:N2}", carriage), string.Format("{0:N2}", totalMoney), string.Format("<a href=\"javascript:void(0);\" onclick=\"showCost(" + transportOrderId + ");\">{0:N2}</a>", totalCost), string.Format("{0:N2}", gain)); return html; }
protected decimal GetTotalConsumption(string transportOrderId) { decimal totalCost = 0.00M; BLL.Consumption consumptionBll = new BLL.Consumption(); DataSet consumptionDS = consumptionBll.GetList(0, "TransportOrderId = " + transportOrderId + "", "Money"); if (consumptionDS != null && consumptionDS.Tables[0].Rows.Count > 0) { foreach (DataRow dr in consumptionDS.Tables[0].Rows) { totalCost += Utils.StrToDecimal(dr["Money"].ToString(), 0.00M); } } return totalCost; }