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);
}
/// <summary>
/// 生成其他物资运输排队记录
/// </summary>
/// <param name="autotruck">车辆</param>
/// <param name="supply">供货单位</param>
/// <param name="receive">收货单位</param>
/// <param name="goodsType">物资类型</param>
/// <param name="inFactoryTime">入厂时间</param>
/// <param name="remark">备注</param>
/// <param name="place">地点</param>
/// <returns></returns>
public bool JoinQueueGoodsTransport(CmcsAutotruck autotruck, CmcsSupplier supply, CmcsSupplier receive, CmcsGoodsType goodsType, DateTime inFactoryTime, string remark, string place)
{
CmcsGoodsTransport transport = new CmcsGoodsTransport
{
SerialNumber = carTransportDAO.CreateNewTransportSerialNumber(eCarType.其他物资, inFactoryTime),
AutotruckId = autotruck.Id,
CarNumber = autotruck.CarNumber,
SupplyUnitId = supply.Id,
SupplyUnitName = supply.Name,
ReceiveUnitId = receive.Id,
ReceiveUnitName = receive.Name,
GoodsTypeId = goodsType.Id,
GoodsTypeName = goodsType.GoodsName,
InFactoryTime = inFactoryTime,
IsFinish = 0,
IsUse = 1,
StepName = eTruckInFactoryStep.入厂.ToString(),
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);
}
/// <summary>
/// 生成运输记录
/// </summary>
/// <param name="autotruck"></param>
/// <param name="mine"></param>
/// <param name="fuelKind"></param>
/// <param name="ticketWeight"></param>
/// <param name="inFactoryTime"></param>
/// <param name="remark"></param>
/// <returns></returns>
public bool JoinQueueBuyFuelTransport(CmcsAutotruck autotruck, CmcsMine mine, CmcsFuelKind fuelKind, decimal ticketWeight, DateTime inFactoryTime, string remark, ref CmcsBuyFuelTransport transport)
{
transport = new CmcsBuyFuelTransport
{
SerialNumber = carTransportDAO.CreateNewTransportSerialNumber(eTransportType.原料煤入场, inFactoryTime),
AutotruckId = autotruck.Id,
CarNumber = autotruck.CarNumber,
InFactoryPlace = CommonAppConfig.GetInstance().AppIdentifier,
MineId = mine.Id,
MineName = mine.Name,
FuelKindId = fuelKind.Id,
FuelKindName = fuelKind.FuelName,
TicketWeight = ticketWeight,
InFactoryTime = inFactoryTime,
IsFinish = 0,
IsUse = 1,
StepName = eTruckInFactoryStep.入厂.ToString(),
Remark = remark
};
CmcsInFactoryBatch inFactoryBatch = carTransportDAO.GCQCInFactoryBatchByBuyFuelTransport(transport, 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="output"></param>
public void SyncCarInfo(Action <string, eOutputType> output)
{
int res = 0;
foreach (KY_CarInfo item in this.EquDber.Entities <KY_CarInfo>("where LJ_1>0"))
{
CmcsAutotruck auto = commonDAO.SelfDber.Entity <CmcsAutotruck>("where CarNumber=:CarNumber and LeftObstacle1=0", new { CarNumber = item.Car_Number });
if (auto != null)
{
auto.CarriageLength = item.Car_Long;
auto.CarriageWidth = item.Car_Width;
auto.CarriageBottomToFloor = item.Car_Height;
auto.LeftObstacle1 = item.LJ_1;
auto.LeftObstacle2 = item.LJ_2;
auto.LeftObstacle3 = item.LJ_3;
auto.LeftObstacle4 = item.LJ_4;
auto.LeftObstacle5 = item.LJ_5;
auto.LeftObstacle6 = item.LJ_6;
auto.RightObstacle1 = item.LJ_1;
auto.RightObstacle2 = item.LJ_2;
auto.RightObstacle3 = item.LJ_3;
auto.RightObstacle4 = item.LJ_4;
auto.RightObstacle5 = item.LJ_5;
auto.RightObstacle6 = item.LJ_6;
if (commonDAO.SelfDber.Update <CmcsAutotruck>(auto) > 0)
{
res++;
}
}
}
output(string.Format("同步车辆信息 {0} 条（第三方 > 集中管控）-{1}", res, this.MachineCode), eOutputType.Normal);
}
/// <summary>
/// 生成来访车辆运输排队记录
/// </summary>
/// <param name="autotruck">车辆</param>
/// <param name="inFactoryTime">入厂时间</param>
/// <param name="remark">备注</param>
/// <param name="place">地点</param>
/// <returns></returns>
public bool JoinQueueVisitTransport(CmcsAutotruck autotruck, DateTime inFactoryTime, string remark, string place)
{
CmcsVisitTransport transport = new CmcsVisitTransport
{
SerialNumber = carTransportDAO.CreateNewTransportSerialNumber(eTransportType.来访车辆, inFactoryTime),
AutotruckId = autotruck.Id,
CarNumber = autotruck.CarNumber,
InFactoryTime = inFactoryTime,
IsFinish = 0,
IsUse = 1,
StepName = eTruckInFactoryStep.入厂.ToString(),
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);
}
/// <summary>
/// 计算拉筋数量
/// </summary>
/// <param name="autotruck"></param>
/// <returns></returns>
public int SumObstacle(CmcsAutotruck autotruck)
{
if (autotruck.LeftObstacle1 > 0)
{
if (autotruck.LeftObstacle2 > 0)
{
if (autotruck.LeftObstacle3 > 0)
{
if (autotruck.LeftObstacle4 > 0)
{
if (autotruck.LeftObstacle5 > 0)
{
if (autotruck.LeftObstacle6 > 0)
{
return(6);
}
return(5);
}
return(4);
}
return(3);
}
return(2);
}
return(1);
}
return(0);
}
private void dataGridViewX1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == -1 || e.RowIndex == -1)
{
return;
}
CmcsAutotruck entity = Dbers.GetInstance().SelfDber.Get <CmcsAutotruck>(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 <CmcsAutotruck>(entity.Id);
BindData();
}
else
{
MessageBoxEx.Show("该车牌号正在使用中，禁止删除！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
break;
}
}
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);
}
/// <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="autotruck"></param>
/// <returns></returns>
public bool CheckHasUnFinishTransport(CmcsAutotruck autotruck)
{
if (autotruck == null)
{
return(false);
}
return(commonDAO.SelfDber.Count <CmcsUnFinishTransport>("where AutotruckId=:AutotruckId order by CreateDate desc", new { AutotruckId = autotruck.Id }) > 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="place">地点</param>
/// <param name="samplingType">采样方式</param>
/// <returns></returns>
public bool JoinQueueBuyFuelTransport(CmcsAutotruck autotruck, CmcsMine mine, CmcsTransportCompany transportCompany, CmcsFuelKind fuelKind, CmcsInNetTransport inNetTransport, decimal ticketWeight, string samplerCode, string weighterCode, DateTime inFactoryTime, string remark, string place, CmcsSupplier supplier = null)
{
CmcsBuyFuelTransport transport = new CmcsBuyFuelTransport
{
SerialNumber = carTransportDAO.CreateNewTransportSerialNumber(eCarType.入厂煤, inFactoryTime),
AutotruckId = autotruck.Id,
CarNumber = autotruck.CarNumber,
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,
StepName = eTruckInFactoryStep.入厂.ToString(),
OutNetTransportId = inNetTransport == null ? "" : inNetTransport.Id,
SamplePlace = samplerCode,
GrossPlace = weighterCode,
Remark = remark,
SamplingType = eSamplingType.机械采样.ToString()
};
if (supplier != null)
{
transport.SupplierId = supplier.Id;
transport.SupplierName = supplier.Name;
}
// 生成批次以及采制化三级编码数据
CmcsInFactoryBatch inFactoryBatch = carTransportDAO.GCQCInFactoryBatchByBuyFuelTransport(transport);
if (inFactoryBatch != null)
{
if (SelfDber.Insert(transport) > 0)
{
if (inNetTransport != null)
{
//更新内网矿发运输记录节点状态
inNetTransport.StepName = eTruckInFactoryStep.入厂.ToString();
inNetTransport.Infactorytime = inFactoryTime;
SelfDber.Update(inNetTransport);
}
// 插入未完成运输记录
return(SelfDber.Insert(new CmcsUnFinishTransport
{
TransportId = transport.Id,
CarType = eCarType.入厂煤.ToString(),
AutotruckId = autotruck.Id,
PrevPlace = place,
}) > 0);
}
}
return(false);
}
/// <summary>
/// 选择车辆
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSelectAutotruck_Click(object sender, EventArgs e)
{
FrmAutotruck_Select frm = new FrmAutotruck_Select("and IsUse=1 order by CarNumber asc");
if (frm.ShowDialog() == DialogResult.OK)
{
this.CurrCmcsAutotruck = frm.Output;
}
}
private void FrmAutotruck_Select_KeyUp(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Escape)
{
this.Output = null;
this.DialogResult = DialogResult.Cancel;
this.Close();
}
}
/// <summary>
/// 同步全过程基础信息(车辆基本信息)
/// </summary>
public void SyncBaseInfoForCHLGL(Action <string, eOutputType> output, SqlServerDapperDber sqlDapperDber)
{
int res = 0;
try
{
foreach (View_rlgl_chlgl_chlgl qgc_chlgl in sqlDapperDber.Entities <View_rlgl_chlgl_chlgl>())
{
if (commonDAO.SelfDber.Get <View_rlgl_chlgl_chlgl>(qgc_chlgl.Dbid.ToString()) != null)
{
commonDAO.SelfDber.Update <View_rlgl_chlgl_chlgl>(qgc_chlgl);
}
else
{
commonDAO.SelfDber.Insert <View_rlgl_chlgl_chlgl>(qgc_chlgl);
}
CmcsAutotruck cmcsAutotruck = commonDAO.SelfDber.Entity <CmcsAutotruck>("where CarNumber=:CarNumber", new { CarNumber = qgc_chlgl.Chph });
if (cmcsAutotruck == null)
{
commonDAO.SelfDber.Insert(new CmcsAutotruck()
{
CarNumber = qgc_chlgl.Chph,
EPCCardId = qgc_chlgl.Rfid_xlh,
CarMaxWeight = qgc_chlgl.Hzl,
Is_hmd = qgc_chlgl.Is_hmd,
BX_EndDate = qgc_chlgl.Bx_enddate,
Xshzh_EndDate = qgc_chlgl.Xshzh_enddate,
Zgzh_EndDate = qgc_chlgl.Zgzh_enddate,
IsUse = 1,
CarType = qgc_chlgl.Cllx == 965 ? "入厂煤" : "其他物资"
});
}
else
{
cmcsAutotruck.CarNumber = qgc_chlgl.Chph;
cmcsAutotruck.EPCCardId = qgc_chlgl.Rfid_xlh;
cmcsAutotruck.CarMaxWeight = qgc_chlgl.Hzl;
cmcsAutotruck.Is_hmd = qgc_chlgl.Is_hmd;
cmcsAutotruck.BX_EndDate = qgc_chlgl.Bx_enddate;
cmcsAutotruck.Xshzh_EndDate = qgc_chlgl.Xshzh_enddate;
cmcsAutotruck.Zgzh_EndDate = qgc_chlgl.Zgzh_enddate;
cmcsAutotruck.IsUse = 1;
cmcsAutotruck.CarType = qgc_chlgl.Cllx == 965 ? "入厂煤" : "其他物资";
commonDAO.SelfDber.Update(cmcsAutotruck);
}
res++;
}
}
catch (Exception ex)
{
output("同步车辆基本信息报错，" + ex.Message, eOutputType.Error);
}
output(string.Format("同步车辆基本信息{0}条", res), eOutputType.Normal);
}
private void btnXExport_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("sheet1");
if (this.listCount.Count == 0)
{
MessageBox.Show("请先查询数据", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (folderBrowserDialog1.ShowDialog() != DialogResult.OK)
{
return;
}
for (int i = 0; i < listCount.Count; i++)
{
CmcsBuyFuelTransport entity = listCount[i];
CmcsAutotruck autoTruck = Dbers.GetInstance().SelfDber.Get <CmcsAutotruck>(entity.AutotruckId);
if (entity.CarNumber == "合计")
{
continue;
}
Mysheet1(sheetl, i + 2, 0, entity.CarNumber);
Mysheet1(sheetl, i + 2, 1, entity.InFactoryTime.ToString("yyyy-MM-dd HH:mm:ss"));
Mysheet1(sheetl, i + 2, 2, entity.TareTime.ToString("yyyy-MM-dd HH:mm:ss"));
Mysheet1(sheetl, i + 2, 3, autoTruck != null ? autoTruck.EmissionStandard : "");
sheetl.GetRow(i + 2).Height = sheetl.GetRow(1).Height;
sheetl.GetRow(i + 3).GetCell(0).CellStyle = sheetl.GetRow(2).GetCell(0).CellStyle;
sheetl.GetRow(i + 3).GetCell(1).CellStyle = sheetl.GetRow(2).GetCell(1).CellStyle;
sheetl.GetRow(i + 3).GetCell(2).CellStyle = sheetl.GetRow(2).GetCell(2).CellStyle;
sheetl.GetRow(i + 3).GetCell(3).CellStyle = sheetl.GetRow(2).GetCell(3).CellStyle;
sheetl.GetRow(i + 3).GetCell(4).CellStyle = sheetl.GetRow(2).GetCell(4).CellStyle;
sheetl.GetRow(i + 3).GetCell(5).CellStyle = sheetl.GetRow(2).GetCell(5).CellStyle;
sheetl.GetRow(i + 3).GetCell(6).CellStyle = sheetl.GetRow(2).GetCell(6).CellStyle;
sheetl.GetRow(i + 3).GetCell(7).CellStyle = sheetl.GetRow(2).GetCell(7).CellStyle;
sheetl.GetRow(i + 3).GetCell(8).CellStyle = sheetl.GetRow(2).GetCell(8).CellStyle;
}
sheetl.ForceFormulaRecalculation = true;
string fileName = "入厂煤车辆出入厂记录_" + dtpStartTime.Value.ToString("yyyy-MM-dd") + ".xls";
GC.Collect();
FileStream fs = File.OpenWrite(folderBrowserDialog1.SelectedPath + "\\" + fileName);
hssfworkbook.Write(fs); //向打开的这个xls文件中写入表并保存。
fs.Close();
MessageBox.Show("导出成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnSelectAutotruck_BuyFuel_Click(object sender, EventArgs e)
{
FrmAutotruck_Select frm = new FrmAutotruck_Select("and CarType='" + eCarType.入厂煤.ToString() + "' and IsUse=1 order by CarNumber asc");
if (frm.ShowDialog() == DialogResult.OK)
{
CmcsAutotruck = frm.Output;
txt_CarNumber.Text = frm.Output.CarNumber;
}
}
/// <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);
}
/// <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);
}
private void buttonX1_Click(object sender, EventArgs e)
{
// 发送到页面
cefWebBrowser.Browser.GetMainFrame().ExecuteJavaScript("testColor();", "", 0);
CmcsAutotruck autotruck = CommonDAO.GetInstance().GetAutotruckByCarNumber("鄂ATM168");
Bitmap res = new Bitmap(CMCS.Monitor.Win.Properties.Resources.Autotruck);
PreviewCarBmp carBmp = new PreviewCarBmp(autotruck);
Bitmap bmp = carBmp.GetPreviewBitmap(res, 249, 130);
bmp.Save("Autotruck.bmp");
}
/// <summary>
/// 预览车辆拉筋信息图
/// </summary>
/// <param name="autotruck"></param>
private bool PreviewCarCarriage(CmcsAutotruck autotruck, string sampler)
{
if (autotruck != null && autotruck.CarriageLength > 0 && autotruck.CarriageWidth > 0)
{
Bitmap res = new Bitmap(CMCS.Monitor.Win.Properties.Resources.Autotruck);
PreviewCarBmp carBmp = new PreviewCarBmp(autotruck);
Bitmap bmp = carBmp.GetPreviewBitmap(res, 249, 130);
bmp.Save("Autotruck_" + sampler + ".bmp");
return(true);
}
return(false);
}
/// <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="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);
}
}
void Return()
{
GridRow gridRow = superGridControl1.PrimaryGrid.ActiveRow as GridRow;
if (gridRow == null)
{
return;
}
this.Output = (gridRow.DataItem as CmcsAutotruck);
this.DialogResult = DialogResult.OK;
this.Close();
}
private void superGridControl1_DataBindingComplete(object sender, DevComponents.DotNetBar.SuperGrid.GridDataBindingCompleteEventArgs e)
{
foreach (GridRow gridRow in e.GridPanel.Rows)
{
CmcsAutotruck entity = gridRow.DataItem as CmcsAutotruck;
if (entity == null)
{
return;
}
// 填充有效状态
gridRow.Cells["clmIsUse"].Value = (entity.IsUse == 1 ? "是" : "否");
}
}
/// <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="autotruck"></param>
private bool PreviewCarCarriage(CmcsAutotruck autotruck)
{
if (autotruck != null && autotruck.CarriageLength > 0 && autotruck.CarriageWidth > 0)
{
Bitmap res = new Bitmap(CMCS.Monitor.Win.Properties.Resources.Autotruck);
PreviewCarBmp carBmp = new PreviewCarBmp(autotruck);
Bitmap bmp = carBmp.GetPreviewBitmap(res, 249, 130);
bmp.Save("Web/CarSampler/Resources/images/Autotruck.png");
pbxAutotruck.Image = bmp;
return(true);
}
return(false);
}
public FrmCarManage_Confirm(string transportId)
{
InitializeComponent();
LoadIsUse();
this.transportId = transportId;
CmcsAutotruck entity = commonDAO.SelfDber.Get <CmcsAutotruck>(this.transportId);
if (entity != null)
{
txtCarNum.Text = entity.CarNumber;
txtDriver.Text = entity.Driver;
txtCellPhoneNumber.Text = entity.CellPhoneNumber;
if (entity.IsUse == 0)
{
ddlIsUse.SelectedIndex = 1;
}
else if (entity.IsUse == 1)
{
ddlIsUse.SelectedIndex = 0;
}
else
{
ddlIsUse.SelectedIndex = 2;
}
((ComboBoxItem)ddlIsUse.SelectedItem).Name = entity.IsUse.ToString();
txtCarriageLength.Text = entity.CarriageLength.ToString();
txtCarriageWidth.Text = entity.CarriageWidth.ToString();
txtCarriageBottomToFloor.Text = entity.CarriageBottomToFloor.ToString();
txtLeftObstacle1.Text = entity.LeftObstacle1.ToString();
txtLeftObstacle2.Text = entity.LeftObstacle2.ToString();
txtLeftObstacle3.Text = entity.LeftObstacle3.ToString();
txtLeftObstacle4.Text = entity.LeftObstacle4.ToString();
txtLeftObstacle5.Text = entity.LeftObstacle5.ToString();
txtLeftObstacle6.Text = entity.LeftObstacle6.ToString();
txtRightObstacle1.Text = entity.RightObstacle1.ToString();
txtRightObstacle2.Text = entity.RightObstacle2.ToString();
txtRightObstacle3.Text = entity.RightObstacle3.ToString();
txtRightObstacle4.Text = entity.RightObstacle4.ToString();
txtRightObstacle5.Text = entity.RightObstacle5.ToString();
txtRightObstacle6.Text = entity.RightObstacle6.ToString();
txt_ReMark.Text = entity.ReMark;
}
}
private void FrmAutotruck_Oper_Load(object sender, EventArgs e)
{
cmb_CarType.Items.Add("入厂煤");
cmb_CarType.Items.Add("其他物资");
cmb_CarType.Items.Add("来访车辆");
cmb_CarType.SelectedIndex = 0;
cmbEmissionStandard.Items.Add("国III");
cmbEmissionStandard.Items.Add("国IV");
cmbEmissionStandard.Items.Add("国V");
cmbEmissionStandard.Items.Add("国VI");
cmbEmissionStandard.Items.Add("新能源");
cmbEmissionStandard.SelectedIndex = 0;
if (!String.IsNullOrEmpty(id))
{
this.cmcsAutotruck = Dbers.GetInstance().SelfDber.Get <CmcsAutotruck>(this.id);
txt_CarNumber.Text = cmcsAutotruck.CarNumber;
cmb_CarType.SelectedItem = cmcsAutotruck.CarType;
cmbEmissionStandard.SelectedItem = cmcsAutotruck.EmissionStandard;
txt_Driver.Text = cmcsAutotruck.Driver;
txt_CellPhoneNumber.Text = cmcsAutotruck.CellPhoneNumber;
chb_IsUse.Checked = (cmcsAutotruck.IsUse == 1);
dbi_LeftObstacle1.Value = cmcsAutotruck.LeftObstacle1;
dbi_LeftObstacle2.Value = cmcsAutotruck.LeftObstacle2;
dbi_LeftObstacle3.Value = cmcsAutotruck.LeftObstacle3;
dbi_LeftObstacle4.Value = cmcsAutotruck.LeftObstacle4;
dbi_LeftObstacle5.Value = cmcsAutotruck.LeftObstacle5;
dbi_LeftObstacle6.Value = cmcsAutotruck.LeftObstacle6;
dbi_RightObstacle1.Value = cmcsAutotruck.RightObstacle1;
dbi_RightObstacle2.Value = cmcsAutotruck.RightObstacle2;
dbi_RightObstacle3.Value = cmcsAutotruck.RightObstacle3;
dbi_RightObstacle4.Value = cmcsAutotruck.RightObstacle4;
dbi_RightObstacle5.Value = cmcsAutotruck.RightObstacle5;
dbi_RightObstacle6.Value = cmcsAutotruck.RightObstacle6;
dbi_CarriageLength.Value = cmcsAutotruck.CarriageLength;
dbi_CarriageWidth.Value = cmcsAutotruck.CarriageWidth;
dbi_CarriageBottomToFloor.Value = cmcsAutotruck.CarriageBottomToFloor;
dbi_CarriageLength2.Value = cmcsAutotruck.CarriageLength2;
dbi_CarriageBottomToFloor2.Value = cmcsAutotruck.CarriageBottomToFloor2;
txt_ReMark.Text = cmcsAutotruck.ReMark;
cmcsEPCCard = Dbers.GetInstance().SelfDber.Get <CmcsEPCCard>(cmcsAutotruck.EPCCardId);
txt_EPCCardNumber.Text = cmcsEPCCard.CardNumber;
}
if (!edit)
{
btnSubmit.Enabled = false;
CMCS.CarTransport.Queue.Utilities.Helper.ControlReadOnly(panelEx2);
}
label_warn.ForeColor = Color.Red;
}
private void superGridControl1_DataBindingComplete(object sender, DevComponents.DotNetBar.SuperGrid.GridDataBindingCompleteEventArgs e)
{
foreach (GridRow gridRow in e.GridPanel.Rows)
{
CmcsAutotruck entity = gridRow.DataItem as CmcsAutotruck;
if (entity == null)
{
return;
}
// 填充有效状态
gridRow.Cells["clmIsUse"].Value = (entity.IsUse == 1 ? "是" : "否");
gridRow.Cells["clmCardNumber"].Value = Dbers.GetInstance().SelfDber.Get <CmcsEPCCard>(entity.EPCCardId).CardNumber;
}
}
private void superGridControl1_DataBindingComplete(object sender, DevComponents.DotNetBar.SuperGrid.GridDataBindingCompleteEventArgs e)
{
foreach (GridRow item in e.GridPanel.Rows)
{
try
{
CmcsAutotruck CmcsAutotruck = item.DataItem as CmcsAutotruck;
item.Cells["cellIsUse"].Value = CmcsAutotruck.IsUse == 1 ? "有效" : (CmcsAutotruck.IsUse == -1 ? "黑名单" : "无效");
}
catch (Exception)
{
}
}
}
