/*
* 推荐商家 后台用
* */
public JsonResult RecShopListGet(string shopId)
{
OleDbConnection mycn = buildConn();
mycn.Open();
string condition = "";
if (!string.IsNullOrEmpty(shopId))
{
condition += " and s.shopid= " + shopId + "";
}
string sql = "select s.* from shop s,recommend_shop r where 1=1 and r.shopid = s.shopid " + condition;
OleDbCommand mycm = new OleDbCommand(sql, mycn);
OleDbDataReader msdr = mycm.ExecuteReader();
List<RecShop> list = new List<RecShop>();
while (msdr.Read())
{
if (msdr.HasRows)
{
string[] readstring = new string[msdr.FieldCount];
for (int i = 0; i < msdr.FieldCount; i++)
{
if (msdr.IsDBNull(i))
{
continue;
}
}
RecShop u = new RecShop();
u.shopId = (int)msdr["shopid"];
u.shopName = msdr.GetString(1);
u.introduction = msdr.GetString(2);
u.picurl = msdr.GetString(3);
u.attention = (int)msdr["attention"];
list.Add(u);
}
}
msdr.Close();
mycn.Close();
return Json(new { data = list, success = true }, JsonRequestBehavior.AllowGet);
}
/*
* 天天美食、玩乐生活等
* type为必录项
*/
public JsonResult ShopNorTypeListGet(string type, string start, string limit)
{
OleDbConnection mycn = buildConn();
mycn.Open();
if (string.IsNullOrEmpty(type))
{
return Json(new { success = false, msg = "传入的type值为空！" }, JsonRequestBehavior.AllowGet);
}
string sql = "select s.shopid,s.shopname,s.introduction,s.piclist,s.attention from shop s where s.shopid in (select shop_id from shop_type where type_id = " + type + ")";// ) m left join type f on f.type_id = " + type + "" +" LIMIT " + start + ", " + limit + "";
OleDbCommand mycm = new OleDbCommand(sql, mycn);
OleDbDataReader msdr = mycm.ExecuteReader();
List<RecShop> list = new List<RecShop>();
while (msdr.Read())
{
if (msdr.HasRows)
{
string[] readstring = new string[msdr.FieldCount];
for (int i = 0; i < msdr.FieldCount; i++)
{
if (msdr.IsDBNull(i))
{
continue;
}
}
RecShop u = new RecShop();
u.shopId = Convert.ToInt32(msdr["shopid"]);
u.shopName = Convert.ToString(msdr["shopname"]);
u.introduction = Convert.ToString(msdr["introduction"]);
u.picurl = Convert.ToString(msdr["piclist"]);
u.attention = Convert.ToInt32(msdr["attention"]);
//u.type = Convert.ToString(msdr["type_name"]);
list.Add(u);
}
}
msdr.Close();
mycn.Close();
return Json(new { data = list, success = true }, JsonRequestBehavior.AllowGet);
}
/*
* 1会员商家 2新店推荐 3品牌推荐 4胜利特价
* 店铺列表
* */
public JsonResult ShopMidListGet(string type, string start, string limit)
{
OleDbConnection mycn = buildConn();
mycn.Open();
string condition = "";
if (!string.IsNullOrEmpty(type))
{
condition += " and r.type= '" + type + "'";
}
int curPage = (Convert.ToInt16(start) / 10);
int pag = curPage * Convert.ToInt16(limit);
string sql = "";
if (start == "0")
{
sql = "select top " + Convert.ToInt16(limit) + " s.*,r.type from shop s,recommend_shop r where 1=1 and r.shopid = s.shopid " + condition + " order by s.shopid desc ";
}
else
{
sql = "select top " + Convert.ToInt16(limit) + " s.*,r.type from shop s,recommend_shop r where 1=1 and r.shopid = s.shopid " + condition + " and s.shopid not in (select top " + pag + " shopid from shop s,type r where 1=1 and r.shopid= s.shopid " + condition + " ) order by s.shopid desc ";
}
OleDbCommand mycm = new OleDbCommand(sql, mycn);
OleDbDataReader msdr = mycm.ExecuteReader();
List<RecShop> list = new List<RecShop>();
while (msdr.Read())
{
if (msdr.HasRows)
{
string[] readstring = new string[msdr.FieldCount];
for (int i = 0; i < msdr.FieldCount; i++)
{
if (msdr.IsDBNull(i))
{
continue;
}
}
RecShop u = new RecShop();
u.shopId = Convert.ToInt32(msdr["shopid"]);
u.shopName = Convert.ToString(msdr["shopname"]);
u.introduction = Convert.ToString(msdr["introduction"]);
u.picurl = Convert.ToString(msdr["piclist"]);
u.attention = Convert.ToInt32(msdr["attention"]);
if (System.DBNull.Value != msdr["type"])
{
u.type = Convert.ToString(msdr["type"]);
}
list.Add(u);
}
}
msdr.Close();
mycn.Close();
return Json(new { data = list, success = true }, JsonRequestBehavior.AllowGet);
}
/*
* 我的收藏
* */
public JsonResult ShopFavorListGet(string userName, string start, string limit)
{
OleDbConnection mycn = buildConn();
mycn.Open();
string condition = "";
if (!string.IsNullOrEmpty(userName))
{
condition += " and u.username= '******'";
}
string sql = "select s.*,r.*,t.type_id from shop s,favorite r,shop_type t,sys_user u where 1=1 and u.id = r.user_id and t.shop_id = s.shopid and r.shop_id = s.shopid " + condition + " order by s.shopid";
OleDbCommand mycm = new OleDbCommand(sql, mycn);
OleDbDataReader msdr = mycm.ExecuteReader();
List<RecShop> list = new List<RecShop>();
List<RecShop> listResult = new List<RecShop>();
while (msdr.Read())
{
if (msdr.HasRows)
{
string[] readstring = new string[msdr.FieldCount];
for (int i = 0; i < msdr.FieldCount; i++)
{
if (msdr.IsDBNull(i))
{
continue;
}
}
RecShop u = new RecShop();
u.shopId = Convert.ToInt16(msdr["shopid"]);
u.shopName = Convert.ToString(msdr["shopname"]);
u.introduction = Convert.ToString(msdr["introduction"]);
u.picurl = Convert.ToString(msdr["piclist"]);
u.attention = Convert.ToInt16(msdr["attention"]);
u.type = Convert.ToString((int)msdr["type_id"]);
list.Add(u);
}
}
int s = Convert.ToInt16(start);
int p = Convert.ToInt16(limit);
if (p > list.Count - s - (p * (s / p)))
{
p = list.Count;
}
for (int i = s; i < p; i++)
{
listResult.Add(list[i]);
}
msdr.Close();
mycn.Close();
return Json(new { data = listResult, success = true }, JsonRequestBehavior.AllowGet);
}
