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