/// <summary>
/// 判断表存在不
/// </summary>
/// <param name="TableName"></param>
/// <returns></returns>
public static bool ExistTable(string TableName)
{
DbBase db = new DbBase();
string sql = "select COUNT( *) from sysobjects where id = OBJECT_ID('[" + TableName + "]')";
return((int)db.ExecuteScalar(sql) > 0);
}
public string GetImageUrl(int goodsId, int goodsPackageId)
{
BLL.DbBase db = new BLL.DbBase();
db.ChangeDBShop();
string url = db.ExecuteScalar("SELECT dbo.[GetImagePathOriginal](" + goodsId.ToString() + "," + goodsPackageId.ToString() + ")") as string;
if (string.IsNullOrEmpty(url))
{
url = "images/nopic1.jpg";
}
return("http://image.101yao.com//" + url);
}
public string Login(string name, string pwd)
{
BLL.DbBase bll = new BLL.DbBase();
bll.ChangeDBShop();
int c = (int)bll.ExecuteScalar(string.Format("SELECT COUNT(*) FROM yxs_administrators WHERE NAME='{0}' AND PASSWORD='******'", Library.Lang.Input.Filter(name), Library.Lang.Input.MD5(pwd, false)));
if (c == 1)
{
Memcached.ClientLibrary.MemcachedClient mc = new Memcached.ClientLibrary.MemcachedClient();
mc.PoolName = "Price_Cache";
string authKey = MongoDB.Oid.NewOid().ToString();
mc.Set(authKey, name, DateTime.Now.AddHours(12));
return(authKey);
}
return(null);
}