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 ActionResult Index()
{
ViewBag.js = 0; //是否执行提示js
ViewBag.info = ""; //提交信息文字
SOSOshop.BLL.Integral.MemberIntegralLock bll = new SOSOshop.BLL.Integral.MemberIntegralLock();
bool isAllow = bll.isAllow(BaseController.GetUserId(), SOSOshop.BLL.Integral.MemberIntegralTemplateEnum.每日签到);
ViewBag.isAllow = isAllow;
if (isAllow)
{
if (Request.HttpMethod == "POST")
{
new SOSOshop.BLL.Integral.MemberIntegral().AddIntegral(BaseController.GetUserId(), 0, SOSOshop.BLL.Integral.MemberIntegralTemplateEnum.每日签到, "");
ViewBag.js = 1;
ViewBag.isAllow = false;
SOSOshop.BLL.DbBase db = new SOSOshop.BLL.DbBase();
string sql = "SELECT name,diff FROM (SELECT TOP 1 *,(Integral-(SELECT integral FROM dbo.MemberIntegral WHERE uid=" + BaseController.GetUserId() + "))diff FROM dbo.MemberIntegralGift WHERE Integral>(SELECT integral FROM dbo.MemberIntegral WHERE uid=" + BaseController.GetUserId() + ") AND State=1)a ORDER BY diff ASC";
var dt = db.ExecuteTable(sql);
if (dt.Rows.Count > 0)
{
ViewBag.info = string.Format("还差{0:F0}积分即可兑换礼品({1})", dt.Rows[0]["diff"], dt.Rows[0]["name"]);
}
}
}
return(View());
}
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;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SOSOshop.BLL.AdministrorManager.CheckAdmin();
SOSOshop.BLL.SysParameter sp = new SOSOshop.BLL.SysParameter();
WebName = sp.WebSiteName;
WebTitle = sp.WebSiteTitle;
if (Request.QueryString["ClearCache"] != null)//清除缓存
{
SOSOshop.BLL.DbBase db1 = new SOSOshop.BLL.DbBase(); db1.ClearCache();
Response.Redirect("admin_index.aspx"); Response.End();
}
ChangeHope.DataBase.SQLServerHelper.connectionString = new SOSOshop.BLL.Db()._db.ConnectionString;
}
}
/// <summary>
/// 获取地区Id
/// </summary>
/// <param name="regionName"></param>
/// <returns></returns>
private int GetRegionId(string regionName)
{
int rtn = 0;
if (!string.IsNullOrEmpty(regionName))
{
SOSOshop.BLL.DbBase db = new SOSOshop.BLL.DbBase();
var dt = db.ExecuteScalar(string.Format("SELECT TOP 1 id FROM Region WHERE Name='{0}'", regionName));
if (dt != null)
{
int.TryParse(dt.ToString(), out rtn);
}
}
return(rtn);
}
/// <summary>
/// 取得挂网价等数据抓取及映射
/// </summary>
/// <returns></returns>
public string GetCrawl()
{
SOSOshop.BLL.DbBase db = new SOSOshop.BLL.DbBase();
object 基 = db.ExecuteScalar("SELECT COUNT(*) FROM exchange.dbo.Crawl_Data_Goods_RegionBidPricing");
object 基映 = db.ExecuteScalar("SELECT COUNT(*) FROM exchange.dbo.LinkRegionBidPricing");
object 调 = db.ExecuteScalar("SELECT COUNT(*) FROM exchange.dbo.Crawl_Data_Goods_RegionLimitPricing");
object 调映 = db.ExecuteScalar("SELECT COUNT(*) FROM exchange.dbo.LinkRegionLimitPricing");
object 挂 = db.ExecuteScalar("SELECT COUNT(*) FROM exchange.dbo.Crawl_Data_Goods_RegionPricing");
object 挂映 = db.ExecuteScalar("SELECT COUNT(*) FROM exchange.dbo.LinkRegionPricing");
string str = string.Format("基(<span style='color:red'>{0}</span>/<span style='color:#6699FF'>{1}</span>) 调(<span style='color:red'>{2}</span>/<span style='color:#6699FF'>{3}</span>) 挂(<span style='color:red'>{4}</span>/<span style='color:#6699FF'>{5}</span>)", 基, 基映, 调, 调映, 挂, 挂映);
return(str);
}
/// <summary>
/// 获取交易人员的电话和QQ
/// </summary>
/// <returns></returns>
public DataTable GetAdminPhoneAndQQ()
{
int uid = GetUserId();
DataTable resultTable = new DataTable();
if (uid != 0)
{
SOSOshop.BLL.DbBase db = new SOSOshop.BLL.DbBase();
string sql = "SELECT top 1 dbo.yxs_administrators.OfficePhone,dbo.yxs_administrators.QQ, yxs_administrators.name " +
"FROM dbo.memberinfo INNER JOIN dbo.yxs_administrators ON Editer = adminid " +
"WHERE UID=" + uid;
resultTable = db.ExecuteTableForCache(sql);
if (resultTable.Rows.Count == 0)
{
sql = "SELECT top 1 dbo.yxs_administrators.OfficePhone,dbo.yxs_administrators.QQ, yxs_administrators.name " +
"FROM dbo.yxs_administrators " +
"WHERE adminID=1";
resultTable = db.ExecuteTableForCache(sql);
}
}
else
{
SOSOshop.BLL.DbBase db = new SOSOshop.BLL.DbBase();
string sql = "SELECT top 1 dbo.yxs_administrators.OfficePhone,dbo.yxs_administrators.QQ, yxs_administrators.name " +
"FROM dbo.yxs_administrators " +
"WHERE adminID=1";
resultTable = db.ExecuteTableForCache(sql);
}
return(resultTable);
}
//
// GET: /Jf/
public ActionResult Index()
{
SOSOshop.BLL.DbBase bll = new SOSOshop.BLL.DbBase();
return(View(bll.ExecuteTable("select * from MemberIntegralGift where State=1")));
}
public static string Get_Html(string select, string select_name, string selected_value, string separater)
{
DataSet Category = new DataSet();
string sqlString = "SELECT id, name, detail, website, usergroup, sumproduct, editor, createdate, lastupdate, status, path FROM Tag WHERE 1=1 order by id";
Category = new SOSOshop.BLL.DbBase().ExecuteDataSet(sqlString);
Func <DataRow, bool> where1 = delegate(DataRow dr) { return(dr["path"].ToString().Split('/').Length == 1); }; //一级分类
Func <DataRow, bool> where2 = delegate(DataRow dr) { return(dr["path"].ToString().Split('/').Length == 2); }; //二级分类
Func <DataRow, bool> where3 = delegate(DataRow dr) { return(dr["path"].ToString().Split('/').Length == 3); }; //三级分类
Func <DataRow, bool> where4 = delegate(DataRow dr) { return(dr["path"].ToString().Split('/').Length == 4); }; //三级分类
Func <DataRow, bool> where5 = delegate(DataRow dr) { return(dr["path"].ToString().Split('/').Length == 5); }; //三级分类
DataRow[] dr1s = Category.Tables[0].Select().Where <DataRow>(where1).ToArray();
DataRow[] dr2s = Category.Tables[0].Select().Where <DataRow>(where2).ToArray();
DataRow[] dr3s = Category.Tables[0].Select().Where <DataRow>(where3).ToArray();
if (dr1s.Length == 0 || dr2s.Length == 0 || dr3s.Length == 0)
{
if (dr1s.Length == 0)
{
if (dr2s.Length == 0)
{
dr1s = dr3s;
}
else
{
dr1s = dr2s;
dr2s = dr3s;
}
}
else if (dr2s.Length == 0)
{
DataRow[] dr4s = Category.Tables[0].Select().Where <DataRow>(where4).ToArray();
DataRow[] dr5s = Category.Tables[0].Select().Where <DataRow>(where5).ToArray();
if (dr3s.Length == 0)
{
if (dr4s.Length == 0)
{
dr2s = dr5s;
}
else
{
dr2s = dr4s;
dr3s = dr5s;
}
}
else
{
dr2s = dr3s;
if (dr4s.Length == 0)
{
dr3s = dr5s;
}
else
{
dr3s = dr4s;
}
}
}
}
StringBuilder js = new StringBuilder();
int level = 0;
bool selected = (string.IsNullOrEmpty(selected_value) || selected_value.Trim() == "0");
if (select == "select")
{
js.Append("<select id=\"" + select_name + "\" name=\"tag_path\">");
}
if (select == "select")
{
js.Append("<option value=\"\"" + (selected ? " selected" : "") + ">未定义(默认)</option>");
}
int count1 = dr1s.Length;
DataRow dr1 = null;
for (int i1 = 0; i1 < count1; i1++)
{
dr1 = dr1s[i1];
//id, name, detail, website, usergroup, sumproduct, editor, createdate, lastupdate, status, path
selected = GetClassOptionSelected(dr1, selected_value);
level = 1;
if (dr2s.Length > 0)
{
DataRow[] _dr2s = dr2s.AsQueryable().Where <DataRow>(delegate(DataRow dr) { return(dr["path"].ToString() == dr1["path"].ToString() + "/" + dr["id"].ToString()); }).ToArray();
int count2 = _dr2s.Length;
if (count2 > 0)
{
js.Append(GetClassOptionValueString(select, dr1, selected, level, separater));
DataRow dr2 = null;
for (int i2 = 0; i2 < count2; i2++)
{
dr2 = _dr2s[i2];
selected = GetClassOptionSelected(dr2, selected_value);
level = 2;
if (dr3s.Length > 0)
{
DataRow[] _dr3s = dr3s.AsQueryable().Where <DataRow>(delegate(DataRow dr) { return(dr["path"].ToString() == dr2["path"].ToString() + "/" + dr["id"].ToString()); }).ToArray();
int count3 = _dr3s.Length;
if (count3 > 0)
{
js.Append(GetClassOptionValueString(select, dr2, selected, level, separater));
DataRow dr3 = null;
for (int i3 = 0; i3 < count3; i3++)
{
dr3 = _dr3s[i3];
selected = GetClassOptionSelected(dr3, selected_value);
level = 3;
js.Append(GetClassOptionValueString(select, dr3, selected, level, separater));
}
}
else
{
js.Append(GetClassOptionValueString(select, dr2, selected, level, separater));
}
}
else
{
js.Append(GetClassOptionValueString(select, dr2, selected, level, separater));
}
}
}
else
{
js.Append(GetClassOptionValueString(select, dr1, selected, level, separater));
}
}
else
{
js.Append(GetClassOptionValueString(select, dr1, selected, level, separater));
}
}
if (select == "select")
{
js.Append("</select>");
}
return(js.ToString());
}
private void UpdateMemberPermission(RadioButtonList cb)
{
int uid = 0; int.TryParse(this.hfUID.Value, out uid);
if (uid > 0 && cb.Enabled)
{
//授权
bool isCheckUp = SOSOshop.BLL.PowerPass.isPass("008009014");
if (!isCheckUp)
{
Response.Write("<script type=\"text/javascript\">alert('操作失败！无权限！');location='Buyer_Permissions.aspx?UID=" + uid + "';</script>");
Response.End();
}
else
{
SOSOshop.BLL.MemberPermission bll = new SOSOshop.BLL.MemberPermission();
string c = cb.ID.Replace("cb_", "");
string v = cb.SelectedValue;
bool ok = bll.Amend(uid, c, v);
if (!ok)
{
Response.Write("<script type=\"text/javascript\">alert('操作失败！');location='Buyer_Permissions.aspx?UID=" + uid + "';</script>");
Response.End();
}
else
{
#region 后台用户操作日志记录
SOSOshop.Model.AdminInfo adminInfo = SOSOshop.BLL.AdministrorManager.Get();
SOSOshop.BLL.Logs.Log.LogAdminAdd("修改买家权限[" + uid + "]" + c, (adminInfo == null ? 0 : adminInfo.AdminId), (adminInfo == null ? "" : adminInfo.AdminName), 1);
#endregion
#region 清除缓存
SOSOshop.BLL.DbBase db1 = new SOSOshop.BLL.DbBase(); db1.ClearCache();
#endregion
//快捷开通交易权限
if (v == "1" && c == "IsSpecialTrade")
{
string sql = "UPDATE dbo.memberaccount SET isIsSpecialTradeDate=getdate() where uid={0};Update memberpermission set IsMoneyAndShipping=1,IsCOD=0 Where UID=(select top(1) UID from memberinfo where UID={0} and Member_Class=0) ";
sql += "Update memberpermission set IsMoneyAndShipping=0,IsCOD=1 Where UID=(select top(1) UID from memberinfo where UID={0} and Member_Class=1) ";
int effected = bll.ExecuteNonQuery(string.Format(sql, uid));
if (effected <= 0)
{
bll.Amend(uid, c, "0");
Response.Write("<script type=\"text/javascript\">alert('操作失败！');location='Buyer_Permissions.aspx?UID=" + uid + "';</script>");
Response.End();
}
else
{
//发送短信通知
string MobilePhone = Convert.ToString(bll.ExecuteScalar("select MobilePhone from memberaccount where UID=" + uid));
string SmsMsg = "尊敬的" + bll.ExecuteScalar("select TrueName from MemberInfo where UID=" + uid)
+ "，快捷交易权限（7天内有效）已开通，立即登录，畅享医药电商的网上采购快感";
string from = "系统";
string to = MobilePhone;
SOSOshop.BLL.Sms.SendAndSaveDataBase(MobilePhone, SmsMsg, from, to);
Response.Write("<script type=\"text/javascript\">location='Buyer_Permissions.aspx?UID=" + uid + "';</script>");
Response.End();
}
}
}
}
}
}
