/// <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; }