public static DBSql getInstance()
{
if (instance == null)
{
instance = new DBSql();
}
return(instance);
}
/// <summary>
/// 暂停活动
/// </summary>
/// <param name="promotion_id"></param>
/// <param name="session"></param>
/// <param name="actionId"></param>
/// <param name="iid"></param>
public void promotionStop(string promotion_id, string session, string actionId, string iid)
{
string appkey = "12287381";
string secret = "d3486dac8198ef01000e7bd4504601a4";
IDictionary <string, string> param = new Dictionary <string, string>();
//删除活动
param = new Dictionary <string, string>();
param.Add("promotion_id", promotion_id);
string result = Post("http://gw.api.taobao.com/router/rest", appkey, secret, "taobao.marketing.promotion.delete", session, param);
//更新结束活动
string sql = "update tete_activitylist set Status=3 ,isok=1 WHERE ActivityID = " + actionId + " and ProductID=" + iid;
DBSql.getInstance().ExecSql(sql);
}
/// <summary>
/// 暂停的活动
/// </summary>
private void activityStop()
{
try
{
string session = string.Empty;
DBSql db = DBSql.getInstance();
string sql1 = "select * from tete_activity where status=3 and isok=0 "; //暂停的活动
DataTable dt1 = DBSql.getInstance().GetTable(sql1);
if (dt1 != null && dt1.Rows.Count > 0)
{
for (int i = 0; i < dt1.Rows.Count; i++)
{
string sql2 = " select * from tete_activitylist where ActivityID=" + dt1.Rows[i]["ID"].ToString();//更新该活动下的商品
DataTable dt1s2 = DBSql.getInstance().GetTable(sql2);
if (dt1s2 != null && dt1s2.Rows.Count > 0)
{
for (int j = 0; j < dt1s2.Rows.Count; j++)
{
string sqlstr1 = "SELECT session FROM TopTaobaoShop WHERE nick = '" + dt1s2.Rows[j]["nick"].ToString() + "'";
DataTable dtnick = db.GetTable(sqlstr1);
if (dtnick.Rows.Count != 0)
{
session = dtnick.Rows[0]["session"].ToString();
}
//暂停活动
promotionStop(dt1s2.Rows[j]["promotionID"].ToString(), session, dt1s2.Rows[j]["ActivityID"].ToString(), dt1s2.Rows[j]["ProductID"].ToString());
}
}
sql1 = "update tete_activity set Status=3 , isok=1 where id=" + dt1.Rows[i]["ID"].ToString(); //暂停活动
DBSql.getInstance().ExecSql(sql1);
}
}
#region 除的活动 需要把活动商品删除掉
sql1 = "select * from tete_activity where status=4 and isok=0 "; //删除的活动
dt1 = DBSql.getInstance().GetTable(sql1);
if (dt1 != null && dt1.Rows.Count > 0)
{
for (int i = 0; i < dt1.Rows.Count; i++)
{
string sql2 = " select * from tete_activitylist where ActivityID=" + dt1.Rows[i]["ID"].ToString();//更新该活动下的商品
DataTable dt1s2 = DBSql.getInstance().GetTable(sql2);
if (dt1s2 != null && dt1s2.Rows.Count > 0)
{
for (int j = 0; j < dt1s2.Rows.Count; j++)
{
string sqlstr1 = "SELECT session FROM TopTaobaoShop WHERE nick = '" + dt1s2.Rows[j]["nick"].ToString() + "'";
DataTable dtnick = db.GetTable(sqlstr1);
if (dtnick.Rows.Count != 0)
{
session = dtnick.Rows[0]["session"].ToString();
}
//删除活动
promotionStop(dt1s2.Rows[j]["promotionID"].ToString(), session, dt1s2.Rows[j]["ActivityID"].ToString(), dt1s2.Rows[j]["ProductID"].ToString());
}
}
sql1 = "update tete_activity set Status=4 , isok=1 where id=" + dt1.Rows[i]["ID"].ToString(); //删除的活动
DBSql.getInstance().ExecSql(sql1);
}
}
#endregion
dt1.Dispose();
//休息后继续循环-默认1分半钟一次
Thread.Sleep(90000);
Thread newThread5 = new Thread(activityStop);
newThread5.Start();
}
catch (Exception e)
{
WriteLog4("自动取消活动运行错误*****************************************" + e.StackTrace + e.Message + "----error!!!", "1");
//MessageBox.Show("\r\n" + e.StackTrace);
Thread newThread5 = new Thread(activityStop);
//休息后继续循环-默认1分半钟一次
Thread.Sleep(90000);
newThread5.Start();
}
}