public string NewOpenDoor(string newLockId, string userId) { if (!authentication.ValideLockUser()) { return("{'headerError'}"); } NewLockManager managerNew = new NewLockManager(); Dictionary <string, string> ret = new Dictionary <string, string>(); //传值校验 Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("newLockId", newLockId); dic.Add("UserId", userId); string returnFiled = managerNew.checkIsNullFild(dic); if (returnFiled != string.Empty) { ret.Add("ret", "1"); ret.Add("msg", "字段" + returnFiled + "不允许为空!"); return(JSONHelper.ToJson(ret)); } //判断是否授权 if (managerNew.GetIsEnterprise(userId) == "2") { ret.Add("ret", "1"); ret.Add("msg", "我公司暂无给贵公司授权,请核对再操做!"); return(JSONHelper.ToJson(ret)); } //判断接口是否授权 if (!managerNew.GetIsInterfacePermissions("9", userId)) { ret.Add("ret", "1"); ret.Add("msg", "我公司暂无给贵公司授权该接口,请核对再操做!"); return(JSONHelper.ToJson(ret)); } string lockId = managerNew.getDeviceID(newLockId, "DeviceID"); if (lockId == string.Empty) { ret.Add("ret", "1"); ret.Add("msg", "未获取该家庭锁信息!"); return(JSONHelper.ToJson(ret)); } //开锁 string open = managerNew.openDoorSDK(lockId, userId); Dictionary <string, object> returnInfo = new Dictionary <string, object>(); returnInfo = JSONHelper.FromJson <Dictionary <string, object> >(open); if (returnInfo["ret"].ToString() == "0") { ret.Add("ret", "0"); } else { ret.Add("ret", "1"); } ret.Add("msg", returnInfo["msg"].ToString()); return(JSONHelper.ToJson(ret)); }
public string NewSelPasswordICcard(string newLockId, int type, string userId) { if (!authentication.ValideLockUser()) { return("{'headerError'}"); } NewLockManager managerNew = new NewLockManager(); Dictionary <string, string> ret = new Dictionary <string, string>(); //传值校验 Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("newLockId", newLockId); dic.Add("type", type.ToString()); string returnFiled = managerNew.checkIsNullFild(dic); if (returnFiled != string.Empty) { ret.Add("ret", "1"); ret.Add("msg", "字段" + returnFiled + "不允许为空!"); return(JSONHelper.ToJson(ret)); } //判断是否授权 if (managerNew.GetIsEnterprise(userId) == "2") { ret.Add("ret", "1"); ret.Add("msg", "我公司暂无给贵公司授权,请核对再操做!"); return(JSONHelper.ToJson(ret)); } //判断接口是否授权 if (!managerNew.GetIsInterfacePermissions("12", userId)) { ret.Add("ret", "1"); ret.Add("msg", "我公司暂无给贵公司授权该接口,请核对再操做!"); return(JSONHelper.ToJson(ret)); } if (type != 1 && type != 2) { ret.Add("ret", "1"); ret.Add("msg", "type参数值超出允许范围!"); return(JSONHelper.ToJson(ret)); } string lockId = managerNew.getDeviceID(newLockId, "DeviceID"); string UserId = managerNew.getDeviceID(newLockId, "UserId"); if (lockId == string.Empty || userId == string.Empty) { ret.Add("ret", "1"); ret.Add("msg", "未获取该家庭锁信息!"); return(JSONHelper.ToJson(ret)); } RentInfoHelper helper = new RentInfoHelper(); if (type == 1) { ret.Add("ret", "0"); ret.Add("msg", helper.GetJSONInfo("select ID,LockID,ICCard,StartDate,EndDate,IsValid,UserId from v_RentICCard_view where LockID='" + lockId + " and Status='0' and UserId='" + UserId + "'and ICCard is not null and len(ICCard)>0")); return(JSONHelper.ToJson(ret)); } else { ret.Add("ret", "0"); ret.Add("msg", helper.GetJSONInfo("select ID,LockID,Password,StartDate,EndDate,IsValid,UserId from v_RentPass_view where LockID='" + lockId + "' and Status='0' and UserId='" + UserId + "'and IsAdd is not null and len(IsAdd)>0")); return(JSONHelper.ToJson(ret)); } }
public string NewAddPasswordICcard(string newLockId, string type, string pwdAndCard, string startTime, string endTime, string userId) { if (!authentication.ValideLockUser()) { return("{'headerError'}"); } NewLockManager managerNew = new NewLockManager(); Dictionary <string, string> ret = new Dictionary <string, string>(); //传值校验 Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("newLockId", newLockId); dic.Add("type", type); if (type == "1" || type == "2") { if (pwdAndCard == string.Empty) { ret.Add("ret", "1"); ret.Add("msg", "永久录入字段pwdAndCard不允许为空!"); return(JSONHelper.ToJson(ret)); } else { dic.Add("pwdAndCard", pwdAndCard); } } dic.Add("startTime", startTime); dic.Add("endTime", endTime); string returnFiled = managerNew.checkIsNullFild(dic); if (returnFiled != string.Empty) { ret.Add("ret", "1"); ret.Add("msg", "字段" + returnFiled + "不允许为空!"); return(JSONHelper.ToJson(ret)); } //是否给公司授权 if (managerNew.GetIsEnterprise(userId) == "2") { ret.Add("ret", "1"); ret.Add("msg", "我公司暂无给贵公司授权,请核对再操做!"); return(JSONHelper.ToJson(ret)); } //判断接口是否授权 if (!managerNew.GetIsInterfacePermissions("10", userId)) { ret.Add("ret", "1"); ret.Add("msg", "我公司暂无给贵公司授权该接口,请核对再操做!"); return(JSONHelper.ToJson(ret)); } string[] strArr = { "1", "2", "3", "4" }; bool exists = ((IList)strArr).Contains(type); if (!exists) { ret.Add("ret", "1"); ret.Add("msg", "type参数值超出允许范围!"); return(JSONHelper.ToJson(ret)); } string deviceId = managerNew.getDeviceID(newLockId, "DeviceID"); string UserId = managerNew.getDeviceID(newLockId, "UserId"); if (deviceId == string.Empty || userId == string.Empty) { ret.Add("ret", "1"); ret.Add("msg", "未获取该家庭锁信息!"); return(JSONHelper.ToJson(ret)); } return(managerNew.GetPostInterface(deviceId, UserId, type, pwdAndCard, startTime, endTime)); }
public string DeleteGatewayLock(string newLockID, int type, string userId) { if (!authentication.ValideLockUser()) { return("{'headerError'}"); } Dictionary <string, string> ret = new Dictionary <string, string>(); try { string LockInfo = string.Empty; NewLockManager managerNew = new NewLockManager(); //传值校验 Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("newLockID", newLockID); dic.Add("type", type.ToString()); string returnFiled = managerNew.checkIsNullFild(dic); if (returnFiled != string.Empty) { ret.Add("ret", "1"); ret.Add("msg", "字段" + returnFiled + "不允许为空!"); return(JSONHelper.ToJson(ret)); } //判断是否授权 if (managerNew.GetIsEnterprise(userId) == "2") { ret.Add("ret", "1"); ret.Add("msg", "我公司暂无给贵公司授权,请核对再操做!"); return(JSONHelper.ToJson(ret)); } //判断接口是否授权 if (!managerNew.GetIsInterfacePermissions("5", userId)) { ret.Add("ret", "1"); ret.Add("msg", "我公司暂无给贵公司授权该接口,请核对再操做!"); return(JSONHelper.ToJson(ret)); } if (type == 1) //删除网关 { LockInfo = managerNew.deleteGateway(newLockID); } else if (type == 2) //删除锁 { LockInfo = managerNew.deleteAddLock(newLockID); } else if (type == 3) //强制删除网关 { LockInfo = managerNew.forceDelGate(newLockID); } else if (type == 4) //删除家庭 { LockInfo = managerNew.deleteFamily(newLockID); } else { ret.Add("ret", "1"); ret.Add("msg", "type参数值超出允许范围!"); return(JSONHelper.ToJson(ret)); } Dictionary <string, object> returnInfo = new Dictionary <string, object>(); returnInfo = JSONHelper.FromJson <Dictionary <string, object> >(LockInfo); if (returnInfo["ret"].ToString() == "0") { ret.Add("ret", "0"); string lockId = managerNew.getDeviceID(newLockID, "DeviceID"); //删除所有密码 string delSqlPass = "******" + lockId + "'"; MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(delSqlPass)); //删除所有卡片 string delSqlIc = "Update Rent_Locks_ICCards set IsValid='0' where LockID='" + lockId + "'"; MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(delSqlIc)); if (type == 2) { string delSqlLock = "Update Rent_NewLock_Process set IsDeleteLock='' where NewLockID='" + newLockID + "'"; MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(delSqlLock)); } else if (type == 3) { string delSqlGate = "Update Rent_NewLock_Process set IsDeleteGateway='true', PinInfo='',IsCreateLock='', IsDeleteLock='' , IsCreateGateway='', GatewayId='', DevKey='' where NewLockID='" + newLockID + "'"; MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(delSqlGate)); } else if (type == 4) //删除家庭 { string delSql = string.Empty; delSql = "delete from Rent_NewLock_Process where NewLockID='" + newLockID + "'"; MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(delSql)); delSql = "delete from Rent_Locks where Memo='" + newLockID + "'"; MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(delSql)); delSql = "delete from Enterprise_Homeowner_Info where NewLockID='" + newLockID + "'"; MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(delSql)); } } else { ret.Add("ret", "1"); } ret.Add("msg", returnInfo["msg"].ToString()); } catch (Exception ex) { ret.Add("ret", "1"); ret.Add("msg", ex.Message); } return(JSONHelper.ToJson(ret)); }