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