public List <IndexFloor> GetIndexFloor(string userId, string entId)
{
///获取用户信息
UserInfoDal dal = new UserInfoDal();
List <UserInfo> user = dal.GetUserInfo(userId, entId);
string jgjb = "", KhType = "";
bool landing = false;
bool staleDated = false;
if (user.Count > 0)
{
entId = user[0].EntId;
jgjb = user[0].Pricelevel;
KhType = user[0].KhType;
landing = true;
staleDated = user[0].StaleDated;
}
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@type", "floorImg"),
new SqlParameter("@jgjb", jgjb),
new SqlParameter("@khlb", KhType),
new SqlParameter("@EntId", entId),
new SqlParameter("@userId", userId),
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
var ds = sql.RunProDataSet("Proc_GoodsList", param);
List <IndexFloor> list = new List <IndexFloor>();
if (ds.Tables.Count > 0)
{
list = FillFloor(ds.Tables[0], ds.Tables[1], entId, landing, staleDated, jgjb, userId);
}
return(list);
}
/// <summary>
/// 搜索页获取商品列表
/// </summary>
/// <param name="ywyId">业务员Id</param>
/// <param name="userId">客户Id</param>
/// <param name="searchValue">搜索条件</param>
/// <param name="letter">厂家首字母</param>
/// <param name="tags">排序类型</param>
/// <param name="isKc">是否有货</param>
/// <param name="CategoryId">商品分类Id</param>
/// <param name="pageIndex">当前页</param>
/// <param name="pageSize">没页行数</param>
/// <returns></returns>
public ValetOrderModel <GoodsInfo> GetGoodsList(string ywyId, string userId, string searchValue, string letter, string tags, string isKc, string CategoryId, int pageIndex, int pageSize, string entid)
{
ValetOrderModel <GoodsInfo> mode = new ValetOrderModel <GoodsInfo>();
mode.PageIndex = pageIndex;
mode.PageSize = pageSize;
////加载用户信息
string jgjb = "", clientlimit = "", KhType = "";
try
{
//获取用户信息
UserInfoDal dal = new UserInfoDal();
List <UserInfo> user = new List <UserInfo>();
user = dal.GetUserInfo(userId, entid);
if (user.Count <= 0)
{
mode.Success = "002";
mode.Message = "客户信息获取失败";
return(mode);
}
entid = user[0].EntId;
jgjb = user[0].Pricelevel;
clientlimit = user[0].ClientLimit;
KhType = user[0].KhType;
}
catch (Exception ex)
{
LogQueue.Write(LogType.Error, "ValetOrder/GetGoodsList", ex.Message.ToString());
mode.Success = "002";
mode.Message = "客户信息获取失败," + ex.Message.ToString();
return(mode);
}
try
{
///加载查询条件
StringBuilder StrWhere = new StringBuilder();
if (searchValue.IndexOf(" ") >= 0)
{
string goodsValue, factoryValue;
string[] searchString = searchValue.Split(' ');
goodsValue = searchString[0];
factoryValue = searchString[1];
StrWhere.Append(" and b.mnemonic_code like '%" + goodsValue + "%' and b.Origin_mnemonic_code like '%" + factoryValue + "%' ");
}
else
{
StrWhere.Append(" and(b.goodscode like '%" + searchValue + "%' or b.sub_title like '%" + searchValue + "%' or b.mnemonic_code like '%" + searchValue + "%'");
StrWhere.Append(" or b.drug_factory like '%" + searchValue + "%' or b.Origin_mnemonic_code like '%" + searchValue + "%') ");
}
//是否有货筛选
if (isKc == "Y")
{
StrWhere.Append(" and c.stock_quantity>0 ");
}
//商品价格大于0筛选
StrWhere.Append(" and d.price>0.0");
///厂家首字母筛选
if (letter != "")
{
StrWhere.Append(" and left(b.Origin_mnemonic_code,1)='" + letter + "'");
}
StringBuilder order = new StringBuilder();
order.Append(" ");
//商品排序
switch (tags)
{
case "click_u": //点击量升序
order.Append(" order by a.click asc,b.goodscode asc");
break;
case "click_d": //点击量降序
order.Append(" order by a.click desc,b.goodscode desc");
break;
case "sales_u": //销量升序
order.Append(" order by a.sales asc,b.goodscode asc");
break;
case "sales_d": //销量降序
order.Append(" order by a.sales desc,b.goodscode desc");
break;
case "price_u": //价格升序
order.Append(" order by d.price asc,b.goodscode asc");
break;
case "price_d": //价格降序
order.Append(" order by d.price desc,b.goodscode desc");
break;
case "cxbs": //促销排序
order.Append(" order by fabh desc,b.goodscode asc");
break;
case "cjpx": //厂家排序
order.Append(" order by drug_factory asc");
break;
case "sppx": //商品排序
order.Append(" order by sub_title asc");
break;
default:
order.Append(" order by b.goodscode asc");
break;
}
//////统计客户搜索类容
if (searchValue != "")
{
bool flag = StatisticalDal.GoodsStatistical("GoodsSearch", searchValue, entid);
}
///获取商品列表
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@Type", "GetList"),
new SqlParameter("@UserId", userId),
new SqlParameter("@Entid", entid),
new SqlParameter("@PageSize", pageSize),
new SqlParameter("@PageIndex", pageIndex),
new SqlParameter("@StrWhere", StrWhere.ToString()),
new SqlParameter("@Order", order.ToString()),
new SqlParameter("@CategoryId", CategoryId),
new SqlParameter("@Login_Id", ywyId),
new SqlParameter("@Jgjb", jgjb),
new SqlParameter("@khlb", KhType)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataSet ds = sql.RunProDataSet("Proc_GoodsList", param);
mode.Success = "001";
if (ds.Tables.Count > 0)
{
DataTable dt = new DataTable();
if (ds.Tables.Count >= 3)
{
dt = ds.Tables[1];
}
else
{
dt = ds.Tables[0];
}
if (dt.Rows.Count > 0)
{
mode.Data = SetGoodsList(dt);
mode.Success = "000";
mode.Message = "商品加载成功";
}
}
return(mode);
}
catch (Exception ex)
{
mode.Success = "002";
mode.Message = "商品信息加载失败," + ex.Message.ToString();
return(mode);
}
}