/// <summary>
/// 更新二维码
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public bool Update(DistributorProductQrcodeInfo entity)
{
using (var conn = new SqlConnection(connectString))
{
string sql = @"UPDATE [Distributor_Product_Qrcode] SET [Qrcode]=@Qrcode WHERE [Product_Id]=@Product_Id AND [Distributor_Id]=@Distributor_Id";
return(conn.Execute(sql, entity) > 0);
}
}
public ActionResult CreateDistributorProductCode(int uid, int pid)
{
if (uid != distributor.Id)
{
return(Json(new { ok = false, error = "无权操作" }));
}
string qrcodeUrl = string.Empty;
DistributorProductQrcodeInfo qrcode = DistributorProductQrcodeBLL.Read(uid, pid);
if (qrcode != null && !string.IsNullOrWhiteSpace(qrcode.Qrcode))
{
return(Json(new { ok = true, qrcodeurl = qrcode.Qrcode }));
}
else
{
string access_token = WxGetInfo.IsExistAccess_Token();
string url = "https://api.weixin.qq.com/wxa/getwxacodeunlimit?access_token=" + access_token;
WxPayData jsondata = new WxPayData();
jsondata.SetValue("scene", uid + "," + pid);
jsondata.SetValue("page", "pages/product/detail");
jsondata.SetValue("width", 430);
CreateQrCode(jsondata, url, ref qrcodeUrl);
if (!string.IsNullOrWhiteSpace(qrcodeUrl))
{
#region 更新到DistributorProductCode表
if (qrcode == null)
{
DistributorProductQrcodeBLL.Add(new DistributorProductQrcodeInfo
{
Distributor_Id = uid,
Product_Id = pid,
Qrcode = qrcodeUrl
});
}
else
{
DistributorProductQrcodeBLL.Update(new DistributorProductQrcodeInfo
{
Distributor_Id = uid,
Product_Id = pid,
Qrcode = qrcodeUrl
});
}
#endregion
return(Json(new { ok = true, qrcodeurl = qrcodeUrl }));
}
else
{
return(Json(new { ok = false, error = "生成分销商品推广码出错" }));
}
}
}
public bool Add(DistributorProductQrcodeInfo entity)
{
//判断记录是否存在
if (Read(entity.Distributor_Id, entity.Product_Id) != null)
{
return(false);
}
using (var conn = new SqlConnection(connectString))
{
string sql = @"INSERT INTO [Distributor_Product_Qrcode]([Product_Id],[Distributor_Id],[Qrcode]) VALUES(@Product_Id,@Distributor_Id,@Qrcode)";
return(conn.Execute(sql, entity) > 0);
}
}
/// <summary>
/// 更新二维码
/// </summary>
public static bool Update(DistributorProductQrcodeInfo entity)
{
return(dal.Update(entity));
}
public static bool Add(DistributorProductQrcodeInfo entity)
{
return(dal.Add(entity));
}
