/// <summary> /// 更新检测站设置 /// </summary> /// <param name="jcz">JCZXXB</param> /// <returns>bool</returns> public bool Update_jcz(JCZXXB jcz) { string sql = "update jczxxb set jczbh=@jczbh,jczmc=@jczmc,jczdh=@jczdh,jczdz=@jczdz,jczfzr=@jczfzr"; SqlParameter[] spr = { new SqlParameter("@jczbh", jcz.JCZBH), new SqlParameter("@jczmc", jcz.JCZMC), new SqlParameter("@jczdh", jcz.JCZDH), new SqlParameter("@jczdz", jcz.JCZDZ), new SqlParameter("@jczfzr", jcz.JCZFZR) }; try { if (DBHelperSQL.Execute(sql, spr) > 0) { return(true); } else { return(false); } } catch (Exception) { throw; } }
private void init_sql() { try { toolStripLabelSql.Text = "正在初始化数据库..."; ip = tool.getIp(); //获取本机ip jcxxxb = jcxxx.GetModel(ip); //初始化检测线 Login newlogin = new Login(); newlogin.ShowDialog(); if (loginSuccess) { enable_panel(); labelUserName.Text = loginYg.User_Name; } else { disabled_panel(); labelUserName.Text = "未登录"; } if (jcxxxb.JCXBH != "-2") //在服务器找到了本机IP配置的检测线 { jczxxb = jczxx.Get_jczxx(); label_jcxbh.Text = jczxxb.JCZBH; label_jczmc.Text = jczxxb.JCZMC; this.Text = "沈阳大路机动车检测站:" + jcxxxb.JCXMC; } else { disabled_panel(); //禁止相应操作 MessageBox.Show("本机" + ip + "在配置之前,无法作为检测线使用。", "系统提示"); } toolStripLabelSql.Text = "数据库连接正常"; } catch { toolStripLabelSql.Text = "数据库连接异常"; disabled_panel(); MessageBox.Show("数据库未连接成功,请检查配置文件是否正确", "系统提示"); } }
/// <summary> /// 获取检测站设置 /// </summary> /// <returns>JCZXXB</returns> public JCZXXB Get_JCZ() { string sql = "select * from jczxxb"; try { DataTable dt = new DataTable(); JCZXXB jcz = new JCZXXB(); dt = DBHelperSQL.GetDataTable(sql, CommandType.Text); if (dt.Rows.Count > 0) { jcz.JCZBH = dt.Rows[0]["JCZBH"].ToString(); jcz.JCZMC = dt.Rows[0]["JCZMC"].ToString(); jcz.JCZDZ = dt.Rows[0]["JCZDZ"].ToString(); jcz.JCZDH = dt.Rows[0]["JCZDH"].ToString(); jcz.JCZFZR = dt.Rows[0]["JCZFZR"].ToString(); } return(jcz); } catch (Exception) { throw; } }