/// <summary> /// 管控策略按钮双击事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_Administration_Click(object sender, EventArgs e) { try { UpdateManagementStrategyForm msf = new UpdateManagementStrategyForm(); PublicClass.ShowChildForm(msf); //mf = new MainForm(); //mf.ShowChildForm(msf, this); } catch { CommonalityEntity.WriteTextLog("CarTypeForm.btn_Administration_Click()" + "".ToString()); } }
/// <summary> /// 保存,如果有同样车牌号的通行策略则把之前的状态注销 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnUpdate_Click(object sender, EventArgs e) { IList <DrivewayStrategyRecord> iedsr = null; try { if (string.IsNullOrEmpty(txt_carState.Text)) { PublicClass.ShowToolTip(ToolTipIcon.Info, "提示", "请选择状态!", txt_carState, this); return; } string strsort = ""; if (SortYesOrNo) { strsort = "有序"; } else { strsort = "无序"; } if (SetSortList.Count != Driveway_IDList.Count) { SortYesOrNo = false; } else { SortYesOrNo = true; } //得到车辆对象 Expression <Func <CarInfo, bool> > fn = n => n.CarInfo_ID == Convert.ToInt32(CommonalityEntity.CarInfo_ID); CarInfo car = CarInfoDAL.Single(fn); LinQBaseDao.Query("delete ManagementStrategyRecord where ManagementStrategyRecord_CarInfo_ID=" + car.CarInfo_ID); LinQBaseDao.Query("delete DrivewayStrategyRecord where DrivewayStrategyRecord_CarInfo_ID=" + car.CarInfo_ID); //循环选择的通道 iedsr = new List <DrivewayStrategyRecord>(); if (SetSortList.Count == Driveway_IDList.Count) { for (int i = 0; i < SetSortList.Count; i++) { DataTable tablesDrisn = LinQBaseDao.Query("select Position_Name,Driveway_Name,Driveway_type from View_DrivewayPosition where driveway_warrantystate='正常' and driveway_state='启动' and Driveway_ID=" + SetSortList[i].id + " order by Position_Name asc, Driveway_Name asc").Tables[0]; DrivewayStrategyRecord Newdsr = new DrivewayStrategyRecord(); Newdsr.DrivewayStrategyRecord_Name = txtDrivewayStrategy.Text.Trim(); Newdsr.DrivewayStrategyRecord_Driveway_ID = SetSortList[i].id;//通道编号 Newdsr.DrivewayStrategyRecord_State = txt_carState.Text; Newdsr.DrivewayStrategyRecord_Remark = txt_DrivewayStrategyRecord_Remark.Text.Trim(); Newdsr.DrivewayStrategyRecord_OffReason = txt_DrivewayStrategyRecord_OffReason.Text.Trim(); Newdsr.DrivewayStrategyRecord_OffTime = CommonalityEntity.GetServersTime(); Newdsr.DrivewayStrategyRecord_OffName = HelpClass.common.USERNAME; Newdsr.DrivewayStrategyRecord_CarInfo_ID = car.CarInfo_ID; Newdsr.DrivewayStrategyRecord_Sort = SortYesOrNo == true ? SetSortList[i].sort : 1; Newdsr.DrivewayStrategyRecord_Record = "【" + txt_carInfo_Name.Text.ToString().Trim() + "】 " + tablesDrisn.Rows[0]["Position_Name"] + tablesDrisn.Rows[0]["Driveway_Name"]; iedsr.Add(Newdsr); } try { dc.DrivewayStrategyRecord.InsertAllOnSubmit(iedsr); dc.SubmitChanges(); DialogResult dr = MessageBox.Show("操作已完成!请继续修改相应的管控策略否则修改无效", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (dr == DialogResult.Yes) { string sids = ""; DataTable dt = LinQBaseDao.Query("select DrivewayStrategyRecord_ID, DrivewayStrategyRecord_Driveway_ID from DrivewayStrategyRecord where DrivewayStrategyRecord_CarInfo_ID=" + car.CarInfo_ID + " and DrivewayStrategyRecord_State='启动' order by DrivewayStrategyRecord_Sort ").Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { sids += dt.Rows[i][0].ToString() + ","; } int driid = Convert.ToInt32(dt.Rows[0][1].ToString()); sids = sids.TrimEnd(','); string SmallID = LinQBaseDao.GetSingle("select SmallTicket_ID from SmallTicket where SmallTicket_CarInfo_ID=" + car.CarInfo_ID).ToString(); DataTable dtpd = LinQBaseDao.Query("select Position_ID, Position_Value,Driveway_Value from View_FVN_Driveway_Position where Driveway_ID=" + driid).Tables[0]; if (dtpd.Rows.Count > 0) { string str = "update CarInOutRecord set CarInOutRecord_DrivewayStrategyS='" + sids + "',CarInOutRecord_Update=1,CarInOutRecord_Driveway_ID=" + driid + ",CarInOutRecord_Remark='" + txtDrivewayStrategy.Text.Trim() + "',CarInOutRecord_Sort='" + strsort + "' where CarInOutRecord_CarInfo_ID=" + car.CarInfo_ID; str += " update SortNumberInfo set SortNumberInfo_PositionValue='" + dtpd.Rows[0][1].ToString() + "',SortNumberInfo_DrivewayValue='" + dtpd.Rows[0][2].ToString() + "' where SortNumberInfo_SmallTicket_ID in (select SmallTicket_ID from SmallTicket where SmallTicket_CarInfo_ID=" + car.CarInfo_ID + ")"; LinQBaseDao.Query(str); sids = ""; CommonalityEntity.boolCepyManagementStrategy = false; UpdateManagementStrategyForm up = new UpdateManagementStrategyForm(carname); up.Show(); } } BingMethod(); } catch { MessageBox.Show("操作失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } } catch { CommonalityEntity.WriteTextLog("DrivewayStrategyRecordForm.btnUpdate_Click()" + "".ToString()); } finally { SetSortList.Clear(); Driveway_IDList.Clear(); } }