/// <summary> /// 添加或取消收藏 /// </summary> /// <param name="reqdata"></param> /// <param name="type">0添加 1取消</param> /// <returns></returns> public string AddOrCancelCollect(string reqdata, string type) { string res = ""; try { CollectAndFootPrintModel proreq = JsonConvert.DeserializeObject <CollectAndFootPrintModel>(reqdata); proreq.CreateDate = DateTime.Now.ToString("yyyy-MM-dd"); proreq.CreateTime = DateTime.Now; bool resb = false; if (type == "0")//添加收藏 { resb = cfdal.AddCollectOrFootPrint(proreq, "Collect"); } else//取消收藏 { resb = cfdal.DelCollectOrFootPrint(proreq, "Collect"); } res = JsonConvert.SerializeObject(new { code = 0, msg = "ok", addstate = resb }); } catch (Exception ex) { res = JsonConvert.SerializeObject(new { code = 10003, msg = "系统故障", count = 0 }); LogHelper.ErrorLog("添加取消收藏异常:" + ex.Message + "," + ex.StackTrace + ",参数:" + reqdata); } return(res); }
/// <summary> /// 获取用户足迹 带分页 /// </summary> /// <param name="uid"></param> /// <param name="index"></param> /// <param name="pagesize"></param> /// <param name="type">0收藏 1足迹</param> /// <returns></returns> public string GetFootPrintByPage(string uid) { string res = ""; try { int totalcount = 0; List <CollectAndFootPrintModel> list = cfdal.GetCOrFByPage(uid, out totalcount, "FootPrint"); var datearr = list.GroupBy(g => g.CreateDate); List <FootPrintOutModel> outlist = new List <FootPrintOutModel>(); foreach (var item in datearr) { FootPrintOutModel outm = new FootPrintOutModel(); outm.CreateDate = item.FirstOrDefault().CreateDate; outm.footlist = new List <CollectAndFootPrintModel>(); foreach (var sitem in item) { CollectAndFootPrintModel m = sitem; outm.footlist.Add(m); } outlist.Add(outm); } res = JsonConvert.SerializeObject(new { code = 0, msg = "ok", count = totalcount, rows = outlist }); } catch (Exception ex) { res = JsonConvert.SerializeObject(new { code = 10003, count = 0, msg = "系统故障" }); LogHelper.ErrorLog("查询收藏或者足迹异常:" + ex.Message + "," + ex.StackTrace); } return(res); }
/// <summary> /// 备件基础信息 /// </summary> /// <param name="reqdata"></param> /// <returns></returns> public string Product(string reqdata) { string res = ""; try { Product_Request reqd = JsonConvert.DeserializeObject <Product_Request>(reqdata); //reqd.PhoneNumber = reqd.PhoneNumber.Replace("15827002712", "18717764701"); reqd.key = AppSettingUtil.InsideApiKey2; Product_Response prespon = stockhttpdal.product(JsonConvert.SerializeObject(reqd)); if (prespon.code == 200) { Response_Product proinfo = ProductFactory(prespon); proinfo.StockQty = GetStockQty(reqd); //库存 ShoppingCartModel scm = shopcartdal.GetShoppingCartByPro(reqd.UnionId, reqd.keyValue, reqd.LocationName, reqd.SerialNumber, reqd.BatchNumber); proinfo.cartGoodsCount = scm != null ? scm.number : 0; //购物车数量 CollectAndFootPrintModel cfm = cfdal.GetCollectOrFootPrint(reqd.UnionId, reqd.keyValue, reqd.LocationName, reqd.SerialNumber, reqd.BatchNumber, "Collect"); proinfo.IsCollect = cfm == null ? 0 : 1; //收藏状态 res = JsonConvert.SerializeObject(new { code = 0, msg = "ok", ProductData = proinfo }); } else { res = JsonConvert.SerializeObject(new { code = 10002, msg = "api异常" }); } } catch (Exception ex) { res = JsonConvert.SerializeObject(new { code = 10003, msg = "系统故障", count = 0 }); LogHelper.ErrorLog(ex.Message + "," + ex.StackTrace); } return(res); }
/// <summary> /// 新增 /// </summary> /// <param name="model"></param> /// <param name="datatype">Collect收藏 FootPrint足迹</param> /// <returns></returns> public bool AddCollectOrFootPrint(CollectAndFootPrintModel model, string datatype) { using (IDbConnection connection = new SqlConnection(DBConnectionStringConfig.Default.WechatServerDBReadConnStr)) { string sql = " INSERT INTO " + datatype; sql += " (unionid,VendName,LocationName,ProductCode,SerialNumber,BatchNumber,ProductName,ProductDescrEN,ProductDescrCH,ImgUrl,CreateDate,CreateTime) "; sql += " VALUES "; sql += " (@unionid,@VendName,@LocationName,@ProductCode,@SerialNumber,@BatchNumber,@ProductName,@ProductDescrEN,@ProductDescrCH,@ImgUrl,@CreateDate,@CreateTime); "; sql += " SELECT CAST(SCOPE_IDENTITY() AS INT) "; model.Id = connection.Query <int>(sql, model).Single(); bool result = model.Id > 0; return(result); } }
/// <summary> /// 删除足迹 /// </summary> /// <param name="reqdata"></param> /// <returns></returns> public string DelFootPrint(string reqdata) { string res = ""; try { CollectAndFootPrintModel proreq = JsonConvert.DeserializeObject <CollectAndFootPrintModel>(reqdata); bool resb = cfdal.DelCollectOrFootPrint(proreq, "FootPrint"); res = JsonConvert.SerializeObject(new { code = 0, msg = "ok", addstate = resb }); } catch (Exception ex) { res = JsonConvert.SerializeObject(new { code = 10003, msg = "系统故障", count = 0 }); LogHelper.ErrorLog("添加取消收藏异常:" + ex.Message + "," + ex.StackTrace + ",参数:" + reqdata); } return(res); }
/// <summary> /// 删除足迹或者收藏 /// </summary> /// <param name="model"></param> /// <param name="datatype">Collect收藏 FootPrint足迹</param> /// <returns></returns> public bool DelCollectOrFootPrint(CollectAndFootPrintModel model, string datatype) { StringBuilder strSql = new StringBuilder(); DynamicParameters dp = new DynamicParameters(); strSql.Append(" DELETE FROM " + datatype); strSql.Append(" WHERE unionid=@unionid and ProductCode=@ProductCode and LocationName=@LocationName and SerialNumber=@SerialNumber and BatchNumber=@BatchNumber "); dp.Add("@unionid", model.unionid); dp.Add("@ProductCode", model.ProductCode); dp.Add("@LocationName", model.LocationName); dp.Add("@SerialNumber", model.SerialNumber); dp.Add("@BatchNumber", model.BatchNumber); using (IDbConnection connection = new SqlConnection(DBConnectionStringConfig.Default.WechatServerDBReadConnStr)) { bool result = connection.Execute(strSql.ToString(), dp) > 0; return(result); } }
/// <summary> /// 添加足迹 /// </summary> /// <param name="proreq"></param> public string AddFootPrint(string reqdata) { string res = ""; try { CollectAndFootPrintModel proreq = JsonConvert.DeserializeObject <CollectAndFootPrintModel>(reqdata); proreq.CreateDate = DateTime.Now.ToString("yyyy-MM-dd"); proreq.CreateTime = DateTime.Now; bool s = cfdal.AddCollectOrFootPrint(proreq, "FootPrint"); res = JsonConvert.SerializeObject(new { code = 0, msg = "ok", addstate = s }); } catch (Exception ex) { res = JsonConvert.SerializeObject(new { code = 10003, msg = "系统故障", count = 0 }); LogHelper.ErrorLog("添加足迹异常:" + ex.Message + "," + ex.StackTrace + ",参数:" + reqdata); } return(res); }