public JsonResult HandleOrder(OrderInfo orderInfo)
{
string sql = "insert into houseOrdered(houseId,userId,orderTime,orderPhone) values (" + orderInfo.HouseId +
", " + GetUserId() + ", '" + orderInfo.OrderTime + "', '" + orderInfo.OrderPhone + "')";
return(Success(DataOperate.Create(sql)));
}
public JsonResult ApplyHouseRenewal(ApplyRenewal applyRenewal)
{
var sql = "insert into renewalContractApply(contractId,type,houseId,userId) values(" +
applyRenewal.ContractId + ",'" + applyRenewal.Type + "'," + applyRenewal.HouseId + "," +
GetUserId() + ")";
return(Success(DataOperate.Create(sql)));
}
public JsonResult ToBeOwner(ToBeOwner toBeOwner)
{
string sql = "INSERT INTO applyTobeowner (userId, houseCity, houseCommunity) VALUES (" + GetUserId() +
", '" +
toBeOwner.HouseCity + "', '" + toBeOwner.HouseCommunity + "');";
return(Success(DataOperate.Create(sql)));
}
public JsonResult HandleCollect(HandleCollect handleCollect)
{
string sql = "";
if (handleCollect.Liked)
{
sql = "insert into houseCollected(houseId, userId) values (" + handleCollect.HouseId + ", " + GetUserId() + ")";
}
else
{
sql = "delete from houseCollected where houseId=" + handleCollect.HouseId + " and userId=" + GetUserId();
}
return(Success(DataOperate.Create(sql)));
}
