public bool DeleteOwnerToTenant(DeleteOwnerToTenant deleteOwnerToTenant)
{
var selSql = "select * from contract where userId=" + deleteOwnerToTenant.Id;
string[] sqlT = new string[2];
int i = 0;
sqlT[i++] = "update house set houseStatus = 'unactivated' where userId=" + deleteOwnerToTenant.Id;
sqlT[i] = "update user SET type = 'tenant' where id= " + deleteOwnerToTenant.Id;
DataSet allContract = DataOperate.FindAll(selSql);
if (allContract.Tables.Count == 1 && allContract.Tables[0].Rows.Count == 0)
{
DataOperate.Update(sqlT[i]);
return(true);
}
else if (GetContractBool(allContract))
{
return(DataOperate.ExecTransaction(sqlT));
}
else
{
return(false);
}
}
public JsonResult GetHouseListToTable(GetHouseListToTable getHouseListToTable)
{
var selSql1 = "select * from house ";
DataSet allHouse = DataOperate.FindAll(selSql1);
string[] signed = { "activated", "empty" };
// 检查房主合同状态 修改房源状态
foreach (DataRow row in allHouse.Tables[0].Rows)
{
if (signed.Contains(row["rentStatus"].ToString()))
{
var selSql2 = "select * from contract where type='withOwner' and contractStatus = 'undue' and houseId=" + row["id"].ToString();
DataSet allHouseContract = DataOperate.FindAll(selSql2);
if (allHouseContract.Tables.Count == 1 && allHouseContract.Tables[0].Rows.Count == 0)
{
DataOperate.Update("update house set rentStatus='invalid' where id=" + row["id"]);
}
}
}
var countSql = "select count(*) from house";
var sql = "select * from house";
if (getHouseListToTable.Status.Length > 0)
{
countSql += " where rentStatus in ('" + string.Join("','", getHouseListToTable.Status) + "')";
sql += " where rentStatus in ('" + string.Join("','", getHouseListToTable.Status) + "')";
}
sql += " order by id desc limit " + (getHouseListToTable.PageNum - 1) * getHouseListToTable.PageSize + "," + getHouseListToTable.PageSize;
return(Success(new { totalCount = DataOperate.Sele(countSql), data = DataOperate.FindAll(sql) }));
}
public JsonResult PassHouseCommission(PassHouseCommission passHouseCommission)
{
var sql = "UPDATE house SET rentStatus = 'unactivated', adminId = " + GetAdminId() +
" WHERE id = " + passHouseCommission.Id;
return(Success(DataOperate.Update(sql)));
}
public JsonResult RejectHouseCommission(RejectHouseCommission rejectHouseCommission)
{
var sql = "UPDATE house SET rentStatus = 'reject', adminId = " + GetAdminId() +
" WHERE id = " + rejectHouseCommission.Id;
return(Success(DataOperate.Update(sql)));
}
public JsonResult PassHouseOrder(PassHouseOrder passHouseOrder)
{
var sql = "UPDATE houseOrdered SET orderStatus = 'done', adminId = " + GetAdminId() +
" WHERE id = " + passHouseOrder.Id;
return(Success(DataOperate.Update(sql)));
}
public JsonResult RejectHouseOrder(RejectHouseOrder rejectHouseOrder)
{
var sql = "UPDATE houseOrdered SET orderStatus = 'reject', adminId = " + GetAdminId() +
" WHERE id = " + rejectHouseOrder.Id;
return(Success(DataOperate.Update(sql)));
}
public JsonResult RemoveCollect(RemoveCollect removeCollect)
{
string sql = "delete from houseCollected where houseId=" + removeCollect.HouseId + " and userId=" +
GetUserId();
return(Success(DataOperate.Update(sql)));
}
public JsonResult RejectOwnerRenewalApply(RejectOwnerRenewalApply rejectOwnerRenewalApply)
{
var sql = "update renewalContractApply set applyStatus='reject', adminId=" + GetAdminId() + " where id=" +
rejectOwnerRenewalApply.Id;
return(Success(DataOperate.Update(sql)));
}
public JsonResult PerfectInfo(CurrentAdmin currentAdmin)
{
string sql = "update admin set name='" + currentAdmin.Name + "', sex='" + currentAdmin.Sex +
"', cardNum='" + currentAdmin.CardNum + "', phone='" + currentAdmin.Phone + "', native='" +
currentAdmin.Native + "', major='" + currentAdmin.Major + "', avatar='" + currentAdmin.Avatar +
"' where id= " + GetAdminId();
return(Success(DataOperate.Update(sql)));
}
public JsonResult PerfectInfo(CurrentUser currentUser)
{
string sql = "update user set name='" + currentUser.Name + "', sex='" + currentUser.Sex + "', cardNum='" +
currentUser.CardNum + "', phone='" + currentUser.Phone + "', native='" + currentUser.Native +
"', job='" + currentUser.Job +
"', avatar='" + currentUser.Avatar + "' where id= " + GetUserId();
return(Success(DataOperate.Update(sql)));
}
public bool DeleteTenant(TenantToDelete tenantToDelete)
{
string selSql = "select * from contract where userId=" + tenantToDelete.Id;
string delSql = "update user set type='cancelled' where id=" + tenantToDelete.Id;
DataSet allContract = DataOperate.FindAll(selSql);
if ((allContract.Tables.Count == 1 && allContract.Tables[0].Rows.Count == 0) ||
GetContractBool(allContract))
{
DataOperate.Update(delSql);
return(true);
}
return(false);
}
public JsonResult UpdatePwd(UpdatePwd updatePwd)
{
string sql1 = "select * from admin where id=" + GetAdminId();
var r = DataOperate.FindOne(sql1);
if (r == null)
{
return(Fail(false, 2001));
}
else
{
if (r["pwd"].ToString() == updatePwd.Pwd)
{
string sql2 = "update admin set pwd='" + updatePwd.NewPwd + "' where id=" + GetAdminId();
return(Success(DataOperate.Update(sql2)));
}
else
{
return(Fail(false, 2002));
}
}
}
public JsonResult GetOwnerContractList()
{
var sql = "select * from contract where type='withOwner' and contractStatus != 'invalid'";
DataSet allContract = DataOperate.FindAll(sql);
// 检查合同状态并修改
foreach (DataRow row in allContract.Tables[0].Rows)
{
var expired = (DateTime.Parse(row["endAt"].ToString()) <
DateTime.Parse(DateTime.Now.ToString()));
var contractStatus = expired ? "fallDue" : "undue";
var newSql = "update contract set contractStatus='" + contractStatus + "' where id=" +
row["id"].ToString();
DataOperate.Update(newSql);
}
var sqlParent = "select * from contract where type = 'withOwner' and parentNum is null and contractStatus != 'invalid'";
var sqlChildren = "select * from contract where type = 'withOwner' and parentNum is not null and contractStatus != 'invalid'";
var parentList = new List <OwnerContract>();
DataSet parentRows = DataOperate.FindAll(sqlParent);
DataSet childrenRows = DataOperate.FindAll(sqlChildren);
foreach (DataRow row in parentRows.Tables[0].Rows)
{
var ownerContract = new OwnerContract();
foreach (var dataColumn in row.Table.Columns)
{
ownerContract.SetAttribute(dataColumn.ToString(), row[dataColumn.ToString()].ToString());
}
ownerContract.Children = GetChildrenByParentId(childrenRows, ownerContract.Id.ToString());
parentList.Add(ownerContract);
}
return(Success(parentList));
}
public JsonResult ChangePayStatus(ChangePayStatus changePayStatus)
{
return(Success(DataOperate.Update("update transactions set tranStatus = 'paid', tranDate = '" + changePayStatus.CurrentTime +
"' where id=" + changePayStatus.id)));
}
public JsonResult RejectTobeOwnerApply(RejectTobeOwnerApply rejectTobeOwnerApply)
{
string sql = "update applyTobeowner set applyStatus = 'reject', adminId = " + GetAdminId() + " where id = " + rejectTobeOwnerApply.Id + ";";
return(Success(DataOperate.Update(sql)));
}
public JsonResult RemoveOrder(RemoveOrder removeOrder)
{
string sql = "delete from houseOrdered where houseId=" + removeOrder.HouseId + " and userId=" + GetUserId();
return(Success(DataOperate.Update(sql)));
}
