/// <summary>
/// 查看轮播图每一帧的数据情况，再进行其他操作
/// </summary>
public IEnumerable <SWfsOperationPicture> GetSWfsOperationPictureSwitchCondition(string pageNo, string pagePositionNo, int pictureIndex = -1)
{
var dic = new Dictionary <string, object>();
dic.Add("PageNo", pageNo);
dic.Add("PagePositionNo", pagePositionNo);
dic.Add("PictureIndex", pictureIndex);
return(DapperUtil.Query <SWfsOperationPicture>("ComBeziWfs_SWfsOperationPicture_GetSWfsOperationPictureByPageNoPositionNoPiceureIndex", dic, new { PageNo = pageNo, PagePositionNo = pagePositionNo, PictureIndex = pictureIndex }));
}
/// <summary>
/// 验证同级下是否存在重复标签, 用于页面修改标签时验证重复名称
/// </summary>
/// <param name="parentNo">父级编号</param>
/// <param name="LabelName">标签名称</param>
/// <param name="LabelId">标签自动编号</param>
/// <returns></returns>
public int IsExistSameLabel(string parentNo, string LabelName, int LabelId)
{
return(DapperUtil.Query <int>("ComBeziWfs_SWfsLabel_IsExistsProductLabelEx", new
{
ParentNo = parentNo,
LabelName = LabelName,
LabelId = LabelId
}).FirstOrDefault());
}
/// <summary>
/// 获取楼层广告图分页
/// </summary>
/// <param name="dic"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="count"></param>
/// <returns></returns>
public IEnumerable <SWfsOperationPicture> GetSWfsindexModuleRefPic(Dictionary <string, object> dic, int pageIndex, int pageSize, out int count)
{
IEnumerable <SWfsOperationPicture> query = DapperUtil.Query <SWfsOperationPicture>("ComBeziWfs_SWfsOperationPicture_GetSWfsOperationPicturePage", dic, dic["object"]);
//查询总条数
int totalCount = DapperUtil.Query <int>("ComBeziWfs_SWfsOperationPicture_GetSWfsOperationPictureCount", dic, dic["object"]).First <int>();
count = totalCount;
return(query ?? new List <SWfsOperationPicture>());
}
/// <summary>
/// 删除商品信息
/// </summary>
/// <param name="idstr"></param>
/// <returns></returns>
public void DelShoesNewProduct(string idstr)
{
foreach (string id in idstr.Split(','))
{
DynamicParameters dp = new DynamicParameters();
dp.Add("NewArrivalProductListId", id, System.Data.DbType.Int32, System.Data.ParameterDirection.Input);
DapperUtil.Execute("ComBeziWfs_SWfsIndexNewArrivalProductList_DelShoesNewProduct", dp);
}
}
//保存区块关联
public bool SaveRegionRelationInfo(SWfsBrandFlagShipStoreRegion obj)
{
if (obj.RegionID <= 0 || obj.BrandNO == null || obj.RelationType <= 0 || string.IsNullOrEmpty(obj.TemplateNo))
{
return(false);
}
if (obj.ImgNO == null)
{
obj.ImgNO = "";
}
if (obj.RelationContent == null)
{
obj.RelationContent = "";
}
obj.CreateDate = DateTime.Now;
//查询关联数据描述
switch (obj.RelationType)
{
case 1: //查询名称活动
if (!string.IsNullOrEmpty(obj.RelationContent))
{
SWfsNewSubject subobj = GetNewSubjectByNO(obj.RelationContent);
obj.Direction = subobj == null ? "" : subobj.SubjectName;
}
break;
case 2:
obj.Direction = "";
break;
case 3:
if (!string.IsNullOrEmpty(obj.RelationContent))
{
SWfsBrandNavigation navobj = GetBrandNavigationNO(obj.RelationContent);
obj.Direction = navobj == null ? "" : navobj.NavigationName;
}
break;
case 4:
obj.Direction = "";
break;
}
if (obj.FlagReigionID == 0)
{
//判断是否已近存在该区块的数据
if (GetRegionRelationInfoByCondition(obj.BrandNO, obj.TemplateNo, obj.RegionID).Count() > 0)
{
return(false);
}
return(DapperUtil.Insert <SWfsBrandFlagShipStoreRegion>(obj, true) > 0 ? true : false);
}
else
{
return(DapperUtil.Update <SWfsBrandFlagShipStoreRegion>(obj));
}
}
public JsonResult ExportVCodeList(string activityId, string vCode, string userName, string useCodeStatus, string vCodeType, string dateCreate, string endDate)
{
var dic = new Dictionary <string, object>();
#region 搜索条件
dic.Add("VCode", vCode);
ViewBag.KeyWord = vCode;
dic.Add("OperatorId", userName);
ViewBag.Prompt = userName;
dic.Add("UseCodeStatus", useCodeStatus != "-1" ? useCodeStatus : "");
dic.Add("VCodeType", vCodeType.Equals("0") ? "" : vCodeType);
dic.Add("DateCreate", dateCreate);
ViewBag.CreateDate = dateCreate;
dic.Add("EndDate", endDate);
ViewBag.EndCreateDate = endDate;
#endregion
//var CodeReflist = DapperUtil.Query<SWfsVActivityCodesRef>("ComBeziWfs_SWfsVActivityCodesRef_List",dic, new { ActivityId = activityId });
var ByVCodeList = DapperUtil.Query <VCodeInfo>("ComBeziWfs_SwfsVActivityCodesRef_VCodeList", dic,
new
{
VCode = dic["VCode"].ToString(),
OperatorId = dic["OperatorId"].ToString(),
UseCodeStatus = dic["UseCodeStatus"].ToString(),
VCodeType = dic["VCodeType"].ToString(),
DateCreate = dic["DateCreate"].ToString(),
EndDate = dic["EndDate"].ToString(),
ActivityId = activityId
});
DataTable dt = new DataTable();
string[] titles = "微码,用户名,邮箱,绑定状态,类型,生成时间,绑定时间".Split(',');
string[] titleCode = "VCode,UserName,MailAddress,UseCodeStatus,VCodeType,DateCreate,BindTime".Split(',');
dt.Columns.Clear();
foreach (string titleName in titles)
{
dt.Columns.Add(titleName, typeof(string));
}
foreach (VCodeInfo datarow in ByVCodeList)
{
dt.Rows.Add(datarow.VCode, datarow.OperatorId, datarow.MailAddress, datarow.UseCodeStatus == 0 ? "未绑定" : datarow.UseCodeStatus == 1 ? "已绑定" : "作废",
datarow.VCodeType == 1 ? "独享" : "共享", datarow.DateCreate, datarow.BindTime.ToString() == "0001/1/1 0:00:00" ? "" : datarow.BindTime.ToString());
}
string ExcleSavePath = AppSettingManager.AppSettings["ExcleSavePath"].ToString();
string ExcelFileWeb = AppSettingManager.AppSettings["ExcelFileWeb"].ToString();
string name = "V码列表" + DateTime.Now.ToString("yyyyMMddhhmmss") + ".xls";
string path = ExcleSavePath + "/" + name;
CreateExecl(dt, path);
return(Json(new { result = "1", Url = ExcelFileWeb + "/" + name }, JsonRequestBehavior.AllowGet));
}
public List <string> GetHomeAlterPic()
{
List <string> list = new List <string>();
string AlterOne = DapperUtil.Query <string>("ComBeziWfs_SWfsAppAlterPic_GetSWfsAppHomeAlterPic1").FirstOrDefault();
string AlterTwo = DapperUtil.Query <string>("ComBeziWfs_SWfsAppAlterPic_GetSWfsAppHomeAlterPic2").FirstOrDefault();
list.Add(AlterOne);
list.Add(AlterTwo);
return(list);
}
/// <summary>
/// 删除COS分类下的所有规则
/// </summary>
/// <param name="OCSCategoryNo"></param>
/// <returns></returns>
public int DelSortRuleByCategoryNo(string OCSCategoryNo)
{
int result = 0;
result = DapperUtil.Execute("ComBeziWfs_SWfsSortRule_DeleteSortRuleByCategoryNo", new
{
OcsCategoryNO = OCSCategoryNo
});
return(result);
}
public bool MobileAdModify(string id, string status, string updateUserId, DateTime updateDate)
{
return(DapperUtil.UpdatePartialColumns <SWfsMobileAd>(new
{
ID = id,
UpdateUserId = updateUserId,
UpdateDate = updateDate,
Status = status
}));
}
/// <summary>
/// 获取指定OCS分类编号、产品编号的记录数目
/// </summary>
/// <param name="ocsCategoryNo"></param>
/// <param name="productNo"></param>
/// <returns></returns>
public int GetSortProductCount(string ocsCategoryNo, string productNo)
{
IEnumerable <SWfsSortProduct> list = DapperUtil.Query <SWfsSortProduct>("ComBeziWfs_SWfsSortProduct_IsRepeatCategoryNo", new
{
OcsCategoryNo = ocsCategoryNo,
ProductNo = productNo
});
return(list.Count());
}
private void button4_Click(object sender, EventArgs e)
{
var conn = System.Configuration.ConfigurationManager.ConnectionStrings["MSSQL"].ConnectionString;
var sql = "select * from monitoring_rx_3301_201911";
//var table = DapperExReader.GetTable(DataBaseType.MSSQL, conn, sql);
//var table = DapperExReader.GetTable("MSSQL", sql);
var instance = DapperUtil.GetScalar <string>(DataBaseType.MSSQL, conn, "select top 1 HIN_FACILITY_IDENT,* from monitoring_rx_3301_201911");
Console.WriteLine(instance);
}
public IList <SWfsOperationPicture> GetIndexOperationPicture(string pageNo, string pagePositionNo)
{
var dic = new Dictionary <string, object>();
dic.Add("PageNo", pageNo);
dic.Add("PagePositionNo", pagePositionNo);
var resultList = DapperUtil.Query <SWfsOperationPicture>("ComBeziWfs_SWfsOperationPicture_GetSWfsOperationPictureByPageNo", dic, new { PageNo = pageNo, PagePositionNo = pagePositionNo }).ToList();
return(resultList);
}
/// <summary>
/// 删除导航信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int delNavigaInfoById(string id)
{
int result = 0;
result = DapperUtil.Execute("ComBeziWfs_SWfsNavigationManage_DeleteNavigationSortById", new
{
NavigationId = id
});
return(result);
}
/// <summary>
/// 获取楼层连接
/// </summary>
/// <param name="moduleId"></param>
/// <returns></returns>
public List <SWfsIndexModuleLink> GetSWfsIndexModuleLinkByModuleId(int moduleId)
{
if (moduleId <= 0)
{
return(new List <SWfsIndexModuleLink>());
}
List <SWfsIndexModuleLink> links = DapperUtil.Query <SWfsIndexModuleLink>("ComBeziWfs_SWfsIndexModuleLink_GetSWfsIndexModuleLinkByModuleId", new { ModuleId = moduleId }).FilterList();
return(links ?? new List <SWfsIndexModuleLink>());
}
/// <summary>
/// 判断添加的上新是否有重复时间的
/// </summary>
/// <param name="startdate">上新时间</param>
/// <returns></returns>
public int SelectNewArrivalDate(DateTime startdate, int newArrivalId, string pageNo, string pagePositionNo)
{
DynamicParameters dp = new DynamicParameters();
dp.Add("StartDate", startdate, System.Data.DbType.DateTime, System.Data.ParameterDirection.Input);
dp.Add("NewArrivalId", newArrivalId, System.Data.DbType.Int32, System.Data.ParameterDirection.Input);
dp.Add("PageNo", pageNo, System.Data.DbType.AnsiString, System.Data.ParameterDirection.Input);
dp.Add("PagePositionNo", pagePositionNo, System.Data.DbType.AnsiString, System.Data.ParameterDirection.Input);
return(DapperUtil.Query <int>("ComBeziWfs_SWfsIndexNewArrival_SelectNewDate", dp).FirstOrDefault());
}
/// <summary>
/// 查询热门品牌是否存在(批量) by lijibo
/// </summary>
/// <param name="brandNo"></param>
/// <param name="brandView"></param>
/// <param name="batch"></param>
/// <returns></returns>
public int GetIsExistBrandNoByBrandNoAndBrandView(string brandNo, int typeId, string batch)
{
string[] brandNoS = brandNo.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
return(DapperUtil.Query <int>("ComBeziWfs_SWfsBrandIndex_IsExistBrandNos", new
{
TypeId = typeId,
BrandNo = brandNoS
}).FirstOrDefault());
}
/// <summary>
/// 添加首页推荐品牌
/// </summary>
/// <param name="channelNo">A01或者A02区分男女</param>
/// <param name="brandNo">品牌编号</param>
/// <returns></returns>
public int AddHomeBrand(string channelNo, string brandNo)
{
return(DapperUtil.Insert <SWfsSpHomeRecommendBrand>(new SWfsSpHomeRecommendBrand
{
PageNo = channelNo,
BrandNO = brandNo,
SortId = 999,
CreateDate = DateTime.Now
}, true));
}
/// <summary>
/// 创建品牌索引
/// </summary>
/// <param name="brandIndex"></param>
/// <returns></returns>
public int SaveBrandIndex(SWfsBrandIndex brandIndex)
{
if (brandIndex != null && brandIndex.IndexId == 0)
{
return(DapperUtil.Insert <SWfsBrandIndex>(brandIndex));
}
else
{
return(DapperUtil.Update <SWfsBrandIndex>(brandIndex) ? 1 : -1);
}
}
//获取模板的内容
public IEnumerable <SWfsProductTemplate> GetTemplateContentByTemplateNoList(string templateNoList)
{
if (string.IsNullOrEmpty(templateNoList))
{
return(new List <SWfsProductTemplate>());
}
return(DapperUtil.Query <SWfsProductTemplate>("ComBeziWfs_SWfsProductTemplate_GetTemplateHtmlByTemplateNoList", new
{
TemplateNOList = templateNoList.Split(',').Distinct().ToArray()
}));
}
/// <summary>
/// 查询一、二、三、四级分类。2014年10月1日 14:24:56 by liu
/// </summary>
public IList <ErpCategory> SelectErpCategoryByParentNo(string parentNo)
{
//IList<WfsErpCategory> categorylist = DapperUtil.Query<WfsErpCategory>("ComBeziWfs_WfsErpCategory_ReadFirstClassCategory", new { ParentNo = parentNo }).ToList();
IList <ErpCategory> categorylist = DapperUtil.Query <ErpCategory>("ComBeziWfs_WfsErpCategory_ReadCategoryByParentNO", new { ParentNo = parentNo }).ToList();
if (categorylist == null)
{
return(new List <ErpCategory>());
}
return(categorylist);
}
//添加所选商品
public bool AddAboutProduct(int flagNo, string pIdList, int order)
{
if (order == 1)
{
return(DapperUtil.UpdatePartialColumns <SWfsBrandFlagShipStoreSave>(new { FlagShipStoreId = flagNo, ProductNos1 = pIdList }));
}
else
{
return(DapperUtil.UpdatePartialColumns <SWfsBrandFlagShipStoreSave>(new { FlagShipStoreId = flagNo, ProductNos2 = pIdList }));
}
}
/// <summary>
/// 根据NewArrivalId删除数据
/// </summary>
/// <param name="NewArrivalId"></param>
/// <returns></returns>
public int DeleteNewShelfListNewArrivalId(string NewArrivalId)
{
StringBuilder str = new StringBuilder();
str.Append("delete from SwfsFlagShipNewArrivalProductList where NewArrivalId=" + NewArrivalId + ";");
str.Append("delete from SwfsFlagShipNewArrival where NewArrivalId=" + NewArrivalId + ";");
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("sqlstring", str);
return(DapperUtil.Query <int>("ComBeziWfs_SwfsFlagShipNewArrivalProductList_InsertsProduct", dic).FirstOrDefault());
}
//查询出最大的排序值
public int MaxSortProduct(string NewArrivalId, string IsOneRow)
{
try
{
return(DapperUtil.Query <int>("ComBeziWfs_SwfsFlagShipNewArrivalProductList_MaxSort", new { NewArrivalId = NewArrivalId, IsOneRow = IsOneRow }).FirstOrDefault());
}
catch (Exception e)
{
return(0);
}
}
//删除所选择的商品
public int DeleteProduct(string idStr)
{
idStr = idStr.TrimEnd(',');
StringBuilder str = new StringBuilder();
str.Append("delete from SwfsFlagShipNewArrivalProductList where ProductListId in(" + idStr + ");");
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("sqlstring", str);
return(DapperUtil.Query <int>("ComBeziWfs_SwfsFlagShipNewArrivalProductList_InsertsProduct", dic).FirstOrDefault());
}
//商品管理列表
public List <ProductInfoNew> SelectNewArrivalId(string newArrivalId, string isOneRow)
{
List <ProductInfoNew> list = new List <ProductInfoNew>();
list = DapperUtil.Query <ProductInfoNew>("ComBeziWfs_SwfsFlagShipNewArrivalProductList_SelectNewArrivalId", new { IsOneRow = isOneRow, NewArrivalId = newArrivalId, pageIndex = 1, pageSize = 30 }).ToList();
for (int i = 0; i < list.Count(); i++)//循环去取商品价格的信息
{
list[i] = SelectSpfSkuPrice(list[i], list[i].ProductNo);
}
return(list);
}
//获取商品信息
public Product GetProductInfoByProductNo(string productNo)
{
Product obj = DapperUtil.Query <Product>("ComBeziWfs_WfsProduct_GetProductInfoByProductNo", new
{
ProductNo = productNo
}).FirstOrDefault();
if (obj != null && !string.IsNullOrEmpty(obj.CategoryNo))
{
string categoryNoList = string.Empty;
//查询所在分类
switch (obj.CategoryNo.Length)
{
case 3:
categoryNoList = obj.CategoryNo;
break;
case 6:
categoryNoList = obj.CategoryNo.Substring(0, 3) + "," + obj.CategoryNo;
break;
case 9:
categoryNoList = obj.CategoryNo.Substring(0, 3) + "," + obj.CategoryNo.Substring(0, 6) + "," + obj.CategoryNo;
break;
case 12:
categoryNoList = obj.CategoryNo.Substring(0, 3) + "," + obj.CategoryNo.Substring(0, 6) + "," + obj.CategoryNo.Substring(0, 9) + "," + obj.CategoryNo;
break;
}
IEnumerable <ErpCategory> categoryList = DapperUtil.Query <ErpCategory>("ComBeziWfs_SWfsCategory_GetProductCategoryAllByCategoryNoList", new
{
CategoryNoList = categoryNoList.Split(',')
});
switch (categoryList.Count())
{
case 1:
obj.CategoryNo = categoryList.ElementAt(0).CategoryName;
break;
case 2:
obj.CategoryNo = categoryList.Single(p => p.CategoryNo.Length == 3).CategoryName + ">" + categoryList.Single(p => p.CategoryNo.Length == 6).CategoryName;
break;
case 3:
obj.CategoryNo = categoryList.Single(p => p.CategoryNo.Length == 3).CategoryName + ">" + categoryList.Single(p => p.CategoryNo.Length == 6).CategoryName + ">" + categoryList.Single(p => p.CategoryNo.Length == 9).CategoryName;
break;
case 4:
obj.CategoryNo = categoryList.Single(p => p.CategoryNo.Length == 3).CategoryName + ">" + categoryList.Single(p => p.CategoryNo.Length == 6).CategoryName + ">" + categoryList.Single(p => p.CategoryNo.Length == 9).CategoryName + ">" + categoryList.Single(p => p.CategoryNo.Length == 12).CategoryName;
break;
}
}
return(obj);
}
/// <summary>
/// 获取评论数据 没有 则只返回一条
/// </summary>
/// <param name="skuNo"></param>
/// <returns></returns>
public List <ProductCommentEntity> GetProductDetailOrCommentDetailBySku(string skuNo)
{
List <ProductCommentEntity> list = new List <ProductCommentEntity>();
if (!string.IsNullOrEmpty(skuNo))
{
Dictionary <string, object> dic = new Dictionary <string, object>();
list = DapperUtil.Query <ProductCommentEntity>("ComBeziWfs_SWfsProductComment_GetProductDetailOrCommentDetailBySku", dic, new { skuNo = skuNo }).ToList();
}
return(list);
}
public IList <SWfsPictureManager> GetList(string name, string position, string begindate, string enddate, string gender, int siteNo, int pagePosition)
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("PictureName", string.IsNullOrEmpty(name) ? "" : name);
dic.Add("Position", string.IsNullOrEmpty(position) ? "" : position);
dic.Add("BCreate", string.IsNullOrEmpty(begindate) ? "" : begindate);
dic.Add("ECreate", string.IsNullOrEmpty(enddate) ? "" : enddate);
dic.Add("Gender", string.IsNullOrEmpty(gender) ? "" : gender);
return(DapperUtil.Query <SWfsPictureManager>("ComBeziWfs_SWfsPictureManager_GetSWfsPictureManagerList", dic, new { PictureName = name, Position = position, DateBegin = begindate, DateEnd = enddate, Gender = gender, WebSite = siteNo, PagePosition = pagePosition }).ToList());
}
public IEnumerable <SWfsQuestAnswer> GetSWfsSWfsQuestAnswerList(string productKeywords, string questKeywords, string answerKeywords, int pageIndex, int pageSize, out int total)
{
var dic = new Dictionary <string, object>();
dic.Add("ProductKeywords", productKeywords == null ? "" : productKeywords);
dic.Add("QuestKeywords", questKeywords == null ? "" : questKeywords);
dic.Add("AnswerKeywords", answerKeywords == null ? "" : answerKeywords);
total = 0;
total = DapperUtil.Query <int>("ComBeziWfs_SWfsProductQuestAnswer_SelectSWfsProductQuestAnswerCount", dic, new { ProductKeywords = productKeywords, QuestKeywords = questKeywords, AnswerKeywords = answerKeywords }).FirstOrDefault();
return(DapperUtil.Query <SWfsQuestAnswer>("ComBeziWfs_SWfsProductQuestAnswer_SelectSWfsProductQuestAnswerList", dic, new { ProductKeywords = productKeywords, QuestKeywords = questKeywords, AnswerKeywords = answerKeywords, pageIndex = pageIndex, pageSize = pageSize }));
}
public int AddSWfsSearchPriceInterval(SWfsSearchPriceInterval sWfsSearchPriceInterval)
{
return(DapperUtil.Execute("ComBeziWfs_SWfsSearchPriceInterval_Add", new
{
@CategoryNo = sWfsSearchPriceInterval.CategoryNo,
@MinPrice = sWfsSearchPriceInterval.MinPrice,
@MaxPrice = sWfsSearchPriceInterval.MaxPrice,
@Status = 0,
@OperatorUserId = sWfsSearchPriceInterval.OperatorUserId
}));
}
