/// <summary> /// 应用当前选中的LED设置 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnLEDApplication_Click(object sender, EventArgs e) { try { CommonalityEntity.IsCancellation = false; isUpdate = -1; if (ChkPositionLEDState()) { DialogResult dlgResult = MessageBox.Show("已经存在启动状态的设置,是否替换?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (dlgResult == DialogResult.OK) { //修改条件 Expression <Func <PositionLED, bool> > funs = n => n.PositionLED_State == "启动" && n.PositionLED_Position_ID == int.Parse(this.lvwUserList.SelectedRows[0].Cells["PositionLED_Position_ID"].Value.ToString()); //需要修改的内容 Action <PositionLED> actions = p => { p.PositionLED_State = "暂停"; }; //执行更新 PositionLEDDAL.UpdatePositionLED(funs, actions); //应用当前选中的设置 //条件 int id = int.Parse(this.lvwUserList.SelectedRows[0].Cells["PositionLED_ID"].Value.ToString()); Expression <Func <PositionLED, bool> > fun = n => n.PositionLED_ID == id; //需要的内容 Action <PositionLED> action = p => { p.PositionLED_State = "启动"; }; //执行更新 PositionLEDDAL.UpdatePositionLED(fun, action); CommonalityEntity.WriteLogData("修改", "启动编号为:" + id + "的LED显示信息", CommonalityEntity.USERNAME);//操作日志 } else { return; } } else { //应用当前选中的设置 //条件 int id = int.Parse(this.lvwUserList.SelectedRows[0].Cells["PositionLED_ID"].Value.ToString()); Expression <Func <PositionLED, bool> > fun = n => n.PositionLED_ID == id; //需要的内容 Action <PositionLED> action = p => { p.PositionLED_State = "启动"; }; //执行更新 PositionLEDDAL.UpdatePositionLED(fun, action); CommonalityEntity.WriteLogData("修改", "启动编号为:" + id + "的LED显示信息", CommonalityEntity.USERNAME);//操作日志 } } catch { CommonalityEntity.WriteTextLog("LEDSerForm btnLEDApplication_Click()"); } finally { GetGriddataviewLoad("");//加载 } }
/// <summary> /// 保存用户操作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnAdd_Click(object sender, EventArgs e) { try { isUpdate = 1; if (!ChkContent()) { return; } //判断是否修改 //添加数据到数据库 PositionLED pLED = new PositionLED(); #region 获取页面的数据 pLED.PositionLED_Position_ID = int.Parse(chkPositionLED_Position_Id.SelectedValue.ToString()); if (cboleixing.Text == "排队信息") { pLED.PositionLED_Type = 1; } else if (cboleixing.Text == "欢迎语") { pLED.PositionLED_Type = 2; } pLED.PositionLED_ScreenHeight = int.Parse(txtPositionLED_ScreenHeight.Text.Trim()); pLED.PositionLED_ScreenWeight = int.Parse(txtPositionLED_ScreenWeight.Text.Trim()); pLED.PositionLED_X = int.Parse(txtPositionLED_X.Text.Trim()); pLED.PositionLED_Y = int.Parse(txtPositionLED_Y.Text.Trim()); pLED.PositionLED_Count = int.Parse(cbotiaoshu.Text.Trim()); pLED.PositionLED_Remark = txtPositionLED_Remark.Text.Trim(); //pLED.PositionLED_PassageState = chkboxLEDPassState.Text.ToString(); //保存选择的字体设置项目 pLED.PositionLED_Font = fontdlgFont.Font.Name.ToString(); pLED.PositionLED_FontSize = fontdlgFont.Font.Size.ToString(); pLED.PositionLED_Color = colordlgFont.Color.ToString(); if (cboleixing.Text == "欢迎语") { pLED.PositionLED_Content = ""; pLED.PositionLED_Operate = CommonalityEntity.USERNAME; pLED.PositionLED_Time = CommonalityEntity.GetServersTime(); #endregion pLED.PositionLED_State = chkboxLEDState.Text.Trim(); if (chkboxLEDState.Text.Trim() == "启动") { if (ChkPositionLEDState()) { DialogResult dlgResult = MessageBox.Show("已经存在启动状态的设置,是否替换?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (dlgResult == DialogResult.OK) { //修改条件 Expression <Func <PositionLED, bool> > fun = n => n.PositionLED_State == "启动" && n.PositionLED_Position_ID == int.Parse(chkPositionLED_Position_Id.SelectedValue.ToString()); //需要修改的内容 Action <PositionLED> action = p => { p.PositionLED_State = "暂停"; }; //执行更新 PositionLEDDAL.UpdatePositionLED(fun, action); PositionLEDDAL.InsertPositionLED(pLED); } else { pLED.PositionLED_State = "暂停"; PositionLEDDAL.InsertPositionLED(pLED); } } else { PositionLEDDAL.InsertPositionLED(pLED); } } else { PositionLEDDAL.InsertPositionLED(pLED); } DataTable dt = dt = LinQBaseDao.Query("select PositionLED_ID,PositionLED_State from PositionLED order by PositionLED_ID desc").Tables[0]; string positionled_id = dt.Rows[0][0].ToString(); string state = dt.Rows[0][1].ToString(); if (state == "启动") { CommonalityEntity.WriteLogData("新增", "新增并启动编号为:" + positionled_id + "的LED显示信息", CommonalityEntity.USERNAME);//添加操作日志 } else { CommonalityEntity.WriteLogData("新增", "新增编号为:" + positionled_id + "的LED显示信息", CommonalityEntity.USERNAME);//添加操作日志 } } else if (cboleixing.Text == "排队信息") { string serialnumber = ""; string carType = ""; string carNumber = ""; if (chkCarNumber.Checked) { carNumber = chkCarNumber.Text.Trim() + ","; } if (chkCarType.Checked) { carType = chkCarType.Text.Trim() + ","; } if (chkSerialnumber.Checked) { serialnumber = "distinct(" + chkSerialnumber.Text.Trim() + "),"; } string chklists = ""; if (list.Count() > 1) { foreach (var item in list) { chklists += (item.ToString() + ","); } list.Clear(); } string listsql = serialnumber + carNumber + carType + chklists; listsql = listsql.TrimEnd(','); //限定选择的显示内容只能为3个 string[] split = listsql.Split(','); int num = 0; for (int i = 0; i < split.Length; i++) { num++; } if (num > 3) { MessageBox.Show("排队信息显示的项目最多选择3项", "错误提示"); return; } else { string sql = "Select " + listsql + " from View_LEDShow_zj"; pLED.PositionLED_Content = sql; pLED.PositionLED_Operate = CommonalityEntity.USERNAME; pLED.PositionLED_Time = CommonalityEntity.GetServersTime(); pLED.PositionLED_State = chkboxLEDState.Text.Trim(); if (chkboxLEDState.Text.Trim() == "启动") { if (ChkPositionLEDState()) { DialogResult dlgResult = MessageBox.Show("已经存在启动状态的设置,是否替换?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (dlgResult == DialogResult.OK) { //修改条件 Expression <Func <PositionLED, bool> > fun = n => n.PositionLED_State == "启动" && n.PositionLED_Position_ID == int.Parse(chkPositionLED_Position_Id.SelectedValue.ToString()); //需要修改的内容 Action <PositionLED> action = p => { p.PositionLED_State = "暂停"; }; //执行更新 PositionLEDDAL.UpdatePositionLED(fun, action); PositionLEDDAL.InsertPositionLED(pLED); } else { pLED.PositionLED_State = "暂停"; PositionLEDDAL.InsertPositionLED(pLED); } } else { PositionLEDDAL.InsertPositionLED(pLED); } } else { PositionLEDDAL.InsertPositionLED(pLED); } DataTable dt = dt = LinQBaseDao.Query("select PositionLED_ID,PositionLED_State from PositionLED order by PositionLED_ID desc").Tables[0]; string positionled_id = dt.Rows[0][0].ToString(); string state = dt.Rows[0][1].ToString(); if (state == "启动") { CommonalityEntity.WriteLogData("新增", "新增并启动编号为:" + positionled_id + "的LED显示信息", CommonalityEntity.USERNAME);//添加操作日志 } else { CommonalityEntity.WriteLogData("新增", "新增编号为:" + positionled_id + "的LED显示信息", CommonalityEntity.USERNAME);//添加操作日志 } } } } catch { //记录错误日志 CommonalityEntity.WriteTextLog("LEDSetForm btnAdd_Click()"); } finally { GetGriddataviewLoad("");//绑定列表 Empty(); } }
/// <summary> /// 选中列表中的项进行修改 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnUpdate_Click(object sender, EventArgs e) { try { if (this.lvwUserList.SelectedRows.Count <= 0) { MessageBox.Show("请选择要修改的项!"); return; } else if (!ChkContent()) { return; } //修改条件 Expression <Func <PositionLED, bool> > fun = n => n.PositionLED_ID == int.Parse(this.lvwUserList.SelectedRows[0].Cells["PositionLED_ID"].Value.ToString()); string positionLED_State = chkboxLEDState.Text.Trim(); if (chkboxLEDState.Text.Trim() == "启动") { if (ChkPositionLEDState()) { DialogResult dlgResult = MessageBox.Show("已经存在启动状态的设置,是否替换?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (dlgResult == DialogResult.OK) { //修改条件 Expression <Func <PositionLED, bool> > funs = n => n.PositionLED_State == "启动" && n.PositionLED_Position_ID == int.Parse(this.lvwUserList.SelectedRows[0].Cells["PositionLED_Position_ID"].Value.ToString()); //需要修改的内容 Action <PositionLED> actions = p => { p.PositionLED_State = "暂停"; }; //执行更新 PositionLEDDAL.UpdatePositionLED(funs, actions); } else { return; } } } string id = ""; string strfront = ""; string strcontent = ""; //需要修改的内容 Action <PositionLED> action = pLED => { strfront = pLED.PositionLED_Position_ID + "," + pLED.PositionLED_ScreenHeight + "," + pLED.PositionLED_ScreenWeight + "," + pLED.PositionLED_X + "," + pLED.PositionLED_Y + "," + pLED.PositionLED_IntervalX + "," + pLED.PositionLED_IntervalY + "," + pLED.PositionLED_Count + "," + pLED.PositionLED_Remark + "," + pLED.PositionLED_State + "," + pLED.PositionLED_Font + "," + pLED.PositionLED_FontSize + "," + pLED.PositionLED_Color + "," + pLED.PositionLED_Content; pLED.PositionLED_Position_ID = int.Parse(chkPositionLED_Position_Id.SelectedValue.ToString()); if (cboleixing.Text == "排队信息") { pLED.PositionLED_Type = 1; } else if (cboleixing.Text == "欢迎语") { pLED.PositionLED_Type = 2; } pLED.PositionLED_ScreenHeight = int.Parse(txtPositionLED_ScreenHeight.Text.Trim()); pLED.PositionLED_ScreenWeight = int.Parse(txtPositionLED_ScreenWeight.Text.Trim()); pLED.PositionLED_X = int.Parse(txtPositionLED_X.Text.Trim()); pLED.PositionLED_Y = int.Parse(txtPositionLED_Y.Text.Trim()); pLED.PositionLED_Count = int.Parse(cbotiaoshu.Text.Trim()); pLED.PositionLED_Remark = txtPositionLED_Remark.Text.Trim(); //pLED.PositionLED_PassageState = chkboxLEDPassState.Text.ToString(); pLED.PositionLED_State = chkboxLEDState.Text.Trim(); pLED.PositionLED_Font = fontdlgFont.Font.Name.ToString(); pLED.PositionLED_FontSize = fontdlgFont.Font.Size.ToString(); pLED.PositionLED_Color = colordlgFont.Color.ToString(); string userialnumber = ""; string ucarType = ""; string ucarNumber = ""; if (chkCarNumber.Checked) { ucarNumber = chkCarNumber.Text.Trim() + ","; } if (chkCarType.Checked) { ucarType = chkCarType.Text.Trim() + ","; } if (chkSerialnumber.Checked) { userialnumber = "distinct(" + chkSerialnumber.Text.Trim() + "),"; } string uchklists = ""; if (list.Count() > 0) { foreach (var item in list) { uchklists += (item.ToString() + ","); } list.Clear(); } string ulistsql = userialnumber + ucarNumber + ucarType + uchklists; string sql = "Select " + ulistsql.TrimEnd(',') + " from View_LEDShow_zj"; pLED.PositionLED_Content = sql; strcontent = pLED.PositionLED_Position_ID + "," + pLED.PositionLED_ScreenHeight + "," + pLED.PositionLED_ScreenWeight + "," + pLED.PositionLED_X + "," + pLED.PositionLED_Y + "," + pLED.PositionLED_IntervalX + "," + pLED.PositionLED_IntervalY + "," + pLED.PositionLED_Count + "," + pLED.PositionLED_Remark + "," + pLED.PositionLED_State + "," + pLED.PositionLED_Font + "," + pLED.PositionLED_FontSize + "," + pLED.PositionLED_Color + "," + pLED.PositionLED_Content; id = pLED.PositionLED_ID.ToString(); }; //执行更新 PositionLEDDAL.UpdatePositionLED(fun, action); CommonalityEntity.WriteLogData("修改", "更新编号为:" + id + "的LED显示信息,修改前:" + strfront + ";修改后:" + strcontent, CommonalityEntity.USERNAME); btnUpdate.Enabled = false; btnAdd.Enabled = true; } catch { //记录错误日志 CommonalityEntity.WriteTextLog("LEDSetForm btnAdd_Click()"); } finally { GetGriddataviewLoad("");//绑定列表 Empty(); } }