/// <summary>
/// 添加类别Root
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public static FrontProductCategoryInfo InsertFrontProductCategoryRoot(FrontProductCategoryInfo info)
{
DataCommand cmd = DataCommandManager.GetDataCommand("InsertFrontProductCategoryRoot");
cmd.SetParameterValue("@CategoryName", info.CategoryName);
cmd.SetParameterValue("@IsLeaf", info.IsLeaf);
cmd.SetParameterValue("@Priority", info.Priority);
cmd.SetParameterValue("@Status", info.Status);
cmd.SetParameterValue("@FPCLinkUrlMode", info.FPCLinkUrlMode);
cmd.SetParameterValue("@FPCLinkUrl", info.FPCLinkUrl);
cmd.SetParameterValue("@UIModeType", info.UIModeType);
cmd.SetParameterValue("@SellerSysNo", info.SellerSysNo);
cmd.SetParameterValue("@InUserSysNo", info.InUserSysNo);
cmd.SetParameterValue("@InUserName", info.InUserName);
int count = cmd.ExecuteNonQuery();
if (count > 0)
{
info.CategoryCode = cmd.GetParameterValue("@CategoryCode").ToString();
info.SysNo = int.Parse(cmd.GetParameterValue("@SysNo").ToString());
}
return(info);
}
private void GetMaxUpdateTime(out string max1, out string max2)
{
DataCommand dc = DataCommandManager.GetDataCommand("GetMaxUpdateTime");
dc.SetParameterValue("TimeStamp1", timeStampPara1);
dc.SetParameterValue("TimeStamp2", timeStampPara2);
dc.ExecuteNonQuery();
max1 = dc.GetParameterValue("UpdateTime1").ToString();
max2 = dc.GetParameterValue("UpdateTime2").ToString();
}
/// <summary>
/// 创建商品基础信息
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public static ProductMaintainBasicInfo CreateProductBasicInfo(ProductMaintainBasicInfo entity)
{
entity.MerchantSysNo = entity.SellerSysNo.Value;
DataCommand cmd = DataCommandManager.GetDataCommand("CreateProductBasicInfo");
cmd.SetParameterValue <ProductMaintainBasicInfo>(entity);
cmd.ExecuteNonQuery();
entity.ProductGroupSysNo = (int)cmd.GetParameterValue("@ProductGroupSysNo");
entity.ProductSysNo = (int)cmd.GetParameterValue("@ProductSysNo");
return(entity);
}
public static CategoryEntity AddCategory1(CategoryEntity entity)
{
DataCommand dc = DataCommandManager.GetDataCommand("InsertAddCategory1");
dc.SetParameterValue("@CategoryName", entity.Category1);
dc.ExecuteNonQuery();
entity.ParentCategorySysNo = 0;
entity.ParentSysNo = 0;
entity.ParentCategorySysNo = Convert.ToInt32(dc.GetParameterValue("@SysNo"));
entity.ParentSysNo = Convert.ToInt32(dc.GetParameterValue("@EC_CategoryRelationSysNo"));
return(entity);
}
public static void GetCustomerContributeInfo(int customerSysNo, string companyCode, out int guideCount, out int reviewCount, out int consultReplyCount)
{
DataCommand command = DataCommandManager.GetDataCommand("GetCustomerContributeInfo");
command.SetParameterValue("@CustomerSysno", customerSysNo);
command.SetParameterValue("@CompanyCode", companyCode);
command.ExecuteNonQuery();
guideCount = Convert.ToInt32(command.GetParameterValue("@GuideCount"));
reviewCount = Convert.ToInt32(command.GetParameterValue("@ReviewCount"));
consultReplyCount = Convert.ToInt32(command.GetParameterValue("@ConsultReplyCount"));
}
public int CreateSysNo()
{
DataCommand insertCommand = DataCommandManager.GetDataCommand("CreateRegisterSysNo");
insertCommand.ExecuteNonQuery();
return((int)insertCommand.GetParameterValue("@SysNo"));
}
/// <summary>
/// 获取所有需要审核的类别信息
/// </summary>
/// <param name="query"></param>
/// <param name="TotalCount"></param>
/// <returns></returns>
public DataTable GetCategoryRequestApprovalList(CategoryRequestApprovalQueryFilter query, out int TotalCount)
{
DataCommand dc = null;
switch (query.Category)
{
case CategoryType.CategoryType1:
dc = DataCommandManager.GetDataCommand("GetCategoryRequest1List");
break;
case CategoryType.CategoryType2:
dc = DataCommandManager.GetDataCommand("GetCategoryRequest2List");
break;
case CategoryType.CategoryType3:
dc = DataCommandManager.GetDataCommand("GetCategoryRequest3List");
break;
default:
dc = DataCommandManager.GetDataCommand("GetCategoryRequest1List");
break;
}
dc.SetParameterValue("@PageCurrent", query.PagingInfo.PageIndex);
dc.SetParameterValue("@PageSize", query.PagingInfo.PageSize);
dc.SetParameterValue("@CreateUserSysNo", 0);
dc.SetParameterValue("@SortField", query.PagingInfo.SortBy);
DataTable dt = new DataTable();
dt = dc.ExecuteDataTable();
TotalCount = (int)dc.GetParameterValue("@TotalCount");
return(dt);
}
/// <summary>
/// 添加投诉信息
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public SOComplaintInfo InsertComplainMaster(SOComplaintInfo info)
{
DataCommand command = DataCommandManager.GetDataCommand("CreateComplainMaster");
command.SetParameterValue("@CompanyCode", info.ComplaintCotentInfo.CompanyCode);
command.SetParameterValue("@SOSysNo", info.ComplaintCotentInfo.SOSysNo);
command.SetParameterValue("@ComplainType", info.ComplaintCotentInfo.ComplainType);
command.SetParameterValue("@ComplainSourceType", info.ComplaintCotentInfo.ComplainSourceType);
command.SetParameterValue("@Subject", info.ComplaintCotentInfo.Subject);
command.SetParameterValue("@ComplainContent", info.ComplaintCotentInfo.ComplainContent);
command.SetParameterValue("@CustomerEmail", info.ComplaintCotentInfo.CustomerEmail);
command.SetParameterValue("@CustomerPhone", info.ComplaintCotentInfo.CustomerPhone);
command.SetParameterValue("@ReplyContent", info.ProcessInfo.ReplyContent);
command.SetParameterValue("@CreateCustomerSysNo", info.ComplaintCotentInfo.CustomerSysNo);
command.SetParameterValue("@CreateDate", info.ComplaintCotentInfo.ComplainTime);
command.SetParameterValue("@Status", info.ProcessInfo.Status);
command.SetParameterValue("@ReplySourceType", info.ProcessInfo.ReplyType);
command.SetParameterValue("@ResponsibleDept", info.ProcessInfo.ResponsibleDepartment);
command.SetParameterValue("@ComplainNote", info.ProcessInfo.ComplainNote);
command.SetParameterValue("@AssignerSysNo", info.ProcessInfo.AssignerSysNo);
command.SetParameterValue("@AssignDate", info.ProcessInfo.AssignDate);
command.SetParameterValue("@OperatorSysNo", info.ProcessInfo.OperatorSysNo);
command.SetParameterValue("@CSConfirmComplainType", info.ProcessInfo.CSConfirmComplainType);
command.SetParameterValue("@CSConfirmComplainTypeDetail", info.ProcessInfo.CSConfirmComplainTypeDetail);
command.SetParameterValue("@ResponsibleUser", info.ProcessInfo.ResponsibleUser);
command.ExecuteNonQuery();
info.SysNo = Convert.ToInt32(command.GetParameterValue("@SysNo"));
return(info);
}
/// <summary>
/// 查询属性
/// </summary>
/// <param name="queryCriteria"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public DataTable QueryPropertyList(PropertyQueryFilter queryCriteria, out int totalCount)
{
DataCommand dc = DataCommandManager.GetDataCommand("QueryPropertyList");
if (string.IsNullOrEmpty(queryCriteria.PropertyName))
{
dc.SetParameterValue("@PropertyDescription", "");
}
else
{
dc.SetParameterValue("@PropertyDescription", "%" + queryCriteria.PropertyName.Trim() + "%");
}
dc.SetParameterValue("@IsActive", queryCriteria.Status == null ? -999 : (int)queryCriteria.Status);
dc.SetParameterValue("@CompanyCode", "8601");
dc.SetParameterValue("@SortField", queryCriteria.PagingInfo.SortBy);
dc.SetParameterValue("@PageSize", queryCriteria.PagingInfo.PageSize);
dc.SetParameterValue("@PageCurrent", queryCriteria.PagingInfo.PageIndex);
var source = dc.ExecuteDataTable();
totalCount = (int)dc.GetParameterValue("@TotalCount");
return(source);
}
/// <summary>
/// 查询商品
/// </summary>
/// <param name="filter"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public DataTable QueryProductEx(NeweggProductQueryFilter filter, out int totalCount)
{
DataCommand command = DataCommandManager.GetDataCommand("QueryProductEx");
filter.CompanyCode = "8601";
filter.CurrentUserSysNo = ServiceContext.Current.UserSysNo;
CreateQueryProductCommand(filter, command);
var sort = filter.PagingInfo.SortBy;
var sortField = "";
var sortType = "";
if (!String.IsNullOrEmpty(sort))
{
var input = Regex.Replace(filter.PagingInfo.SortBy.Trim(), "\\s+", " ");
var pageArry = input.Split(' ');
if (pageArry.Length == 2)
{
sortField = pageArry[0];
sortType = pageArry[1];
}
}
command.SetParameterValue("@SortField", sortField);
command.SetParameterValue("@SortType", sortType);
command.SetParameterValue("@PageSize", filter.PagingInfo.PageSize);
command.SetParameterValue("@PageCurrent", filter.PagingInfo.PageIndex);
var columnConfig = new EnumColumnList
{
{ "Status", typeof(ProductStatus) }
};
var table = command.ExecuteDataTable(columnConfig);
totalCount = Convert.ToInt32(command.GetParameterValue("@TotalCount"));
return(table);
}
public static QueryResult <ManufacturerInfo> QueryManufacturerList(ManufacturerQueryFilter queryFilter)
{
DataCommand dc = DataCommandManager.GetDataCommand("QueryManufacturer");
if (string.IsNullOrEmpty(queryFilter.ManufacturerNameLocal))
{
dc.SetParameterValue("@ManufacturerName", "");
}
else
{
dc.SetParameterValue("@ManufacturerName", "%" + queryFilter.ManufacturerNameLocal.Trim() + "%");
}
dc.SetParameterValue("@Status", queryFilter.Status == null ? -999 : (int)queryFilter.Status);
dc.SetParameterValue("@CompanyCode", "8601");
dc.SetParameterValue("@SortField", queryFilter.SortFields);
dc.SetParameterValue("@PageSize", queryFilter.PageSize);
dc.SetParameterValue("@PageCurrent", queryFilter.PageIndex);
List <ManufacturerInfo> resultList = dc.ExecuteEntityList <ManufacturerInfo>();;
int totalCount = (int)dc.GetParameterValue("@TotalCount");
return(new QueryResult <ManufacturerInfo>()
{
PageInfo = new PageInfo()
{
PageIndex = queryFilter.PageIndex,
PageSize = queryFilter.PageSize,
TotalCount = totalCount,
SortBy = queryFilter.SortFields
},
ResultList = resultList
});
}
/// <summary>
/// 根据query得到CPSUser信息
/// </summary>
/// <param name="query"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public DataTable GetCpsUser(CpsUserQueryFilter query, out int totalCount)
{
DataCommand cmd = DataCommandManager.GetDataCommand("GetCpsUser");
cmd.SetParameterValue("@Status", query.AuditStatus);
cmd.SetParameterValue("@UserType", query.UserType);
cmd.SetParameterValue("@WebSiteType", query.WebSiteType);
cmd.SetParameterValue("@IsAvailable", query.IsActive);
cmd.SetParameterValue("@CustomerID", query.CustomerID);
cmd.SetParameterValue("@ReceivablesName", query.ReceivablesName);
cmd.SetParameterValue("@Email", query.Email);
cmd.SetParameterValue("@Phone", query.Phone);
cmd.SetParameterValue("@ImMessenger", query.ImMessenger);
cmd.SetParameterValue("@RegisterDateFrom", query.RegisterDateFrom);
cmd.SetParameterValue("@RegisterDateTo", query.RegisterDateTo);
cmd.SetParameterValue("@PageIndex", query.PageInfo.PageIndex);
cmd.SetParameterValue("@PageSize", query.PageInfo.PageSize);
cmd.SetParameterValue("@SortFiled", query.PageInfo.SortBy);
EnumColumnList enumList = new EnumColumnList
{
{ "Status", typeof(AuditStatus) },
{ "UserType", typeof(UserType) },
{ "IsAvailable", typeof(IsActive) },
{ "BankLock", typeof(IsLock) },
{ "BankAccountType", typeof(UserType) }
};
DataTable dt = new DataTable();
dt = cmd.ExecuteDataTable(enumList);
totalCount = (int)cmd.GetParameterValue("@TotalCount");
return(dt);
}
public static int?CreateMaster(Coupon info)
{
DataCommand cmd = DataCommandManager.GetDataCommand("CreateCouponsMaster");
cmd.SetParameterValue("@CouponName", info.CouponName);
cmd.SetParameterValue("@CouponDesc", info.CouponDesc);
if (info.SaleRule != null && info.SaleRule.ProductRange != null)
{
cmd.SetParameterValue("@RulesType", info.SaleRule.ProductRange.ProductRangeType);
}
else
{
cmd.SetParameterValue("@RulesType", "A");
}
cmd.SetParameterValue("@Status", info.Status);
cmd.SetParameterValue("@MerchantSysNo", info.MerchantSysNo);
cmd.SetParameterValue("@BeginDate", info.BeginDate);
cmd.SetParameterValue("@EndDate", info.EndDate);
cmd.SetParameterValue("@InUser", info.InUser);
cmd.SetParameterValue("@CompanyCode", info.CompanyCode);
cmd.ExecuteNonQuery();
info.SysNo = (int)cmd.GetParameterValue("@SysNo");
return(info.SysNo);
}
/// <summary>
/// 查询生产商
/// </summary>
/// <returns></returns>
public virtual DataTable QueryManufacturer(ManufacturerQueryFilter queryCriteria, out int totalCount)
{
DataCommand dc = DataCommandManager.GetDataCommand("QueryManufacturer");
if (string.IsNullOrEmpty(queryCriteria.ManufacturerNameLocal))
{
dc.SetParameterValue("@ManufacturerName", "");
}
else
{
dc.SetParameterValue("@ManufacturerName", "%" + queryCriteria.ManufacturerNameLocal.Trim() + "%");
}
dc.SetParameterValue("@Status", queryCriteria.Status == null ? -999 : (int)queryCriteria.Status);
dc.SetParameterValue("@CompanyCode", "8601");
dc.SetParameterValue("@SortField", queryCriteria.PagingInfo.SortBy);
dc.SetParameterValue("@PageSize", queryCriteria.PagingInfo.PageSize);
dc.SetParameterValue("@PageCurrent", queryCriteria.PagingInfo.PageIndex);
var source = dc.ExecuteDataTable(5, typeof(ManufacturerStatus));;
totalCount = (int)dc.GetParameterValue("@TotalCount");
return(source);
}
/// <summary>
/// 获取配送方式的SysNo
/// </summary>
/// <returns></returns>
public int GetShipTypeSequence()
{
DataCommand cmd = DataCommandManager.GetDataCommand("ShipType_GetShipTypeSequence");
cmd.ExecuteNonQuery();
return(Convert.ToInt32(cmd.GetParameterValue("@SysNo")));
}
public void InsertProductPriceRequest(int productSysNo, ProductPriceRequestInfo productPriceRequestInfo)
{
DataCommand cmd = DataCommandManager.GetDataCommand("InsertProductPriceRequest");
cmd.SetParameterValue("@ProductSysNo", productSysNo);
cmd.SetParameterValue("@BasicPrice", productPriceRequestInfo.BasicPrice);
cmd.SetParameterValue("@CurrentPrice", productPriceRequestInfo.CurrentPrice);
cmd.SetParameterValue("@CashRebate", productPriceRequestInfo.CashRebate);
cmd.SetParameterValue("@Point", productPriceRequestInfo.Point);
cmd.SetParameterValue("@Status", ProductPriceRequestStatus.Origin);
cmd.SetParameterValue("@Type", productPriceRequestInfo.AuditType);
cmd.SetParameterValue("@IsWholeSale", productPriceRequestInfo.ProductWholeSalePriceInfo.Any() ? 1 : 0);
for (int i = 0; i < Enum.GetValues(typeof(WholeSaleLevelType)).Cast <WholeSaleLevelType>().Count(); i++)
{
if (productPriceRequestInfo.ProductWholeSalePriceInfo.Count > i)
{
cmd.SetParameterValue("@Q" + (i + 1), productPriceRequestInfo.ProductWholeSalePriceInfo[i].Qty);
cmd.SetParameterValue("@P" + (i + 1), productPriceRequestInfo.ProductWholeSalePriceInfo[i].Price);
}
else
{
cmd.SetParameterValue("@Q" + (i + 1), null);
cmd.SetParameterValue("@P" + (i + 1), null);
}
}
cmd.SetParameterValue("@IsUseAlipayVipPrice", productPriceRequestInfo.IsUseAlipayVipPrice);
cmd.SetParameterValue("@AlipayVipPrice", productPriceRequestInfo.AlipayVipPrice);
cmd.SetParameterValue("@PMMemo", productPriceRequestInfo.PMMemo);
cmd.SetParameterValue("@CreateUserSysNo", productPriceRequestInfo.CreateUser.SysNo);
cmd.ExecuteNonQuery();
productPriceRequestInfo.SysNo = (int)cmd.GetParameterValue("@SysNo");
InsertRequestRankPrice(productSysNo, productPriceRequestInfo);
}
public DataTable GetRmaPolicyLog(RmaPolicyLogQueryFilter filter, out int totalCount)
{
DataCommand cmd = DataCommandManager.GetDataCommand("GetRmaPolicyLog");
cmd.SetParameterValue("@RmaPolicySysNo", filter.RmaPolicySysNO);
cmd.SetParameterValue("@RmaPolicy", filter.RmaPolicy);
cmd.SetParameterValue("@UpdateDateTo", filter.UpdateDateTo);
cmd.SetParameterValue("@UpdateDateFrom", filter.UpdateDateFrom);
cmd.SetParameterValue("@EditUserName", filter.EidtUserName);
cmd.SetParameterValue("@pageIndex", filter.PagingInfo.PageIndex);
cmd.SetParameterValue("@pageSize", filter.PagingInfo.PageSize);
cmd.SetParameterValue("@sortField", filter.PagingInfo.SortBy);
EnumColumnList enumList = new EnumColumnList
{
{ "Status", typeof(RmaPolicyStatus) },
{ "Type", typeof(RmaPolicyType) },
{ "IsOnlineRequst", typeof(IsOnlineRequst) },
{ "OperationType", typeof(RmaLogActionType) },
};
DataTable dt = new DataTable();
dt = cmd.ExecuteDataTable(enumList);
totalCount = (int)cmd.GetParameterValue("@totalCount");
return(dt);
}
/// <summary>
/// 是否存在该审核
/// 当中文名或者英文名存在重的名称即认为存在品牌重复
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public bool IsExistsBrandRequest_New(BrandRequestInfo info)
{
string queryStr = "";
DataCommand cmd = DataCommandManager.GetDataCommand("IsExistsBrandRequest_New");
if ((!string.IsNullOrWhiteSpace(info.BrandNameLocal.Content)) && string.IsNullOrWhiteSpace(info.BrandNameGlobal))
{
queryStr = " AND BrandName_Ch=@BrandName_Ch";
}
if ((!string.IsNullOrWhiteSpace(info.BrandNameGlobal)) && string.IsNullOrWhiteSpace(info.BrandNameLocal.Content))
{
queryStr = " AND BrandName_En=@BrandName_En";
}
if ((!string.IsNullOrWhiteSpace(info.BrandNameGlobal)) && (!string.IsNullOrWhiteSpace(info.BrandNameLocal.Content)))
{
queryStr = " AND (BrandName_Ch=@BrandName_Ch or BrandName_En=@BrandName_En)";
}
if ((!string.IsNullOrWhiteSpace(info.BrandNameGlobal)) && string.IsNullOrWhiteSpace(info.BrandNameLocal.Content))
{
queryStr = " AND BrandName_Ch='' AND BrandName_En='' ";
}
cmd.SetParameterValue("@BrandName_Ch", info.BrandNameLocal.Content);
cmd.SetParameterValue("@BrandName_En", info.BrandNameGlobal);
cmd.ReplaceParameterValue("#strWhere#", queryStr);
cmd.ExecuteNonQuery();
return((int)cmd.GetParameterValue("@flag") < 0);
}
public DataTable GetProductExtByQuery(ProductExtQueryFilter query, out int totalCount)
{
DataCommand dc = DataCommandManager.GetDataCommand("GetItemExtList");
dc.SetParameterValue("@ProductID", query.ProductID);
dc.SetParameterValue("@ProductStatus", query.ProductStatus);
if (query.ProductType != null)
{
dc.SetParameterValue("@ProductType", LegacyEnumMapper.ConvertProductType(query.ProductType.Value));
}
else
{
dc.SetParameterValue("@ProductType", null);
}
dc.SetParameterValue("@Manufacturer", query.Manufacturer);
dc.SetParameterValue("@ProductPrice", query.ProductPrice);
dc.SetParameterValue("@IsPermitRefund", query.IsPermitRefund);
dc.SetParameterValue("@Category1", query.Category1);
dc.SetParameterValue("@Category2", query.Category2);
dc.SetParameterValue("@Category3", query.Category3);
dc.SetParameterValue("@SortField", query.PagingInfo.SortBy);
dc.SetParameterValue("@PageSize", query.PagingInfo.PageSize);
dc.SetParameterValue("@PageCurrent", query.PagingInfo.PageIndex);
EnumColumnList enumList = new EnumColumnList
{
{ "Status", typeof(ProductStatus) },
{ "IsPermitRefund", typeof(IsDefault) }
};
DataTable dt = new DataTable();
dt = dc.ExecuteDataTable(enumList);
totalCount = Convert.ToInt32(dc.GetParameterValue("@TotalCount"));
return(dt);
}
/// <summary>
/// 根据类别检测是否存在
/// </summary>
/// <param name="type"></param>
/// <param name="entity"></param>
/// <returns></returns>
public bool IsIsExistCategoryByType(CategoryType type, CategoryInfo entity)
{
DataCommand cmd = null;
switch (type)
{
case CategoryType.CategoryType1:
cmd = DataCommandManager.GetDataCommand("IsExistCategory1");
break;
case CategoryType.CategoryType2:
cmd = DataCommandManager.GetDataCommand("IsExistCategory2");
cmd.SetParameterValue("@ParentCategorySysNo", entity.ParentSysNumber);
break;
case CategoryType.CategoryType3:
cmd = DataCommandManager.GetDataCommand("IsExistCategory3");
cmd.SetParameterValue("@ParentCategorySysNo", entity.ParentSysNumber);
break;
default:
cmd = DataCommandManager.GetDataCommand("IsExistCategory1");
break;
}
cmd.SetParameterValue("@CategoryName", entity.CategoryName.Content);
cmd.SetParameterValue("@CategorySysNo", entity.SysNo);
cmd.SetParameterValue("@OperationType", entity.OperationType);
cmd.ExecuteNonQuery();
return((int)cmd.GetParameterValue("@Flag") < 0);
}
/// <summary>
/// 创建Category的SysNO
/// </summary>
/// <returns></returns>
public int CreateCategorySequence()
{
DataCommand cmd = DataCommandManager.GetDataCommand("CreateCategorySequence");
cmd.ExecuteNonQuery();
return((int)cmd.GetParameterValue("@SysNo"));
}
/// <summary>
/// 查询PM
/// </summary>
/// <param name="queryCriteria"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public DataTable QueryProductManagerInfo(ProductManagerQueryFilter queryCriteria, out int totalCount)
{
DataCommand dc = DataCommandManager.GetDataCommand("QueryProductManagerInfo");
if (string.IsNullOrEmpty(queryCriteria.UserName))
{
dc.SetParameterValue("@PMUserName", "");
}
else
{
dc.SetParameterValue("@PMUserName", "%" + queryCriteria.UserName.Trim() + "%");
}
dc.SetParameterValue("@PMID", string.IsNullOrEmpty(queryCriteria.UserID) ? "" : queryCriteria.UserID);
dc.SetParameterValue("@Status", queryCriteria.Status == null ? -999 : (int)queryCriteria.Status);
dc.SetParameterValue("@CompanyCode", "8601");
dc.SetParameterValue("@SortField", queryCriteria.PagingInfo.SortBy);
dc.SetParameterValue("@PageSize", queryCriteria.PagingInfo.PageSize);
dc.SetParameterValue("@PageCurrent", queryCriteria.PagingInfo.PageIndex);
var source = dc.ExecuteDataTable();
totalCount = Convert.ToInt32(dc.GetParameterValue("@TotalCount"));
return(source);
}
public bool IsExistsProductByProductId(string productId)
{
DataCommand cmd = DataCommandManager.GetDataCommand("IsExistsProductByProductId");
cmd.SetParameterValue("@productId", productId);
cmd.ExecuteNonQuery();
return((int)cmd.GetParameterValue("@Flag") > 0);
}
/// <summary>
/// 添加权限
/// </summary>
/// <param name="entity">权限信息</param>
/// <returns></returns>
public static int InsertFunctions(Functions entity)
{
DataCommand cmd = DataCommandManager.GetDataCommand("InsertFunctions");
cmd.SetParameterValue <Functions>(entity);
cmd.ExecuteNonQuery();
return(Convert.ToInt32(cmd.GetParameterValue("@SysNo")));
}
/// <summary>
/// 新建
/// </summary>
/// <param name="item"></param>
public int InsertGiftCardFabricationMaster(GiftCardFabricationMaster item)
{
DataCommand cmd = DataCommandManager.GetDataCommand("GiftCard_InsertGiftCardFabricationMaster");
cmd.SetParameterValue <GiftCardFabricationMaster>(item);
cmd.ExecuteNonQuery();
return((int)cmd.GetParameterValue("@SysNo"));
}
/// <summary>
/// 检查是否已存在标准类型（Type='p'）并且状态为有效(status='A')
/// </summary>
/// <returns></returns>
public bool IsExistsRmaPolicy(int sysNo = 0)
{
DataCommand cmd = DataCommandManager.GetDataCommand("IsExistsRmaPolicy");
cmd.SetParameterValue("@SysNO", sysNo);
cmd.ExecuteNonQuery();
return((int)cmd.GetParameterValue("@flag") < 0);
}
/// <summary>
/// 创建投票，作为聚合根，只创建活动的基本信息，得到活动ID
/// </summary>
/// <param name="item"></param>
public int CreatePollMaster(PollMaster item)
{
DataCommand dc = DataCommandManager.GetDataCommand("Poll_CreatePollMaster");
dc.SetParameterValue <PollMaster>(item);
dc.ExecuteNonQuery();
return(Convert.ToInt32(dc.GetParameterValue("@SysNo")));
}
/// <summary>
/// 添加奖品发放记录
/// </summary>
/// <param name="entity">奖品发放记录信息</param>
/// <returns></returns>
public static int InsertGiftsGrantRecord(GiftsGrantRecord entity)
{
DataCommand cmd = DataCommandManager.GetDataCommand("InsertGiftsGrantRecord");
cmd.SetParameterValue <GiftsGrantRecord>(entity);
cmd.ExecuteNonQuery();
return(Convert.ToInt32(cmd.GetParameterValue("@SysNo")));
}
public virtual void CreateBasicInfo(BizEntity.Customer.CustomerBasicInfo entity)
{
DataCommand cmd = DataCommandManager.GetDataCommand("CreateCustomerBasicInfo");
cmd.SetParameterValue <CustomerBasicInfo>(entity);
cmd.ExecuteNonQuery();
entity.CustomerSysNo = Convert.ToInt32(cmd.GetParameterValue("@CustomerSysNo"));
}
public bool IsExistsCategory(int?CategorySysNo)
{
DataCommand cmd = DataCommandManager.GetDataCommand("IsExistsCategory");
cmd.SetParameterValue("@CategorySysNo", CategorySysNo);
cmd.ExecuteNonQuery();
return((int)cmd.GetParameterValue("@Flag") > 0);
}
public HistoryImport GetResultImportList(HistoryQuery import, int action)
{
var result = new HistoryImport { HistoryItem = new List<ResultImport>(), PageInfo = new PageInfo() };
var cmd = new DataCommand("SearchImportData", new SqlCustomDbCommand());
var whereStr = new StringBuilder();
if (import.DeviceId == null || import.DeviceId==0)
{
if (!string.IsNullOrEmpty(import.ObjectId.ToString()))
{
whereStr.Append(string.Format(" and import.ObjectID={0}", import.ObjectId));
}
}
else
{
whereStr.Append(string.Format(" and import.ObjectID={0}", import.DeviceId));
}
if (!string.IsNullOrEmpty(import.Starttime.ToString()))
{
whereStr.Append(string.Format(" and import.Starttime>='{0}'", import.Starttime));
}
if (!string.IsNullOrEmpty(import.Endtime.ToString()))
{
whereStr.Append(string.Format(" and import.Starttime<='{0}'", import.Endtime));
}
if (!string.IsNullOrEmpty(import.ItemCode))
{
whereStr.Append(string.Format(" and import.ItemCode='{0}'", import.ItemCode));
}
if (!string.IsNullOrEmpty(import.DateUnit.ToString(CultureInfo.InvariantCulture)))
{
whereStr.Append(string.Format(" and import.MonthType={0}", import.DateUnit));
}
cmd.SetParameterValue("@action", action);
cmd.ReplaceParameterValue("#whereStr#", whereStr.ToString());
cmd.ReplaceParameterValue("#pagesize#",import.PaddingInfo.PageSize.ToString(CultureInfo.InvariantCulture));
cmd.ReplaceParameterValue("#pagenums#", ((import.PaddingInfo.Page - 1) * import.PaddingInfo.PageSize).ToString(CultureInfo.InvariantCulture));
result.HistoryItem = cmd.ExecuteEntityList<ResultImport>();
foreach (var item in result.HistoryItem)
{
item.ObjectName = GetObjectName(item.IsArea, item.ObjectId);
}
result.PageInfo.Total = (int)cmd.GetParameterValue("@Count");
return result;
}
