public ActionResult Update(long id)
{
List <Category> categoryList = CategoryService.GetList();
var selectItemList = new List <SelectListItem>()
{
new SelectListItem()
{
Value = "0", Text = "未知"
}
};
var selectList = new SelectList(categoryList, "ID", "Name");
selectItemList.AddRange(selectList);
Product_MY p = new Product_MY();
if (id > 0)
{
p = ProductService.GetInfo(id);
if (p == null)
{
p = new Product_MY();
}
else
{
selectItemList.Find(s => s.Value == p.PCID.ToString()).Selected = true;
}
}
ViewBag.CategoryList = selectItemList;
return(View(p));
}
public ActionResult GetDetail(long id)
{
Product_MY product = ProductMyService.GetInfo(id);
if (product != null)
{
var redpack = UtilityService.GetRedPack(product.PPrice.Value, product.CouponMoney.Value, 10);
return(Json(new
{
code = 0,
result = new
{
id = product.ID,
name = product.PTitle,
img = product.PImgUrls.Split('|')[0],
price = product.PPrice - product.CouponMoney - redpack,
coupon = product.CouponMoney,
redpack = redpack,
sales = product.PSales,
key = product.CouponCommand
}
}, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { code = 1, result = new { } }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Update(Product_MY p)
{
if (p.ID > 0)
{
int result = ProductService.Update(p);
return(Content("<script>alert('修改成功');window.location.href='" + Url.Content("~/Product/Update?id=") + p.ID + "';</script>"));
}
else
{
return(Content("<script>alert('修改失败');window.location.href='" + Url.Content("~/Product/Update?id=") + p.ID + "';</script>"));
}
}
public static List <Product_MY> GetDouble11List(DataTable dt, int productType)
{
if (dt == null || dt.Rows.Count == 0)
{
return(null);
}
else
{
List <Category> cList = CategoryService.GetList();
Category matchCategory = new Category();
List <Product_MY> pList = new List <Product_MY>();
foreach (DataRow dr in dt.Rows)
{
if (!string.IsNullOrWhiteSpace(dr[0].ToString()))
{
matchCategory = cList.Find(c => c.MappingName.Contains(dr[0].ToString()));
Product_MY product = new Product_MY();
product.AddedID = ConfigService.LoginUser == null ? 1 : ConfigService.LoginUser.ID;
product.PlanID = ConfigService.LoginUser == null ? "0" : ConfigService.LoginUser.PID;
product.AddedType = 4;
product.PID = Convert.ToInt64(dr[3]);
product.PTitle = dr[4].ToString();
product.PImgUrls = dr[6].ToString() + "_300x300.jpg";
product.PLink = dr[5].ToString();
product.PCID = matchCategory == null || matchCategory.ID == 0 ? 15 : matchCategory.ID;
product.PPrice = Convert.ToDecimal(dr[7]);
//product.PSales = Convert.ToInt32(dr[7]);
product.PRate = Convert.ToDecimal(dr[8]);
product.CouponMoney = UtilityService.GetMinPriceFromStr(dr[10].ToString());
product.PCommission = (product.PPrice - product.CouponMoney) * (product.PRate / 100);
product.PRedPack = UtilityService.GetRedPack(product.PPrice.Value, product.CouponMoney.Value, product.PRate.Value);
product.CouponEndTime = string.IsNullOrWhiteSpace(dr[15].ToString()) ? DateTime.Now.AddDays(7) : Convert.ToDateTime(dr[15]).AddDays(1);
product.CouponCount = Convert.ToInt32(dr[12]);
product.CouponRemain = Convert.ToInt32(dr[13]);
product.CouponShortLink = string.IsNullOrWhiteSpace(dr[16].ToString()) ? dr[5].ToString() : dr[16].ToString();
product.CouponLink = string.IsNullOrWhiteSpace(dr[16].ToString()) ? dr[5].ToString() : dr[16].ToString();
//product.CouponCommand = dt.Columns.Count == 23 ? dr[22].ToString() : "";
product.AddedTime = DateTime.Now;
if (product.CouponEndTime > DateTime.Now)
{
pList.Add(product);
}
}
}
return(pList);
}
}
public static List <Product_MY> GetHightList(DataTable dt, int productType)
{
if (dt == null || dt.Rows.Count == 0)
{
return(null);
}
else
{
List <Product_MY> pList = new List <Product_MY>();
foreach (DataRow dr in dt.Rows)
{
if (!string.IsNullOrWhiteSpace(dr[0].ToString()))
{
Product_MY product = new Product_MY();
product.AddedID = ConfigService.LoginUser == null ? 1 : ConfigService.LoginUser.ID;
product.PlanID = ConfigService.LoginUser == null ? "0" : ConfigService.LoginUser.PID;
product.AddedType = 3;
product.PID = Convert.ToInt64(dr[0]);
product.PTitle = dr[1].ToString();
product.PImgUrls = dr[2].ToString() + "_300x300.jpg";
product.PLink = dr[3].ToString();
product.PCID = productType;
product.PPrice = Convert.ToDecimal(dr[5]);
product.PSales = Convert.ToInt32(dr[6]);
product.PRate = string.IsNullOrWhiteSpace(dr[10].ToString()) ? Convert.ToDecimal(dr[7]) : Convert.ToDecimal(dr[10]);
product.CouponMoney = UtilityService.GetMinPriceFromStr(dr[20].ToString());
product.PCommission = (product.PPrice - product.CouponMoney) * (product.PRate / 100);
product.PRedPack = UtilityService.GetRedPack(product.PPrice.Value, product.CouponMoney.Value, product.PRate.Value);
product.CouponEndTime = string.IsNullOrWhiteSpace(dr[22].ToString()) ? Convert.ToDateTime(dr[13]) : Convert.ToDateTime(dr[22]).AddDays(1);
product.CouponCount = Convert.ToInt32(dr[18]);
product.CouponRemain = Convert.ToInt32(dr[19]);
product.CouponShortLink = string.IsNullOrWhiteSpace(dr[25].ToString()) ? dr[15].ToString() : dr[25].ToString();
product.CouponLink = string.IsNullOrWhiteSpace(dr[23].ToString()) ? dr[16].ToString() : dr[23].ToString();
product.CouponCommand = string.IsNullOrWhiteSpace(dr[24].ToString()) ? dr[17].ToString() : dr[24].ToString();
product.AddedTime = DateTime.Now;
if (product.CouponEndTime > DateTime.Now)
{
pList.Add(product);
}
}
}
return(pList);
}
}
public ActionResult Add()
{
List <Category> categoryList = CategoryService.GetList();
var selectItemList = new List <SelectListItem>()
{
new SelectListItem()
{
Value = "0", Text = "全部"
}
};
var selectList = new SelectList(categoryList, "ID", "Name");
selectItemList.AddRange(selectList);
Product_MY p = new Product_MY();
ViewBag.CategoryList = selectItemList;
return(View(p));
}
public ActionResult Add(Product_MY p)
{
p.AddedID = ConfigService.LoginUser == null ? 1 : ConfigService.LoginUser.ID;
p.PlanID = ConfigService.LoginUser == null ? "0" : ConfigService.LoginUser.PID;
p.AddedType = 3;
p.AddedTime = DateTime.Now;
if (!p.CouponEndTime.HasValue)
{
p.CouponEndTime = DateTime.Now.AddDays(3);
}
else
{
p.CouponEndTime = p.CouponEndTime.Value.AddDays(1);
}
if (!p.PSales.HasValue)
{
p.PSales = 0;
}
if (!p.PRate.HasValue)
{
p.PRate = 0;
}
if (!p.CouponStartTime.HasValue)
{
p.CouponStartTime = DateTime.Now;
}
if (!p.CouponCount.HasValue)
{
p.CouponCount = 100;
}
if (!p.CouponRemain.HasValue)
{
p.CouponRemain = 100;
}
if (p.PPrice.HasValue && p.CouponMoney.HasValue && p.PRate.HasValue)
{
p.PCommission = (p.PPrice - p.CouponMoney) * (p.PRate / 100);
p.PRedPack = UtilityService.GetRedPack(p.PPrice.Value, p.CouponMoney.Value, p.PRate.Value);
}
p.ID = ProductService.Add(p);
return(Content("<script>alert('添加成功');window.location.href='" + Url.Content("~/Product/Add") + "';</script>"));
}
public ActionResult Detail(long id, bool isjson = false)
{
Product_MY product = ProductMyService.GetInfo(id);
if (string.IsNullOrWhiteSpace(product.CouponCommand))
{
ITopClient client = new DefaultTopClient(ConfigService.TaoBaoApiUrl, "24526506", "5a9e071dacf3f6f925eccce6f7b99602", "json");
TbkTpwdCreateRequest req = new TbkTpwdCreateRequest();
req.UserId = "98776048";
req.Text = product.PTitle;
req.Url = product.CouponLink;
req.Logo = product.PImgUrls.Replace("300x300", "100x100");
req.Ext = "{\"test\":\"testv\"}";
TbkTpwdCreateResponse rsp = client.Execute(req);
JObject obj = JObject.Parse(rsp.Body);
if (obj["tbk_tpwd_create_response"] != null &&
obj["tbk_tpwd_create_response"]["data"] != null &&
obj["tbk_tpwd_create_response"]["data"]["model"] != null)
{
product.CouponCommand = obj["tbk_tpwd_create_response"]["data"]["model"].ToString();
ProductMyService.Update(product);
if (isjson)
{
return(Json(new { key = product.CouponCommand }, JsonRequestBehavior.AllowGet));
}
}
else
{
ErrorLog.WriteTextLog("", rsp.Body, DateTime.Now);
if (isjson)
{
return(Json(new { key = "" }, JsonRequestBehavior.AllowGet));
}
}
}
else if (isjson)
{
return(Json(new { key = product.CouponCommand }, JsonRequestBehavior.AllowGet));
}
return(View(product));
}
public ActionResult GetDetail(long id, long userid = 0)
{
Product_MY product = ProductService.GetInfo(id);
if (product != null)
{
product.ClickCount = product.ClickCount + 1;
ProductService.Update(product);
UsersBLog log = new UsersBLog();
log.BrowseTime = DateTime.Now;
log.CategoryID = product.PCID;
log.Name = product.PTitle;
log.ProductID = product.ID;
log.ProductLink = product.PLink;
log.UserID = userid;
UsersBLogService.Insert(log);
return(Json(new
{
code = 0,
data = new
{
id = product.ID,
name = product.PTitle,
imgs = product.PImgUrls.Split('|'),
price = product.PPrice - product.CouponMoney - product.PRedPack,
coupon = product.CouponMoney,
desc = product.Desc,
redpack = product.PRedPack,
sales = product.PSales,
key = product.CouponCommand
}
}, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { code = 1, msg = "商品ID错误" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Code(long id)
{
Product_MY product = ProductMyService.GetInfo(id);
string imgSrc = "";
if (product != null)
{
if (string.IsNullOrWhiteSpace(product.Remark))
{
imgSrc = CodeHelper.CombinImage(product.PImgUrls.Split('|')[0], product.ID, product.PTitle, product.PPrice.Value, product.CouponMoney.Value, product.PSales.Value);
if (!string.IsNullOrWhiteSpace(imgSrc))
{
product.Remark = imgSrc;
ProductMyService.Update(product);
}
}
else
{
imgSrc = product.Remark;
}
}
ViewBag.Src = imgSrc;
return(View());
}
public static int Update(Product_MY p)
{
return(MySqlHelper.context.Update(p));
}
public static long Add(Product_MY p)
{
Product_MY newP = MySqlHelper.context.Insert(p);
return(newP.ID);
}
public static int TaobaoAppInput(string text, int cid)
{
text = text.Trim('\n');
Regex titleReg = new Regex("(?<=.?).+(?=【包邮】)");
Regex priceReg = new Regex("(?<=【在售价】).+(?=元)");
Regex price2Reg = new Regex("(?<=【券后价】).+(?=元)");
Regex urlReg = new Regex("(?<=【下单链接】).+(?=\\n)");
Regex cmdReg = new Regex("(?<=复制这条信息，).+(?=，)");
Regex imgReg = new Regex("(?<=var extraData = {\"pic\":\").+(?=\",\"title)");
Regex couponLinkReg = new Regex("(?<=var url = ').+(?=';)");
try
{
string shoplink = urlReg.Match(text).Value;
if (string.IsNullOrEmpty(shoplink))
{
return(1);
}
string response = RequestUtility.GetData(shoplink);
if (string.IsNullOrEmpty(response))
{
return(2);
}
string imgpath = imgReg.Match(response).Value;
if (string.IsNullOrEmpty(imgpath))
{
return(3);
}
imgpath = "https:" + imgpath + "_300x300";
decimal price2 = Convert.ToDecimal(price2Reg.Match(text).Value);
Product_MY product = new Product_MY();
product.AddedID = ConfigService.LoginUser == null ? 1 : ConfigService.LoginUser.ID;
product.AddedTime = DateTime.Now;
product.AddedType = 3;
product.ClickCount = 0;
product.CouponCommand = cmdReg.Match(text).Value;
product.CouponCount = 100;
product.CouponEndTime = DateTime.Now.AddDays(2);
product.CouponLink = couponLinkReg.Match(response).Value;
product.PPrice = Convert.ToDecimal(priceReg.Match(text).Value);
product.CouponMoney = product.PPrice - price2;
product.CouponRemain = 100;
product.CouponShortLink = shoplink;
product.CouponStartTime = DateTime.Now;
product.Desc = "";
product.DescImgs = "";
product.IsBig = true;
product.PCID = cid;
product.PCommission = 0;
product.PID = 0;
product.PImgUrls = imgpath;
product.PIntro = "";
product.PlanID = ConfigService.LoginUser == null ? "" : ConfigService.LoginUser.PID;
product.PLink = product.CouponLink;
product.PRate = 0;
product.PSales = 0;
product.PTitle = titleReg.Match(text).Value;
product.Remark = "";
if (string.IsNullOrEmpty(product.PTitle) ||
string.IsNullOrWhiteSpace(product.CouponCommand) ||
!product.PPrice.HasValue ||
!product.CouponMoney.HasValue ||
string.IsNullOrWhiteSpace(product.CouponShortLink))
{
return(4);
}
IQuery <Product_MY> q = MySqlHelper.context.Query <Product_MY>();
var pmy = q.Where(p => p.CouponCommand == product.CouponCommand || p.CouponShortLink == product.CouponShortLink).FirstOrDefault();
if (pmy != null)
{
product.ID = pmy.ID;
MySqlHelper.context.Update(product);
}
else
{
Product_MY newP = MySqlHelper.context.Insert(product);
}
}
catch (Exception ex)
{
ErrorLog.WriteTextLog("TaobaoAppInput", ex.ToString(), DateTime.Now);
return(5);
}
return(0);
}
public static int QTKInput(string url, string text, int cid)
{
Regex titleReg = new Regex("(?<=今日推荐：).+(?=\\n)");
Regex priceReg = new Regex("(?<=（售价 ).+(?=元）)");
Regex introReg = new Regex("(?<=【推荐理由】).+(?=\\n)");
Regex salesReg = new Regex("(?<=已抢).+(?=件)");
Regex couponReg = new Regex("(?<=领).+(?=元券包邮秒杀)");
Regex urlReg = new Regex("(?<=商品链接：).+(?=；)");
Regex cmdReg = new Regex("(?<=或复制这条信息).+(?=，)");
try
{
Product_MY product = new Product_MY();
product.AddedID = ConfigService.LoginUser == null?1: ConfigService.LoginUser.ID;
product.AddedTime = DateTime.Now;
product.AddedType = 3;
product.ClickCount = 0;
product.CouponCommand = cmdReg.Match(text).Value;
product.CouponCount = 100;
product.CouponEndTime = DateTime.Now.AddDays(2);
product.CouponLink = "";
product.CouponMoney = Convert.ToDecimal(couponReg.Match(text).Value);
product.CouponRemain = 100;
product.CouponShortLink = urlReg.Match(text).Value;
product.CouponStartTime = DateTime.Now;
product.Desc = "";
product.DescImgs = "";
product.IsBig = true;
product.PCID = cid;
product.PCommission = 0;
product.PID = 0;
product.PImgUrls = url;
product.PIntro = introReg.Match(text).Value;
product.PlanID = ConfigService.LoginUser == null ? "" : ConfigService.LoginUser.PID;
product.PLink = product.CouponLink;
product.PPrice = Convert.ToDecimal(priceReg.Match(text).Value);
product.PRate = 0;
product.PSales = Convert.ToInt32(salesReg.Match(text).Value);
product.PTitle = titleReg.Match(text).Value;
product.Remark = "";
if (string.IsNullOrEmpty(product.PTitle) ||
string.IsNullOrWhiteSpace(product.CouponCommand) ||
!product.PPrice.HasValue ||
!product.PSales.HasValue ||
!product.CouponMoney.HasValue ||
string.IsNullOrWhiteSpace(product.CouponShortLink))
{
return(1);
}
IQuery <Product_MY> q = MySqlHelper.context.Query <Product_MY>();
var pmy = q.Where(p => p.CouponCommand == product.CouponCommand || p.CouponShortLink == product.CouponShortLink).FirstOrDefault();
if (pmy != null)
{
MySqlHelper.context.Delete <Product_MY>(p => p.ID == pmy.ID);
}
Product_MY newP = MySqlHelper.context.Insert(product);
}
catch (Exception ex)
{
ErrorLog.WriteTextLog("QTKInput", ex.ToString(), DateTime.Now);
return(2);
}
return(0);
}
