/// <summary> /// 应用语音设置 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSMSApplication_Click(object sender, EventArgs e) { try { isUpdate = true; if (ChkPositionVoiceState()) { DialogResult dlgResult = MessageBox.Show("已经存在启动状态的设置,是否替换?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (dlgResult == DialogResult.OK) { //修改条件 Expression <Func <PositionVoice, bool> > funs = n => n.PositionVoice_State == "启动" && n.PositionVoice_Position_ID == int.Parse(chkPositionVoice_Position_Id.SelectedValue.ToString()); //需要修改的内容 Action <PositionVoice> actions = p => { p.PositionVoice_State = "暂停"; }; //执行更新 PositionVoiceDAL.UpdatePositionVoice(funs, actions); //应用当前选中的设置 //条件 int id = int.Parse(this.lvwUserList.SelectedRows[0].Cells["PositionVoice_ID"].Value.ToString()); Expression <Func <PositionVoice, bool> > fun = n => n.PositionVoice_ID == id; //需要的内容 Action <PositionVoice> action = p => { p.PositionVoice_State = "启动"; }; //执行更新 PositionVoiceDAL.UpdatePositionVoice(fun, action); CommonalityEntity.WriteLogData("启动", "启动编号为:" + id + "的语音呼叫信息", CommonalityEntity.USERNAME); } else { return; } } else { //应用当前选中的设置 //条件 Expression <Func <PositionVoice, bool> > fun = n => n.PositionVoice_ID == int.Parse(this.lvwUserList.SelectedRows[0].Cells["PositionVoice_ID"].Value.ToString()); //需要的内容 Action <PositionVoice> action = p => { p.PositionVoice_State = "启动"; }; //执行更新 PositionVoiceDAL.UpdatePositionVoice(fun, action); CommonalityEntity.WriteLogData("启动", "启用语音编号为:" + int.Parse(this.lvwUserList.SelectedRows[0].Cells["PositionVoice_ID"].Value.ToString()), CommonalityEntity.USERNAME); } } catch { CommonalityEntity.WriteTextLog("VoiceSetForm btnLEDApplication_Click()" + ""); } finally { GetGriddataviewLoad("");//加载 } }
/// <summary> /// 添加语音设置 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnAdd_Click(object sender, EventArgs e) { try { //if (!ChkContent()) return; //添加数据到数据库 PositionVoice pv = new PositionVoice(); pv.PositionVoice_Position_ID = int.Parse(chkPositionVoice_Position_Id.SelectedValue.ToString()); pv.PositionVoice_Remark = txtPositionVoice_Remark.Text.Trim(); pv.PositionVoice_State = combokPositionVoice_State.Text.ToString(); pv.PositionVoice_PassageState = cmbtxtPositionVoice_Type.Text; if (cmbtxtPositionVoice_Type.Text.Trim() == "欢迎语") { pv.PositionVoice_Content = txtHY.Text; } else { pv.PositionVoice_Count = int.Parse(txtPositionVoice_Count.Text.Trim()); string serialnumber = ""; string carType = ""; string carNumber = ""; if (chkCarNumber.Checked) { carNumber = chkCarNumber.Text.Trim() + ","; } if (chkCarType.Checked) { carType = chkCarType.Text.Trim() + ","; } if (chkSerialnumber.Checked) { serialnumber = chkSerialnumber.Text.Trim() + ","; } string chklists = ""; if (list.Count() > 0) { foreach (var item in list) { chklists += (item.ToString() + ","); } list.Clear(); } string content = carType + carNumber + serialnumber + chklists; pv.PositionVoice_Content = content; } pv.PositionVoice_Operate = CommonalityEntity.USERNAME; pv.PositionVoice_Time = CommonalityEntity.GetServersTime(); if (pv.PositionVoice_State == "启动") { if (ChkPositionVoiceState()) { DialogResult dlgResult = MessageBox.Show("已经存在启动状态的设置,是否替换?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (dlgResult == DialogResult.OK) { //修改条件 Expression <Func <PositionVoice, bool> > fun = n => n.PositionVoice_State == "启动" && n.PositionVoice_Position_ID == int.Parse(chkPositionVoice_Position_Id.SelectedValue.ToString()); //需要修改的内容 Action <PositionVoice> action = p => { p.PositionVoice_State = "暂停"; }; //执行更新 PositionVoiceDAL.UpdatePositionVoice(fun, action); PositionVoiceDAL.InsertPositionVoice(pv); } else { pv.PositionVoice_State = "暂停"; PositionVoiceDAL.InsertPositionVoice(pv); } } else { PositionVoiceDAL.InsertPositionVoice(pv); } } else { PositionVoiceDAL.InsertPositionVoice(pv); } DataTable dt = LinQBaseDao.Query("select PositionVoice_ID,PositionVoice_State from PositionVoice order by PositionVoice_ID desc").Tables[0]; string positionvoice_id = dt.Rows[0][0].ToString(); string positionvoice_state = dt.Rows[0][1].ToString(); if (positionvoice_state == "启动") { CommonalityEntity.WriteLogData("新增", "新增并启用编号为:" + positionvoice_id + "的语音呼叫信息", CommonalityEntity.USERNAME); } else { CommonalityEntity.WriteLogData("新增", "新增编号为:" + positionvoice_id + "的语音呼叫信息", CommonalityEntity.USERNAME); } MessageBox.Show("保存成功!"); } catch { //记录错误日志 CommonalityEntity.WriteTextLog("VoiceSetForm btnAdd_Click()" + ""); } finally { btnSelect_Click(sender, e); // 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; } //修改条件 Expression <Func <PositionVoice, bool> > fun = n => n.PositionVoice_ID == int.Parse(this.lvwUserList.SelectedRows[0].Cells["PositionVoice_ID"].Value.ToString()); string PositionVoice_State = combokPositionVoice_State.Text.Trim(); if (combokPositionVoice_State.Text.Trim() == "启动") { if (ChkPositionVoiceState()) { DialogResult dlgResult = MessageBox.Show("已经存在启动状态的设置,是否替换?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (dlgResult == DialogResult.OK) { //修改条件 Expression <Func <PositionVoice, bool> > funs = n => n.PositionVoice_State == "启动" && n.PositionVoice_Position_ID == int.Parse(chkPositionVoice_Position_Id.SelectedValue.ToString()); //需要修改的内容 Action <PositionVoice> actions = p => { p.PositionVoice_State = "暂停"; }; //执行更新 PositionVoiceDAL.UpdatePositionVoice(funs, actions); } else { return; } } } string id = ""; string strfront = ""; string strcontent = ""; //需要修改的内容 Action <PositionVoice> action = pv => { strfront = pv.PositionVoice_Count + "," + pv.PositionVoice_Position_ID + "," + pv.PositionVoice_Remark + "," + pv.PositionVoice_State + "," + pv.PositionVoice_Content; pv.PositionVoice_Position_ID = int.Parse(chkPositionVoice_Position_Id.SelectedValue.ToString()); pv.PositionVoice_Remark = txtPositionVoice_Remark.Text.Trim(); pv.PositionVoice_State = combokPositionVoice_State.Text.ToString(); pv.PositionVoice_PassageState = cmbtxtPositionVoice_Type.Text; if (cmbtxtPositionVoice_Type.Text.Trim() == "欢迎语") { pv.PositionVoice_Content = txtHY.Text; } else { pv.PositionVoice_Count = int.Parse(txtPositionVoice_Count.Text.Trim()); string userialnumber = ""; string ucarType = ""; string ucarNumber = ""; if (chkCarNumber.Checked) { ucarNumber = chkCarNumber.Text.Trim() + ","; } if (chkCarType.Checked) { ucarType = chkCarType.Text.Trim() + ","; } if (chkSerialnumber.Checked) { userialnumber = chkSerialnumber.Text.Trim() + ","; } string uchklists = ""; if (list.Count() > 0) { foreach (var item in list) { uchklists += ("," + item.ToString()); } list.Clear(); } string content = ucarType + ucarNumber + userialnumber + uchklists; pv.PositionVoice_Content = content; } id = pv.PositionVoice_ID.ToString(); strcontent = pv.PositionVoice_Count + "," + pv.PositionVoice_Position_ID + "," + pv.PositionVoice_Remark + "," + pv.PositionVoice_State + "," + pv.PositionVoice_Content; }; //执行更新 PositionVoiceDAL.UpdatePositionVoice(fun, action); isUpdate = false; txtjiange_end(); CommonalityEntity.WriteLogData("修改", "更新编号为:" + id + "的语音呼叫信息,修改前:" + strfront + ";修改后:" + strcontent, CommonalityEntity.USERNAME); btnUpdate.Enabled = false; btnAdd.Enabled = true; MessageBox.Show("修改成功!"); } catch { //记录错误日志 CommonalityEntity.WriteTextLog("VoiceSetForm btnAdd_Click()" + ""); } finally { isUpdate = false; btnSelect_Click(sender, e); //GetGriddataviewLoad("");//绑定列表 Empty(); } }