public ConsignToAcctLogInfo CreateConsignToAccountLog(ConsignToAcctLogInfo logInfo) { DataCommand command = DataCommandManager.GetDataCommand("CreateConsignToAccountLog"); command.SetParameterValue("@SysNo", logInfo.LogSysNo); command.SetParameterValue("@ProductSysNo", logInfo.ProductSysNo); command.SetParameterValue("@VendorSysNo", logInfo.VendorSysNo); command.SetParameterValue("@StockSysNo", logInfo.StockSysNo); command.SetParameterValue("@Quantity", logInfo.ProductQuantity); command.SetParameterValue("@CreateCost", logInfo.CreateCost); command.SetParameterValue("@SettleCost", logInfo.SettleCost); command.SetParameterValue("@ConsignToAccType", (int)logInfo.ConsignToAccType); command.SetParameterValue("@Note", logInfo.Note); object getCode = ""; EnumCodeMapper.TryGetCode(logInfo.ConsignToAccStatus, out getCode); if (null != getCode) { command.SetParameterValue("@Status", getCode.ToString()); } command.SetParameterValue("@SettleType", logInfo.SettleType.ToString()); command.SetParameterValue("@SettlePercentage", logInfo.SettlePercentage); command.SetParameterValue("@SalePrice", logInfo.SalePrice); command.SetParameterValue("@Point", logInfo.Point); command.SetParameterValue("@OrderSysNo", logInfo.OrderSysNo); command.SetParameterValue("@CompanyCode", logInfo.CompanyCode); logInfo.LogSysNo = System.Convert.ToInt32(command.ExecuteScalar()); return(logInfo); }
private object GetDbValue(object value) { if (value == null || value == DBNull.Value) { return(DBNull.Value); } Type type = value.GetType(); if (type.IsEnum || (type.IsGenericType && type.GetGenericTypeDefinition() == typeof(Nullable <>) && type.GetGenericArguments() != null && type.GetGenericArguments().Length == 1 && type.GetGenericArguments()[0].IsEnum)) { object code; if (EnumCodeMapper.TryGetCode(value, out code)) { return(code); } else { return((int)value); } } return(value); }
private void ConvertColumnFromRow(DataRow row, EnumColumnList enumColumns, CodeNamePairColumnList codeNamePairColunms) { if (enumColumns != null && enumColumns.Count > 0) { foreach (var entry in enumColumns) { Type enumType = entry.EnumType; if (!enumType.IsEnum) { throw new ArgumentException("The type '" + enumType.AssemblyQualifiedName + "' is not enum.", "enumColumns"); } int columnIndex = entry.ColumnIndex.HasValue ? entry.ColumnIndex.Value : row.Table.Columns.IndexOf(entry.ColumnName + "_ECCentral_Auto_Removed_820319"); if (columnIndex < 0) { continue; } if (row[columnIndex] == null || row[columnIndex] == DBNull.Value) { row[entry.NewColumnIndex] = DBNull.Value; continue; } object orignalData = row[columnIndex]; object tmp; if (orignalData == null || orignalData == DBNull.Value || orignalData.ToString().Trim().Length <= 0) { row[entry.NewColumnIndex] = DBNull.Value; } else if (EnumCodeMapper.TryGetEnum(orignalData, enumType, out tmp)) { row[entry.NewColumnIndex] = tmp; } else { row[entry.NewColumnIndex] = Enum.Parse(enumType, orignalData.ToString(), true); } } } if (codeNamePairColunms != null && codeNamePairColunms.Count > 0) { foreach (var entry in codeNamePairColunms) { int columnIndex = entry.ColumnIndex.HasValue ? entry.ColumnIndex.Value : row.Table.Columns.IndexOf(entry.ColumnName + "_ECCentral_Auto_Removed_820319"); if (row[columnIndex] == null || row[columnIndex] == DBNull.Value) { row[entry.NewColumnIndex] = DBNull.Value; continue; } List <CodeNamePair> list = CodeNamePairManager.GetList(entry.DomainName, entry.Key); string code = row[columnIndex].ToString(); CodeNamePair option = list.Find(x => x.Code == code); if (option != null) { row[entry.NewColumnIndex] = option.Name; } } } }
/// <summary> /// 修改团购处理状态 /// </summary> /// <param name="sysNo"></param> /// <param name="settlementStatus"></param> public void UpdateGroupBuySettlementStatus(int sysNo, GroupBuyingSettlementStatus settlementStatus) { DataCommand command = DataCommandManager.GetDataCommand("ChangeGroupBuySettlement"); command.SetParameterValue("@SysNo", sysNo); object status = "N"; EnumCodeMapper.TryGetCode(settlementStatus, out status); command.SetParameterValue("@SettlementStatus", status); command.ExecuteNonQuery(); }
// /// <summary> /// 根据团购编号修改所有团购订单的处理状态 /// </summary> /// <param name="groupBuySysNo">团购编号</param> /// <param name="settlementStatus">处理状态</param> public void UpdateGroupBuySOSettlementStatusByGroupBuySysNo(int groupBuySysNo, SettlementStatus settlementStatus) { DataCommand command = DataCommandManager.GetDataCommand("SO_Update_GroupBuySettlementStatusByGroupBuySysNo"); command.SetParameterValue("@ReferenceSysNo", groupBuySysNo); object status = null; EnumCodeMapper.TryGetCode(settlementStatus, out status); command.SetParameterValue("@SettlementStatus", status); command.ExecuteNonQuery(); }
public void Start() { EnumCodeMapper.AddMap <BusinessDataType>(new Dictionary <BusinessDataType, Int32> { { BusinessDataType.SO, 0 }, { BusinessDataType.RMA, 1 }, { BusinessDataType.CustomerMaster, 2 } }); EnumCodeMapper.AddMap <ChangeType>(new Dictionary <ChangeType, string> { { ChangeType.Add, "A" }, { ChangeType.Update, "U" }, { ChangeType.Delete, "D" } }); }
public void Start() { EnumCodeMapper.AddMap <AmbassadorStatus>(new Dictionary <AmbassadorStatus, int> { { AmbassadorStatus.UnActive, 1 }, { AmbassadorStatus.Active, 2 }, { AmbassadorStatus.Canceled, 3 } }); EnumCodeMapper.AddMap <UserType>(new Dictionary <UserType, int> { { UserType.NeweggAmbassador, 0 }, { UserType.NeweggEmployee, 4 } }); }
public static int SaveGiftPromotionMasterInfo(SalesGiftInfo info) { if (!info.SysNo.HasValue) { DataCommand cmd = DataCommandManager.GetDataCommand("SaleGift_CreateSaleGiftMaster"); cmd.SetParameterValue("@PromotionName", info.Title); cmd.SetParameterValue("@PromotionDesc", info.Description); object typeCode = null; EnumCodeMapper.TryGetCode(info.Type.Value, out typeCode); cmd.SetParameterValue("@Type", typeCode.ToString()); cmd.SetParameterValue("@Status", SaleGiftStatus.Origin); cmd.SetParameterValue("@BeginDate", info.BeginDate.Value); cmd.SetParameterValue("@Enddate", info.EndDate.Value); cmd.SetParameterValue("@AmountLimit", !info.OrderMinAmount.HasValue ? 0 : info.OrderMinAmount.Value); cmd.SetParameterValue("@PromotionLink", info.PromotionLink); cmd.SetParameterValue("@Memo", info.Memo); cmd.SetParameterValue("@InUser", info.InUserName ?? ""); cmd.SetParameterValue("@DisCountType", SaleGiftDiscountBelongType.BelongMasterItem); cmd.SetParameterValue("@IsGlobal", info.IsGlobalProduct == true ? "Y" : "N"); cmd.SetParameterValue("@CompanyCode", info.CompanyCode); cmd.SetParameterValue("@VendorSysNo", info.SellerSysNo); cmd.ExecuteNonQuery(); info.SysNo = (int)cmd.GetParameterValue("@SysNo"); return(info.SysNo.Value); } else { DataCommand cmd = DataCommandManager.GetDataCommand("SaleGift_UpdateSaleGiftMaster"); cmd.SetParameterValue("@SysNo", info.SysNo); cmd.SetParameterValue("@PromotionName", info.Title); object typeCode = null; EnumCodeMapper.TryGetCode(info.Type.Value, out typeCode); cmd.SetParameterValue("@Type", typeCode); cmd.SetParameterValue("@PromotionDesc", info.Description); cmd.SetParameterValue("@BeginDate", info.BeginDate); cmd.SetParameterValue("@Enddate", info.EndDate.Value); cmd.SetParameterValue("@AmountLimit", !info.OrderMinAmount.HasValue ? 0 : info.OrderMinAmount.Value); cmd.SetParameterValue("@PromotionLink", info.PromotionLink); cmd.SetParameterValue("@Memo", info.Memo); cmd.SetParameterValue("@EditUser", info.EditUser); cmd.SetParameterValue("@DisCountType", SaleGiftDiscountBelongType.BelongMasterItem); cmd.SetParameterValue("@VendorSysNo", info.VendorSysNo); cmd.ExecuteNonQuery(); return(info.SysNo.Value); } }
public void Start() { EnumCodeMapper.AddMap <RMAOwnBy>(new Dictionary <RMAOwnBy, int> { { RMAOwnBy.Origin, 0 }, { RMAOwnBy.Customer, 1 }, { RMAOwnBy.Self, 2 }, }); EnumCodeMapper.AddMap <RMALocation>(new Dictionary <RMALocation, int> { { RMALocation.Origin, 0 }, { RMALocation.Self, 1 }, { RMALocation.Vendor, 2 } }); EnumCodeMapper.AddMap <SellersType>(new Dictionary <SellersType, string> { { SellersType.Self, "NEG" }, { SellersType.Seller, "MET" } }); }
public void Start() { EnumCodeMapper.AddMap <AdjustRequestStatus>(new Dictionary <AdjustRequestStatus, int> { { AdjustRequestStatus.Origin, 1 }, { AdjustRequestStatus.Verified, 2 }, { AdjustRequestStatus.OutStock, 3 }, { AdjustRequestStatus.Abandon, -1 } }); EnumCodeMapper.AddMap <ConvertRequestStatus>(new Dictionary <ConvertRequestStatus, int> { { ConvertRequestStatus.Origin, 1 }, { ConvertRequestStatus.Verified, 2 }, { ConvertRequestStatus.OutStock, 3 }, { ConvertRequestStatus.Abandon, -1 } }); EnumCodeMapper.AddMap <LendRequestStatus>(new Dictionary <LendRequestStatus, int> { { LendRequestStatus.Origin, 1 }, { LendRequestStatus.Verified, 2 }, { LendRequestStatus.OutStock, 3 }, { LendRequestStatus.Abandon, -1 }, { LendRequestStatus.ReturnPartly, 4 }, { LendRequestStatus.ReturnAll, 5 } }); EnumCodeMapper.AddMap <ShiftRequestStatus>(new Dictionary <ShiftRequestStatus, int> { { ShiftRequestStatus.Origin, 1 }, { ShiftRequestStatus.Verified, 2 }, { ShiftRequestStatus.OutStock, 3 }, { ShiftRequestStatus.Abandon, -1 }, { ShiftRequestStatus.InStock, 4 }, { ShiftRequestStatus.PartlyInStock, 5 } }); EnumCodeMapper.AddMap <ConvertProductType>(new Dictionary <ConvertProductType, int> { { ConvertProductType.Source, 1 }, { ConvertProductType.Target, 2 } }); EnumCodeMapper.AddMap <VirtualRequestActionType>(new Dictionary <VirtualRequestActionType, string> { { VirtualRequestActionType.Run, "R" }, { VirtualRequestActionType.Close, "C" } }); EnumCodeMapper.AddMap <SpecialShiftRequestType>(new Dictionary <SpecialShiftRequestType, int> { { SpecialShiftRequestType.Default, 0 }, { SpecialShiftRequestType.DelayOutStock, 1 }, { SpecialShiftRequestType.UrgencyDelayInStock, 2 }, { SpecialShiftRequestType.NormalDelayInStock, 3 }, { SpecialShiftRequestType.HandWork, 4 } }); EnumCodeMapper.AddMap <WarehouseType>(new Dictionary <WarehouseType, int> { { WarehouseType.Real, 1 }, { WarehouseType.Virtual, 2 } }); EnumCodeMapper.AddMap <WarehouseOwnerType>(new Dictionary <WarehouseOwnerType, int> { { WarehouseOwnerType.Self, 1 }, { WarehouseOwnerType.ThirdParty, 2 } }); EnumCodeMapper.AddMap <ValidStatus>(new Dictionary <ValidStatus, int> { { ValidStatus.Valid, 0 }, { ValidStatus.InValid, -1 } }); EnumCodeMapper.AddMap <CustomsCodeMode>(new Dictionary <CustomsCodeMode, string> { { CustomsCodeMode.DirectImportMode, "2244" }, { CustomsCodeMode.PudongAirportTradeMode, "2216" }, { CustomsCodeMode.YangshanTradeMode, "2249" }, { CustomsCodeMode.WaigaoqiaoTradeMode, "2218" } }); }
public System.Data.DataTable QuerySaleGift(SaleGiftQueryFilter filter, out int totalCount) { PagingInfoEntity pagingEntity = new PagingInfoEntity(); pagingEntity.SortField = filter.PageInfo.SortBy; pagingEntity.MaximumRows = filter.PageInfo.PageSize; pagingEntity.StartRowIndex = filter.PageInfo.PageIndex * filter.PageInfo.PageSize; var cmd = DataCommandManager.CreateCustomDataCommandFromConfig("SaleGift_QueryGift"); using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "SysNo DESC")) { //sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.WebChannelID", DbType.AnsiStringFixedLength, // "@WebChannelID", QueryConditionOperatorType.Equal, filter.ChannelID); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.CompanyCode", DbType.AnsiStringFixedLength, "@CompanyCode", QueryConditionOperatorType.Equal, filter.CompanyCode); sqlBuilder.ConditionConstructor.BeginGroupCondition(QueryConditionRelationType.AND); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.OR, "B.BrandSysNo", DbType.Int32, "@BrandSysNo", QueryConditionOperatorType.Equal, filter.BrandSysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.OR, "D.BrandSysNo", DbType.Int32, "@BrandSysNo", QueryConditionOperatorType.Equal, filter.BrandSysNo); sqlBuilder.ConditionConstructor.EndGroupCondition(); sqlBuilder.ConditionConstructor.BeginGroupCondition(QueryConditionRelationType.AND); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.OR, "B.C3SysNo", DbType.Int32, "@Category3SysNo", QueryConditionOperatorType.Equal, filter.Category3SysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.OR, "D.Category3SysNo", DbType.Int32, "@Category3SysNo", QueryConditionOperatorType.Equal, filter.Category3SysNo); sqlBuilder.ConditionConstructor.EndGroupCondition(); #region Jack.G.tang 2013-1-7 update Bug 95316 /*修改原因:新增Category1和Category2的查询条件 */ if (filter.Category1SysNo > 0) { sqlBuilder.ConditionConstructor.BeginGroupCondition(QueryConditionRelationType.AND); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.OR, "C3.Category1SysNo", DbType.Int32, "@Category1SysNo", QueryConditionOperatorType.Equal, filter.Category1SysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.OR, "Category3.Category1SysNo", DbType.Int32, "@Category1SysNo", QueryConditionOperatorType.Equal, filter.Category1SysNo); sqlBuilder.ConditionConstructor.EndGroupCondition(); } if (filter.Category2SysNo > 0) { sqlBuilder.ConditionConstructor.BeginGroupCondition(QueryConditionRelationType.AND); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.OR, "C3.Category2SysNo", DbType.Int32, "@Category2SysNo", QueryConditionOperatorType.Equal, filter.Category2SysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.OR, "Category3.Category2SysNo", DbType.Int32, "@Category2SysNo", QueryConditionOperatorType.Equal, filter.Category2SysNo); sqlBuilder.ConditionConstructor.EndGroupCondition(); } #endregion if (filter.MasterProductSysNo.HasValue) { ProductBasic pMaster = GetProductBasic(filter.MasterProductSysNo.Value); sqlBuilder.ConditionConstructor.BeginGroupCondition(QueryConditionRelationType.AND); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.OR, "B.ProductSysNo", DbType.Int32, "@MasterProductSysNo", QueryConditionOperatorType.Equal, filter.MasterProductSysNo); if (pMaster.C3SysNo.HasValue) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.OR, "B.C3SysNo", DbType.Int32, "@MasterC3SysNo", QueryConditionOperatorType.Equal, pMaster.C3SysNo); } if (pMaster.BrandSysNo.HasValue) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.OR, "B.BrandSysNo", DbType.Int32, "@MasterBrandSysNo", QueryConditionOperatorType.Equal, pMaster.BrandSysNo); } sqlBuilder.ConditionConstructor.EndGroupCondition(); } sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "C.ProductSysNo", DbType.Int32, "@GiftProductSysNo", QueryConditionOperatorType.Equal, filter.GiftProductSysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.InUser", DbType.String, "@PMUser", QueryConditionOperatorType.Equal, filter.PMUser); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.SysNo", DbType.Int32, "@SysNo", QueryConditionOperatorType.Equal, filter.SysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.Status", DbType.AnsiStringFixedLength, "@Status", QueryConditionOperatorType.Equal, filter.Status); if (!string.IsNullOrEmpty(filter.PromotionName)) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.PromotionName", DbType.String, "@PromotionName", QueryConditionOperatorType.Like, filter.PromotionName); } sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.Type", DbType.AnsiStringFixedLength, "@Type", QueryConditionOperatorType.Equal, filter.Type); if (filter.ActivityDateFrom.HasValue) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.BeginDate", DbType.DateTime, "@BeginDate", QueryConditionOperatorType.MoreThanOrEqual, filter.ActivityDateFrom); } if (filter.ActivityDateTo.HasValue) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.EndDate", DbType.DateTime, "@EndDate", QueryConditionOperatorType.LessThan, filter.ActivityDateTo.Value); } if (filter.VendorSysNo > 0) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "VendorSysNo", DbType.Int32, "@VendorSysNo", QueryConditionOperatorType.Equal, filter.VendorSysNo); } cmd.CommandText = sqlBuilder.BuildQuerySql(); DataSet ds = cmd.ExecuteDataSet(); DataTable dt1 = ds.Tables[0]; DataTable dt2 = ds.Tables[1]; DataTable dt3 = ds.Tables[2]; if (dt1 != null && dt1.Rows.Count > 0) { foreach (DataRow row in dt1.Rows) { object status; EnumCodeMapper.TryGetEnum(row["Status"], typeof(SaleGiftStatus), out status); row["Status"] = status; if (status != null) { row["StatusName"] = ((SaleGiftStatus)status).ToDisplayText(); } object type; EnumCodeMapper.TryGetEnum(row["Type"], typeof(SaleGiftType), out type); row["Type"] = type; if (type != null) { row["TypeName"] = ((SaleGiftType)type).ToDisplayText(); } if (((SaleGiftType)type) == SaleGiftType.Full) { row["MasterProducts"] = "商品范围"; } else { if (dt2 != null && dt2.Rows.Count > 0) { string masterProducts = ""; foreach (DataRow row2 in dt2.Rows) { if (row2["SysNo"].ToString() == row["SysNo"].ToString()) { masterProducts += row2["ProductID"].ToString() + Environment.NewLine; } } row["MasterProducts"] = masterProducts; } } if (dt3 != null && dt3.Rows.Count > 0) { string giftProducts = ""; foreach (DataRow row3 in dt3.Rows) { if (row3["SysNo"].ToString() == row["SysNo"].ToString()) { giftProducts += row3["ProductID"].ToString() + Environment.NewLine; } } row["GiftProducts"] = giftProducts; } } } totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); return(dt1); } }
public DataTable Query(AdvertisingQueryFilter filter, out int totalCount) { PagingInfoEntity pagingEntity = new PagingInfoEntity(); pagingEntity.SortField = filter.PageInfo.SortBy; pagingEntity.MaximumRows = filter.PageInfo.PageSize; pagingEntity.StartRowIndex = filter.PageInfo.PageIndex * filter.PageInfo.PageSize; var cmd = DataCommandManager.CreateCustomDataCommandFromConfig("AdvertisingQuery"); using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "product.InDate DESC")) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "category.SysNo", DbType.Int32, "@ProductLineCategorySysNo", QueryConditionOperatorType.Equal, filter.ProductLineCategorySysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "Link.ProductLineSysNo", DbType.Int32, "@ProductLineSysNo", QueryConditionOperatorType.Equal, filter.ProductLineSysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "Link.InUser", DbType.String, "@InUser", QueryConditionOperatorType.Like, filter.InUser); string sql = string.Empty; if (filter.OperateDateFrom.HasValue) { sql = string.Format(@" Link.InDate >= '{0}'", filter.OperateDateFrom); } if (filter.OperateDateTo.HasValue) { sql = string.Format(@" Link.InDate <= '{0}' or Link.EditDate <='{0}'", filter.OperateDateTo.Value.AddDays(1).AddSeconds(-1)); } if (filter.OperateDateFrom.HasValue && filter.OperateDateTo.HasValue) { sql = string.Format(@" ((Link.InDate >= '{0}' AND Link.InDate <='{1}') OR (Link.EditDate >= '{0}' AND Link.EditDate <='{1}'))", filter.OperateDateFrom, filter.OperateDateTo.Value.AddDays(1).AddSeconds(-1)); } if (!string.IsNullOrEmpty(sql)) { sqlBuilder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, sql); } sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "Link.ImageWidth", DbType.Int32, "@ImageWidth", QueryConditionOperatorType.Equal, filter.ImageWidth); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "Link.ImageHeight", DbType.Int32, "@ImageHeight", QueryConditionOperatorType.Equal, filter.ImageHeight); object _type; if (filter.Type != null && EnumCodeMapper.TryGetCode(filter.Type, out _type)) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "Link.Type", DbType.String, "@Type", QueryConditionOperatorType.Like, _type); } cmd.CommandText = sqlBuilder.BuildQuerySql(); EnumColumnList enumList = new EnumColumnList(); enumList.Add("Type", typeof(AdvertisingType)); enumList.Add("Status", typeof(ValidStatus)); var dt = cmd.ExecuteDataTable(enumList); totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); return(dt); } }
public DataSet Query(GroupBuyingLotteryQueryFilter filter, out int totalCount) { PagingInfoEntity pagingEntity = new PagingInfoEntity(); pagingEntity.SortField = filter.PagingInfo.SortBy; pagingEntity.MaximumRows = filter.PagingInfo.PageSize; pagingEntity.StartRowIndex = filter.PagingInfo.PageIndex * filter.PagingInfo.PageSize; var cmd = DataCommandManager.CreateCustomDataCommandFromConfig("GetGroupBuyingLotteryList"); using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "M.SysNo DESC")) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "M.[ProductGroupBuyingSysNo]", DbType.Int32, "@ProductGroupBuyingSysNo", QueryConditionOperatorType.Equal, filter.GroupBuyingSysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "M.LotteryDate", DbType.DateTime, "@BeginDateFrom", QueryConditionOperatorType.MoreThanOrEqual, filter.BeginDateFrom); //sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, // "M.LotteryDate", DbType.DateTime, "@BeginDateTo", // QueryConditionOperatorType.LessThan, // filter.BeginDateTo); //sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, // "M.LotteryDate", DbType.DateTime, "@EndDateFrom", // QueryConditionOperatorType.MoreThanOrEqual, // filter.EndDateFrom); if (filter.EndDateTo != null) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "M.LotteryDate", DbType.DateTime, "@EndDateTo", QueryConditionOperatorType.LessThan, filter.EndDateTo.Value.AddDays(1)); } object _rank; if (filter.RankType != null && EnumCodeMapper.TryGetCode(filter.RankType, out _rank)) { sqlBuilder.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "C.Rank", DbType.Int32, "@Rank", QueryConditionOperatorType.Equal, _rank); } sqlBuilder.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "M.CompanyCode", DbType.AnsiStringFixedLength, "@CompanyCode", QueryConditionOperatorType.Equal, filter.CompanyCode); cmd.CommandText = sqlBuilder.BuildQuerySql(); var ds = cmd.ExecuteDataSet(); cmd.ConvertEnumColumn(ds.Tables[0], new EnumColumnList { { "Rank", typeof(CustomerRank) } }); totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); return(ds); } }
/// <summary> /// 加载团购信息 /// </summary> /// <param name="sysNo"></param> /// <returns></returns> public GroupBuyingInfo Load(int sysNo) { DataCommand cmd = DataCommandManager.GetDataCommand("GetProductGroupBuyingEntity"); cmd.SetParameterValue("@SysNo", sysNo); var ds = cmd.ExecuteDataSet(); GroupBuyingInfo result = null; if (ds.Tables[0].Rows.Count > 0) { result = new GroupBuyingInfo(); //DataMapper.AutoMap<GroupBuyingInfo>(result, ds.Tables[0].Rows[0]); DataRow row = ds.Tables[0].Rows[0]; result.CompanyCode = row["CompanyCode"].ToString(); result.SysNo = Convert.ToInt32(row["SysNo"]); result.ProductSysNo = Convert.ToInt32(row["ProductSysNo"]); result.ProductID = row["ProductID"].ToString(); result.GroupBuyingTypeSysNo = Convert.ToInt32(row["GroupBuyingTypeSysNo"]); result.GroupBuyingAreaSysNo = Convert.ToInt32(row["GroupBuyingAreaSysNo"]); result.GroupBuyingVendorSysNo = row["VendorSysNo"] == DBNull.Value ? 0 : Convert.ToInt32(row["VendorSysNo"]); result.RequestSysNo = row["RequestSysNo"] == DBNull.Value ? 0 : Convert.ToInt32(row["RequestSysNo"]); result.GroupBuyingVendorName = row["VendorName"] == null ? "" : row["VendorName"].ToString(); result.GroupBuyingTitle = new LanguageContent(row["GroupBuyingTitle"].ToString()); result.GroupBuyingRules = new LanguageContent(row["GroupBuyingRules"].ToString()); result.GroupBuyingDesc = new LanguageContent(row["GroupBuyingDesc"].ToString()); result.GroupBuyingDescLong = new LanguageContent(row["GroupBuyingDescLong"].ToString()); result.GroupBuyingPicUrl = new LanguageContent(row["GroupBuyingPicUrl"].ToString()); result.Reasons = row["Reasons"] == null ? string.Empty : row["Reasons"].ToString(); result.InUser = row["InUser"] == null ? string.Empty : row["InUser"].ToString(); result.GroupBuyingMiddlePicUrl = new LanguageContent(row["GroupBuyingMiddlePicUrl"].ToString()); result.GroupBuyingSmallPicUrl = new LanguageContent(row["GroupBuyingSmallPicUrl"].ToString()); result.BeginDate = Convert.ToDateTime(row["BeginDate"]); result.EndDate = Convert.ToDateTime(row["EndDate"]); result.IsByGroup = row["IsByGroup"].Equals(1); result.LimitOrderCount = Convert.ToInt32(row["LimitOrderCount"]); result.MaxCountPerOrder = Convert.ToInt32(row["MaxPerOrder"]); result.OriginalPrice = Convert.ToDecimal(row["OriginalPrice"]); result.GBPrice = Convert.ToDecimal(row["GBPrice"]); result.CurrentSellCount = Convert.ToInt32(row["CurrentSellCount"]); result.CouponValidDate = row["CouponValidDate"] == DBNull.Value ? default(DateTime?) : Convert.ToDateTime(row["CouponValidDate"]); result.LotteryRule = row["LotteryRule"] == null ? string.Empty : row["LotteryRule"].ToString(); result.GroupBuyingCategorySysNo = (row["GroupBuyingCategorySysNo"] == null || row["GroupBuyingCategorySysNo"] == DBNull.Value)? default(int?) : Convert.ToInt32(row["GroupBuyingCategorySysNo"]); result.IsWithoutReservation = Convert.ToInt32(row["IsWithoutReservation"]) == 1; result.IsVouchers = Convert.ToInt32(row["IsVouchers"]) == 1; object categoryType; if (EnumCodeMapper.TryGetEnum(row["GroupBuyingCategoryType"], typeof(GroupBuyingCategoryType), out categoryType)) { result.CategoryType = (GroupBuyingCategoryType)categoryType; } object settlementStatus; if (EnumCodeMapper.TryGetEnum(row["SettlementStatus"], typeof(GroupBuyingStatus), out settlementStatus)) { result.SettlementStatus = (GroupBuyingSettlementStatus)settlementStatus; } object status; if (EnumCodeMapper.TryGetEnum(row["Status"], typeof(GroupBuyingStatus), out status)) { result.Status = (GroupBuyingStatus)status; } if (row["Priority"] != DBNull.Value) { result.Priority = Convert.ToInt32(row["Priority"]); } if (row["SuccessDate"] != DBNull.Value) { result.SuccessDate = Convert.ToDateTime(row["SuccessDate"]); } //result.InUser = row["InUser"].ToString(); //result.PriceRankList = DataMapper.GetEntityList<PSPriceDiscountRule, List<PSPriceDiscountRule>>(ds.Tables[1].Rows); result.PriceRankList = new List <PSPriceDiscountRule>(); foreach (DataRow item in ds.Tables[1].Rows) { if (result.GroupBuyingTypeSysNo == 6) { result.GroupBuyingPoint = Convert.ToInt32(item["GroupBuyingPoint"]); } result.PriceRankList.Add(new PSPriceDiscountRule() { MinQty = Convert.ToInt32(item["SellCount"]), DiscountValue = Convert.ToDecimal(item["GroupBuyingPrice"]), ProductSysNo = Convert.ToInt32(item["SysNo"]), }); decimal?costAmt = item["CostAmt"] != DBNull.Value ? Convert.ToDecimal(item["CostAmt"]) : default(decimal?); if (costAmt.HasValue) { result.CostAmt = costAmt; } } //团购类型 result.GroupBuyingTypeList = this.GetGroupBuyingTypes(); //地区 result.GroupBuyingAreaList = this.GetGroupBuyingAreas(); } return(result); }
public void Start() { //注册付款单审核状态 EnumCodeMapper.AddMap <PayableAuditStatus>(new Dictionary <PayableAuditStatus, string> { { PayableAuditStatus.NotAudit, "O" }, { PayableAuditStatus.WaitFNAudit, "F" }, { PayableAuditStatus.Audited, "A" } }); //注册邮局电汇收款单确认状态 EnumCodeMapper.AddMap <PostIncomeConfirmStatus>(new Dictionary <PostIncomeConfirmStatus, string> { { PostIncomeConfirmStatus.Audit, "A" }, { PostIncomeConfirmStatus.Cancel, "C" }, { PostIncomeConfirmStatus.Related, "R" } }); //注册订单跟进状态 EnumCodeMapper.AddMap <TrackingInfoStatus>(new Dictionary <TrackingInfoStatus, string> { { TrackingInfoStatus.Follow, "A" }, { TrackingInfoStatus.Submit, "S" }, { TrackingInfoStatus.Confirm, "C" } }); //注册POS支付方式 EnumCodeMapper.AddMap <POSPayType>(new Dictionary <POSPayType, string> { { POSPayType.Card, "01" }, { POSPayType.Cash, "02" }, { POSPayType.Check, "03" } }); //注册POS自动确认状态 EnumCodeMapper.AddMap <AutoConfirmStatus>(new Dictionary <AutoConfirmStatus, string> { { AutoConfirmStatus.Success, "A" }, { AutoConfirmStatus.Fault, "D" } }); //注册逾期未收款订单责任人状态 EnumCodeMapper.AddMap <ResponseUserStatus>(new Dictionary <ResponseUserStatus, string> { { ResponseUserStatus.Active, "A" }, { ResponseUserStatus.Dective, "D" } }); EnumCodeMapper.AddMap <ECCentral.BizEntity.Invoice.InvoiceType>(new Dictionary <ECCentral.BizEntity.Invoice.InvoiceType, string> { { ECCentral.BizEntity.Invoice.InvoiceType.MET, "MET" }, { ECCentral.BizEntity.Invoice.InvoiceType.SELF, "NEG" }, }); EnumCodeMapper.AddMap <ECCentral.BizEntity.Invoice.DeliveryType>(new Dictionary <ECCentral.BizEntity.Invoice.DeliveryType, string> { { ECCentral.BizEntity.Invoice.DeliveryType.MET, "MET" }, { ECCentral.BizEntity.Invoice.DeliveryType.SELF, "NEG" }, }); EnumCodeMapper.AddMap <ECCentral.BizEntity.Invoice.StockType>(new Dictionary <ECCentral.BizEntity.Invoice.StockType, string> { { ECCentral.BizEntity.Invoice.StockType.MET, "MET" }, { ECCentral.BizEntity.Invoice.StockType.SELF, "NEG" }, { ECCentral.BizEntity.Invoice.StockType.NAM, "NAM" } }); //注册付款单审核状态 EnumCodeMapper.AddMap <SapImportedStatus>(new Dictionary <SapImportedStatus, string> { { SapImportedStatus.Origin, "A" }, { SapImportedStatus.Success, "S" }, { SapImportedStatus.Fault, "E" }, { SapImportedStatus.Unfinished, "F" } }); EnumCodeMapper.AddMap <APInvoiceItemStatus>(new Dictionary <APInvoiceItemStatus, string> { { APInvoiceItemStatus.Active, "A" }, { APInvoiceItemStatus.Deactive, "D" } }); EnumCodeMapper.AddMap <SAPStatus>(new Dictionary <SAPStatus, string> { { SAPStatus.Active, "A" }, { SAPStatus.Deactive, "D" } }); //注册以旧换新状态 EnumCodeMapper.AddMap <OldChangeNewStatus>(new Dictionary <OldChangeNewStatus, string> { { OldChangeNewStatus.Abandon, "-1" }, { OldChangeNewStatus.Audited, "2" }, { OldChangeNewStatus.Close, "4" }, { OldChangeNewStatus.Origin, "0" }, { OldChangeNewStatus.Refund, "3" }, { OldChangeNewStatus.RefuseAudit, "-2" }, { OldChangeNewStatus.SubmitAudit, "1" } }); //退款结果 EnumCodeMapper.AddMap <WLTRefundStatus>(new Dictionary <WLTRefundStatus, int> { { WLTRefundStatus.Success, 1 }, { WLTRefundStatus.Failure, -1 }, { WLTRefundStatus.Processing, 3 } }); // 变价单状态 EnumCodeMapper.AddMap <RequestPriceStatus>(new Dictionary <RequestPriceStatus, int> { { RequestPriceStatus.Auditting, 0 }, { RequestPriceStatus.Audited, 1 }, { RequestPriceStatus.Running, 2 }, { RequestPriceStatus.Aborted, 3 }, { RequestPriceStatus.Finished, 4 }, { RequestPriceStatus.Void, -1 } }); // 变价单变价类型 EnumCodeMapper.AddMap <RequestPriceType>(new Dictionary <RequestPriceType, int> { { RequestPriceType.PurchasePrice, 0 }, { RequestPriceType.SalePrice, 1 } }); }
/// <summary> /// 添加配送方式-产品 /// </summary> /// <param name="ShipTypeProductInfo"></param> /// <returns></returns> public void CreateShipTypeProduct(ShipTypeProductInfo ShipTypeProductInfo) { object obj = null; DataCommand cmd = DataCommandManager.GetDataCommand("ShipTypeProduct_Master_Create"); cmd.SetParameterValue("@StockSysNo", ShipTypeProductInfo.WareHouse); cmd.SetParameterValue("@ShipTypeSysNo", ShipTypeProductInfo.ShippingType); if (!ShipTypeProductInfo.CitySysNo.HasValue && !ShipTypeProductInfo.ProvinceSysNo.HasValue) { cmd.SetParameterValue("@AreaSysNo", null); } if (!ShipTypeProductInfo.CitySysNo.HasValue && ShipTypeProductInfo.ProvinceSysNo.HasValue) { cmd.SetParameterValue("@AreaSysNo", ShipTypeProductInfo.ProvinceSysNo); } if (ShipTypeProductInfo.CitySysNo.HasValue && !ShipTypeProductInfo.DistrictSysNo.HasValue) { cmd.SetParameterValue("@AreaSysNo", ShipTypeProductInfo.CitySysNo); } if (ShipTypeProductInfo.DistrictSysNo.HasValue) { cmd.SetParameterValue("@AreaSysNo", ShipTypeProductInfo.AreaSysNo); } cmd.SetParameterValue("@InUser", ServiceContext.Current.UserSysNo); cmd.SetParameterValue("@EditUser", ServiceContext.Current.UserSysNo); cmd.SetParameterValue("@Status", "A"); cmd.SetParameterValue("@CompanyCode", ShipTypeProductInfo.CompanyCode); cmd.SetParameterValue("@StoreCompanyCode", ShipTypeProductInfo.CompanyCode); cmd.SetParameterValue("@LanguageCode", "zh-CN"); cmd.ExecuteNonQuery(); ShipTypeProductInfo.SysNo = (int)cmd.GetParameterValue("@SysNo"); CustomDataCommand cmd_item = DataCommandManager.CreateCustomDataCommandFromConfig("ShipTypeProduct_Item_Create"); StringBuilder builersql = new StringBuilder();; if (ShipTypeProductInfo.ListProductInfo == null && ShipTypeProductInfo.ListCategoryInfo == null) { return; } if (ShipTypeProductInfo.ListProductInfo != null && ShipTypeProductInfo.ListCategoryInfo == null) { for (int i = 0; i < ShipTypeProductInfo.ListProductInfo.Count; i++) { cmd_item.SetParameterValue("@MasterSysNo", ShipTypeProductInfo.SysNo); cmd_item.SetParameterValue("@CompanyCode", ShipTypeProductInfo.CompanyCode); cmd_item.SetParameterValue("@Status", "A"); cmd_item.SetParameterValue("@Description", ShipTypeProductInfo.Description); if (EnumCodeMapper.TryGetCode(ShipTypeProductInfo.ShipTypeProductType, out obj)) { cmd_item.SetParameterValue("@Type", obj); } if (EnumCodeMapper.TryGetCode(ShipTypeProductInfo.ProductRange, out obj)) { cmd_item.SetParameterValue("@ItemRange", obj); } cmd_item.SetParameterValue("@InUser", ServiceContext.Current.UserSysNo); cmd_item.SetParameterValue("@EditUser", ServiceContext.Current.UserSysNo); cmd_item.SetParameterValue("@StoreCompanyCode", ShipTypeProductInfo.CompanyCode); cmd_item.SetParameterValue("@LanguageCode", "zh-CN"); cmd_item.SetParameterValue("@CompanyCustomer", 0); builersql.Append(cmd_item.CommandText.Replace("#DynamicData#", ShipTypeProductInfo.ListProductInfo[i].SysNo.ToString() + ",'" + ShipTypeProductInfo.ListProductInfo[i].ProductID.ToString() + "'")); } cmd_item.CommandText = builersql.ToString(); cmd_item.ExecuteNonQuery(); } if (ShipTypeProductInfo.ListProductInfo == null && ShipTypeProductInfo.ListCategoryInfo != null) { for (int i = 0; i < ShipTypeProductInfo.ListCategoryInfo.Count; i++) { cmd_item.SetParameterValue("@MasterSysNo", ShipTypeProductInfo.SysNo); cmd_item.SetParameterValue("@CompanyCode", ShipTypeProductInfo.CompanyCode); cmd_item.SetParameterValue("@Status", "A"); cmd_item.SetParameterValue("@Description", ShipTypeProductInfo.Description); if (EnumCodeMapper.TryGetCode(ShipTypeProductInfo.ShipTypeProductType, out obj)) { cmd_item.SetParameterValue("@Type", obj); } if (EnumCodeMapper.TryGetCode(ShipTypeProductInfo.ProductRange, out obj)) { cmd_item.SetParameterValue("@ItemRange", obj); } cmd_item.SetParameterValue("@InUser", ServiceContext.Current.UserSysNo); cmd_item.SetParameterValue("@EditUser", ServiceContext.Current.UserSysNo); cmd_item.SetParameterValue("@StoreCompanyCode", ShipTypeProductInfo.CompanyCode); cmd_item.SetParameterValue("@LanguageCode", "zh-CN"); cmd_item.SetParameterValue("@CompanyCustomer", 0); builersql.Append(cmd_item.CommandText.Replace("#DynamicData#", ShipTypeProductInfo.ListCategoryInfo[i].SysNo + ",null")); } cmd_item.CommandText = builersql.ToString(); cmd_item.ExecuteNonQuery(); } }
public static Coupon Load(int?sysNo) { Coupon info = null; DataCommand cmd = DataCommandManager.GetDataCommand("LoadCoupon"); cmd.SetParameterValue("@SysNo", sysNo); DataSet ds = cmd.ExecuteDataSet(); if (ds != null && ds.Tables.Count > 0) { DataTable dtMaster = ds.Tables[0]; if (dtMaster.Rows.Count > 0) { info = DataMapper.GetEntity <Coupon>(dtMaster.Rows[0]); info.DiscountRules = new List <CouponDiscountRule>(); info.BindRule = new CouponBindRule(); info.SaleRule = new CouponSaleRule(); info.SaleRule.ProductRange = new ProductRelation(); info.SaleRule.ProductRange.Products = new List <RelProduct>(); info.SaleRule.CustomerRange = new CustomerRelation(); info.SaleRule.CustomerRange.Customers = new List <RelCustomer>(); info.BindRule.ProductRange = new ProductRelation(); info.BindRule.ProductRange.Products = new List <RelProduct>(); DataTable dtDiscountRules = ds.Tables[1]; if (dtDiscountRules.Rows.Count > 0) { #region Coupon_DiscountRules的数据绑定 foreach (DataRow dr in dtDiscountRules.Rows) { CouponDiscountRule rule = new CouponDiscountRule(); if (dr["RulesType"].ToString().Trim().ToUpper() == "P") { rule.RulesType = CouponDiscountRuleType.Percentage; } else if (dr["RulesType"].ToString().Trim().ToUpper() == "D") { rule.RulesType = CouponDiscountRuleType.Discount; } rule.Value = decimal.Parse(dr["Value"].ToString().Trim()); rule.Amount = decimal.Parse(dr["Amount"].ToString().Trim()); info.DiscountRules.Add(rule); } #endregion } DataTable dtBindRule = ds.Tables[2]; if (dtBindRule.Rows.Count > 0) { #region Coupon_BindRules的数据绑定 DataRow dr = dtBindRule.Rows[0]; if (!string.IsNullOrEmpty(dr["BindCondition"].ToString())) { object bindConditionType; EnumCodeMapper.TryGetEnum(dr["BindCondition"], typeof(CouponsBindConditionType), out bindConditionType); info.BindRule.BindCondition = (CouponsBindConditionType)bindConditionType; } if (!string.IsNullOrEmpty(dr["ValidPeriod"].ToString())) { object validPeriod; EnumCodeMapper.TryGetEnum(dr["ValidPeriod"], typeof(CouponValidPeriodType), out validPeriod); info.BindRule.ValidPeriod = (CouponValidPeriodType)validPeriod; } if (!string.IsNullOrEmpty(dr["BindBeginDate"].ToString())) { info.BindRule.BindBeginDate = DateTime.Parse(dr["BindBeginDate"].ToString().Trim()); } if (!string.IsNullOrEmpty(dr["BindEndDate"].ToString())) { info.BindRule.BindEndDate = DateTime.Parse(dr["BindEndDate"].ToString().Trim()); } if (!string.IsNullOrEmpty(dr["AmountLimit"].ToString())) { info.BindRule.AmountLimit = decimal.Parse(dr["AmountLimit"].ToString().Trim()); } if (!string.IsNullOrEmpty(dr["LimitType"].ToString())) { if (dr["LimitType"].ToString().Trim().ToLower() == "A".ToLower()) { info.BindRule.ProductRange.ProductRangeType = ProductRangeType.All; } else { info.BindRule.ProductRange.ProductRangeType = ProductRangeType.Limit; } } else { info.BindRule.ProductRange.ProductRangeType = ProductRangeType.All; } #endregion } DataTable dtBindRuleItems = ds.Tables[3]; if (dtBindRuleItems.Rows.Count > 0) { #region Coupon_BindRuleItems的数据绑定 foreach (DataRow dr in dtBindRuleItems.Rows) { if (dr["RuleItemType"].ToString().Trim().ToUpper() == "I") { RelProduct product = new RelProduct(); if (!string.IsNullOrEmpty(dr["ItemDataSysNo"].ToString())) { product.ProductSysNo = int.Parse(dr["ItemDataSysNo"].ToString()); } if (!string.IsNullOrEmpty(dr["ProductID"].ToString())) { product.ProductID = dr["ProductID"].ToString(); } if (!string.IsNullOrEmpty(dr["ProductName"].ToString())) { product.ProductName = dr["ProductName"].ToString(); } if (!string.IsNullOrEmpty(dr["RelationType"].ToString())) { if (dr["RelationType"].ToString().Trim() == "Y") { info.BindRule.ProductRange.RelationType = RelationType.Y; } else { info.BindRule.ProductRange.RelationType = RelationType.N; } } if (!string.IsNullOrEmpty(dr["ProductStatus"].ToString())) { ProductStatus productStatus; if (Enum.TryParse <ProductStatus>(dr["ProductStatus"].ToString(), out productStatus)) { product.ProductStatus = EnumHelper.GetDescription(productStatus); } } info.BindRule.ProductRange.Products.Add(product); } } #endregion } DataTable dtSaleRules_Ex = ds.Tables[4]; if (dtSaleRules_Ex.Rows.Count > 0) { #region Coupon_SaleRules_Ex的数据绑定 DataRow dr = dtSaleRules_Ex.Rows[0]; if (!string.IsNullOrEmpty(dr["OrderAmountLimit"].ToString())) { info.SaleRule.OrderAmountLimit = decimal.Parse(dr["OrderAmountLimit"].ToString().Trim()); if (info.SaleRule.OrderAmountLimit == 0m) { info.SaleRule.OrderAmountLimit = null; } } if (!string.IsNullOrEmpty(dr["OrderMaxDiscount"].ToString())) { info.SaleRule.OrderMaxDiscount = decimal.Parse(dr["OrderMaxDiscount"].ToString().Trim()); } if (!string.IsNullOrEmpty(dr["CustomerMaxFrequency"].ToString())) { info.SaleRule.CustomerMaxFrequency = int.Parse(dr["CustomerMaxFrequency"].ToString()); } if (!string.IsNullOrEmpty(dr["MaxFrequency"].ToString())) { info.SaleRule.MaxFrequency = int.Parse(dr["MaxFrequency"].ToString()); } #endregion } DataTable dtSaleRules = ds.Tables[5]; if (dtSaleRules.Rows.Count > 0) { if (!string.IsNullOrEmpty(dtMaster.Rows[0]["ProductRangeType"].ToString())) { object productRangeType; EnumCodeMapper.TryGetEnum(dtMaster.Rows[0]["ProductRangeType"], typeof(ProductRangeType), out productRangeType); info.SaleRule.ProductRange.ProductRangeType = (ProductRangeType)productRangeType; } #region Coupon_SaleRules的数据绑定 foreach (DataRow dr in dtSaleRules.Rows) { if (dr["Type"].ToString().Trim().ToUpper() == "I") { RelProduct product = new RelProduct(); if (!string.IsNullOrEmpty(dr["ProductSysNo"].ToString())) { product.ProductSysNo = int.Parse(dr["ProductSysNo"].ToString()); } if (!string.IsNullOrEmpty(dr["ProductID"].ToString())) { product.ProductID = dr["ProductID"].ToString(); } if (!string.IsNullOrEmpty(dr["ProductName"].ToString())) { product.ProductName = dr["ProductName"].ToString(); } if (!string.IsNullOrEmpty(dr["RelationType"].ToString())) { if (dr["RelationType"].ToString().Trim() == "Y") { info.SaleRule.ProductRange.RelationType = RelationType.Y; } else { info.SaleRule.ProductRange.RelationType = RelationType.N; } } if (!string.IsNullOrEmpty(dr["ProductStatus"].ToString())) { ProductStatus productStatus; if (Enum.TryParse <ProductStatus>(dr["ProductStatus"].ToString(), out productStatus)) { product.ProductStatus = EnumHelper.GetDescription(productStatus); } } info.SaleRule.ProductRange.Products.Add(product); } } #endregion } DataTable dtSaleRulesCustomer = ds.Tables[6]; if (dtSaleRulesCustomer.Rows.Count > 0) { #region Coupon_SaleRulesCustomer的数据绑定 foreach (DataRow dr in dtSaleRulesCustomer.Rows) { RelCustomer customer = new RelCustomer(); //cs.Customer = new SampleObject(int.Parse(dr["CustomerSysNo"].ToString())); customer.CustomerSysNo = int.Parse(dr["CustomerSysNo"].ToString()); customer.CustomerID = string.IsNullOrEmpty(dr["CustomerID"].ToString()) ? null : dr["CustomerID"].ToString().Trim(); customer.CustomerName = string.IsNullOrEmpty(dr["CustomerName"].ToString()) ? null : dr["CustomerName"].ToString().Trim(); info.SaleRule.CustomerRange.Customers.Add(customer); info.SaleRule.CustomerRange.CustomerRangeType = CouponCustomerRangeType.Limit; } #endregion } else { info.SaleRule.CustomerRange.CustomerRangeType = CouponCustomerRangeType.All; } if (info != null && info.BindRule != null && info.BindRule.BindCondition == CouponsBindConditionType.None) { List <CouponCode> codes = LoadCouponCodes(info.SysNo); if (codes != null && codes.Count > 0) { info.CouponCodes = codes; if (codes[0].CodeType == CouponCodeType.Common) { info.GeneralCode = codes[0]; } else { string BatchCode = ""; for (int i = 0; i < codes.Count; i++) { if (i == codes.Count - 1) { BatchCode += codes[i].Code; } else { BatchCode += codes[i].Code + "\n"; } } info.ThrowInCodes = BatchCode; } } } if (info != null && (info.Status == CouponStatus.Run || info.Status == CouponStatus.Finish || info.Status == CouponStatus.Stoped)) { info.CouponCodes = LoadCouponCodes(info.SysNo); } } } return(info); }
public void Start() { //EnumCodeMapper.AddMap<CustomerType>(new Dictionary<CustomerType, int>{ // { CustomerType.Personal, 0 }, // { CustomerType.Enterprise, 1 }, // { CustomerType.EnterpriseUnVerify, -1 }, // { CustomerType.Campus, 2 }, // { CustomerType.CampusUnVerify, -2 } //}); //EnumCodeMapper.AddMap<AgentType>(new Dictionary<AgentType, string>{ // { AgentType.Personal, "P" }, // { AgentType.Enterprise, "E" }, // { AgentType.Campus, "C" } //}); EnumCodeMapper.AddMap <DepartmentValidStatus>(new Dictionary <DepartmentValidStatus, string> { { DepartmentValidStatus.Active, "A" }, { DepartmentValidStatus.DeActive, "D" } }); EnumCodeMapper.AddMap <BizOperationUserType>(new Dictionary <BizOperationUserType, string> { { BizOperationUserType.InUser, "I" }, { BizOperationUserType.EditUser, "E" }, { BizOperationUserType.ConfirmUser, "C" }, { BizOperationUserType.ApprovedUser, "A" }, { BizOperationUserType.User, "U" }, { BizOperationUserType.PM, "P" }, { BizOperationUserType.RecvUserSysNo, "R" } }); EnumCodeMapper.AddMap <BizOperationUserStatus>(new Dictionary <BizOperationUserStatus, int> { { BizOperationUserStatus.Active, 0 }, { BizOperationUserStatus.InActive, -1 } }); EnumCodeMapper.AddMap <HYNStatus>(new Dictionary <HYNStatus, string> { { HYNStatus.Hide, "Hide" }, { HYNStatus.No, "No" }, { HYNStatus.Yes, "Yes" } }); EnumCodeMapper.AddMap <SYNStatus>(new Dictionary <SYNStatus, string> { { SYNStatus.No, "No" }, { SYNStatus.Yes, "Yes" } }); EnumCodeMapper.AddMap <IsSpecial>(new Dictionary <IsSpecial, string> { { IsSpecial.No, "N" }, { IsSpecial.Yes, "Y" } }); EnumCodeMapper.AddMap <DeliveryStatusFor24H>(new Dictionary <DeliveryStatusFor24H, string> { { DeliveryStatusFor24H.No, "0" }, { DeliveryStatusFor24H.Yes, "24H" } }); EnumCodeMapper.AddMap <AreaStatus>(new Dictionary <AreaStatus, int> { { AreaStatus.Active, 0 }, { AreaStatus.Deactive, -1 } }); EnumCodeMapper.AddMap <ShipTypeProductType>(new Dictionary <ShipTypeProductType, string> { { ShipTypeProductType.Required, "D" }, { ShipTypeProductType.Embargo, "E" } }); EnumCodeMapper.AddMap <ProductRange>(new Dictionary <ProductRange, string> { { ProductRange.Goods, "P" }, { ProductRange.GoodsType, "C" } }); EnumCodeMapper.AddMap <CompanyCustomer>(new Dictionary <CompanyCustomer, int> { { CompanyCustomer.Default, 0 }, { CompanyCustomer.AstraZeneca, 1 } }); EnumCodeMapper.AddMap <LogSOStatus>(new Dictionary <LogSOStatus, int> { { LogSOStatus.Origin, 0 }, { LogSOStatus.WaitingOutStock, 1 }, { LogSOStatus.WaitingPay, 2 }, { LogSOStatus.WaitingManagerAudit, 3 }, { LogSOStatus.OutStock, 4 }, { LogSOStatus.SystemCancel, -4 }, { LogSOStatus.ManagerCancel, -3 }, { LogSOStatus.CustomerCancel, -2 }, { LogSOStatus.EmployeeCancel, -1 } }); EnumCodeMapper.AddMap <c.BizLogType>(new Dictionary <c.BizLogType, int> { { c.BizLogType.St_Transfer_Item_Delete, 50143 }, { c.BizLogType.RMA_Refund_CancelAudit, 70505 }, { c.BizLogType.Sys_User_Add, 101010 }, { c.BizLogType.Sys_User_Update, 101011 }, { c.BizLogType.Sys_User_Login, 101012 }, { c.BizLogType.Sys_Role_Add, 101110 }, { c.BizLogType.Sys_Role_Update, 101111 }, { c.BizLogType.Sys_UserRole_Add, 101210 }, { c.BizLogType.Sys_UserRole_Delete, 101212 }, { c.BizLogType.Sys_RolePrivilege_Add, 101310 }, { c.BizLogType.Sys_RolePrivilege_Delete, 101312 }, { c.BizLogType.Basic_Category1_Add, 111310 }, { c.BizLogType.Basic_Category1_Update, 111311 }, { c.BizLogType.Basic_Category1_CancelAudit, 111313 }, { c.BizLogType.Basic_Category1_Approved, 111314 }, { c.BizLogType.Basic_Category1_Declined, 111315 }, { c.BizLogType.Basic_Category2_Add, 111410 }, { c.BizLogType.Basic_Category2_Update, 111411 }, { c.BizLogType.Basic_Category2_CancelAudit, 111413 }, { c.BizLogType.Basic_Category2_Approved, 111414 }, { c.BizLogType.Basic_Category2_Declined, 111415 }, { c.BizLogType.Basic_Category3_Add, 111510 }, { c.BizLogType.Basic_Category3_Update, 111511 }, { c.BizLogType.Basic_Category3_CancelAudit, 111513 }, { c.BizLogType.Basic_Category3_Approved, 111514 }, { c.BizLogType.Basic_Category3_Declined, 111515 }, { c.BizLogType.Basic_CategoryAttribute_Init, 111610 }, { c.BizLogType.Basic_CategoryAttribute_Update, 111611 }, { c.BizLogType.Basic_CategoryAttribute_Top, 111612 }, { c.BizLogType.Basic_CategoryAttribute_Up, 111613 }, { c.BizLogType.Basic_CategoryAttribute_Down, 111614 }, { c.BizLogType.Basic_CategoryAttribute_Bottom, 111615 }, { c.BizLogType.Basic_Manufacturer_Add, 111710 }, { c.BizLogType.Basic_Manufacturer_Update, 111711 }, { c.BizLogType.Basic_Vendor_Add, 111810 }, { c.BizLogType.Basic_Vendor_Update, 111811 }, { c.BizLogType.Basic_Vendor_Hold, 111812 }, { c.BizLogType.Basic_Vendor_UnHold, 111813 }, { c.BizLogType.Basic_Stock_Add, 111910 }, { c.BizLogType.Basic_Stock_Update, 111911 }, { c.BizLogType.Basic_Currency_Add, 112010 }, { c.BizLogType.Basic_Currency_Update, 112011 }, { c.BizLogType.Basic_Customer_Add, 113001 }, { c.BizLogType.Basic_Product_Basic_Update, 113002 }, { c.BizLogType.Basic_Product_Price_Update, 113003 }, { c.BizLogType.Basic_Product_PM_Update, 113004 }, { c.BizLogType.Basic_Product_Attribute_Update, 113005 }, { c.BizLogType.Basic_Product_Weight_Update, 113006 }, { c.BizLogType.Basic_Product_Pic_Update, 113007 }, { c.BizLogType.Basic_Product_NotPermitRefund, 113008 }, { c.BizLogType.Basic_Product_PermitRefund, 113009 }, { c.BizLogType.Basic_Product_JDItem_Update, 113010 }, { c.BizLogType.Ex_Product_TakePictures_Update, 113011 }, { c.BizLogType.Basic_Customer_Invalid, 113012 }, { c.BizLogType.Basic_Customer_ManualSetVIPRank, 113013 }, { c.BizLogType.Basic_Product_Clone, 113014 }, { c.BizLogType.Basic_Product_Copy, 113015 }, { c.BizLogType.Basic_Product_Note_Update, 113017 }, { c.BizLogType.Basic_Product_Hold_Update, 113018 }, { c.BizLogType.Inventory_PurchaseQtyAdjust, 113019 }, { c.BizLogType.Basic_Product_Price_Update_Verify, 113020 }, { c.BizLogType.Basic_Product_Price_Update_CancelVerify, 113021 }, { c.BizLogType.Basic_Product_Price_Update_VerifyOK, 113022 }, { c.BizLogType.Basic_Product_Price_Update_VerifyCancel, 113023 }, { c.BizLogType.Basic_Product_Info_PublishOK, 113024 }, { c.BizLogType.Basic_Product_UnitCost_Update_Instalment, 113025 }, { c.BizLogType.Basic_Product_Price_Update_Instalment, 113026 }, { c.BizLogType.Basic_Product_Price_PMRequestMemo, 113030 }, { c.BizLogType.Basic_Product_Price_TLRequestMemo, 113031 }, { c.BizLogType.Basic_Product_TopCancelWithGoDown, 113041 }, { c.BizLogType.Basic_Product_TopSave, 113042 }, { c.BizLogType.Basic_Product_TopCancel, 113043 }, { c.BizLogType.Vendor_Update_Verify, 114020 }, { c.BizLogType.Vendor_Update_Cancel_Verify, 114021 }, { c.BizLogType.Vendor_Update_VerifyOK, 114022 }, { c.BizLogType.Vendor_Update__VerifyCancel, 114023 }, { c.BizLogType.Basic_Area_Add, 116010 }, { c.BizLogType.Basic_Area_Update, 116011 }, { c.BizLogType.Basic_PayType_Add, 116012 }, { c.BizLogType.Basic_PayType_Update, 116013 }, { c.BizLogType.Basic_ShipType_Add, 116014 }, { c.BizLogType.Basic_ShipType_Update, 116015 }, { c.BizLogType.Basic_ShipAreaUn_Add, 116016 }, { c.BizLogType.Basic_ShipAreaUn_Delete, 116017 }, { c.BizLogType.Basic_ShipPayUn_Add, 116018 }, { c.BizLogType.Basic_ShipPayUn_Delete, 116019 }, { c.BizLogType.Basic_ShipAreaPrice_Add, 116020 }, { c.BizLogType.Basic_ShipAreaPrice_Delete, 116021 }, { c.BizLogType.Purchase_Basket_Insert, 201010 }, { c.BizLogType.Purchase_Basket_Update, 201011 }, { c.BizLogType.Purchase_Basket_Delete, 201012 }, { c.BizLogType.Purchase_Create, 201110 }, { c.BizLogType.Purchase_Master_Update, 201111 }, { c.BizLogType.Purchase_Item_Insert, 201112 }, { c.BizLogType.Purchase_Item_Update, 201113 }, { c.BizLogType.Purchase_Item_Delete, 201114 }, { c.BizLogType.Purchase_Verify_InStock, 201116 }, { c.BizLogType.Purchase_CancelVerify, 201117 }, { c.BizLogType.Purchase_InStock, 201118 }, { c.BizLogType.Purchase_CancelInStock, 201119 }, { c.BizLogType.Purchase_Abandon, 201120 }, { c.BizLogType.Purchase_CancelAbandon, 201121 }, { c.BizLogType.Purchase_ApportionMaster_Add, 201122 }, { c.BizLogType.Purchase_ApportionMaster_Delete, 201123 }, { c.BizLogType.Purchase_ApportionItem_Add, 201124 }, { c.BizLogType.Purchase_ApportionItem_Delete, 201125 }, { c.BizLogType.Purchase_Apportion_Export, 201126 }, { c.BizLogType.Purchase_InStockMemo, 201127 }, { c.BizLogType.Purchase_Item_Check, 201128 }, { c.BizLogType.Purchase_AutoAbandon, 201129 }, { c.BizLogType.POCToAcc_Add, 201130 }, { c.BizLogType.POC_VendorSettle_Create, 201131 }, { c.BizLogType.POC_VendorSettle_Master_Update, 201132 }, { c.BizLogType.POC_VendorSettle_Item_Add, 201133 }, { c.BizLogType.POC_VendorSettle_Item_Delete, 201134 }, { c.BizLogType.POC_VendorSettle_Item_Update, 201135 }, { c.BizLogType.POC_VendorSettle_Audit, 201136 }, { c.BizLogType.POC_VendorSettle_CancelAudit, 201137 }, { c.BizLogType.POC_VendorSettle_Settle, 201138 }, { c.BizLogType.POC_VendorSettle_CancelSettle, 201139 }, { c.BizLogType.POC_VendorSettle_Abandon, 201140 }, { c.BizLogType.POC_VendorSettle_CancelAbandon, 201141 }, { c.BizLogType.POC_FinanceSettle_Create, 201142 }, { c.BizLogType.POC_FinanceSettle_Abandon, 201143 }, { c.BizLogType.POC_FinanceSettle_CancelAbandon, 201144 }, { c.BizLogType.Purchase_PMRequestMemo, 201145 }, { c.BizLogType.Purchase_TLRequestMemo, 201146 }, { c.BizLogType.Finance_Pay_Item_Add, 301110 }, { c.BizLogType.Finance_Pay_Item_Update, 301111 }, { c.BizLogType.Finance_Pay_Item_Abandon, 301112 }, { c.BizLogType.Finance_Pay_Item_CancelAbandon, 301113 }, { c.BizLogType.Finance_Pay_Item_Pay, 301114 }, { c.BizLogType.Finance_Pay_Item_CancelPay, 301115 }, { c.BizLogType.Finance_Pay_Update, 301116 }, { c.BizLogType.Finance_SOIncome_Add, 301201 }, { c.BizLogType.Finance_SOIncome_Abandon, 301202 }, { c.BizLogType.Finance_SOIncome_Confirm, 301203 }, { c.BizLogType.Finance_SOIncome_UnConfirm, 301204 }, { c.BizLogType.Finance_SOIncome_UpdateIncomeAmt, 301205 }, { c.BizLogType.Finance_SOIncome_UpdateInvoiceNo, 301206 }, { c.BizLogType.Finance_NetPay_AddVerified, 301310 }, { c.BizLogType.Finance_NetPay_Verify, 301311 }, { c.BizLogType.Finance_NetPay_Abandon, 301312 }, { c.BizLogType.Finance_AdvancePay_Check, 301313 }, { c.BizLogType.FinanceRemitNoOwnerEdit, 301314 }, { c.BizLogType.FinanceRemitNoOwnerClaimAudit, 301315 }, { c.BizLogType.FinanceRemitNoOwnerDelete, 301316 }, { c.BizLogType.Add_NewEggAccounts_Point, 301401 }, { c.BizLogType.Online_Bulletin_Update, 401001 }, { c.BizLogType.Online_List_Insert, 401002 }, { c.BizLogType.Online_List_Delete, 401003 }, { c.BizLogType.Online_Poll_Insert, 401004 }, { c.BizLogType.Online_Poll_Update, 401005 }, { c.BizLogType.Online_Poll_InsertItem, 401006 }, { c.BizLogType.Online_Poll_UpdateItem, 401007 }, { c.BizLogType.Online_Poll_DeleteItem, 401008 }, { c.BizLogType.Online_Poll_Show, 401009 }, { c.BizLogType.Online_Poll_NotShow, 401010 }, { c.BizLogType.Online_FeedBack_Update, 401011 }, { c.BizLogType.Online_ProductQuestion_Reply, 401012 }, { c.BizLogType.PromotionAdd, 402001 }, { c.BizLogType.PromotionInvalid, 402002 }, { c.BizLogType.PromotionValid, 402003 }, { c.BizLogType.PromotionCodeAdd, 402004 }, { c.BizLogType.PromotionCodeInvalid, 402005 }, { c.BizLogType.PromotionCodeValid, 402006 }, { c.BizLogType.PromotionCodeDistribute, 402007 }, { c.BizLogType.PromotionCustomerDelete, 402008 }, { c.BizLogType.PromotionProductAdd, 402009 }, { c.BizLogType.PromotionProductDelete, 402010 }, { c.BizLogType.BetAdd, 402011 }, { c.BizLogType.BetUpdate, 402012 }, { c.BizLogType.BetOptionAdd, 402013 }, { c.BizLogType.BetOptionDelete, 402014 }, { c.BizLogType.BetAnswerSet, 402015 }, { c.BizLogType.BetOpen, 402016 }, { c.BizLogType.PromotionEdit, 402017 }, { c.BizLogType.PromotionLimitAdd, 402018 }, { c.BizLogType.PromotionLimitEdit, 402019 }, { c.BizLogType.PromotionLimitDelete, 402020 }, { c.BizLogType.PromotionCodeDelete, 402021 }, { c.BizLogType.PromotionCodeEdit, 402022 }, { c.BizLogType.Auction_Status_Update, 405001 }, { c.BizLogType.Auction_Detail_Update, 405002 }, { c.BizLogType.Auction_Detail_Insert, 405003 }, { c.BizLogType.AuctionComment_Status_Update, 405004 }, { c.BizLogType.Auction_Trubermaker_Insert, 405005 }, { c.BizLogType.Auction_Status_Confirm, 405006 }, { c.BizLogType.Auction_Status_Delete, 405007 }, { c.BizLogType.Auction_Reset_Status_Update, 405008 }, { c.BizLogType.Countdown_Insert, 408001 }, { c.BizLogType.Countdown_Update, 408002 }, { c.BizLogType.Countdown_Abandon, 408003 }, { c.BizLogType.Countdown_Interupt, 408004 }, { c.BizLogType.Countdown_Verify, 408005 }, { c.BizLogType.Countdown_VerifyPass, 408006 }, { c.BizLogType.Countdown_VerifyFaild, 408007 }, { c.BizLogType.Delivery_OK, 409001 }, { c.BizLogType.Delivery_Abandon, 409002 }, { c.BizLogType.Delivery_Failure, 409003 }, { c.BizLogType.Delivery_NoAction, 409004 }, { c.BizLogType.Delivery_ReAssign, 409005 }, { c.BizLogType.PO_Vendor_Invoice_Add, 409006 }, { c.BizLogType.PO_Vendor_Invoice_Update, 409007 }, { c.BizLogType.PO_Vendor_Invoice_Verify, 409008 }, { c.BizLogType.PO_Vendor_Invoice_CancelVerify, 409009 }, { c.BizLogType.PO_Vendor_Invoice_Abandon, 409010 }, { c.BizLogType.PO_Vendor_Invoice_CancelAbandon, 409011 }, { c.BizLogType.InvoiceInput_Add, 500000 }, { c.BizLogType.InvoiceInput_SubmitAudit, 500001 }, { c.BizLogType.InvoiceInput_CancelAudit, 500002 }, { c.BizLogType.InvoiceInput_PassAudit, 500003 }, { c.BizLogType.InvoiceInput_RefuseAudit, 500004 }, { c.BizLogType.St_Lend_Master_Insert, 501110 }, { c.BizLogType.St_Lend_Master_Update, 501111 }, { c.BizLogType.St_Lend_Item_Insert, 501112 }, { c.BizLogType.St_Lend_Item_Delete, 501113 }, { c.BizLogType.St_Lend_Item_Update, 501114 }, { c.BizLogType.St_Lend_Abandon, 501115 }, { c.BizLogType.St_Lend_CancelAbandon, 501116 }, { c.BizLogType.St_Lend_Verify, 501117 }, { c.BizLogType.St_Lend_CancelVerify, 501118 }, { c.BizLogType.St_Lend_OutStock, 501119 }, { c.BizLogType.St_Lend_CancelOutStock, 501120 }, { c.BizLogType.St_Lend_Return_Insert, 501121 }, { c.BizLogType.St_Lend_Return_Delete, 501122 }, { c.BizLogType.St_Adjust_Master_Insert, 501210 }, { c.BizLogType.St_Adjust_Master_Update, 501211 }, { c.BizLogType.St_Adjust_Item_Insert, 501212 }, { c.BizLogType.St_Adjust_Item_Delete, 501213 }, { c.BizLogType.St_Adjust_Item_Update, 501214 }, { c.BizLogType.St_Adjust_Abandon, 501215 }, { c.BizLogType.St_Adjust_CancelAbandon, 501216 }, { c.BizLogType.St_Adjust_Verify, 501217 }, { c.BizLogType.St_Adjust_CancelVerify, 501218 }, { c.BizLogType.St_Adjust_OutStock, 501219 }, { c.BizLogType.St_Adjust_CancelOutStock, 501220 }, { c.BizLogType.St_Shift_Master_Insert, 501310 }, { c.BizLogType.St_Shift_Master_Update, 501311 }, { c.BizLogType.St_Shift_Item_Insert, 501312 }, { c.BizLogType.St_Shift_Item_Delete, 501313 }, { c.BizLogType.St_Shift_Item_Update, 501314 }, { c.BizLogType.St_Shift_Abandon, 501315 }, { c.BizLogType.St_Shift_CancelAbandon, 501316 }, { c.BizLogType.St_Shift_Verify, 501317 }, { c.BizLogType.St_Shift_CancelVerify, 501318 }, { c.BizLogType.St_Shift_OutStock, 501319 }, { c.BizLogType.St_Shift_CancelOutStock, 501320 }, { c.BizLogType.St_Shift_InStock, 501321 }, { c.BizLogType.St_Shift_CancelInStock, 501322 }, { c.BizLogType.St_Shift_BatchInsert, 501323 }, { c.BizLogType.St_Transfer_Master_Insert, 501410 }, { c.BizLogType.St_Transfer_Master_Update, 501411 }, { c.BizLogType.St_Transfer_Item_Insert, 501412 }, { c.BizLogType.St_Transfer_Item_Update, 501414 }, { c.BizLogType.St_Transfer_Abandon, 501415 }, { c.BizLogType.St_Transfer_CancelAbandon, 501416 }, { c.BizLogType.St_Transfer_Verify, 501417 }, { c.BizLogType.St_Transfer_CancelVerify, 501418 }, { c.BizLogType.St_Transfer_OutStock, 501419 }, { c.BizLogType.St_Transfer_CancelOutStock, 501420 }, { c.BizLogType.St_Virtual_Insert, 501510 }, { c.BizLogType.St_SOVirtualItemRequest_Add, 501511 }, { c.BizLogType.St_SOVirtualItemRequest_Save, 501512 }, { c.BizLogType.St_SOVirtualItemRequest_Abandon, 501513 }, { c.BizLogType.St_SOVirtualItemRequest_UpdateCSMemo, 501514 }, { c.BizLogType.St_Category3SetRMAInfo_Update, 501515 }, { c.BizLogType.St_Inventory_SetPos, 501610 }, { c.BizLogType.AuditRefund_Update, 600000 }, { c.BizLogType.Sale_SO_WebSite_Create, 0 }, { c.BizLogType.Sale_SO_WebSite_Submit, 200 }, { c.BizLogType.Sale_SO_Create, 600601 }, { c.BizLogType.Sale_SO_Audit, 600602 }, { c.BizLogType.Sale_SO_CancelAudit, 600603 }, { c.BizLogType.Sale_SO_ManagerAudit, 600604 }, { c.BizLogType.Sale_SO_CustomerAbandon, 600605 }, { c.BizLogType.Sale_SO_EmployeeAbandon, 600606 }, { c.BizLogType.Sale_SO_ManagerAbandon, 600607 }, { c.BizLogType.Sale_SO_CancelAbandon, 600608 }, { c.BizLogType.Sale_SO_OutStock, 600609 }, { c.BizLogType.Sale_SO_CancelOutStock, 600610 }, { c.BizLogType.Sale_SO_PrintInvoice, 600611 }, { c.BizLogType.Sale_SO_Update, 600612 }, { c.BizLogType.Sale_SO_FastCashRebate, 600613 }, { c.BizLogType.Sale_SO_HoldSO, 600614 }, { c.BizLogType.Sale_SO_UnHoldSO, 600615 }, { c.BizLogType.Sale_SO_VoideSO, 600616 }, { c.BizLogType.Sale_SO_UpdateInvoiceNo, 600617 }, { c.BizLogType.Sale_SO_SplitInvoice, 600618 }, { c.BizLogType.Sale_SO_CancelSplitInvoice, 600619 }, { c.BizLogType.Sale_RMA_Create, 600801 }, { c.BizLogType.Sale_RMA_Abandon, 600802 }, { c.BizLogType.Sale_RMA_Audit, 600803 }, { c.BizLogType.Sale_RMA_CancelAudit, 600804 }, { c.BizLogType.Sale_RMA_Receive, 600805 }, { c.BizLogType.Sale_RMA_CancelReceive, 600806 }, { c.BizLogType.Sale_RMA_Handle, 600807 }, { c.BizLogType.Sale_RMA_CancelHandle, 600808 }, { c.BizLogType.Sale_RMA_Close, 600809 }, { c.BizLogType.Sale_RMA_Reopen, 600810 }, { c.BizLogType.Sale_RO_Create, 600901 }, { c.BizLogType.Sale_RO_Abandon, 600902 }, { c.BizLogType.Sale_RO_Audit, 600903 }, { c.BizLogType.Sale_RO_CancelAudit, 600904 }, { c.BizLogType.Sale_RO_Return, 600905 }, { c.BizLogType.Sale_RO_CancelReturn, 600906 }, { c.BizLogType.Sale_RO_PrintInvoice, 600907 }, { c.BizLogType.Sale_RMA_Create2, 700801 }, { c.BizLogType.Sale_RMA_Abandon2, 700802 }, { c.BizLogType.Sale_RMA_Audit2, 700803 }, { c.BizLogType.RMA_OutBound_Create, 702001 }, { c.BizLogType.RMA_OutBound_Update, 702002 }, { c.BizLogType.RMA_OutBound_OutStock, 702003 }, { c.BizLogType.RMA_OutBound_CancelOutStock, 702004 }, { c.BizLogType.RMA_OutBound_DeleteItem, 702005 }, { c.BizLogType.RMA_OutBound_InsertItem, 702006 }, { c.BizLogType.RMA_OutBound_Abandon, 702007 }, { c.BizLogType.RMA_Register_Check, 703001 }, { c.BizLogType.RMA_Register_Memo, 703002 }, { c.BizLogType.RMA_Register_Outbound, 703003 }, { c.BizLogType.RMA_Register_Revert, 703004 }, { c.BizLogType.RMA_Register_Refund, 703005 }, { c.BizLogType.RMA_Register_Return, 703006 }, { c.BizLogType.RMA_Register_Close, 703007 }, { c.BizLogType.RMA_Register_ToCC, 703008 }, { c.BizLogType.RMA_Register_ToRMA, 703009 }, { c.BizLogType.RMA_Register_RevertAudit, 703010 }, { c.BizLogType.RMA_Register_ResponseInfo, 703011 }, { c.BizLogType.RMA_Register_ToRegister, 703012 }, { c.BizLogType.RMA_Register_ToCheck, 703013 }, { c.BizLogType.RMA_Register_ToASK, 703014 }, { c.BizLogType.RMA_Register_ToRevert, 703015 }, { c.BizLogType.RMA_Register_ToReturn, 703016 }, { c.BizLogType.RMA_Register_ToECC, 703017 }, { c.BizLogType.RMA_Revert_Create, 704001 }, { c.BizLogType.RMA_Revert_Update, 704002 }, { c.BizLogType.RMA_Revert_Abandon, 704003 }, { c.BizLogType.RMA_Revert_Out, 704004 }, { c.BizLogType.RMA_Revert_CancelOut, 704005 }, { c.BizLogType.RMA_Refund_Create, 705001 }, { c.BizLogType.RMA_Refund_Upate, 705002 }, { c.BizLogType.RMA_Refund_Abandon, 705003 }, { c.BizLogType.RMA_Refund_Audit, 705004 }, { c.BizLogType.RMA_Refund_Refund, 705006 }, { c.BizLogType.AO_Refund_Refund, 705008 }, { c.BizLogType.RMA_Refund_CancelRefund, 705007 }, { c.BizLogType.RMA_Return_Create, 706001 }, { c.BizLogType.RMA_Return_Update, 706002 }, { c.BizLogType.RMA_Return_Abandon, 706003 }, { c.BizLogType.RMA_Return_Return, 706004 }, { c.BizLogType.RMA_Return_CancelReturn, 706005 }, { c.BizLogType.RMA_Return_Audit, 706006 }, { c.BizLogType.RMA_Request_Create, 707001 }, { c.BizLogType.RMA_Request_Update, 707002 }, { c.BizLogType.RMA_Request_Receive, 707003 }, { c.BizLogType.RMA_Request_CancelReceive, 707004 }, { c.BizLogType.RMA_Request_Abandon, 707005 }, { c.BizLogType.RMA_Request_Close, 707006 }, { c.BizLogType.RMA_Request_ReCreate, 707007 }, { c.BizLogType.RMA_Auto_Request, 707008 }, { c.BizLogType.RMA_Auto_Refund, 707009 }, { c.BizLogType.RMA_Auto_Return, 707010 }, { c.BizLogType.PO_SendMail, 808001 }, { c.BizLogType.InventoryBackUp, 999998 }, { c.BizLogType.ZZZZZ, 999999 } }); EnumCodeMapper.AddMap <FreeShippingAmountSettingStatus>(new Dictionary <FreeShippingAmountSettingStatus, string> { { FreeShippingAmountSettingStatus.Active, "A" }, { FreeShippingAmountSettingStatus.DeActive, "D" } }); }
public void Start() { EnumCodeMapper.AddMap <CustomerType>(new Dictionary <CustomerType, int> { { CustomerType.Personal, 0 }, { CustomerType.Enterprise, 1 }, { CustomerType.Campus, 2 }, { CustomerType.Media, 3 }, { CustomerType.Internal, 4 } }); EnumCodeMapper.AddMap <AvtarShowStatus>(new Dictionary <AvtarShowStatus, string>() { { AvtarShowStatus.NotSet, "S" }, { AvtarShowStatus.Show, "A" }, { AvtarShowStatus.NotShow, "D" } }); //兼容数据库中头像状态为S的情况 EnumCodeMapper.AddExtraCodeMap <AvtarShowStatus>(AvtarShowStatus.NotSet, "0"); //前台注册时为0,其实 EnumCodeMapper.AddExtraCodeMap <CustomerStatus>(CustomerStatus.InValid, -1); //前台注册时为0,其实 EnumCodeMapper.AddMap <OrderCheckStatus>(new Dictionary <OrderCheckStatus, int>() { { OrderCheckStatus.Invalid, 1 }, { OrderCheckStatus.Valid, 0 } }); EnumCodeMapper.AddMap <RefundRequestType>(new Dictionary <RefundRequestType, string>() { { RefundRequestType.SO, "S" }, { RefundRequestType.Balance, "C" } }); EnumCodeMapper.AddMap <RefundRequestStatus>(new Dictionary <RefundRequestStatus, string>() { { RefundRequestStatus.A, "A" }, { RefundRequestStatus.O, "O" }, { RefundRequestStatus.R, "R" } }); EnumCodeMapper.AddMap <PrepayStatus>(new Dictionary <PrepayStatus, string>() { { PrepayStatus.Valid, "A" }, { PrepayStatus.InValid, "D" } }); //EnumCodeMapper.AddMap<CompanyCustomer>(new Dictionary<CompanyCustomer, int>() //{ // {CompanyCustomer.Newegg,0}, // {CompanyCustomer.AstraZeneca,1} //}); EnumCodeMapper.AddMap <RefundAdjustStatus>(new Dictionary <RefundAdjustStatus, int>() { { RefundAdjustStatus.Abandon, -1 }, { RefundAdjustStatus.Initial, 0 }, { RefundAdjustStatus.WaitingAudit, 1 }, { RefundAdjustStatus.AuditRefuesed, 2 }, { RefundAdjustStatus.Audited, 3 }, { RefundAdjustStatus.Refunded, 4 } }); EnumCodeMapper.AddMap <RefundAdjustType>(new Dictionary <RefundAdjustType, int>() { { RefundAdjustType.ShippingAdjust, 1 }, { RefundAdjustType.Other, 2 } }); }
/// <summary> /// 根据实体创建查询条件 /// </summary> /// <param name="query"></param> /// <param name="command"></param> private void CreateQueryProductCommand(object query, DataCommand command) { if (query == null || command == null) { return; } var targetProArray = query.GetType().GetProperties(BindingFlags.Public | BindingFlags.Instance); if (targetProArray.Length <= 0) { return; } foreach (var pro in targetProArray) { var tempType = pro.PropertyType; var value = pro.GetValue(query, null); if (!tempType.IsGenericType && tempType.IsClass && !tempType.Name.ToUpper().Contains("STRING") && !tempType.Name.ToUpper().Contains("PAGINGINFO") ) { if (value != null) { CreateQueryProductCommand(value, command); } } else if (tempType.IsGenericType && tempType.Name.ToLower().Contains("comparison") && tempType.GetGenericArguments().Length == 2) { var targe = GetGenericType(null, tempType.GetGenericArguments()[0]); var otherTarge = tempType.GetGenericArguments()[1]; if (targe.Name.ToLower().Contains("decimal")) { var tempValue = (QueryFilter.IM.Comparison <decimal?, OperatorType>)value; CreateComparisonCommand <decimal?, OperatorType>(tempValue, pro.Name, command); } else if (targe.Name.ToLower().Contains("int") && otherTarge.Name.ToLower().Contains("operatortype")) { var tempValue = (QueryFilter.IM.Comparison <int?, OperatorType>)value; CreateComparisonCommand <int?, OperatorType>(tempValue, pro.Name, command); } else if (targe.Name.ToLower().Contains("int") && otherTarge.Name.ToLower().Contains("comparison")) { var tempValue = (QueryFilter.IM.Comparison <int?, Comparison>)value; CreateComparisonCommand <int?, Comparison>(tempValue, pro.Name, command); } } else if (tempType.IsGenericType && tempType.GetGenericTypeDefinition() == typeof(Nullable <>) && tempType.GetGenericArguments().Length == 1) { var baseType = GetGenericType(value, tempType); if (baseType.IsEnum) { if (value == null) { if (EnumCodeMapper.IsExistMap(baseType)) { CreateCommand(EmptyValueStr, pro.Name, command); } else { CreateCommand(EmptyValue, pro.Name, command); } } else { if (EnumCodeMapper.IsExistMap(baseType)) { var code = Convert.ToInt32(value); var codeValue = (char)code; CreateCommand(Convert.ToString(codeValue), pro.Name, command); } else { CreateCommand(Convert.ToInt32(value), pro.Name, command); } } } else if (baseType.Name.ToLower().Contains("datetime")) { var tempValue = value == null?DateTime.Parse(MinTime) : DateTime.Parse(value.ToString()); CreateCommand(tempValue, pro.Name, command); } else if (baseType.IsValueType) { var tempValue = value == null ? EmptyValue : Convert.ToInt32(value); CreateCommand(tempValue, pro.Name, command); } } else if (tempType.IsValueType || tempType.Name.ToLower().Contains("string")) { if (tempType.Name.ToLower().Contains("string") && value == null) { CreateCommand("", pro.Name, command); } else { CreateCommand(value, pro.Name, command); } } } }
public void Start() { #region EIMS EnumCodeMapper.AddMap <InvoiceStatus>(new Dictionary <InvoiceStatus, string> { { InvoiceStatus.AutoClose, "F" }, { InvoiceStatus.Open, "O" }, { InvoiceStatus.Lock, "E" } }); #endregion #region VendorPortal EnumCodeMapper.AddMap <ValidStatus>(new Dictionary <ValidStatus, string> { { ValidStatus.Active, "A" }, { ValidStatus.DeActive, "D" } }); #endregion #region CPS EnumCodeMapper.AddMap <FinanceStatus>(new Dictionary <FinanceStatus, string> { { FinanceStatus.Paid, "P" }, { FinanceStatus.Settled, "S" }, { FinanceStatus.Unsettled, "U" }, { FinanceStatus.UnRequest, "R" }, { FinanceStatus.Abandon, "V" } }); EnumCodeMapper.AddMap <CPSOrderType>(new Dictionary <CPSOrderType, string> { { CPSOrderType.SO, "SO" }, { CPSOrderType.RMA, "RMA" } }); EnumCodeMapper.AddMap <ToCashStatus>(new Dictionary <ToCashStatus, string> { { ToCashStatus.Paid, "P" }, { ToCashStatus.Requested, "R" }, { ToCashStatus.Confirmed, "C" } }); EnumCodeMapper.AddMap <AdvertisingType>(new Dictionary <AdvertisingType, string> { { AdvertisingType.Custom, "C" }, { AdvertisingType.IMG, "I" }, { AdvertisingType.TEXT, "T" } }); EnumCodeMapper.AddMap <AuditStatus>(new Dictionary <AuditStatus, string> { { AuditStatus.AuditClearance, "A" }, { AuditStatus.AuditNoClearance, "D" }, { AuditStatus.AuditReady, "O" } }); EnumCodeMapper.AddMap <UserType>(new Dictionary <UserType, string> { { UserType.Personal, "P" }, { UserType.Enterprise, "E" } //{ UserType.Other, "O" } }); EnumCodeMapper.AddMap <IsActive>(new Dictionary <IsActive, string> { { IsActive.DeActive, "0" }, { IsActive.Active, "1" }, }); EnumCodeMapper.AddMap <IsLock>(new Dictionary <IsLock, string> { { IsLock.Lock, "L" }, { IsLock.UnLock, "U" }, }); EnumCodeMapper.AddMap <CanProvideInvoice>(new Dictionary <CanProvideInvoice, string> { { CanProvideInvoice.Yes, "Y" }, { CanProvideInvoice.No, "N" } }); #endregion }
public void Start() { EnumCodeMapper.AddMap <ECCentral.BizEntity.SO.SODeliveryPromise>(new Dictionary <ECCentral.BizEntity.SO.SODeliveryPromise, string> { { ECCentral.BizEntity.SO.SODeliveryPromise.In24H, "24H" }, { ECCentral.BizEntity.SO.SODeliveryPromise.NoPromise, "" } }); EnumCodeMapper.AddMap <ECCentral.BizEntity.SO.SOPriceStatus>(new Dictionary <ECCentral.BizEntity.SO.SOPriceStatus, string> { { ECCentral.BizEntity.SO.SOPriceStatus.Original, "O" }, { ECCentral.BizEntity.SO.SOPriceStatus.Deactivate, "D" } }); EnumCodeMapper.AddMap <ECCentral.BizEntity.SO.SettlementStatus>(new Dictionary <ECCentral.BizEntity.SO.SettlementStatus, string> { { ECCentral.BizEntity.SO.SettlementStatus.PlanFail, "P" }, { ECCentral.BizEntity.SO.SettlementStatus.Fail, "F" }, { ECCentral.BizEntity.SO.SettlementStatus.Success, "S" } }); EnumCodeMapper.AddExtraCodeMap <SOStatus>(new Dictionary <SOStatus, object[]> { { SOStatus.Abandon, new object[] { -1, -2, -3, -4 } }, { SOStatus.Origin, new object[] { 0, 2 } } }); EnumCodeMapper.AddExtraCodeMap <SOComplainReplyType>(SOComplainReplyType.Phone, ResSOEnum.SOComplainReplyType_Phone); EnumCodeMapper.AddExtraCodeMap <SOComplainReplyType>(SOComplainReplyType.Email, ResSOEnum.SOComplainReplyType_Email); EnumCodeMapper.AddMap <ECCentral.BizEntity.SO.SOSplitType>(new Dictionary <ECCentral.BizEntity.SO.SOSplitType, string> { { ECCentral.BizEntity.SO.SOSplitType.Normal, "0" }, { ECCentral.BizEntity.SO.SOSplitType.Force, "1" }, { ECCentral.BizEntity.SO.SOSplitType.Customer, "2" }, { ECCentral.BizEntity.SO.SOSplitType.SubSO, "3" } }); EnumCodeMapper.AddMap <ECCentral.BizEntity.SO.SOProductType>(new Dictionary <ECCentral.BizEntity.SO.SOProductType, string> { { ECCentral.BizEntity.SO.SOProductType.Product, "0" }, { ECCentral.BizEntity.SO.SOProductType.Gift, "1" }, { ECCentral.BizEntity.SO.SOProductType.Award, "2" }, { ECCentral.BizEntity.SO.SOProductType.Coupon, "3" }, { ECCentral.BizEntity.SO.SOProductType.ExtendWarranty, "4" }, { ECCentral.BizEntity.SO.SOProductType.Accessory, "5" }, { ECCentral.BizEntity.SO.SOProductType.SelfGift, "6" } }); EnumCodeMapper.AddMap <ECCentral.BizEntity.SO.SOProductPriceType>(new Dictionary <ECCentral.BizEntity.SO.SOProductPriceType, string> { { ECCentral.BizEntity.SO.SOProductPriceType.Normal, "0" }, { ECCentral.BizEntity.SO.SOProductPriceType.Member, "1" }, { ECCentral.BizEntity.SO.SOProductPriceType.WholeSale, "2" } }); EnumCodeMapper.AddMap <ECCentral.BizEntity.IM.ProductPayType>(new Dictionary <ECCentral.BizEntity.IM.ProductPayType, string> { { ECCentral.BizEntity.IM.ProductPayType.MoneyOnly, "0" }, { ECCentral.BizEntity.IM.ProductPayType.All, "1" }, { ECCentral.BizEntity.IM.ProductPayType.PointOnly, "2" } }); EnumCodeMapper.AddMap <ECCentral.BizEntity.SO.WMSAction>(new Dictionary <ECCentral.BizEntity.SO.WMSAction, string> { { ECCentral.BizEntity.SO.WMSAction.Abandon, "V" }, { ECCentral.BizEntity.SO.WMSAction.AbandonHold, "D" }, { ECCentral.BizEntity.SO.WMSAction.CancelAuditHold, "C" }, { ECCentral.BizEntity.SO.WMSAction.Hold, "H" }, { ECCentral.BizEntity.SO.WMSAction.UnHold, "U" } }); EnumCodeMapper.AddMap <ECCentral.BizEntity.SO.OPCStatus>(new Dictionary <ECCentral.BizEntity.SO.OPCStatus, string> { { ECCentral.BizEntity.SO.OPCStatus.Close, "C" }, { ECCentral.BizEntity.SO.OPCStatus.Error, "E" }, { ECCentral.BizEntity.SO.OPCStatus.Fail, "F" }, { ECCentral.BizEntity.SO.OPCStatus.Open, "O" } }); EnumCodeMapper.AddMap <ECCentral.BizEntity.SO.OPCTransStatus>(new Dictionary <ECCentral.BizEntity.SO.OPCTransStatus, string> { { ECCentral.BizEntity.SO.OPCTransStatus.Origin, "O" }, { ECCentral.BizEntity.SO.OPCTransStatus.Error, "E" }, { ECCentral.BizEntity.SO.OPCTransStatus.Fail, "F" }, { ECCentral.BizEntity.SO.OPCTransStatus.Success, "S" } }); EnumCodeMapper.AddMap(new Dictionary <ECCentral.BizEntity.SO.ValidStatus, string> { { ECCentral.BizEntity.SO.ValidStatus.Active, "A" }, { ECCentral.BizEntity.SO.ValidStatus.DeActive, "D" } }); EnumCodeMapper.AddMap(new Dictionary <ECCentral.BizEntity.SO.SOProductActivityType, string> { { ECCentral.BizEntity.SO.SOProductActivityType.GroupBuy, "G" }, { ECCentral.BizEntity.SO.SOProductActivityType.SpecialAccount, "C" }, { ECCentral.BizEntity.SO.SOProductActivityType.E_Promotion, "E" } }); }
/// <summary> /// 查询配送方式-产品 /// </summary> /// <param name="filter"></param> /// <param name="totalCount"></param> /// <returns></returns> public DataTable QueryShipTypeProductList(ShipTypeProductQueryFilter filter, out int totalCount) { MapSortField(filter); totalCount = 0; object _itemRange = null;; object _type = null; object _companyCustomer; CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("ShipTypeProduct_QueryShipTypeProduct"); PagingInfoEntity pagingInfo = ToPagingInfo(filter.PagingInfo); using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingInfo, "B.SysNo DESC")) { if (filter.ShipTypeProductType.HasValue && EnumCodeMapper.TryGetCode(filter.ShipTypeProductType, out _type)) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "B.[Type]", DbType.String, "@Type", QueryConditionOperatorType.Equal, _type); } sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "B.Description", DbType.String, "@Description", QueryConditionOperatorType.Like, filter.Description); if (filter.ProductRange.HasValue && EnumCodeMapper.TryGetCode(filter.ProductRange, out _itemRange)) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "B.ItemRange", DbType.String, "@ItemRange", QueryConditionOperatorType.Equal, _itemRange); } if (filter.CompanyCustomer != null && EnumCodeMapper.TryGetCode(filter.CompanyCustomer, out _companyCustomer)) { sqlBuilder.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "B.CompanyCustomer", DbType.String, "@CompanyCustomer", QueryConditionOperatorType.Equal, _companyCustomer); } sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "B.ProductID", DbType.String, "@ProductID", QueryConditionOperatorType.Equal, filter.ProductID); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.ShipTypeSysNo", DbType.Int32, "@ShipTypeSysNo", QueryConditionOperatorType.Equal, filter.ShippingType); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.StockSysNo", DbType.Int32, "@StockSysNo", QueryConditionOperatorType.Equal, filter.WareHouse); if (!filter.Category2.HasValue) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "E.Category1Sysno", DbType.Int32, "@C1SysNo", QueryConditionOperatorType.Equal, filter.Category1); } if (filter.Category2.HasValue && !filter.Category3.HasValue) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "E.Category2Sysno", DbType.Int32, "@C2SysNo", QueryConditionOperatorType.Equal, filter.Category2); } if (filter.Category3.HasValue) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "E.Category3Sysno", DbType.Int32, "@C3SysNo", QueryConditionOperatorType.Equal, filter.Category3); } if (filter.AreaSysNo.HasValue) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "D.SysNO", DbType.Int32, "@AreaSysNo", QueryConditionOperatorType.Equal, filter.AreaSysNo); } else if (filter.CitySysNo != null && filter.DistrictSysNo == null) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "D.SysNo", DbType.Int32, "@SysNo", QueryConditionOperatorType.Equal, filter.CitySysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.OR, "D.CitySysNo", DbType.Int32, "@CitySysNo", QueryConditionOperatorType.Equal, filter.CitySysNo); } else if (filter.ProvinceSysNo.HasValue) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "D.SysNo", DbType.Int32, "@AreaSysNo", QueryConditionOperatorType.Equal, filter.ProvinceSysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.OR, "D.ProvinceSysNo", DbType.Int32, "@ProvinceSysNo", QueryConditionOperatorType.Equal, filter.ProvinceSysNo); } cmd.CommandText = sqlBuilder.BuildQuerySql(); EnumColumnList EnumList = new EnumColumnList(); EnumList.Add("ItemRange", typeof(ECCentral.BizEntity.Common.ProductRange)); EnumList.Add("Type", typeof(ECCentral.BizEntity.Common.ShipTypeProductType)); EnumList.Add("CompanyCustomer", typeof(ECCentral.BizEntity.Common.CompanyCustomer)); DataTable dt = cmd.ExecuteDataTable(EnumList); totalCount = int.Parse(cmd.GetParameterValue("TotalCount").ToString()); return(dt); } }
public void SetParameterValue <T>(InputMap <T> map, T entity, char sqlParamSplitter, bool ignoreCase, bool throwOnPropertyNotExist) where T : class { List <ParameterProperty <T> > maps = (map == null) ? null : map.GetMaps(); if (maps == null) { maps = new List <ParameterProperty <T> >(0); } for (int i = 0; i < m_DbParameterList.Count; i++) { string property = m_PropertyNameList[i]; ConfigKeyWord keyword; ParameterProperty <T> pp = maps.Find(p => p.Parameter == m_DbParameterList[i].ParameterName || ("@" + p.Parameter == m_DbParameterList[i].ParameterName)); string[] proArray; if (pp != null) { proArray = pp.PropertyList.ToArray(); } else if (ConfigHelper.IsKeyWord(property, out keyword)) { // 构造函数的时候,就已经对这种自动赋值的param已经赋过值了,这里不用再赋了 //if (keyword == ConfigKeyWord.UserSysNo) //{ // m_DbParameterList[i].Value = ServiceContext.Current.UserSysNo; //} //else if (keyword == ConfigKeyWord.UserAcct) //{ // string acct = ConfigHelper.CurrentUserAcct; // m_DbParameterList[i].Value = (acct == null ? DBNull.Value : (object)acct); //} //else //{ // m_DbParameterList[i].Value = DateTime.Now; //} continue; } else { char[] sep = sqlParamSplitter == '.' ? new char[] { sqlParamSplitter } : new char[] { sqlParamSplitter, '.' }; proArray = property.Split(sep, StringSplitOptions.RemoveEmptyEntries); } object tmp = DataMapper.GetFieldValueAllowNull(entity, proArray, ignoreCase, throwOnPropertyNotExist); if (tmp != null) { Type type = tmp.GetType(); if (type.IsEnum || (type.IsGenericType && type.GetGenericTypeDefinition() == typeof(Nullable <>) && type.GetGenericArguments() != null && type.GetGenericArguments().Length == 1 && type.GetGenericArguments()[0].IsEnum)) { object code; if (EnumCodeMapper.TryGetCode(tmp, out code)) { tmp = code; } else if (m_DbParameterList[i].DbType == DbType.Int16 || m_DbParameterList[i].DbType == DbType.Int32 || m_DbParameterList[i].DbType == DbType.Int64) { tmp = (int)tmp; } else { tmp = tmp.ToString(); } } } m_DbParameterList[i].Value = (tmp == null ? DBNull.Value : tmp); } }
public void Start() { EnumCodeMapper.AddMap(new Dictionary <ValidStatus, string> { { ValidStatus.Active, "A" }, { ValidStatus.DeActive, "D" } }); EnumCodeMapper.AddMap(new Dictionary <ProductType, string> { { ProductType.Normal, "O" }, { ProductType.OpenBox, "S" }, { ProductType.Bad, "B" }, { ProductType.Virtual, "V" } }); EnumCodeMapper.AddMap(new Dictionary <Large, string> { { Large.Yes, "Y" }, { Large.No, "N" } }); EnumCodeMapper.AddMap(new Dictionary <ProductGroupImageShow, string> { { ProductGroupImageShow.Yes, "Y" }, { ProductGroupImageShow.No, "N" } }); EnumCodeMapper.AddMap(new Dictionary <ProductGroupPolymeric, string> { { ProductGroupPolymeric.Yes, "Y" }, { ProductGroupPolymeric.No, "N" } }); EnumCodeMapper.AddExtraCodeMap(ProductGroupPolymeric.No, new object[] { "n" }); EnumCodeMapper.AddMap(new Dictionary <PropertyStatus, int> { { PropertyStatus.Active, 1 }, { PropertyStatus.DeActive, 0 } }); EnumCodeMapper.AddMap(new Dictionary <ProductAccessoryStatus, int> { { ProductAccessoryStatus.Active, 0 }, { ProductAccessoryStatus.DeActive, -1 } }); EnumCodeMapper.AddMap(new Dictionary <PropertyType, string> { { PropertyType.Grouping, "G" }, { PropertyType.Other, "A" } }); EnumCodeMapper.AddMap(new Dictionary <ProductPropertyRequired, int> { { ProductPropertyRequired.Yes, 1 }, { ProductPropertyRequired.No, 0 } }); EnumCodeMapper.AddExtraCodeMap(PropertyType.Other, new object[] { "O" }); EnumCodeMapper.AddMap(new Dictionary <ProductResourceStatus, string> { { ProductResourceStatus.Active, "A" }, { ProductResourceStatus.DeActive, "D" } }); EnumCodeMapper.AddMap(new Dictionary <ProductResourceIsShow, string> { { ProductResourceIsShow.Yes, "Y" }, { ProductResourceIsShow.No, "N" } }); EnumCodeMapper.AddMap(new Dictionary <ResourcesType, string> { { ResourcesType.Image, "I" }, { ResourcesType.Image360, "D" }, { ResourcesType.Video, "V" } }); EnumCodeMapper.AddMap(new Dictionary <IsLarge, string> { { IsLarge.Yes, "L" }, { IsLarge.No, "S" }, { IsLarge.Undefined, "-" } }); EnumCodeMapper.AddMap(new Dictionary <OfferVATInvoice, int> { { OfferVATInvoice.Yes, 1 }, { OfferVATInvoice.No, 0 } }); EnumCodeMapper.AddMap(new Dictionary <WarrantyShow, int> { { WarrantyShow.Yes, 1 }, { WarrantyShow.No, 0 } }); EnumCodeMapper.AddMap(new Dictionary <CustomerRank, int> { { CustomerRank.Ferrum, 1 }, { CustomerRank.Copper, 2 }, { CustomerRank.Silver, 3 }, { CustomerRank.Golden, 4 }, { CustomerRank.Diamond, 5 }, { CustomerRank.Crown, 6 }, { CustomerRank.Supremacy, 7 } }); EnumCodeMapper.AddMap(new Dictionary <ProductRankPriceStatus, int> { { ProductRankPriceStatus.Active, 0 }, { ProductRankPriceStatus.DeActive, -1 } }); EnumCodeMapper.AddMap(new Dictionary <WholeSaleLevelType, int> { { WholeSaleLevelType.L1, 1 }, { WholeSaleLevelType.L2, 2 }, { WholeSaleLevelType.L3, 3 } }); EnumCodeMapper.AddMap(new Dictionary <GiftCardStatus, string> { { GiftCardStatus.ManualActive, "H" }, { GiftCardStatus.InValid, "D" }, { GiftCardStatus.Void, "V" }, { GiftCardStatus.Used, "U" }, { GiftCardStatus.Valid, "A" } }); EnumCodeMapper.AddMap(new Dictionary <CategoryExtendWarrantyStatus, string> { { CategoryExtendWarrantyStatus.Active, "A" }, { CategoryExtendWarrantyStatus.DeActive, "D" } }); EnumCodeMapper.AddMap(new Dictionary <CategoryExtendWarrantyDisuseBrandStatus, string> { { CategoryExtendWarrantyDisuseBrandStatus.Active, "A" }, { CategoryExtendWarrantyDisuseBrandStatus.DeActive, "D" } }); EnumCodeMapper.AddMap(new Dictionary <ActionType, string> { { ActionType.Hold, "Hold" }, { ActionType.AdjustExpireDate, "AdjustExpireDate" }, { ActionType.ForwardCard, "ForwardCard" }, { ActionType.MandatoryVoid, "MandatoryVoid" }, { ActionType.UnHold, "UnHold" }, { ActionType.SO, "SO" }, { ActionType.RMA, "RMA" }, { ActionType.ROBalance, "ROBalance" } }); EnumCodeMapper.AddMap(new Dictionary <SellerProductRequestStatus, string> { { SellerProductRequestStatus.Approved, "A" }, { SellerProductRequestStatus.Processing, "P" }, { SellerProductRequestStatus.UnApproved, "D" }, { SellerProductRequestStatus.WaitApproval, "O" }, { SellerProductRequestStatus.Finish, "F" } }); EnumCodeMapper.AddMap(new Dictionary <SellerProductRequestType, string> { { SellerProductRequestType.NewCreated, "N" }, { SellerProductRequestType.ParameterUpdate, "P" }, { SellerProductRequestType.ImageAndDescriptionUpdate, "I" } }); EnumCodeMapper.AddMap(new Dictionary <SellerProductRequestTakePictures, string> { { SellerProductRequestTakePictures.Yes, "Y" }, { SellerProductRequestTakePictures.No, "N" } }); EnumCodeMapper.AddMap(new Dictionary <SellerProductRequestFileType, string> { { SellerProductRequestFileType.Image, "I" }, { SellerProductRequestFileType.Text, "P" } }); EnumCodeMapper.AddMap(new Dictionary <SellerProductRequestFileStatus, string> { { SellerProductRequestFileStatus.WaitProcess, "O" }, { SellerProductRequestFileStatus.Finish, "F" } }); EnumCodeMapper.AddMap(new Dictionary <ProductPriceRequestStatus, int> { { ProductPriceRequestStatus.Origin, 0 }, { ProductPriceRequestStatus.Approved, 1 }, { ProductPriceRequestStatus.Deny, -1 }, { ProductPriceRequestStatus.Canceled, -2 }, { ProductPriceRequestStatus.NeedSeniorApprove, 9 }, }); EnumCodeMapper.AddMap(new Dictionary <ProductPriceRequestAuditType, string> { { ProductPriceRequestAuditType.Audit, "T" }, { ProductPriceRequestAuditType.SeniorAudit, "P" } }); EnumCodeMapper.AddMap(new Dictionary <ProductIsTakePicture, string> { { ProductIsTakePicture.Yes, "Y" }, { ProductIsTakePicture.No, "N" } }); EnumCodeMapper.AddMap(new Dictionary <SellerProductRequestOfferInvoice, string> { { SellerProductRequestOfferInvoice.Yes, "Y" }, { SellerProductRequestOfferInvoice.No, "N" } }); EnumCodeMapper.AddMap(new Dictionary <ProductStatus, int> { { ProductStatus.Abandon, -1 }, { ProductStatus.Active, 1 }, { ProductStatus.InActive_Show, 0 }, { ProductStatus.InActive_UnShow, 2 } }); EnumCodeMapper.AddMap(new Dictionary <IsDefault, int> { { IsDefault.Active, 0 }, { IsDefault.DeActive, 1 } }); EnumCodeMapper.AddMap(new Dictionary <TimelyPromotionTitleStatus, string> { { TimelyPromotionTitleStatus.Original, "O" }, { TimelyPromotionTitleStatus.Active, "A" }, { TimelyPromotionTitleStatus.DeActive, "D" } }); EnumCodeMapper.AddMap(new Dictionary <ProductIsVirtualPic, string> { { ProductIsVirtualPic.Yes, "Y" }, { ProductIsVirtualPic.No, "N" } }); EnumCodeMapper.AddMap(new Dictionary <ProductIsAccessoryShow, string> { { ProductIsAccessoryShow.Yes, "Y" }, { ProductIsAccessoryShow.No, "N" } }); EnumCodeMapper.AddMap(new Dictionary <NotifyStatus, int> { { NotifyStatus.NotifyYes, 1 }, { NotifyStatus.NotifyBad, -1 }, { NotifyStatus.NotifyNo, 0 } }); EnumCodeMapper.AddMap(new Dictionary <ProductInfoFinishStatus, string> { { ProductInfoFinishStatus.Yes, "Y" }, { ProductInfoFinishStatus.No, "N" } }); EnumCodeMapper.AddMap(new Dictionary <ThirdPartner, string> { { ThirdPartner.Hengzhong, "H" }, { ThirdPartner.Xijie, "X" }, { ThirdPartner.Belle, "B" }, { ThirdPartner.Yieke, "Y" }, { ThirdPartner.Ingrammicro, "I" } }); EnumCodeMapper.AddExtraCodeMap(new Dictionary <StockRules, object[]> { { StockRules.Limit, new object[] { "L" } }, { StockRules.Direct, new object[] { "U" } }, { StockRules.Customer, new object[] { "C", "T", "D" } }, }); EnumCodeMapper.AddMap(new Dictionary <ProductMappingStatus, string> { { ProductMappingStatus.Active, "A" }, { ProductMappingStatus.DeActive, "D" } }); EnumCodeMapper.AddMap(new Dictionary <IsUseAlipayVipPrice, string> { { IsUseAlipayVipPrice.Yes, "Y" }, { IsUseAlipayVipPrice.No, "N" } }); EnumCodeMapper.AddMap(new Dictionary <IsAutoAdjustPrice, int> { { IsAutoAdjustPrice.Yes, 1 }, { IsAutoAdjustPrice.No, 0 } }); EnumCodeMapper.AddMap(new Dictionary <InventorySync, string> { { InventorySync.Yes, "Y" }, { InventorySync.No, "N" } }); EnumCodeMapper.AddMap(new Dictionary <BooleanEnum, string> { { BooleanEnum.Yes, "Y" }, { BooleanEnum.No, "N" } }); EnumCodeMapper.AddMap(new Dictionary <ProductChannelInfoStatus, string> { { ProductChannelInfoStatus.Active, "A" }, { ProductChannelInfoStatus.DeActive, "D" } }); EnumCodeMapper.AddMap(new Dictionary <ProductChannelPeriodPriceStatus, string> { { ProductChannelPeriodPriceStatus.Finish, "F" }, { ProductChannelPeriodPriceStatus.Init, "O" }, { ProductChannelPeriodPriceStatus.Abandon, "D" }, { ProductChannelPeriodPriceStatus.Ready, "R" }, { ProductChannelPeriodPriceStatus.Running, "A" }, { ProductChannelPeriodPriceStatus.WaitApproved, "P" } }); EnumCodeMapper.AddMap(new Dictionary <AuthorizedStatus, string> { { AuthorizedStatus.Active, "A" }, { AuthorizedStatus.DeActive, "D" } }); EnumCodeMapper.AddMap(new Dictionary <UnicomContractPhoneNumberStatus, string> { { UnicomContractPhoneNumberStatus.Active, "A" }, { UnicomContractPhoneNumberStatus.DeActive, "D" }, { UnicomContractPhoneNumberStatus.CreateOrder, "S" } }); EnumCodeMapper.AddMap(new Dictionary <CategoryTemplateType, int> { { CategoryTemplateType.TemplateProductTitle, 0 }, { CategoryTemplateType.TemplateProductDescription, 1 }, { CategoryTemplateType.TemplateProductName, 2 }, { CategoryTemplateType.TemplateWeb, 3 } }); EnumCodeMapper.AddMap(new Dictionary <RmaPolicyType, string> { { RmaPolicyType.DiscountType, "D" }, { RmaPolicyType.ExtendType, "E" }, { RmaPolicyType.ManufacturerType, "M" }, { RmaPolicyType.StandardType, "P" }, { RmaPolicyType.SellerType, "S" } }); EnumCodeMapper.AddMap(new Dictionary <RmaPolicyStatus, string> { { RmaPolicyStatus.Active, "A" }, { RmaPolicyStatus.DeActive, "D" }, }); EnumCodeMapper.AddMap(new Dictionary <IsOnlineRequst, string> { { IsOnlineRequst.YES, "Y" }, { IsOnlineRequst.NO, "N" }, }); EnumCodeMapper.AddMap(new Dictionary <RmaLogActionType, string> { { RmaLogActionType.Create, "C" }, { RmaLogActionType.Active, "A" }, { RmaLogActionType.DeActive, "D" }, { RmaLogActionType.Edit, "E" }, }); EnumCodeMapper.AddMap(new Dictionary <CollectDateType, string> { { CollectDateType.ExpiredDate, "E" }, { CollectDateType.ManufactureDate, "P" } }); EnumCodeMapper.AddMap(new Dictionary <GiftVoucherRelateProductStatus, string> { { GiftVoucherRelateProductStatus.Active, "A" }, { GiftVoucherRelateProductStatus.Deactive, "D" } }); EnumCodeMapper.AddMap(new Dictionary <GiftVoucherProductStatus, int> { { GiftVoucherProductStatus.AuditFail, -2 }, { GiftVoucherProductStatus.Void, -1 }, { GiftVoucherProductStatus.WaittingAudit, 1 }, { GiftVoucherProductStatus.Audit, 2 } }); EnumCodeMapper.AddMap(new Dictionary <GVRReqType, int> { { GVRReqType.Add, 0 }, { GVRReqType.Delete, 1 } }); EnumCodeMapper.AddMap(new Dictionary <GVRReqAuditStatus, string> { { GVRReqAuditStatus.AuditWaitting, "W" }, { GVRReqAuditStatus.AuditFailed, "F" }, { GVRReqAuditStatus.AuditSuccess, "S" } }); }
public void Start() { EnumCodeMapper.AddMap <FeatureType>(new Dictionary <FeatureType, string> { { FeatureType.New, "N" }, { FeatureType.Hot, "H" } }); EnumCodeMapper.AddMap <GroupBuyingStatus>(new Dictionary <GroupBuyingStatus, string> { { GroupBuyingStatus.Init, "O" }, { GroupBuyingStatus.WaitingAudit, "W" }, { GroupBuyingStatus.VerifyFaild, "N" }, { GroupBuyingStatus.Pending, "P" }, { GroupBuyingStatus.WaitHandling, "R" }, { GroupBuyingStatus.Active, "A" }, { GroupBuyingStatus.Deactive, "D" }, { GroupBuyingStatus.Finished, "F" } }); EnumCodeMapper.AddMap <CountdownStatus>(new Dictionary <CountdownStatus, int> { { CountdownStatus.Abandon, -1 }, { CountdownStatus.WaitForVerify, -3 }, { CountdownStatus.VerifyFaild, -4 }, { CountdownStatus.Ready, 0 }, { CountdownStatus.Running, 1 }, { CountdownStatus.Finish, 2 }, { CountdownStatus.Interupt, -2 }, { CountdownStatus.Init, -5 } }); EnumCodeMapper.AddMap <ADStatus>(new Dictionary <ADStatus, string> { { ADStatus.Deactive, "D" }, { ADStatus.Active, "A" } }); EnumCodeMapper.AddMap <IsDefaultStatus>(new Dictionary <IsDefaultStatus, string> { { IsDefaultStatus.Deactive, "D" }, { IsDefaultStatus.Active, "A" } }); EnumCodeMapper.AddMap <ADTStatus>(new Dictionary <ADTStatus, string> { { ADTStatus.Deactive, "D" }, { ADTStatus.Active, "A" }, { ADTStatus.Test, "T" } }); EnumCodeMapper.AddMap <RemarksType>(new Dictionary <RemarksType, string> { { RemarksType.Promotion, "R" }, { RemarksType.Comment, "P" }, { RemarksType.Discuss, "D" }, { RemarksType.Consult, "C" } }); EnumCodeMapper.AddMap <RemarkTypeShow>(new Dictionary <RemarkTypeShow, int> { { RemarkTypeShow.Auto, 0 }, { RemarkTypeShow.Manual, -1 } }); EnumCodeMapper.AddMap <YNStatus>(new Dictionary <YNStatus, string> { { YNStatus.No, "N" }, { YNStatus.Yes, "Y" } }); EnumCodeMapper.AddMap <IsDefaultShow>(new Dictionary <IsDefaultShow, string> { { IsDefaultShow.Show, "Y" }, { IsDefaultShow.Hide, "N" } }); EnumCodeMapper.AddMap <GroupBuyingStatusForNeweggg>(new Dictionary <GroupBuyingStatusForNeweggg, string> { { GroupBuyingStatusForNeweggg.WaitingAudit, "O" }, { GroupBuyingStatusForNeweggg.Pending, "P" }, { GroupBuyingStatusForNeweggg.Active, "A" }, { GroupBuyingStatusForNeweggg.Finished, "F" }, { GroupBuyingStatusForNeweggg.Deactive, "D" }, }); EnumCodeMapper.AddMap <BannerType>(new Dictionary <BannerType, string> { { BannerType.Image, "I" }, { BannerType.Flash, "F" }, { BannerType.HTML, "H" }, { BannerType.Text, "T" }, { BannerType.Video, "V" } }); EnumCodeMapper.AddMap <ModuleType>(new Dictionary <ModuleType, int> { { ModuleType.Banner, 0 }, { ModuleType.SEO, 1 }, { ModuleType.ProductRecommend, 2 }, { ModuleType.HotSale, 3 }, { ModuleType.Poll, 4 }, { ModuleType.HotKeywords, 5 }, { ModuleType.DefaultKeywords, 6 } }); EnumCodeMapper.AddMap <CouponsMKTType>(new Dictionary <CouponsMKTType, string> { { CouponsMKTType.MKTAFC, "F" }, { CouponsMKTType.MKTAmbassador, "A" }, { CouponsMKTType.MKTBD, "B" }, { CouponsMKTType.MKTCS, "C" }, { CouponsMKTType.MKTEmail, "M" }, { CouponsMKTType.MKTInternal, "N" }, { CouponsMKTType.MKTNetworkAlliance, "W" }, { CouponsMKTType.MKTOffline, "L" }, { CouponsMKTType.MKTOnline, "O" }, { CouponsMKTType.MKTPM, "P" }, { CouponsMKTType.MKTPlace, "S" } }); EnumCodeMapper.AddMap <CouponsStatus>(new Dictionary <CouponsStatus, string> { { CouponsStatus.Finish, "F" }, { CouponsStatus.Init, "O" }, { CouponsStatus.Ready, "R" }, { CouponsStatus.Run, "A" }, { CouponsStatus.Void, "D" }, { CouponsStatus.WaitingAudit, "W" }, { CouponsStatus.Stoped, "S" } }); EnumCodeMapper.AddMap <OpenAPIStatus>(new Dictionary <OpenAPIStatus, string> { { OpenAPIStatus.Active, "A" }, { OpenAPIStatus.Deactive, "D" } }); //公告及促销评论状态 EnumCodeMapper.AddMap <NewsAdvReplyStatus>(new Dictionary <NewsAdvReplyStatus, int> { { NewsAdvReplyStatus.Show, 0 }, { NewsAdvReplyStatus.SystemHide, -1 }, { NewsAdvReplyStatus.HandHide, -2 } }); EnumCodeMapper.AddMap <CouponsProductRangeType>(new Dictionary <CouponsProductRangeType, string> { { CouponsProductRangeType.AllProducts, "A" }, { CouponsProductRangeType.LimitCategoryBrand, "X" }, { CouponsProductRangeType.LimitProduct, "I" } }); EnumCodeMapper.AddMap <CouponsBindConditionType>(new Dictionary <CouponsBindConditionType, string> { { CouponsBindConditionType.None, "A" }, { CouponsBindConditionType.Rigester, "R" }, { CouponsBindConditionType.Birthday, "B" }, { CouponsBindConditionType.SO, "O" }, { CouponsBindConditionType.Get, "L" } //{CouponsBindConditionType.Alipay,"Z"} }); EnumCodeMapper.AddMap <CouponsValidPeriodType>(new Dictionary <CouponsValidPeriodType, int> { { CouponsValidPeriodType.All, 0 }, { CouponsValidPeriodType.PublishDayToOneWeek, 1 }, { CouponsValidPeriodType.PublishDayToOneMonth, 2 }, { CouponsValidPeriodType.PublishDayToTwoMonths, 3 }, { CouponsValidPeriodType.PublishDayToThreeMonths, 4 }, { CouponsValidPeriodType.PublishDayToSixMonths, 5 }, { CouponsValidPeriodType.CustomPeriod, 6 } }); EnumCodeMapper.AddMap <CouponsRuleType>(new Dictionary <CouponsRuleType, string> { { CouponsRuleType.ProductDiscount, "D" } }); EnumCodeMapper.AddMap <CouponCodeType>(new Dictionary <CouponCodeType, string> { { CouponCodeType.Common, "C" }, { CouponCodeType.ThrowIn, "T" } }); EnumCodeMapper.AddMap <CouponCodeUsedStatus>(new Dictionary <CouponCodeUsedStatus, string> { { CouponCodeUsedStatus.Active, "A" }, { CouponCodeUsedStatus.Deactive, "D" } }); EnumCodeMapper.AddMap <PSDiscountTypeForOrderAmount>(new Dictionary <PSDiscountTypeForOrderAmount, string> { { PSDiscountTypeForOrderAmount.OrderAmountDiscount, "D" }, { PSDiscountTypeForOrderAmount.OrderAmountPercentage, "P" } }); EnumCodeMapper.AddMap <PSDiscountTypeForProductPrice>(new Dictionary <PSDiscountTypeForProductPrice, string> { { PSDiscountTypeForProductPrice.ProductPriceDiscount, "Z" }, { PSDiscountTypeForProductPrice.ProductPriceFinal, "F" } }); EnumCodeMapper.AddMap <SOStatus>(new Dictionary <SOStatus, int> { { SOStatus.Split, -6 }, { SOStatus.Abandon, -1 }, { SOStatus.Origin, 0 }, { SOStatus.WaitingOutStock, 1 }, { SOStatus.Shipping, 10 }, { SOStatus.WaitingManagerAudit, 3 }, { SOStatus.OutStock, 4 }, { SOStatus.Reported, 41 }, { SOStatus.CustomsPass, 45 }, { SOStatus.Complete, 5 }, { SOStatus.Reject, 6 }, { SOStatus.CustomsReject, 65 }, { SOStatus.ShippingReject, 7 } }); EnumCodeMapper.AddMap <CommentProcessStatus>(new Dictionary <CommentProcessStatus, int> { { CommentProcessStatus.Finish, 2 }, { CommentProcessStatus.Handling, 1 }, { CommentProcessStatus.Invalid, -1 }, { CommentProcessStatus.WaitHandling, 0 } }); EnumCodeMapper.AddMap <KeywordsStatus>(new Dictionary <KeywordsStatus, string> { { KeywordsStatus.All, "R" }, { KeywordsStatus.Passed, "A" }, { KeywordsStatus.Reject, "D" }, { KeywordsStatus.Waiting, "O" } }); EnumCodeMapper.AddMap <ReplyVendor>(new Dictionary <ReplyVendor, string> { { ReplyVendor.YES, "M" }, { ReplyVendor.NO, "N" } }); EnumCodeMapper.AddMap <PollType>(new Dictionary <PollType, string> { { PollType.Single, "S" }, { PollType.Multiple, "M" }, { PollType.ShortAnswer, "A" }, { PollType.Other, "C" } }); EnumCodeMapper.AddMap <SaleGiftStatus>(new Dictionary <SaleGiftStatus, string> { { SaleGiftStatus.Finish, "F" }, { SaleGiftStatus.Init, "O" }, { SaleGiftStatus.Ready, "R" }, { SaleGiftStatus.Run, "A" }, { SaleGiftStatus.Void, "D" }, { SaleGiftStatus.WaitingAudit, "P" }, { SaleGiftStatus.Stoped, "S" } }); EnumCodeMapper.AddExtraCodeMap <SaleGiftStatus>(SaleGiftStatus.WaitingAudit, new object[] { "P", "W" }); EnumCodeMapper.AddMap <SaleGiftType>(new Dictionary <SaleGiftType, string> { { SaleGiftType.Full, "F" }, { SaleGiftType.Multiple, "M" }, { SaleGiftType.Single, "S" }, { SaleGiftType.Vendor, "V" }, //{SaleGiftType.FirstOrder,"O"}, //{SaleGiftType.Additional,"B"} }); EnumCodeMapper.AddMap <SaleGiftDiscountBelongType>(new Dictionary <SaleGiftDiscountBelongType, string> { { SaleGiftDiscountBelongType.BelongGiftItem, "G" }, { SaleGiftDiscountBelongType.BelongMasterItem, "M" } }); EnumCodeMapper.AddMap <SaleGiftSaleRuleType>(new Dictionary <SaleGiftSaleRuleType, string> { { SaleGiftSaleRuleType.Brand, "B" }, { SaleGiftSaleRuleType.BrandC3Combo, "C" }, { SaleGiftSaleRuleType.C3, "L" }, { SaleGiftSaleRuleType.Item, "I" } }); EnumCodeMapper.AddMap <SaleGiftGiftItemType>(new Dictionary <SaleGiftGiftItemType, string> { { SaleGiftGiftItemType.GiftPool, "O" }, { SaleGiftGiftItemType.AssignGift, "A" } }); ///捆绑方式,是组合捆绑M还是交叉捆绑S EnumCodeMapper.AddMap <SaleGiftCombineType>(new Dictionary <SaleGiftCombineType, string> { { SaleGiftCombineType.Assemble, "M" }, { SaleGiftCombineType.Cross, "S" } }); EnumCodeMapper.AddMap <AndOrType>(new Dictionary <AndOrType, string> { { AndOrType.Or, "O" }, { AndOrType.And, "A" }, { AndOrType.Not, "N" } }); EnumCodeMapper.AddMap <ThesaurusWordsType>(new Dictionary <ThesaurusWordsType, string> { { ThesaurusWordsType.Doubleaction, "T" }, { ThesaurusWordsType.Monodirectional, "O" } }); EnumCodeMapper.AddMap <KeywordsOperateUserType>(new Dictionary <KeywordsOperateUserType, int> { { KeywordsOperateUserType.Customer, 1 }, { KeywordsOperateUserType.MKTUser, 0 } }); EnumCodeMapper.AddMap <ComboStatus>(new Dictionary <ComboStatus, int> { { ComboStatus.Active, 0 }, { ComboStatus.Deactive, -1 }, { ComboStatus.WaitingAudit, 1 } }); EnumCodeMapper.AddMap <ComboType>(new Dictionary <ComboType, int> { { ComboType.Common, 0 } //{ComboType.NYuanSend,1} }); EnumCodeMapper.AddMap <GroupType>(new Dictionary <GroupType, int> { { GroupType.Custom, 2 }, { GroupType.LevelOne, 3 }, { GroupType.LevelTwo, 0 }, { GroupType.LevelThree, 1 } }); EnumCodeMapper.AddMap <AreaRelationType>(new Dictionary <AreaRelationType, string> { { AreaRelationType.Banner, "B" }, { AreaRelationType.News, "N" } }); EnumCodeMapper.AddMap <ShowType>(new Dictionary <ShowType, string> { { ShowType.Table, "T" }, { ShowType.ImageText, "I" } }); EnumCodeMapper.AddMap <RecommendType>(new Dictionary <RecommendType, int> { { RecommendType.Normal, 0 }, //{RecommendType.Top,1}, //{RecommendType.ShowRecommendIcon,2} //{RecommendType.FiveItemPerRow,3}, //{RecommendType.EightItemLeft,4}, //{RecommendType.EightItemRight,5}, //{RecommendType.EightItemUpperLeft,6}, { RecommendType.SixItemLeft, 7 } }); //前台显示分类级别 EnumCodeMapper.AddMap <ECCategoryLevel>(new Dictionary <ECCategoryLevel, string> { { ECCategoryLevel.Category1, "H" }, { ECCategoryLevel.Category2, "M" }, { ECCategoryLevel.Category3, "L" } }); //产品价格举报状态 EnumCodeMapper.AddMap <ProductPriceCompareStatus>(new Dictionary <ProductPriceCompareStatus, int> { { ProductPriceCompareStatus.WaitAudit, 0 }, { ProductPriceCompareStatus.AuditPass, 1 }, { ProductPriceCompareStatus.AuditDecline, 2 } }); //产品价格举报DisplayLinkStatus EnumCodeMapper.AddMap <DisplayLinkStatus>(new Dictionary <DisplayLinkStatus, int> { { DisplayLinkStatus.Hide, 0 }, { DisplayLinkStatus.Display, 1 } }); EnumCodeMapper.AddMap <SaleAdvStatus>(new Dictionary <SaleAdvStatus, int> { { SaleAdvStatus.Active, 0 }, { SaleAdvStatus.Deactive, -1 } }); EnumCodeMapper.AddMap <GroupBuyingSettlementStatus>(new Dictionary <GroupBuyingSettlementStatus, string> { { GroupBuyingSettlementStatus.MoreThan, "C" }, { GroupBuyingSettlementStatus.Yes, "Y" }, { GroupBuyingSettlementStatus.No, "N" } }); EnumCodeMapper.AddMap <GiftIsOnlineShow>(new Dictionary <GiftIsOnlineShow, string> { { GiftIsOnlineShow.Online, "Y" }, { GiftIsOnlineShow.Deline, "N" } }); EnumCodeMapper.AddMap <CouponLimitType>(new Dictionary <CouponLimitType, string> { { CouponLimitType.PanicBuying, "C" }, { CouponLimitType.Kill, "K" }, //{CouponLimitType.FriedEgg,"T"}, { CouponLimitType.GroupBuying, "G" }, { CouponLimitType.GiftCard, "L" }, { CouponLimitType.Manually, "M" } }); EnumCodeMapper.AddMap <ClearType>(new Dictionary <ClearType, string> { { ClearType.WaitClear, "W" }, { ClearType.CompleteClear, "F" } }); EnumCodeMapper.AddMap <DynamicCategoryType>(new Dictionary <DynamicCategoryType, Int32> { { DynamicCategoryType.Standard, 0 }, { DynamicCategoryType.WangJie, 1 } }); //EnumCodeMapper.AddMap<DynamicCategoryStatus>(new Dictionary<DynamicCategoryStatus, Int32> //{ // {DynamicCategoryStatus.Active,0}, // {DynamicCategoryStatus.Deactive,-1} //}); //限购规则类型 EnumCodeMapper.AddMap <LimitType>(new Dictionary <LimitType, Int32> { { LimitType.SingleProduct, 0 }, { LimitType.Combo, 1 } }); //限购规则状态 EnumCodeMapper.AddMap <LimitStatus>(new Dictionary <LimitStatus, Int32> { { LimitStatus.Invalid, 0 }, { LimitStatus.Valid, 1 } }); //销售立减规则类型 EnumCodeMapper.AddMap <SaleDiscountRuleType>(new Dictionary <SaleDiscountRuleType, Int32> { { SaleDiscountRuleType.AmountRule, 0 }, { SaleDiscountRuleType.QtyRule, 1 } }); //销售立减规则状态 EnumCodeMapper.AddMap <SaleDiscountRuleStatus>(new Dictionary <SaleDiscountRuleStatus, Int32> { { SaleDiscountRuleStatus.Invalid, 0 }, { SaleDiscountRuleStatus.Valid, 1 } }); //销售立减规则状态 EnumCodeMapper.AddMap <GroupBuyingCategoryType>(new Dictionary <GroupBuyingCategoryType, Int32> { { GroupBuyingCategoryType.Physical, 0 }, { GroupBuyingCategoryType.Virtual, 1 }, { GroupBuyingCategoryType.ZeroLottery, 2 } }); EnumCodeMapper.AddMap <GroupBuyingFeedbackStatus>(new Dictionary <GroupBuyingFeedbackStatus, Int32> { { GroupBuyingFeedbackStatus.UnRead, 0 }, { GroupBuyingFeedbackStatus.Readed, 1 } }); EnumCodeMapper.AddMap <BusinessCooperationStatus>(new Dictionary <BusinessCooperationStatus, Int32> { { BusinessCooperationStatus.UnHandled, 0 }, { BusinessCooperationStatus.Handled, 1 } }); EnumCodeMapper.AddMap <SettlementBillStatus>(new Dictionary <SettlementBillStatus, Int32> { { SettlementBillStatus.UnSettle, 0 }, { SettlementBillStatus.Settled, 1 } }); EnumCodeMapper.AddMap <GroupBuyingCategoryStatus>(new Dictionary <GroupBuyingCategoryStatus, Int32> { { GroupBuyingCategoryStatus.Valid, 0 }, { GroupBuyingCategoryStatus.InValid, -1 } }); }
public void Start() { EnumCodeMapper.AddMap <UserStatus>(new Dictionary <UserStatus, string> { { UserStatus.A, "A" }, { UserStatus.D, "D" } }); EnumCodeMapper.AddMap <RoleStatus>(new Dictionary <RoleStatus, string> { { RoleStatus.Active, "A" }, { RoleStatus.DeActive, "D" } }); EnumCodeMapper.AddMap <SettleOrderStatus>(new Dictionary <SettleOrderStatus, string> { { SettleOrderStatus.CLS, "CLS" }, { SettleOrderStatus.ORG, "ORG" }, { SettleOrderStatus.SET, "SET" } }); EnumCodeMapper.AddMap <CommissionType>(new Dictionary <CommissionType, string> { { CommissionType.DEF, "DEF" }, { CommissionType.SAC, "SAC" }, { CommissionType.SOC, "SOC" } }); EnumCodeMapper.AddMap <ProductRangeType>(new Dictionary <ProductRangeType, string> { { ProductRangeType.All, "A" }, { ProductRangeType.Limit, "I" } }); EnumCodeMapper.AddMap <RelationType>(new Dictionary <RelationType, string> { { RelationType.Y, "Y" }, { RelationType.N, "N" } }); EnumCodeMapper.AddMap <CouponStatus>(new Dictionary <CouponStatus, string> { { CouponStatus.Init, "O" }, { CouponStatus.WaitingAudit, "W" }, { CouponStatus.Ready, "R" }, { CouponStatus.Run, "A" }, { CouponStatus.Void, "D" }, { CouponStatus.Stoped, "S" }, { CouponStatus.Finish, "F" } }); EnumCodeMapper.AddMap <CouponDiscountRuleType>(new Dictionary <CouponDiscountRuleType, string> { { CouponDiscountRuleType.Discount, "D" }, { CouponDiscountRuleType.Percentage, "P" } }); EnumCodeMapper.AddMap <CouponsBindConditionType>(new Dictionary <CouponsBindConditionType, string> { { CouponsBindConditionType.None, "A" }, { CouponsBindConditionType.SO, "O" }, { CouponsBindConditionType.Get, "L" } }); EnumCodeMapper.AddMap <CouponValidPeriodType>(new Dictionary <CouponValidPeriodType, int> { { CouponValidPeriodType.All, 0 }, { CouponValidPeriodType.PublishDayToOneWeek, 1 }, { CouponValidPeriodType.PublishDayToOneMonth, 2 }, { CouponValidPeriodType.PublishDayToTwoMonths, 3 }, { CouponValidPeriodType.PublishDayToThreeMonths, 4 }, { CouponValidPeriodType.PublishDayToSixMonths, 5 }, { CouponValidPeriodType.CustomPeriod, 6 } }); EnumCodeMapper.AddMap <SaleGiftType>(new Dictionary <SaleGiftType, string> { { SaleGiftType.Single, "S" }, { SaleGiftType.Multiple, "M" }, { SaleGiftType.Full, "F" } //{ SaleGiftType.Vendor, "V" }, //{ SaleGiftType.Additional, "F" } }); EnumCodeMapper.AddMap <SaleGiftStatus>(new Dictionary <SaleGiftStatus, string> { { SaleGiftStatus.Origin, "O" }, { SaleGiftStatus.WaitingAudit, "P" }, { SaleGiftStatus.Ready, "R" }, { SaleGiftStatus.Run, "A" }, { SaleGiftStatus.Stoped, "S" }, { SaleGiftStatus.Finish, "F" }, { SaleGiftStatus.Void, "D" } }); EnumCodeMapper.AddMap <SaleGiftDiscountBelongType>(new Dictionary <SaleGiftDiscountBelongType, string> { { SaleGiftDiscountBelongType.BelongGiftItem, "G" }, { SaleGiftDiscountBelongType.BelongMasterItem, "M" } }); EnumCodeMapper.AddMap <Specified>(new Dictionary <Specified, string> { { Specified.Y, "Y" }, { Specified.N, "N" } }); EnumCodeMapper.AddMap <CouponCodeType>(new Dictionary <CouponCodeType, string> { { CouponCodeType.Common, "C" }, { CouponCodeType.ThrowIn, "T" } }); EnumCodeMapper.AddMap <AndOrType>(new Dictionary <AndOrType, string> { { AndOrType.And, "A" }, { AndOrType.Not, "N" } }); EnumCodeMapper.AddMap <CouponCodeUsedStatus>(new Dictionary <CouponCodeUsedStatus, string> { { CouponCodeUsedStatus.Active, "A" }, { CouponCodeUsedStatus.Deactive, "D" } }); EnumCodeMapper.AddMap <CustomerType>(new Dictionary <CustomerType, int> { { CustomerType.Personal, 0 }, { CustomerType.Enterprise, 1 }, { CustomerType.Campus, 2 }, { CustomerType.Media, 3 }, { CustomerType.Internal, 4 } }); EnumCodeMapper.AddExtraCodeMap <CustomerStatus>(CustomerStatus.InValid, -1); EnumCodeMapper.AddMap <SOPriceStatus>(new Dictionary <SOPriceStatus, string> { { SOPriceStatus.Original, "O" }, { SOPriceStatus.Deactivate, "D" } }); EnumCodeMapper.AddMap <ShippingStockType>(new Dictionary <ShippingStockType, string> { { ShippingStockType.MET, "MET" }, { ShippingStockType.NEG, "NEG" } }); EnumCodeMapper.AddMap <FreeShippingAmountSettingStatus>(new Dictionary <FreeShippingAmountSettingStatus, string> { { FreeShippingAmountSettingStatus.Active, "A" }, { FreeShippingAmountSettingStatus.DeActive, "D" } }); }
public void Start() { EnumCodeMapper.AddMap <ECCentral.BizEntity.PO.VendorInvoiceType>(new Dictionary <ECCentral.BizEntity.PO.VendorInvoiceType, string> { { ECCentral.BizEntity.PO.VendorInvoiceType.NEG, "NEG" }, { ECCentral.BizEntity.PO.VendorInvoiceType.MET, "MET" }, { ECCentral.BizEntity.PO.VendorInvoiceType.GUD, "GUD" } }); EnumCodeMapper.AddMap <ECCentral.BizEntity.PO.VendorShippingType>(new Dictionary <ECCentral.BizEntity.PO.VendorShippingType, string> { { ECCentral.BizEntity.PO.VendorShippingType.NEG, "NEG" }, { ECCentral.BizEntity.PO.VendorShippingType.MET, "MET" } }); EnumCodeMapper.AddMap <ECCentral.BizEntity.PO.VendorStockType>(new Dictionary <ECCentral.BizEntity.PO.VendorStockType, string> { { ECCentral.BizEntity.PO.VendorStockType.NEG, "NEG" }, { ECCentral.BizEntity.PO.VendorStockType.MET, "MET" }, { ECCentral.BizEntity.PO.VendorStockType.NAM, "NAM" } }); EnumCodeMapper.AddMap <GatherSettleStatus>(new Dictionary <GatherSettleStatus, string> { { GatherSettleStatus.ABD, "ABD" }, { GatherSettleStatus.ORG, "ORG" }, { GatherSettleStatus.AUD, "AUD" }, { GatherSettleStatus.SET, "SET" } }); EnumCodeMapper.AddMap <ECCentral.BizEntity.PO.ValidStatus>(new Dictionary <ECCentral.BizEntity.PO.ValidStatus, int> { { ECCentral.BizEntity.PO.ValidStatus.D, -1 }, { ECCentral.BizEntity.PO.ValidStatus.A, 0 } }); EnumCodeMapper.AddMap <ConsignToAccountLogStatus>(new Dictionary <ConsignToAccountLogStatus, string> { { ConsignToAccountLogStatus.Origin, "A" }, { ConsignToAccountLogStatus.SystemCreated, "S" }, { ConsignToAccountLogStatus.ManualCreated, "C" }, { ConsignToAccountLogStatus.Settled, "F" } }); EnumCodeMapper.AddMap <SettleType>(new Dictionary <SettleType, string> { { SettleType.O, "O" }, { SettleType.P, "P" } }); EnumCodeMapper.AddMap <ConsignToAccountType>(new Dictionary <ConsignToAccountType, string> { { ConsignToAccountType.Adjust, "AD" }, { ConsignToAccountType.Manual, "RMA" }, { ConsignToAccountType.RMA, "OR" }, { ConsignToAccountType.SO, "SO" } }); EnumCodeMapper.AddExtraCodeMap(ConsignToAccountType.Manual, new object[] { "IT" }); EnumCodeMapper.AddMap <PurchaseOrderETAHalfDayType>(new Dictionary <PurchaseOrderETAHalfDayType, string> { { PurchaseOrderETAHalfDayType.AM, "AM" }, { PurchaseOrderETAHalfDayType.PM, "PM" } }); EnumCodeMapper.AddMap <PurchaseOrderTaxRate>(new Dictionary <PurchaseOrderTaxRate, int> { { PurchaseOrderTaxRate.Percent000, 0 }, { PurchaseOrderTaxRate.Percent004, 4 }, { PurchaseOrderTaxRate.Percent006, 6 }, { PurchaseOrderTaxRate.Percent013, 13 }, { PurchaseOrderTaxRate.Percent017, 17 } }); EnumCodeMapper.AddMap <YNStatus>(new Dictionary <YNStatus, string> { { YNStatus.Yes, "Y" }, { YNStatus.NO, "N" } }); EnumCodeMapper.AddMap <VendorCommissionItemType>(new Dictionary <VendorCommissionItemType, string> { { VendorCommissionItemType.DEF, "DEF" }, { VendorCommissionItemType.SOC, "SOC" }, { VendorCommissionItemType.SAC, "SAC" } }); EnumCodeMapper.AddMap <VendorCommissionReferenceType>(new Dictionary <VendorCommissionReferenceType, string> { { VendorCommissionReferenceType.SO, "SO" }, { VendorCommissionReferenceType.RMA, "RMA" } }); EnumCodeMapper.AddMap <VendorRank>(new Dictionary <VendorRank, string> { { VendorRank.A, "A" }, { VendorRank.B, "B" }, { VendorRank.C, "C" } }); EnumCodeMapper.AddMap <ConsignSettleRuleStatus>(new Dictionary <ConsignSettleRuleStatus, string> { { ConsignSettleRuleStatus.Wait_Audit, "O" }, { ConsignSettleRuleStatus.Stop, "S" }, { ConsignSettleRuleStatus.Forbid, "F" }, { ConsignSettleRuleStatus.Enable, "E" }, { ConsignSettleRuleStatus.Disable, "D" }, { ConsignSettleRuleStatus.Available, "A" } }); EnumCodeMapper.AddMap <PurchaseOrderBatchInfoStatus>(new Dictionary <PurchaseOrderBatchInfoStatus, string> { { PurchaseOrderBatchInfoStatus.A, "A" }, { PurchaseOrderBatchInfoStatus.I, "I" }, { PurchaseOrderBatchInfoStatus.R, "R" } }); }
/// <summary> /// 查询配送方式-产品 /// </summary> /// <param name="filter"></param> /// <param name="totalCount"></param> /// <returns></returns> public DataTable QueryShipTypeProductList(ShipTypeProductQueryFilter filter, out int totalCount) { totalCount = 0; object _itemRange = null;; object _type = null; CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("ShipTypeProduct_QueryShipTypeProduct"); PagingInfoEntity pagingInfo = ToPagingInfo(filter.PagingInfo); using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingInfo, "SPI.SysNo DESC")) { if (filter.ShipTypeProductType.HasValue) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "SPI.[Type]", DbType.String, "@Type", QueryConditionOperatorType.Equal, EnumCodeMapper.TryGetCode(filter.ShipTypeProductType, out _type)); } sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "SPI.Description", DbType.String, "@Description", QueryConditionOperatorType.Like, filter.Description); if (filter.ProductRange.HasValue) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "SPI.ItemRange", DbType.String, "@ItemRange", QueryConditionOperatorType.Equal, EnumCodeMapper.TryGetCode(filter.ProductRange, out _itemRange)); } sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "SPI.ProductID", DbType.String, "@ProductID", QueryConditionOperatorType.Equal, filter.ProductID); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "SPM.ShipTypeSysNo", DbType.Int32, "@ShipTypeSysNo", QueryConditionOperatorType.Equal, filter.ShippingType); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "SPM.StockSysNo", DbType.Int32, "@StockSysNo", QueryConditionOperatorType.Equal, filter.WareHouse); cmd.CommandText = sqlBuilder.BuildQuerySql(); EnumColumnList EnumList = new EnumColumnList(); EnumList.Add("ItemRange", typeof(ECCentral.BizEntity.Common.ProductRange)); EnumList.Add("Type", typeof(ECCentral.BizEntity.Common.ShipTypeProductType)); DataTable dt = cmd.ExecuteDataTable(EnumList); totalCount = int.Parse(cmd.GetParameterValue("TotalCount").ToString()); return(dt); } }
public DataTable Query(OrderQueryFilter filter, out int totalCount) { PagingInfoEntity pagingEntity = new PagingInfoEntity(); pagingEntity.SortField = filter.PageInfo.SortBy; pagingEntity.MaximumRows = filter.PageInfo.PageSize; pagingEntity.StartRowIndex = filter.PageInfo.PageIndex * filter.PageInfo.PageSize; var cmd = DataCommandManager.CreateCustomDataCommandFromConfig("CPSOrderQuery"); StringBuilder whereStrSO = new StringBuilder("WHERE 1 = 1 "); StringBuilder whereStrRMA = new StringBuilder("WHERE 1 = 1 "); using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "SysNo DESC")) { //单据类型 object _type; if (filter.OrderType != null && EnumCodeMapper.TryGetCode(filter.OrderType, out _type)) { whereStrSO.Append(" AND csItem.Type = @Type "); whereStrRMA.Append(" AND csItem.Type = @Type "); cmd.AddInputParameter("@Type", DbType.String, filter.OrderType); } if (!string.IsNullOrEmpty(filter.OrderSysNoList)) { string orderSysNoList = filter.OrderSysNoList.Replace('.', ','); whereStrSO.Append(" AND csItem.OrderSysNo IN (" + orderSysNoList + ") "); whereStrRMA.Append(" AND csItem.OrderSysNo IN (" + orderSysNoList + ") "); } //主渠道名称 if (!string.IsNullOrEmpty(filter.MasterChannelID)) { whereStrSO.Append(" AND cpsUser.CustomerID = @MasterChannelID "); whereStrRMA.Append(" AND cpsUser.CustomerID = @MasterChannelID "); cmd.AddInputParameter("@MasterChannelID", DbType.String, filter.MasterChannelID); } //渠道来源【Source】 if (!string.IsNullOrEmpty(filter.SubChannelID)) { whereStrSO.Append(" AND channel.Source = @SubChannelID "); whereStrRMA.Append(" AND channel.Source = @SubChannelID "); cmd.AddInputParameter("@SubChannelID", DbType.String, filter.SubChannelID); } //下单时间【SO RMA创建时间】 if (filter.CreateDateBegin.HasValue) { whereStrSO.Append(" AND ippSO.OrderDate >= @CreateDateBegin "); whereStrRMA.Append(" AND cpsRMA.CreateTime >= @CreateDateBegin "); cmd.AddInputParameter("@CreateDateBegin", DbType.DateTime, filter.CreateDateBegin); } if (filter.CreateDateEnd.HasValue) { whereStrSO.Append(" AND ippSO.OrderDate < @CreateDateEnd "); whereStrRMA.Append(" AND cpsRMA.CreateTime < @CreateDateEnd "); cmd.AddInputParameter("@CreateDateEnd", DbType.DateTime, filter.CreateDateEnd.Value.AddDays(1)); } //交易完成日期 if (filter.FinishDateBegin.HasValue) { whereStrSO.Append(" AND ippSO.OutTime >= @FinishDateBegin "); whereStrRMA.Append(" AND cpsRMA.RefundTime >= @FinishDateBegin "); cmd.AddInputParameter("@FinishDateBegin", DbType.DateTime, filter.FinishDateBegin); } if (filter.FinishDateEnd.HasValue) { whereStrSO.Append(" AND ippSO.OutTime < @FinishDateEnd "); whereStrRMA.Append(" AND cpsRMA.RefundTime < @FinishDateEnd "); cmd.AddInputParameter("@FinishDateEnd", DbType.DateTime, filter.FinishDateEnd.Value.AddDays(1)); } //结算日期 if (filter.SettlementDateBegin.HasValue) { whereStrSO.Append(" AND csMaster.SettledTime >= @SettlementDateBegin "); whereStrRMA.Append(" AND csMaster.SettledTime >= @SettlementDateBegin "); cmd.AddInputParameter("@SettlementDateBegin", DbType.DateTime, filter.SettlementDateBegin); } if (filter.SettlementDateEnd.HasValue) { whereStrSO.Append(" AND csMaster.SettledTime < @SettlementDateEnd "); whereStrRMA.Append(" AND csMaster.SettledTime < @SettlementDateEnd "); cmd.AddInputParameter("@SettlementDateEnd", DbType.DateTime, filter.SettlementDateEnd.Value.AddDays(1)); } //结算状态 object _status; if (filter.SettledStatus != null && EnumCodeMapper.TryGetCode(filter.SettledStatus, out _status)) { whereStrSO.Append(" AND csItem.Status = @SettledStatus "); whereStrRMA.Append(" AND csItem.Status = @SettledStatus "); cmd.AddInputParameter("@SettledStatus", DbType.String, filter.SettledStatus); } cmd.CommandText = sqlBuilder.BuildQuerySql(); cmd.CommandText = cmd.CommandText.Replace("#StrWhereSO#", whereStrSO.ToString()); cmd.CommandText = cmd.CommandText.Replace("#StrWhereRMA#", whereStrRMA.ToString()); EnumColumnList enumList = new EnumColumnList(); enumList.Add("SettledStatus", typeof(FinanceStatus)); var dt = cmd.ExecuteDataTable(enumList); totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); if (totalCount > 0) { dt = this.GetOrderStatus(dt, "OrderStatus"); } return(dt); } }