protected void lbtnDelete_Click(object sender, EventArgs e) { string Id = ((LinkButton)sender).CommandArgument; try { TheTransportPriceListDetailMgr.DeleteTransportPriceListDetail(Convert.ToInt32(Id)); ShowSuccessMessage("Transportation.TransportPriceListDetail.DeleteOperation.Successfully"); UpdateView(); } catch (Castle.Facilities.NHibernateIntegration.DataException ex) { ShowErrorMessage("Transportation.TransportPriceListDetail.DeleteOperation.Fail"); } }
protected void CV_ServerValidate(object source, ServerValidateEventArgs args) { CustomValidator cv = (CustomValidator)source; switch (cv.ID) { case "cvItem": if (TheItemMgr.LoadItem(args.Value.Trim()) == null) { ShowWarningMessage("MasterData.Item.Code.NotExist"); args.IsValid = false; } else { Controls_TextBox tbUom = ((Controls_TextBox)(this.FV_Operation.FindControl("tbUom"))); if (tbUom.Text.Trim() == "") { ShowWarningMessage("Transportation.TransportPriceListDetail.Uom.Empty"); args.IsValid = false; } } break; case "cvUnitPrice": try { Convert.ToDecimal(args.Value); } catch (Exception) { ShowWarningMessage("Transportation.TransportPriceListDetail.UnitPrice.Error"); args.IsValid = false; } break; case "cvCurrency": if (TheCurrencyMgr.LoadCurrency(args.Value) == null) { ShowWarningMessage("MasterData.Currency.Code.NotExist", args.Value); args.IsValid = false; } break; case "cvServiceCharge": try { Convert.ToDecimal(args.Value); } catch (Exception) { ShowWarningMessage("Transportation.TransportPriceListDetail.ServiceCharge.Error"); args.IsValid = false; } break; case "cvEndDate": try { if (args.Value.Trim() != "") { DateTime startDate = Convert.ToDateTime(((TextBox)(this.FV_Operation.FindControl("tbStartDate"))).Text.Trim()); if (DateTime.Compare(startDate, Convert.ToDateTime(args.Value)) > 0) { ShowErrorMessage("Transportation.TransportPriceListDetail.TimeCompare"); args.IsValid = false; } } } catch (Exception) { ShowWarningMessage("Common.Date.Error"); args.IsValid = false; } break; case "cvBillingMethod": TextBox tbStartDate = ((TextBox)(this.FV_Operation.FindControl("tbStartDate"))); TextBox tbEndDate = ((TextBox)(this.FV_Operation.FindControl("tbEndDate"))); Controls_TextBox tbItem = ((Controls_TextBox)(this.FV_Operation.FindControl("tbItem"))); com.Sconit.Control.CodeMstrDropDownList ddlBillingMethod = ((com.Sconit.Control.CodeMstrDropDownList)(this.FV_Operation.FindControl("ddlBillingMethod"))); IList <TransportPriceListDetail> transportPriceListDetailList = TheTransportPriceListDetailMgr.CheckOperation(this.TransportPriceListCode, tbStartDate.Text.Trim(), tbEndDate.Text.Trim(), tbItem.Text.Trim(), ddlBillingMethod.SelectedValue); if (transportPriceListDetailList != null && transportPriceListDetailList.Count > 0) { if (transportPriceListDetailList.Count > 1 || transportPriceListDetailList[0].Id.ToString() != this.TransportPriceListDetailId) { ShowWarningMessage("Transportation.TransportPriceListDetail.ExistOperation"); args.IsValid = false; } } break; default: break; } }
protected void createTBill() { TransportationOrder to = TheTransportationOrderMgr.LoadTransportationOrder(OrderNo); if (to.Status == "In-Process") { TransportationActBill tb = new TransportationActBill(); tb.BillAddress = TheBillAddressMgr.LoadBillAddress(((Controls_TextBox)(this.FV_Order.FindControl("tbCarrierBillAddress"))).Text); tb.Currency = TheCurrencyMgr.LoadCurrency("RMB"); tb.Status = "Create"; tb.IsIncludeTax = false; tb.OrderNo = this.OrderNo; tb.TransType = "Transportation"; tb.EffectiveDate = DateTime.Now; tb.CreateDate = DateTime.Now; tb.CreateUser = CurrentUser; tb.LastModifyUser = CurrentUser; tb.LastModifyDate = DateTime.Now; tb.IsProvisionalEstimate = false; string carrier = string.Empty; tb.PricingMethod = ((com.Sconit.Control.CodeMstrDropDownList)(this.FV_Order.FindControl("ddlPricingMethod"))).SelectedValue; carrier = ((Controls_TextBox)(this.FV_Order.FindControl("tbCarrier"))).Text + "WL"; string vchtype = ((DropDownList)(this.FV_Order.FindControl("ddlType"))).SelectedValue; int shipto = (TheTransportationOrderMgr.LoadTransportationOrder(this.OrderNo)).TransportationRoute.ShipTo.Id; int shipfrom = (TheTransportationOrderMgr.LoadTransportationOrder(this.OrderNo)).TransportationRoute.ShipFrom.Id; DataSet ds = SqlHelper.ExecuteDataset(connstring, CommandType.Text, "select id from TPriceListDet where Tpricelist='" + carrier + "' and startdate<'" + to.CreateDate.ToShortDateString() + "' and enddate >'" + to.CreateDate.ToShortDateString() + "' and currency='RMB' and pricingmethod='" + tb.PricingMethod + "' and vehicletype='" + vchtype + "' and shipto='" + shipto + "' and shipfrom='" + shipfrom + "' "); if (ds.Tables[0].Rows.Count == 0) { throw new BusinessErrorException("没有找到该类型的价格单"); } int _id = Convert.ToInt32(ds.Tables[0].Rows[0][0]); tb.PriceListDetail = TheTransportPriceListDetailMgr.LoadTransportPriceListDetail(_id); tb.PriceList = TheTransportPriceListMgr.LoadTransportPriceList(carrier); tb.UnitPrice = tb.PriceListDetail.UnitPrice; tb.ShipFrom = tb.PriceListDetail.ShipFrom; tb.ShipTo = tb.PriceListDetail.ShipTo; tb.VehicleType = tb.PriceListDetail.VehicleType; if (tb.PricingMethod != "SHIPT") { decimal qty = 0; foreach (DataRow dr in ds_ip.Tables[0].Rows) { qty += Convert.ToDecimal((TheInProcessLocationMgr.LoadInProcessLocation(dr["ipno"].ToString())).CompleteLatency); } tb.BillQty = qty; tb.BilledQty = 0; if (qty < tb.PriceListDetail.MinVolume) { tb.BillAmount = tb.PriceListDetail.MinVolume * tb.UnitPrice; } else { tb.BillAmount = qty * tb.UnitPrice; } tb.BilledAmount = 0; } else { tb.BillQty = 1; tb.BilledQty = 0; tb.BillAmount = tb.PriceListDetail.UnitPrice; tb.BilledAmount = 0; } TheTransportationActBillMgr.CreateTransportationActBill(tb); } else { return; } }