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 PassOwnerRenewalApply(PassOwnerRenewalApply passOwnerRenewalApply)
{
string[] sqlT = new string[2];
int i = 0;
sqlT[i++] = "update renewalContractApply set applyStatus='pass', adminId=" + GetAdminId() + " where id=" +
passOwnerRenewalApply.Id;
sqlT[i] = "update house set rentStatus='unactivated' where id=" + passOwnerRenewalApply.HouseId;
return(Success(DataOperate.ExecTransaction(sqlT)));
}
public JsonResult DissolveTenantContract(DissolveTenantContract dissolveTenantContract)
{
string[] sqlT = new string[3];
int i = 0;
sqlT[i++] = "update contract set contractStatus='invalid' where id=" + dissolveTenantContract.ContractId;
sqlT[i++] = "update transactions set tranStatus='invalid' where tranStatus='unpaid' and contractId=" + dissolveTenantContract.ContractId;
sqlT[i] = "update house set rentStatus='empty' where id=" + dissolveTenantContract.HouseId;
return(Success(DataOperate.ExecTransaction(sqlT)));
}
public JsonResult PassTobeOwnerApply(PassTobeOwnerApply passTobeOwnerApply)
{
string sql = "select * from applyTobeowner where id = " + passTobeOwnerApply.Id + "";
var record = DataOperate.FindOne(sql);
string updateSql = "UPDATE applyTobeowner SET applyStatus = 'pass', adminId = " + GetAdminId() +
" WHERE id = " + passTobeOwnerApply.Id + " and applyStatus = 'todo'";
string updateUserSql = "UPDATE user SET type = 'owner' WHERE id = " + record["userId"].ToString() + ";";
return(Success(DataOperate.ExecTransaction(new[] { updateSql, updateUserSql })));
}
public JsonResult UpdateInfo(UpdateForm updateForm)
{
var sqls = new List <string>();
sqls.Add("update admin set name='" + updateForm.Name + "', sex='" + updateForm.Sex + "', phone='" +
updateForm.Phone + "', native='" + updateForm.Native + "', major='" + updateForm.Major +
"', avatar='" + updateForm.Avatar + "' where id= " + GetAdminId());
sqls.Add("delete from selfDesc where selfId=" + GetAdminId());
foreach (var updateDataSelfDescTag in updateForm.SelfDescTags)
{
sqls.Add("insert into selfDesc (selfId,tag) values (" + GetAdminId() + ",'" +
updateDataSelfDescTag + "')");
}
return(Success(DataOperate.ExecTransaction(sqls.ToArray())));
}
public JsonResult DissolveHouseContract(DissolveHouseContract dissolveHouseContract)
{
string sql =
"select count(*) from contract where type='withTenant' and contractStatus='undue' and houseId=" +
dissolveHouseContract.HouseId;
string[] sqlT = new string[4];
int i = 0;
sqlT[i++] = "update contract set contractStatus='invalid' where id=" + dissolveHouseContract.ContractId;
sqlT[i++] = "update transactions set tranStatus='invalid' where tranStatus='unpaid' and contractId=" + dissolveHouseContract.ContractId;
sqlT[i++] = "update house set rentStatus='invalid' where id=" + dissolveHouseContract.HouseId;
sqlT[i] = "delete from resOfHouse where houseId=" + dissolveHouseContract.HouseId;
if (DataOperate.Sele(sql) == 0)
{
return(Success(DataOperate.ExecTransaction(sqlT)));
}
else
{
return(Fail("该合同关联房源已被租用，不可解约..", 3001));
}
}
