/// <summary>
/// 新增一条记录
/// </summary>
/// <param name="qcRecord">用户实体</param>
/// /// <param name="rint">新增后自动增长编号</param>
/// <returns></returns>
public static bool InsertOneUnuRecord(UnusualRecord qcRecord, out int rint)
{
rint = 0;
bool rbool = true;
using (DCCarManagementDataContext db = new DCCarManagementDataContext())
{
try
{
rbool = LinQBaseDao.InsertOne(db, qcRecord);
rint = db.UnusualRecord.Max(p => p.UnusualRecord_ID);
}
catch
{
rbool = false;
}
finally { db.Connection.Close(); }
}
return(rbool);
}
//private void comboxDriveway_DropDown(object sender, EventArgs e)
//{
// GetDriveway();
//}
/// <summary>
/// 异常呼叫
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnUnu_Click(object sender, EventArgs e)
{
try
{
isUnusual = true;
if (pv.PositionVoice_ID <= 0)
{
MessageBox.Show("请先进行呼叫设置");
return;
}
if (this.lvwUserList.SelectedRows[0].Cells["sortnumberinfo_state"].Value.ToString() == "注销")
{
MessageBox.Show("车辆排队状态被注销，不能呼叫！");
return;
}
string strslq = " select * from View_LEDShow_zj where sortnumberinfo_state='启动' and 车辆类型='" + _carType + "' and Driveway_Position_ID=" + SystemClass.PositionID + " and CarInfo_State='启动' and 通道名称='" + comboxDriveway.Text.Trim() + "' and 通行状态='待通行' and 排队号 <> ''";
DataTable dtsort = LinQBaseDao.Query(strslq).Tables[0];
if (dtsort.Rows.Count > 1)
{
MessageBox.Show("已呼叫车辆未放行，不能继续呼叫！");
return;
}
DialogResult dlgR = MessageBox.Show("确认呼叫" + this.lvwUserList.SelectedRows[0].Cells["QueueCarNumber"].Value.ToString() + "车辆? 当前呼叫为异常呼叫!", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Stop);
if (dlgR == DialogResult.OK)
{
#region 记录呼叫异常
ur = new UnusualRecord();
ur.UnusualRecord_Operate = CommonalityEntity.USERNAME;
ur.UnusualRecord_Reason = "异常呼叫" + this.lvwUserList.SelectedRows[0].Cells["QueueCarNumber"].Value.ToString() + "车辆";
ur.UnusualRecord_Remark = "异常呼叫";
ur.UnusualRecord_State = "启动";
ur.UnusualRecord_Time = CommonalityEntity.GetServersTime();
ur.UnusualRecord_Type = "异常呼叫";
ur.UnusualRecord_UnusualType_ID = 1;
ur.UnusualRecord_Site = "排队信息";
ur.UnusualRecord_SiteID = int.Parse(this.lvwUserList.SelectedRows[0].Cells["sortNumberInfo_ID"].Value.ToString());
ur.UnusualRecord_CarInfo_ID = int.Parse(this.lvwUserList.SelectedRows[0].Cells["CarInfo_ID"].Value.ToString());
UnusualRecordDAL.InsertUnusualRecord(ur);//记录异常信息
#endregion
}
else
{
return;
}
//得到排队信息表编号，修改排队状态
string sortid = this.lvwUserList.SelectedRows[0].Cells["sortNumberInfo_ID"].Value.ToString();
string strsql = " SortNumberInfo_TongXing ='待通行',SortNumberInfo_CallCount +=1,SortNumberInfo_Remark = '异常呼叫',SortNumberInfo_Number='是'";
if (this.lvwUserList.SelectedRows[0].Cells["Queue_State"].Value.ToString() == "排队中")
{
strsql += ",SortNumberInfo_CallTime ='" + CommonalityEntity.GetServersTime() + "'";
}
strsql = "update SortNumberInfo set " + strsql + " where SortNumberInfo_ID=" + sortid;
LinQBaseDao.Query(strsql);
//得到呼叫的内容
GetData();
}
catch
{
CommonalityEntity.WriteTextLog("QueueForm btnUnu_Click():");
}
finally
{
GetGriddataviewLoad("");//重新加载数据
}
}
/// <summary>
/// 添加一条LED信息
/// </summary>
/// <param name="pLED">LED实体</param>
/// <returns>返回执行结果 true or false</returns>
public static bool InsertUnusualRecord(UnusualRecord pLED)
{
return(LinQBaseDao.InsertOne <UnusualRecord>(dc, pLED));
}
