private void superGridControl1_DataBindingComplete(object sender, DevComponents.DotNetBar.SuperGrid.GridDataBindingCompleteEventArgs e)
{
foreach (GridRow gridRow in e.GridPanel.Rows)
{
CmcsBuyFuelTransport entity = gridRow.DataItem as CmcsBuyFuelTransport;
if (entity == null)
{
return;
}
//gridRow.Cells["KsWeight"].Value = entity.KsWeight + entity.AutoKsWeight;
}
}
/// <summary>
/// 保存运输记录
/// </summary>
/// <returns></returns>
bool SaveBuyFuelTransport()
{
CmcsAutotruck autoTruck = commonDAO.SelfDber.Entity <CmcsAutotruck>("where CarNumber=:CarNumber", new { CarNumber = this.txt_CarNumber.Text });
if (autoTruck == null)
{
autoTruck = new CmcsAutotruck()
{
CarNumber = this.txt_CarNumber.Text
};
commonDAO.SelfDber.Insert(autoTruck);
}
this.CurrentAutotruck = autoTruck;
try
{
if (this.CurrentBuyFuelTransport == null)
{
// 查找该车未完成的运输记录
CmcsUnFinishTransport unFinishTransport = carTransportDAO.GetUnFinishTransportByAutotruckId(this.CurrentAutotruck.Id, eCarType.入场煤.ToString());
if (unFinishTransport != null)
{
this.CurrentBuyFuelTransport = commonDAO.SelfDber.Get <CmcsBuyFuelTransport>(unFinishTransport.TransportId);
}
else
{
CmcsBuyFuelTransport transport = new CmcsBuyFuelTransport();
QueuerDAO.GetInstance().JoinQueueBuyFuelTransport(autoTruck, this.SelectedMine_BuyFuel, this.SelectedFuelKind_BuyFuel, Convert.ToDecimal(this.txtTicketWeight_BuyFuel.Value), DateTime.Now, "", ref transport);
this.CurrentBuyFuelTransport = transport;
}
}
this.CurrentBuyFuelTransport.KgWeight = (decimal)this.txtKgWeight_BuyFuel.Value;
this.CurrentBuyFuelTransport.KsWeight = (decimal)this.txtKsWeight_BuyFuel.Value;
this.CurrentBuyFuelTransport.DeductWeight = (decimal)this.txtKgWeight_BuyFuel.Value + (decimal)this.txtKsWeight_BuyFuel.Value;
if (weighterDAO.SaveBuyFuelTransportHand(this.CurrentBuyFuelTransport, (decimal)Hardwarer.Wber.Weight, DateTime.Now, CommonAppConfig.GetInstance().AppIdentifier))
{
this.CurrentBuyFuelTransport = commonDAO.SelfDber.Get <CmcsBuyFuelTransport>(this.CurrentBuyFuelTransport.Id);
LoadTodayUnFinishBuyFuelTransport();
LoadTodayFinishBuyFuelTransport();
return(true);
}
}
catch (Exception ex)
{
MessageBoxEx.Show("保存失败\r\n" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
Log4Neter.Error("保存运输记录", ex);
}
return(false);
}
/// <summary>
/// 窗体加载绑定数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void FrmBuyFuelTransport_Oper_Load(object sender, EventArgs e)
{
//绑定煤种信息
cmbFuelName_BuyFuel.DisplayMember = "Name";
cmbFuelName_BuyFuel.ValueMember = "Id";
cmbFuelName_BuyFuel.DataSource = Dbers.GetInstance().SelfDber.Entities <CmcsFuelKind>("where IsStop=0 and ParentId is not null");
cmbFuelName_BuyFuel.SelectedIndex = 0;
BindStepName();
LoadHeavyWeight(cmbHeavyWeight);
this.CmcsBuyFuelTransport = Dbers.GetInstance().SelfDber.Get <CmcsBuyFuelTransport>(this.PId);
if (this.CmcsBuyFuelTransport != null)
{
txt_SerialNumber.Text = CmcsBuyFuelTransport.SerialNumber;
txt_CarNumber.Text = CmcsBuyFuelTransport.CarNumber;
CmcsInFactoryBatch cmcsinfactorybatch = Dbers.GetInstance().SelfDber.Get <CmcsInFactoryBatch>(CmcsBuyFuelTransport.InFactoryBatchId);
if (cmcsinfactorybatch != null)
{
txt_InFactoryBatchNumber.Text = cmcsinfactorybatch.Batch;
}
txt_SupplierName.Text = CmcsBuyFuelTransport.SupplierName;
txt_TransportCompanyName.Text = CmcsBuyFuelTransport.TransportCompanyName;
txt_MineName.Text = CmcsBuyFuelTransport.MineName;
cmbFuelName_BuyFuel.Text = CmcsBuyFuelTransport.FuelKindName;
dbi_TicketWeight.Value = (double)CmcsBuyFuelTransport.TicketWeight;
dbi_GrossWeight.Value = (double)CmcsBuyFuelTransport.GrossWeight;
dbi_TareWeight.Value = (double)CmcsBuyFuelTransport.TareWeight;
dbi_DeductWeight.Value = (double)CmcsBuyFuelTransport.DeductWeight;
dbi_SuttleWeight.Value = (double)CmcsBuyFuelTransport.SuttleWeight;
cmbHeavyWeight.Text = CmcsBuyFuelTransport.HeavyWeight;
txtShipNumber.Text = CmcsBuyFuelTransport.ShipName;
txt_InFactoryTime.Text = CmcsBuyFuelTransport.InFactoryTime.Year == 1 ? "" : CmcsBuyFuelTransport.InFactoryTime.ToString();
txt_SamplingTime.Text = CmcsBuyFuelTransport.SamplingTime.Year == 1 ? "" : CmcsBuyFuelTransport.SamplingTime.ToString();
txt_GrossTime.Text = CmcsBuyFuelTransport.GrossTime.Year == 1 ? "" : CmcsBuyFuelTransport.GrossTime.ToString();
txt_UploadTime.Text = CmcsBuyFuelTransport.UploadTime.Year == 1 ? "" : CmcsBuyFuelTransport.UploadTime.ToString();
txt_TareTime.Text = CmcsBuyFuelTransport.TareTime.Year == 1 ? "" : CmcsBuyFuelTransport.TareTime.ToString();
txt_OutFactoryTime.Text = CmcsBuyFuelTransport.OutFactoryTime.Year == 1 ? "" : CmcsBuyFuelTransport.OutFactoryTime.ToString();
txt_Remark.Text = CmcsBuyFuelTransport.Remark;
chb_IsFinish.Checked = (CmcsBuyFuelTransport.IsFinish == 1);
chb_IsUse.Checked = (CmcsBuyFuelTransport.IsUse == 1);
cmbStepName.Text = CmcsBuyFuelTransport.StepName;
this.CmcsAutotruck = commonDAO.SelfDber.Get <CmcsAutotruck>(CmcsBuyFuelTransport.AutotruckId);
ShowDeduct(this.CmcsBuyFuelTransport.Id);
}
if (this.EditMode == eEditMode.查看)
{
btnSubmit.Enabled = false;
HelperUtil.ControlReadOnly(panelEx2, true);
}
}
private void superGridControl1_DataBindingComplete(object sender, DevComponents.DotNetBar.SuperGrid.GridDataBindingCompleteEventArgs e)
{
foreach (GridRow gridRow in e.GridPanel.Rows)
{
View_BuyFuelTransport entity = gridRow.DataItem as View_BuyFuelTransport;
if (entity == null)
{
return;
}
CmcsBuyFuelTransport entity2 = Dbers.GetInstance().SelfDber.Get <CmcsBuyFuelTransport>(entity.Id);
gridRow.Cells["clmKsWeight"].Value = entity2.AutoKsWeight + entity2.KsWeight;
}
}
public void Print(CmcsBuyFuelTransport buyfueltransport)
{
_BuyFuelTransport = buyfueltransport;
try
{
this._PrintDocument.Print();
}
catch
{
MessageBoxEx.Show("打印异常，请检查打印机！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
_BuyFuelTransport = null;
}
private void tsmiPrint_Click(object sender, EventArgs e)
{
GridRow gridRow = superGridControl1.PrimaryGrid.ActiveRow as GridRow;
if (gridRow == null)
{
return;
}
CmcsBuyFuelTransport entity = gridRow.DataItem as CmcsBuyFuelTransport;
FrmPrintWeb frm = new FrmPrintWeb(entity);
frm.ShowDialog();
}
private void superGridControl1_DataBindingComplete(object sender, DevComponents.DotNetBar.SuperGrid.GridDataBindingCompleteEventArgs e)
{
foreach (GridRow item in e.GridPanel.Rows)
{
try
{
CmcsBuyFuelTransport entity = item.DataItem as CmcsBuyFuelTransport;
}
catch (Exception)
{
}
}
}
/// <summary>
/// 根据来煤预报生成入厂煤运输排队记录，同时生成批次信息以及采制化三级编码
/// </summary>
/// <param name="autotruck">车辆信息</param>
/// <param name="lmyb">来煤预报</param>
/// <param name="inFactoryTime">入厂时间</param>
/// <returns></returns>
public bool JoinQueueBuyFuelTransport(CmcsAutotruck autotruck, CmcsLMYB lmyb, DateTime inFactoryTime)
{
CmcsLMYBDetail lmybDetail = commonDAO.SelfDber.Entity <CmcsLMYBDetail>("where CarNumber=:CarNumber and LMYBId=:LMYBId", new { CarNumber = autotruck.CarNumber, LMYBId = lmyb.Id });
if (lmybDetail == null)
{
return(false);
}
CmcsBuyFuelTransport transport = new CmcsBuyFuelTransport
{
SerialNumber = carTransportDAO.CreateNewTransportSerialNumber(eTransportType.原料煤入场, 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 = "根据来煤预报自动生成",
};
// 生成批次以及采制化三级编码数据
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);
}
/// <summary>
/// 打印磅单
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsmiPrint_Click(object sender, EventArgs e)
{
GridRow gridRow = superGridControl2_BuyFuel.PrimaryGrid.ActiveRow as GridRow;
if (gridRow == null)
{
return;
}
View_BuyFuelTransport entity = gridRow.DataItem as View_BuyFuelTransport;
CmcsBuyFuelTransport entity2 = Dbers.GetInstance().SelfDber.Get <CmcsBuyFuelTransport>(entity.Id);
FrmPrintWeb frm = new FrmPrintWeb(entity2);
frm.ShowDialog();
}
/// <summary>
/// 保存入厂煤运输记录
/// </summary>
/// <param name="transportId"></param>
/// <param name="dt"></param>
/// <returns></returns>
public bool SaveBuyFuelTransport(string transportId, DateTime dt)
{
CmcsBuyFuelTransport transport = SelfDber.Get <CmcsBuyFuelTransport>(transportId);
if (transport == null)
{
return(false);
}
transport.StepName = eTruckInFactoryStep.入厂.ToString();
transport.InFactoryTime = dt;
return(SelfDber.Update(transport) > 0);
}
/// <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);
}
private void btnSave_Click(object sender, EventArgs e)
{
CmcsBuyFuelTransport transport = commonDAO.SelfDber.Get <CmcsBuyFuelTransport>(this.transportId);
if (transport != null)
{
transport.KgWeight = Convert.ToDecimal(txtKGWeight.Text);
transport.KsWeight = Convert.ToDecimal(txtKSWeight.Text);
commonDAO.SelfDber.Update <CmcsBuyFuelTransport>(transport);
this.DialogResult = DialogResult.OK;
this.Close();
}
}
public FrmCarDeduction_Confirm(string transportId)
{
InitializeComponent();
this.transportId = transportId;
CmcsBuyFuelTransport transport = commonDAO.SelfDber.Get <CmcsBuyFuelTransport>(this.transportId);
if (transport != null)
{
txtCarNum.Text = transport.CarNumber;
txtKGWeight.Text = transport.KgWeight.ToString("f2");
txtKSWeight.Text = transport.KsWeight.ToString("f2");
}
}
public int SyncTransport(Action <string, eOutputType> output)
{
int res = 0;
IList <TransportOld> list = DcDbers.GetInstance().TruckWeight_Dber.Entities <TransportOld>("where IsToServer=0 and SuttleWeight>0");
foreach (TransportOld item in list)
{
CmcsBuyFuelTransport entity = CommonDAO.GetInstance().SelfDber.Get <CmcsBuyFuelTransport>(item.Id);
if (entity == null)
{
entity = new CmcsBuyFuelTransport();
entity.Id = item.Id;
entity.CreateDate = item.CreateDate;
entity.OperDate = item.OperDate;
entity.OperUser = item.OperUser;
entity.CreateUser = item.CreateUser;
entity.InFactoryTime = item.InFactoryTime;
entity.GrossPlace = item.GrossPlace;
entity.GrossTime = item.GrossTime;
entity.GrossWeight = item.GrossWeight;
entity.TarePlace = item.TarePlace;
entity.TareTime = item.TareTime;
entity.TareWeight = item.TareWeight;
entity.SuttleWeight = item.SuttleWeight;
entity.KsWeight = item.KsWeight;
entity.KgWeight = item.KgWeight;
entity.AutoKsWeight = item.AutoKsWeight;
entity.CheckWeight = item.CheckWeight;
entity.ProfitAndLossWeight = item.ProfitAndLossWeight;
entity.OutFactoryTime = item.OutFactoryTime;
entity.MineName = item.MineName;
entity.AutotruckId = item.AutotruckId;
entity.CarNumber = item.CarNumber;
entity.TicketWeight = item.TicketWeight;
entity.FuelKindId = item.FuelKindId;
entity.FuelKindName = item.FuelKindName;
entity.IsUse = item.IsUse;
entity.IsFinish = item.IsFinish;
entity.StepName = item.StepName;
entity.InFactoryBatchId = item.InFactoryBatchId;
entity.SerialNumber = item.SerialNumber;
res += CommonDAO.GetInstance().SelfDber.Insert(entity);
item.IsToServer = 1;
DcDbers.GetInstance().TruckWeight_Dber.Update(item);
}
}
output(string.Format("同步运输记录 {0} 条（第三方 > 集中管控）", res), eOutputType.Normal);
return(res);
}
/// <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'));
}
/// <summary>
/// 请求数据
/// </summary>
void RequestData()
{
string value = string.Empty, machineCode = string.Empty;
List <HtmlDataItem> datas = new List <HtmlDataItem>();
datas.Clear();
machineCode = this.CurrentMachineCode;
string[] machineCodes = new string[] { GlobalVars.MachineCode_QC_Weighter_1, GlobalVars.MachineCode_QC_Weighter_2, GlobalVars.MachineCode_QC_Weighter_3, GlobalVars.MachineCode_QC_Weighter_4 };
for (int i = 0; i < machineCodes.Length; i++)
{
int machineNumber = i + 1;
machineCode = machineCodes[i];
datas.Add(new HtmlDataItem("#" + machineNumber + "汽车衡_系统", monitorCommon.ConvertBooleanToColor(commonDAO.GetSignalDataValue(machineCode, eSignalDataName.系统.ToString())), eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("#" + machineNumber + "汽车衡_IO控制器", monitorCommon.ConvertBooleanToColor(commonDAO.GetSignalDataValue(machineCode, eSignalDataName.IO控制器_连接状态.ToString())), eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("#" + machineNumber + "汽车衡_地磅仪表", monitorCommon.ConvertBooleanToColor(commonDAO.GetSignalDataValue(machineCode, eSignalDataName.地磅仪表_连接状态.ToString())), eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("#" + machineNumber + "汽车衡_LED屏", monitorCommon.ConvertBooleanToColor(commonDAO.GetSignalDataValue(machineCode, eSignalDataName.LED屏1_连接状态.ToString())), eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("#" + machineNumber + "汽车衡_读卡器1", monitorCommon.ConvertBooleanToColor(commonDAO.GetSignalDataValue(machineCode, eSignalDataName.读卡器1_连接状态.ToString())), eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("#" + machineNumber + "汽车衡_读卡器2", monitorCommon.ConvertBooleanToColor(commonDAO.GetSignalDataValue(machineCode, eSignalDataName.读卡器2_连接状态.ToString())), eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("#" + machineNumber + "汽车衡_仪表重量", commonDAO.GetSignalDataValue(machineCode, eSignalDataName.地磅仪表_实时重量.ToString()) + " 吨", eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("#" + machineNumber + "汽车衡_仪表重量", commonDAO.GetSignalDataValue(machineCode, eSignalDataName.地磅仪表_稳定.ToString()).ToLower() == "1" ? ColorTranslator.ToHtml(EquipmentStatusColors.BeReady) : ColorTranslator.ToHtml(EquipmentStatusColors.Working), eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("#" + machineNumber + "汽车衡_当前车号", string.IsNullOrEmpty(commonDAO.GetSignalDataValue(machineCode, eSignalDataName.当前车号.ToString())) ? "--" : commonDAO.GetSignalDataValue(machineCode, eSignalDataName.当前车号.ToString()), eHtmlDataItemType.svg_text));
if (!string.IsNullOrWhiteSpace(commonDAO.GetSignalDataValue(machineCode, eSignalDataName.当前运输记录Id.ToString())))
{
CmcsBuyFuelTransport cmcsBuyFuelTransport = commonDAO.SelfDber.Get <CmcsBuyFuelTransport>(commonDAO.GetSignalDataValue(machineCode, eSignalDataName.当前运输记录Id.ToString()));
datas.Add(new HtmlDataItem("#" + machineNumber + "汽车衡_毛重", cmcsBuyFuelTransport == null ? "0 吨" : cmcsBuyFuelTransport.GrossWeight + " 吨", eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("#" + machineNumber + "汽车衡_皮重", cmcsBuyFuelTransport == null ? "0 吨" : cmcsBuyFuelTransport.TareWeight + " 吨", eHtmlDataItemType.svg_text));
}
else
{
datas.Add(new HtmlDataItem("#" + machineNumber + "汽车衡_毛重", "0 吨", eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("#" + machineNumber + "汽车衡_皮重", "0 吨", eHtmlDataItemType.svg_text));
}
datas.Add(new HtmlDataItem("#" + machineNumber + "汽车衡_卡车", (!string.IsNullOrEmpty(commonDAO.GetSignalDataValue(machineCode, eSignalDataName.当前车号.ToString()))).ToString(), eHtmlDataItemType.svg_visible));
datas.Add(new HtmlDataItem("#" + machineNumber + "汽车衡_地感1", commonDAO.GetSignalDataValue(machineCode, eSignalDataName.地感1信号.ToString()).ToLower() == "1" ? ColorTranslator.ToHtml(EquipmentStatusColors.Working) : "#c0c0c0", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("#" + machineNumber + "汽车衡_地感2", commonDAO.GetSignalDataValue(machineCode, eSignalDataName.地感2信号.ToString()).ToLower() == "1" ? ColorTranslator.ToHtml(EquipmentStatusColors.Working) : "#c0c0c0", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("#" + machineNumber + "汽车衡_对射1", commonDAO.GetSignalDataValue(machineCode, eSignalDataName.对射1信号.ToString()).ToLower() == "1" ? ColorTranslator.ToHtml(EquipmentStatusColors.Working) : "#c0c0c0", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("#" + machineNumber + "汽车衡_对射2", commonDAO.GetSignalDataValue(machineCode, eSignalDataName.对射2信号.ToString()).ToLower() == "1" ? ColorTranslator.ToHtml(EquipmentStatusColors.Working) : "#c0c0c0", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("#" + machineNumber + "汽车衡_对射3", commonDAO.GetSignalDataValue(machineCode, eSignalDataName.对射3信号.ToString()).ToLower() == "1" ? ColorTranslator.ToHtml(EquipmentStatusColors.Working) : "#c0c0c0", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("#" + machineNumber + "汽车衡_道闸1", (commonDAO.GetSignalDataValue(machineCode, eSignalDataName.道闸1升杆.ToString()) == "0").ToString(), eHtmlDataItemType.svg_visible));
datas.Add(new HtmlDataItem("#" + machineNumber + "汽车衡_道闸2", (commonDAO.GetSignalDataValue(machineCode, eSignalDataName.道闸2升杆.ToString()) == "0").ToString(), eHtmlDataItemType.svg_visible));
datas.Add(new HtmlDataItem("#" + machineNumber + "汽车衡_卡车", commonDAO.GetSignalDataValue(machineCode, eSignalDataName.磅方向.ToString()), eHtmlDataItemType.svg_scare));
// 添加更多...
}
// 发送到页面
cefWebBrowser.Browser.GetMainFrame().ExecuteJavaScript("requestData(" + Newtonsoft.Json.JsonConvert.SerializeObject(datas) + ");", "", 0);
}
private void superGridControl1_DataBindingComplete(object sender, GridDataBindingCompleteEventArgs e)
{
foreach (GridRow item in e.GridPanel.Rows)
{
try
{
CmcsBuyFuelTransport cmcsBuyFuelTransport = item.DataItem as CmcsBuyFuelTransport;
item.Cells["cellPASSWEIGHT"].Value = cmcsBuyFuelTransport.PASSWEIGHT.ToString("f2");
}
catch (Exception)
{
}
}
}
/// <summary>
/// 保存入厂煤运输记录
/// </summary>
/// <param name="transportId"></param>
/// <param name="place"></param>
/// <returns></returns>
public bool SaveBuyFuelTransport(string transportId, DateTime dt, string place)
{
CmcsBuyFuelTransport transport = SelfDber.Get <CmcsBuyFuelTransport>(transportId);
if (transport == null)
{
return(false);
}
transport.StepName = eTruckInFactoryStep.采样.ToString();
transport.SamplingTime = dt;
transport.SamplePlace = place;
return(SelfDber.Update(transport) > 0);
}
/// <summary>
/// 保存入厂煤运输记录
/// </summary>
/// <param name="transportId"></param>
/// <param name="dt"></param>
/// <returns></returns>
public bool SaveBuyFuelTransport(string transportId, DateTime dt)
{
CmcsBuyFuelTransport transport = SelfDber.Get <CmcsBuyFuelTransport>(transportId);
if (transport == null)
{
return(false);
}
transport.OutFactoryPlace = CommonAppConfig.GetInstance().AppIdentifier;
transport.StepName = eTruckInFactoryStep.出厂.ToString();
transport.OutFactoryTime = dt;
transport.IsFinish = 1;
transport.IsSynch = "0";
return(SelfDber.Update(transport) > 0);
}
/// <summary>
/// 选择回皮车辆
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSelectAutotruck_BuyFuel_Click(object sender, EventArgs e)
{
FrmUnFinishTransport_Select frm = new FrmUnFinishTransport_Select("where CarType='" + eCarType.入场煤.ToString() + "' order by CreateDate desc");
if (frm.ShowDialog() == DialogResult.OK)
{
List <View_UnFinishTransport> list = CarTransportDAO.GetInstance().GetUnFinishTransportByCarNumber(frm.Output.CarNumber.Trim(), " order by CreateDate desc");
if (list != null && list.Count > 0)
{
this.CurrentBuyFuelTransport = commonDAO.SelfDber.Get <CmcsBuyFuelTransport>(list[0].TransportId);
}
else
{
this.CurrentBuyFuelTransport = null;
}
}
}
private void FrmSupplier_Oper_Load(object sender, EventArgs e)
{
this.MinimizeBox = false;
if (!String.IsNullOrEmpty(id))
{
try
{
this.cmcsSupplier = Dbers.GetInstance().SelfDber.Get <CmcsBuyFuelTransport>(this.id);
makeImage(null, null);
}
catch (Exception ex)
{
MessageBoxEx.Show("打印失败，请联系系统管理员！", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.Close();
}
}
}
public void Print(CmcsBuyFuelTransport buyfueltransport)
{
if (buyfueltransport == null)
{
return;
}
_BuyFuelTransport = buyfueltransport;
try
{
this._PrintDocument.Print();
}
catch (Exception ex)
{
Log4Neter.Error("打印异常，请检查打印机！", ex);
}
_BuyFuelTransport = null;
}
/// <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="place">地点</param>
/// <param name="samplingType">采样方式</param>
/// <param name="heavyweight">重车磅</param>
/// <param name="samplingType">船号</param>
/// <returns></returns>
public bool JoinQueueBuyFuelTransport(CmcsAutotruck autotruck, CmcsSupplier supplier, CmcsMine mine, CmcsTransportCompany transportCompany, CmcsFuelKind fuelKind, decimal ticketWeight, DateTime inFactoryTime, string remark, string place, string heavyweight, string shipnumber)
{
CmcsBuyFuelTransport transport = new CmcsBuyFuelTransport
{
SerialNumber = carTransportDAO.CreateNewTransportSerialNumber(eCarType.入厂煤, inFactoryTime),
AutotruckId = autotruck.Id,
CarNumber = autotruck.CarNumber,
SupplierId = supplier.Id,
SupplierName = supplier.Name,
MineId = mine != null ? mine.Id:"",
MineName = mine != null ? mine.Name:"",
TransportCompanyId = transportCompany != null?transportCompany.Id:"",
TransportCompanyName = transportCompany != null ? transportCompany.Name:"",
FuelKindId = fuelKind != null?fuelKind.Id:"",
FuelKindName = fuelKind != null ? fuelKind.Name:"",
TicketWeight = ticketWeight,
InFactoryTime = inFactoryTime,
IsFinish = 0,
IsUse = 1,
StepName = eTruckInFactoryStep.入厂.ToString(),
Remark = remark,
HeavyWeight = heavyweight,
ShipName = shipnumber,
Recorder = GlobalVars.LoginUser.Name
};
// 生成批次以及采制化三级编码数据
CmcsInFactoryBatch inFactoryBatch = carTransportDAO.GCQCInFactoryBatchByBuyFuelTransport(transport);
if (inFactoryBatch != null)
{
if (SelfDber.Insert(transport) > 0)
{
// 插入未完成运输记录
return(SelfDber.Insert(new CmcsUnFinishTransport
{
TransportId = transport.Id,
CarType = eCarType.入厂煤.ToString(),
AutotruckId = autotruck.Id,
PrevPlace = place,
}) > 0);
}
}
return(false);
}
void Search(string input)
{
List <View_UnFinishTransport> list = new List <View_UnFinishTransport>();
if (!string.IsNullOrEmpty(input))
{
list = CarTransportDAO.GetInstance().GetUnFinishTransportByCarNumberAccurate(input.Trim(), " order by CreateDate desc");
if (list != null && list.Count > 0)
{
this.CurrentBuyFuelTransport = commonDAO.SelfDber.Get <CmcsBuyFuelTransport>(list[0].TransportId);
}
else
{
this.CurrentBuyFuelTransport = null;
}
}
}
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)
{
}
}
}
/// <summary>
/// 保存入厂煤运输记录
/// </summary>
/// <param name="transportId"></param>
/// <param name="weight">重量</param>
/// <param name="place"></param>
/// <returns></returns>
public bool SaveBuyFuelTransport(string transportId, decimal weight, DateTime dt, string place)
{
CmcsBuyFuelTransport transport = SelfDber.Get <CmcsBuyFuelTransport>(transportId);
if (transport == null)
{
return(false);
}
//根据当前流程节点名称判断
if (transport.StepName != eTruckInFactoryStep.重车.ToString() && transport.StepName != eTruckInFactoryStep.采样.ToString())
{
transport.StepName = eTruckInFactoryStep.重车.ToString();
transport.GrossWeight = weight;
transport.GrossPlace = place;
transport.GrossTime = dt;
}
else if (transport.StepName == eTruckInFactoryStep.重车.ToString() || transport.StepName == eTruckInFactoryStep.采样.ToString())
{
transport.StepName = eTruckInFactoryStep.轻车.ToString();
transport.TareWeight = weight;
transport.TarePlace = place;
transport.TareTime = dt;
//扣吨量
transport.DeductWeight = GetDeductWeight(transport.Id);
transport.SuttleWeight = transport.GrossWeight - transport.TareWeight - transport.DeductWeight;
// 回皮即完结
transport.IsFinish = 1;
//流程结束时删除临时运输记录
CmcsUnFinishTransport unFinishTransport = SelfDber.Entity <CmcsUnFinishTransport>("where TransportId=:TransportId", new { TransportId = transportId });
if (unFinishTransport != null)
{
SelfDber.Delete <CmcsUnFinishTransport>(unFinishTransport.Id);
}
}
else
{
return(false);
}
return(SelfDber.Update(transport) > 0);
}
/// <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="Mpph">全过程煤批编号</param>
/// <param name="sampler">指定采样机编号</param>
/// <param name="remark">备注</param>
/// <param name="place">地点</param>
/// <returns></returns>
public bool JoinQueueBuyFuelTransport(CmcsAutotruck autotruck, CmcsSupplier supplier, CmcsMine mine, CmcsTransportCompany transportCompany, CmcsFuelKind fuelKind, decimal ticketWeight, DateTime inFactoryTime, string Mpph, string sampler, string remark, string place)
{
CmcsBuyFuelTransport transport = new CmcsBuyFuelTransport
{
SerialNumber = carTransportDAO.CreateNewTransportSerialNumber(eCarType.入厂煤, inFactoryTime),
AutotruckId = autotruck.Id,
CarNumber = autotruck.CarNumber,
SupplierId = supplier.Id,
SupplierName = supplier.Name,
MineId = mine.Id,
MineName = mine.Name,
TransportCompanyId = transportCompany.Id,
TransportCompanyName = transportCompany.Name,
FuelKindId = fuelKind.Id,
FuelKindName = fuelKind.Name,
TicketWeight = ticketWeight,
InFactoryTime = inFactoryTime,
IsFinish = 0,
IsUse = 1,
Mpph = Mpph,
SamplePlace = sampler,
StepName = eTruckInFactoryStep.入厂.ToString(),
HistoryTareAvg = GetHistoryTareAvg(autotruck.CarNumber),
Remark = remark
};
// 生成批次以及采制化三级编码数据
//CmcsInFactoryBatch inFactoryBatch = carTransportDAO.GCQCInFactoryBatchByBuyFuelTransport(transport);
//if (inFactoryBatch != null)
//{
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="entity"></param>
public void PrintBuyFuelTransport(CmcsBuyFuelTransport entity)
{
CmcsTransportTemp temp = new CmcsTransportTemp()
{
TareTime = entity.TareTime,
SupplierName = entity.MineName,
CarNumber = entity.CarNumber,
FuelKindName = entity.FuelKindName,
GrossWeight = entity.GrossWeight,
TareWeight = entity.TareWeight,
SuttleWeight = entity.SuttleWeight,
DeductWeight = entity.DeductWeight,
Remark = entity.Remark,
SerialNumber = entity.SerialNumber
};
Print(temp);
}
public void BindData()
{
ChangeColumn();
List <CmcsBuyFuelTransport> list = Dbers.GetInstance().SelfDber.Entities <CmcsBuyFuelTransport>(this.SqlWhere + " order by CreateDate desc");
if (ddlStatus.Text == eFlowStatus.出场.ToString() && list.Count > 0)
{
CmcsBuyFuelTransport total = new CmcsBuyFuelTransport();
total.CarNumber = "合计";
total.GrossWeight = list.Sum(a => a.GrossWeight);
total.TareWeight = list.Sum(a => a.TareWeight);
total.CheckWeight = list.Sum(a => a.CheckWeight);
total.KgWeight = list.Sum(a => a.KgWeight);
total.KsWeight = list.Sum(a => a.KsWeight);
list.Insert(list.Count, total);
}
superGridControl1.PrimaryGrid.DataSource = list;
}
private void superGridControl1_DataBindingComplete(object sender, DevComponents.DotNetBar.SuperGrid.GridDataBindingCompleteEventArgs e)
{
foreach (GridRow gridRow in e.GridPanel.Rows)
{
CmcsBuyFuelTransport entity = gridRow.DataItem as CmcsBuyFuelTransport;
if (entity == null)
{
return;
}
gridRow.Cells["clmKsWeight"].Value = entity.AutoKsWeight + entity.KsWeight;
if (entity.MineName == "合计")
{
gridRow.Cells["clmFuelKind"].Visible = false;
gridRow.Cells["clmGrossTime"].Visible = false;
gridRow.Cells["clmTareTime"].Visible = false;
}
}
}