}//号牌登记
public static string UpdateLicense(lisence l, int num)
{
db0.open();
string t;
using (db0.sqlc){
StringBuilder sb = new StringBuilder();
sb.AppendLine("declare @s int");
sb.AppendLine("select @s=[recorf]+@score from [Dinfo] where [ddrivingno]='@id'");
sb.AppendLine("if @s>=12");
sb.AppendLine("begin");
sb.AppendLine("update [Dinfo] set [recorf]=12,[stat]='暂扣' where [ddrivingno]='@id'");
sb.AppendLine();
sb.AppendLine("end");
sb.AppendLine("else");
sb.AppendLine("update [Dinfo] set [recorf]=@s where [ddrivingno]='@id'");
sb.AppendLine();
sb.AppendFormat("select [recorf] from [Dinfo] where [ddrivingno]='@id'");
SqlCommand cmd = new SqlCommand(sb.ToString(), db0.sqlc);
SqlParameter[] sp = new SqlParameter[] {
new SqlParameter("id", l.Licenseno),
new SqlParameter("score", num)
};
cmd.Parameters.Add(sp);
int t0 = Convert.ToInt32(cmd.ExecuteScalar());
if (t0 == 12)
{
t = "编号为" + l.Licenseno + "的驾照记分已满12分，执行暂扣";
}
else if (t0 != 0)
{
t = "登记成功，编号为" + l.Licenseno + "的驾照记分为" + t0;
}
else
{
t = "查无此照\n";
}
return(t);
}
}//驾照扣分
}//用户驾照查询
public static bool RegisterLicense(lisence l)
{
db0.open();
using (db0.sqlc)
{
string sql = "update [Dinfo] set [stat]='@state' where [ddrivingno]='@id'";
SqlCommand cmd0 = new SqlCommand(sql, db0.sqlc);
SqlParameter[] sp = new SqlParameter[] {
new SqlParameter("id", l.Licenseno),
new SqlParameter("state", l.State)
};
cmd.Parameters.Add(sp);
if (cmd0.ExecuteNonQuery() != 0)
{
return(true);
}
else
{
return(false);
}
}
}//驾照补换登记
public static lisence GetPersonInfo(string id)
{
db0.open();
string sql = "select * from [Dinfo] where [ddrivingno]='@id'";
lisence l = new lisence();
using (db0.sqlc)
{
SqlCommand cmd = new SqlCommand(sql, db0.sqlc);
SqlParameter sp = new SqlParameter("id", id);
cmd.Parameters.Add(sp);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
l.Licenseno = id;
l.Type = dr["dtype"].ToString();
l.Date = DateTime.Parse(dr["date"].ToString());
l.Record = int.Parse(dr["recorf"].ToString());
l.State = dr["stat"].ToString();
}
}
return(l);
}//用户驾照查询
