/// <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; } if (string.IsNullOrEmpty(txtPositionSMS_Count.Text.Trim())) { MessageBox.Show("发送间隔不能为空!"); return; } int scount = Convert.ToInt32(txtPositionSMS_Count.Text.Trim()); //修改条件 Expression <Func <PositionSMS, bool> > fun = n => n.PositionSMS_ID == int.Parse(this.lvwUserList.SelectedRows[0].Cells["PositionSMS_ID"].Value.ToString()); if (combokPositionSMS_State.Text.Trim() == "启动") { if (ChkPositionSMSState()) { DialogResult dlgResult = MessageBox.Show("已经存在启动状态的设置,是否替换?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (dlgResult == DialogResult.OK) { //修改条件 Expression <Func <PositionSMS, bool> > funs = n => n.PositionSMS_State == "启动" && n.PositionSMS_Position_ID == int.Parse(this.lvwUserList.SelectedRows[0].Cells["PositionSMS_ID"].Value.ToString()); //需要修改的内容 Action <PositionSMS> actions = p => { p.PositionSMS_State = "暂停"; }; //执行更新 if (PositionSMSDAL.UpdatePositionSMS(funs, actions)) { MessageBox.Show("修改成功"); } else { MessageBox.Show("修改失败!"); } } else { return; } } } string id = ""; string strfront = ""; string strcontent = ""; //需要修改的内容 Action <PositionSMS> action = ps => { strfront = ps.PositionSMS_Content + "," + ps.PositionSMS_Count + "," + ps.PositionSMS_Position_ID + "," + ps.PositionSMS_State; ps.PositionSMS_Content = txtPositionSMS_Content.Text.Trim(); ps.PositionSMS_Position_ID = int.Parse(chkPositionSMS_Position_Id.SelectedValue.ToString()); ps.PositionSMS_Count = scount; //ps.PositionSMS_Type = txtPositionSMS_Type.Text.Trim(); ps.PositionSMS_State = combokPositionSMS_State.Text.ToString(); strcontent = ps.PositionSMS_Content + "," + ps.PositionSMS_Count + "," + ps.PositionSMS_Position_ID + "," + ps.PositionSMS_State; id = ps.PositionSMS_ID.ToString(); }; //执行更新 if (PositionSMSDAL.UpdatePositionSMS(fun, action)) { MessageBox.Show("修改成功"); } else { MessageBox.Show("修改失败!"); } CommonalityEntity.WriteLogData("修改", "更新编号为:" + id + "的短信提示信息,,修改前:" + strfront + ";修改后:" + strcontent + "", CommonalityEntity.USERNAME); //更新成功更更新XML的间隔数 //txtjiange_setLoad(); } catch { CommonalityEntity.WriteTextLog("SMSSetForm btnAdd_Click()" + ""); } finally { GetGriddataviewLoad(""); btnUpdate.Enabled = false; btnAdd.Enabled = true; Cler(); } }
private void btnSMSApplication_Click(object sender, EventArgs e) { try { isUpdate = true; if (ChkPositionSMSState()) { DialogResult dlgResult = MessageBox.Show("已经存在启动状态的设置,是否替换?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (dlgResult == DialogResult.OK) { //修改条件 Expression <Func <PositionSMS, bool> > funs = n => n.PositionSMS_State == "启动" && n.PositionSMS_Position_ID == int.Parse(this.lvwUserList.SelectedRows[0].Cells["PositionSMS_Position_ID"].Value.ToString()); //需要修改的内容 Action <PositionSMS> actions = p => { p.PositionSMS_State = "暂停"; }; //执行更新 PositionSMSDAL.UpdatePositionSMS(funs, actions); //应用当前选中的设置 //条件 int positionsms_id = int.Parse(this.lvwUserList.SelectedRows[0].Cells["PositionSMS_ID"].Value.ToString()); Expression <Func <PositionSMS, bool> > fun = n => n.PositionSMS_ID == positionsms_id; //需要的内容 Action <PositionSMS> action = p => { p.PositionSMS_State = "启动"; }; //执行更新 PositionSMSDAL.UpdatePositionSMS(fun, action); CommonalityEntity.WriteLogData("启动", "启动编号为: " + positionsms_id + "的信息", CommonalityEntity.USERNAME);//添加操作日志 } else { return; } } else { //应用当前选中的设置 //条件 int positionsms_id = int.Parse(this.lvwUserList.SelectedRows[0].Cells["PositionSMS_ID"].Value.ToString()); Expression <Func <PositionSMS, bool> > fun = n => n.PositionSMS_ID == positionsms_id; //需要的内容 Action <PositionSMS> action = p => { p.PositionSMS_State = "启动"; }; //执行更新 PositionSMSDAL.UpdatePositionSMS(fun, action); CommonalityEntity.WriteLogData("启动", "启动编号为: " + positionsms_id + "短信提示信息", CommonalityEntity.USERNAME);//添加操作日志 } } catch { CommonalityEntity.WriteTextLog("SMSSetForm btnSMSApplication_Click()" + ""); } finally { GetGriddataviewLoad("");//加载 } }
/// <summary> /// 保存当前设置 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnAdd_Click(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(txtPositionSMS_Count.Text.Trim())) { MessageBox.Show("发送间隔不能为空!"); return; } int scount = Convert.ToInt32(txtPositionSMS_Count.Text.Trim()); //得到输入的数据 PositionSMS ps = new PositionSMS(); ps.PositionSMS_Content = txtPositionSMS_Content.Text.Trim(); ps.PositionSMS_Count = scount; ps.PositionSMS_Operate = CommonalityEntity.USERNAME; ps.PositionSMS_Position_ID = int.Parse(chkPositionSMS_Position_Id.SelectedValue.ToString()); //ps.PositionSMS_Type = txtPositionSMS_Type.Text.Trim(); ps.PositionSMS_Time = CommonalityEntity.GetServersTime(); ps.PositionSMS_State = combokPositionSMS_State.Text.ToString(); if (combokPositionSMS_State.Text.Trim() == "启动") { if (ChkPositionSMSState()) { DialogResult dlgResult = MessageBox.Show("已经存在启动状态的设置,是否替换?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (dlgResult == DialogResult.OK) { //修改条件 Expression <Func <PositionSMS, bool> > fun = n => n.PositionSMS_State == "启动" && n.PositionSMS_Position_ID == int.Parse(chkPositionSMS_Position_Id.SelectedValue.ToString()); //需要修改的内容 Action <PositionSMS> action = p => { p.PositionSMS_State = "暂停"; }; //执行更新 PositionSMSDAL.UpdatePositionSMS(fun, action); PositionSMSDAL.InsertPositionSMS(ps); } else { ps.PositionSMS_State = "暂停"; PositionSMSDAL.InsertPositionSMS(ps); } } else { PositionSMSDAL.InsertPositionSMS(ps); } } else { PositionSMSDAL.InsertPositionSMS(ps); } DataTable dt = LinQBaseDao.Query("select PositionSMS_ID,PositionSMS_State from PositionSMS order by PositionSMS_ID desc ").Tables[0]; string positionsms_id = dt.Rows[0][0].ToString(); string positionsms_state = dt.Rows[0][1].ToString(); if (positionsms_state == "启动") { CommonalityEntity.WriteLogData("新增", "新增并启动编号为: " + positionsms_id + "的短信提示信息", CommonalityEntity.USERNAME);//添加操作日志 } else { CommonalityEntity.WriteLogData("新增", "新增编号为: " + positionsms_id + "的短信提示信息", CommonalityEntity.USERNAME);//添加操作日志 } } catch { CommonalityEntity.WriteTextLog("SMSSetForm btnAdd_Click()" + ""); } finally { GetGriddataviewLoad(""); Cler(); } }