private void superGridControl1_CellMouseDown(object sender, DevComponents.DotNetBar.SuperGrid.GridCellMouseEventArgs e)
{
CmcsBuyFuelTransportDeduct entity = cmcsbuyfueltransportdeducts.Where(a => a.Id == superGridControl1.PrimaryGrid.GetCell(e.GridCell.GridRow.Index, superGridControl1.PrimaryGrid.Columns["clmId"].ColumnIndex).Value.ToString()).FirstOrDefault();
switch (superGridControl1.PrimaryGrid.Columns[e.GridCell.ColumnIndex].Name)
{
case "clmShow":
FrmBuyFuelTransportDeduct_Oper frmShow = new FrmBuyFuelTransportDeduct_Oper(entity.Id, cmcsBuyFuelTransport.Id, false, cmcsbuyfueltransportdeducts);
if (frmShow.ShowDialog() == DialogResult.OK)
{
superGridControl1.PrimaryGrid.DataSource = cmcsbuyfueltransportdeducts;
dbi_DeductWeight.Value = (double)cmcsbuyfueltransportdeducts.Select(a => a.DeductWeight).Sum();
}
break;
case "clmEdit":
FrmBuyFuelTransportDeduct_Oper frmEdit = new FrmBuyFuelTransportDeduct_Oper(entity.Id, cmcsBuyFuelTransport.Id, true, cmcsbuyfueltransportdeducts);
if (frmEdit.ShowDialog() == DialogResult.OK)
{
cmcsbuyfueltransportdeducts = cmcsbuyfueltransportdeducts.Where(a => a.Id != frmEdit.cmcsBuyFuelTransportDeduct.Id).ToList();
cmcsbuyfueltransportdeducts.Add(frmEdit.cmcsBuyFuelTransportDeduct);
superGridControl1.PrimaryGrid.DataSource = cmcsbuyfueltransportdeducts;
dbi_DeductWeight.Value = (double)cmcsbuyfueltransportdeducts.Select(a => a.DeductWeight).Sum();
}
break;
case "clmDelete":
cmcsbuyfueltransportdeducts = cmcsbuyfueltransportdeducts.Where(a => a.Id != entity.Id).ToList();
superGridControl1.PrimaryGrid.DataSource = cmcsbuyfueltransportdeducts;
dbi_DeductWeight.Value = (double)cmcsbuyfueltransportdeducts.Select(a => a.DeductWeight).Sum();
CommonDAO.GetInstance().SelfDber.Delete <CmcsBuyFuelTransportDeduct>(entity.Id);
break;
}
}
private void superGridControl1_CellMouseDown(object sender, DevComponents.DotNetBar.SuperGrid.GridCellMouseEventArgs e)
{
CmcsBuyFuelTransportDeduct entity = cmcsbuyfueltransportdeducts.Where(a => a.Id == superGridControl1.PrimaryGrid.GetCell(e.GridCell.GridRow.Index, superGridControl1.PrimaryGrid.Columns["clmId"].ColumnIndex).Value.ToString()).FirstOrDefault();
switch (superGridControl1.PrimaryGrid.Columns[e.GridCell.ColumnIndex].Name)
{
case "clmShow":
FrmBuyFuelTransportDeduct_Oper frmShow = new FrmBuyFuelTransportDeduct_Oper(entity.Id, eEditMode.查看);
if (frmShow.ShowDialog() == DialogResult.OK)
{
ShowDeduct(this.CmcsBuyFuelTransport.Id);
}
break;
case "clmEdit":
FrmBuyFuelTransportDeduct_Oper frmEdit = new FrmBuyFuelTransportDeduct_Oper(entity.Id, eEditMode.修改);
if (frmEdit.ShowDialog() == DialogResult.OK)
{
ShowDeduct(this.CmcsBuyFuelTransport.Id);
}
break;
case "clmDelete":
if (MessageBoxEx.Show("确定删除扣吨记录！", "操作提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Asterisk) == System.Windows.Forms.DialogResult.OK)
{
Dbers.GetInstance().SelfDber.Delete <CmcsBuyFuelTransportDeduct>(entity.Id);
ShowDeduct(this.CmcsBuyFuelTransport.Id);
}
break;
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
if (dbi_DeductWeight.Value == 0)
{
MessageBoxEx.Show("扣重不能为0！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (cmcsBuyFuelTransportDeduct != null)
{
cmcsBuyFuelTransportDeduct.DeductWeight = (decimal)dbi_DeductWeight.Value;
cmcsBuyFuelTransportDeduct.DeductType = (string)cmb_DeductType.SelectedItem;
cmcsBuyFuelTransportDeduct.OperDate = DateTime.Now;
cmcsBuyFuelTransportDeduct.OperUser = SelfVars.LoginUser.UserName;
}
else
{
cmcsBuyFuelTransportDeduct = new CmcsBuyFuelTransportDeduct();
cmcsBuyFuelTransportDeduct.DeductWeight = (decimal)dbi_DeductWeight.Value;
cmcsBuyFuelTransportDeduct.DeductType = (string)cmb_DeductType.SelectedItem;
cmcsBuyFuelTransportDeduct.OperDate = dtnow;
cmcsBuyFuelTransportDeduct.OperUser = SelfVars.LoginUser.UserName;
}
this.DialogResult = DialogResult.OK;
this.Close();
}
void SaveAndUpdate(CmcsBuyFuelTransport item, List <CmcsBuyFuelTransportDeduct> details)
{
List <CmcsBuyFuelTransportDeduct> olds = Dbers.GetInstance().SelfDber.Entities <CmcsBuyFuelTransportDeduct>(" where TransportId=:TransportId", new { TransportId = item.Id });
foreach (CmcsBuyFuelTransportDeduct old in olds)
{
CmcsBuyFuelTransportDeduct del = details.Where(a => a.Id == old.Id).FirstOrDefault();
if (del == null)
{
Dbers.GetInstance().SelfDber.Delete <CmcsBuyFuelTransportDeduct>(old.Id);
}
}
foreach (var detail in details)
{
detail.TransportId = item.Id;
CmcsBuyFuelTransportDeduct insertorupdate = olds.Where(a => a.Id == detail.Id).FirstOrDefault();
if (insertorupdate == null)
{
Dbers.GetInstance().SelfDber.Insert(detail);
}
else
{
Dbers.GetInstance().SelfDber.Update(detail);
}
}
List <CmcsBuyFuelTransportDeduct> news = Dbers.GetInstance().SelfDber.Entities <CmcsBuyFuelTransportDeduct>(" where TransportId=:TransportId", new { TransportId = item.Id });
if (news != null && news.Count > 0)
{
item.DeductWeight = news.Sum(a => a.DeductWeight);
//Dbers.GetInstance().SelfDber.Update(item);
}
}
/// <summary>
/// 保存数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSubmit_Click(object sender, EventArgs e)
{
if (dbi_DeductWeight.Value == 0)
{
MessageBoxEx.Show("扣重不能为0！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (this.EditMode == eEditMode.修改)
{
CmcsBuyFuelTransportDeduct.DeductWeight = (decimal)dbi_DeductWeight.Value;
CmcsBuyFuelTransportDeduct.DeductType = (string)cmb_DeductType.SelectedItem;
CmcsBuyFuelTransportDeduct.OperDate = DateTime.Now;
CmcsBuyFuelTransportDeduct.OperUser = GlobalVars.LoginUser.UserName;
Dbers.GetInstance().SelfDber.Update(CmcsBuyFuelTransportDeduct);
}
else if (this.EditMode == eEditMode.新增)
{
CmcsBuyFuelTransportDeduct = new CmcsBuyFuelTransportDeduct();
CmcsBuyFuelTransportDeduct.TransportId = this.PId;
CmcsBuyFuelTransportDeduct.DeductWeight = (decimal)dbi_DeductWeight.Value;
CmcsBuyFuelTransportDeduct.DeductType = (string)cmb_DeductType.SelectedItem;
Dbers.GetInstance().SelfDber.Insert(CmcsBuyFuelTransportDeduct);
}
this.DialogResult = DialogResult.OK;
this.Close();
}
/// <summary>
/// 窗体加载绑定数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void FrmBuyFuelTransportDeduct_Oper_Load(object sender, EventArgs e)
{
cmb_DeductType.Items.Add("扣矸");
cmb_DeductType.Items.Add("扣水");
cmb_DeductType.Items.Add("其他");
cmb_DeductType.SelectedIndex = 0;
if (this.EditMode == eEditMode.修改)
{
this.CmcsBuyFuelTransportDeduct = Dbers.GetInstance().SelfDber.Get <CmcsBuyFuelTransportDeduct>(this.PId);
if (CmcsBuyFuelTransportDeduct != null)
{
cmb_DeductType.SelectedItem = CmcsBuyFuelTransportDeduct.DeductType;
dbi_DeductWeight.Value = (double)CmcsBuyFuelTransportDeduct.DeductWeight;
txt_OperUser.Text = CmcsBuyFuelTransportDeduct.OperUser;
txt_OperDate.Text = CmcsBuyFuelTransportDeduct.OperDate.ToString();
}
}
if (this.EditMode == eEditMode.查看)
{
btnSubmit.Enabled = false;
HelperUtil.ControlReadOnly(panelEx2, true);
}
}
private void FrmBuyFuelTransportDeduct_Oper_Load(object sender, EventArgs e)
{
cmb_DeductType.Items.Add("扣矸");
cmb_DeductType.Items.Add("扣水");
cmb_DeductType.Items.Add("其他");
cmb_DeductType.SelectedIndex = 0;
if (!String.IsNullOrEmpty(id))
{
this.cmcsBuyFuelTransportDeduct = cmcsbuyfueltransportdeducts.Where(a => a.Id == id).First();
dbi_DeductWeight.Value = (double)cmcsBuyFuelTransportDeduct.DeductWeight;
txt_OperUser.Text = cmcsBuyFuelTransportDeduct.OperUser;
cmb_DeductType.SelectedItem = cmcsBuyFuelTransportDeduct.DeductType;
txt_OperDate.Text = cmcsBuyFuelTransportDeduct.OperDate.ToString();
}
else
{
txt_OperDate.Text = dtnow.ToString();
txt_OperUser.Text = SelfVars.LoginUser.UserName;
}
if (!edit)
{
btnSubmit.Enabled = false;
}
}
/// <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.GrossWeight = weight;
transport.GrossPlace = place;
transport.GrossTime = dt;
CmcsInNetTransport inNetTransport = SelfDber.Get <CmcsInNetTransport>(transport.OutNetTransportId);
if (inNetTransport != null)
{
inNetTransport.StepName = eTruckInFactoryStep.重车.ToString();
SelfDber.Update(inNetTransport);
}
}
else if (transport.StepName == eTruckInFactoryStep.重车.ToString())
{
transport.StepName = eTruckInFactoryStep.轻车.ToString();
transport.TareWeight = weight;
transport.TarePlace = place;
transport.TareTime = dt;
transport.OutFactoryTime = dt;
CmcsInNetTransport inNetTransport = SelfDber.Get <CmcsInNetTransport>(transport.OutNetTransportId);
if (inNetTransport != null)
{
inNetTransport.StepName = eTruckInFactoryStep.轻车.ToString();
inNetTransport.IsFinish = 1;
SelfDber.Update(inNetTransport);
}
//扣吨量
transport.DeductWeight = GetDeductWeightWithOutAuto(transport.Id);
transport.SuttleWeight = transport.GrossWeight - transport.TareWeight - transport.DeductWeight;
if (transport.GrossWeight > 0 && transport.TareWeight > 0)
{
if (transport.TheMine.PurcHaseType == "地方煤")
{
transport.TicketWeight = transport.SuttleWeight;
}
else if (transport.TheMine.PurcHaseType == "厂矿直供" && transport.TicketWeight > 0 && transport.TicketWeight <= (transport.GrossWeight - transport.TareWeight))
{
CmcsBuyFuelTransportDeduct deduct = commonDAO.SelfDber.Entity <CmcsBuyFuelTransportDeduct>("where TransportId=:TransportId and DeductType = '磅差'", new { TransportId = transport.Id });
decimal KgWeight = transport.GrossWeight - transport.TareWeight - transport.TicketWeight + 0.1m;
transport.SuttleWeight = transport.TicketWeight - 0.1m - transport.DeductWeight;
if (deduct == null)
{
deduct = new CmcsBuyFuelTransportDeduct();
deduct.TransportId = transport.Id;
deduct.DeductType = "磅差";
deduct.DeductWeight = KgWeight;
Dbers.GetInstance().SelfDber.Insert(deduct);
}
else if (deduct != null && deduct.DeductWeight != KgWeight)
{
deduct.DeductWeight = KgWeight;
Dbers.GetInstance().SelfDber.Update(deduct);
}
transport.DeductWeight += KgWeight;
}
}
// 回皮即完结
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="sender"></param>
/// <param name="e"></param>
private void btnSubmit_Click(object sender, EventArgs e)
{
if (this.EditMode == eEditMode.修改)
{
CmcsBuyFuelTransport.SerialNumber = txt_SerialNumber.Text;
CmcsBuyFuelTransport.CarNumber = txt_CarNumber.Text;
if (cmcsSupplier != null)
{
CmcsBuyFuelTransport.SupplierId = cmcsSupplier.Id;
CmcsBuyFuelTransport.SupplierName = cmcsSupplier.Name;
}
if (cmcsTransportCompany != null)
{
CmcsBuyFuelTransport.TransportCompanyId = cmcsTransportCompany.Id;
CmcsBuyFuelTransport.TransportCompanyName = cmcsTransportCompany.Name;
}
if (cmcsMine != null)
{
CmcsBuyFuelTransport.MineId = cmcsMine.Id;
CmcsBuyFuelTransport.MineName = cmcsMine.Name;
}
if (cmcsFuelKind != null)
{
CmcsBuyFuelTransport.FuelKindId = cmcsFuelKind.Id;
CmcsBuyFuelTransport.FuelKindName = cmcsFuelKind.Name;
}
CmcsBuyFuelTransport.TicketWeight = (decimal)dbi_TicketWeight.Value;
CmcsBuyFuelTransport.GrossWeight = (decimal)dbi_GrossWeight.Value;
CmcsBuyFuelTransport.DeductWeight = (decimal)dbi_DeductWeight.Value;
CmcsBuyFuelTransport.TareWeight = (decimal)dbi_TareWeight.Value;
CmcsBuyFuelTransport.SuttleWeight = (decimal)dbi_SuttleWeight.Value;
CmcsBuyFuelTransport.Remark = txt_Remark.Text;
CmcsBuyFuelTransport.IsFinish = (chb_IsFinish.Checked ? 1 : 0);
CmcsBuyFuelTransport.IsUse = (chb_IsUse.Checked ? 1 : 0);
CmcsBuyFuelTransport.StepName = cmbStepName.Text;
CmcsUnFinishTransport unfinishTransport = Dbers.GetInstance().SelfDber.Entity <CmcsUnFinishTransport>(" where TransportId= '" + CmcsBuyFuelTransport.Id + "'");
//有效并且未完成时需要存在[未完成运输记录]
if (chb_IsUse.Checked && !chb_IsFinish.Checked)
{
if (unfinishTransport == null)
{
unfinishTransport = new CmcsUnFinishTransport()
{
TransportId = CmcsBuyFuelTransport.Id,
CarType = eCarType.入厂煤.ToString(),
AutotruckId = CmcsBuyFuelTransport.AutotruckId,
PrevPlace = CommonAppConfig.GetInstance().AppIdentifier
};
Dbers.GetInstance().SelfDber.Insert(unfinishTransport);
}
}
//无效或者是完成时需要删除[未完成运输记录]
if (!chb_IsUse.Checked || chb_IsFinish.Checked)
{
if (unfinishTransport != null)
{
Dbers.GetInstance().SelfDber.Delete <CmcsUnFinishTransport>(unfinishTransport.Id);
}
}
// 生成批次以及采制化三级编码数据
CmcsInFactoryBatch inFactoryBatch = carTransportDAO.GCQCInFactoryBatchByBuyFuelTransport(CmcsBuyFuelTransport);
if (inFactoryBatch != null)
{
//扣吨量
CmcsBuyFuelTransport.DeductWeight = WeighterDAO.GetInstance().GetDeductWeightWithOutAuto(CmcsBuyFuelTransport.Id);
if (CmcsBuyFuelTransport.GrossWeight > 0 && CmcsBuyFuelTransport.TareWeight > 0)
{
CmcsBuyFuelTransport.SuttleWeight = CmcsBuyFuelTransport.GrossWeight - CmcsBuyFuelTransport.TareWeight - CmcsBuyFuelTransport.DeductWeight;
if (CmcsBuyFuelTransport.TheMine.PurcHaseType == "地方煤")
{
CmcsBuyFuelTransport.TicketWeight = CmcsBuyFuelTransport.SuttleWeight;
}
else if (CmcsBuyFuelTransport.TheMine.PurcHaseType == "厂矿直供" && CmcsBuyFuelTransport.TicketWeight > 0 && CmcsBuyFuelTransport.TicketWeight <= (CmcsBuyFuelTransport.GrossWeight - CmcsBuyFuelTransport.TareWeight))
{
CmcsBuyFuelTransportDeduct deduct = commonDAO.SelfDber.Entity <CmcsBuyFuelTransportDeduct>("where TransportId=:TransportId and DeductType = '磅差'", new { TransportId = CmcsBuyFuelTransport.Id });
decimal KgWeight = CmcsBuyFuelTransport.GrossWeight - CmcsBuyFuelTransport.TareWeight - CmcsBuyFuelTransport.TicketWeight + 0.1m;
CmcsBuyFuelTransport.SuttleWeight = CmcsBuyFuelTransport.TicketWeight - 0.1m - CmcsBuyFuelTransport.DeductWeight;
if (deduct == null)
{
deduct = new CmcsBuyFuelTransportDeduct();
deduct.TransportId = CmcsBuyFuelTransport.Id;
deduct.DeductType = "磅差";
deduct.DeductWeight = KgWeight;
Dbers.GetInstance().SelfDber.Insert(deduct);
}
else if (deduct != null && deduct.DeductWeight != KgWeight)
{
deduct.DeductWeight = KgWeight;
Dbers.GetInstance().SelfDber.Update(deduct);
}
CmcsBuyFuelTransport.DeductWeight += KgWeight;
}
}
CmcsBuyFuelTransport.IsSyncBatch = 0;
Dbers.GetInstance().SelfDber.Update(CmcsBuyFuelTransport, GlobalVars.LoginUser != null ? GlobalVars.LoginUser.UserName : "******");
}
}
this.DialogResult = DialogResult.OK;
this.Close();
}
