public string GetFilterLayoutJs(string userId = "")
{
List <string> fileds = this.CanFilterFields(userId);
if (fileds == null || fileds.Count == 0)
{
return(string.Empty);
}
List <FilterField> filterFiledList = new List <FilterField>();
foreach (var item in fileds)
{
DataTable dt = this.DataSet.Tables[0];
if (dt.Columns[item] == null)
{
throw new Exception("字段不存在");
}
DefineField df = DataSourceHelper.ConvertToDefineField(dt.Columns[item]);
filterFiledList.Add(new FilterField(df.ControlType, df.Name, df.DisplayName));
}
if (this.Template.BillType == BillType.Rpt)
{
return(JsBuilder.BuildFilterFieldJs(filterFiledList));
}
else
{
// 主数据、单据、Grid
return(JsBuilder.BuildFilterFieldJsForBillListing(filterFiledList));
}
}
/// <summary>
/// Execute as list.
/// </summary>
/// <typeparam name="T">Given type of object</typeparam>
/// <param name="storedProcedureName">Store procedure name.</param>
/// <param name="parameterCollection">Accept Key Value collection for parameters.</param>
/// <returns>Type of list of object implementing.</returns>
public List <T> ExecuteAsList <T>(string storedProcedureName, List <KeyValuePair <string, object> > parameterCollection)
{
using (NpgsqlConnection conn = new NpgsqlConnection(ConnectionString))
{
NpgsqlCommand command = new NpgsqlCommand();
command.Connection = conn;
command.CommandText = storedProcedureName;
command.CommandType = CommandType.StoredProcedure;
for (int i = 0; i < parameterCollection.Count; i++)
{
NpgsqlParameter sqlParaMeter = new NpgsqlParameter();
sqlParaMeter.IsNullable = true;
sqlParaMeter.ParameterName = parameterCollection[i].Key;
sqlParaMeter.Value = parameterCollection[i].Value;
command.Parameters.Add(sqlParaMeter);
}
conn.Open();
NpgsqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
List <T> mList = new List <T>();
mList = DataSourceHelper.FillCollection <T>(reader);
if (reader != null)
{
reader.Close();
}
reader.Close();
return(mList);
}
}
public async Task <PageLayoutViewModel> GetLayoutElement(string pageName, int siteID)
{
var ds = await new BlockDataProvider().GetLayoutElement(pageName, siteID);
PageLayoutViewModel obj = new PageLayoutViewModel()
{
Elements = new List <LayoutElements>(),
};
IList <LayoutElement> lstElements = DataSourceHelper.FillCollection <LayoutElement>(ds.Tables[0]);
IList <ViewModule> lstModule = DataSourceHelper.FillCollection <ViewModule>(ds.Tables[1]);
foreach (var e in lstElements)
{
if (e.HasInnerElement)
{
LayoutElements ele = CreateElements(e);
ele.InnerElements = GetInnerElement(e.ElementID, lstElements, lstModule);
obj.Elements.Add(ele);
}
else
{
break;
}
}
return(obj);
}
public void InitalizingMapPresenterWithNonEmptyMapHasUndefinedView()
{
MockRepository mocks = new MockRepository();
Map map = new Map(_factories.GeoFactory);
map.AddLayer(DataSourceHelper.CreateFeatureFeatureLayer(_factories.GeoFactory));
IMapView2D mapView = mocks.Stub <IMapView2D>();
SetupResult.For(mapView.Dpi).Return(ScreenHelper.Dpi);
mapView.ViewSize = new Size2D(1000, 1000);
mocks.ReplayAll();
TestPresenter2D mapPresenter = new TestPresenter2D(map, mapView);
//Assert.Equal(map.Center[Ordinates.X], mapPresenter.GeoCenter[Ordinates.X]);
//Assert.Equal(map.Center[Ordinates.Y], mapPresenter.GeoCenter[Ordinates.Y]);
Assert.Equal(0, mapPresenter.WorldWidth);
Assert.Equal(0, mapPresenter.WorldHeight);
Assert.Equal(0, mapPresenter.WorldUnitsPerPixel);
Assert.Equal(1, mapPresenter.WorldAspectRatio);
Assert.Equal(0, mapPresenter.PixelWorldWidth);
Assert.Equal(0, mapPresenter.PixelWorldHeight);
Assert.Equal(null, mapPresenter.ToViewTransform);
Assert.Equal(null, mapPresenter.ToWorldTransform);
}
public void MovingRowTriggersViewListChangedItemMovedNotification()
{
// TODO: implement MovingRowTriggersViewListChangedItemMovedNotification
FeatureProvider data = DataSourceHelper.CreateFeatureDatasource(_factories.GeoFactory);
FeatureDataTable table = new FeatureDataTable(_factories.GeoFactory);
IExtents halfBounds = data.GetExtents();
halfBounds.Scale(0.5);
FeatureQueryExpression query = FeatureQueryExpression.Intersects(data.GetExtents());
IFeatureDataReader reader = data.ExecuteFeatureQuery(query);
table.Load(reader, LoadOption.OverwriteChanges, null);
FeatureDataView view = new FeatureDataView(table);
Boolean addNotificationOccured = false;
view.ListChanged += delegate(Object sender, ListChangedEventArgs e)
{
if (e.ListChangedType == ListChangedType.ItemMoved)
{
addNotificationOccured = true;
}
};
Assert.True(addNotificationOccured);
}
public void SettingOidFilterAllowsOnlyFeaturesContainingFilteredOidsInView()
{
FeatureProvider data = DataSourceHelper.CreateFeatureDatasource(_factories.GeoFactory);
FeatureDataTable <Guid> table = new FeatureDataTable <Guid>("Oid", _factories.GeoFactory);
FeatureQueryExpression query = FeatureQueryExpression.Intersects(data.GetExtents());
IFeatureDataReader reader = data.ExecuteFeatureQuery(query);
table.Load(reader, LoadOption.OverwriteChanges, null);
Guid[] ids = new Guid[3];
ids[0] = (table.Rows[1] as FeatureDataRow <Guid>).Id;
ids[1] = (table.Rows[4] as FeatureDataRow <Guid>).Id;
ids[2] = (table.Rows[6] as FeatureDataRow <Guid>).Id;
FeatureDataView view = new FeatureDataView(table);
view.OidFilter = new OidCollectionExpression(ids);
Assert.Equal(3, view.Count);
Assert.True(view.Find(ids[0]) > -1);
Assert.True(view.Find(ids[1]) > -1);
Assert.True(view.Find(ids[2]) > -1);
Assert.Equal(-1, view.Find((table.Rows[0] as FeatureDataRow <Guid>).Id));
Assert.Equal(-1, view.Find((table.Rows[2] as FeatureDataRow <Guid>).Id));
Assert.Equal(-1, view.Find((table.Rows[3] as FeatureDataRow <Guid>).Id));
Assert.Equal(-1, view.Find((table.Rows[5] as FeatureDataRow <Guid>).Id));
}
public void ChangeViewSpatialFilterTriggersNotification()
{
FeatureProvider data = DataSourceHelper.CreateFeatureDatasource(_factories.GeoFactory);
FeatureDataTable table = new FeatureDataTable(_factories.GeoFactory);
FeatureQueryExpression query = FeatureQueryExpression.Intersects(data.GetExtents());
IFeatureDataReader reader = data.ExecuteFeatureQuery(query);
table.Load(reader, LoadOption.OverwriteChanges, null);
FeatureDataView view = new FeatureDataView(table);
Boolean resetNotificationOccured = false;
view.ListChanged += delegate(Object sender, ListChangedEventArgs e)
{
if (e.ListChangedType == ListChangedType.Reset)
{
resetNotificationOccured = true;
}
};
Assert.False(resetNotificationOccured);
IExtents queryExtents = _factories.GeoFactory.CreateExtents2D(0, 0, 10, 10);
SpatialBinaryExpression expression = SpatialBinaryExpression.Intersects(queryExtents);
view.SpatialFilter = expression;
Assert.True(resetNotificationOccured);
}
public void AddingRowToTableTriggersViewListChangedItemAddedNotification()
{
FeatureProvider data = DataSourceHelper.CreateFeatureDatasource(_factories.GeoFactory);
FeatureDataTable table = new FeatureDataTable(_factories.GeoFactory);
IExtents halfBounds = data.GetExtents();
halfBounds.Scale(0.5);
FeatureQueryExpression query = FeatureQueryExpression.Intersects(halfBounds);
IFeatureDataReader reader = data.ExecuteFeatureQuery(query);
table.Load(reader, LoadOption.OverwriteChanges, null);
FeatureDataView view = new FeatureDataView(table);
Boolean addNotificationOccured = false;
view.ListChanged += delegate(Object sender, ListChangedEventArgs e)
{
if (e.ListChangedType == ListChangedType.ItemAdded)
{
addNotificationOccured = true;
}
};
FeatureDataRow row = table.NewRow();
row["Oid"] = Guid.NewGuid();
row["FeatureName"] = "New row";
row.Geometry = _factories.GeoFactory.CreatePoint2D(44, 44);
table.AddRow(row);
Assert.True(addNotificationOccured);
}
public void ChangeViewSpatialFilterReturnsOnlyFilteredRows()
{
FeatureProvider data = DataSourceHelper.CreateFeatureDatasource(_factories.GeoFactory);
FeatureDataTable table = new FeatureDataTable(_factories.GeoFactory);
FeatureQueryExpression query = FeatureQueryExpression.Intersects(data.GetExtents());
IFeatureDataReader reader = data.ExecuteFeatureQuery(query);
table.Load(reader);
IGeometry queryExtents = _factories.GeoFactory.CreateExtents2D(0, 0, 10, 10).ToGeometry();
List <FeatureDataRow> expectedRows = new List <FeatureDataRow>();
foreach (FeatureDataRow row in table)
{
IGeometry g = row.Geometry;
if (queryExtents.Intersects(g))
{
expectedRows.Add(row);
}
}
FeatureDataView view = new FeatureDataView(table);
SpatialBinaryExpression expression = SpatialBinaryExpression.Intersects(queryExtents);
view.SpatialFilter = expression;
Assert.Equal(expectedRows.Count, view.Count);
}
public void ChangeViewAttributeFilterTriggersNotification()
{
FeatureProvider data = DataSourceHelper.CreateFeatureDatasource(_factories.GeoFactory);
FeatureDataTable table = new FeatureDataTable(_factories.GeoFactory);
FeatureQueryExpression query = FeatureQueryExpression.Intersects(data.GetExtents());
IFeatureDataReader reader = data.ExecuteFeatureQuery(query);
table.Load(reader, LoadOption.OverwriteChanges, null);
FeatureDataView view = new FeatureDataView(table);
Boolean resetNotificationOccured = false;
view.ListChanged += delegate(Object sender, ListChangedEventArgs e)
{
if (e.ListChangedType == ListChangedType.Reset)
{
resetNotificationOccured = true;
}
};
Assert.False(resetNotificationOccured);
Assert.Throws <NotSupportedException>(delegate { view.RowFilter = "FeatureName LIKE 'A m*'"; });
Assert.True(resetNotificationOccured);
}
//GetInterestForCampaign
public async Task <IList <InterestInfo> > GetInterestForCampaign(int SiteID)
{
NL_Provider provider = new NL_Provider();
DataSet ds = await provider.GetInterestForCampaign(SiteID);
List <InterestInfo> finalList = new List <InterestInfo>();
IList <InterestTempInfo> infos = new List <InterestTempInfo>();
if (ds.Tables.Count > 0)
{
infos = DataSourceHelper.FillCollection <InterestTempInfo>(ds.Tables[0]);
List <string> appNames = infos.Select(x => x.AppName).Distinct().ToList();
foreach (string appName in appNames)
{
List <InterestTempInfo> tempInfos = infos.ToList <InterestTempInfo>().FindAll(x => x.AppName == appName);
List <string> categories = tempInfos.Select(x => x.CategoryName).Distinct().ToList();
foreach (string category in categories)
{
List <InterestTempInfo> tempCatInfos = tempInfos.FindAll(x => x.CategoryName == category);
List <string> keywords = tempCatInfos.Select(x => x.KeyWord).ToList();
InterestInfo objInfo = new InterestInfo();
objInfo.AppName = appName;
objInfo.CategoryName = category;
objInfo.KeyWordList = keywords;
finalList.Add(objInfo);
}
}
}
return(finalList);
}
private void Initialization()
{
if (tableDataSource == null)
{
DataTable filterRefTable = DataSourceHelper.GetDataTable(DataSource);
// Initialization SessionWorker
if (SessionWorker == null)
{
var sw = new SessionWorker {
Key = Guid.NewGuid().ToString()
};
sw.SetSession(HttpContext.Current.Session);
sw.Object = filterRefTable.DataSet;
SessionWorker = sw;
}
// Initialization tableDataSource
Type tableAdapterType =
TableAdapterTools.GetTableAdapterType(filterRefTable.GetType());
tableDataSource = new TableDataSource
{
ID = "tableDataSource_ID",
TypeName = tableAdapterType.FullName,
SelectMethod = this._storage.SelectMethod,
FillType = TableDataSourceFillType.ParametersNotChanged,
SessionWorker = this.SessionWorker,
SetFilterByCustomConditions = false,
};
tableDataSource.View.CustomConditions.AddRange(_storage.CustomConditions);
}
}
public void RenderFeatureTest()
{
IFeatureProvider provider = DataSourceHelper.CreateGeometryDatasource(_factories.GeoFactory);
TestVectorRenderer vectorRenderer = new TestVectorRenderer();
BasicGeometryRenderer2D <RenderObject> geometryRenderer =
new BasicGeometryRenderer2D <RenderObject>(vectorRenderer);
FeatureDataTable features = new FeatureDataTable(_factories.GeoFactory);
IExtents extents = provider.GetExtents();
FeatureQueryExpression query = new FeatureQueryExpression(extents.ToGeometry(),
SpatialOperation.Intersects,
provider);
features.Merge(provider.ExecuteFeatureQuery(query) as IEnumerable <IFeatureDataRecord>,
provider.GeometryFactory);
foreach (FeatureDataRow feature in features)
{
IGeometry g = feature.Geometry;
List <RenderObject> renderedObjects = new List <RenderObject>(geometryRenderer.RenderFeature(feature));
for (Int32 i = 0; i < renderedObjects.Count; i++)
{
RenderObject ro = renderedObjects[i];
}
}
}
private void Page_Loaded(object sender, RoutedEventArgs e)
{
plotter.AddLineGraph(DataSourceHelper.CreateDataSource(x => x != 0 ? 10 * Math.Sin(x) / x : 1));
var line = plotter.AddLineGraph(DataSourceHelper.CreateDataSource(x => Math.Sqrt(x)));
// this will set different look to line chart's legend item - text from the left and line segment from the right
NewLegend.SetLegendItemsBuilder(line, new LegendItemsBuilder(CreateDifferentlyLookingLegendItem));
// creating and adding to plotter line chart's description editor
StackPanel textEditingPanel = new StackPanel {
Orientation = Orientation.Horizontal, Background = Brushes.LightGray
};
TextBlock label = new TextBlock {
Text = "Chart's legend description:", Margin = new Thickness(5, 10, 0, 10), VerticalAlignment = VerticalAlignment.Center
};
TextBox editor = new TextBox {
DataContext = line, Margin = new Thickness(5, 10, 5, 10)
};
editor.SetBinding(TextBox.TextProperty, new Binding {
Path = new PropertyPath("(0)", NewLegend.DescriptionProperty), Mode = BindingMode.TwoWay, UpdateSourceTrigger = UpdateSourceTrigger.PropertyChanged
});
textEditingPanel.Children.Add(label);
textEditingPanel.Children.Add(editor);
plotter.Children.Add(textEditingPanel);
}
///<summary>
///构建数据库模型
///</summary>
protected override void BuildDataSet()
{
this.DataSet = new DataSet();
DataTable comType = new DataTable(tableName);
//构建表结构
DataSourceHelper.AddColumn(new DefineField(comType, "ABNORMALREASONID", "原因代码", FieldSize.Size20)
{
AllowCopy = false, AllowEmpty = false, DataType = LibDataType.Text
});
DataSourceHelper.AddColumn(new DefineField(comType, "ABNORMALREASONNAME", "原因名称", FieldSize.Size50)
{
AllowEmpty = false, DataType = LibDataType.NText
});
DataSourceHelper.AddColumn(new DefineField(comType, "ABNORMALREASONTYPEID", "原因类别", FieldSize.Size20)
{
AllowEmpty = false,
DataType = LibDataType.Text,
RelativeSource = new RelativeSourceCollection()
{
new RelativeSource("com.AbnormalReasonType")
{
RelFields = new RelFieldCollection()
{
new RelField("ABNORMALREASONTYPENAME", LibDataType.NText, FieldSize.Size50, "原因类别名称")
}
}
}
});
DataSourceHelper.AddFixColumn(comType, this.BillType); //系统自动创建的内容
comType.PrimaryKey = new DataColumn[] { comType.Columns["ABNORMALREASONID"] }; //定义表的主键
this.DataSet.Tables.Add(comType);
}
internal MassMailEditInfo GetMassMailDetailForEdit(long massmailID)
{
List <KeyValuePair <string, object> > Param = new List <KeyValuePair <string, object> >();
Param.Add(new KeyValuePair <string, object>("@MassMailID", massmailID));
SQLHandler objHandler = new SQLHandler();
try
{
DataSet ds = objHandler.ExecuteAsDataSet("[dbo].[usp_SCAdmin_GetMailDetailByMassMailID]", Param);
if (ds != null && ds.Tables.Count > 0)
{
MassMailEditInfo objMail = DataSourceHelper.FillObject <MassMailEditInfo>(ds.Tables[0].CreateDataReader());
List <MassMailFilterTypeInfo> lstAdditionalUsers = new List <MassMailFilterTypeInfo>();
lstAdditionalUsers = DataSourceHelper.FillCollection <MassMailFilterTypeInfo>(ds.Tables[1]);
objMail.AdditionalUsers = lstAdditionalUsers;
return(objMail);
}
else
{
return(null);
}
}
catch (Exception ex)
{
return(null);
//base.ProcessExcetion(ex);
}
}
internal MassMailSendInfo GetMailAndUserToSendMail(string SecheduleDate)
{
const string sp = "[dbo].[Admin_MassMail_GetMailForSend]";
List <KeyValuePair <string, object> > Param = new List <KeyValuePair <string, object> >();
Param.Add(new KeyValuePair <string, object>("@ScheduleDate", SecheduleDate));
SQLHandler objHandler = new SQLHandler();
try
{
DataSet ds = objHandler.ExecuteAsDataSet(sp, Param);
if (ds != null && ds.Tables.Count > 0)
{
MassMailSendInfo objMail = DataSourceHelper.FillObject <MassMailSendInfo>(ds.Tables[0].CreateDataReader());
List <UserInfo> lstUsers = new List <UserInfo>();
lstUsers = DataSourceHelper.FillCollection <UserInfo>(ds.Tables[1]);
objMail.MailToUsers = lstUsers;
return(objMail);
}
else
{
return(null);
}
}
catch (Exception ex)
{
throw ex;
}
}
private static DataTable GetDataSource(Report report, DataSource dataSource)
{
var parameters = new ParameterInfo
{
Parameters = report.Parameters,
DataSourceParameters = dataSource.Parameters
};
var result = DataSourceHelper.GetDataTable(report.Tenant, dataSource.Query, parameters);
if (!dataSource.ReturnsJson)
{
return(result);
}
if (result.Rows?.Count == 0)
{
return(result);
}
var token = result.Rows[0][0];
if (token == null)
{
return(result);
}
string json = token.ToString();
result = JsonConvert.DeserializeObject <DataTable>(json);
return(result);
}
protected override void BuildDataSet()
{
this.DataSet = new DataSet();
DataTable masterTable = new DataTable(masterTableName);
DataSourceHelper.AddColumn(new DefineField(masterTable, "PROGID", "功能代码", FieldSize.Size50)
{
AllowEmpty = false,
ControlType = LibControlType.IdName,
RelativeSource = new RelativeSourceCollection()
{
new RelativeSource("axp.FuncList")
{
RelFields = new RelFieldCollection()
{
new RelField("PROGNAME", LibDataType.NText, FieldSize.Size50, "功能名称")
}
}
}
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "BUSINESSTASKID", "任务代码", FieldSize.Size50)
{
AllowCopy = false, AllowEmpty = false
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "BUSINESSTASKNAME", "任务名称", FieldSize.Size50)
{
ControlType = LibControlType.NText
});
masterTable.PrimaryKey = new DataColumn[] { masterTable.Columns["PROGID"], masterTable.Columns["BUSINESSTASKID"] };
this.DataSet.Tables.Add(masterTable);
}
public static IDictionary <string, object> ComposeDropDownFieldDescriptor(string name, string caption, string lookupPrvName, object lookupContext, string textFld, string valFld, IList <IDictionary <string, object> > conditions)
{
var fieldDescriptor = new Dictionary <string, object>();
fieldDescriptor["name"] = name;
fieldDescriptor["caption"] = caption;
fieldDescriptor["dataType"] = "string";
fieldDescriptor["conditions"] = conditions != null
? conditions
: new List <IDictionary <string, object> > {
new Dictionary <string, object> {
{ "text", "=" }, { "value", "=" }
},
new Dictionary <string, object> {
{ "text", "<>" }, { "value", "!=" }
}
};
var rendererData = new Dictionary <string, object>();
rendererData["name"] = "dropdownlist";
rendererData["values"] = DataSourceHelper.GetProviderDataSource(lookupPrvName, lookupContext).Cast <object>().Select(r =>
new Dictionary <string, object> {
{ "value", DataBinder.Eval(r, valFld) },
{ "text", DataBinder.Eval(r, textFld) }
}).ToArray();
fieldDescriptor["renderer"] = rendererData;
return(fieldDescriptor);
}
public ReverbCommand(uint bufferOffset, ReverbParameter parameter, Memory <ReverbState> state, bool isEnabled, ulong workBuffer, int nodeId, bool isLongSizePreDelaySupported, bool newEffectChannelMappingSupported)
{
Enabled = true;
IsEffectEnabled = isEnabled;
NodeId = nodeId;
_parameter = parameter;
State = state;
WorkBuffer = workBuffer;
InputBufferIndices = new ushort[Constants.VoiceChannelCountMax];
OutputBufferIndices = new ushort[Constants.VoiceChannelCountMax];
for (int i = 0; i < Parameter.ChannelCount; i++)
{
InputBufferIndices[i] = (ushort)(bufferOffset + Parameter.Input[i]);
OutputBufferIndices[i] = (ushort)(bufferOffset + Parameter.Output[i]);
}
IsLongSizePreDelaySupported = isLongSizePreDelaySupported;
// NOTE: We do the opposite as Nintendo here for now to restore previous behaviour
// TODO: Update reverb processing and remove this to use RemapLegacyChannelEffectMappingToChannelResourceMapping.
DataSourceHelper.RemapChannelResourceMappingToLegacy(newEffectChannelMappingSupported, InputBufferIndices);
DataSourceHelper.RemapChannelResourceMappingToLegacy(newEffectChannelMappingSupported, OutputBufferIndices);
}
/// <summary>
/// Execute As Object
/// </summary>
/// <typeparam name="T">Given type of object.</typeparam>
/// <param name="storedProcedureName">Accept Key Value Collection For Parameters</param>
/// <returns> Type of the object implementing</returns>
public T ExecuteAsObject <T>(string storedProcedureName)
{
using (NpgsqlConnection conn = new NpgsqlConnection(ConnectionString))
{
NpgsqlCommand command = new NpgsqlCommand();
command.Connection = conn;
command.CommandText = storedProcedureName;
command.CommandType = CommandType.StoredProcedure;
conn.Open();
NpgsqlDataReader reader = command.ExecuteReader();
ArrayList arrColl = DataSourceHelper.FillCollection(reader, typeof(T));
conn.Close();
if (reader != null)
{
reader.Close();
}
if (arrColl != null && arrColl.Count > 0)
{
return((T)arrColl[0]);
}
else
{
return(default(T));
}
}
}
public List <T> ExecuteAsListText <T>(string sqlCommand)
{
SqlConnection SQLConn = new SqlConnection(this._connectionString);
try
{
SqlDataReader SQLReader;
SqlCommand SQLCmd = new SqlCommand();
SQLCmd.Connection = SQLConn;
SQLCmd.CommandText = sqlCommand;
SQLCmd.CommandType = CommandType.Text;
SQLConn.Open();
SQLReader = SQLCmd.ExecuteReader(CommandBehavior.CloseConnection); //datareader automatically closes the SQL connection
List <T> mList = new List <T>();
mList = DataSourceHelper.FillCollection <T>(SQLReader);
if (SQLReader != null)
{
SQLReader.Close();
}
SQLConn.Close();
return(mList);
}
catch (Exception e)
{
throw e;
}
finally
{
SQLConn.Close();
}
}
public CatalogPricingRuleInfo GetCatalogPricingRule(Int32 catalogPriceRuleID, Int32 storeID, Int32 portalID, string userName, string culture)
{
PriceRuleSqlProvider priceRuleSqlProvider = new PriceRuleSqlProvider();
DataSet ds = new DataSet();
ds = priceRuleSqlProvider.GetCatalogPricingRule(catalogPriceRuleID, storeID, portalID, userName, culture);
DataTable dtCatalogPricingRule = ds.Tables[0];
DataTable dtCatalogPriceRuleCondition = ds.Tables[1];
DataTable dtCatalogConditionDetails = ds.Tables[2];
DataTable dtCatalogPriceRuleRoles = ds.Tables[3];
List <CatalogPriceRule> lstCatalogPriceRule;
lstCatalogPriceRule = DataSourceHelper.FillCollection <CatalogPriceRule>(dtCatalogPricingRule);
List <CatalogPriceRuleCondition> lstCatalogPriceRuleCondition;
lstCatalogPriceRuleCondition = DataSourceHelper.FillCollection <CatalogPriceRuleCondition>(dtCatalogPriceRuleCondition);
List <CatalogPriceRuleRole> lstCatalogPriceRuleRole;
lstCatalogPriceRuleRole = DataSourceHelper.FillCollection <CatalogPriceRuleRole>(dtCatalogPriceRuleRoles);
List <CatalogConditionDetail> lstCatalogConditionDetail;
lstCatalogConditionDetail = DataSourceHelper.FillCollection <CatalogConditionDetail>(dtCatalogConditionDetails);
CatalogPricingRuleInfo catalogPricingRuleInfo = new CatalogPricingRuleInfo();
CatalogPriceRule catalogPriceRule = lstCatalogPriceRule[0];
catalogPricingRuleInfo.CatalogPriceRule = catalogPriceRule;
List <CatalogPriceRuleCondition> lstCPRC = new List <CatalogPriceRuleCondition>();
foreach (CatalogPriceRuleCondition catalogPriceRuleCondition in lstCatalogPriceRuleCondition)
{
List <CatalogConditionDetail> lstCCD = new List <CatalogConditionDetail>();
foreach (CatalogConditionDetail catalogConditionDetail in lstCatalogConditionDetail)
{
if (catalogPriceRuleCondition.CatalogPriceRuleConditionID == catalogConditionDetail.CatalogPriceRuleConditionID)
{
lstCCD.Add(catalogConditionDetail);
}
}
catalogPriceRuleCondition.CatalogConditionDetail = lstCCD;
lstCPRC.Add(catalogPriceRuleCondition);
}
catalogPricingRuleInfo.CatalogPriceRuleConditions = lstCPRC;
List <CatalogPriceRuleRole> lstCPRR = new List <CatalogPriceRuleRole>();
foreach (CatalogPriceRuleRole catalogPriceRuleRole in lstCatalogPriceRuleRole)
{
if (catalogPriceRuleRole.CatalogPriceRuleID == catalogPriceRule.CatalogPriceRuleID)
{
lstCPRR.Add(catalogPriceRuleRole);
}
}
catalogPricingRuleInfo.CatalogPriceRuleRoles = lstCPRR;
return(catalogPricingRuleInfo);
}
protected override void BuildDataSet()
{
this.DataSet = new DataSet();
DataTable masterTable = new DataTable(masterTableName);
DataSourceHelper.AddColumn(new DefineField(masterTable, "EXECTASKDATAID", "执行标识号", FieldSize.Size50));
DataSourceHelper.AddColumn(new DefineField(masterTable, "CREATETIME", "创建时间")
{
DataType = LibDataType.Int64, ControlType = LibControlType.DateTime
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "PROGID", "功能代码", FieldSize.Size50)
{
AllowEmpty = false,
ControlType = LibControlType.IdName,
RelativeSource = new RelativeSourceCollection()
{
new RelativeSource("axp.FuncList")
{
RelFields = new RelFieldCollection()
{
new RelField("PROGNAME", LibDataType.NText, FieldSize.Size50, "功能名称")
}
}
}
});
DataSourceHelper.AddColumn(new DefineField(masterTable, "RESULTDATA", "结果数据")
{
DataType = LibDataType.Binary, ControlType = LibControlType.NText
});
masterTable.PrimaryKey = new DataColumn[] { masterTable.Columns["EXECTASKDATAID"] };
this.DataSet.Tables.Add(masterTable);
}
public async Task <IList <AdvanceFilterInfo> > GetAdvanceFilters(int SiteID)
{
NL_Provider provider = new NL_Provider();
DataSet ds = await provider.GetAdvanceFilters(SiteID);
List <AdvanceFilterInfo> finalList = new List <AdvanceFilterInfo>();
for (int i = 0; i < ds.Tables.Count; i++)
{
IList <AdvanceFilterTempInfo> infos = DataSourceHelper.FillCollection <AdvanceFilterTempInfo>(ds.Tables[i]);
AdvanceFilterInfo info = new AdvanceFilterInfo
{
AppName = infos[0].AppName,
CategoryName = infos[0].CategoryName,
InputType = infos[0].InputType
};
List <string> lstKeyword = infos.Select(x => x.KeyWord).Distinct().ToList();
info.FilterList = lstKeyword;
finalList.Add(info);
}
return(finalList);
}
public static CatalogPricingRuleInfo GetCatalogPricingRule(Int32 catalogPriceRuleID, AspxCommonInfo aspxCommonObj)
{
DataSet ds = new DataSet();
ds = AspxCatalogPriceRuleProvider.GetCatalogPricingRule(catalogPriceRuleID, aspxCommonObj);
DataTable dtCatalogPricingRule = ds.Tables[0];
DataTable dtCatalogPriceRuleCondition = ds.Tables[1];
DataTable dtCatalogConditionDetails = ds.Tables[2];
DataTable dtCatalogPriceRuleRoles = ds.Tables[3];
List <CatalogPriceRule> lstCatalogPriceRule;
lstCatalogPriceRule = DataSourceHelper.FillCollection <CatalogPriceRule>(dtCatalogPricingRule);
List <CatalogPriceRuleCondition> lstCatalogPriceRuleCondition;
lstCatalogPriceRuleCondition = DataSourceHelper.FillCollection <CatalogPriceRuleCondition>(dtCatalogPriceRuleCondition);
List <CatalogPriceRuleRole> lstCatalogPriceRuleRole;
lstCatalogPriceRuleRole = DataSourceHelper.FillCollection <CatalogPriceRuleRole>(dtCatalogPriceRuleRoles);
List <CatalogConditionDetail> lstCatalogConditionDetail;
lstCatalogConditionDetail = DataSourceHelper.FillCollection <CatalogConditionDetail>(dtCatalogConditionDetails);
CatalogPricingRuleInfo catalogPricingRuleInfo = new CatalogPricingRuleInfo();
CatalogPriceRule catalogPriceRule = lstCatalogPriceRule[0];
catalogPricingRuleInfo.CatalogPriceRule = catalogPriceRule;
List <CatalogPriceRuleCondition> lstCPRC = new List <CatalogPriceRuleCondition>();
foreach (CatalogPriceRuleCondition catalogPriceRuleCondition in lstCatalogPriceRuleCondition)
{
List <CatalogConditionDetail> lstCCD = new List <CatalogConditionDetail>();
foreach (CatalogConditionDetail catalogConditionDetail in lstCatalogConditionDetail)
{
if (catalogPriceRuleCondition.CatalogPriceRuleConditionID == catalogConditionDetail.CatalogPriceRuleConditionID)
{
lstCCD.Add(catalogConditionDetail);
}
}
catalogPriceRuleCondition.CatalogConditionDetail = lstCCD;
lstCPRC.Add(catalogPriceRuleCondition);
}
catalogPricingRuleInfo.CatalogPriceRuleConditions = lstCPRC;
List <CatalogPriceRuleRole> lstCPRR = new List <CatalogPriceRuleRole>();
foreach (CatalogPriceRuleRole catalogPriceRuleRole in lstCatalogPriceRuleRole)
{
if (catalogPriceRuleRole.CatalogPriceRuleID == catalogPriceRule.CatalogPriceRuleID)
{
lstCPRR.Add(catalogPriceRuleRole);
}
}
catalogPricingRuleInfo.CatalogPriceRuleRoles = lstCPRR;
return(catalogPricingRuleInfo);
}
protected override object SaveViewState()
{
Pair p = new Pair();
p.First = base.SaveViewState();
p.Second = DataSourceHelper.SaveViewState(_parameters);
return(p);
}
public ActionResult Index()
{
GetButtonPermissions();
var enabledItems = DataSourceHelper.GetIsTrue();
ViewBag.EnableItems = enabledItems;
return(PartialView());
}
public void Dispose()
{
if (this._dataSourceHelper != null)
{
this._dataSourceHelper = null;
GC.Collect();
}
}