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); }
public bool UpdateExpensesInfo(Model.TransportOrderItem model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update mtms_TransportOrderItem set "); strSql.Append(" FactDispatchCount = @FactDispatchCount, "); strSql.Append(" FactReceivedCount = @FactReceivedCount, "); strSql.Append(" TotalPrice = @TotalPrice, "); strSql.Append(" RoundStatus = @RoundStatus "); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@FactDispatchCount", SqlDbType.Decimal, 9), new SqlParameter("@FactReceivedCount", SqlDbType.Decimal, 9), new SqlParameter("@TotalPrice", SqlDbType.Decimal, 9), new SqlParameter("@RoundStatus", SqlDbType.VarChar, 254) }; parameters[0].Value = model.Id; parameters[1].Value = model.FactDispatchCount; parameters[2].Value = model.FactReceivedCount; parameters[3].Value = model.TotalPrice; parameters[4].Value = model.RoundStatus; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.TransportOrderItem GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select Id, TransportOrderId, OrderId, OrderCode, RoundStatus, ContractNumber, BillNumber, Shipper, Receiver, LoadingAddress, UnloadingAddress, Goods, Unit, FactDispatchCount, FactReceivedCount, CompensationCosts, MyCosts, Haulway, LoadingCapacityRunning, NoLoadingCapacityRunning, Formula, UnitPrice, TotalPrice, CompanyPrice "); strSql.Append(" from mtms_TransportOrderItem "); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = Id; Model.TransportOrderItem model = new Model.TransportOrderItem(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Id"].ToString() != "") { model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString()); } if (ds.Tables[0].Rows[0]["TransportOrderId"].ToString() != "") { model.TransportOrderId = int.Parse(ds.Tables[0].Rows[0]["TransportOrderId"].ToString()); } if (ds.Tables[0].Rows[0]["OrderId"].ToString() != "") { model.OrderId = int.Parse(ds.Tables[0].Rows[0]["OrderId"].ToString()); } model.OrderCode = ds.Tables[0].Rows[0]["OrderCode"].ToString(); model.RoundStatus = ds.Tables[0].Rows[0]["RoundStatus"].ToString(); model.ContractNumber = ds.Tables[0].Rows[0]["ContractNumber"].ToString(); model.BillNumber = ds.Tables[0].Rows[0]["BillNumber"].ToString(); model.Shipper = ds.Tables[0].Rows[0]["Shipper"].ToString(); model.Receiver = ds.Tables[0].Rows[0]["Receiver"].ToString(); model.LoadingAddress = ds.Tables[0].Rows[0]["LoadingAddress"].ToString(); model.UnloadingAddress = ds.Tables[0].Rows[0]["UnloadingAddress"].ToString(); model.Goods = ds.Tables[0].Rows[0]["Goods"].ToString(); model.Unit = ds.Tables[0].Rows[0]["Unit"].ToString(); if (ds.Tables[0].Rows[0]["FactDispatchCount"].ToString() != "") { model.FactDispatchCount = decimal.Parse(ds.Tables[0].Rows[0]["FactDispatchCount"].ToString()); } if (ds.Tables[0].Rows[0]["FactReceivedCount"].ToString() != "") { model.FactReceivedCount = decimal.Parse(ds.Tables[0].Rows[0]["FactReceivedCount"].ToString()); } if (ds.Tables[0].Rows[0]["CompensationCosts"].ToString() != "") { model.CompensationCosts = decimal.Parse(ds.Tables[0].Rows[0]["CompensationCosts"].ToString()); } if (ds.Tables[0].Rows[0]["MyCosts"].ToString() != "") { model.MyCosts = decimal.Parse(ds.Tables[0].Rows[0]["MyCosts"].ToString()); } model.Haulway = ds.Tables[0].Rows[0]["Haulway"].ToString(); if (ds.Tables[0].Rows[0]["LoadingCapacityRunning"].ToString() != "") { model.LoadingCapacityRunning = decimal.Parse(ds.Tables[0].Rows[0]["LoadingCapacityRunning"].ToString()); } if (ds.Tables[0].Rows[0]["NoLoadingCapacityRunning"].ToString() != "") { model.NoLoadingCapacityRunning = decimal.Parse(ds.Tables[0].Rows[0]["NoLoadingCapacityRunning"].ToString()); } model.Formula = ds.Tables[0].Rows[0]["Formula"].ToString(); if (ds.Tables[0].Rows[0]["UnitPrice"].ToString() != "") { model.UnitPrice = decimal.Parse(ds.Tables[0].Rows[0]["UnitPrice"].ToString()); } if (ds.Tables[0].Rows[0]["TotalPrice"].ToString() != "") { model.TotalPrice = decimal.Parse(ds.Tables[0].Rows[0]["TotalPrice"].ToString()); } if (ds.Tables[0].Rows[0]["CompanyPrice"].ToString() != "") { model.CompanyPrice = decimal.Parse(ds.Tables[0].Rows[0]["CompanyPrice"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.TransportOrderItem model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into mtms_TransportOrderItem("); strSql.Append("TransportOrderId,RoundStatus,ContractNumber,BillNumber,Shipper,Receiver,LoadingAddress,UnloadingAddress,Goods,Unit,FactDispatchCount,FactReceivedCount,CompensationCosts,MyCosts,Haulway,LoadingCapacityRunning,NoLoadingCapacityRunning,Formula,UnitPrice,TotalPrice,CompanyPrice,DispatchCount,OrderCode,OrderId"); strSql.Append(") values ("); strSql.Append("@TransportOrderId,@RoundStatus,@ContractNumber,@BillNumber,@Shipper,@Receiver,@LoadingAddress,@UnloadingAddress,@Goods,@Unit,@FactDispatchCount,@FactReceivedCount,@CompensationCosts,@MyCosts,@Haulway,@LoadingCapacityRunning,@NoLoadingCapacityRunning,@Formula,@UnitPrice,@TotalPrice,@CompanyPrice,@DispatchCount,@OrderCode,@OrderId"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@TransportOrderId", SqlDbType.Int, 4), new SqlParameter("@RoundStatus", SqlDbType.VarChar, 254), new SqlParameter("@ContractNumber", SqlDbType.VarChar, 254), new SqlParameter("@BillNumber", SqlDbType.VarChar, 254), new SqlParameter("@Shipper", SqlDbType.VarChar, 254), new SqlParameter("@Receiver", SqlDbType.VarChar, 254), new SqlParameter("@LoadingAddress", SqlDbType.VarChar, 254), new SqlParameter("@UnloadingAddress", SqlDbType.VarChar, 254), new SqlParameter("@Goods", SqlDbType.VarChar, 254), new SqlParameter("@Unit", SqlDbType.VarChar, 254), new SqlParameter("@FactDispatchCount", SqlDbType.Decimal, 9), new SqlParameter("@FactReceivedCount", SqlDbType.Decimal, 9), new SqlParameter("@CompensationCosts", SqlDbType.Decimal, 9), new SqlParameter("@MyCosts", SqlDbType.Decimal, 9), new SqlParameter("@Haulway", SqlDbType.VarChar, 254), new SqlParameter("@LoadingCapacityRunning", SqlDbType.Decimal, 9), new SqlParameter("@NoLoadingCapacityRunning", SqlDbType.Decimal, 9), new SqlParameter("@Formula", SqlDbType.VarChar, 254), new SqlParameter("@UnitPrice", SqlDbType.Decimal, 9), new SqlParameter("@TotalPrice", SqlDbType.Decimal, 9), new SqlParameter("@CompanyPrice", SqlDbType.Decimal, 9), new SqlParameter("@DispatchCount", SqlDbType.Decimal, 9), new SqlParameter("@OrderCode", SqlDbType.VarChar, 254), new SqlParameter("@OrderId", SqlDbType.Int, 4) }; parameters[0].Value = model.TransportOrderId; parameters[1].Value = model.RoundStatus; parameters[2].Value = model.ContractNumber; parameters[3].Value = model.BillNumber; parameters[4].Value = model.Shipper; parameters[5].Value = model.Receiver; parameters[6].Value = model.LoadingAddress; parameters[7].Value = model.UnloadingAddress; parameters[8].Value = model.Goods; parameters[9].Value = model.Unit; parameters[10].Value = model.FactDispatchCount; parameters[11].Value = model.FactReceivedCount; parameters[12].Value = model.CompensationCosts; parameters[13].Value = model.MyCosts; parameters[14].Value = model.Haulway; parameters[15].Value = model.LoadingCapacityRunning; parameters[16].Value = model.NoLoadingCapacityRunning; parameters[17].Value = model.Formula; parameters[18].Value = model.UnitPrice; parameters[19].Value = model.TotalPrice; parameters[20].Value = model.CompanyPrice; parameters[21].Value = model.DispatchCount; parameters[22].Value = model.OrderCode; parameters[23].Value = model.OrderId; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.TransportOrderItem model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update mtms_TransportOrderItem set "); strSql.Append(" TransportOrderId = @TransportOrderId , "); strSql.Append(" RoundStatus = @RoundStatus , "); strSql.Append(" ContractNumber = @ContractNumber , "); strSql.Append(" BillNumber = @BillNumber , "); strSql.Append(" Shipper = @Shipper , "); strSql.Append(" Receiver = @Receiver , "); strSql.Append(" LoadingAddress = @LoadingAddress , "); strSql.Append(" UnloadingAddress = @UnloadingAddress , "); strSql.Append(" Goods = @Goods , "); strSql.Append(" Unit = @Unit , "); strSql.Append(" FactDispatchCount = @FactDispatchCount , "); strSql.Append(" FactReceivedCount = @FactReceivedCount , "); strSql.Append(" CompensationCosts = @CompensationCosts , "); strSql.Append(" MyCosts = @MyCosts , "); strSql.Append(" Haulway = @Haulway , "); strSql.Append(" LoadingCapacityRunning = @LoadingCapacityRunning , "); strSql.Append(" NoLoadingCapacityRunning = @NoLoadingCapacityRunning , "); strSql.Append(" Formula = @Formula , "); strSql.Append(" UnitPrice = @UnitPrice , "); strSql.Append(" TotalPrice = @TotalPrice , "); strSql.Append(" CompanyPrice = @CompanyPrice, "); strSql.Append(" OrderCode = @OrderCode, "); strSql.Append(" OrderId = @OrderId "); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@TransportOrderId", SqlDbType.Int, 4), new SqlParameter("@RoundStatus", SqlDbType.VarChar, 254), new SqlParameter("@ContractNumber", SqlDbType.VarChar, 254), new SqlParameter("@BillNumber", SqlDbType.VarChar, 254), new SqlParameter("@Shipper", SqlDbType.VarChar, 254), new SqlParameter("@Receiver", SqlDbType.VarChar, 254), new SqlParameter("@LoadingAddress", SqlDbType.VarChar, 254), new SqlParameter("@UnloadingAddress", SqlDbType.VarChar, 254), new SqlParameter("@Goods", SqlDbType.VarChar, 254), new SqlParameter("@Unit", SqlDbType.VarChar, 254), new SqlParameter("@FactDispatchCount", SqlDbType.Decimal, 9), new SqlParameter("@FactReceivedCount", SqlDbType.Decimal, 9), new SqlParameter("@CompensationCosts", SqlDbType.Decimal, 9), new SqlParameter("@MyCosts", SqlDbType.Decimal, 9), new SqlParameter("@Haulway", SqlDbType.VarChar, 254), new SqlParameter("@LoadingCapacityRunning", SqlDbType.Decimal, 9), new SqlParameter("@NoLoadingCapacityRunning", SqlDbType.Decimal, 9), new SqlParameter("@Formula", SqlDbType.VarChar, 254), new SqlParameter("@UnitPrice", SqlDbType.Decimal, 9), new SqlParameter("@TotalPrice", SqlDbType.Decimal, 9), new SqlParameter("@CompanyPrice", SqlDbType.Decimal, 9), new SqlParameter("@OrderCode", SqlDbType.VarChar, 254), new SqlParameter("@OrderId", SqlDbType.Int, 4) }; parameters[0].Value = model.Id; parameters[1].Value = model.TransportOrderId; parameters[2].Value = model.RoundStatus; parameters[3].Value = model.ContractNumber; parameters[4].Value = model.BillNumber; parameters[5].Value = model.Shipper; parameters[6].Value = model.Receiver; parameters[7].Value = model.LoadingAddress; parameters[8].Value = model.UnloadingAddress; parameters[9].Value = model.Goods; parameters[10].Value = model.Unit; parameters[11].Value = model.FactDispatchCount; parameters[12].Value = model.FactReceivedCount; parameters[13].Value = model.CompensationCosts; parameters[14].Value = model.MyCosts; parameters[15].Value = model.Haulway; parameters[16].Value = model.LoadingCapacityRunning; parameters[17].Value = model.NoLoadingCapacityRunning; parameters[18].Value = model.Formula; parameters[19].Value = model.UnitPrice; parameters[20].Value = model.TotalPrice; parameters[21].Value = model.CompanyPrice; parameters[22].Value = model.OrderCode; parameters[23].Value = model.OrderId; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 获得数据列表 /// </summary> public List<Model.TransportOrderItem> DataTableToList(DataTable dt) { List<Model.TransportOrderItem> modelList = new List<Model.TransportOrderItem>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Model.TransportOrderItem model; for (int n = 0; n < rowsCount; n++) { model = new Model.TransportOrderItem(); if (dt.Rows[n]["Id"].ToString() != "") { model.Id = int.Parse(dt.Rows[n]["Id"].ToString()); } if (dt.Rows[n]["TransportOrderId"].ToString() != "") { model.TransportOrderId = int.Parse(dt.Rows[n]["TransportOrderId"].ToString()); } model.RoundStatus = dt.Rows[n]["RoundStatus"].ToString(); model.ContractNumber = dt.Rows[n]["ContractNumber"].ToString(); model.BillNumber = dt.Rows[n]["BillNumber"].ToString(); model.Shipper = dt.Rows[n]["Shipper"].ToString(); model.Receiver = dt.Rows[n]["Receiver"].ToString(); model.LoadingAddress = dt.Rows[n]["LoadingAddress"].ToString(); model.UnloadingAddress = dt.Rows[n]["UnloadingAddress"].ToString(); model.Goods = dt.Rows[n]["Goods"].ToString(); model.Unit = dt.Rows[n]["Unit"].ToString(); if (dt.Rows[n]["FactDispatchCount"].ToString() != "") { model.FactDispatchCount = decimal.Parse(dt.Rows[n]["FactDispatchCount"].ToString()); } if (dt.Rows[n]["FactReceivedCount"].ToString() != "") { model.FactReceivedCount = decimal.Parse(dt.Rows[n]["FactReceivedCount"].ToString()); } if (dt.Rows[n]["CompensationCosts"].ToString() != "") { model.CompensationCosts = decimal.Parse(dt.Rows[n]["CompensationCosts"].ToString()); } if (dt.Rows[n]["MyCosts"].ToString() != "") { model.MyCosts = decimal.Parse(dt.Rows[n]["MyCosts"].ToString()); } model.Haulway = dt.Rows[n]["Haulway"].ToString(); if (dt.Rows[n]["LoadingCapacityRunning"].ToString() != "") { model.LoadingCapacityRunning = decimal.Parse(dt.Rows[n]["LoadingCapacityRunning"].ToString()); } if (dt.Rows[n]["NoLoadingCapacityRunning"].ToString() != "") { model.NoLoadingCapacityRunning = decimal.Parse(dt.Rows[n]["NoLoadingCapacityRunning"].ToString()); } model.Formula = dt.Rows[n]["Formula"].ToString(); if (dt.Rows[n]["UnitPrice"].ToString() != "") { model.UnitPrice = decimal.Parse(dt.Rows[n]["UnitPrice"].ToString()); } if (dt.Rows[n]["TotalPrice"].ToString() != "") { model.TotalPrice = decimal.Parse(dt.Rows[n]["TotalPrice"].ToString()); } if (dt.Rows[n]["CompanyPrice"].ToString() != "") { model.CompanyPrice = decimal.Parse(dt.Rows[n]["CompanyPrice"].ToString()); } modelList.Add(model); } } return modelList; }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.TransportOrderItem GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select Id, TransportOrderId, OrderId, OrderCode, RoundStatus, ContractNumber, BillNumber, Shipper, Receiver, LoadingAddress, UnloadingAddress, Goods, Unit, FactDispatchCount, FactReceivedCount, CompensationCosts, MyCosts, Haulway, LoadingCapacityRunning, NoLoadingCapacityRunning, Formula, UnitPrice, TotalPrice, CompanyPrice "); strSql.Append(" from mtms_TransportOrderItem "); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int,4) }; parameters[0].Value = Id; Model.TransportOrderItem model = new Model.TransportOrderItem(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Id"].ToString() != "") { model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString()); } if (ds.Tables[0].Rows[0]["TransportOrderId"].ToString() != "") { model.TransportOrderId = int.Parse(ds.Tables[0].Rows[0]["TransportOrderId"].ToString()); } if (ds.Tables[0].Rows[0]["OrderId"].ToString() != "") { model.OrderId = int.Parse(ds.Tables[0].Rows[0]["OrderId"].ToString()); } model.OrderCode = ds.Tables[0].Rows[0]["OrderCode"].ToString(); model.RoundStatus = ds.Tables[0].Rows[0]["RoundStatus"].ToString(); model.ContractNumber = ds.Tables[0].Rows[0]["ContractNumber"].ToString(); model.BillNumber = ds.Tables[0].Rows[0]["BillNumber"].ToString(); model.Shipper = ds.Tables[0].Rows[0]["Shipper"].ToString(); model.Receiver = ds.Tables[0].Rows[0]["Receiver"].ToString(); model.LoadingAddress = ds.Tables[0].Rows[0]["LoadingAddress"].ToString(); model.UnloadingAddress = ds.Tables[0].Rows[0]["UnloadingAddress"].ToString(); model.Goods = ds.Tables[0].Rows[0]["Goods"].ToString(); model.Unit = ds.Tables[0].Rows[0]["Unit"].ToString(); if (ds.Tables[0].Rows[0]["FactDispatchCount"].ToString() != "") { model.FactDispatchCount = decimal.Parse(ds.Tables[0].Rows[0]["FactDispatchCount"].ToString()); } if (ds.Tables[0].Rows[0]["FactReceivedCount"].ToString() != "") { model.FactReceivedCount = decimal.Parse(ds.Tables[0].Rows[0]["FactReceivedCount"].ToString()); } if (ds.Tables[0].Rows[0]["CompensationCosts"].ToString() != "") { model.CompensationCosts = decimal.Parse(ds.Tables[0].Rows[0]["CompensationCosts"].ToString()); } if (ds.Tables[0].Rows[0]["MyCosts"].ToString() != "") { model.MyCosts = decimal.Parse(ds.Tables[0].Rows[0]["MyCosts"].ToString()); } model.Haulway = ds.Tables[0].Rows[0]["Haulway"].ToString(); if (ds.Tables[0].Rows[0]["LoadingCapacityRunning"].ToString() != "") { model.LoadingCapacityRunning = decimal.Parse(ds.Tables[0].Rows[0]["LoadingCapacityRunning"].ToString()); } if (ds.Tables[0].Rows[0]["NoLoadingCapacityRunning"].ToString() != "") { model.NoLoadingCapacityRunning = decimal.Parse(ds.Tables[0].Rows[0]["NoLoadingCapacityRunning"].ToString()); } model.Formula = ds.Tables[0].Rows[0]["Formula"].ToString(); if (ds.Tables[0].Rows[0]["UnitPrice"].ToString() != "") { model.UnitPrice = decimal.Parse(ds.Tables[0].Rows[0]["UnitPrice"].ToString()); } if (ds.Tables[0].Rows[0]["TotalPrice"].ToString() != "") { model.TotalPrice = decimal.Parse(ds.Tables[0].Rows[0]["TotalPrice"].ToString()); } if (ds.Tables[0].Rows[0]["CompanyPrice"].ToString() != "") { model.CompanyPrice = decimal.Parse(ds.Tables[0].Rows[0]["CompanyPrice"].ToString()); } return model; } else { return null; } }
public bool UpdateExpensesInfo(Model.TransportOrderItem model) { return(dal.UpdateExpensesInfo(model)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.TransportOrderItem model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.TransportOrderItem model) { return(dal.Add(model)); }
/// <summary> /// 获得数据列表 /// </summary> public List <Model.TransportOrderItem> DataTableToList(DataTable dt) { List <Model.TransportOrderItem> modelList = new List <Model.TransportOrderItem>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Model.TransportOrderItem model; for (int n = 0; n < rowsCount; n++) { model = new Model.TransportOrderItem(); if (dt.Rows[n]["Id"].ToString() != "") { model.Id = int.Parse(dt.Rows[n]["Id"].ToString()); } if (dt.Rows[n]["TransportOrderId"].ToString() != "") { model.TransportOrderId = int.Parse(dt.Rows[n]["TransportOrderId"].ToString()); } model.RoundStatus = dt.Rows[n]["RoundStatus"].ToString(); model.ContractNumber = dt.Rows[n]["ContractNumber"].ToString(); model.BillNumber = dt.Rows[n]["BillNumber"].ToString(); model.Shipper = dt.Rows[n]["Shipper"].ToString(); model.Receiver = dt.Rows[n]["Receiver"].ToString(); model.LoadingAddress = dt.Rows[n]["LoadingAddress"].ToString(); model.UnloadingAddress = dt.Rows[n]["UnloadingAddress"].ToString(); model.Goods = dt.Rows[n]["Goods"].ToString(); model.Unit = dt.Rows[n]["Unit"].ToString(); if (dt.Rows[n]["FactDispatchCount"].ToString() != "") { model.FactDispatchCount = decimal.Parse(dt.Rows[n]["FactDispatchCount"].ToString()); } if (dt.Rows[n]["FactReceivedCount"].ToString() != "") { model.FactReceivedCount = decimal.Parse(dt.Rows[n]["FactReceivedCount"].ToString()); } if (dt.Rows[n]["CompensationCosts"].ToString() != "") { model.CompensationCosts = decimal.Parse(dt.Rows[n]["CompensationCosts"].ToString()); } if (dt.Rows[n]["MyCosts"].ToString() != "") { model.MyCosts = decimal.Parse(dt.Rows[n]["MyCosts"].ToString()); } model.Haulway = dt.Rows[n]["Haulway"].ToString(); if (dt.Rows[n]["LoadingCapacityRunning"].ToString() != "") { model.LoadingCapacityRunning = decimal.Parse(dt.Rows[n]["LoadingCapacityRunning"].ToString()); } if (dt.Rows[n]["NoLoadingCapacityRunning"].ToString() != "") { model.NoLoadingCapacityRunning = decimal.Parse(dt.Rows[n]["NoLoadingCapacityRunning"].ToString()); } model.Formula = dt.Rows[n]["Formula"].ToString(); if (dt.Rows[n]["UnitPrice"].ToString() != "") { model.UnitPrice = decimal.Parse(dt.Rows[n]["UnitPrice"].ToString()); } if (dt.Rows[n]["TotalPrice"].ToString() != "") { model.TotalPrice = decimal.Parse(dt.Rows[n]["TotalPrice"].ToString()); } if (dt.Rows[n]["CompanyPrice"].ToString() != "") { model.CompanyPrice = decimal.Parse(dt.Rows[n]["CompanyPrice"].ToString()); } modelList.Add(model); } } return(modelList); }
private bool DoEdit(int _id) { bool result = false; BLL.TransportOrder bll = new BLL.TransportOrder(); Model.TransportOrder model = bll.GetModel(_id); string[] orderIds = Request.Params.GetValues("orderId"); string[] factDispatchCounts = Request.Params.GetValues("factDispatchCount"); if (orderIds == null) { JscriptMsg("请填写运输项信息!", "", "Error"); return(false); } model.DispatchTime = Convert.ToDateTime(txtDispatchTime.Text.Trim()); model.FactDispatchTime = DateTime.Now; model.BackTime = Convert.ToDateTime(txtBackTime.Text.Trim()); model.FactBackTime = DateTime.Now; model.MotorcadeName = ddlMotorcade.SelectedValue; model.CarNumber = ddlCarNumber.SelectedValue; model.Driver = txtDriver.Text.Trim(); model.Remarks = txtRemarks.Text.Trim(); model.AddTime = DateTime.Now; model.Status = 0; List <Model.TransportOrderItem> item_list = new List <Model.TransportOrderItem>(); List <Model.Order> order_list = new List <Model.Order>();//订单 BLL.Order orderBll = new BLL.Order(); //new BLL.TransportOrderItem().DeleteBy(model.Id);//删除该运输单下 所有 运输子项 for (int i = 0; i < orderIds.Length; i++) { Model.Order order = orderBll.GetModel(Convert.ToInt32(orderIds[i])); if (order != null) { Model.TransportOrderItem item = new Model.TransportOrderItem(); item.OrderId = order.Id; item.OrderCode = order.Code; item.ContractNumber = order.ContractNumber; item.BillNumber = order.BillNumber; item.Shipper = order.Shipper; item.Receiver = order.Receiver; item.LoadingAddress = order.LoadingAddress; item.UnloadingAddress = order.UnloadingAddress; item.Goods = order.Goods; item.Unit = order.Unit; item.DispatchCount = order.Quantity; item.FactDispatchCount = Convert.ToDecimal(factDispatchCounts[i]); item.FactReceivedCount = item.FactDispatchCount; item.CompensationCosts = 0.00M; item.MyCosts = 0.00m; item.Haulway = order.Haulway; item.LoadingCapacityRunning = order.LoadingCapacityRunning; item.NoLoadingCapacityRunning = order.NoLoadingCapacityRunning; item.Formula = order.Formula; item.UnitPrice = order.UnitPrice; item.TotalPrice = order.TotalPrice; item.CompanyPrice = item.TotalPrice; item_list.Add(item); //int status = (order.IsCharteredCar == 1 || ((order.DispatchedCount + item.FactDispatchCount) == order.Quantity)) ? 1 : 0; //order.Status = status; //order.DispatchedCount = item.FactDispatchCount; //order_list.Add(order); } } if (bll.Update(model, item_list, order_list)) { AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "修改运输单信息:" + model.Code); //记录日志 result = true; } return(result); }
private bool DoAdd() { bool result = false; Model.TransportOrder model = new Model.TransportOrder(); BLL.TransportOrder bll = new BLL.TransportOrder(); string[] orderIds = Request.Params.GetValues("orderId"); string[] factDispatchCounts = Request.Params.GetValues("factDispatchCount"); if (orderIds == null) { JscriptMsg("请填写运输项信息!", "", "Error"); return false; } model.Code = "No" + DateTime.Now.ToString("yyyyMMddhhmmss"); model.DispatchTime = Convert.ToDateTime(txtDispatchTime.Text.Trim()); model.FactDispatchTime = DateTime.Now; model.BackTime = Convert.ToDateTime(txtBackTime.Text.Trim()); model.FactBackTime = DateTime.Now; model.MotorcadeName = ddlMotorcade.SelectedValue; model.CarNumber = ddlCarNumber.SelectedValue; model.Driver = txtDriver.Text.Trim(); model.Remarks = txtRemarks.Text.Trim(); List<Model.TransportOrderItem> item_list = new List<Model.TransportOrderItem>();//运输子项 List<Model.Order> order_list = new List<Model.Order>();//订单 BLL.Order orderBll = new BLL.Order(); for (int i = 0; i < orderIds.Length; i++) { Model.Order order = orderBll.GetModel(Convert.ToInt32(orderIds[i])); if (order != null) { Model.TransportOrderItem item = new Model.TransportOrderItem(); item.OrderId = order.Id; item.OrderCode = order.Code; item.ContractNumber = order.ContractNumber; item.BillNumber = order.BillNumber; item.Shipper = order.Shipper; item.Receiver = order.Receiver; item.LoadingAddress = order.LoadingAddress; item.UnloadingAddress = order.UnloadingAddress; item.Goods = order.Goods; item.Unit = order.Unit; item.DispatchCount = order.Quantity; item.FactDispatchCount = Convert.ToDecimal(factDispatchCounts[i]); item.FactReceivedCount = item.FactDispatchCount; item.CompensationCosts = 0.00M; item.MyCosts = 0.00m; item.Haulway = order.Haulway; item.LoadingCapacityRunning = order.LoadingCapacityRunning; item.NoLoadingCapacityRunning = order.NoLoadingCapacityRunning; item.Formula = order.Formula; item.UnitPrice = order.UnitPrice; item.TotalPrice = order.TotalPrice; item.CompanyPrice = item.TotalPrice; item_list.Add(item); // int status = (order.IsCharteredCar == 1 || ((order.DispatchedCount + item.FactDispatchCount) == order.Quantity)) ? 1 : 0; //order.Status = status; order.DispatchedCount = order.DispatchedCount + item.FactDispatchCount; order_list.Add(order); } } if (bll.Add(model,item_list,order_list) > 0) { AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加运输单:" + model.Code); //记录日志 result = true; } return result; }