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