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