/// <summary> /// 更新流程 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private async void btnDefineFlowUpdate_Click(object sender, EventArgs e) { try { if (this.txtDefineFlowID.Text != string.Empty && this.txtDefineFlowName.Text != string.Empty && this.txtSendCmd.Text != string.Empty && this.txtReceiveCmd.Text != string.Empty && this.txtDefineFlowCarType.Text != string.Empty && this.txtDefineFlowSleepTime.Text != string.Empty) //this.txtDefineFlowReceiveNum.Text != string.Empty) { //int result = configer.UpdateDefineFlow(this.txtDefineFlowName.Text, this.txtSendCmd.Text, this.txtReceiveCmd.Text, this.cbDefineFlowEnable.Checked + "", this.txtDefineFlowCarType.Text, this.txtDefineFlowSleepTime.Text, this.txtDefineFlowID.Text); if (!int.TryParse(txtDefineFlowID.Text.Trim(), out int ID) || !int.TryParse(txtDefineFlowCarType.Text.Trim(), out int sleepTime) || !int.TryParse(txtDefineFlowSleepTime.Text.Trim(), out int receiveNum)) { MessageBox.Show("序号,时间间隔,或接收帧数不是数字,请重新设置!"); return; } var itme = new T_DefineFlow { id = ID, flowname = txtDefineFlowName.Text.Trim(), sendcmd = txtSendCmd.Text.Trim(), receivecmd = txtReceiveCmd.Text.Trim(), enabled = cbDefineFlowEnable.Checked, sleeptime = sleepTime, receivenum = receiveNum, }; int result = await Comm.SqlComm.UpdateDefineFlow(itme); if (result == 1) { FillDefineFlow(); MessageBox.Show("更新流程成功!"); } else { MessageBox.Show("更新流程失败!"); } } } catch (Exception ex) { logger.Error(ex.Message + "***" + ex.StackTrace); } }
/// <summary> /// 更新流程 /// </summary> /// <returns></returns> public async static Task <int> UpdateDefineFlow(T_DefineFlow t_DefineFlow) { try { return(await _sqlSugar.Updateable(t_DefineFlow) .UpdateColumns(t => new { t.flowname, t.sendcmd, t.receivecmd, t.enabled, t.sleeptime, t.receivenum }) .ExecuteCommandAsync()); } catch (Exception ex) { Log.Error($"修改记录失败!\r\n flowname={t_DefineFlow.flowname},sendcmd={ t_DefineFlow.sendcmd},receivecmd={ t_DefineFlow.receivecmd}," + $"enabled={ t_DefineFlow.enabled},sleeptime= {t_DefineFlow.sleeptime}, receivenum={t_DefineFlow.receivenum}", ex); } return(0); }