/// <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);
}
