/// <summary>
/// 改变rider所在的区域
/// </summary>
public string Change(webReq req)
{
ResultForWeb r = new ResultForWeb();
r.HttpCode = 200;
r.Message = "";
r.data = "{}";
if (Session["pfId"] == null)
{
r.HttpCode = 300;
return(JsonConvert.SerializeObject(r));
}
var sourceId = req.sourceId;
var riderId = req.riderId;
var areaId = req.areaId;
RiderInfo rider1 = new RiderInfo();
rider1.riderAreaId = 0;
rider1.id = sourceId;
RiderInfoOper.Instance.Update(rider1);
RiderInfo rider2 = new RiderInfo();
rider2.id = riderId;
rider2.riderAreaId = areaId;
RiderInfoOper.Instance.Update(rider2);
return(JsonConvert.SerializeObject(r));
}
public HttpResponseMessage SetArea(SetAreaReq req)
{
var riderId = Convert.ToInt32(req.riderId);
var tokenStr = req.Token;
Token token = CacheHelper.GetRiderToken(tokenStr);
if (token == null)
{
return(ControllerHelper.Instance.JsonResult(400, "token失效"));
}
if (token.Payload.UserID != riderId)
{
return(ControllerHelper.Instance.JsonResult(400, "token错误"));
}
var areaId = Convert.ToInt32(req.areaId);
//rider.riderAreaId = areaId;
try
{
var rider = new RiderInfo();
rider.id = riderId;
rider.riderAreaId = areaId;
RiderInfoOper.Instance.Update(rider);
return(ControllerHelper.Instance.JsonResult(200, "设置成功"));
}
catch (Exception e)
{
return(ControllerHelper.Instance.JsonResult(500, "服务器错误"));
}
}
public RiderPosition(RiderInfo rider)
{
riderId = rider.id;
lat = rider.lat;
lng = rider.lng;
riderType = (int)rider.riderType;
}
/// <summary>
/// add
/// </summary>
/// <param name="RiderInfo"></param>
/// <returns></returns>
public int Add(RiderInfo model)
{
var str = GetInsertStr(model) + " select @@identity";
var dict = GetParameters(model);
return(Convert.ToInt32(SqlHelperHere.ExecuteScalar(str, dict)));
}
public HttpResponseMessage SetType(RiderReq req)
{
var riderId = Convert.ToInt32(req.riderId);
var tokenStr = req.Token;
Token token = CacheHelper.GetRiderToken(tokenStr);
if (token == null)
{
return(ControllerHelper.Instance.JsonResult(400, "token失效"));
}
if (token.Payload.UserID != riderId)
{
return(ControllerHelper.Instance.JsonResult(400, "token错误"));
}
var rider = RiderInfoOper.Instance.GetById(riderId);
if (rider.riderType != 2)
{
if (rider.riderType == 1)
{
rider.riderType = 0;
}
else
{
rider.riderType = 1;
}
}
//var temp = rider.riderType + 1;
//rider.riderType = temp > 2 ? 0 : temp;
try
{
var riderHere = new RiderInfo();
riderHere.id = rider.id;
riderHere.riderType = rider.riderType;
RiderInfoOper.Instance.Update(riderHere);
if (rider.riderType == 2)
{
var ua = UserAddressOper.Instance.GetByRiderId(riderId);
if (ua == null)
{
ua = new UserAddress();
ua.riderId = riderId;
var rp = CacheHelper.GetRiderPosition(riderId);
ua.lat = rp.lat;
ua.lng = rp.lng;
ua.mapAddress = rider.mapAddress;
ua.phone = rider.phone;
UserAddressOper.Instance.Add(ua);
}
}
return(ControllerHelper.Instance.JsonResult(200, "riderType", rider.riderType.ToString(), "更换成功"));
}
catch (Exception e)
{
return(ControllerHelper.Instance.JsonResult(500, "更换失败"));
}
}
/// <summary>
/// del
/// </summary>
/// <param name="RiderInfo"></param>
/// <returns></returns>
public void Delete(int id)
{
RiderInfo model = new RiderInfo();
model.isDeleted = true;
model.id = id;
Update(model);
}
/// <summary>
/// 骑手的所属区域设为0
/// </summary>
/// <param name="riderId"></param>
public void RemoveArea(int riderId)
{
RiderInfo rider = new RiderInfo();
rider.id = riderId;
rider.riderAreaId = 0;
Update(rider);
}
/// <summary>
/// update
/// </summary>
/// <param name="RiderInfo"></param>
/// <returns></returns>
public void Update(RiderInfo model)
{
//CacheHelper.LockCache("RiderInfo");
var str = GetUpdateStr(model);
var dict = GetParameters(model);
SqlHelperHere.ExcuteNon(str, dict);
//CacheHelper.ReleaseLock("RiderInfo");
}
public riderType2(RiderInfo rider)
{
riderId = rider.id;
riderName = rider.name;
address = rider.mapAddress;
var rp = CacheHelper.GetRiderPosition(riderId);
lat = rp.lat;
lng = rp.lng;
}
/// <summary>
/// 设置骑手账号token
/// </summary>
/// <param name="rider"></param>
/// <returns></returns>
public static Token SetRiderToken(RiderInfo rider)
{
Token token = new Token
{
Payload = new Payload
{
exp = DateTime.Now.AddDays(TokenInvalidOutTimeDays).ToString(),
UserID = rider.id,
UserName = rider.name
}
};
cache.Set("Ta_RiderToken_" + token.Payload.UserID, token, DateTime.Now.AddDays(TokenInvalidOutTimeDays));
return(token);
}
//
// GET: /RiderStock/
//RiderStockOper oper = new RiderStockOper();
//RiderInfoOper riderOper = new RiderInfoOper();
//FoodTagInfoOper ftOper = new FoodTagInfoOper();
public ActionResult Index()
{
if (Session["pfId"] == null)
{
return(View("_Login"));
}
var riderId = Convert.ToInt32(Request["riderId"]);
ViewBag.riderId = riderId;
var riderNo = Request["riderNo"];
RiderInfo rider = RiderInfoOper.Instance.GetById(riderId);
ViewBag.areaId = rider.riderAreaId;
ViewBag.riderNo = rider.riderNo;
ViewBag.riderName = rider.name;
return(View());
}
public void RegisterPlayerRider(Rider rider, bool enemy)
{
GameObject newRiderInfo = Instantiate(enemy ? EnemyRiderInfoPrefab.gameObject : RiderInfoPrefab.gameObject);
newRiderInfo.transform.SetParent(transform);
newRiderInfo.GetComponent <RectTransform>().anchoredPosition = new Vector3(enemy ? Screen.width - EnemyStartX : StartX, (enemy ? m_enemyHeight : m_height) + StartY, 0.0f);
if (enemy)
{
m_enemyHeight -= SpacingY;
}
else
{
m_height -= SpacingY;
}
RiderInfo newInfo = newRiderInfo.GetComponent <RiderInfo>();
newInfo.SetOwnerRider(rider);
newInfo.SetPortraitSprite(RiderImages[m_playerRiderInfo.Count]);
m_playerRiderInfo.Add(newInfo);
}
public HttpResponseMessage ToggleRiderStatus(RiderReq req)
{
var riderId = Convert.ToInt32(req.riderId);
var tokenStr = req.Token;
Token token = CacheHelper.GetRiderToken(tokenStr);
if (token == null)
{
return(ControllerHelper.Instance.JsonResult(400, "token失效"));
}
if (token.Payload.UserID != riderId)
{
return(ControllerHelper.Instance.JsonResult(400, "token错误"));
}
var rider = RiderInfoOper.Instance.GetById(riderId);
if ((bool)rider.riderStatus)
{
rider.riderStatus = false;
}
else
{
rider.riderStatus = true;
}
var riderHere = new RiderInfo();
riderHere.id = riderId;
riderHere.riderStatus = rider.riderStatus;
RiderInfoOper.Instance.Update(riderHere);
JObject jo = new JObject();
jo.Add("riderStatus", rider.riderStatus);
return(ControllerHelper.Instance.JsonResult(200, JsonConvert.SerializeObject(jo), ""));
}
/// <summary>
/// 插入
/// </summary>
/// <param name="riderinfo"></param>
/// <returns>是否成功</returns>
public string GetInsertStr(RiderInfo riderinfo)
{
StringBuilder part1 = new StringBuilder();
StringBuilder part2 = new StringBuilder();
if (riderinfo.riderAccount != null)
{
part1.Append("riderAccount,");
part2.Append("@riderAccount,");
}
if (riderinfo.riderPwd != null)
{
part1.Append("riderPwd,");
part2.Append("@riderPwd,");
}
if (riderinfo.riderType != null)
{
part1.Append("riderType,");
part2.Append("@riderType,");
}
if (riderinfo.riderStatus != null)
{
part1.Append("riderStatus,");
part2.Append("@riderStatus,");
}
if (riderinfo.riderAreaId != null)
{
part1.Append("riderAreaId,");
part2.Append("@riderAreaId,");
}
if (riderinfo.isDeleted != null)
{
part1.Append("isDeleted,");
part2.Append("@isDeleted,");
}
if (riderinfo.riderNo != null)
{
part1.Append("riderNo,");
part2.Append("@riderNo,");
}
if (riderinfo.sexType != null)
{
part1.Append("sexType,");
part2.Append("@sexType,");
}
if (riderinfo.name != null)
{
part1.Append("name,");
part2.Append("@name,");
}
if (riderinfo.phone != null)
{
part1.Append("phone,");
part2.Append("@phone,");
}
if (riderinfo.deviceToken != null)
{
part1.Append("deviceToken,");
part2.Append("@deviceToken,");
}
if (riderinfo.avgStars != null)
{
part1.Append("avgStars,");
part2.Append("@avgStars,");
}
if (riderinfo.starCount != null)
{
part1.Append("starCount,");
part2.Append("@starCount,");
}
if (riderinfo.sendCount != null)
{
part1.Append("sendCount,");
part2.Append("@sendCount,");
}
if (riderinfo.lat != null)
{
part1.Append("lat,");
part2.Append("@lat,");
}
if (riderinfo.lng != null)
{
part1.Append("lng,");
part2.Append("@lng,");
}
if (riderinfo.mapAddress != null)
{
part1.Append("mapAddress,");
part2.Append("@mapAddress,");
}
StringBuilder sql = new StringBuilder();
sql.Append("insert into riderinfo(").Append(part1.ToString().Remove(part1.Length - 1)).Append(") values (").Append(part2.ToString().Remove(part2.Length - 1)).Append(")");
return(sql.ToString());
} /// <summary>
public AssignRiderRes(RiderInfo rider)
{
riderId = rider.id;
riderName = rider.name;
}
public riderId_name(RiderInfo rider)
{
riderId = rider.id;
riderName = rider.name;
}
public riderId_name2(RiderInfo rider)
{
riderId = rider.id;
name = rider.name;
}
public string Update(webReq req)
{
var pwd = req.pwd;
if (!StringHelperHere.Instance.IsPwdValidate(pwd))
{
return(JsonHelperHere.JsonMsg(false, "密码应为6~16位英文字母、数字"));
}
var riderId = req.riderId;
var lat = req.lat;
var lng = req.lng;
var mapAddress = req.mapAddress;
var riderType = req.riderType;
var account = req.account;
var riderName = req.riderName;
var status = req.status;
var areaId = req.riderAreaId;
var stars = req.stars;
stars = stars < 0 ? 0 : stars;
stars = stars > 5 ? 5 : stars;
var phone = req.phone;
var starCount = req.starCount;
var sendCount = req.sendCount;
if (RiderInfoOper.Instance.IsHaveAccount(account, riderId))
{
return(JsonHelperHere.JsonMsg(false, "已存在这个账号"));
}
RiderInfo rider = new RiderInfo();
rider.riderAccount = account;
rider.riderPwd = pwd;
rider.riderType = riderType;
rider.riderStatus = Convert.ToBoolean(status);
rider.name = riderName;
rider.riderAreaId = areaId;
rider.id = riderId;
rider.phone = phone;
rider.avgStars = stars;
rider.starCount = starCount;
rider.sendCount = sendCount;
if (riderType == 2)
{
rider.lat = lat;
rider.lng = lng;
rider.mapAddress = mapAddress;
var ua = UserAddressOper.Instance.GetByRiderId(riderId);
if (ua == null)
{
ua = new UserAddress();
ua.riderId = riderId;
ua.lat = lat;
ua.lng = lng;
ua.mapAddress = mapAddress;
ua.phone = phone;
UserAddressOper.Instance.Add(ua);
}
else
{
ua.lat = lat;
ua.lng = lng;
ua.mapAddress = mapAddress;
ua.phone = phone;
UserAddressOper.Instance.Update(ua);
}
}
else
{
rider.lat = "";
rider.lng = "";
rider.mapAddress = "";
}
RiderInfoOper.Instance.Update(rider);
var temp = CacheHelper.GetRiderPosition(riderId);
if (riderType != 2)
{
CacheHelper.SetRiderPosition(riderId, temp.lat, temp.lng, riderType);
}
else
{
CacheHelper.SetRiderPosition(riderId, lat, lng, riderType);
}
return(JsonHelperHere.JsonMsg(true, ""));
}
} /// <summary>
/// 更新
/// </summary>
/// <param name="riderinfo"></param>
/// <returns>是否成功</returns>
public string GetUpdateStr(RiderInfo riderinfo)
{
StringBuilder part1 = new StringBuilder();
part1.Append("update riderinfo set ");
if (riderinfo.riderAccount != null)
{
part1.Append("riderAccount = @riderAccount,");
}
if (riderinfo.riderPwd != null)
{
part1.Append("riderPwd = @riderPwd,");
}
if (riderinfo.riderType != null)
{
part1.Append("riderType = @riderType,");
}
if (riderinfo.riderStatus != null)
{
part1.Append("riderStatus = @riderStatus,");
}
if (riderinfo.riderAreaId != null)
{
part1.Append("riderAreaId = @riderAreaId,");
}
if (riderinfo.isDeleted != null)
{
part1.Append("isDeleted = @isDeleted,");
}
if (riderinfo.riderNo != null)
{
part1.Append("riderNo = @riderNo,");
}
if (riderinfo.sexType != null)
{
part1.Append("sexType = @sexType,");
}
if (riderinfo.name != null)
{
part1.Append("name = @name,");
}
if (riderinfo.phone != null)
{
part1.Append("phone = @phone,");
}
if (riderinfo.deviceToken != null)
{
part1.Append("deviceToken = @deviceToken,");
}
if (riderinfo.avgStars != null)
{
part1.Append("avgStars = @avgStars,");
}
if (riderinfo.starCount != null)
{
part1.Append("starCount = @starCount,");
}
if (riderinfo.sendCount != null)
{
part1.Append("sendCount = @sendCount,");
}
if (riderinfo.lat != null)
{
part1.Append("lat = @lat,");
}
if (riderinfo.lng != null)
{
part1.Append("lng = @lng,");
}
if (riderinfo.mapAddress != null)
{
part1.Append("mapAddress = @mapAddress,");
}
int n = part1.ToString().LastIndexOf(",");
part1.Remove(n, 1);
part1.Append(" where id= @id ");
return(part1.ToString());
}
public string Add(webReq req)
{
ResultForWeb r = new ResultForWeb
{
HttpCode = 200,
Message = "",
data = "{}"
};
var pwd = req.pwd;
if (!StringHelperHere.Instance.IsPwdValidate(pwd))
{
r.HttpCode = 500;
r.Message = "密码应为6~16位英文字母、数字";
//r.data = JsonHelperHere.JsonMsg(false, "密码应为6~16位英文字母、数字");
return(JsonConvert.SerializeObject(r));
}
var lat = req.lat;
var lng = req.lng;
var mapAddress = req.mapAddress;
var riderType = req.riderType;
var account = req.account;
var phone = req.phone;
var riderName = req.riderName;
var status = req.status;
var areaId = req.riderAreaId;
var stars = req.stars;
stars = stars < 0 ? 0 : stars;
stars = stars > 5 ? 5 : stars;
var starCount = req.starCount;
var sendCount = req.sendCount;
if (RiderInfoOper.Instance.IsHaveAccount(account, 0))
{
r.Message = "已存在这个账号";
r.HttpCode = 500;
return(JsonConvert.SerializeObject(r));
}
RiderInfo rider = new RiderInfo();
rider.riderAccount = account;
rider.riderPwd = pwd;
rider.riderType = riderType;
rider.riderStatus = Convert.ToBoolean(status);
rider.name = riderName;
rider.riderAreaId = areaId;
rider.phone = phone;
rider.avgStars = stars;
rider.starCount = starCount;
rider.sendCount = sendCount;
if (riderType == 2)
{
rider.lat = lat;
rider.lng = lng;
rider.mapAddress = mapAddress;
}
var riderId = RiderInfoOper.Instance.Add(rider);
var temp = CacheHelper.GetRiderPosition(riderId);
if (riderType != 2)
{
CacheHelper.SetRiderPosition(riderId, temp.lat, temp.lng, riderType);
}
else
{
CacheHelper.SetRiderPosition(riderId, lat, lng, riderType);
UserAddress ua = new UserAddress();
ua.riderId = riderId;
ua.lat = lat;
ua.lng = lng;
ua.mapAddress = mapAddress;
ua.phone = phone;
UserAddressOper.Instance.Add(ua);
}
//JsonHelperHere.JsonMsg(true, "");
return(JsonConvert.SerializeObject(r));
}
/// 获取参数
/// </summary>
/// <param name="riderinfo"></param>
/// <returns></returns>
public Dictionary <string, string> GetParameters(RiderInfo riderinfo)
{
Dictionary <string, string> dict = new Dictionary <string, string>();
if (riderinfo.id != null)
{
dict.Add("@id", riderinfo.id.ToString());
}
if (riderinfo.riderAccount != null)
{
dict.Add("@riderAccount", riderinfo.riderAccount.ToString());
}
if (riderinfo.riderPwd != null)
{
dict.Add("@riderPwd", riderinfo.riderPwd.ToString());
}
if (riderinfo.riderType != null)
{
dict.Add("@riderType", riderinfo.riderType.ToString());
}
if (riderinfo.riderStatus != null)
{
dict.Add("@riderStatus", riderinfo.riderStatus.ToString());
}
if (riderinfo.riderAreaId != null)
{
dict.Add("@riderAreaId", riderinfo.riderAreaId.ToString());
}
if (riderinfo.isDeleted != null)
{
dict.Add("@isDeleted", riderinfo.isDeleted.ToString());
}
if (riderinfo.riderNo != null)
{
dict.Add("@riderNo", riderinfo.riderNo.ToString());
}
if (riderinfo.sexType != null)
{
dict.Add("@sexType", riderinfo.sexType.ToString());
}
if (riderinfo.name != null)
{
dict.Add("@name", riderinfo.name.ToString());
}
if (riderinfo.phone != null)
{
dict.Add("@phone", riderinfo.phone.ToString());
}
if (riderinfo.deviceToken != null)
{
dict.Add("@deviceToken", riderinfo.deviceToken.ToString());
}
if (riderinfo.avgStars != null)
{
dict.Add("@avgStars", riderinfo.avgStars.ToString());
}
if (riderinfo.starCount != null)
{
dict.Add("@starCount", riderinfo.starCount.ToString());
}
if (riderinfo.sendCount != null)
{
dict.Add("@sendCount", riderinfo.sendCount.ToString());
}
if (riderinfo.lat != null)
{
dict.Add("@lat", riderinfo.lat.ToString());
}
if (riderinfo.lng != null)
{
dict.Add("@lng", riderinfo.lng.ToString());
}
if (riderinfo.mapAddress != null)
{
dict.Add("@mapAddress", riderinfo.mapAddress.ToString());
}
return(dict);
}
