//根据身份证号查询客户姓名，显示在要填写的订单上
public string searchUserName(string id /*身份证号码*/)
{
string sql = "select Uname from UserInfo where Uid='" + id + "'";
string username = DatabaseLink.GetSingleData(sql);//将查询结果存于table表中
return(username);
}
//根据身份证号查询客户手机号码，显示在订单上
public string searchTelephone(string id /*身份证号码*/)
{
string sql = "select Laccount from LoginInfo where Lid='" + id + "'";
string telephone = DatabaseLink.GetSingleData(sql);//将查询结果存于table表中
return(telephone);
}
//根据类型编号查询客房类型
public string searchRoomType(string id /*客房类型编号*/)
{
string sql = "select Ttype from RoomType where Tid='" + id + "'";
string type = DatabaseLink.GetSingleData(sql);//将查询结果存于table表中
return(type);
}
