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