public virtual void read(sbyte[] bytes, int offset, int Length)
{
ByteBuffer b = ByteBuffer.wrap(bytes, offset, Length).order(ByteOrder.LITTLE_ENDIAN);
version = b.Int;
size = endianSwap32(b.Int);
unknown = endianSwap16(b.Short);
sizeParams = endianSwap16(b.Short);
int readSize = 12;
parameters.Clear();
for (int i = 0; i < NUMBER_PARAMETERS; i++)
{
int type = endianSwap16(b.Short);
int valueLength = endianSwap16(b.Short);
sbyte[] value = new sbyte[valueLength];
b.get(value);
readSize += 4 + valueLength;
TicketParam ticketParam = new TicketParam(type, value);
parameters.Add(ticketParam);
}
unknownBytes = new sbyte[size - readSize + 8];
b.get(unknownBytes);
}
public bool AddGo(TicketParam value)
{
/*
* if (DateTime.Compare(value.rt.GetBeginTime(), nowTime) < 0)
* {
* Lucky.LuckyUtils.Log("error " + value.rt.GetBeginTime());
* return false;
* }
*/
lock (golock)
{
long id = value.rt.GetRoutineId();
DateTime start = value.rt.GetBeginTime();
Lucky.LuckyUtils.Log("add routine id " + id);
GoId.Add(id, start);
if (waitingGo.ContainsKey(start))
{
Dictionary <long, TicketParam> dicts;
waitingGo.TryGetValue(start, out dicts);
dicts.Add(id, value);
}
else
{
Dictionary <long, TicketParam> dicts = new Dictionary <long, TicketParam>();
dicts.Add(id, value);
waitingGo.Add(start, dicts);
}
Lucky.LuckyUtils.Log("goid " + GoId.Count);
}
return(true);
}
public CodeMessage deleteTicket(string openId, TicketParam listParam)
{
string ticketsql = "select status from t_daigou_ticket where ticketCode = '" + listParam.ticketNum + "' and openId = '" + openId + "'";
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(ticketsql, "t_daigou_ticket").Tables[0];
if (dt.Rows.Count > 0)
{
if (dt.Rows[0][0].ToString() == "0" || dt.Rows[0][0].ToString() == "8" || dt.Rows[0][0].ToString() == "9")
{
ArrayList al = new ArrayList();
string sql = "delete from t_daigou_ticket where ticketCode = '" + listParam.ticketNum + "'";
string sql1 = "delete from t_daigou_brand where ticketCode = '" + listParam.ticketNum + "'";
al.Add(sql);
al.Add(sql1);
if (DatabaseOperationWeb.ExecuteDML(al))
{
return(CodeMessage.deleteTicketSuccess);
}
else
{
return(CodeMessage.deleteTicketError);
}
}
else
{
return(CodeMessage.deleteTicketError);
}
}
else
{
return(CodeMessage.TicketZeroError);
}
}
public TicketParam getTicketItem(string openId, string ticketCode)
{
string sql = "select b.brand,b.price,t.img,t.ticketCode,t.shopName from t_daigou_brand b,t_daigou_ticket t where b.ticketCode =t.ticketCode and b.ticketCode = '" + ticketCode + "' and t.openId = '" + openId + "'";
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "t_daigou_ticket").Tables[0];
if (dt.Rows.Count > 0)
{
TicketParam tp = new TicketParam();
tp.imgbasesrc = dt.Rows[0]["img"].ToString();
tp.shopName = dt.Rows[0]["shopName"].ToString();
tp.ticketNum = dt.Rows[0]["ticketCode"].ToString();
tp.goodsAll = new List <BrandParam>();
for (int i = 0; i < dt.Rows.Count; i++)
{
BrandParam bp = new BrandParam();
bp.goodsName = dt.Rows[i]["brand"].ToString();
bp.goodsPrice = dt.Rows[i]["price"].ToString();
tp.goodsAll.Add(bp);
}
return(tp);
}
else
{
return(null);
}
}
public bool Update(int?Id, TicketParam ticketParam)
{
if (Id != null && ticketParam != null)
{
status = _ticketRepository.Update(Id, ticketParam);
}
return(status);
}
public bool Insert(TicketParam ticketParam)
{
if (ticketParam != null)
{
status = _ticketRepository.Insert(ticketParam);
}
return(status);
}
public void AirPlaneFly(TicketParam tp)
{
TicketsController.Instance.DeleteTickets(tp.rt.GetTicketId());
if (UserTicketsModel.Instance.where == Where.City && tp.rt.GetRoutineStartNode().Contains(UserTicketsModel.Instance.city))
{
AudioManager.Instance.PlayMusic(Audios.AirPlaneClip);
UserTicketsModel.Instance.where = Where.AirPlane;
Lucky.LuckyUtils.Log("airplane fly" + tp.rt.GetBeginTime());
Vector3 startPos = Vector3.zero;
Lucky.LuckyUtils.Log("start " + tp.rt.GetRoutineStartNode());
Lucky.LuckyUtils.Log("stop " + tp.rt.GetEndNode());
string start = tp.rt.GetRoutineStartNode();
string stop = tp.rt.GetEndNode();
start = GetCityString(start);
stop = GetCityString(stop);
LocationsModel.cityslocation.TryGetValue(start, out startPos);
Vector3 stopPos = Vector3.zero;
LocationsModel.cityslocation.TryGetValue(stop, out stopPos);
Lucky.LuckyUtils.Log("start stop pos " + startPos + " " + stopPos);
airline.Show(startPos, stopPos);
dst = stop;
DateTime starttime = tp.rt.GetBeginTime();
DateTime stoptime = tp.rt.GetEndTime();
TimeSpan ts = stoptime - starttime;
ticketid = tp.rt.GetTicketId();
TicketsController.Instance.DeleteTickets(ticketid);
traveltime = (float)ts.TotalMinutes;
Lucky.LuckyUtils.Log("travel time " + ts.TotalMinutes);
double realtime = traveltime / TimeManager.instance.TimeSpeed;
Lucky.LuckyUtils.Log("realtime " + realtime);
animationName = start + "To" + stop;
animator = airplane.GetComponent <Animator>();
animator.Stop();
AnimationClip clip = FindClip(animator, animationName);
if (clip != null)
{
cliptime = clip.length;
double speed = cliptime / realtime;
Lucky.LuckyUtils.Log("speed " + speed);
airplane.SetActive(true);
animator.Play(animationName);
animator.speed = (float)speed;
}
UserTicketsModel.Instance.going = true;
}
else
{
InfoView.Show(new InfoMessage("你当前不在出发城市，该机票" + tp.rt.GetTicketName() + "作废！", "亏大了!"));
}
}
public CodeMessage insertTicket(string openId, TicketParam listParam)
{
try
{
string ticketsql = "select * from t_daigou_ticket where ticketCode = '" + listParam.ticketNum + "'";
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(ticketsql, "t_daigou_ticket").Tables[0];
if (dt.Rows.Count > 0)
{
return(CodeMessage.repeatTicketError);
}
string fileName = listParam.ticketNum + ".jpg";
string base64String = listParam.imgbasesrc.Split(",")[1];
if (saveImageByBase64String(base64String, fileName))
{
if (!updateImgToOSS(fileName))
{
return(CodeMessage.updateOssError);
}
}
else
{
return(CodeMessage.updateImgError);
}
string sql = "insert into t_daigou_ticket(openId,createTime,img,ticketCode,shopName,status) " +
"values('" + openId + "',now(),'" + Global.OssUrl + Global.OssDir + fileName + "','" + listParam.ticketNum + "','" + listParam.shopName + "','0')";
if (DatabaseOperationWeb.ExecuteDML(sql))
{
ArrayList al = new ArrayList();
foreach (var goods in listParam.goodsAll)
{
string sql1 = "insert into t_daigou_brand(ticketCode,brand,price) values('" + listParam.ticketNum + "','" + goods.goodsName + "','" + goods.goodsPrice + "')";
al.Add(sql1);
}
if (!DatabaseOperationWeb.ExecuteDML(al))
{
return(CodeMessage.insertTicketError);
}
}
else
{
return(CodeMessage.insertTicketError);
}
}
catch (Exception)
{
return(CodeMessage.insertTicketError);
}
return(CodeMessage.insertTicketSuccess);
}
public void TrainGo(TicketParam tp)
{
if (tp == null)
{
Debug.Log("tp is null");
}
TicketsController.Instance.DeleteTickets(tp.rt.GetTicketId());
if (UserTicketsModel.Instance.where == Where.City && tp.rt.GetRoutineStartNode().Contains(UserTicketsModel.Instance.city))
{
AudioManager.Instance.PlayMusic(Audios.RailwayClip);
UserTicketsModel.Instance.where = Where.Train;
Lucky.LuckyUtils.Log("train go" + tp.rt.GetBeginTime());
string start = tp.rt.GetRoutineStartNode();
string stop = tp.rt.GetEndNode();
dst = stop;
DateTime starttime = tp.rt.GetBeginTime();
DateTime stoptime = tp.rt.GetEndTime();
TimeSpan ts = stoptime - starttime;
ticketid = tp.rt.GetTicketId();
TicketsController.Instance.DeleteTickets(ticketid);
traveltime = (float)ts.TotalMinutes;
double realtime = traveltime / TimeManager.instance.TimeSpeed;
start = GetCityString(start);
stop = GetCityString(stop);
animationName = start + "-" + stop + "_Train";
Lucky.LuckyUtils.Log("train " + animationName);
animator = train.GetComponent <Animator>();
AnimationClip clip = FindClip(animator, animationName);
if (clip != null)
{
cliptime = clip.length;
double speed = cliptime / realtime;
train.SetActive(true);
animator.Play(animationName, 0, 0);
animator.speed = (float)speed;
}
UserTicketsModel.Instance.going = true;
}
else
{
InfoView.Show(new InfoMessage("你当前不在出发城市，该火车票" + tp.rt.GetTicketName() + "作废！", "亏大了!"));
}
}
public override string ToString()
{
StringBuilder s = new StringBuilder();
s.Append(string.Format("version=0x{0:X8}", version));
s.Append(string.Format(", size=0x{0:X}", size));
s.Append(string.Format(", unknown=0x{0:X}", unknown));
for (int i = 0; i < parameters.Count; i++)
{
TicketParam param = parameters[i];
s.Append(string.Format(", param#{0:D}={1}", i, param));
}
s.Append(string.Format(", unknownBytes: {0}", Utilities.getMemoryDump(unknownBytes, 0, unknownBytes.Length)));
return(s.ToString());
}
public CodeMessage updateTicket(string openId, TicketParam listParam)
{
string ticketsql = "select status from t_daigou_ticket where ticketCode = '" + listParam.ticketNum + "'";
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(ticketsql, "t_daigou_ticket").Tables[0];
if (dt.Rows.Count > 0)
{
if (dt.Rows[0][0].ToString() == "0" || dt.Rows[0][0].ToString() == "8" || dt.Rows[0][0].ToString() == "9")
{
}
else
{
return(CodeMessage.updateTicketStatusError);
}
}
else
{
return(CodeMessage.TicketZeroError);
}
string sql = "delete from t_daigou_brand where ticketCode = '" + listParam.ticketNum + "'";
if (DatabaseOperationWeb.ExecuteDML(sql))
{
ArrayList al = new ArrayList();
foreach (var goods in listParam.goodsAll)
{
string sql1 = "insert into t_daigou_brand(ticketCode,brand,price) values('" + listParam.ticketNum + "','" + goods.goodsName + "','" + goods.goodsPrice + "')";
al.Add(sql1);
}
if (DatabaseOperationWeb.ExecuteDML(al))
{
string upsql = "update t_daigou_ticket set status='0' where ticketCode = '" + listParam.ticketNum + "'";
}
else
{
return(CodeMessage.updateTicketError);
}
}
else
{
return(CodeMessage.updateTicketError);
}
return(CodeMessage.updateTicketSuccess);
}
public bool Update(int?Id, TicketParam TicketParam)
{
var result = 0;
var ticket = Get(Id);
ticket.Problem = TicketParam.Problem;
ticket.DueDate = TicketParam.DueDate;
ticket.Solution = TicketParam.Solution;
ticket.Categories = myContext.Categories.Find(TicketParam.Categories);
ticket.SubCategories = myContext.SubCategories.Find(TicketParam.SubCategories);
ticket.Priorities = myContext.Priorities.Find(TicketParam.Priorities);
ticket.Customers = myContext.Customers.Find(TicketParam.Customers);
ticket.UpdateDate = DateTimeOffset.UtcNow.LocalDateTime;
result = myContext.SaveChanges();
if (result > 0)
{
status = true;
}
return(status);
}
public bool Insert(TicketParam TicketParam)
{
var result = 0;
ticket.Problem = TicketParam.Problem;
//ticket.DueDate = TicketParam.DueDate;
//ticket.Solution = TicketParam.Solution;
//ticket.Categories = myContext.Categories.Find(TicketParam.Categories);
//ticket.SubCategories = myContext.SubCategories.Find(TicketParam.SubCategories);
//ticket.Priorities = myContext.Priorities.Find(TicketParam.Priorities);
//ticket.Customers = myContext.Customers.Find(TicketParam.Customers);
ticket.CreateDate = DateTimeOffset.UtcNow.LocalDateTime;
myContext.Tickets.Add(ticket);
result = myContext.SaveChanges();
if (result > 0)
{
status = true;
}
return(status);
}
protected internal override void read()
{
version = read32();
size = endianSwap32(read32());
unknown = endianSwap16((short)read16());
sizeParams = endianSwap16((short)read16());
parameters.Clear();
for (int i = 0; i < NUMBER_PARAMETERS; i++)
{
int type = endianSwap16((short)read16());
int Length = endianSwap16((short)read16());
sbyte[] value = new sbyte[Length];
read8Array(value);
TicketParam ticketParam = new TicketParam(type, value);
parameters.Add(ticketParam);
}
unknownBytes = new sbyte[size - Offset + 8];
read8Array(unknownBytes);
}
// PUT: api/Priorities/5
public void Put(int id, TicketParam TicketParam)
{
_ticketService.Update(id, TicketParam);
}
// POST: api/Priorities
public void Post(TicketParam TicketParam)
{
_ticketService.Insert(TicketParam);
}
public CreateTicketResponse CreateTicket([FromBody] TicketParam param)
{
return(new CreateTicketResponse("SYSAID000232", DateTime.Now, "Not Assign"));
}
