public static bool AddTuiGuang(TuiguangPro tuiguang) { try { string query = @"insert into TuiguangPro(itemNo,sellerNick,itemPicUrl,itemTitle,itemUrl,price, inventory,tuiStatus,tuiAddress,createTime,endUseTime,openId) values(@itemNo,@sellerNick,@itemPicUrl,@itemTitle,@itemUrl,@price, @inventory,@tuiStatus,@tuiAddress,getdate(),@endUseTime,@openId)"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@itemNo", string.IsNullOrEmpty(tuiguang.ItemNo)?"":tuiguang.ItemNo), new SqlParameter("@sellerNick", string.IsNullOrEmpty(tuiguang.SellerNick)?"":tuiguang.SellerNick), new SqlParameter("@itemPicUrl", string.IsNullOrEmpty(tuiguang.ItemPicUrl)?"":tuiguang.ItemPicUrl), new SqlParameter("@itemTitle", string.IsNullOrEmpty(tuiguang.ItemTitle)?"":tuiguang.ItemTitle), new SqlParameter("@itemUrl", string.IsNullOrEmpty(tuiguang.ItemUrl)?"":tuiguang.ItemUrl), new SqlParameter("@price", string.IsNullOrEmpty(tuiguang.Price)?"":tuiguang.Price), new SqlParameter("@inventory", string.IsNullOrEmpty(tuiguang.Inventory)?"":tuiguang.Inventory), new SqlParameter("@tuiStatus", string.IsNullOrEmpty(tuiguang.TuiStatus)?"":tuiguang.TuiStatus), new SqlParameter("@tuiAddress", string.IsNullOrEmpty(tuiguang.TuiAddress)?"":tuiguang.TuiAddress), new SqlParameter("@endUseTime", string.IsNullOrEmpty(tuiguang.EndUseTime)?"":tuiguang.EndUseTime), new SqlParameter("@openId", string.IsNullOrEmpty(tuiguang.OpenId)?"":tuiguang.OpenId) }; DataBase.ExecuteSql(query, param); return(true); } catch (Exception ex) { ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data); return(false); } }
public static bool AddTask(string itemNo) { Item itm = TBOnSalePro.GetItemByID(Users.SessionKey, itemNo); if (itm != null) { TuiguangPro obj = new TuiguangPro(); obj.ItemNo = itemNo; obj.SellerNick = Users.Nick; obj.ItemPicUrl = itm.PicUrl; obj.ItemTitle = itm.Title; obj.ItemUrl = itm.DetailUrl; obj.Price = itm.Price; obj.Inventory = itm.SoldQuantity.ToString(); obj.TuiStatus = "1";// 1:推广中 0:下架中 obj.EndUseTime = Users.Deadline == null ? "" : Users.Deadline; //分配或者获取Openid string openID = ""; DataTable tbOpenid = tuiGuangDAL.GetTuiGuangOpenID(Users.Nick); if (tbOpenid != null && tbOpenid.Rows.Count == 1) { openID = tbOpenid.Rows[0]["openId"].ToString(); } else { DataTable tbSytemOpenIds = tuiGuangDAL.GetSystemOpenIDs(); if (tbSytemOpenIds != null && tbSytemOpenIds.Rows.Count > 0) { for (int i = 0; i < tbSytemOpenIds.Rows.Count; i++) { string openId = tbSytemOpenIds.Rows[i]["openid"].ToString(); if (tuiGuangDAL.ChekOpenIDCanUsed(openId)) { openID = openId; //执行更新操作,将分配的OPENID占用 tuiGuangDAL.UpdateOpenStatus(openId); break; } } } } obj.OpenId = openID; if (!string.IsNullOrEmpty(openID)) { obj.TuiAddress = "http://youmuya.wx.jaeapp.com/index.php/Home/Choice/shareGoodsDetail/gid/" + openID + ".html"; if (tuiGuangDAL.AddTuiGuang(obj)) { return(true); } } else { return(false); } } return(false); }
public static bool UpdateTuiPro(string itemNo, string status) { try { TuiguangPro obj = new TuiguangPro(); obj.SellerNick = System.Web.HttpUtility.UrlEncode(Users.Nick); obj.ItemNo = itemNo; obj.TuiStatus = status; return(tuiGuangDAL.UpdateTuiPro(obj)); } catch (Exception ex) { ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data); } return(false); }
/// <summary> /// 下架/上架推广位 /// </summary> /// <param name="o"></param> /// <returns></returns> public static bool UpdateTuiPro(TuiguangPro o) { try { string query = @"update TuiguangPro set tuiStatus = @tuiStatus where itemNo = @itemNo and sellerNick = @sellerNick"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@tuiStatus", o.TuiStatus), new SqlParameter("@itemNo", o.ItemNo), new SqlParameter("@sellerNick", o.SellerNick), }; DataBase.ExecuteSql(query, param); return(true); } catch (Exception ex) { ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data); return(false); } }