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;
}
