public RES LoadOrderList() { var db = ModelEF.GetInst(); var orderList = db.YunOrders.ToList(); return(RES.New.SetAsOK(orderList)); }
public List <Dictionary <string, object> > ExecuteSQL(string sql, object param) { var paramaArray = new List <SqlParameter>(); if (param is string) { var paramaDict = JSON.ToObject <Dictionary <string, object> >(param.ToString()); foreach (var item in paramaDict) { paramaArray.Add(new SqlParameter(item.Key, item.Value)); } } //else if (param is object[]) //{ // paramaArray = param as object[]; //} else if (null == param) { paramaArray = null; } var db = ModelEF.GetInst().Database; var res = db.SqlQuery <Dictionary <string, object> >(sql, paramaArray.ToArray()).ToList(); db.Connection.Close(); return(res); }
/// <summary> /// 保存一个实体 /// </summary> /// <returns></returns> public RES Save() { try { var db = ModelEF.GetInst(); if (this.ID == Guid.Empty) { this.ID = Guid.NewGuid(); db.YunRelations.Add(this); } else { var currentEntity = db.YunRelations.FirstOrDefault(p => p.ID == this.ID); if (null != currentEntity) { currentEntity.Name = this.Name; } } db.SaveChangesAsync(); return(RES.OK()); } catch (Exception ex) { return(RES.FAIL()); } }
/// ///保存一个商品 public RES Save(YunCommodity newData) { var newVal = JSON.ToObject <YunForm>(JSON.ToJson(newData)); var db = ModelEF.GetInst(); var oldVal = db.YunForms.FirstOrDefault(p => p.ID == newVal.ID); if (null == oldVal) { newVal.InitialDateTime(); var inst = db.YunForms.Add(newVal); db.SaveChanges(); return(RES.New.SetAsOK(newVal)); } else { var properties = newVal.GetType().GetProperties().ToList(); properties.ForEach(p => { var targetProperty = oldVal.GetType().GetProperty(p.Name); if (null != targetProperty && targetProperty.CanWrite) { targetProperty.SetValue(oldVal, p.GetValue(newVal)); } }); db.SaveChanges(); return(RES.New.SetAsOK(oldVal)); } }
/// <summary> /// 移动一个节点 /// </summary> /// <param name="nodeIdStr"></param> /// <param name="sourceParentIDStr"></param> /// <param name="targetParentNodeIDStr"></param> /// <returns></returns> public RES MoveNode(string nodeIdStr, string sourceParentIDStr, string targetParentNodeIDStr) { try { if (GUID.IsGuid(nodeIdStr) && GUID.IsGuid(sourceParentIDStr) && GUID.IsGuid(targetParentNodeIDStr)) { var currentNodeID = Guid.Parse(nodeIdStr); var sourceParentNodeID = Guid.Parse(sourceParentIDStr); var targetParentNodeID = Guid.Parse(targetParentNodeIDStr); var db = ModelEF.GetInst(); var currentEntity = db.YunRelations.FirstOrDefault(p => p.ID == currentNodeID); if (null != currentEntity) { currentEntity.ParentID = targetParentNodeID; } db.SaveChangesAsync(); return(RES.OK()); } return(RES.FAIL()); } catch (Exception ex) { return(RES.FAIL()); } }
public RES Load(string id) { var db = ModelEF.GetInst(); var guid = Guid.Parse(id); var query = from item in db.YunForms where item.ID == guid select item; return(RES.New.SetAsOK(query.FirstOrDefault())); }
public RES Remove() { var res = RES.New; var db = ModelEF.GetInst(); var data_db = db.YunForms.FirstOrDefault(p => p.ID == this.ID); db.YunForms.Remove(data_db); db.SaveChanges(); return(res.SetAsOK()); }
public RES LoadList(long formType) { var res = RES.New; var db = ModelEF.GetInst(); var query = from item in db.YunForms where formType == item.FormType orderby CreateTime descending select item; res.DATA = query.ToList(); return(res.SetAsOK()); }
/// <summary> /// /// </summary> /// <param name="rootId"></param> /// <returns></returns> public RES LoadList(string rootId) { if (GUID.IsGuid(rootId)) { var rootID = Guid.Parse(rootId); var db = ModelEF.GetInst(); var res = db.YunRelations.Where(p => p.RootID == rootID); return(RES.New.SetAsOK(res)); } return(RES.New.SetAsFail()); }
public RES LoadList_Comment(string sourceIDStr) { var res = RES.New; var db = ModelEF.GetInst(); var formType = (int)ENUM.ServiceType.云评论; var sourceID = Guid.Parse(sourceIDStr); var query = from item in db.YunForms where formType == item.FormType && sourceID == item.SourceID select item; res.DATA = query.ToList(); return(res.SetAsOK()); }
/// <summary> /// 加载一个订单 /// </summary> /// <returns></returns> public RES LoadOrder(string orderID) { var res = RES.New; var orderGuid = ORDER.OrderIDToGuid(orderID); var db = ModelEF.GetInst(); var order = db.YunOrders.FirstOrDefault(p => p.ID == orderGuid); var qrCodeList = db.YunQRCodes.Where(p => p.OrderID == orderGuid).ToList(); order.QRCodeList = qrCodeList; res.DATA = order; return(res.SetAsOK()); }
/// <summary> /// 检索一个商品信息 ID,Code /// </summary> /// <param name="key"></param> /// <returns></returns> public RES Get(string keyword) { if (GUID.IsGuid(keyword)) { var db = ModelEF.GetInst(); var guid = Guid.Parse(keyword); var val = db.YunForms.FirstOrDefault(p => p.ID == guid); var inst = ModelEF.GetInst().YunForms.FirstOrDefault(p => p.ID == Guid.Parse(keyword)); return(RES.New.SetAsOK(inst)); } return(RES.New.SetAsFail()); }
public RES LoadList(string filter) { try { var db = ModelEF.GetInst(); var titleId = GUID.FromStringToGuid("Title"); var list = db.YunFormInsts.Where(p => p.CreateTime <= DateTime.Now && p.PropertyID == titleId).ToList(); return(RES.OK(list)); } catch (Exception ex) { return(RES.FAIL()); } }
public RES Save(string json) { try { var logItem = JSON.ToObject <ALog>(json); var db = ModelEF.GetInst(); db.ALogs.Add(logItem); db.SaveChangesAsync(); return(RES.OK()); } catch (Exception e) { return(RES.FAIL(e.Message)); } }
///下架 public RES OffShelves(string keyword) { var db = ModelEF.GetInst(); if (GUID.IsGuid(keyword)) { var guid = Guid.Parse(keyword); var val = db.YunForms.FirstOrDefault(p => p.ID == guid); if (null != val) { val.ValueI01 = (int)ENUM.CommodityStatus.架; } db.SaveChanges(); } return(RES.New.SetAsOK()); }
///删除商品 public RES Remove(string keyword) { var db = ModelEF.GetInst(); if (GUID.IsGuid(keyword)) { var guid = Guid.Parse(keyword); var val = db.YunForms.FirstOrDefault(p => p.ID == guid); if (null != val) { val.Status = (int)ENUM.实体状态.已删除; } db.SaveChanges(); } return(RES.New.SetAsOK()); }
public RES LoadDetail(string idStr) { try { if (GUID.IsGuid(idStr)) { var id = Guid.Parse(idStr); var db = ModelEF.GetInst(); var entity = db.YunFormInsts.FirstOrDefault(p => p.ID == id); return(RES.OK(entity)); } return(RES.FAIL()); } catch (Exception ex) { return(RES.FAIL()); } }
/// <summary> /// 获取当前节点信息 /// </summary> /// <param name="nodeId"></param> /// <returns></returns> public RES GetCurrentNode(string nodeId) { if (GUID.IsGuid(nodeId)) { try { var nId = Guid.Parse(nodeId); var db = ModelEF.GetInst(); var currentEntity = db.YunRelations.FirstOrDefault(p => p.ID == nId); return(RES.OK(currentEntity)); } catch (Exception ex) { return(RES.FAIL()); } } return(RES.FAIL()); }
/// <summary> /// 获取子节点集合 /// </summary> /// <param name="nodeId"></param> /// <returns></returns> public RES GetChildNodes(string nodeId) { if (GUID.IsGuid(nodeId)) { try { var nId = Guid.Parse(nodeId); var db = ModelEF.GetInst(); var childNodes = db.YunRelations.Where(p => p.ParentID == nId); return(RES.OK(childNodes)); } catch (Exception ex) { return(RES.FAIL()); } } return(RES.FAIL()); }
/// <summary> /// 保存一个ToDo /// </summary> /// <param name="id"></param> /// <param name="title"></param> /// <param name="content"></param> /// <returns></returns> public RES SaveToDo(string idStr, string title, string content) { try { var db = ModelEF.GetInst(); var titleId = GUID.FromStringToGuid("Title"); var contentId = GUID.FromStringToGuid("Content"); YunFormInst titleInst = null; YunFormInst contentInst = null; if (GUID.IsGuid(idStr)) { var id = Guid.Parse(idStr); var oldInst = db.YunFormInsts.Where(p => p.ID == id); if (null != oldInst) { titleInst = oldInst.FirstOrDefault(p => p.PropertyID == titleId); titleInst.PropertyValueString = title; titleInst.UpdateTime = DateTime.Now; contentInst = oldInst.FirstOrDefault(p => p.PropertyID == contentId); contentInst.PropertyValueString = title; contentInst.UpdateTime = DateTime.Now; } } else { titleInst = new YunFormInst { ID = Guid.NewGuid(), CreateTime = DateTime.Now, PropertyID = titleId, PropertyValueString = title }; contentInst = new YunFormInst { ID = Guid.NewGuid(), CreateTime = DateTime.Now, PropertyID = contentId, PropertyValueString = content }; db.YunFormInsts.Add(titleInst); db.YunFormInsts.Add(contentInst); } var rInt = db.SaveChanges(); return(RES.OK(rInt)); } catch (Exception ex) { return(RES.FAIL(ex.Message)); } }
/// <summary> /// 验证一个订单 /// </summary> /// <param name="json"></param> /// <returns></returns> public RES QRCodeCheckIn(string json) { var param = JSON.ToObject <Dictionary <string, object> >(json); var orderId = Guid.Parse(param["OrderId"].ToString()); var refundCount = 0; // var qrCode = string.Empty; // var db = ModelEF.GetInst(); var order = db.YunOrders.FirstOrDefault(p => p.ID == orderId); if (param.ContainsKey("QRCode") && null != param["QRCode"]) { qrCode = param["QRCode"].ToString(); order.QRCodeList = db.YunQRCodes.Where(p => p.OrderID == orderId && p.QRCode == qrCode).Take(1).ToList();; } else if (param.ContainsKey("Count") && null != param["Count"]) { refundCount = int.Parse(param["Count"].ToString()); order.QRCodeList = db.YunQRCodes.Where(p => p.OrderID == orderId).Take(refundCount).ToList(); } order.QRCodeList.ForEach(p => { p.Status = (int)ENUM.订单及消费项状态.无可用项目; }); if (0 < order.QRCodeList.Count(p => p.Status == (int)ENUM.订单及消费项状态.未使用)) { ///若还有可使用的 order.Status = (int)ENUM.订单及消费项状态.部分使用; } else if (0 < order.QRCodeList.Count(p => p.Status == (int)ENUM.订单及消费项状态.已退款) && order.QRCodeList.Count(p => p.Status == (int)ENUM.订单及消费项状态.已退款) == order.QRCodeList.Count()) { order.Status = (int)ENUM.订单及消费项状态.全部已退款; } else if (0 == order.QRCodeList.Count(p => p.Status == (int)ENUM.订单及消费项状态.未使用)) { order.Status = (int)ENUM.订单及消费项状态.无可用项目; } db.SaveChanges(); return(RES.New.SetAsOK(order)); }
/// <summary> /// 支付一个订单 /// </summary> /// <param name="json"></param> /// <returns></returns> public RES PayOrder(string json) { var param = JSON.ToObject <Dictionary <string, object> >(json); var orderId = Guid.Parse(param["OrderId"].ToString()); var db = ModelEF.GetInst(); var order = db.YunOrders.FirstOrDefault(p => p.ID == orderId); var qrCodeList = db.YunQRCodes.Where(p => p.OrderID == orderId).ToList(); order.QRCodeList = qrCodeList; order.Status = (int)ENUM.订单及消费项状态.未使用; qrCodeList.ForEach(p => { p.Status = (int)ENUM.订单及消费项状态.未使用; }); db.SaveChanges(); return(RES.New.SetAsOK(order)); }
/// <summary> /// 保存一个文档 /// </summary> /// <param name="title"></param> /// <param name="content"></param> /// <returns></returns> public RES SaveArticle(string title, string content, int status = 0) { try { var inst = new YunArticle(); inst.ID = Guid.NewGuid(); inst.Status = status; inst.Title = title; inst.Content = content; var db = ModelEF.GetInst(); db.YunArticles.Add(inst); db.SaveChangesAsync(); return(RES.OK(inst)); } catch (Exception ex) { return(RES.FAIL()); } }
/// <summary> /// 获取整棵树 /// </summary> /// <returns></returns> public RES GetWholeTree(string rootID) { if (GUID.IsGuid(rootID)) { try { var nId = Guid.Parse(rootID); var db = ModelEF.GetInst(); var nodes = db.YunRelations.Where(p => p.RootID == nId).ToList(); var rootNode = db.YunRelations.FirstOrDefault(p => p.ID == nId); nodes.Add(rootNode); return(RES.OK(nodes)); } catch (Exception ex) { return(RES.FAIL()); } } return(RES.FAIL()); }
public virtual RES SaveToSQLServer() { if (Guid.Empty == this.ID) { this.ID = Guid.NewGuid(); } HttpPostedFile file = HttpContext.Current.Request.Files[0]; var bytes = new byte[(int)file.InputStream.Length]; file.InputStream.Read(bytes, 0, bytes.Length); this.BinData = bytes; var res = RES.New; var db = ModelEF.GetInst(); db.YunForms.Add(this); db.SaveChanges(); return(res); }
/// <summary> /// 同步保存一个对象 /// </summary> /// <returns></returns> public virtual RES Save() { var res = RES.New; if (Guid.Empty == this.ID) { this.ID = Guid.NewGuid(); this.CreateTime = DateTime.Now; if (!this.Status.HasValue) { this.Status = (int)ENUM.实体状态.正常; } } ; var db = ModelEF.GetInst(); db.YunForms.Add(this); db.SaveChanges(); return(res); }
/// <summary> /// 移除一个子节点 /// </summary> /// <param name="nodeId"></param> /// <returns></returns> public RES RemoveNode(string nodeId) { if (GUID.IsGuid(nodeId)) { try { var nId = Guid.Parse(nodeId); var db = ModelEF.GetInst(); var currentEntity = db.YunRelations.FirstOrDefault(p => p.ID == nId); if (null != currentEntity) { currentEntity.Status = (int)ENUM.实体状态.已删除; } db.SaveChangesAsync(); return(RES.OK()); } catch (Exception ex) { return(RES.FAIL()); } } return(RES.FAIL()); }
/// <summary> /// 修改一个子节点的信息 /// </summary> /// <param name="nodeId"></param> /// <returns></returns> public RES RenameNode(string nodeId, string newName) { if (GUID.IsGuid(nodeId) && !string.IsNullOrWhiteSpace(newName)) { try { var nId = Guid.Parse(nodeId); var db = ModelEF.GetInst(); var currentEntity = db.YunRelations.FirstOrDefault(p => p.ID == nId); if (null != currentEntity) { currentEntity.Name = newName; } db.SaveChangesAsync(); return(RES.OK()); } catch (Exception ex) { return(RES.FAIL()); } } return(RES.FAIL()); }
/// <summary> /// 从url中保存一个原始文章 /// </summary> /// <param name="url"></param> /// <param name="headers"></param> /// <returns></returns> public RES SaveArticleFromUrl(string url, string headers) { try { var content = HTTP.Get(url, string.IsNullOrWhiteSpace(headers) ? null: JSON.ToObject <Dictionary <string, string> >(headers)); var inst = new YunArticle(); inst.ID = Guid.NewGuid(); inst.Status = (int)ENUM.实体状态.可用; inst.Title = null; inst.Url = url; inst.Content = content; inst.CreateTime = DateTime.Now; inst.UpdateTime = DateTime.Now; var db = ModelEF.GetInst(); db.YunArticles.Add(inst); db.SaveChangesAsync(); return(RES.OK(inst)); } catch (Exception ex) { return(RES.FAIL(ex.Message)); } }
/// <summary> /// 创建一个未支付订单 /// </summary> /// <param name="json"></param> /// <returns></returns> public RES CreatePrepayOrder(string goodsIDStr, long count, string sourceIDStr, string consumerIDStr) { var res = RES.New; if (!string.IsNullOrWhiteSpace(goodsIDStr) && 0 < count && !string.IsNullOrWhiteSpace(goodsIDStr) && !string.IsNullOrWhiteSpace(goodsIDStr)) { var db = ModelEF.GetInst(); ///若数据符合要求 var goodsID = new Guid(goodsIDStr); var sourceID = new Guid(sourceIDStr); var consumerID = new Guid(consumerIDStr); var yunOrder = new YunOrder(); yunOrder.GoodsID = goodsID; yunOrder.SourceID = sourceID; yunOrder.ConsumerID = consumerID; yunOrder.Count = (int)count; yunOrder.ID = Guid.NewGuid(); yunOrder.Status = (int)ENUM.订单及消费项状态.未支付; //yunOrder.OrderID =GUID. MD5.ToMD5( ORDER.NewOrderID); for (int k = 0; k < count; k++) { var item = new YunQRCode(); item.ID = Guid.NewGuid(); item.OrderID = yunOrder.ID; item.QRCode = item.OrderID.ToString() + k; //item.Status = (int)ENUM.EntityStatus.正常; item.Status = (int)ENUM.订单及消费项状态.未支付; db.YunQRCodes.Add(item); } db.YunOrders.Add(yunOrder); db.SaveChanges(); } return(res.SetAsOK()); }