static void AddSalesInfo()
{
GoodsInfoDal GoodsInfoDal = new GoodsInfoDal();
ProfitsInfo salesInfo = new ProfitsInfo();
//salesInfo.GoodsId = 2;
//salesInfo.Count = 3;
//salesInfo.DisCount = 50;
//salesInfo.GoodsInfo = GoodsInfoDal.GetEntityById(salesInfo.GoodsId);
//salesInfo.Prices = salesInfo.GoodsInfo.PayPrice * (decimal)salesInfo.Count - salesInfo.DisCount;
//salesInfo.CreateTime = DateTime.Now;
//salesInfo.IsPay = true;
ProfitsInfoDal salesInfoDal = new ProfitsInfoDal();
bool d = salesInfoDal.Add(salesInfo);
if (d)
{
Console.WriteLine("成功");
}
else
{
Console.WriteLine("失败");
}
}
public JsonResult SearchGoodsList(string userId, string entId, string searchValue, string letter, string tags, string isKc, string CategoryId, string Login_Id, int pageIndex, int pageSize)
{
try
{
if (string.IsNullOrEmpty(entId))
{
entId = BaseConfiguration.EntId;
}
///获取商品分类列表
///
////获取当前商品分类
List <Category> clist = new List <Category>();
if (CategoryId != "")
{
ImgInfoDal idal = new ImgInfoDal();
clist = idal.GetCategory(CategoryId, entId);
}
///商品信息
GoodsInfoDal dal = new GoodsInfoDal();
List <GoodsList> list = dal.GetGoodsList(userId, Server.UrlDecode(searchValue.Trim()), letter, tags, isKc, CategoryId, Login_Id, pageIndex, pageSize, entId);
///商品分类信息
return(Json(new { success = true, list, clist }));
}
catch (Exception ex)
{
LogQueue.Write(LogType.Error, "Search/SearchGoodsList", ex.Message.ToString());
return(Json(new { success = false, message = "商品列表加载失败！" }));
}
}
static void EditGoodsInfo()
{
GoodsInfo goodsInfo = new GoodsInfo();
goodsInfo.UnitId = 1;
goodsInfo.SortId = 1;
goodsInfo.WholeSalerId = 1;
goodsInfo.GoodsName = "品";
goodsInfo.PurPrice = (decimal)455.343;
goodsInfo.PayPrice = (decimal)455.343;
goodsInfo.Total = 500;
goodsInfo.SalesCount = 0;
goodsInfo.SurplusCount = 500;
goodsInfo.GoodsType = " gfg ";
goodsInfo.CreateTime = DateTime.Now;
goodsInfo.LastTime = DateTime.Now + new TimeSpan(50, 5, 5, 1);
goodsInfo.Id = 2;
GoodsInfoDal GoodsInfoDal = new GoodsInfoDal();
bool d = GoodsInfoDal.Edit(goodsInfo);
if (d)
{
Console.WriteLine("成功");
}
else
{
Console.WriteLine("失败");
}
}
public JsonResult GoodsDetails(string entId, string userId, string articleId)
{
try
{
if (string.IsNullOrEmpty(entId))
{
entId = BaseConfiguration.EntId;
}
if (string.IsNullOrEmpty(articleId))
{
return(Json(new { success = false, message = "参数获取失败！" }));
}
///商品信息
GoodsInfoDal dal = new GoodsInfoDal();
///商品当月销量排行
List <GoodsStatistical> slist = dal.GetGoodsRanking(userId, entId, "GoodsSale", 10);
///商品当月点击量量排行
List <GoodsStatistical> clist = dal.GetGoodsRanking(userId, entId, "GoodsClick", 3);
///商品详情
List <GoodsList> list = dal.GetGoodDetail(userId, articleId, entId);
return(Json(new { success = true, list, slist, clist }));
}
catch (Exception ex)
{
LogQueue.Write(LogType.Error, "Goods/GoodsDetails", ex.Message.ToString());
return(Json(new { success = false, message = "商品详情加载失败！" }));
}
}
/// <summary>
/// 更多回复
/// </summary>
/// <param name="userId"></param>
/// <param name="entId"></param>
/// <param name="criticismsId"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public JsonResult MoreRepaly(string userId, string entId, int criticismsId, int pageIndex = 1, int pageSize = 30)
{
try
{
if (string.IsNullOrEmpty(entId))
{
entId = BaseConfiguration.EntId;
}
if (criticismsId == 0)
{
return(Json(new { success = false, message = "参数获取异常！" }));
}
else if (string.IsNullOrEmpty(userId))
{
return(Json(new { success = false, message = "请先登录！" }));
}
///商品信息
GoodsInfoDal dal = new GoodsInfoDal();
///商品评价回复
List <StairCriticisms> list = dal.GetReplay(userId, entId, criticismsId, pageIndex, pageSize, out int pageCount, out int recordCount);
return(Json(new { success = true, list, pageCount, recordCount }));
}
catch (Exception ex)
{
LogQueue.Write(LogType.Error, "Goods/MoreRepaly", ex.Message.ToString());
return(Json(new { success = false, message = "商品评价回复获取失败！" }));
}
}
public JsonResult LikeCriticism(string userId, string entId, int criticismsId)
{
try
{
if (string.IsNullOrEmpty(entId))
{
entId = BaseConfiguration.EntId;
}
if (criticismsId == 0)
{
return(Json(new { success = false, message = "参数获取异常！" }));
}
else if (string.IsNullOrEmpty(userId))
{
return(Json(new { success = false, message = "请先登录！" }));
}
///商品信息
GoodsInfoDal dal = new GoodsInfoDal();
int flag = dal.LikeCriticism(userId, entId, criticismsId, out string message);
return(Json(new { success = flag == 1 ? true : false, message }));
}
catch (Exception ex)
{
LogQueue.Write(LogType.Error, "Goods/RedactCriticism", ex.Message.ToString());
return(Json(new { success = false, message = "商品评价点赞失败！" }));
}
}
public JsonResult RedactCriticism(string userId, string entId, string orderNo, int id, string articleId, string content, decimal starLevel, int superiorId = 0, int replayId = 0)
{
try
{
if (string.IsNullOrEmpty(entId))
{
entId = BaseConfiguration.EntId;
}
if (string.IsNullOrEmpty(articleId) && string.IsNullOrEmpty(orderNo))
{
return(Json(new { success = false, message = "商品和订单编号不能为空" }));
}
else if (string.IsNullOrEmpty(userId))
{
return(Json(new { success = false, message = "请先登录！" }));
}
///商品信息
GoodsInfoDal dal = new GoodsInfoDal();
int flag = dal.RedactCriticism(userId, entId, orderNo, id, articleId, content, starLevel, superiorId, replayId, out string message);
return(Json(new { success = flag == 1 ? true : false, message }));
}
catch (Exception ex)
{
LogQueue.Write(LogType.Error, "Goods/RedactCriticism", ex.Message.ToString());
return(Json(new { success = false, message = "商品评价编辑失败！" }));
}
}
public JsonResult GoodsCriticisms(string userId, string entId, string articleId, string orderBy = "desc", int pageIndex = 1, int pageSize = 30)
{
try
{
if (string.IsNullOrEmpty(entId))
{
entId = BaseConfiguration.EntId;
}
if (string.IsNullOrEmpty(articleId))
{
return(Json(new { success = false, message = "参数获取失败！" }));
}
else if (string.IsNullOrEmpty(userId))
{
return(Json(new { success = false, message = "请先登录！" }));
}
///商品信息
GoodsInfoDal dal = new GoodsInfoDal();
///商品评价
List <StairCriticisms> list = dal.GetCriticisms(userId, entId, articleId, pageIndex, pageSize, orderBy, out int pageCount, out int recordCount, out int passSum, out decimal raveReviews);
return(Json(new { success = true, list, pageCount, recordCount, passSum, raveReviews }));
}
catch (Exception ex)
{
LogQueue.Write(LogType.Error, "Goods/GoodsEvaluate", ex.Message.ToString());
return(Json(new { success = false, message = "商品评价失败！" }));
}
}
public ActionResult SearchFastGoods(string entid, string userId, string searchValue)
{
try
{
if (string.IsNullOrEmpty(entid) || string.IsNullOrEmpty(userId))
{
return(Json(new { flag = 0, message = "请先登录！" }));
}
//获取用户信息
UserInfoDal dal = new UserInfoDal();
List <UserInfo> user = new List <UserInfo>();
if (!string.IsNullOrEmpty(userId))
{
user = dal.GetUserInfo(userId, entid);
}
string jgjb = "", clientlimit = "", KhType = "";
bool landing = false;
bool staleDated = false;
if (user.Count > 0)
{
entid = user[0].EntId;
jgjb = user[0].Pricelevel;
clientlimit = user[0].ClientLimit;
KhType = user[0].KhType;
staleDated = user[0].StaleDated;
landing = true;
}
GoodsInfoDal infoDal = new GoodsInfoDal();
if (searchValue.Trim().Contains(" "))
{
int length = searchValue.Length;
int index = searchValue.IndexOf(" ");
string goodsValue, factoryValue;
goodsValue = searchValue.Substring(0, index).Trim();
factoryValue = searchValue.Substring(index, length - index).ToString().Trim();
searchValue = goodsValue + ',' + factoryValue;
}
List <GoodsList> lists = new List <GoodsList>();
lists = infoDal.SearchFastGoods(entid, searchValue, jgjb, KhType, landing, staleDated);
if (lists == null)
{
return(Json(new { flag = 2, message = "无符合商品！" }));
}
else
{
return(Json(new { flag = 2, message = "商品查询成功！", lists }));
}
}
catch (Exception ex)
{
LogQueue.Write(LogType.Error, "Search/SearchFastGoods", ex.Message.ToString());
return(Json(new { flag = 99, message = "商品获取失败！" }));
}
}
static void DeleteGoodsInfo()
{
int id = 1;
GoodsInfoDal sortInfoDal = new GoodsInfoDal();
var d = sortInfoDal.Delete(id);
if (d)
{
Console.WriteLine("成功");
}
else
{
Console.WriteLine("失败");
}
}
public JsonResult OftenBuy(string userId, string entId, string searchValue, int pageIndex = 1, int pageSize = 15)
{
try
{
if (string.IsNullOrEmpty(entId) || string.IsNullOrEmpty(userId))
{
return(Json(new { success = false, message = "请先登录" }));
}
//获取用户信息
UserInfoDal dal = new UserInfoDal();
List <UserInfo> user = new List <UserInfo>();
if (!string.IsNullOrEmpty(userId))
{
user = dal.GetUserInfo(userId, entId);
}
string jgjb = "", clientlimit = "", KhType = "";
bool landing = false;
bool staleDated = false;
if (user.Count > 0)
{
entId = user[0].EntId;
jgjb = user[0].Pricelevel;
clientlimit = user[0].ClientLimit;
KhType = user[0].KhType;
staleDated = user[0].StaleDated;
landing = true;
}
GoodsInfoDal infoDal = new GoodsInfoDal();
if (searchValue.Trim().Contains(" "))
{
int length = searchValue.Length;
int index = searchValue.IndexOf(" ");
string goodsValue, factoryValue;
goodsValue = searchValue.Substring(0, index).Trim();
factoryValue = searchValue.Substring(index, length - index).ToString().Trim();
searchValue = goodsValue + ',' + factoryValue;
}
List <GoodsList> lists = new List <GoodsList>();
lists = infoDal.OftenBuy(userId, entId, searchValue, jgjb, KhType, landing, staleDated, pageIndex, pageSize, out int pageCount, out int recordCount);
return(Json(new { success = true, message = "常购商品获取成功", lists, pageCount, recordCount }));
}
catch (Exception ex)
{
LogQueue.Write(LogType.Error, "Search/OftenBuy", $"{ex.Message}");
return(Json(new { success = false, message = "常购商品获取失败！" }));
}
}
/// <summary>
/// 请求求购信息
/// </summary>
/// <param name="userId">用户</param>
/// <param name="entId">机构</param>
/// <param name="pageIndex">页码</param>
/// <param name="pageSize">容量</param>
/// <returns></returns>
public ActionResult QueryReply(string userId, string entId, int pageIndex, int pageSize)
{
try
{
GoodsInfoDal goodsInfoDal = new GoodsInfoDal();
RequrementList requrementList = new RequrementList();
requrementList = goodsInfoDal.QueryReply(userId, entId, pageIndex, pageSize);
return(Json(new { success = true, message = "求购信息获取成功", requrementList }));
}
catch (Exception ex)
{
string msg = ex.Message.ToString().Trim();
LogQueue.Write(LogType.Error, "GoodsInfoDal/QueryReply", msg);
return(Json(new { success = false, message = msg }));
}
}
/// <summary>
/// 同类商品推荐
/// </summary>
/// <param name="entId">企业</param>
/// <param name="userId">用户</param>
/// <param name="articleId">商品ID</param>
/// <param name="num">条目数</param>
/// <returns></returns>
public ActionResult Commendation(string entId, string userId, string articleId, int num)
{
try
{
if (string.IsNullOrEmpty(entId))
{
entId = BaseConfiguration.EntId;
}
if (string.IsNullOrEmpty(articleId))
{
return(Json(new { success = false, message = "参数异常" }));
}
///获取用户信息
UserInfoDal dal = new UserInfoDal();
List <UserInfo> user = new List <UserInfo>();
if (!string.IsNullOrEmpty(userId))
{
user = dal.GetUserInfo(userId, entId);
}
string jgjb = "", clientlimit = "", KhType = "";
bool landing = false;
bool staleDated = false;
//获取客户价格级别
if (user.Count > 0)
{
entId = user[0].EntId;
jgjb = user[0].Pricelevel;
clientlimit = user[0].ClientLimit;
KhType = user[0].KhType;
staleDated = user[0].StaleDated;
landing = true;
}
GoodsInfoDal infoDal = new GoodsInfoDal();
///商品详情
List <GoodsList> list = infoDal.GetGoodDetail(userId, articleId, entId);
var category = list[0].GoodsInfo[0].Category;
//同类商品推荐
List <Models.GoodsInfo> klist = infoDal.Commendation(entId, category, num, jgjb, KhType, landing, staleDated);
return(Json(new { success = true, message = "商品推荐获取成功", klist }));
}
catch (Exception ex)
{
LogQueue.Write(LogType.Error, "Goods/Commendation", ex.Message.ToString());
return(Json(new { success = false, message = "商品推荐加载失败！" }));
}
}
public JsonResult SearchIndex(string entid, string parameter)
{
try
{
if (string.IsNullOrEmpty(entid))
{
entid = BaseConfiguration.EntId;
}
GoodsInfoDal infoDal = new GoodsInfoDal();
List <SearchIndex> indices = new List <SearchIndex>();
indices = infoDal.SearchIndex(entid, parameter);
return(Json(new { success = true, list = indices }));
}
catch (Exception ex)
{
LogQueue.Write(LogType.Error, "Search/SearchIndex", ex.Message.ToString());
return(Json(new { success = false, message = "搜索栏索引获取失败！" }));
}
}
public JsonResult GetActivity(string userId, string entId, string articleId, string fabh = "")
{
try
{
if (string.IsNullOrEmpty(userId) || string.IsNullOrEmpty(entId))
{
return(Json(new { success = false, message = "用户未登录，请先登录" }));
}
GoodsInfoDal dal = new GoodsInfoDal();
List <Promotion> list = new List <Promotion>();
list = dal.GetActivity(userId, entId, articleId, fabh);
return(Json(new { success = true, message = list }));
}
catch (Exception ex)
{
LogQueue.Write(LogType.Error, "Search/GetActivity", ex.Message.ToString());
return(Json(new { success = false, message = "商品活动信息获取失败！" }));
}
}
static void EditSalesInfo()
{
GoodsInfoDal GoodsInfoDal = new GoodsInfoDal();
ProfitsInfoDal salesInfoDal = new ProfitsInfoDal();
ProfitsInfo salesInfo = salesInfoDal.GetEntityById(2);
salesInfo.Remark = "测试修改";
salesInfo.IsPay = false;
var d = salesInfoDal.Edit(salesInfo);//仅能修改 备注和是否支付
if (d)
{
Console.WriteLine("成功");
}
else
{
Console.WriteLine("失败");
}
}
public ActionResult GetArticleRecommend(string entId, string userId, int count, int type)
{
if (string.IsNullOrEmpty(entId))
{
entId = BaseConfiguration.EntId;
}
///获取用户信息
UserInfoDal dal = new UserInfoDal();
List <UserInfo> user = new List <UserInfo>();
if (!string.IsNullOrEmpty(userId))
{
user = dal.GetUserInfo(userId, entId);
}
string jgjb = "", clientlimit = "", KhType = "";
bool staleDated = false;
//获取客户价格级别
if (user.Count > 0)
{
entId = user[0].EntId;
jgjb = user[0].Pricelevel;
clientlimit = user[0].ClientLimit;
KhType = user[0].KhType;
staleDated = user[0].StaleDated;
}
GoodsInfoDal goodsInfoDal = new GoodsInfoDal();
DataTable dt = goodsInfoDal.GetGetArticleRecommend(entId, jgjb, KhType, count, type);
JsonSerializerSettings setting = new JsonSerializerSettings()
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
};
var data = JsonConvert.SerializeObject(dt, setting);
return(Json(data));
}
/// <summary>
/// 发起求购专区
/// </summary>
/// <param name="userId">用户</param>
/// <param name="entId">机构</param>
/// <param name="buyName">求购人</param>
/// <param name="buyTel">求购人联系方式</param>
/// <param name="buyGoods">求购药品名称</param>
/// <param name="productName">求购药品厂家</param>
/// <param name="buySpec">求购药品规格</param>
/// <param name="buyNumber">求购药品数量</param>
/// <param name="buyPrice">求购药品价格</param>
/// <param name="message">求购备注</param>
/// <returns></returns>
public ActionResult InsertReply(string userId, string entId, string buyName, string buyTel, string buyGoods, string productName, string buySpec, decimal buyNumber, decimal buyPrice, string message)
{
try
{
GoodsInfoDal goodsInfoDal = new GoodsInfoDal();
if (string.IsNullOrEmpty(buyName) || string.IsNullOrEmpty(buyGoods) || string.IsNullOrEmpty(userId) || string.IsNullOrEmpty(entId) || string.IsNullOrEmpty(productName) || string.IsNullOrEmpty(buyTel) || string.IsNullOrEmpty(buySpec))
{
LogQueue.Write(LogType.Debug, "", $"求购人:{buyName},求购人联系方式:{buyTel},求购药品名称:{buyGoods},用户:{userId},机构:{entId},求购药品厂家:{productName},求购药品规格:{buySpec}");
return(Json(new { success = false, message = "参数异常" }));
}
else
{
bool flag = goodsInfoDal.InsertReply(buyName, buyTel, buyGoods, productName, buySpec, buyNumber, buyPrice, userId, entId, message, out string msg);
return(Json(new { success = flag, message = msg }));
}
}
catch (Exception ex)
{
string msg = ex.Message.ToString().Trim();
LogQueue.Write(LogType.Error, "GoodsInfoDal/InsertReply", msg);
return(Json(new { success = false, message = msg }));
}
}
/// <summary>
/// 专区商品
/// </summary>
/// <param name="entId">机构Id</param>
/// <param name="userId">会员Id</param>
/// <param name="zqType">专区类型</param>
/// <param name="pageIndex">页码</param>
/// <param name="pageSize">页容</param>
/// <returns></returns>
public JsonResult GetZqGoodsList(string entId, string userId, string zqType, int pageIndex, int pageSize)
{
try
{
if (string.IsNullOrEmpty(entId))
{
entId = BaseConfiguration.EntId;
}
if (string.IsNullOrEmpty(zqType))
{
return(Json(new { success = false, msgCode = "E002", message = "专区类型获取失败" }));
}
///获取商品分类列表
GoodsInfoDal dal = new GoodsInfoDal();
List <GoodsList> list = dal.GetGoodsList(userId, "", "", "cxbs", "", "", "", pageIndex, pageSize, entId, zqType);
///商品分类信息
return(Json(new { success = true, list }));
}
catch (Exception ex)
{
LogQueue.Write(LogType.Error, "Search/SearchGoodsList", ex.Message.ToString());
return(Json(new { success = false, message = "商品列表加载失败！" }));
}
}
