private void CmdQueryBtn_Click(object sender, EventArgs e) { string strWhe = string.Empty; try { string strSql = "select Cmd_Sno, Cmd_Mode, Cmd_Sts, Stn_No, Loc, New_Loc, Height, substring(Crt_Date,1,10) as Crt_Dte, substring(Crt_Date,12,8) as Crt_Tim," + "User_Id, Plt_ID, Trace from Cmd_Mst where Cmd_Sts in ('0','1') "; if (cmbCmdMode.SelectedIndex != 0) { strWhe += string.Format(" and Cmd_Mode='{0}'", cmbCmdMode.Text.Split("-".ToCharArray())[0]); } if (CmdSnoCtl.Text != "命令号") { strWhe += string.Format(" and Cmd_Sno='{0}'", GCtrl.C5Sno(int.Parse(CmdSnoCtl.Text))); } strSql = strSql + strWhe; dtCmdQuery.Clear(); Globals.DB.ExecGetTable(strSql, ref dtCmdQuery); dgvCmdMst.ClearSelection(); } catch (Exception ex) { Log.WriteLog(ex); } }
private void CmdSnoCtl_Leave(object sender, EventArgs e) { try { CmdSnoCtl.Text = GCtrl.C5Sno(int.Parse(CmdSnoCtl.Text)); } catch (Exception) { CmdSnoCtl.Text = "命令号"; } }
private void modCmdBtn_Click(object sender, EventArgs e) { DataRow drCmd = null; //if (!Globals.bLogin) { MsgBox.Warning("请先到用户登录模块登录,谢谢!"); return; } if (!Globals.CtlValidate(cStnNoCtl, cTraceCtl, cPriCtl, cmbCSts)) { MsgBox.Warning(StrTables.MSG_NOT_FULL); return; } if (MsgBox.Question("是否确认执行?") == DialogResult.No) { return; } try { string sSql = string.Format("select * from Cmd_Mst where Cmd_Sno='{0}'", GCtrl.C5Sno(cmbCmdSno.Text)); if (!Globals.DB.ExecGetRow(sSql, ref drCmd) || drCmd == null) { MsgBox.Warning("查无记录!"); return; } MakeSql mSql = new MakeSql("Cmd_Mst", SqlType.Update); mSql.AddStrWhere(drCmd, "Cmd_Sno"); mSql.SetStrValue("Cmd_Sts", cmbCSts.Text.Split("-".ToCharArray())[0]); mSql.SetStrValue("Stn_No", cStnNoCtl.Text.Trim()); mSql.SetStrValue("Trace", cTraceCtl.Text.Trim()); mSql.SetStrValue("Prty", cPriCtl.Text.Trim()); sSql = mSql.GetSql(); if (Globals.DB.ExecSql(sSql)) { MsgBox.Information("操作成功!"); } } catch (Exception ex) { Log.WriteLog(ex); } finally { flushCmdBtn_Click(null, null); } }