/// <summary> /// 加载 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void LEDPreviewForm_Load(object sender, EventArgs e) { try { DataTable dts = LinQBaseDao.Query("select CarType_ID,CarType_DriSName from CarType where CarType_State='启动'").Tables[0]; if (dts.Rows.Count > 0) { for (int i = 0; i < dts.Rows.Count; i++) { int kk = Convert.ToInt32(LinQBaseDao.GetSingle("select count(0) from ManagementStrategy where ManagementStrategy_DriSName='" + dts.Rows[i][1].ToString() + "' and ManagementStrategy_ControlInfo_ID in(select ControlInfo_ID from ControlInfo where ControlInfo_Name='排队') and ManagementStrategy_State='启动' ").ToString()); if (kk == 0) { cartypeid += dts.Rows[i][0].ToString() + ","; } } } cartypeid = cartypeid.TrimEnd(','); //读取LED配置项 string sql = "select * from PositionLED where PositionLED_State='启动' and PositionLED_Position_ID=" + SystemClass.PositionID + ""; pled = PositionLEDDAL.GetLED(sql); //加载时将窗体显示位置修改到指定位置 int X = Convert.ToInt32(pled.PositionLED_X); int Y = Convert.ToInt32(pled.PositionLED_Y); this.Location = new Point(X, Y); fontsize = Convert.ToInt32(pled.PositionLED_FontSize); //判断当前门岗是否有LED的配置信息 if (pled.PositionLED_ID <= 0) { lbltishi.Visible = true; lblleixingting.Visible = false; lblleixingzhi.Visible = false; lblChePaiting.Visible = false; lblpaiduihaoting.Visible = false; lblMenGangting.Visible = false; lblTongDaoting.Visible = false; lbltishi.Text = "当前登录门岗\r\n暂无LED显示配置信息,\r\n请先配置对应门岗显示信息!!!"; return; } else { try { //读取配置的高宽(高度与宽度是反的) int weight = Convert.ToInt32(pled.PositionLED_ScreenWeight); int heifht = Convert.ToInt32(pled.PositionLED_ScreenHeight); this.Size = new Size(weight, heifht); //读取配置的字体颜色 string s = pled.PositionLED_Color; int cd = s.Length - 8; yanse = s.Substring(7, cd); if (pled.PositionLED_Type == 1) { timer1.Enabled = true; BindCountting(); BindTypeting(); Bindting(); } else if (pled.PositionLED_Type == 2) { lblhuanyingyu.Visible = true; lblleixingting.Visible = false; lblleixingzhi.Visible = false; lblChePaiting.Visible = false; lblpaiduihaoting.Visible = false; lblMenGangting.Visible = false; lblTongDaoting.Visible = false; lblhuanyingyu.Text = pled.PositionLED_Remark.ToString(); return; } } catch { //将类型的循环标识加1 typecountting = typecountting + 1; if (typecountting >= typeting) { typecountting = 0; } BindTypeting(); Bindting(); } } } catch { } }
/// <summary> /// 加载 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void LEDPreviewForm_Load(object sender, EventArgs e) { //读取LED配置项 string sql = "select * from PositionLED where PositionLED_State='启动' and PositionLED_Position_ID=" + SystemClass.PositionID + ""; pLED = PositionLEDDAL.GetLED(sql); //加载时将窗体显示位置修改到指定位置 int X = Convert.ToInt32(pLED.PositionLED_X); int Y = Convert.ToInt32(pLED.PositionLED_Y); this.Location = new Point(X, Y); //判断当前门岗是否有LED的配置信息 if (pLED.PositionLED_ID <= 0) { lbltishi.Visible = true; lbltishi.Text = "当前登录门岗\r\n暂无LED显示配置信息,\r\n请先配置对应门岗显示信息"; return; } else { DataTable dts = LinQBaseDao.Query("select CarType_ID from CarType where CarType_State='启动'").Tables[0]; if (dts.Rows.Count > 0) { for (int i = 0; i < dts.Rows.Count; i++) { // and ManagementStrategy_State='启动' int kk = Convert.ToInt32(LinQBaseDao.GetSingle("select count(0) from ManagementStrategy where ManagementStrategy_CarType_ID=" + dts.Rows[i][0].ToString() + " and ManagementStrategy_ControlInfo_ID in(select ControlInfo_ID from ControlInfo where ControlInfo_Name='排队')").ToString()); if (kk == 0) { cartypeid += dts.Rows[i][0].ToString() + ","; } } } cartypeid = cartypeid.TrimEnd(','); //读取配置的高宽(高度与宽度是反的) int weight = Convert.ToInt32(pLED.PositionLED_ScreenWeight); int heifht = Convert.ToInt32(pLED.PositionLED_ScreenHeight); this.Size = new Size(weight, heifht); //读取配置的字体颜色 string s = pLED.PositionLED_Color; int cd = s.Length - 8; yanse = s.Substring(7, cd); if (pLED.PositionLED_Type == 1)//1为显示排队信息 { try { BindCount(); if (type == 0) { lbltishi.Visible = true; lbltishi.Text = "一级防火单位,严禁将烟火带入厂区,否则引发事故将移送公安机关处理!!!"; } else { BindType(); timer1.Enabled = false; //将刷类型的闹钟关闭 lbltishi.Visible = false; //将提示语的LBL关闭 TimerLED.Enabled = true; //只有在显示排队信息时才将闹钟打开 } } catch { count = count + 1; if (count == type) { count = 0; } BindType(); } } else if (pLED.PositionLED_Type == 2)//2为显示欢迎语 { lblhuanyingyu.Visible = true; lblhuanyingyu.Text = pLED.PositionLED_Remark; } } }