private void ShowInfo(int _id) { BLL.StoreInOrder bll = new BLL.StoreInOrder(); Model.StoreInOrder model = bll.GetModel(_id); ddlCustomer.SelectedValue = model.CustomerId.ToString(); txtAccountNumber.Text = model.AccountNumber; txtInspectionNumber.Text = model.InspectionNumber; txtBeginChargingTime.Text = model.BeginChargingTime.ToString("yyyy-MM-dd"); txtChargingCount.Text = model.ChargingCount.ToString(); txtSuttleWeight.Text = model.SuttleWeight.ToString("0.00"); txtAdmin.Text = model.Admin; txtRemark.Text = model.Remark; BLL.StoreInUnitPrice unitpriceBLL = new BLL.StoreInUnitPrice(); DataTable unitpriceDT = unitpriceBLL.GetList(" StoreInOrderId = " + _id + "").Tables[0]; this.rptUnitPriceList.DataSource = unitpriceDT; this.rptUnitPriceList.DataBind(); BLL.StoreInCost costBLL = new BLL.StoreInCost(); DataTable costDT = costBLL.GetList(" StoreInOrderId = " + _id + "").Tables[0]; this.rptCostList.DataSource = costDT; this.rptCostList.DataBind(); BLL.StoreInGoods goodsBLL = new BLL.StoreInGoods(); DataTable goodsDT = goodsBLL.GetList(" and A.StoreInOrderId = " + _id + " ").Tables[0]; this.rptGoodsList.DataSource = goodsDT; this.rptGoodsList.DataBind(); }
private void ShowInfo(int _id) { BLL.StoreInOrder bll = new BLL.StoreInOrder(); Model.StoreInOrder model = bll.GetModel(_id); ddlCustomer.SelectedValue = model.CustomerId.ToString(); txtAccountNumber.Text = model.AccountNumber; txtInspectionNumber.Text = model.InspectionNumber; txtBeginChargingTime.Text = model.BeginChargingTime.ToString("yyyy-MM-dd"); txtChargingCount.Text = model.ChargingCount.ToString(); txtSuttleWeight.Text = model.SuttleWeight.ToString("0.00"); txtAdmin.Text = model.Admin; txtRemark.Text = model.Remark; BLL.StoreInUnitPrice unitpriceBLL = new BLL.StoreInUnitPrice(); DataTable unitpriceDT = unitpriceBLL.GetList(" StoreInOrderId = " + _id + "").Tables[0]; this.rptUnitPriceList.DataSource = unitpriceDT; this.rptUnitPriceList.DataBind(); BLL.StoreInCost costBLL = new BLL.StoreInCost(); DataTable costDT = costBLL.GetList(" StoreInOrderId = " + _id + "").Tables[0]; this.rptCostList.DataSource = costDT; this.rptCostList.DataBind(); BLL.StoreInGoods goodsBLL = new BLL.StoreInGoods(); DataTable goodsDT = goodsBLL.GetList(" and A.StoreInOrderId = " + _id + " ").Tables[0]; this.rptGoodsList.DataSource = goodsDT; this.rptGoodsList.DataBind(); }
private void UnitPriceBind(string storeInOrderValue) { string[] storeInOrderValues = storeInOrderValue.Split('|'); int _storeInOrderId; DateTime _chargingTime; decimal _chargingCount; DateTime _receivedEndTime = DateTime.Now; DateTime _receivedBeginTime = DateTime.Now; if (int.TryParse(storeInOrderValues[0], out _storeInOrderId) && DateTime.TryParse(storeInOrderValues[1], out _chargingTime) && Decimal.TryParse(storeInOrderValues[2], out _chargingCount)) { BLL.StoreInUnitPrice unitPriceBLL = new BLL.StoreInUnitPrice(); DataTable unitPriceDT = unitPriceBLL.GetList(0, "StoreInOrderId = " + _storeInOrderId + "", "BeginTime asc").Tables[0]; int rowsCount = unitPriceDT.Rows.Count; StringBuilder unitPriceText = new StringBuilder(); decimal totalPrice = 0.00M; for (int i = 0; i < rowsCount; i++) { DateTime beginTime = Convert.ToDateTime(unitPriceDT.Rows[i]["BeginTime"]); DateTime endTime = Convert.ToDateTime(unitPriceDT.Rows[i]["EndTime"]); decimal totalUnitPrice = 0.00M; if (i == 0) { beginTime = _chargingTime; _receivedBeginTime = beginTime; } if (i == rowsCount - 1) { DateTime et; if (!DateTime.TryParse(txtReceivedTime.Text, out et)) { et = DateTime.Now; } endTime = new DateTime(et.Year, et.Month, et.Day); _receivedEndTime = endTime; } totalUnitPrice = Convert.ToDecimal(unitPriceDT.Rows[i]["Price"]) * (endTime - beginTime).Days * _chargingCount; unitPriceText.AppendFormat("{0}、时间:{1}-{2},天数:{3},单价:{4},数量:{5},费用:{6}\r\n", i + 1, beginTime, endTime, (endTime - beginTime).Days, Convert.ToDecimal(unitPriceDT.Rows[i]["Price"]), _chargingCount, string.Format("{0:N2}", totalUnitPrice)); totalPrice += totalUnitPrice; } txtChargingCount.Text = _chargingCount.ToString("f2"); txtTotalMoney.Text = totalPrice.ToString("f2"); txtInvoiceMoney.Text = totalPrice.ToString("f2"); hidReceivedBeginTime.Value = _receivedBeginTime.ToString(); hidReceivedEndTime.Value = _receivedEndTime.ToString(); txtUnitPriceDetails.Text = unitPriceText.ToString(); } else { txtUnitPriceDetails.Text = "该入库单下没有单价,无法进行结账。"; } }
private void RptBind(string _strWhere, string _orderby) { BLL.StoreInUnitPrice bll = new BLL.StoreInUnitPrice(); this.rptList.DataSource = bll.GetList(0, _strWhere, _orderby); this.rptList.DataBind(); }
private void UnitPriceBind(string storeInOrderValue) { string[] storeInOrderValues = storeInOrderValue.Split('|'); int _storeInOrderId; DateTime _chargingTime; decimal _chargingCount; DateTime _receivedEndTime = DateTime.Now; DateTime _receivedBeginTime = DateTime.Now; if (int.TryParse(storeInOrderValues[0], out _storeInOrderId) && DateTime.TryParse(storeInOrderValues[1], out _chargingTime) && Decimal.TryParse(storeInOrderValues[2], out _chargingCount)) { BLL.StoreInUnitPrice unitPriceBLL = new BLL.StoreInUnitPrice(); DataTable unitPriceDT = unitPriceBLL.GetList(0, "StoreInOrderId = " + _storeInOrderId + "", "BeginTime asc").Tables[0]; int rowsCount = unitPriceDT.Rows.Count; StringBuilder unitPriceText = new StringBuilder(); decimal totalPrice = 0.00M; for (int i = 0; i < rowsCount; i++) { DateTime beginTime = Convert.ToDateTime(unitPriceDT.Rows[i]["BeginTime"]); DateTime endTime = Convert.ToDateTime(unitPriceDT.Rows[i]["EndTime"]); decimal totalUnitPrice = 0.00M; if (i == 0) { beginTime = _chargingTime; _receivedBeginTime = beginTime; } if (i == rowsCount - 1) { DateTime et; if (!DateTime.TryParse(txtReceivedTime.Text, out et)) { et = DateTime.Now; } endTime = new DateTime(et.Year, et.Month, et.Day); _receivedEndTime = endTime; } totalUnitPrice = Convert.ToDecimal(unitPriceDT.Rows[i]["Price"]) * (endTime - beginTime).Days * _chargingCount; unitPriceText.AppendFormat("{0}、时间:{1}-{2},天数:{3},单价:{4},数量:{5},费用:{6}\r\n", i + 1, beginTime, endTime, (endTime - beginTime).Days, Convert.ToDecimal(unitPriceDT.Rows[i]["Price"]), _chargingCount, string.Format("{0:N2}", totalUnitPrice)); totalPrice += totalUnitPrice; } txtChargingCount.Text = _chargingCount.ToString("f2"); txtTotalMoney.Text = totalPrice.ToString("f2"); txtInvoiceMoney.Text = totalPrice.ToString("f2"); hidReceivedBeginTime.Value = _receivedBeginTime.ToString(); hidReceivedEndTime.Value = _receivedEndTime.ToString(); txtUnitPriceDetails.Text = unitPriceText.ToString(); } else { txtUnitPriceDetails.Text = "该入库单下没有单价,无法进行结账。"; } }
private void RptBind(string _strWhere, string _orderby) { BLL.StoreInUnitPrice bll = new BLL.StoreInUnitPrice(); this.rptList.DataSource = bll.GetList(0, _strWhere, _orderby); this.rptList.DataBind(); }