private void ShowInfo(int _id) { BLL.TransportOrder bll = new BLL.TransportOrder(); Model.TransportOrder model = bll.GetModel(_id); txtDispatchTime.Text = model.DispatchTime.ToString("yyyy-MM-dd"); txtBackTime.Text = model.BackTime.ToString("yyyy-MM-dd"); ddlMotorcade.SelectedValue = model.MotorcadeName; ddlCarNumber.SelectedValue = model.CarNumber; txtDriver.Text = model.Driver; txtRemarks.Text = model.Remarks; BLL.TransportOrderItem itemBll = new BLL.TransportOrderItem(); DataTable dt = itemBll.GetList(" TransportOrderId = " + model.Id + "").Tables[0]; foreach (DataRow dr in dt.Rows) { string dispatchCount = dr["DispatchCount"].ToString().Equals("0.00") ? "包车" : dr["DispatchCount"].ToString(); transportOrderItems += "<tr data-value=\"" + dr["Id"].ToString() + "\" data-order-id=\"" + dr["OrderId"].ToString() + "\">"; transportOrderItems += "<td width=\"5%\"><input type=\"hidden\" name=\"orderId\" value=\"" + dr["OrderId"].ToString() + "\"/></td>"; transportOrderItems += "<td width=\"10%\">" + dr["BillNumber"].ToString() + "</td>"; transportOrderItems += "<td width=\"10%\">" + dr["Shipper"].ToString() + "</td>"; transportOrderItems += "<td width=\"10%\">" + dr["Receiver"].ToString() + "</td>"; transportOrderItems += "<td width=\"10%\">" + dr["Goods"].ToString() + "</td>"; transportOrderItems += "<td width=\"9%\">" + dr["Unit"].ToString() + "</td>"; transportOrderItems += "<td width=\"6%\">" + dispatchCount + "</td>"; transportOrderItems += "<td width=\"5%\"><input type=\"text\" name=\"factDispatchCount\" value=\"" + dr["FactDispatchCount"].ToString() + "\" class=\"input small\"/></td>"; transportOrderItems += "<td width=\"5%\">" + dr["UnitPrice"].ToString() + "</td>"; transportOrderItems += "<td width=\"5%\">" + dr["TotalPrice"].ToString() + "</td>"; transportOrderItems += "</tr>"; } }
protected string GetTransportOrderItems(string transportOrderId) { BLL.TransportOrderItem itemBll = new BLL.TransportOrderItem(); string shippers = string.Empty; string goods = string.Empty; string loadingAddress = string.Empty; string unloadingAddress = string.Empty; DataSet ds = itemBll.GetList(0, "TransportOrderId = " + transportOrderId + "", "Shipper, Goods, LoadingAddress, UnloadingAddress"); if (ds != null && ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { shippers += dr["Shipper"].ToString() + ","; goods += dr["Goods"].ToString() + ","; loadingAddress += dr["LoadingAddress"].ToString() + ","; unloadingAddress += dr["UnloadingAddress"].ToString() + ","; } shippers = shippers.TrimEnd(','); goods = goods.TrimEnd(','); loadingAddress = loadingAddress.TrimEnd(','); unloadingAddress = unloadingAddress.TrimEnd(','); } string html = string.Format("<td align=\"center\">{0}</td><td align=\"center\">{1}</td><td align=\"center\">{2}</td><td align=\"center\">{3}</td>", shippers, goods, loadingAddress, unloadingAddress); return(html); }
private void ShowInfo(int _id) { BLL.TransportOrder bll = new BLL.TransportOrder(); Model.TransportOrder model = bll.GetModel(_id); labCode.Text = model.Code; labFactDispatchTime.Text = model.FactDispatchTime.Value.ToString("yyyy-MM-dd"); labMotorcadeName.Text = model.MotorcadeName; labCarNumber.Text = model.CarNumber; labDriver.Text = model.Driver; labPayee.Text = model.Payee; labAdvance.Text = model.Advance.ToString(); BLL.TransportOrderItem itemBll = new BLL.TransportOrderItem(); DataTable dt = itemBll.GetList(" TransportOrderId = " + model.Id + "").Tables[0]; foreach (DataRow dr in dt.Rows) { transportOrderItems += "<tr data-value=\"" + dr["Id"].ToString() + "\">"; transportOrderItems += "<td></td>"; transportOrderItems += "<td align=\"left\">" + dr["OrderCode"].ToString() + "</td>"; transportOrderItems += "<td width=\"10%\">" + dr["BillNumber"].ToString() + "</td>"; transportOrderItems += "<td width=\"10%\">" + dr["Shipper"].ToString() + "</td>"; transportOrderItems += "<td width=\"10%\">" + dr["Receiver"].ToString() + "</td>"; transportOrderItems += "<td width=\"10%\">" + dr["Goods"].ToString() + "</td>"; transportOrderItems += "<td width=\"9%\" align=\"center\">" + dr["Unit"].ToString() + "</td>"; transportOrderItems += "<td width=\"6%\">" + dr["DispatchCount"].ToString() + "</td>"; transportOrderItems += "<td width=\"5%\">" + dr["FactDispatchCount"].ToString() + "</td>"; transportOrderItems += "<td width=\"5%\">¥" + string.Format("{0:N2}", dr["UnitPrice"].ToString()) + "</td>"; transportOrderItems += "<td width=\"5%\">¥" + string.Format("{0:N2}", dr["TotalPrice"].ToString()) + "</td>"; transportOrderItems += "</tr>"; } }
private void ShowInfo(int _id) { BLL.TransportOrder bll = new BLL.TransportOrder(); Model.TransportOrder model = bll.GetModel(_id); labMotorcade.Text = model.MotorcadeName; labCarNumber.Text = model.CarNumber; labDriver.Text = model.Driver; labPayee.Text = model.Driver; BLL.TransportOrderItem itemBll = new BLL.TransportOrderItem(); DataTable dt = itemBll.GetList(" TransportOrderId = " + model.Id + "").Tables[0]; foreach (DataRow dr in dt.Rows) { string dispatchCount = dr["DispatchCount"].ToString().Equals("0.00") ? "包车" : dr["DispatchCount"].ToString(); transportOrderItems += "<tr data-value=\"" + dr["OrderId"].ToString() + "\">"; transportOrderItems += "<td width=\"5%\"><input type=\"hidden\" name=\"transportOrderItemId\" value=\"" + dr["Id"].ToString() + "\"/></td>"; transportOrderItems += "<td align=\"left\">" + dr["OrderCode"].ToString() + "</td>"; transportOrderItems += "<td width=\"10%\">" + dr["BillNumber"].ToString() + "</td>"; transportOrderItems += "<td width=\"10%\">" + dr["Shipper"].ToString() + "</td>"; transportOrderItems += "<td width=\"10%\">" + dr["Receiver"].ToString() + "</td>"; transportOrderItems += "<td width=\"10%\">" + dr["Goods"].ToString() + "</td>"; transportOrderItems += "<td width=\"9%\" align=\"center\">" + dr["Unit"].ToString() + "</td>"; transportOrderItems += "<td width=\"6%\">" + dispatchCount + "</td>"; transportOrderItems += "<td width=\"5%\">" + dr["FactDispatchCount"].ToString() + "</td>"; transportOrderItems += "<td width=\"5%\">¥" + dr["UnitPrice"].ToString() + "</td>"; transportOrderItems += "<td width=\"5%\">¥" + dr["TotalPrice"].ToString() + "</td>"; transportOrderItems += "</tr>"; } }
protected string GetTransportOrderItems(string transportOrderId) { BLL.TransportOrderItem itemBll = new BLL.TransportOrderItem(); string shippers = string.Empty; string goods = string.Empty; string loadingAddress = string.Empty; string unloadingAddress = string.Empty; DataSet ds = itemBll.GetList(0, "TransportOrderId = " + transportOrderId + "", "Shipper, Goods, LoadingAddress, UnloadingAddress"); if (ds != null && ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { shippers += dr["Shipper"].ToString() + ","; goods += dr["Goods"].ToString() + ","; loadingAddress += dr["LoadingAddress"].ToString() + ","; unloadingAddress += dr["UnloadingAddress"].ToString() + ","; } shippers = shippers.TrimEnd(','); goods = goods.TrimEnd(','); loadingAddress = loadingAddress.TrimEnd(','); unloadingAddress = unloadingAddress.TrimEnd(','); } string html = string.Format("<td align=\"center\">{0}</td><td align=\"center\">{1}</td><td align=\"center\">{2}</td><td align=\"center\">{3}</td>", shippers, goods, loadingAddress, unloadingAddress); return html; }
private void ShowInfo(int _id) { BLL.TransportOrder bll = new BLL.TransportOrder(); Model.TransportOrder model = bll.GetModel(_id); labFactDispatchTime.Text = model.FactDispatchTime.Value.ToString("yyyy-MM-dd"); txtFactBackTime.Text = DateTime.Now.ToString("yyyy-MM-dd"); labMotorcade.Text = model.MotorcadeName; labCarNumber.Text = model.CarNumber; labDriver.Text = model.Driver; labAdvance.Text = model.Advance.ToString(); labPayee.Text = model.Driver; txtRepayment.Text = model.Advance.ToString(); txtFactRepayment.Text = "0.00"; BLL.TransportOrderItem itemBll = new BLL.TransportOrderItem(); DataTable dt = itemBll.GetList(" TransportOrderId = " + model.Id + "").Tables[0]; foreach (DataRow dr in dt.Rows) { transportOrderItems += "<tr data-value=\"" + dr["Id"].ToString() + "\">"; transportOrderItems += "<td width=\"5%\"><input type=\"hidden\" name=\"transportOrderItemId\" value=\"" + dr["Id"].ToString() + "\"/></td>"; transportOrderItems += "<td align=\"left\">" + dr["OrderCode"].ToString() + "</td>"; transportOrderItems += "<td width=\"10%\"><select name='roundStatus'>"; transportOrderItems += "<option value='往'>往</option>"; transportOrderItems += "<option value='返'>返</option>"; transportOrderItems += "<option value='往返'>往返</option>"; transportOrderItems += "</select></td>"; transportOrderItems += "<td width=\"10%\">" + dr["Shipper"].ToString() + "</td>"; transportOrderItems += "<td width=\"10%\">" + dr["Receiver"].ToString() + "</td>"; transportOrderItems += "<td width=\"10%\">" + dr["Goods"].ToString() + "</td>"; transportOrderItems += "<td width=\"9%\">" + dr["Unit"].ToString() + "</td>"; transportOrderItems += "<td width=\"6%\"><input type=\"text\" name=\"factDispatchCount\" class=\"input small\" value=\"" + dr["FactDispatchCount"].ToString() + "\" style='width:50px'/></td>"; transportOrderItems += "<td width=\"5%\"><input type=\"text\" name=\"factReceivedCount\" class=\"input small\" value=\"" + dr["FactReceivedCount"].ToString() + "\" style='width:50px'/></td>"; transportOrderItems += "<td width=\"5%\">¥" + string.Format("{0:N2}", dr["UnitPrice"].ToString()) + "</td>"; transportOrderItems += "<td width=\"5%\">¥<input type=\"text\" name=\"totalPrice\" value=\"" + dr["TotalPrice"].ToString() + "\" style='width:50px'/></td>"; transportOrderItems += "</tr>"; } BLL.CostItem costItemBll = new BLL.CostItem(); DataTable costItemDT = costItemBll.GetAllList().Tables[0]; foreach (DataRow dr in costItemDT.Rows) { consumptions += "<tr data-value=\"" + dr["Id"].ToString() + "\">"; consumptions += "<td width=\"5%\"><input type=\"hidden\" name=\"costItemName\" value=\"" + dr["Name"].ToString() + "\"/></td>"; consumptions += "<td width=\"5%\">" + dr["Name"].ToString() + "</td>"; consumptions += "<td width=\"50%\">¥<input type=\"text\" name=\"money\" class=\"input small\" value=\"0.00\"/></td>"; consumptions += "</tr>"; } }
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); }
private bool DoEdit(int _id) { bool result = false; BLL.TransportOrder bll = new BLL.TransportOrder(); Model.TransportOrder model = bll.GetModel(_id); //model.FactDispatchTime = Utils.StrToDateTime(txtFactDispatchTime.Text.Trim(), DateTime.Now); //model.Advance = Utils.StrToDecimal(txtAdvance.Text.Trim(), 0.00M); model.AddTime = DateTime.Now; model.Status = 1; string[] itemIds = Request.Params.GetValues("transportOrderItemId"); string[] factDispatchCounts = Request.Params.GetValues("factDispatchCount"); List <Model.TransportOrderItem> item_list = new List <Model.TransportOrderItem>(); BLL.TransportOrderItem itemBll = new BLL.TransportOrderItem(); for (int i = 0; i < itemIds.Length; i++) { Model.TransportOrderItem item = itemBll.GetModel(Utils.StrToInt(itemIds[i], 0)); if (item != null) { item.FactDispatchCount = Utils.StrToDecimal(factDispatchCounts[i], item.FactDispatchCount); item_list.Add(item); } } if (bll.Update(model, item_list)) { AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "登记出车信息:" + model.Code); //记录日志 result = true; } return(result); }
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; }
private void RptBind() { string sql = " Status = 3 "; if (!string.IsNullOrEmpty(_beginTime)) { sql += " AND FactBackTime >= '" + _beginTime + "' "; txtBeginTime.Text = _beginTime; } else { sql += " AND FactBackTime >= '" + DateTime.Now.AddMonths(-1) + "' "; txtBeginTime.Text = DateTime.Now.AddMonths(-1).ToString("yyyy-MM-dd"); } if (!string.IsNullOrEmpty(_endTime)) { sql += " AND FactBackTime <= '" + _endTime + "' "; txtEndTime.Text = _endTime; } else { sql += " AND FactBackTime <= '" + DateTime.Now + "' "; txtEndTime.Text = DateTime.Now.ToString("yyyy-MM-dd"); } string ids = string.Empty; BLL.TransportOrder bll = new BLL.TransportOrder(); DataSet tods = bll.GetList(sql); if (tods != null && tods.Tables[0].Rows.Count > 0) { foreach (DataRow dr in tods.Tables[0].Rows) { ids += dr["Id"].ToString() + ","; totalFactRepayment += Utils.StrToDecimal(dr["FactRepayment"].ToString(), 0.00M); totalCarriage += Utils.StrToDecimal(dr["Carriage"].ToString(), 0.00M); totalAdvance += Utils.StrToDecimal(dr["Advance"].ToString(), 0.00M); } if (ids.EndsWith(",")) { ids = ids.TrimEnd(','); } } if (!string.IsNullOrEmpty(ids)) { BLL.TransportOrderItem itemBll = new BLL.TransportOrderItem(); DataSet itemds = itemBll.GetList(" TransportOrderId IN (" + ids + ") "); if (itemds != null && itemds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in itemds.Tables[0].Rows) { totalIncome += Utils.StrToDecimal(dr["TotalPrice"].ToString(), 0.00M); } } BLL.Consumption cBll = new BLL.Consumption(); DataSet cds = cBll.GetSumList(" TransportOrderId IN (" + ids + ") "); if (cds != null && cds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in cds.Tables[0].Rows) { totalCostItem += Utils.StrToDecimal(dr["TotalMoney"].ToString(), 0.00M); costItem += "<tr><td width=\"20%\" style=\"text-align:right\">"+dr["Name"].ToString()+" : </td>"; costItem += "<td>¥" + string.Format("{0:N2}", dr["TotalMoney"]) + "</td></tr>"; } } } //throw new Exception("totalIncome:" + totalIncome.ToString() // + "totalFactRepayment:" + totalFactRepayment.ToString() // + "totalCarriage:" + totalCarriage.ToString() // + "totalAdvance:" + totalAdvance.ToString() // + "totalCostItem:" + totalCostItem.ToString() // ); totalGain = totalIncome + totalFactRepayment - totalCarriage - totalAdvance - totalCostItem; }
private bool DoEdit(int _id) { bool result = false; BLL.TransportOrder bll = new BLL.TransportOrder(); Model.TransportOrder model = bll.GetModel(_id); model.FactBackTime = Utils.StrToDateTime(txtFactBackTime.Text.Trim(), DateTime.Now); model.Repayment = Utils.StrToDecimal(txtRepayment.Text.Trim(), 0.00M); model.FactRepayment = Utils.StrToDecimal(txtFactRepayment.Text.Trim(), 0.00M); model.Carriage = Utils.StrToDecimal(txtCarriage.Text.Trim(), 0.00M); model.Status = 2; string[] itemIds = Request.Params.GetValues("transportOrderItemId"); string[] factDispatchCounts = Request.Params.GetValues("factDispatchCount"); string[] factReceivedCounts = Request.Params.GetValues("factReceivedCount"); string[] totalPrices = Request.Params.GetValues("totalPrice"); string[] roundStatus = Request.Params.GetValues("roundStatus"); string[] costItemNames = Request.Params.GetValues("costItemName"); string[] monies = Request.Params.GetValues("money"); List <Model.TransportOrderItem> item_list = new List <Model.TransportOrderItem>(); BLL.TransportOrderItem itemBll = new BLL.TransportOrderItem(); Model.TransportOrderItem item; List <Model.Order> orders = new List <Model.Order>(); BLL.Order orderBll = new BLL.Order(); Model.Order order; for (int i = 0; i < itemIds.Length; i++) { item = itemBll.GetModel(Utils.StrToInt(itemIds[i], 0)); if (item != null) { decimal oldFactDispatchCount = item.FactDispatchCount; decimal newFactDispatchCount = Utils.StrToDecimal(factDispatchCounts[i], 0.00M); order = orderBll.GetModel(item.OrderId); order.DispatchedCount += newFactDispatchCount - oldFactDispatchCount; orders.Add(order); item.FactDispatchCount = newFactDispatchCount; item.FactReceivedCount = Utils.StrToDecimal(factReceivedCounts[i], 0.00M); item.TotalPrice = Utils.StrToDecimal(totalPrices[i], 0.00M); item.RoundStatus = roundStatus[i]; item_list.Add(item); } } List <Model.Consumption> consumption_list = new List <Model.Consumption>(); for (int i = 0; i < costItemNames.Length; i++) { Model.Consumption consumption = new Model.Consumption(); consumption.Name = costItemNames[i]; consumption.Money = Utils.StrToDecimal(monies[i], 0.00M); consumption.TransportOrderId = _id; consumption_list.Add(consumption); } if (bll.Update(model, item_list, consumption_list, orders)) { AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "回车报账信息:" + model.Code); //记录日志 result = true; } return(result); }
private bool DoEdit(int _id) { bool result = false; BLL.TransportOrder bll = new BLL.TransportOrder(); Model.TransportOrder model = bll.GetModel(_id); //model.FactDispatchTime = Utils.StrToDateTime(txtFactDispatchTime.Text.Trim(), DateTime.Now); //model.Advance = Utils.StrToDecimal(txtAdvance.Text.Trim(), 0.00M); model.AddTime = DateTime.Now; model.Status = 1; string[] itemIds = Request.Params.GetValues("transportOrderItemId"); string[] factDispatchCounts = Request.Params.GetValues("factDispatchCount"); List<Model.TransportOrderItem> item_list = new List<Model.TransportOrderItem>(); BLL.TransportOrderItem itemBll = new BLL.TransportOrderItem(); for (int i = 0; i < itemIds.Length; i++) { Model.TransportOrderItem item = itemBll.GetModel(Utils.StrToInt(itemIds[i], 0)); if (item != null) { item.FactDispatchCount = Utils.StrToDecimal(factDispatchCounts[i], item.FactDispatchCount); item_list.Add(item); } } if (bll.Update(model,item_list)) { AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "登记出车信息:" + model.Code); //记录日志 result = true; } return result; }
private void ShowInfo(int _id) { BLL.TransportOrder bll = new BLL.TransportOrder(); Model.TransportOrder model = bll.GetModel(_id); labCode.Text = model.Code; labFactDispatchTime.Text = model.FactDispatchTime.Value.ToString("yyyy-MM-dd"); labMotorcadeName.Text = model.MotorcadeName; labCarNumber.Text = model.CarNumber; labDriver.Text = model.Driver; labPayee.Text = model.Payee; labAdvance.Text = model.Advance.ToString(); BLL.TransportOrderItem itemBll = new BLL.TransportOrderItem(); DataTable dt = itemBll.GetList(" TransportOrderId = " + model.Id + "").Tables[0]; foreach (DataRow dr in dt.Rows) { transportOrderItems += "<tr data-value=\"" + dr["Id"].ToString() + "\">"; transportOrderItems += "<td></td>"; transportOrderItems += "<td align=\"left\">" + dr["OrderCode"].ToString() + "</td>"; transportOrderItems += "<td width=\"10%\">" + dr["BillNumber"].ToString() + "</td>"; transportOrderItems += "<td width=\"10%\">" + dr["Shipper"].ToString() + "</td>"; transportOrderItems += "<td width=\"10%\">" + dr["Receiver"].ToString() + "</td>"; transportOrderItems += "<td width=\"10%\">" + dr["Goods"].ToString() + "</td>"; transportOrderItems += "<td width=\"9%\" align=\"center\">" + dr["Unit"].ToString() + "</td>"; transportOrderItems += "<td width=\"6%\">" + dr["DispatchCount"].ToString() + "</td>"; transportOrderItems += "<td width=\"5%\">" + dr["FactDispatchCount"].ToString() + "</td>"; transportOrderItems += "<td width=\"5%\">¥" +string.Format("{0:N2}", dr["UnitPrice"].ToString())+ "</td>"; transportOrderItems += "<td width=\"5%\">¥" + string.Format("{0:N2}",dr["TotalPrice"].ToString()) + "</td>"; transportOrderItems += "</tr>"; } }
private void RptBind() { string sql = " Status = 3 "; if (!string.IsNullOrEmpty(_beginTime)) { sql += " AND FactBackTime >= '" + _beginTime + "' "; txtBeginTime.Text = _beginTime; } else { sql += " AND FactBackTime >= '" + DateTime.Now.AddMonths(-1) + "' "; txtBeginTime.Text = DateTime.Now.AddMonths(-1).ToString("yyyy-MM-dd"); } if (!string.IsNullOrEmpty(_endTime)) { sql += " AND FactBackTime <= '" + _endTime + "' "; txtEndTime.Text = _endTime; } else { sql += " AND FactBackTime <= '" + DateTime.Now + "' "; txtEndTime.Text = DateTime.Now.ToString("yyyy-MM-dd"); } string ids = string.Empty; BLL.TransportOrder bll = new BLL.TransportOrder(); DataSet tods = bll.GetList(sql); if (tods != null && tods.Tables[0].Rows.Count > 0) { foreach (DataRow dr in tods.Tables[0].Rows) { ids += dr["Id"].ToString() + ","; totalFactRepayment += Utils.StrToDecimal(dr["FactRepayment"].ToString(), 0.00M); totalCarriage += Utils.StrToDecimal(dr["Carriage"].ToString(), 0.00M); totalAdvance += Utils.StrToDecimal(dr["Advance"].ToString(), 0.00M); } if (ids.EndsWith(",")) { ids = ids.TrimEnd(','); } } if (!string.IsNullOrEmpty(ids)) { BLL.TransportOrderItem itemBll = new BLL.TransportOrderItem(); DataSet itemds = itemBll.GetList(" TransportOrderId IN (" + ids + ") "); if (itemds != null && itemds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in itemds.Tables[0].Rows) { totalIncome += Utils.StrToDecimal(dr["TotalPrice"].ToString(), 0.00M); } } BLL.Consumption cBll = new BLL.Consumption(); DataSet cds = cBll.GetSumList(" TransportOrderId IN (" + ids + ") "); if (cds != null && cds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in cds.Tables[0].Rows) { totalCostItem += Utils.StrToDecimal(dr["TotalMoney"].ToString(), 0.00M); costItem += "<tr><td width=\"20%\" style=\"text-align:right\">" + dr["Name"].ToString() + " : </td>"; costItem += "<td>¥" + string.Format("{0:N2}", dr["TotalMoney"]) + "</td></tr>"; } } } //throw new Exception("totalIncome:" + totalIncome.ToString() // + "totalFactRepayment:" + totalFactRepayment.ToString() // + "totalCarriage:" + totalCarriage.ToString() // + "totalAdvance:" + totalAdvance.ToString() // + "totalCostItem:" + totalCostItem.ToString() // ); totalGain = totalIncome + totalFactRepayment - totalCarriage - totalAdvance - totalCostItem; }
private void ShowInfo(int _id) { BLL.TransportOrder bll = new BLL.TransportOrder(); Model.TransportOrder model = bll.GetModel(_id); labMotorcade.Text = model.MotorcadeName; labCarNumber.Text = model.CarNumber; labDriver.Text = model.Driver; labPayee.Text = model.Driver; BLL.TransportOrderItem itemBll = new BLL.TransportOrderItem(); DataTable dt = itemBll.GetList(" TransportOrderId = " + model.Id + "").Tables[0]; foreach (DataRow dr in dt.Rows) { string dispatchCount = dr["DispatchCount"].ToString().Equals("0.00") ? "包车" : dr["DispatchCount"].ToString(); transportOrderItems += "<tr data-value=\"" + dr["OrderId"].ToString() + "\">"; transportOrderItems += "<td width=\"5%\"><input type=\"hidden\" name=\"transportOrderItemId\" value=\"" + dr["Id"].ToString() + "\"/></td>"; transportOrderItems += "<td align=\"left\">" + dr["OrderCode"].ToString() + "</td>"; transportOrderItems += "<td width=\"10%\">" + dr["BillNumber"].ToString() + "</td>"; transportOrderItems += "<td width=\"10%\">" + dr["Shipper"].ToString() + "</td>"; transportOrderItems += "<td width=\"10%\">" + dr["Receiver"].ToString() + "</td>"; transportOrderItems += "<td width=\"10%\">" + dr["Goods"].ToString() + "</td>"; transportOrderItems += "<td width=\"9%\" align=\"center\">" + dr["Unit"].ToString() + "</td>"; transportOrderItems += "<td width=\"6%\">" + dispatchCount + "</td>"; transportOrderItems += "<td width=\"5%\">" + dr["FactDispatchCount"].ToString() + "</td>"; transportOrderItems += "<td width=\"5%\">¥" + dr["UnitPrice"].ToString() + "</td>"; transportOrderItems += "<td width=\"5%\">¥" + dr["TotalPrice"].ToString() + "</td>"; transportOrderItems += "</tr>"; } }
private void ShowInfo(int _id) { BLL.TransportOrder bll = new BLL.TransportOrder(); Model.TransportOrder model = bll.GetModel(_id); labFactDispatchTime.Text = model.FactDispatchTime.Value.ToString("yyyy-MM-dd"); txtFactBackTime.Text = DateTime.Now.ToString("yyyy-MM-dd"); labMotorcade.Text = model.MotorcadeName; labCarNumber.Text = model.CarNumber; labDriver.Text = model.Driver; labAdvance.Text = model.Advance.ToString(); labPayee.Text = model.Driver; txtRepayment.Text = model.Advance.ToString(); txtFactRepayment.Text = "0.00"; BLL.TransportOrderItem itemBll = new BLL.TransportOrderItem(); DataTable dt = itemBll.GetList(" TransportOrderId = " + model.Id + "").Tables[0]; foreach (DataRow dr in dt.Rows) { transportOrderItems += "<tr data-value=\"" + dr["Id"].ToString() + "\">"; transportOrderItems += "<td width=\"5%\"><input type=\"hidden\" name=\"transportOrderItemId\" value=\"" + dr["Id"].ToString() + "\"/></td>"; transportOrderItems += "<td align=\"left\">" + dr["OrderCode"].ToString() + "</td>"; transportOrderItems += "<td width=\"10%\"><select name='roundStatus'>"; transportOrderItems += "<option value='往'>往</option>"; transportOrderItems += "<option value='返'>返</option>"; transportOrderItems += "<option value='往返'>往返</option>"; transportOrderItems += "</select></td>"; transportOrderItems += "<td width=\"10%\">" + dr["Shipper"].ToString() + "</td>"; transportOrderItems += "<td width=\"10%\">" + dr["Receiver"].ToString() + "</td>"; transportOrderItems += "<td width=\"10%\">" + dr["Goods"].ToString() + "</td>"; transportOrderItems += "<td width=\"9%\">" + dr["Unit"].ToString() + "</td>"; transportOrderItems += "<td width=\"6%\"><input type=\"text\" name=\"factDispatchCount\" class=\"input small\" value=\"" + dr["FactDispatchCount"].ToString() + "\" style='width:50px'/></td>"; transportOrderItems += "<td width=\"5%\"><input type=\"text\" name=\"factReceivedCount\" class=\"input small\" value=\"" + dr["FactReceivedCount"].ToString() + "\" style='width:50px'/></td>"; transportOrderItems += "<td width=\"5%\">¥" + string.Format("{0:N2}",dr["UnitPrice"].ToString())+ "</td>"; transportOrderItems += "<td width=\"5%\">¥<input type=\"text\" name=\"totalPrice\" value=\"" + dr["TotalPrice"].ToString() + "\" style='width:50px'/></td>"; transportOrderItems += "</tr>"; } BLL.CostItem costItemBll = new BLL.CostItem(); DataTable costItemDT = costItemBll.GetAllList().Tables[0]; foreach (DataRow dr in costItemDT.Rows) { consumptions += "<tr data-value=\"" + dr["Id"].ToString() + "\">"; consumptions += "<td width=\"5%\"><input type=\"hidden\" name=\"costItemName\" value=\"" + dr["Name"].ToString() + "\"/></td>"; consumptions += "<td width=\"5%\">" + dr["Name"].ToString() + "</td>"; consumptions += "<td width=\"50%\">¥<input type=\"text\" name=\"money\" class=\"input small\" value=\"0.00\"/></td>"; consumptions += "</tr>"; } }
private bool DoEdit(int _id) { bool result = false; BLL.TransportOrder bll = new BLL.TransportOrder(); Model.TransportOrder model = bll.GetModel(_id); model.FactBackTime = Utils.StrToDateTime(txtFactBackTime.Text.Trim(), DateTime.Now); model.Repayment = Utils.StrToDecimal(txtRepayment.Text.Trim(), 0.00M); model.FactRepayment = Utils.StrToDecimal(txtFactRepayment.Text.Trim(), 0.00M); model.Carriage = Utils.StrToDecimal(txtCarriage.Text.Trim(), 0.00M); model.Status = 2; string[] itemIds = Request.Params.GetValues("transportOrderItemId"); string[] factDispatchCounts = Request.Params.GetValues("factDispatchCount"); string[] factReceivedCounts = Request.Params.GetValues("factReceivedCount"); string[] totalPrices = Request.Params.GetValues("totalPrice"); string[] roundStatus = Request.Params.GetValues("roundStatus"); string[] costItemNames = Request.Params.GetValues("costItemName"); string[] monies = Request.Params.GetValues("money"); List<Model.TransportOrderItem> item_list = new List<Model.TransportOrderItem>(); BLL.TransportOrderItem itemBll = new BLL.TransportOrderItem(); Model.TransportOrderItem item; List<Model.Order> orders = new List<Model.Order>(); BLL.Order orderBll = new BLL.Order(); Model.Order order; for (int i = 0; i < itemIds.Length; i++) { item = itemBll.GetModel(Utils.StrToInt(itemIds[i], 0)); if (item != null) { decimal oldFactDispatchCount = item.FactDispatchCount; decimal newFactDispatchCount = Utils.StrToDecimal(factDispatchCounts[i], 0.00M); order = orderBll.GetModel(item.OrderId); order.DispatchedCount += newFactDispatchCount - oldFactDispatchCount; orders.Add(order); item.FactDispatchCount = newFactDispatchCount; item.FactReceivedCount = Utils.StrToDecimal(factReceivedCounts[i], 0.00M); item.TotalPrice = Utils.StrToDecimal(totalPrices[i], 0.00M); item.RoundStatus = roundStatus[i]; item_list.Add(item); } } List<Model.Consumption> consumption_list = new List<Model.Consumption>(); for (int i = 0; i < costItemNames.Length; i++) { Model.Consumption consumption = new Model.Consumption(); consumption.Name = costItemNames[i]; consumption.Money = Utils.StrToDecimal(monies[i], 0.00M); consumption.TransportOrderId = _id; consumption_list.Add(consumption); } if (bll.Update(model, item_list, consumption_list, orders)) { AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "回车报账信息:" + model.Code); //记录日志 result = true; } return result; }
private void ShowInfo(int _id) { BLL.TransportOrder bll = new BLL.TransportOrder(); Model.TransportOrder model = bll.GetModel(_id); txtDispatchTime.Text = model.DispatchTime.ToString("yyyy-MM-dd"); txtBackTime.Text = model.BackTime.ToString("yyyy-MM-dd"); ddlMotorcade.SelectedValue = model.MotorcadeName; ddlCarNumber.SelectedValue = model.CarNumber; txtDriver.Text = model.Driver; txtRemarks.Text = model.Remarks; BLL.TransportOrderItem itemBll = new BLL.TransportOrderItem(); DataTable dt = itemBll.GetList(" TransportOrderId = " + model.Id + "").Tables[0]; foreach (DataRow dr in dt.Rows) { string dispatchCount = dr["DispatchCount"].ToString().Equals("0.00") ? "包车" : dr["DispatchCount"].ToString(); transportOrderItems += "<tr data-value=\"" + dr["Id"].ToString() + "\" data-order-id=\"" + dr["OrderId"].ToString() + "\">"; transportOrderItems += "<td width=\"5%\"><input type=\"hidden\" name=\"orderId\" value=\"" + dr["OrderId"].ToString() + "\"/></td>"; transportOrderItems += "<td width=\"10%\">" + dr["BillNumber"].ToString() + "</td>"; transportOrderItems += "<td width=\"10%\">" + dr["Shipper"].ToString() + "</td>"; transportOrderItems += "<td width=\"10%\">" + dr["Receiver"].ToString() + "</td>"; transportOrderItems += "<td width=\"10%\">" + dr["Goods"].ToString() + "</td>"; transportOrderItems += "<td width=\"9%\">" + dr["Unit"].ToString() + "</td>"; transportOrderItems += "<td width=\"6%\">" + dispatchCount + "</td>"; transportOrderItems += "<td width=\"5%\"><input type=\"text\" name=\"factDispatchCount\" value=\"" + dr["FactDispatchCount"].ToString() + "\" class=\"input small\"/></td>"; transportOrderItems += "<td width=\"5%\">" + dr["UnitPrice"].ToString() + "</td>"; transportOrderItems += "<td width=\"5%\">" + dr["TotalPrice"].ToString() + "</td>"; transportOrderItems += "</tr>"; } }