/// <summary>
/// 查询停车记录
/// </summary>
/// <returns></returns>
public ActionResult GetParkingList(int status, bool number = false)
{
try
{
string auth = AppUserToken;
if (auth.IsEmpty())
{
//没有登录
//
return(RedirectToAction("Index", "ErrorPrompt", new { message = "用户登录失败" }));
}
else if (auth == "-1")
{
return(RedirectToAction("Register", "ParkingPayment"));
}
int pageIndex = 1;
int pageSize = 35;
ParkingList pklist = ParkingApi.bb(status, pageIndex, pageSize, auth);
ParkingList pk = JsonConvert.DeserializeObject <ParkingList>(JsonHelper.GetJsonString(pklist));
return(View(pk));
}
catch (Exception e)
{
return(View());
}
}
public MainWindow(ParkingList parkingList, ISnackbarMessageQueue messageQueue)
{
InitializeComponent();
DataContext = this;
ContentControl.Content = parkingList;
MessageQueue = messageQueue;
}
private void BindParkList()
{
ServiceAreaManager areaManager = new ServiceAreaManager();
DataTable parkingList = areaManager.GetAllParkings(1, 9999);
ParkingList.DataSource = parkingList;
ParkingList.DataTextField = "ThisName";
ParkingList.DataValueField = "ID";
ParkingList.DataBind();
}
public static ParkingList GetBuldings()
{
ParkingList lst = new ParkingList();
using (SqlConnection Conn = new SqlConnection("server=SURESHJALAJA-PC;database=Parking;uid=sa;password=suresh;"))
{
using (SqlCommand Cmd = new SqlCommand(Constants.Proc.USP_GET_BUILDINGS, Conn))
{
Cmd.CommandType = CommandType.StoredProcedure;
Conn.Open();
using (SqlDataReader dr = Cmd.ExecuteReader())
{
while (dr.Read())
{
ParkingBO Obj = new ParkingBO();
Obj.BuildingId = Convert.ToInt32(dr["BuildingID"]);
Obj.BuildingName = Convert.ToString(dr["BuildingName"]);
lst.Add(Obj);
}
}
}
}
return lst;
}
public static ParkingList GetParkingSlotsByLevelID(int levelID)
{
ParkingList lst = new ParkingList();
using (SqlConnection Conn = new SqlConnection("server=SURESHJALAJA-PC;database=Parking;uid=sa;password=suresh;"))
{
using (SqlCommand Cmd = new SqlCommand(Constants.Proc.USP_GET_PARKINGSLOTSBYLEVELID, Conn))
{
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.Parameters.Add("@LevelID", SqlDbType.Int).Value = levelID;
Conn.Open();
using (SqlDataReader dr = Cmd.ExecuteReader())
{
while (dr.Read())
{
ParkingBO Obj = new ParkingBO();
Obj.ParkingID = Convert.ToInt32(dr["ParkingID"]);
Obj.ParkingName = Convert.ToString(dr["ParkingName"]);
Obj.LevelID = Convert.ToInt32(dr["LevelID"]);
lst.Add(Obj);
}
}
}
}
return lst;
}
