/// <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); }
/// <summary> /// 保存销售煤运输记录 /// </summary> /// <param name="transportId"></param> /// <param name="weight">重量</param> /// <param name="place"></param> /// <returns></returns> public bool SaveSaleFuelTransport(string transportId, decimal weight, DateTime dt, string place) { CmcsSaleFuelTransport transport = SelfDber.Get <CmcsSaleFuelTransport>(transportId); if (transport == null) { return(false); } transport.IsSynch = "0"; if (transport.TareWeight == 0 && transport.GrossWeight != 0) { transport.StepName = eTruckInFactoryStep.装载.ToString(); transport.LoadArea = place; transport.Loader = ""; transport.LoadTime = dt; commonDAO.InsertWaitForHandleEvent("汽车智能化_同步销售煤运输记录到批次", transport.Id); } else { return(false); } return(SelfDber.Update(transport) > 0); }
private void dataGridViewX1_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == -1 || e.RowIndex == -1) { return; } CmcsSaleFuelTransport entity = Dbers.GetInstance().SelfDber.Get <CmcsSaleFuelTransport>(superGridControl1.PrimaryGrid.GetCell(e.ColumnIndex, superGridControl1.PrimaryGrid.Columns["clmId"].ColumnIndex).Value.ToString()); if (entity == null) { return; } switch (superGridControl1.PrimaryGrid.Columns[e.ColumnIndex].Name) { case "clmDelete": // 查询正在使用该记录的车数 if (MessageBoxEx.Show("确定要删除该记录?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { Dbers.GetInstance().SelfDber.Delete <CmcsSaleFuelTransport>(entity.Id); BindData(); } else { MessageBoxEx.Show("该记录正在使用中,禁止删除!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } break; } }
private void superGridControl1_DataBindingComplete(object sender, DevComponents.DotNetBar.SuperGrid.GridDataBindingCompleteEventArgs e) { foreach (GridRow gridRow in e.GridPanel.Rows) { CmcsSaleFuelTransport entity = gridRow.DataItem as CmcsSaleFuelTransport; if (entity == null) { return; } CmcsSupplier supplier = Dbers.GetInstance().SelfDber.Get <CmcsSupplier>(entity.SupplierId); if (supplier != null) { gridRow.Cells["clmSupplier"].Value = supplier.Name; } CmcsFuelKind fuelkind = Dbers.GetInstance().SelfDber.Get <CmcsFuelKind>(entity.FuelKindId); if (fuelkind != null) { gridRow.Cells["clmFuelKind"].Value = fuelkind.FuelName; } CmcsTransportCompany company = Dbers.GetInstance().SelfDber.Get <CmcsTransportCompany>(entity.TransportCompanyId); if (company != null) { gridRow.Cells["clmTransportCompany"].Value = company.Name; } if (entity.SupplierId == "合计") { gridRow.Cells["clmSupplier"].Value = "合计"; gridRow.Cells["clmFuelKind"].Visible = false; gridRow.Cells["clmTransportCompany"].Visible = false; gridRow.Cells["clmGrossTime"].Visible = false; gridRow.Cells["clmTareTime"].Visible = false; } } }
private void superGridControl1_DataBindingComplete(object sender, GridDataBindingCompleteEventArgs e) { foreach (GridRow item in e.GridPanel.Rows) { try { CmcsSaleFuelTransport cmcsBuyFuelTransport = item.DataItem as CmcsSaleFuelTransport; CmcsFuelKind fk = Dbers.GetInstance().SelfDber.Get <CmcsFuelKind>(cmcsBuyFuelTransport.FuelKindId); item.Cells["FuelKindName"].Value = fk != null ? fk.FuelName : ""; CmcsSupplier sp = Dbers.GetInstance().SelfDber.Get <CmcsSupplier>(cmcsBuyFuelTransport.SupplierId); item.Cells["SupplierName"].Value = sp != null ? sp.Name : ""; CmcsTransportCompany tc = Dbers.GetInstance().SelfDber.Get <CmcsTransportCompany>(cmcsBuyFuelTransport.TransportCompanyId); item.Cells["TransportCompanyName"].Value = tc != null ? tc.Name : ""; item.Cells["cellGrossWeight"].Value = cmcsBuyFuelTransport.GrossWeight.ToString("f2"); item.Cells["cellTareWeight"].Value = cmcsBuyFuelTransport.TareWeight.ToString("f2"); item.Cells["cellSuttleWeight"].Value = cmcsBuyFuelTransport.SuttleWeight.ToString("f2"); if (cmcsBuyFuelTransport.CarNumber != "总计") { item.Cells["cellInFactoryTime"].Value = cmcsBuyFuelTransport.InFactoryTime.ToShortDateString(); } } catch (Exception) { } } }
public bool JoinQueueSaleFuelTransport(CmcsAutotruck autotruck, CmcsSupplier supplier, CmcsTransportCompany transportCompany, CmcsFuelKind fuelKind, DateTime inFactoryTime, string remark, string place, string loadarea) { CmcsSaleFuelTransport transport = new CmcsSaleFuelTransport { SerialNumber = carTransportDAO.CreateNewTransportSerialNumber(eCarType.销售煤, inFactoryTime), AutotruckId = autotruck.Id, CarNumber = autotruck.CarNumber, TransportCompanyName = transportCompany.Name, TransportCompanyId = transportCompany.Id, SupplierName = supplier.Name, SupplierId = supplier.Id, FuelKindName = fuelKind.Name, FuelKindId = fuelKind.Id, InFactoryTime = inFactoryTime, IsFinish = 0, IsUse = 1, StepName = eTruckInFactoryStep.入厂.ToString(), LoadArea = loadarea, Remark = remark }; if (SelfDber.Insert(transport) > 0) { // 插入未完成运输记录 return(SelfDber.Insert(new CmcsUnFinishTransport { TransportId = transport.Id, CarType = eCarType.销售煤.ToString(), AutotruckId = autotruck.Id, PrevPlace = place, }) > 0); } return(false); }
public bool JoinQueueSaleFuelTransport(CmcsAutotruck autotruck, CmcsTransportSales transportsales, DateTime inFactoryTime, string remark, string place, string loadarea) { CmcsSaleFuelTransport transport = new CmcsSaleFuelTransport { SerialNumber = carTransportDAO.CreateNewTransportSerialNumber(eCarType.销售煤, inFactoryTime), AutotruckId = autotruck.Id, CarNumber = autotruck.CarNumber, TransportSalesNum = transportsales.YbNum, TransportSalesId = transportsales.Id, TransportCompanyName = transportsales.TransportCompayName, TransportCompanyId = transportsales.TransportCompayId, TransportNo = transportsales.TransportNo, SupplierName = transportsales.Consignee, SupplierId = transportsales.SaleSorderId, InFactoryTime = inFactoryTime, IsFinish = 0, IsUse = 1, StepName = eTruckInFactoryStep.入厂.ToString(), LoadArea = loadarea, Remark = remark }; 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 superGridControl1_CellMouseDown(object sender, GridCellMouseEventArgs e) { if (e.GridCell.ColumnIndex == -1 || e.GridCell.GridRow.Index == -1) { return; } SuperGridControl sgc = (SuperGridControl)sender; var Cell = sgc.PrimaryGrid.GetCell(e.GridCell.GridRow.Index, 12); string id = Cell != null?Cell.Value.ToString() : ""; CmcsSaleFuelTransport entity = Dbers.GetInstance().SelfDber.Get <CmcsSaleFuelTransport>(id); if (entity == null) { return; } String newid = id.ToString(); switch (sgc.PrimaryGrid.GetCell(e.GridCell.GridRow.Index, e.GridCell.ColumnIndex).NullString) { case "抓拍": break; case "装车线": break; } }
private void FrmSaleFuelTransport_Oper_Load(object sender, EventArgs e) { if (!String.IsNullOrEmpty(id)) { this.cmcsSaleFuelTransport = Dbers.GetInstance().SelfDber.Get <CmcsSaleFuelTransport>(this.id); if (!String.IsNullOrEmpty(this.cmcsSaleFuelTransport.TransportSalesId)) { cmcsTransportSales = Dbers.GetInstance().SelfDber.Get <CmcsTransportSales>(this.cmcsSaleFuelTransport.TransportSalesId); } txt_SerialNumber.Text = cmcsSaleFuelTransport.SerialNumber; txt_CarNumber.Text = cmcsSaleFuelTransport.CarNumber; txt_TransportSalesNum.Text = cmcsSaleFuelTransport.TransportSalesNum; txt_TransportNo.Text = cmcsSaleFuelTransport.TransportNo; txt_SupplierName.Text = cmcsSaleFuelTransport.SupplierName; txt_LoadArea.Text = cmcsSaleFuelTransport.LoadArea; txt_TransportCompanyName.Text = cmcsSaleFuelTransport.TransportCompanyName; 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; HelperUtil.ControlReadOnly(panelEx2, true); } }
/// <summary> /// 保存出厂煤运输记录 /// </summary> /// <param name="transportId"></param> /// <param name="place"></param> /// <returns></returns> public bool SaveSaleFuelTransport(string transportId, DateTime dt, string place) { CmcsSaleFuelTransport transport = SelfDber.Get <CmcsSaleFuelTransport>(transportId); if (transport == null) { return(false); } transport.IsSynch = "0"; transport.StepName = eTruckInFactoryStep.采样.ToString(); transport.SamplingTime = dt; transport.SamplePlace = place; CmcsRCSampling sample = Dbers.GetInstance().SelfDber.Get <CmcsRCSampling>(transport.SamplingId); if (sample != null) { if (sample.SamplingDate.Year < 2000) { sample.SamplingDate = DateTime.Now; } if (string.IsNullOrEmpty(sample.CARNUMS) || !sample.CARNUMS.Contains(transport.CarNumber)) { sample.CARNUMS += "," + transport.CarNumber; sample.TOTALNUM++; if (sample.CARNUMS.StartsWith(",")) { sample.CARNUMS.Remove(0, 1); } } Dbers.GetInstance().SelfDber.Update(sample); } return(SelfDber.Update(transport) > 0); }
/// <summary> /// 保存重量 /// </summary> /// <param name="transport"></param> /// <returns></returns> public bool SaveSaleFuelTransport(CmcsSaleFuelTransport transport) { if (transport == null) { return(false); } transport.IsSynch = "0"; // 生成批次以及采制化三级编码数据 CmcsInFactoryBatch inFactoryBatch = CarTransportDAO.GetInstance().GCQCInFactoryBatchBySaleFuelTransport(transport, null); if (transport.GrossWeight > 0) { if (transport.GrossTime.Year < 2000) { transport.GrossTime = DateTime.Now; transport.InFactoryTime = DateTime.Now; } if (transport.TareWeight > 0) { if (transport.TareTime.Year < 2000) { transport.TareTime = DateTime.Now; } if (transport.OutFactoryTime.Year < 2000) { transport.OutFactoryTime = DateTime.Now; } transport.SuttleWeight = transport.GrossWeight - transport.TareWeight; // 回皮即完结 transport.IsFinish = 1; if (SelfDber.Get <CmcsSaleFuelTransport>(transport.Id) == null) { if (SelfDber.Insert(transport) > 0) { carTransportDAO.DelUnFinishTransport(transport.Id); commonDAO.InsertWaitForHandleEvent("汽车智能化_同步销售煤运输记录到批次", transport.Id); commonDAO.InsertWaitForHandleEvent("汽车智能化_删除未完成运输记录", transport.Id); return(true); } } else { if (SelfDber.Update(transport) > 0) { carTransportDAO.DelUnFinishTransport(transport.Id); commonDAO.InsertWaitForHandleEvent("汽车智能化_同步销售煤运输记录到批次", transport.Id); commonDAO.InsertWaitForHandleEvent("汽车智能化_删除未完成运输记录", transport.Id); return(true); } } } } if (transport.TareTime.Day != transport.InFactoryTime.Day) { carTransportDAO.GCQCInFactoryBatchBySaleFuelTransport(transport, null); } return(SelfDber.Update(transport) > 0); }
private void superGridControl1_DataBindingComplete(object sender, DevComponents.DotNetBar.SuperGrid.GridDataBindingCompleteEventArgs e) { foreach (GridRow gridRow in e.GridPanel.Rows) { CmcsSaleFuelTransport cmcsSaleFuelTransport = gridRow.DataItem as CmcsSaleFuelTransport; if (cmcsSaleFuelTransport == null) { break; } gridRow.Cells["clmIsUse"].Value = ((cmcsSaleFuelTransport.IsUse == 1) ? "是" : "否"); gridRow.Cells["SupplierName"].Value = cmcsSaleFuelTransport.TheSupplier != null ? cmcsSaleFuelTransport.TheSupplier.Name : ""; CmcsTransportCompany cmcsTransportCompany = Dbers.GetInstance().SelfDber.Get <CmcsTransportCompany>(cmcsSaleFuelTransport.TransportCompanyId); if (cmcsTransportCompany != null) { gridRow.Cells["TransportCompanyName"].Value = cmcsTransportCompany.Name; } if (cmcsSaleFuelTransport.GrossWeight > 0 || cmcsSaleFuelTransport.TareWeight > 0) { gridRow.Cells["clmDelete"].Value = ""; } if (cmcsSaleFuelTransport.GrossWeight > 0m && cmcsSaleFuelTransport.TareWeight > 0m) { gridRow.CellStyles.Default.TextColor = System.Drawing.Color.Green; } else if (cmcsSaleFuelTransport.GrossWeight == 0m && cmcsSaleFuelTransport.TareWeight == 0m) { gridRow.CellStyles.Default.TextColor = System.Drawing.Color.Red; } } }
private void superGridControl1_CellMouseDown(object sender, DevComponents.DotNetBar.SuperGrid.GridCellMouseEventArgs e) { CmcsSaleFuelTransport entity = Dbers.GetInstance().SelfDber.Get <CmcsSaleFuelTransport>(superGridControl1.PrimaryGrid.GetCell(e.GridCell.GridRow.Index, superGridControl1.PrimaryGrid.Columns["clmId"].ColumnIndex).Value.ToString()); switch (superGridControl1.PrimaryGrid.Columns[e.GridCell.ColumnIndex].Name) { case "clmShow": FrmSaleFuelTransport_Oper frmShow = new FrmSaleFuelTransport_Oper(entity.Id, eEditMode.查看); if (frmShow.ShowDialog() == DialogResult.OK) { BindData(); } break; case "clmEdit": FrmSaleFuelTransport_Oper frmEdit = new FrmSaleFuelTransport_Oper(entity.Id, eEditMode.修改); if (frmEdit.ShowDialog() == DialogResult.OK) { BindData(); } break; case "clmDelete": // 查询正在使用该记录的车数 if (MessageBoxEx.Show("确定要删除该记录?", "操作提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { Dbers.GetInstance().SelfDber.Delete <CmcsSaleFuelTransport>(entity.Id); //删除临时运输记录 Dbers.GetInstance().SelfDber.DeleteBySQL <CmcsUnFinishTransport>("where TransportId=:TransportId", new { TransportId = entity.Id }); } catch (Exception) { MessageBoxEx.Show("该记录正在使用中,禁止删除!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } BindData(); } break; case "clmPic": if (Dbers.GetInstance().SelfDber.Entities <CmcsTransportPicture>(String.Format(" where TransportId='{0}'", entity.Id)).Count > 0) { FrmTransportPicture frmPic = new FrmTransportPicture(entity.Id, entity.CarNumber); if (frmPic.ShowDialog() == DialogResult.OK) { BindData(); } } else { MessageBoxEx.Show("暂无抓拍图片!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } break; } }
/// <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); }
private void FrmTransport_Confirm_Shown(object sender, EventArgs e) { if (string.IsNullOrEmpty(this.transportId)) { return; } if (this.carType == eCarType.入场煤.ToString()) { CmcsBuyFuelTransport transport = commonDAO.SelfDber.Get <CmcsBuyFuelTransport>(this.transportId); if (transport != null) { this.autotruckId = transport.AutotruckId; txtSerialNumber.Text = transport.SerialNumber; txtCarNumber.Text = transport.CarNumber; txtInFactoryTime.Text = transport.InFactoryTime.ToString("yyyy-MM-dd HH:mm"); } } else if (this.carType == eCarType.销售煤.ToString()) { CmcsSaleFuelTransport transport = commonDAO.SelfDber.Get <CmcsSaleFuelTransport>(this.transportId); if (transport != null) { this.autotruckId = transport.AutotruckId; txtSerialNumber.Text = transport.SerialNumber; txtCarNumber.Text = transport.CarNumber; txtInFactoryTime.Text = transport.InFactoryTime.ToString("yyyy-MM-dd HH:mm"); } } else if (this.carType == eCarType.其他物资.ToString()) { CmcsGoodsTransport transport = commonDAO.SelfDber.Get <CmcsGoodsTransport>(this.transportId); if (transport != null) { this.autotruckId = transport.AutotruckId; txtSerialNumber.Text = transport.SerialNumber; txtCarNumber.Text = transport.CarNumber; txtInFactoryTime.Text = transport.InFactoryTime.ToString("yyyy-MM-dd HH:mm"); } } else if (this.carType == eCarType.来访车辆.ToString()) { CmcsVisitTransport transport = commonDAO.SelfDber.Get <CmcsVisitTransport>(this.transportId); if (transport != null) { this.autotruckId = transport.AutotruckId; txtSerialNumber.Text = transport.SerialNumber; txtCarNumber.Text = transport.CarNumber; txtInFactoryTime.Text = transport.InFactoryTime.ToString("yyyy-MM-dd HH:mm"); } } }
private void btnReportExport_Click(object sender, EventArgs e) { try { FileStream file = new FileStream("计量明细模板.xls", FileMode.Open, FileAccess.Read); HSSFWorkbook hssfworkbook = new HSSFWorkbook(file); HSSFSheet sheetl = (HSSFSheet)hssfworkbook.GetSheet("计量明细"); if (CurrExportData.Count == 0) { MessageBox.Show("请先查询数据"); return; } if (folderBrowserDialog.ShowDialog() != DialogResult.OK) { return; } for (int i = 0; i < CurrExportData.Count; i++) { CmcsSaleFuelTransport entity = CurrExportData[i]; Mysheet1(sheetl, i + 1, 0, entity.SerialNumber.ToString()); Mysheet1(sheetl, i + 1, 1, entity.CarNumber); Mysheet1(sheetl, i + 1, 2, entity.SupplierName); Mysheet1(sheetl, i + 1, 3, entity.FuelKindName); Mysheet1(sheetl, i + 1, 4, entity.GrossWeight.ToString()); Mysheet1(sheetl, i + 1, 5, entity.TareWeight.ToString()); Mysheet1(sheetl, i + 1, 6, "0"); Mysheet1(sheetl, i + 1, 7, entity.SuttleWeight.ToString()); Mysheet1(sheetl, i + 1, 8, entity.TareTime.Year < 2000 ? "" : entity.TareTime.ToString("yyyy-MM-dd HH:mm:ss")); } #region 合计 Mysheet1(sheetl, CurrExportData.Count + 1, 0, "合计"); Mysheet1(sheetl, CurrExportData.Count + 1, 1, CurrExportData.Count + "车"); Mysheet1(sheetl, CurrExportData.Count + 1, 4, Math.Round(CurrExportData.Sum(a => a.GrossWeight), 2).ToString()); Mysheet1(sheetl, CurrExportData.Count + 1, 5, Math.Round(CurrExportData.Sum(a => a.TareWeight), 2).ToString()); Mysheet1(sheetl, CurrExportData.Count + 1, 6, "0"); Mysheet1(sheetl, CurrExportData.Count + 1, 7, Math.Round(CurrExportData.Sum(a => a.SuttleWeight), 2).ToString()); #endregion sheetl.ForceFormulaRecalculation = true; string fileName = DateTime.Now.ToString("yyyyMMddHHmmss") + "计量明细.xls"; GC.Collect(); FileStream fs = File.OpenWrite(folderBrowserDialog.SelectedPath + "\\" + fileName); hssfworkbook.Write(fs); //向打开的这个xls文件中写入表并保存。 fs.Close(); MessageBox.Show("导出成功"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void superGridControl1_DataBindingComplete(object sender, DevComponents.DotNetBar.SuperGrid.GridDataBindingCompleteEventArgs e) { foreach (GridRow gridRow in e.GridPanel.Rows) { CmcsSaleFuelTransport entity = gridRow.DataItem as CmcsSaleFuelTransport; if (entity == null) { return; } } }
/// <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); }
/// <summary> /// 保存入厂煤运输记录 /// </summary> /// <param name="transportId"></param> /// <param name="dt"></param> /// <returns></returns> public bool SaveSaleFuelTransport(string transportId, DateTime dt) { CmcsSaleFuelTransport transport = SelfDber.Get <CmcsSaleFuelTransport>(transportId); if (transport == null) { return(false); } transport.StepName = eTruckInFactoryStep.装载.ToString(); transport.LoadTime = dt; return(SelfDber.Update(transport) > 0); }
private void tsmiPrint_Click(object sender, EventArgs e) { GridRow gridRow = superGridControl1.PrimaryGrid.ActiveRow as GridRow; if (gridRow == null) { return; } CmcsSaleFuelTransport entity = gridRow.DataItem as CmcsSaleFuelTransport; FrmSaleFuelPrintWeb frm = new FrmSaleFuelPrintWeb(entity); frm.ShowDialog(); }
public void Print(CmcsSaleFuelTransport buyfueltransport) { _BuyFuelTransport = buyfueltransport; try { this._PrintDocument.Print(); } catch { MessageBoxEx.Show("打印异常,请检查打印机!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } _BuyFuelTransport = null; }
private void superGridControl1_DataBindingComplete(object sender, DevComponents.DotNetBar.SuperGrid.GridDataBindingCompleteEventArgs e) { foreach (GridRow gridRow in e.GridPanel.Rows) { CmcsSaleFuelTransport entity = gridRow.DataItem as CmcsSaleFuelTransport; if (entity == null) { return; } // 填充有效状态 gridRow.Cells["clmIsUse"].Value = (entity.IsUse == 1 ? "是" : "否"); } }
/// <summary> /// 生成运输记录流水号 /// </summary> /// <param name="carType">车类型</param> /// <param name="dt"></param> /// <returns></returns> public string CreateNewTransportSerialNumber(eCarType carType, DateTime dt) { string prefix = "Null"; if (carType == eCarType.入厂煤) { prefix = "RCM"; CmcsBuyFuelTransport entity = SelfDber.Entity <CmcsBuyFuelTransport>("where to_char(CreateDate,'yyyymmdd')=to_char(:CreateDate,'yyyymmdd') and SerialNumber like :Prefix || '%' order by InFactoryTime desc", new { CreateDate = dt, Prefix = prefix }); if (entity == null) { return(prefix + dt.ToString("yyMMdd") + "001"); } else { return(prefix + dt.ToString("yyMMdd") + (Convert.ToInt16(entity.SerialNumber.Replace(prefix + dt.ToString("yyMMdd"), "")) + 1).ToString().PadLeft(3, '0')); } } else if (carType == eCarType.销售煤) { prefix = "XSM"; CmcsSaleFuelTransport entity = SelfDber.Entity <CmcsSaleFuelTransport>("where to_char(CreateDate,'yyyymmdd')=to_char(:CreateDate,'yyyymmdd') and SerialNumber like :Prefix || '%' order by InFactoryTime desc", new { CreateDate = dt, Prefix = prefix }); if (entity == null) { return(prefix + dt.ToString("yyMMdd") + "001"); } else { return(prefix + dt.ToString("yyMMdd") + (Convert.ToInt16(entity.SerialNumber.Replace(prefix + dt.ToString("yyMMdd"), "")) + 1).ToString().PadLeft(3, '0')); } } else if (carType == eCarType.其他物资) { prefix = "WZ"; CmcsGoodsTransport entity = SelfDber.Entity <CmcsGoodsTransport>("where to_char(CreateDate,'yyyymmdd')=to_char(:CreateDate,'yyyymmdd') and SerialNumber like :Prefix || '%' order by InFactoryTime desc", new { CreateDate = dt, Prefix = prefix }); if (entity == null) { return(prefix + dt.ToString("yyMMdd") + "001"); } else { return(prefix + dt.ToString("yyMMdd") + (Convert.ToInt16(entity.SerialNumber.Replace(prefix + dt.ToString("yyMMdd"), "")) + 1).ToString().PadLeft(3, '0')); } } return(prefix + dt.ToString("yyMMdd") + DateTime.Now.Second.ToString().PadLeft(3, '0')); }
public void BindData() { ChangeColumn(); List <CmcsSaleFuelTransport> list = Dbers.GetInstance().SelfDber.Entities <CmcsSaleFuelTransport>(this.SqlWhere + " order by CreateDate desc"); superGridControl1.PrimaryGrid.DataSource = list; if ((ddlStatus.Text == eFlowStatus.重车.ToString() || ddlStatus.Text == eFlowStatus.出场.ToString()) && list.Count > 0) { CmcsSaleFuelTransport total = new CmcsSaleFuelTransport(); total.CarNumber = "合计"; total.GrossWeight = list.Sum(a => a.GrossWeight); total.TareWeight = list.Sum(a => a.TareWeight); total.SuttleWeight = list.Sum(a => a.SuttleWeight); list.Insert(list.Count, total); } }
/// <summary> /// 保存入厂煤运输记录 /// </summary> /// <param name="transportId"></param> /// <param name="dt"></param> /// <returns></returns> public bool SaveSaleFuelTransport(string transportId, DateTime dt) { CmcsSaleFuelTransport transport = SelfDber.Get <CmcsSaleFuelTransport>(transportId); if (transport == null) { return(false); } transport.StepName = eTruckInFactoryStep.出厂.ToString(); transport.OutFactoryTime = dt; transport.IsFinish = 1; transport.IsSynch = "0"; return(SelfDber.Update(transport) > 0); }
private void superGridControl1_DataBindingComplete(object sender, DevComponents.DotNetBar.SuperGrid.GridDataBindingCompleteEventArgs e) { foreach (GridRow item in e.GridPanel.Rows) { try { CmcsLMYBDetail entity = item.DataItem as CmcsLMYBDetail; item.Cells["clmSupplierName"].Value = entity.TheLMYB.SupplierName; item.Cells["clmMineName"].Value = entity.TheLMYB.MineName; item.Cells["clmStepName"].Value = "等待入场"; if (entity.IsFinish == "已完成") { item.Cells["operation"].Visible = false; } if (this.Type == "入场煤") { CmcsBuyFuelTransport transport = Dbers.GetInstance().SelfDber.Entity <CmcsBuyFuelTransport>("where LMYBDetailId=:LMYBDetailId order by CreateDate desc", new { LMYBDetailId = entity.Id }); if (transport != null) { item.Cells["clmInFactoryTime"].Value = transport.InFactoryTime.ToString("yyyy-MMM-dd"); item.Cells["clmStepName"].Value = transport.StepName; } } else { CmcsSaleFuelTransport transport = Dbers.GetInstance().SelfDber.Entity <CmcsSaleFuelTransport>("where LMYBDetailId=:LMYBDetailId order by CreateDate desc", new { LMYBDetailId = entity.Id }); if (transport != null) { item.Cells["clmInFactoryTime"].Value = transport.InFactoryTime.ToString("yyyy-MMM-dd"); item.Cells["clmStepName"].Value = transport.StepName; } } CmcsAutotruck autoTruck = Dbers.GetInstance().SelfDber.Entity <CmcsAutotruck>("where CarNumber=:CarNumber order by CreateDate desc", new { CarNumber = entity.CarNumber }); if (autoTruck != null) { item.Cells["clmDriver"].Value = autoTruck.Driver; item.Cells["clmPhoneNumber"].Value = autoTruck.CellPhoneNumber; } } catch (Exception) { } } }
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); } }
private void FrmCarShippChange_Confirm_Load(object sender, EventArgs e) { entity = CommonDAO.GetInstance().SelfDber.Get <CmcsSaleFuelTransport>(this.Id); if (entity == null) { this.Close(); } txtCarNum.Text = entity.CarNumber; if (entity.StorageName != null) { cmbShippSpace.Text = entity.StorageName; } else { cmbShippSpace.Text = entity.CPCName; } }
private void FrmSaleFuelTransport_Oper_Load(object sender, EventArgs e) { //绑定煤种信息 cmbFuelName_SaleFuel.DisplayMember = "Name"; cmbFuelName_SaleFuel.ValueMember = "Id"; cmbFuelName_SaleFuel.DataSource = Dbers.GetInstance().SelfDber.Entities <CmcsFuelKind>("where IsStop=0 and ParentId is not null"); cmbFuelName_SaleFuel.SelectedIndex = 0; //绑定流程节点 BindStepName(); this.CmcsSaleFuelTransport = Dbers.GetInstance().SelfDber.Get <CmcsSaleFuelTransport>(this.PId); if (this.CmcsSaleFuelTransport != null) { if (!String.IsNullOrEmpty(this.CmcsSaleFuelTransport.TransportSalesId)) { cmcsTransportSales = Dbers.GetInstance().SelfDber.Get <CmcsTransportSales>(this.CmcsSaleFuelTransport.TransportSalesId); } txt_SerialNumber.Text = CmcsSaleFuelTransport.SerialNumber; txt_CarNumber.Text = CmcsSaleFuelTransport.CarNumber; txt_SupplierName.Text = CmcsSaleFuelTransport.SupplierName; txt_LoadArea.Text = CmcsSaleFuelTransport.LoadArea; txt_TransportCompanyName.Text = CmcsSaleFuelTransport.TransportCompanyName; 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); cmbStepName.Text = CmcsSaleFuelTransport.StepName; } if (this.EditMode == eEditMode.查看) { btnSubmit.Enabled = false; HelperUtil.ControlReadOnly(panelEx2, true); } }
public void BindData() { listCount.Clear(); string tempSqlWhere = this.SqlWhere; listCount = Dbers.GetInstance().SelfDber.Entities <CmcsSaleFuelTransport>(tempSqlWhere + " order by SerialNumber desc"); listCount.OrderBy(a => a.SupplierId); CmcsSaleFuelTransport listTotal1 = new CmcsSaleFuelTransport(); listTotal1.SupplierId = "合计"; listTotal1.GrossWeight = listCount.Sum(a => a.GrossWeight); listTotal1.TareWeight = listCount.Sum(a => a.TareWeight); listTotal1.SuttleWeight = listCount.Sum(a => a.SuttleWeight); listTotal1.IsFinish = listCount.Count;//车数 listCount.Add(listTotal1); superGridControl1.PrimaryGrid.DataSource = listCount; }