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