public EulerAngle(double x, double y, double z, EOrder order = EOrder.Xyz)
{
X = x;
Y = y;
Z = z;
Order = order;
}
public EOrder Update(EOrder venta)
{
EOrder pedido;
string qSql = " UPDATE SalesOrders " +
" SET Status = 2, AtentionTime = @attentionTime " +
" WHERE SalesOrderId = @id";
try
{
using (SqlConnection con = new SqlConnection(cadenaconexion))
{
using (SqlCommand cmd = new SqlCommand(qSql, con))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqlParameter("@attentionTime", venta.attentionTime));
cmd.Parameters.Add(new SqlParameter("@id", venta.id));
con.Open();
cmd.ExecuteNonQuery();
}
}
pedido = GetOrderById(venta.id);
}
catch (Exception ex)
{
throw ex;
}
return(pedido);
}
/// <summary>
/// PlayerUnitに指令を送る
/// </summary>
/// <param name="order">指令</param>
public void PushOrder(EOrder order)
{
for (int i = 0; i < playerUnits.Count; ++i)
{
playerUnits[i].GetComponent <ActionStateMachine>().ExecuteOrder(order);
}
}
public EOrder Insertar(EOrder venta)
{
string sql = " INSERT INTO SalesOrders(UserId, PubId, OrderDate, Status, WaitTime) " +
" VALUES(@UserId, @PubId, GETDATE(), '1', @WaitTime); Select SCOPE_IDENTITY(); ";
EOrder pedidoCreado = null;
int idventa = 0;
try
{
using (SqlConnection con = new SqlConnection(cadenaconexion))
{
con.Open();
using (SqlCommand com = new SqlCommand(sql, con))
{
com.Parameters.Add(new SqlParameter("@UserId", venta.userId));
com.Parameters.Add(new SqlParameter("@PubId", venta.pubId));
com.Parameters.Add(new SqlParameter("@WaitTime", venta.waitTime));
idventa = Convert.ToInt32(com.ExecuteScalar());
}
pedidoCreado = GetOrderById(idventa);
}
return(pedidoCreado);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 格式化为快递鸟指定格式。
/// </summary>
/// <param name="eOrder"></param>
/// <returns></returns>
private string ConvertToPOSTFormat(EOrder eOrder)
{
var jSetting = new JsonSerializerSettings {
NullValueHandling = NullValueHandling.Ignore
};
this._RequestParameter.RequestData = JsonConvert.SerializeObject(eOrder, Formatting.None, jSetting);
this._RequestParameter.DataSign = GetDataSign(this._RequestParameter.RequestData + this._AppKey);
Dictionary <string, string> param = new Dictionary <string, string>();
param.Add("RequestData", HttpUtility.UrlEncode(this._RequestParameter.RequestData));
param.Add("EBusinessID", this._RequestParameter.EBusinessID);
param.Add("RequestType", this._RequestParameter.RequestType);
param.Add("DataSign", this._RequestParameter.DataSign);
param.Add("DataType", this._RequestParameter.DataType);
StringBuilder result = new StringBuilder();
if (param != null && param.Count > 0)
{
foreach (var p in param)
{
if (result.Length > 0)
{
result.Append("&");
}
result.Append(p.Key);
result.Append("=");
result.Append(p.Value);
}
}
return(result.ToString());
}
private EOrder CreateBuyCourseOrder(string userOpenId, ECoursePrice coursePrice)
{
EOrder order = null;
try
{
order = new EOrder
{
CreateDateTime = DateTime.Now,
CustOpenId = userOpenId,
OrderStatus = OrderStatus.Created,
OrderType = OrderType.UserCourse,
OrderId = EduCodeGenerator.GetOrderOrder(),
};
_dbContext.Add(order);
EOrderLine line = new EOrderLine
{
OrderId = order.OrderId,
ItemCode = coursePrice.PriceCode,
ItemName = $"课时购买{coursePrice.PriceCode}_{coursePrice.CourseScheduleType}",
Price = coursePrice.Price,
Qty = coursePrice.Qty,
Ext1 = (int)coursePrice.CourseScheduleType,
};
_dbContext.Add(line);
}
catch (Exception ex)
{
throw ex;
}
return(order);
}
/// <summary>
/// 指示をqueueの最後に追加する。
/// queueの容量超えるとき追加しない。
/// </summary>
public void PushOrder(EOrder order)
{
if (nextOrders.Count == orderCapacity)
{
return;
}
nextOrders.Add(order);
}
public void SetOrder(Visual vOther, EOrder o)
{
uint hr = VisualSetOrder(this.pgad, h(vOther), (uint)o);
if (f(hr))
{
throw new DUserException(hr);
}
}
private float interval; //秒数ことに指示を発送する
void Start()
{
currentOrder = EOrder.Idle;
orderCapacity = 2;
nextOrders = new List <EOrder>(orderCapacity);
interval = 2.0f;
timer = new Timer(interval);
}
/// <summary>
/// 指令を追加
/// </summary>
public void AddOrder(EOrder newOrder)
{
if (orderCount >= orderStackCount) //最大数以上なら追加できない
{
return;
}
orders[orderCount] = newOrder; //末尾指定
++orderCount;
}
public OperationResult Insert(EOrderModel model)
{
var entity = new EOrder
{
OrderType = model.OrderType,
//OrderID = model.OrderID,
ORIGTYPE = model.ORIGTYPE,
ORIGNUMB = model.ORIGNUMB,
BACHNUMB = model.BACHNUMB,
CustID = model.CustID,
ShopID = model.ShopID,
EmplID = model.EmplID,
OrderDate = model.OrderDate,
RequiredDate = model.RequiredDate,
ShippedDate = model.ShippedDate,
ShipID = model.ShipID,
Freight = model.Freight,
Ship_Name = model.Ship_Name,
Ship_Address = model.Ship_Address,
Ship_City = model.Ship_City,
TerrID = model.TerrID,
Ship_zip = model.Ship_zip,
Ship_Country = model.Ship_Country,
Ship_state = model.Ship_state,
Ship_phone = model.Ship_phone,
Auth_code = model.Auth_code,
Bill_name = model.Bill_name,
Bill_address = model.Bill_address,
Bill_city = model.Bill_city,
Bill_state = model.Bill_state,
Bill_zip = model.Bill_zip,
Bill_country = model.Bill_country,
Bill_phone = model.Bill_phone,
RepID = model.RepID,
OrderStats = model.OrderStats,
VoidStats = model.VoidStats,
CommText = model.CommText,
CretDate = model.CretDate,
ModiDate = model.ModiDate,
CretID = model.CretID,
Cc_name = model.Cc_name,
Cc_expmonth = model.Cc_expmonth,
Cc_expyear = model.Cc_expyear,
Cc_number = model.Cc_number,
Cc_type = model.Cc_type,
Verify_with = model.Verify_with,
Pono = model.Pono,
Prnstats = model.Prnstats,
PROC_STATUS = model.PROC_STATUS,
Miscellaneous = model.Miscellaneous,
};
EOrderRepository.Insert(entity);
return(new OperationResult(OperationResultType.Success, "Added successfully"));
}
/// <summary>
/// 指令を実行
/// </summary>
/// <param name="order">指令</param>
public void ExecuteOrder(EOrder order)
{
bool launch = skillManager.AddOrder(order); //Player入力ならスキル発動チェック
if (launch)
{
//Todo Skill状態（アニメションなど必要な処理）
return;
}
ChangeActionState((EAction)order); //発動しなかった場合は指令を実行
}
public bool AddOrder(EOrder order)
{
inputOrder.Enqueue(order); //Queueに追加
for (int i = 0; i < skillModels.Length; ++i) //キャラ全部のスキルを一周
{
bool launch = CheckSkill(skillModels[i].SkillOrder()); //SkillOrderをチェック
if (launch) //Trueの場合スキル発動
{
//Todo Skill i を発動
return(true);
}
}
return(false); //Skill発動しない場合
}
public static bool TryProduceDigOre(Context cx, Entity robot, out EOrder order)
{
order = null;
if (robot.Item == ItemType.Ore)
{
return(false);
}
var oreCell = cx.Field.Map.FindOreBest(robot.Pos);
if (oreCell == null)
{
return(false);
}
cx.IncDigLock(oreCell.Pos);
order = new OrderDigOre(robot, oreCell.Pos);
return(true);
}
public EOrder UpdatePedido(EOrder beventa)
{
EOrder pedidoActualizado = null;
try
{
if (beventa == null)
{
throw new WebFaultException <string>("Entidad no valida", HttpStatusCode.InternalServerError);
}
pedidoActualizado = daopedido.Update(beventa);
return(pedidoActualizado);
}
catch (WebException ex)
{
throw new WebFaultException <string>(ex.ToString(), HttpStatusCode.InternalServerError);
}
}
public EOrder InsertarPedido(EOrder beventa)
{
EOrder nuevoPedido = null;
if (beventa == null)
{
throw new WebFaultException <string>("Entidad no valida", HttpStatusCode.InternalServerError);
}
try
{
nuevoPedido = daopedido.Insertar(beventa);
return(nuevoPedido);
}
catch (WebException ex)
{
throw new WebFaultException <string>(ex.ToString(), HttpStatusCode.InternalServerError);
}
}
private void CheckNextOrder()
{
//次の指示がある場合
if (nextOrders.Count != 0)
{
previousOrder = currentOrder;
currentOrder = nextOrders[0];
PopOrder();
return;
}
//次の指示がない場合
//後退回避かジャンプ回避後は前の指示をプッシュする。
//他の指示なら同じ指示をプッシュする。
if (currentOrder == EOrder.BackStep || currentOrder == EOrder.JumpEvasion)
{
currentOrder = previousOrder;
}
}
public EOrder AnularPedido(string codigo)
{
EOrder pedidoAnulado = null;
try
{
int id = 0;
if (int.TryParse(codigo, out id))
{
pedidoAnulado = daopedido.Anular(id);
}
return(pedidoAnulado);
}
catch (WebException ex)
{
throw new WebFaultException <string>(ex.ToString(), HttpStatusCode.InternalServerError);
}
}
public static bool TryProduceTakeRadar(Context cx, Entity robot, out EOrder order)
{
order = null;
return(false);
var unlocked = cx.VisibleOre < Constant.StartRadarSpam || HighOrderScout.MyRadars.Count > 5;
if (cx.RadarCooldown > 0 || robot.X != 0 || unlocked)
{
return(false);
}
if (robot.Item != ItemType.None)
{
return(false);
}
cx.RadarCooldown = 6;
order = new OrderTake(robot, ItemType.Radar);
return(true);
}
static void Main(string[] args)
{
var eOrder = new EOrder();
var sender = new Sender();
sender.Name = "Taylor";
sender.Mobile = "15018442396";
sender.ProvinceName = "上海";
sender.CityName = "上海";
sender.ExpAreaName = "青浦区";
sender.Address = "明珠路73号";
eOrder.Sender = sender;
var receiver = new Receiver();
receiver.Name = "Yann";
receiver.Mobile = "15018442396";
receiver.ProvinceName = "北京";
receiver.CityName = "北京";
receiver.ExpAreaName = "朝阳区";
receiver.Address = "三里屯街道雅秀大厦";
eOrder.Receiver = receiver;
var good = new Commodity();
good.GoodsName = "鞋子";
good.GoodsWeight = 1.0;
eOrder.Commodity.Add(good);
eOrder.ExpType = "1";
eOrder.PayType = PayType.Finish;
eOrder.ShipperCode = "YD";
eOrder.OrderCode = "YD201703011102105952";
eOrder.CustomerName = "testyd";
eOrder.CustomerPwd = "testydpwd";
var eBusinessID = "";
var appKey = "";
var client = new KDNiaoClient(eBusinessID, appKey);
var result = client.AddEOrder(eOrder);
Console.WriteLine(JsonConvert.SerializeObject(result));
}
public EOrder GetOrderById(int id)
{
EOrder order = null;
string sql = " Select SO.SalesOrderId, So.UserId, So.PubId, So.OrderDate, So.Status, So.WaitTime, So.AtentionTime " +
" from SalesOrders SO Where SO.SalesOrderId = " + id.ToString();
try
{
using (SqlConnection con = new SqlConnection(cadenaconexion))
{
using (SqlCommand com = new SqlCommand(sql, con))
{
con.Open();
using (SqlDataReader dr = com.ExecuteReader())
{
while (dr.Read())
{
order = new EOrder();
order.id = Convert.ToInt32(dr[0]);
order.userId = Convert.ToInt32(dr[1]);
order.pubId = Convert.ToInt32(dr[2]);
order.orderDate = Convert.ToDateTime(dr[3]);
order.status = dr[4].ToString();
order.waitTime = dr[5].ToString();
order.attentionTime = (dr[6] == DBNull.Value ? null : (string)dr[6]);
}
dr.Close();
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(order);
}
/// <summary>
/// 申请电子面单。
/// </summary>
/// <returns></returns>
public EOrderResult AddEOrder(EOrder eOrder)
{
return(new EOrderController(this._EBusinessID, this._AppKey, this._APIUrl).PlaceAnOrder(eOrder));
}
public List <EOrder> Listar(string busqueda, string local, string Valor, string fecha)
{
List <EOrder> lista = new List <EOrder>();
string sql = "";
if (busqueda.Equals("1")) //Listar
{
sql = " SELECT SalesOrderId, UserId, PubId, OrderDate, Status, WaitTime, AtentionTime " +
" FROM SalesOrders " +
" WHERE convert(nvarchar(8), orderDate, 112) = " + fecha +
" AND PubId = " + local;
}
else if (busqueda.Equals("2")) //Por ID
{
sql = " SELECT SalesOrderId, UserId, PubId, OrderDate, Status, WaitTime, AtentionTime " +
" FROM SalesOrders " +
" WHERE SalesOrderId = " + Valor;
}
else if (busqueda.Equals("3")) //Por Estado
{
sql = " SELECT SalesOrderId, UserId, PubId, OrderDate, Status, WaitTime, AtentionTime " +
" FROM SalesOrders " +
" WHERE Status = " + Valor +
" AND PubId = " + local;
}
try
{
using (SqlConnection con = new SqlConnection(cadenaconexion))
{
using (SqlCommand com = new SqlCommand(sql, con))
{
con.Open();
using (SqlDataReader dr = com.ExecuteReader())
{
while (dr.Read())
{
EOrder ve = new EOrder();
ve.id = Convert.ToInt32(dr[0]);
ve.userId = Convert.ToInt32(dr[1]);
ve.pubId = Convert.ToInt32(dr[2]);
ve.orderDate = Convert.ToDateTime(dr[3]);
ve.status = dr[4].ToString();
ve.waitTime = dr[5].ToString();
ve.attentionTime = dr[6].ToString();
lista.Add(ve);
}
dr.Close();
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(lista);
}
public int UpdateByRepository(EOrder entity)
{
return(EOrderRepository.Update(entity));
}
private void ParseCondition(string vsCondition)
{
string[] parts = vsCondition.Split(' ');
foreach (string sPart in parts) {
string s = sPart.ToUpper().Trim();
if (sPart.Trim().Length == 0)
continue;
foreach (var e in Enum.GetValues(typeof(EPool)))
if (s.Equals(((EPool)e).ToString("F")))
EntityPool = (EPool)e;
foreach (var e in Enum.GetValues(typeof(EMatch)))
if (s.Equals(((EMatch)e).ToString("F")))
EntityMatch = (EMatch)e;
foreach (var e in Enum.GetValues(typeof(EOrder)))
if (s.Equals(((EOrder)e).ToString("F")))
EntityOrder = (EOrder)e;
if (s.Equals("MAX"))
EMin = false;
}
}
public static IOrderedEnumerable <T> ThenBy <T>(this IEnumerable <T> source, string propertyName, EOrder order)
{
return(Order(source, propertyName, order == EOrder.Asc ? EOrderMethod.ThenBy : EOrderMethod.ThenByDescending));
}
public void InsertarUsuario()
{
//EUser usuario = new EUser()
//{
// lastName = "Carrasco",
// firstName = "Julia",
// email = "*****@*****.**",
// phoneNumber = "987654321",
// documentNumber = "45781266",
// type = "2",
// password = "******"
//};
//EOrder pedido = new EOrder() {
// userId = 3,
// pubId = 1,
// waitTime = "00:10:00"
//};
EOrderDetail pedido = new EOrderDetail()
{
orderId = 2,
productId = 1,
unitPrice = 20.00,
quantity = 2
};
JavaScriptSerializer serializer = new JavaScriptSerializer();
string postdata = serializer.Serialize(pedido);;
byte[] data = Encoding.UTF8.GetBytes(postdata);
HttpWebRequest req = (HttpWebRequest)WebRequest
.Create("http://localhost:15000/ServiceBares.svc/OrderDetail");
req.Method = "POST";
req.ContentLength = data.Length;
req.ContentType = "application/json";
var reqStream = req.GetRequestStream();
reqStream.Write(data, 0, data.Length);
HttpWebResponse res = null;
EOrder cat = null;
try
{
res = (HttpWebResponse)req.GetResponse();
StreamReader reader = new StreamReader(res.GetResponseStream());
string listaCATJson = reader.ReadToEnd();
JavaScriptSerializer js = new JavaScriptSerializer();
cat = js.Deserialize <EOrder>(listaCATJson);
Assert.IsNotNull(cat);
}
catch (WebException e)
{
HttpStatusCode code = ((HttpWebResponse)e.Response).StatusCode;
string message = ((HttpWebResponse)e.Response).StatusDescription;
StreamReader reader = new StreamReader(e.Response.GetResponseStream());
string error = reader.ReadToEnd();
JavaScriptSerializer js = new JavaScriptSerializer();
string mensaje = js.Deserialize <string>(error);
Assert.AreEqual("", mensaje);
}
}
/// <summary>
/// 下单。
/// </summary>
/// <returns></returns>
public EOrderResult PlaceAnOrder(EOrder eOrder)
{
return(new HttpHandler(HTTPMethod.POST, this._ApiUrl, ConvertToPOSTFormat(eOrder)).GetResponse <EOrderResult>());
}
/// <summary>
/// Sort query by specified property name and ascending flag.
/// </summary>
/// <typeparam name="T">Type of queryable objects.</typeparam>
/// <param name="query">Query.</param>
/// <param name="propertyName">Name of property for sorting.</param>
/// <param name="ascending">Ascending flag.</param>
/// <returns>
/// Ordered query (IOrderedQueryable).
/// </returns>
public static IOrderedQueryable <T> OrderBy <T>(this IQueryable <T> query, string propertyName, EOrder order)
{
return(Order(query, propertyName, order == EOrder.Asc ? EOrderMethod.OrderBy : EOrderMethod.OrderByDescending));
}
