private void dataGridViewX1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == -1 || e.RowIndex == -1)
{
return;
}
CmcsEPCCard entity = Dbers.GetInstance().SelfDber.Get <CmcsEPCCard>(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 <CmcsEPCCard>(entity.Id);
BindData();
}
else
{
MessageBoxEx.Show("该标签卡正在使用中，禁止删除！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
break;
}
}
private void FrmEPCCard_Select_KeyUp(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Escape)
{
this.Output = null;
this.DialogResult = DialogResult.Cancel;
this.Close();
}
}
private void btnSelectEPCCardNumber_Click(object sender, EventArgs e)
{
FrmEPCCard_Select Frm = new FrmEPCCard_Select(string.Empty);
Frm.ShowDialog();
if (Frm.DialogResult == DialogResult.OK)
{
cmcsEPCCard = Frm.Output;
txt_EPCCardNumber.Text = cmcsEPCCard.CardNumber;
}
}
/// <summary>
/// 根据标签卡号获取车辆信息
/// </summary>
/// <param name="carNumber"></param>
/// <returns></returns>
public CmcsAutotruck GetAutotruckByTagId(string tagId)
{
CmcsEPCCard ePCCard = SelfDber.Entity <CmcsEPCCard>("where TagId=:TagId", new { TagId = tagId });
if (ePCCard != null)
{
return(SelfDber.Entity <CmcsAutotruck>("where EPCCardId=:EPCCardId", new { EPCCardId = ePCCard.Id }));
}
return(null);
}
void Return()
{
GridRow gridRow = superGridControl1.PrimaryGrid.ActiveRow as GridRow;
if (gridRow == null)
{
return;
}
this.Output = (gridRow.DataItem as CmcsEPCCard);
this.DialogResult = DialogResult.OK;
this.Close();
}
private void FrmEPCCard_Oper_Load(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(id))
{
this.cmcsepccard = Dbers.GetInstance().SelfDber.Get <CmcsEPCCard>(this.id);
txt_CardNumber.Text = cmcsepccard.CardNumber;
txt_TagId.Text = cmcsepccard.TagId;
}
if (!edit)
{
btnSubmit.Enabled = false;
CMCS.CarTransport.Queue.Utilities.Helper.ControlReadOnly(panelEx2);
}
}
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;
}
/// <summary>
/// 窗体加载绑定数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void FrmEPCCard_Oper_Load(object sender, EventArgs e)
{
this.CmcsepcCard = Dbers.GetInstance().SelfDber.Get <CmcsEPCCard>(this.PId);
if (this.CmcsepcCard != null)
{
txt_CardNumber.Text = CmcsepcCard.CardNumber;
txt_TagId.Text = CmcsepcCard.TagId;
}
if (this.EditMode == eEditMode.查看)
{
btnSubmit.Enabled = false;
HelperUtil.ControlReadOnly(panelEx2, true);
}
}
private void timer1_Tick(object sender, EventArgs e)
{
timer1.Stop();
try
{
List <string> tags = Hardwarer.Rwer2.ScanTags();
if (tags.Count > 0)
{
string tagId = tags[0];
this.CmcsEPCCard = Dbers.GetInstance().SelfDber.Entity <CmcsEPCCard>("where TagId=:TagId", new { TagId = tagId });
}
}
catch { }
timer1.Start();
}
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 ? "是" : "否");
CmcsEPCCard cmcsEPCCard = Dbers.GetInstance().SelfDber.Get <CmcsEPCCard>(entity.EPCCardId);
gridRow.Cells["clmCardNumber"].Value = cmcsEPCCard == null ? "" : cmcsEPCCard.CardNumber;
}
}
private void superGridControl1_CellMouseDown(object sender, DevComponents.DotNetBar.SuperGrid.GridCellMouseEventArgs e)
{
CmcsEPCCard entity = Dbers.GetInstance().SelfDber.Get <CmcsEPCCard>(superGridControl1.PrimaryGrid.GetCell(e.GridCell.GridRow.Index, superGridControl1.PrimaryGrid.Columns["clmId"].ColumnIndex).Value.ToString());
switch (superGridControl1.PrimaryGrid.Columns[e.GridCell.ColumnIndex].Name)
{
case "clmShow":
FrmEPCCard_Oper frmShow = new FrmEPCCard_Oper(entity.Id, eEditMode.查看);
if (frmShow.ShowDialog() == DialogResult.OK)
{
BindData();
}
break;
case "clmEdit":
FrmEPCCard_Oper frmEdit = new FrmEPCCard_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 <CmcsEPCCard>(entity.Id);
}
catch (Exception)
{
MessageBoxEx.Show("该标签卡正在使用中，禁止删除！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
BindData();
}
break;
}
}
/// <summary>
/// 窗体加载绑定数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void FrmAutotruck_Oper_Load(object sender, EventArgs e)
{
label_warn.ForeColor = Color.Red;
cmb_CarType.Items.Add(eCarType.入厂煤.ToString());
cmb_CarType.Items.Add(eCarType.其他物资.ToString());
cmb_CarType.Items.Add(eCarType.转煤车辆.ToString());
cmb_CarType.SelectedIndex = 0;
this.CmcsAutotruck = Dbers.GetInstance().SelfDber.Get <CmcsAutotruck>(this.PId);
if (this.CmcsAutotruck != null)
{
txt_CarNumber.Text = CmcsAutotruck.CarNumber;
cmb_CarType.SelectedItem = CmcsAutotruck.CarType;
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_CarriageLength.Value = CmcsAutotruck.CarriageLength;
dbi_CarriageWidth.Value = CmcsAutotruck.CarriageWidth;
dbi_CarriageBottomToFloor.Value = CmcsAutotruck.CarriageBottomToFloor;
txt_ReMark.Text = CmcsAutotruck.ReMark;
this.CmcsEPCCard = Dbers.GetInstance().SelfDber.Get <CmcsEPCCard>(CmcsAutotruck.EPCCardId);
if (this.CmcsEPCCard != null)
{
txt_EPCCardNumber.Text = cmcsEPCCard.CardNumber;
}
}
if (this.EditMode == eEditMode.查看)
{
btnSubmit.Enabled = false;
HelperUtil.ControlReadOnly(panelEx2, true);
}
}
/// <summary>
/// 保存数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSubmit_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(txt_CardNumber.Text))
{
MessageBoxEx.Show("该标签卡号不能为空！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if ((CmcsepcCard == null || CmcsepcCard.CardNumber != txt_CardNumber.Text) && Dbers.GetInstance().SelfDber.Entities <CmcsEPCCard>(" where CardNumber=:CardNumber", new { CardNumber = txt_CardNumber.Text }).Count > 0)
{
MessageBoxEx.Show("该标签卡号不可重复！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (string.IsNullOrWhiteSpace(txt_TagId.Text))
{
MessageBoxEx.Show("该标签号不能为空！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if ((CmcsepcCard == null || CmcsepcCard.TagId != txt_TagId.Text) && Dbers.GetInstance().SelfDber.Entities <CmcsEPCCard>(" where TagId=:TagId", new { TagId = txt_TagId.Text }).Count > 0)
{
MessageBoxEx.Show("该标签号不可重复！", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (this.EditMode == eEditMode.修改)
{
CmcsepcCard.CardNumber = txt_CardNumber.Text;
CmcsepcCard.TagId = txt_TagId.Text;
Dbers.GetInstance().SelfDber.Update(CmcsepcCard);
}
else if (this.EditMode == eEditMode.新增)
{
CmcsepcCard = new CmcsEPCCard();
CmcsepcCard.CardNumber = txt_CardNumber.Text;
CmcsepcCard.TagId = txt_TagId.Text;
Dbers.GetInstance().SelfDber.Insert(CmcsepcCard);
}
this.DialogResult = DialogResult.OK;
this.Close();
}
private void btnSubmit_Click(object sender, EventArgs e)
{
if (txt_CardNumber.Text.Length == 0)
{
MessageBoxEx.Show("该标卡号不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
if (txt_TagId.Text.Length == 0)
{
MessageBoxEx.Show("该标签号不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
if ((cmcsepccard == null || cmcsepccard.CardNumber != txt_CardNumber.Text) && Dbers.GetInstance().SelfDber.Entities <CmcsEPCCard>(" where CardNumber=:CardNumber", new { CardNumber = txt_CardNumber.Text }).Count > 0)
{
MessageBoxEx.Show("该标卡号不可重复！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if ((cmcsepccard == null || cmcsepccard.TagId != txt_TagId.Text) && Dbers.GetInstance().SelfDber.Entities <CmcsEPCCard>(" where TagId=:TagId", new { TagId = txt_TagId.Text }).Count > 0)
{
MessageBoxEx.Show("该标签号不可重复！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (cmcsepccard != null)
{
cmcsepccard.CardNumber = txt_CardNumber.Text;
cmcsepccard.TagId = txt_TagId.Text;
Dbers.GetInstance().SelfDber.Update(cmcsepccard);
}
else
{
cmcsepccard = new CmcsEPCCard();
cmcsepccard.CardNumber = txt_CardNumber.Text;
cmcsepccard.TagId = txt_TagId.Text;
Dbers.GetInstance().SelfDber.Insert(cmcsepccard);
}
this.DialogResult = DialogResult.OK;
this.Close();
}
