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