private void btnSave_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(txtCarNum.Text)) { MessageBoxEx.Show("请填写车牌号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } CmcsLMYB entity = commonDAO.SelfDber.Get <CmcsLMYB>(this.transportId); if (entity != null) { string where = string.Format(" where LMYBId='{0}'", entity.Id); List <CmcsLMYBDetail> list = commonDAO.SelfDber.Entities <CmcsLMYBDetail>(where); if (list.Where(t => t.CarNumber == txtCarNum.Text && t.IsFinish != "已完成").Count() > 0) { MessageBoxEx.Show("调运明细中车号重复!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } CmcsLMYBDetail detail = new CmcsLMYBDetail(); detail.LMYBId = entity.Id; detail.CarNumber = txtCarNum.Text; detail.TicketWeight = Convert.ToDecimal(txtTicketQty.Text); commonDAO.SelfDber.Insert <CmcsLMYBDetail>(detail); entity.CoalNumber = entity.CoalNumber + detail.TicketWeight; entity.TransportNumber += 1; commonDAO.SelfDber.Update <CmcsLMYB>(entity); this.DialogResult = DialogResult.OK; this.Close(); } }
/// <summary> /// 绑定成品仓 /// </summary> private void LoadUnLoadArea() { IList <FulCoalPot> coalPotlist = CommonDAO.GetInstance().SelfDber.Entities <FulCoalPot>("where SalesOrderId=:SalesOrderId", new { SalesOrderId = this.SalesOrderId }); if (coalPotlist == null || coalPotlist.Count == 0) { coalPotlist = CommonDAO.GetInstance().SelfDber.Entities <FulCoalPot>("where PotName like '%成品仓%'"); } foreach (FulCoalPot item in coalPotlist) { this.cmbShippSpace.Items.Add(new ComboBoxItem(item.Id, item.PotName)); } CmcsLMYB lmyb = CommonDAO.GetInstance().SelfDber.Get <CmcsLMYB>(this.LmybId); if (lmyb != null && !string.IsNullOrEmpty(lmyb.StorageName)) { string[] StorageNames = lmyb.StorageName.Split('|'); string[] StorageIds = lmyb.StorageId.Split('|'); if (StorageNames.Length == StorageIds.Length) { for (int i = 0; i < StorageNames.Length; i++) { this.cmbShippSpace.Items.Add(new ComboBoxItem(StorageIds[i], StorageNames[i])); } } } this.cmbShippSpace.SelectedIndex = 0; }
/// <summary> /// 根据来煤预报生成出场煤运输排队记录,同时生成批次信息 /// </summary> /// <param name="autotruck"></param> /// <param name="transportsales"></param> /// <param name="supplyReceive"></param> /// <param name="company"></param> /// <param name="fuelKind"></param> /// <param name="inFactoryTime"></param> /// <param name="remark"></param> /// <param name="place"></param> /// <param name="loadarea"></param> /// <returns></returns> public bool JoinQueueSaleFuelTransport(CmcsAutotruck autotruck, CmcsLMYBDetail lmybdetail, DateTime inFactoryTime) { CmcsLMYB lmyb = lmybdetail.TheLMYB; if (lmyb == null) { return(false); } eTransportType transportType; Enum.TryParse(lmyb.InFactoryType, out transportType); CmcsSaleFuelTransport transport = new CmcsSaleFuelTransport { SerialNumber = carTransportDAO.CreateNewTransportSerialNumber(transportType, inFactoryTime), AutotruckId = autotruck.Id, CarNumber = autotruck.CarNumber, TransportSalesNum = lmyb.YbNum, TransportSalesId = lmybdetail.Id, TransportCompanyId = lmyb.TransportCompanyId, TransportNo = "", SupplierId = lmyb.TheFuelSupplier != null ? lmyb.TheFuelSupplier.Id : "", InFactoryTime = inFactoryTime, IsFinish = 0, IsUse = 1, StepName = eTruckInFactoryStep.入厂.ToString(), LoadArea = lmybdetail.StorageName, Remark = "根据来煤预报自动生成" }; //生成批次数据 CmcsInFactoryBatch inOutBatch = carTransportDAO.GCQCInFactoryBatchBySaleFuelTransport(transport, null); if (inOutBatch != null) { if (SelfDber.Insert(transport) > 0) { // 插入未完成运输记录 return(SelfDber.Insert(new CmcsUnFinishTransport { TransportId = transport.Id, CarType = lmyb.InFactoryType, AutotruckId = autotruck.Id, PrevPlace = CommonAppConfig.GetInstance().AppIdentifier, }) > 0); } } //if (SelfDber.Insert(transport) > 0) //{ // // 插入未完成运输记录 // return SelfDber.Insert(new CmcsUnFinishTransport // { // TransportId = transport.Id, // CarType = eCarType.销售煤.ToString(), // AutotruckId = autotruck.Id, // PrevPlace = place, // }) > 0; //} return(false); }
private void FrmBuyFuelForecast_Select_KeyUp(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Escape) { this.Output = null; this.DialogResult = DialogResult.Cancel; this.Close(); } }
/// <summary> /// 根据来煤预报生成入厂煤运输排队记录,同时生成批次信息以及采制化三级编码 /// </summary> /// <param name="autotruck">车辆信息</param> /// <param name="lmyb">来煤预报</param> /// <param name="inFactoryTime">入厂时间</param> /// <returns></returns> public bool JoinQueueBuyFuelTransport(CmcsAutotruck autotruck, CmcsLMYBDetail lmybdetail, DateTime inFactoryTime) { CmcsLMYB lmyb = lmybdetail.TheLMYB; if (lmyb == null) { return(false); } eTransportType transportType; Enum.TryParse(lmyb.InFactoryType, out transportType); CmcsBuyFuelTransport transport = new CmcsBuyFuelTransport { SerialNumber = carTransportDAO.CreateNewTransportSerialNumber(transportType, inFactoryTime), AutotruckId = autotruck.Id, CarNumber = autotruck.CarNumber, SupplierId = lmyb.SupplierId, SupplierName = lmyb.SupplierName, InFactoryPlace = CommonAppConfig.GetInstance().AppIdentifier, MineId = lmyb.MineId, MineName = lmyb.MineName, TransportCompanyId = lmyb.TransportCompanyId, FuelKindId = lmyb.FuelKindId, FuelKindName = lmyb.FuelKindName, TicketWeight = lmybdetail.TicketWeight, InFactoryTime = inFactoryTime, IsFinish = 0, IsUse = 1, SamplingType = eSamplingType.机械采样.ToString(), InFactoryType = lmyb.InFactoryType, StepName = eTruckInFactoryStep.入厂.ToString(), Remark = "根据来煤预报自动生成", LMYBDetailId = lmybdetail.Id }; // 生成批次以及采制化三级编码数据 CmcsInFactoryBatch inFactoryBatch = carTransportDAO.GCQCInFactoryBatchByBuyFuelTransport(transport, lmyb); if (inFactoryBatch != null) { if (SelfDber.Insert(transport) > 0) { // 插入未完成运输记录 return(SelfDber.Insert(new CmcsUnFinishTransport { TransportId = transport.Id, CarType = eCarType.入场煤.ToString(), AutotruckId = autotruck.Id, PrevPlace = CommonAppConfig.GetInstance().AppIdentifier, }) > 0); } } return(false); }
public FrmTransportPlan_Confirm(string transportId) { InitializeComponent(); this.transportId = transportId; CmcsLMYB entity = commonDAO.SelfDber.Get <CmcsLMYB>(this.transportId); if (entity != null) { txtYBNum.Text = entity.YbNum; } }
/// <summary> /// 生成出场煤运输排队记录,同时生成批次信息 /// </summary> /// <param name="autotruck"></param> /// <param name="transportsales"></param> /// <param name="supplyReceive"></param> /// <param name="company"></param> /// <param name="fuelKind"></param> /// <param name="inFactoryTime"></param> /// <param name="remark"></param> /// <param name="place"></param> /// <param name="loadarea"></param> /// <returns></returns> public bool JoinQueueSaleFuelTransport(CmcsAutotruck autotruck, CmcsLMYB transportsales, CmcsSupplier supplyReceive, CmcsTransportCompany company, CmcsFuelKind fuelKind, DateTime inFactoryTime, string remark, string place, string loadarea, string transportType, string sampleType, Tuple <string, string> CPC, Tuple <string, string> storageName) { eTransportType TransportType; Enum.TryParse(transportType, out TransportType); CmcsSaleFuelTransport transport = new CmcsSaleFuelTransport { SerialNumber = carTransportDAO.CreateNewTransportSerialNumber(TransportType, inFactoryTime), AutotruckId = autotruck.Id, CarNumber = autotruck.CarNumber, TransportSalesNum = transportsales != null ? transportsales.YbNum : "", TransportSalesId = transportsales != null ? transportsales.Id : "", TransportCompanyName = company.Name, TransportCompanyId = company.Id, TransportNo = transportsales != null ? transportsales.TransportNo : "", SupplierId = supplyReceive.Id, SupplierName = supplyReceive.Name, InFactoryTime = inFactoryTime, IsFinish = 0, IsUse = 1, StepName = eTruckInFactoryStep.入厂.ToString(), LoadArea = loadarea, Remark = remark, FuelKindId = fuelKind != null ? fuelKind.Id : "", OutFactoryType = transportType, SampleType = sampleType, CPCId = CPC.Item1, CPCName = CPC.Item2, StorageId = storageName.Item1, StorageName = storageName.Item2, LMYBId = transportsales != null ? transportsales.Id : "" }; //生成批次数据 CmcsInFactoryBatch inOutBatch = carTransportDAO.GCQCInFactoryBatchBySaleFuelTransport(transport, transportsales); if (inOutBatch != null) { if (SelfDber.Insert(transport) > 0) { // 插入未完成运输记录 return(SelfDber.Insert(new CmcsUnFinishTransport { TransportId = transport.Id, CarType = transportType.ToString(), AutotruckId = autotruck.Id, PrevPlace = place, }) > 0); } } return(false); }
private void btnSelectForecast_SaleFuel_Click(object sender, EventArgs e) { FrmSaleFuelForecast_Select frm = new FrmSaleFuelForecast_Select(); if (frm.ShowDialog() == DialogResult.OK) { cmcsTransportSales = frm.Output; txt_SupplierName.Text = frm.Output.TheFuelSupplier != null ? frm.Output.TheFuelSupplier.Name : ""; txt_TransportCompanyName.Text = Dbers.GetInstance().SelfDber.Get <CmcsTransportCompany>(frm.Output.TransportCompanyId).Name; txt_TransportNo.Text = frm.Output.TransportNo; txt_TransportSalesNum.Text = frm.Output.YbNum; } }
void Return() { GridRow gridRow = superGridControl1.PrimaryGrid.ActiveRow as GridRow; if (gridRow == null) { return; } this.Output = (gridRow.DataItem as CmcsLMYB); this.DialogResult = DialogResult.OK; this.Close(); }
private void timer1_Tick(object sender, EventArgs e) { timer1.Stop(); try { CmcsConfirm confirm = CommonDAO.GetInstance().GetConfirm(this.CurrentAutotruckId, eConfirmType.来煤预报.ToString()); if (confirm != null && !string.IsNullOrEmpty(confirm.ResultId)) { this.Output = CommonDAO.GetInstance().SelfDber.Get <CmcsLMYB>(confirm.ResultId); this.DialogResult = DialogResult.OK; this.Close(); } } catch { } timer1.Start(); }
private void FrmSaleFuelTransport_Oper_Load(object sender, EventArgs e) { LoadFuelkind(cmbFuelName_SaleFuel); if (!String.IsNullOrEmpty(id)) { this.cmcsSaleFuelTransport = Dbers.GetInstance().SelfDber.Get <CmcsSaleFuelTransport>(this.id); if (!String.IsNullOrEmpty(this.cmcsSaleFuelTransport.TransportSalesId)) { cmcsTransportSales = Dbers.GetInstance().SelfDber.Get <CmcsLMYB>(this.cmcsSaleFuelTransport.TransportSalesId); } txt_SerialNumber.Text = cmcsSaleFuelTransport.SerialNumber; txt_CarNumber.Text = cmcsSaleFuelTransport.CarNumber; txt_TransportSalesNum.Text = cmcsSaleFuelTransport.TransportSalesNum; txt_TransportNo.Text = cmcsSaleFuelTransport.TransportNo; txt_LoadArea.Text = cmcsSaleFuelTransport.LoadArea; cmbFuelName_SaleFuel.SelectedValue = cmcsSaleFuelTransport.FuelKindId; CmcsSupplier supplier = Dbers.GetInstance().SelfDber.Get <CmcsSupplier>(cmcsSaleFuelTransport.SupplierId); if (supplier != null) { txt_SupplierName.Text = supplier.Name; } CmcsTransportCompany company = Dbers.GetInstance().SelfDber.Get <CmcsTransportCompany>(cmcsSaleFuelTransport.TransportCompanyId); if (company != null) { txt_TransportCompanyName.Text = company.Name; } dbi_GrossWeight.Value = (double)cmcsSaleFuelTransport.GrossWeight; dbi_TareWeight.Value = (double)cmcsSaleFuelTransport.TareWeight; dbi_SuttleWeight.Value = (double)cmcsSaleFuelTransport.SuttleWeight; txt_InFactoryTime.Text = cmcsSaleFuelTransport.InFactoryTime.Year == 1 ? "" : cmcsSaleFuelTransport.InFactoryTime.ToString(); txt_GrossTime.Text = cmcsSaleFuelTransport.GrossTime.Year == 1 ? "" : cmcsSaleFuelTransport.GrossTime.ToString(); txt_TareTime.Text = cmcsSaleFuelTransport.TareTime.Year == 1 ? "" : cmcsSaleFuelTransport.TareTime.ToString(); txt_OutFactoryTime.Text = cmcsSaleFuelTransport.OutFactoryTime.Year == 1 ? "" : cmcsSaleFuelTransport.OutFactoryTime.ToString(); txt_LoadTime.Text = cmcsSaleFuelTransport.LoadTime.Year == 1 ? "" : cmcsSaleFuelTransport.LoadTime.ToString(); txt_Remark.Text = cmcsSaleFuelTransport.Remark; chb_IsFinish.Checked = (cmcsSaleFuelTransport.IsFinish == 1); chb_IsUse.Checked = (cmcsSaleFuelTransport.IsUse == 1); } if (!edit) { btnSubmit.Enabled = false; CMCS.CarTransport.Queue.Utilities.Helper.ControlReadOnly(panelEx2); } }
/// <summary> /// 打印编码 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void btnCarDeduction_Click(object sender, EventArgs e) { GridButtonXEditControl btn = sender as GridButtonXEditControl; if (btn == null) { return; } CmcsLMYB entity = btn.EditorCell.GridRow.DataItem as CmcsLMYB; if (entity == null) { return; } new FrmTransportPlan_Confirm(entity.Id).ShowDialog(); BindData(); }
private void superGridControl_DataBindingComplete(object sender, GridDataBindingCompleteEventArgs e) { foreach (GridRow gridRow in e.GridPanel.Rows) { try { CmcsLMYB entity = gridRow.DataItem as CmcsLMYB; if (entity == null) { return; } // 填充有效状态 gridRow.Cells["clmTransportCompanyName"].Value = entity.TheTransportCompany.Name; } catch (Exception ex) { Log4Neter.Error("出场煤调运加载", ex); } } }
private void superGridControl1_DataBindingComplete(object sender, DevComponents.DotNetBar.SuperGrid.GridDataBindingCompleteEventArgs e) { foreach (GridRow item in e.GridPanel.Rows) { try { CmcsLMYB CmcsLMYB = item.DataItem as CmcsLMYB; CmcsSupplier fuelSupplier = Dbers.GetInstance().SelfDber.Get <CmcsSupplier>(CmcsLMYB.FuelSupplierId); if (fuelSupplier != null) { item.Cells["cellFuelSupplierName"].Value = fuelSupplier != null ? fuelSupplier.Name : ""; } item.Cells["cellInFactoryTime"].Value = CmcsLMYB.InFactoryTime.ToString("yyyy/MM/dd"); item.Cells["cellCoalNumber"].Value = CmcsLMYB.CoalNumber.ToString("f2"); } catch (Exception) { } } }
/// <summary> /// 生成入厂煤运输排队记录,同时生成批次信息以及采制化三级编码 /// </summary> /// <param name="autotruck"></param> /// <param name="supplier"></param> /// <param name="mine"></param> /// <param name="transportCompany"></param> /// <param name="fuelKind"></param> /// <param name="ticketWeight"></param> /// <param name="inFactoryTime"></param> /// <param name="remark"></param> /// <param name="samplingType"></param> /// <param name="lmyb"></param> /// <param name="inFactoryType"></param> /// <returns></returns> public bool JoinQueueBuyFuelTransport(CmcsAutotruck autotruck, CmcsSupplier supplier, CmcsMine mine, CmcsTransportCompany transportCompany, CmcsFuelKind fuelKind, decimal ticketWeight, DateTime inFactoryTime, string remark, string samplingType, CmcsLMYB lmyb, string inFactoryType) { eTransportType TransportType; Enum.TryParse(inFactoryType, out TransportType); CmcsBuyFuelTransport transport = new CmcsBuyFuelTransport { SerialNumber = carTransportDAO.CreateNewTransportSerialNumber(TransportType, inFactoryTime), AutotruckId = autotruck.Id, CarNumber = autotruck.CarNumber, SupplierId = supplier.Id, SupplierName = supplier.Name, InFactoryPlace = CommonAppConfig.GetInstance().AppIdentifier, MineId = mine.Id, MineName = mine.Name, TransportCompanyId = (transportCompany == null ? null : transportCompany.Id), FuelKindId = fuelKind.Id, FuelKindName = fuelKind.FuelName, TicketWeight = ticketWeight, InFactoryTime = inFactoryTime, IsFinish = 0, IsUse = 1, SamplingType = samplingType, InFactoryType = inFactoryType.ToString(), StepName = eTruckInFactoryStep.入厂.ToString(), Remark = remark, LMYBId = lmyb != null ? lmyb.Id : "", YbNum = lmyb != null ? lmyb.YbNum : "" }; // 生成批次以及采制化三级编码数据 CmcsInFactoryBatch inFactoryBatch = carTransportDAO.GCQCInFactoryBatchByBuyFuelTransport(transport, lmyb); if (inFactoryBatch != null) { if (SelfDber.Insert(transport) > 0) { // 插入未完成运输记录 return(SelfDber.Insert(new CmcsUnFinishTransport { TransportId = transport.Id, CarType = inFactoryType.ToString(), AutotruckId = autotruck.Id, PrevPlace = CommonAppConfig.GetInstance().AppIdentifier, }) > 0); } } return(false); }
/// <summary> /// 根据出场煤运输记录生成批次并返回。 /// 根据入场时间(实际到厂时间)、供煤单位、煤种生成,已存在则不创建 /// </summary> /// <param name="buyFuelTransport"></param> /// <returns></returns> public CmcsInFactoryBatch GCQCInFactoryBatchBySaleFuelTransport(CmcsSaleFuelTransport buyFuelTransport, CmcsLMYB lmyb) { bool isSuccess = false; CmcsInFactoryBatch entity = HasOutBatch(buyFuelTransport); if (entity == null) { //记录运输方式Id CodeContent transporttype = new CodeContent(); List <CodeContent> par = commonDAO.GetCodeContentByKind("运输方式"); if (par != null) { transporttype = par.Where(a => a.Content == "汽车").FirstOrDefault(); } entity = new CmcsInFactoryBatch() { Batch = CreateNewBatchNumber("QC", buyFuelTransport.InFactoryTime), BatchType = "汽车", TransportTypeId = transporttype != null ? transporttype.Id : "", TransportTypeName = "汽车", FactArriveDate = buyFuelTransport.InFactoryTime, FuelKindId = buyFuelTransport.FuelKindId, FuelSupplierId = buyFuelTransport.SupplierId, SentSupplierId = buyFuelTransport.SupplierId, RunDate = buyFuelTransport.InFactoryTime, TransportCompanyId = buyFuelTransport.TransportCompanyId, Remark = "由汽车煤智能化自动创建", IsFinish = 0, IsCheck = 0, IsCTAutoCreate = 1, IsScale = 0, BACKBATCHDATE = buyFuelTransport.TareTime.Year > 2000 ? buyFuelTransport.TareTime : buyFuelTransport.InFactoryTime, InFactoryType = buyFuelTransport.OutFactoryType }; if (lmyb != null) { entity.LMYBID = lmyb.Id; entity.PlanArriveDate = lmyb.InFactoryTime; entity.QCal = lmyb.Q; entity.Stad = lmyb.S; entity.Vad = lmyb.V; } // 创建新批次 isSuccess = SelfDber.Insert(entity) > 0; } if (buyFuelTransport.SampleType != eSamplingType.人工采样.ToString()) { // 生成采制化数据记录 CmcsRCSampling rCSampling = commonDAO.GCSamplingMakeAssay(entity, buyFuelTransport.SampleType, "由汽车煤智能化自动创建", eAssayType.级编码化验); buyFuelTransport.SamplingId = rCSampling.Id; } buyFuelTransport.InOutBatchId = entity.Id; return(entity); }
public UCtrlBuyFuelForecast(CmcsLMYB lMYB) { InitializeComponent(); this.lMYB = lMYB; }
void uCtrlBuyFuelForecast_OnSelected(CmcsLMYB lMYB) { this.Output = lMYB; this.DialogResult = DialogResult.OK; }