private int dayWorker5 = 0;//标记今天是否执行重新初始化一次价格
/// <summary>
/// 处理商品价格变动
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public void backgroundWorker5_DoWork(object sender, DoWorkEventArgs e)
{
while (true)
{
//每天晚上重新初始化一次价格
try
{
if (DateTime.Now.Hour > 2 && dayWorker5 != DateTime.Now.Day)
{
Common.Timer.InitProduct_SaleNum();
//Common.Timer.InitProduct_tag();
//Common.Timer.InitDrugsBase_tag();
Common.Timer.InitProduct_otc();
///重新计算菜单数量
SOSOshop.BLL.Category.Menu.InitData();
//更新商品标签
SOSOshop.BLL.DbBase db = new SOSOshop.BLL.DbBase();
db.ChangeShop();
db.ExecuteNonQuery("UPDATE Product SET tag_ids=b.Tag_Ids FROM Product a INNER JOIN dbo.DrugsBase_Tag_Ids b ON a.DrugsBase_ID = b.DrugsBase_Id WHERE a.tag_ids<>b.Tag_Ids and a.tag_ids<>b.Tag_Ids");
//禁止前台显示 含麻制剂（特特药品）,计生类药品,精神药品,蛋白同化制剂
db.ExecuteNonQuery("UPDATE Product SET Product_bShelves=0,beactive='删' WHERE tag_ids LIKE('%,81,%') OR tag_ids LIKE('%,82,%') OR tag_ids LIKE('%,4,%') OR tag_ids LIKE('%,5,%') OR tag_ids LIKE('%,6,%') OR tag_ids LIKE('%,89,%') and beactive<>'删'");
//更新是否有包装盒
db.ExecuteNonQuery(@"UPDATE dbo.Product SET bimage=1 WHERE Goods_ID IN (SELECT Goods_ID FROM dbo.Goods_Image) AND bimage<>1
UPDATE dbo.Product SET bimage=0 WHERE Goods_ID NOT IN (SELECT Goods_ID FROM dbo.Goods_Image) AND bimage<>0", 120);
dayWorker5 = DateTime.Now.Day;
}
}
catch (Exception ex1)
{
dayWorker5 = DateTime.Now.Day;
SOSOshop.BLL.Logs.Log.LogServiceAdd(ex1.Message, 0, "", "ERP价格处理", ex1.ToString(), 2);
}
System.Threading.Thread.Sleep(1000 * 60 * 1);//1分钟
}
}
public bool SendMember(DataSet ds, string authKey)
{
bool ret = false;
if (authKey == key)
{
try
{
SOSOshop.BLL.DbBase db = new SOSOshop.BLL.DbBase();
var dt = db.ExecuteTable("SELECT * FROM _memberinfo");
foreach (DataRow item in ds.Tables[0].AsEnumerable().Except(dt.AsEnumerable()))
{
adduser(item);
}
db.ExecuteNonQuery("TRUNCATE TABLE _memberinfo");
List <string> c = new List <string>();
foreach (DataColumn item in dt.Columns)
{
c.Add(item.ColumnName);
}
db.BulkToDB(ds.Tables[0], "_memberinfo", c.ToArray());
}
catch (Exception ex)
{
SOSOshop.BLL.Logs.Log.LogServiceAdd(ex.Message, 0, "", "api.asmx SendMember()", ex.StackTrace, 2);
}
}
return(ret);
}
/// <summary>
/// 更新号码与QQ
/// </summary>
private void UpdatePhoneAndQQ()
{
string strAct = Request["act"];
if (!Library.Lang.DataValidator.isNULL(strAct))
{
if (strAct.Contains("yxs_administrators"))
{
string[] act = strAct.Split(':');
string val = Request["val"];
string id = Request["id"];
int adminId = 0;
string value = val;
string column = string.Empty;
if (id != "" || id != "0")
{
adminId = Convert.ToInt32(id);
}
if (act[2] == "LoginAuthenticationOfficePhone")
{
column = "LoginAuthenticationOfficePhone";
}
else if (act[2] == "OfficePhone")
{
column = "OfficePhone";
}
else if (act[2] == "QQ")
{
column = "QQ";
}
if (adminId != 0)
{
string sql = string.Format("update dbo.yxs_administrators set {0}='{1}' where adminId={2}", column, value, adminId);
SOSOshop.BLL.DbBase db = new SOSOshop.BLL.DbBase();
int returnVal = db.ExecuteNonQuery(sql);
Response.Write(returnVal > 0 ? "ok" : "抱歉，编辑失败。");
Response.End(); return;
}
else
{
Response.Write("编辑失败，未提供相应信息的Id");
Response.End(); return;
}
}
}
}