private void btnSubmit_Click(object sender, EventArgs e)
{
if (txt_SerialNumber.Text.Length == 0)
{
MessageBoxEx.Show("该标车牌号不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
if ((cmcsVisitTransport == null || cmcsVisitTransport.CarNumber != txt_SerialNumber.Text) && Dbers.GetInstance().SelfDber.Entities <CmcsVisitTransport>(" where CarNumber=:CarNumber", new { CarNumber = txt_SerialNumber.Text }).Count > 0)
{
MessageBoxEx.Show("该标车牌号不可重复！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (cmcsVisitTransport != null)
{
cmcsVisitTransport.Remark = txt_Remark.Text;
cmcsVisitTransport.IsFinish = (chb_IsFinish.Checked ? 1 : 0);
Dbers.GetInstance().SelfDber.Update(cmcsVisitTransport);
}
else
{
cmcsVisitTransport = new CmcsVisitTransport();
cmcsVisitTransport.Remark = txt_Remark.Text;
cmcsVisitTransport.IsFinish = (chb_IsFinish.Checked ? 1 : 0);
Dbers.GetInstance().SelfDber.Insert(cmcsVisitTransport);
}
this.DialogResult = DialogResult.OK;
this.Close();
}
private void dataGridViewX1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == -1 || e.RowIndex == -1)
{
return;
}
CmcsVisitTransport entity = Dbers.GetInstance().SelfDber.Get <CmcsVisitTransport>(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 <CmcsVisitTransport>(entity.Id);
BindData();
}
else
{
MessageBoxEx.Show("该记录正在使用中，禁止删除！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
break;
}
}
/// <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);
}
private void superGridControl1_CellMouseDown(object sender, DevComponents.DotNetBar.SuperGrid.GridCellMouseEventArgs e)
{
CmcsVisitTransport entity = Dbers.GetInstance().SelfDber.Get <CmcsVisitTransport>(superGridControl1.PrimaryGrid.GetCell(e.GridCell.GridRow.Index, superGridControl1.PrimaryGrid.Columns["clmId"].ColumnIndex).Value.ToString());
switch (superGridControl1.PrimaryGrid.Columns[e.GridCell.ColumnIndex].Name)
{
case "clmShow":
FrmVisitTransport_Oper frmShow = new FrmVisitTransport_Oper(entity.Id, false);
if (frmShow.ShowDialog() == DialogResult.OK)
{
BindData();
}
break;
case "clmEdit":
FrmVisitTransport_Oper frmEdit = new FrmVisitTransport_Oper(entity.Id, true);
if (frmEdit.ShowDialog() == DialogResult.OK)
{
BindData();
}
break;
case "clmDelete":
// 查询正在使用该记录的车数
if (MessageBoxEx.Show("确定要删除该记录？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
Dbers.GetInstance().SelfDber.Delete <CmcsVisitTransport>(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;
}
}
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 superGridControl1_DataBindingComplete(object sender, DevComponents.DotNetBar.SuperGrid.GridDataBindingCompleteEventArgs e)
{
foreach (GridRow gridRow in e.GridPanel.Rows)
{
CmcsVisitTransport entity = gridRow.DataItem as CmcsVisitTransport;
if (entity == null)
{
return;
}
// 填充有效状态
gridRow.Cells["clmOutFactoryTime"].Value = entity.OutFactoryTime.Year == 1 ? "" : entity.OutFactoryTime.ToString();
}
}
/// <summary>
/// 保存来访车辆运输记录
/// </summary>
/// <param name="transportId"></param>
/// <param name="dt"></param>
/// <returns></returns>
public bool SaveVisitTransport(string transportId, DateTime dt)
{
CmcsVisitTransport transport = SelfDber.Get <CmcsVisitTransport>(transportId);
if (transport == null)
{
return(false);
}
transport.StepName = eTruckInFactoryStep.出厂.ToString();
transport.OutFactoryTime = dt;
transport.IsFinish = 1;
return(SelfDber.Update(transport) > 0);
}
private void FrmVisitTransport_Oper_Load(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(id))
{
this.cmcsVisitTransport = Dbers.GetInstance().SelfDber.Get <CmcsVisitTransport>(this.id);
txt_SerialNumber.Text = cmcsVisitTransport.SerialNumber;
txt_CarNumber.Text = cmcsVisitTransport.CarNumber;
txt_InFactoryTime.Text = cmcsVisitTransport.InFactoryTime.Year == 1 ? "" : cmcsVisitTransport.InFactoryTime.ToString();
txt_OutFactoryTime.Text = cmcsVisitTransport.OutFactoryTime.Year == 1 ? "" : cmcsVisitTransport.OutFactoryTime.ToString();
txt_Remark.Text = cmcsVisitTransport.Remark;
chb_IsFinish.Checked = (cmcsVisitTransport.IsFinish == 1);
}
if (!edit)
{
btnSubmit.Enabled = false;
CMCS.CarTransport.Queue.Utilities.Helper.ControlReadOnly(panelEx2);
}
}
/// <summary>
/// 更改来访车辆运输记录的无效状态
/// </summary>
/// <param name="transportId"></param>
/// <param name="isValid">是否有效</param>
/// <returns></returns>
public bool ChangeVisitTransportToInvalid(string transportId, bool isValid)
{
if (isValid)
{
// 设置为有效
CmcsVisitTransport buyFuelTransport = SelfDber.Get <CmcsVisitTransport>(transportId);
if (buyFuelTransport != null)
{
if (SelfDber.Execute("update " + EntityReflectionUtil.GetTableName <CmcsVisitTransport>() + " set IsUse=1 where Id=:Id", new { Id = transportId }) > 0)
{
if (buyFuelTransport.IsFinish == 0)
{
SelfDber.Insert(new CmcsUnFinishTransport
{
AutotruckId = buyFuelTransport.AutotruckId,
CarType = eCarType.来访车辆.ToString(),
TransportId = buyFuelTransport.Id,
PrevPlace = "未知"
});
}
return(true);
}
}
}
else
{
// 设置为无效
if (SelfDber.Execute("update " + EntityReflectionUtil.GetTableName <CmcsVisitTransport>() + " set IsUse=0 where Id=:Id", new { Id = transportId }) > 0)
{
SelfDber.DeleteBySQL <CmcsUnFinishTransport>("where TransportId=:TransportId", new { TransportId = transportId });
return(true);
}
}
return(false);
}
/// <summary>
/// 生成运输记录流水号
/// </summary>
/// <param name="carType">车类型</param>
/// <param name="dt"></param>
/// <returns></returns>
public string CreateNewTransportSerialNumber(eTransportType carType, DateTime dt)
{
string prefix = "Null";
if (carType == eTransportType.原料煤入场)
{
prefix = "YLMRC";
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 == eTransportType.仓储煤入场)
{
prefix = "CCMRC";
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 == eTransportType.中转煤入场)
{
prefix = "ZZMRC";
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 == eTransportType.仓储煤出场)
{
prefix = "CCMCC";
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 == eTransportType.中转煤出场)
{
prefix = "ZZMCC";
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 == eTransportType.销售直销煤 || carType == eTransportType.销售掺配煤)
{
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 == eTransportType.其他物资)
{
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'));
}
}
else if (carType == eTransportType.来访车辆)
{
prefix = "LF";
CmcsVisitTransport entity = SelfDber.Entity <CmcsVisitTransport>("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'));
}
