public void DataListManipulations()
{
string name = "test";
DataList <double> list = new DataList <double>(name);
Assert.IsTrue(list.Name == name);
Assert.IsTrue(list.Count == 0);
Assert.IsTrue(list.StorageType == typeof(double));
list.Add(1.1);
list.Add(2.2);
Assert.IsTrue(list.Count == 2);
Assert.IsTrue(list[0] == 1.1);
Assert.IsTrue(list[1] == 2.2);
Assert.IsTrue(list[list.IndexOf(2.2)] == 2.2);
Assert.IsFalse(list.Contains(0.0));
Assert.IsFalse(list.Remove(0.0));
Assert.IsTrue(list.Contains(1.1));
Assert.IsTrue(list.Remove(1.1));
Assert.IsFalse(list.Contains(1.1));
Assert.IsTrue(list.Count == 1);
list.InsertAt(0, 3.3);
Assert.IsTrue(list.Contains(3.3));
Assert.IsTrue(list.Count == 2);
list.Clear();
Assert.IsFalse(list.Contains(2.2));
Assert.IsTrue(list.Count == 0);
}
/****************************************************************
* Data Node
***************************************************************/
public Node Data()
{
var dataResult = new Data()
{
AnchorToken = Expect(TokenCategory.DATA)
};
dataResult.Add(new Identifier()
{
AnchorToken = Expect(TokenCategory.IDENTIFIER)
});
Expect(TokenCategory.DIV);
var dataValues = new DataList();
dataValues.Add(ExpectLiteral());
while (CurrentToken == TokenCategory.COMMA)
{
Expect(TokenCategory.COMMA);
dataValues.Add(ExpectLiteral());
}
Expect(TokenCategory.DIV);
dataResult.Add(dataValues);
return(dataResult);
}
private void buttonSave_Click(object sender, System.EventArgs e)
{
string filename = this.textFolder.Text + '\\';
filename += this.textName.Text + ".csv";
if (File.Exists(filename))
{
if (MessageBox.Show("ファイルがすでに存在しています。\n上書きしますか？", "上書き確認",
MessageBoxButtons.YesNo) != DialogResult.Yes)
{
return;
}
}
DataList list = new DataList();
Channel channel = (Channel)this.comboChannel.SelectedIndex;
Spectrum spectrum = this.wave.GetSpectrum(channel);
int m = this.checkedListType.CheckedIndices.Count;
int length = this.wave.Count;
double fs = this.wave.Header.sampleRate;
double[] label = new double[length];
for (int i = 0; i < length; ++i)
{
label[i] = fs / length * i;
}
list.Add("周波数", label);
for (int i = 0; i < m; ++i)
{
Property type = (Property)this.checkedListType.CheckedIndices[i];
double[] data = WaveData.GetData(spectrum, type);
string title = (string)this.checkedListType.CheckedItems[i];
list.Add(title, data);
}
char delim;
switch (this.comboDelim.SelectedIndex)
{
case 0: delim = ','; break;
case 1: delim = '\t'; break;
default: delim = ' '; break;
}
try
{
list.Save(filename, delim, false);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public DataList ToDataList()
{
DataList data = new DataList();
data.Add(Id, "id");
data.Add(Name, "name");
return(data);
}
public DataList ToDataList()
{
DataList data = new DataList();
data.Add(Id, "id");
data.Add(Sender, "sender");
data.Add(Content, "content");
data.Add(SendTime.ToString("O"), "send_time");
return(data);
}
private void Form1_Load(object sender, EventArgs e)
{
DataList list = new DataList();
list.Add(new DataEdit(1, "Rocky"));
list.Add(new DataEdit(2, "Fred"));
list.Add(new DataEdit(3, "Mary"));
list.Add(new DataEdit(4, "George"));
list.BeginEdit();
this.dataListBindingSource.DataSource = list;
this.dataListBindingSource.ListChanged += new ListChangedEventHandler(dataListBindingSource_ListChanged);
}
public DataList ToDataList()
{
DataList data = new DataList();
data.Add(Id, "id");
data.Add(EventId, "event_id");
data.Add(Type, "type");
data.Add(Comment, "comment");
return(data);
}
private void Form1_Load(object sender, EventArgs e)
{
DataList list = new DataList();
list.Add(new DataEdit(1, "Rocky"));
list.Add(new DataEdit(2, "Fred"));
list.Add(new DataEdit(3, "Mary"));
list.Add(new DataEdit(4, "George"));
list.BeginEdit();
this.dataListBindingSource.DataSource = list;
this.dataListBindingSource.ListChanged += new ListChangedEventHandler(dataListBindingSource_ListChanged);
}
public void readDataFromConsole()
{
string input = Console.ReadLine();
while (!string.IsNullOrEmpty(input))
{
TextList.Add(input);
input = Console.ReadLine();
}
if (TextList != null)
{
foreach (string s in TextList)
{
Console.WriteLine(s);
}
for (int i = 0; i <= 5; i++)
{
DataList.Add(TextList[i]);
}
Console.WriteLine("Count : {0}", DataList.Count);
Console.WriteLine("Count : {0}", TextList.Count);
EnteredDateForAverageFootfallsPerHour = TextList[6];
EnteredDateForAverageDailyFootfallsInAWeek = TextList[7];
MonthAndYear = TextList[8];
IsDataRead = true;
}
}
/// <summary>
/// Updates collection if necessary.
/// </summary>
protected override void UpdateData()
{
base.UpdateData();
if (!_needUpdate)
{
return;
}
_needUpdate = false;
foreach (var item in _data.Values)
{
RemovePropertyChangedListener(item);
}
Data.Clear();
DataList.Clear();
foreach (var item in _parentCollection)
{
if (_filter(item))
{
string id = GetId(item);
Data.Add(id, item);
DataList.Add(new KeyValuePair <string, T>(id, item));
}
AddPropertyChangedListener(item);
}
}
private void ParseDataSection([NotNull] string line)
{
// Check for label
var labelIndex = line.IndexOf(":", StringComparison.Ordinal);
if (labelIndex > -1)
{
var label = line.Substring(0, labelIndex);
var offset = DataList.SelectMany(a => a).ToArray().Length;
DataTable.Add(label, offset);
if (line.Length > labelIndex + 1)
{
line = line.Substring(labelIndex + 1).Trim(' ', '\t');
}
else
{
return;
}
}
var lineSplit = line.Split(new[] { ' ', '\t' }, StringSplitOptions.RemoveEmptyEntries);
if (lineSplit.Length != 2)
{
throw new ArgumentException("Invalid Syntax (parameter count): " + line);
}
var data = ParseDataDefinition(lineSplit[0], lineSplit[1]);
if (data != null)
{
DataList.Add(data.Encode());
}
}
public LinkColumn(string name, Type DataType, bool allowsnull, object def, Table thisTable, Column linkedcolumn) : base(name, DataType, allowsnull, def, thisTable)
{
try
{
if (linkedcolumn.IsPkey)
{
linkedColumn = linkedcolumn;
SetFkeyProperty(true);
DataType = linkedColumn.DataType;
Default = DataType.GetDefaultValue();
for (int i = 0; i < DataList.Count; i++)
{
DataList.Add(new DataObject(GetHashCode(), Default));
}
}
else
{
throw new ArgumentException("You can connect this column only with PrimaryKeyColumn");
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
private void GetData(CategoryModel category)
{
int index = -1;
if (SelectedData != null)
{
index = DataList.IndexOf(SelectedData);
}
DataList.Clear();
if (category != null)
{
foreach (var data in storageHandler.GetData(category))
{
DataList.Add(data);
}
}
OnPropertyChanged(nameof(DataList));
if (index > -1 && index < DataList.Count)
{
SelectedData = DataList[index];
}
else
{
SelectedData = null;
}
OnPropertyChanged(nameof(SelectedData));
}
/*
* used to create a Datablock struct filled with recorded information and then saved into the data list
* this method MUST BE CALLED INSIDE AddDataBlock()
* inputs: a string representing the name of the game object being recorded
* a generic value of type T that represents the actual data value being recorded
* fields used: objName
*/
protected virtual void AddDataBlock <T>(string dataName, T value)
{
DataBlock db = new DataBlock(dataName, value.ToString(), this.objName, this.Id);
//Debug.Log("db: " + value.ToString());
DataList.Add(db);
}
public ProducerMonitorViewModel() : base("生产者数据监控")
{
ContentId = ToolContentId;
MessageSubscribeRelations.AddSubscribe(MessageType.All, new Relation()
{
CanUninstall = false,
IsActive = true,
IsKeep = true,
RelationDescribe = "数据监视器WSDE类消息监听",
RelationGuid = GuidWSDEDataComeEvent,
RelationAction = messageData =>
{
base.BindingPropInOtherTask(() =>
{
JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer();
//var response = javaScriptSerializer.Deserialize<WSDESubVoterSelectRequest>(messageData.MessageData);
if (DataList.Count() > _maxKeep)
{
for (int i = 0; i < DataList.Count() - _maxKeep; i++)
{
DataList.RemoveAt(0);
}
}
DataList.Add(messageData);
});
},
});
}
private async Task ExecuteRefresh()
{
try
{
int?id = Selected?.ID;
var logs = await _dbservicewms.GetLogs(DateFrom.TimeStamp, DateTo.TimeStamp);
DataList.Clear();
foreach (var p in logs)
{
DataList.Add(new LogViewModel
{
ID = p.ID,
Severity = (EnumLogWMS)p.Severity,
Source = p.Source,
Message = p.Message,
Time = p.Time
});
}
foreach (var l in DataList)
{
l.Initialize(_warehouse);
}
Records = DataList.Count();
if (id != null)
{
Selected = DataList.FirstOrDefault(p => p.ID == id);
}
}
catch (Exception e)
{
_warehouse.AddEvent(Database.Event.EnumSeverity.Error, Database.Event.EnumType.Exception,
string.Format("{0}.{1}: {2}", this.GetType().Name, (new StackTrace()).GetFrame(0).GetMethod().Name, e.Message));
}
}
public void AddEntry(DataList entry, string tableName, string rowName = "")
{
int index = data.names.IndexOf(tableName);
// Create new table
if (index == -1)
{
data.Add(new DataList(), tableName);
index = data.names.IndexOf(tableName);
}
int id = 0;
while (((DataList)data.Get(index)).Get($"{id}") != null)
{
id++;
}
if (rowName == "")
{
rowName = id.ToString();
}
// Add entry
((DataList)data.Get(index)).Add(entry, rowName);
}
private async Task ExecuteRefresh()
{
try
{
int?erpid = Selected?.ERPID;
DataList.Clear();
var cmderp = await _dbservicewms.GetCommandERPs(DateTime.Now.AddHours(-1), DateTime.Now, (int)EnumCommandERPStatus.Active);
foreach (var p in cmderp)
{
DataList.Add(new CommandERPViewModel
{
ID = p.ID,
ERPID = p.ERP_ID,
Reference = p.Reference,
Command = p.Command,
Status = (EnumCommandERPStatus)p.Status,
Time = p.Time
});
}
foreach (var l in DataList)
{
l.Initialize(_warehouse);
}
if (erpid != null)
{
Selected = DataList.FirstOrDefault(p => p.ERPID == erpid);
}
}
catch (Exception e)
{
_warehouse.AddEvent(Database.Event.EnumSeverity.Error, Database.Event.EnumType.Exception,
string.Format("{0}.{1}: {2}", this.GetType().Name, (new StackTrace()).GetFrame(0).GetMethod().Name, e.Message));
}
}
/// <summary>
/// 添加新项，并自动按照当前排序规则整理列表，之后定位到该项
/// </summary>
/// <param name="t">要添加的新项</param>
public void AddItem(T t)
{
DataList.Add(t);
ClearSelection();
Rows[Rows.Count - 1].Selected = true;
Refresh();
}
private void ExecuteRefresh()
{
try
{
UserViewModel u = Selected;
DataList.Clear();
foreach (var p in _warehouse.DBService.GetUsers())
{
DataList.Add(
new UserViewModel
{
UserName = p.User1.ToUpper(),
Password1 = p.Password,
Password2 = p.Password,
AccessLevelWMS = (EnumUserAccessLevel)(p.AccessLevel / 10),
AccessLevelMFCS = (EnumUserAccessLevel)(p.AccessLevel % 10)
});
}
foreach (var l in DataList)
{
l.Initialize(_warehouse);
}
if (u != null)
{
Selected = DataList.FirstOrDefault(p => p.UserName == u.UserName);
}
}
catch (Exception e)
{
_warehouse.AddEvent(Database.Event.EnumSeverity.Error, Database.Event.EnumType.Exception,
string.Format("{0}.{1}: {2}", this.GetType().Name, (new StackTrace()).GetFrame(0).GetMethod().Name, e.Message));
}
}
/// <summary>
/// 新增对象
/// </summary>
/// <param name="t"></param>
public void Add(T t)
{
if (!CheckValidName(t))
{
throw new JException(t.Name + "的名称重复。");
}
if (BeforeSave != null)
{
BeforeSave(t);
}
if (Provider.Add(t) > 0)
{
DataList.Add(t);
if (AfterSaved != null)
{
AfterSaved(t);
}
}
if (t.Id == null)
{
throw new JException("ID is empty");
//t.Id = CreateId();
}
}
public static DataList<ImageInfo> GetImages(String artistName, String albumName, Boolean getOneImage)
{
try
{
DataList<ImageInfo> returnList = new DataList<ImageInfo>();
const String select = "SELECT IMAGE_DATA, IMAGE_EXTENSION, WEB_URL FROM ALBUM_IMAGE WHERE ALBUM_NAME = @ALBUM_NAME and ARTIST_NAME = @ARTIST_NAME ";
using (DataReader reader = Static.Db.CallReader(select,
Static.Db.NewParameter("@ALBUM_NAME", albumName),
Static.Db.NewParameter("@ARTIST_NAME", artistName)))
{
while (reader.Read())
{
returnList.Add(new ImageInfo { Data = reader["IMAGE_DATA"], Extension = reader["IMAGE_EXTENSION"], webUrl = reader["WEB_URL"] });
if (getOneImage)
break;
}
}
return returnList;
}
catch (Exception e)
{
Logging.Error(typeof(ClientDb), e);
return null;
}
}
public async void DebugginAsync(RichTextBox richTextBox, ListBox listBoxer, ProgressBar progressBar)
{
HtmlAgilityPack.HtmlDocument document = new HtmlAgilityPack.HtmlDocument();
document.LoadHtml(html: _getBodyHtml);
var htmlNodes = document.DocumentNode.SelectNodes("//tr/td/a");
// var htmlNodes = document.DocumentNode.SelectNodes("//ul/li/a");
foreach (HtmlNode node in htmlNodes)
{
listBoxer.Items.Add(node.Attributes["href"].Value);
DataList.Add(node.Attributes["href"].Value);
// DataList.Add(node.OuterHtml);
}
List <string> releaseUri = new List <string>();
//List<string> idCollection = new List<string>();
for (int i = 0; i < DataList.Count; i++)
{
string collectionId = "";
if (DataList[i].IndexOf("ID") != -1)
{
for (int k = 0; k <= 4; k++)
{
//idCollection.Add(DataList[i][i + k].ToString());
int indexer = DataList[i].IndexOf("ID") + 2;
collectionId += DataList[i][indexer + k];
}
}
releaseUri.Add($"https://www.olx.kz/ajax/misc/contact/phone/{collectionId}/?pt=");
richTextBox.Text += $" https://www.olx.kz/ajax/misc/contact/phone/{collectionId}/?pt= ";
}
var bodyCollection = new List <string>();
HtmlAgilityPack.HtmlDocument doc = new HtmlAgilityPack.HtmlDocument();
List <string> getPhoneTokenCollection = new List <string>();
List <string> getPhoneRequestUrls = new List <string>();
string[] splitChar = { };
for (int i = 0; i < DataList.Count; i++)
{
doc.LoadHtml(await GetCodeAsync(DataList[i], progressBar));
HtmlNodeCollection nodes = doc.DocumentNode.SelectNodes("//section/script");
foreach (HtmlNode node in nodes)
{
splitChar = node.InnerText.Split(new string[] { "var", "=", "'", "phoneToken", ";", "\n", " " }, StringSplitOptions.RemoveEmptyEntries);
getPhoneTokenCollection.Add(splitChar[0]);
}
}
MessageBox.Show("End;");
}
private void Form1_Load(object sender, EventArgs e)
{
var list = new DataList();
list.Add(new Data { Id = 213, Name = "abc" });
list.Add(new Data { Id = 113, Name = "qwe" });
list.Add(new Data { Id = 413, Name = "zcx" });
list.Add(new Data { Id = 233, Name = "abc" });
list.Add(new Data { Id = 215, Name = "ler" });
this.dataListBindingSource.DataSource = list;
this.sortedBindingSource.DataSource = new Csla.SortedBindingList<Data>(list);
var filtered = new Csla.FilteredBindingList<Data>(list);
this.filteredBindingSource.DataSource = filtered;
//filtered.ApplyFilter("Name", "abc");
}
public BaiduPlatformCategoryEntityBase(int categorySysNo, string categoryName, int number, decimal price)
{
this.CategorySysNo = categorySysNo;
string tags = categoryName.Replace('、', '\\').Replace('/', '\\');
this.DataList = new List <BaiduPlatformCategoryData>();
DataList.Add(new BaiduPlatformCategoryData(tags, number, price));
}
public DataList ToFullDataList()
{
DataList data = new DataList();
// Simple
data.Add(Id, "id");
data.Add(Author, "author");
data.Add(Name, "name");
data.Add(Address.ToString(), "address");
data.Add(StartDate.ToString("O"), "start_date");
data.Add(Price, "price");
data.Add(Description, "description");
data.Add(Tags, "tags");
data.Add(Visible, "visible");
// Complex
DataList sportsDl = new DataList();
foreach (string sport in Sports)
{
sportsDl.Add(sport);
}
DataList linksDl = new DataList();
foreach (string link in Links)
{
linksDl.Add(link);
}
DataList imagesDl = new DataList();
foreach (string image in Images)
{
imagesDl.Add(image);
}
DataList coordinatesDl = new DataList();
coordinatesDl.Add(Latitude);
coordinatesDl.Add(Longitude);
data.Add(sportsDl, "sports");
data.Add(linksDl, "links");
data.Add(imagesDl, "images");
data.Add(coordinatesDl, "coordinates");
return(data);
}
private async void LoadData()
{
IsBusy = true;
await foreach (var item in LoadMoreData().ConfigureAwait(false))
{
DataList.Add(item);
}
IsBusy = false;
}
public void ProcessFile(string filename)
{
DataList.Clear();
using var fileReader = File.OpenText(filename);
var csv = new CsvReader(fileReader, CultureInfo.InvariantCulture);
var foo = csv.Context.AutoMap <MsftMftData>();
var o = new TypeConverterOptions
{
DateTimeStyle = DateTimeStyles.AssumeUniversal & DateTimeStyles.AdjustToUniversal
};
csv.Context.TypeConverterOptionsCache.AddOptions <MsftMftData>(o);
foo.Map(t => t.Line).Ignore();
foo.Map(t => t.Tag).Ignore();
foo.Map(m => m.CreationTime0x10).Convert(row =>
DateTime.Parse(row.Row.GetField <string>("CreationTime0x10").Replace("Z", "")));
foo.Map(m => m.CreationTime0x30).Convert(row =>
DateTime.Parse(row.Row.GetField <string>("CreationTime0x30").Replace("Z", "")));
foo.Map(m => m.LastModificationTime0x10).Convert(row =>
DateTime.Parse(row.Row.GetField <string>("LastModificationTime0x10").Replace("Z", "")));
foo.Map(m => m.LastModificationTime0x30).Convert(row =>
DateTime.Parse(row.Row.GetField <string>("LastModificationTime0x30").Replace("Z", "")));
foo.Map(m => m.LastChangeTime0x10).Convert(row =>
DateTime.Parse(row.Row.GetField <string>("LastChangeTime0x10").Replace("Z", "")));
foo.Map(m => m.LastChangeTime0x30).Convert(row =>
DateTime.Parse(row.Row.GetField <string>("LastChangeTime0x30").Replace("Z", "")));
foo.Map(m => m.LastAccessTime0x10).Convert(row =>
DateTime.Parse(row.Row.GetField <string>("LastAccessTime0x10").Replace("Z", "")));
foo.Map(m => m.LastAccessTime0x30).Convert(row =>
DateTime.Parse(row.Row.GetField <string>("LastAccessTime0x30").Replace("Z", "")));
csv.Context.RegisterClassMap(foo);
var records = csv.GetRecords <MsftMftData>();
var ln = 1;
foreach (var record in records)
{
Log.Debug("Line # {Line}, Record: {RawRecord}", ln, csv.Context.Parser.RawRecord);
record.Line = ln;
record.Tag = TaggedLines.Contains(ln);
DataList.Add(record);
ln += 1;
}
}
public BaiduPlatformManufacturerEntity(BaiduManufacturerEntity brand)
{
this.ManufacturerSysNo = brand.ManufacturerSysNo;
this.ManufacturerType = brand.Type;
this.InitialPingYin = brand.InitialPingYin;
this.DataList = new List <BaiduPlatformManufacturerData>();
DataList.Add(new BaiduPlatformManufacturerData(brand.ManufacturerName, brand.ProductCount, brand.MinPrice));
}
public void ProcessFile(string filename)
{
DataList.Clear();
using var fileReader = new StreamReader(filename, CodePagesEncodingProvider.Instance.GetEncoding(1252));
var config = new CsvConfiguration(CultureInfo.InvariantCulture)
{
BadDataFound = null,
};
var csv = new CsvReader(fileReader, config);
var o = new TypeConverterOptions
{
DateTimeStyle = DateTimeStyles.AssumeUniversal & DateTimeStyles.AdjustToUniversal
};
csv.Context.TypeConverterOptionsCache.AddOptions <SigcheckTroyData>(o);
var foo = csv.Context.AutoMap <SigcheckTroyData>();
//path,verified,date,publisher,company,description,product,product version,file version,machine type,binary version,original name,internal name,copyright,comments,entropy,md5,sha1,pesha1,pesha256,sha256,imp
foo.Map(t => t.Line).Ignore();
foo.Map(t => t.Tag).Ignore();
foo.Map(t => t.Verified).Convert(t => t.Row.GetField("Verified") == "Signed");
foo.Map(t => t.Timestamp).Name("Date");
foo.Map(t => t.ProductVersion).Name("Product Version");
foo.Map(t => t.FileVersion).Name("File Version");
foo.Map(t => t.MachineType).Name("Machine Type");
foo.Map(t => t.BinaryVersion).Name("Binary Version");
foo.Map(t => t.OriginalName).Name("Original Name");
foo.Map(t => t.InternalName).Name("Internal Name");
csv.Context.RegisterClassMap(foo);
var records = csv.GetRecords <SigcheckTroyData>();
var ln = 1;
foreach (var sc in records)
{
Log.Debug("Line # {Line}, Record: {RawRecord}", ln, csv.Context.Parser.RawRecord);
sc.Line = ln;
sc.Tag = TaggedLines.Contains(ln);
DataList.Add(sc);
ln += 1;
}
}
public override BaseData ReadData(string data)
{
string[] temp = data.Split(',');
for (int i = 0; i < temp.Length; i++)
{
DataList.Add((Type)i, temp[i]);
}
return(this);
}
/// <summary>
/// Update the <see cref="DataList"/> based on different settings.
/// </summary>
/// <param name="layout">Specifies if the data is represented in columns or rows.</param>
/// <param name="firstIsName">The indication if the first row/column has the names of the variables.</param>
public void UpdateDataList(Layout layout, bool firstIsName)
{
// Set some variables.
Layout = layout;
FirstIsName = firstIsName;
var offset = FirstIsName ? 1 : 0;
// Remove the named ranges from the workbook.
foreach (var data in DataList)
{
Globals.ExcelAddIn.Application.ActiveWorkbook.Names.Item(data.RangeName.Name).Delete();
}
// Clear the current list of date.
DataList.Clear();
LagList.Clear();
DummyList.Clear();
// Populate the list with data.
if (Layout == Layout.Columns)
{
for (var column = 0; column < Range.Columns.Count; column++)
{
// Name of the variable.
var header = FirstIsName
? Convert.ToString(((Range)Sheet.Cells[Range.Row, Range.Column + column]).Value2)
: "Var_" + (column + 1);
// Range of the data.
var upperLeftCell = Sheet.Cells[Range.Row + offset, Range.Column + column];
var lowerRightCell = Sheet.Cells[Range.Row + Range.Rows.Count - 1, Range.Column + column];
var dataRange = Sheet.Range[upperLeftCell, lowerRightCell];
// Add the data to the list.
DataList.Add(new Data(Sheet, dataRange, header));
}
}
else
{
for (var row = 0; row < Range.Rows.Count; row++)
{
// Name of the variable.
var header = FirstIsName
? Convert.ToString(((Range)Sheet.Cells[Range.Row + row, Range.Column]).Value2)
: "";
// Range of the data.
var upperLeftCell = Sheet.Cells[Range.Row + row, Range.Column + offset];
var lowerRightCell = Sheet.Cells[Range.Row + row, Range.Column + Range.Columns.Count - 1];
var dataRange = Sheet.Range[upperLeftCell, lowerRightCell];
// Add the data to the list.
DataList.Add(new Data(Sheet, dataRange, header));
}
}
}
public BaiduPlatformCategoryManufacturerEntity(int categorySysNo, string categoryName, string pathSegment,
string brandSegment, string manufacturerName, int number, decimal price)
{
this.CategorySysNo = categorySysNo;
this.PathSegment = pathSegment;
this.BrandSegment = brandSegment;
this.DataList = new List <BaiduPlatformCategoryManufacturerData>();
DataList.Add(new BaiduPlatformCategoryManufacturerData(categoryName, manufacturerName, number, price));
}
private void Search_Click(object sender, EventArgs e)
{
btnSearch.Enabled = false;
txtSearch.Enabled = false;
lstResults.Items.Clear();
var videos = new DataList<Video>();
ResultsList.Bind(videos);
ResultsList.ViewFunc = (v) => new string[] { v.Title };
Task.Factory.StartNew(() =>
{
//Query.Search(txtSearch.Text, 2, videos)
foreach (var video in youtubedl.Search(txtSearch.Text, 2))
{
videos.Add(video);
}
});
btnSearch.Enabled = true;
txtSearch.Enabled = true;
}
/// <summary>
/// 筛选附件记录
/// </summary>
/// <param name="ids">编号列表（例如：0,1,79,80）</param>
/// <returns>返回附件记录记录数据列表</returns>
public DataList<AttachmentItem> SelectAttachment(string ids)
{
DataList<AttachmentItem> list = new DataList<AttachmentItem>();
if (!string.IsNullOrEmpty(ids))
{
ids = ids.Replace(" ", string.Empty);
string[] arrIds = ids.Split(',');
if (arrIds.Length > 0)
{
string trueIds = "0";
foreach (string id in arrIds)
{
if (Regex.IsMatch(id, @"^\d+$")) { trueIds += string.Format("{0},", id); }
}
if (trueIds.Length > 1) { trueIds = trueIds.Substring(0, trueIds.Length - 1); }
using (IDataReader reader = conn.ExecuteReader(string.Format("SELECT [ID], [Name], [Path], [Type], [Size], [Publish] FROM [Attach] WHERE [ID] IN ({0})", trueIds)))
{
while (reader.Read())
{
AttachmentItem item = new AttachmentItem();
item.ID = reader.GetInt32(0);
item.Name = reader.GetString(1);
item.Path = reader.GetString(2);
item.Type = reader.GetString(3);
item.Size = reader.GetInt32(4);
item.Publish = reader.GetDateTime(5);
list.Add(item);
}
}
}
}
return list;
}
private DataList<ImageInfo> getImages(string artistName, string albumName, Int64? fileId, Boolean getOneImage)
{
try
{
DataList<ImageInfo> returnList = new DataList<ImageInfo>();
if (canCallAmazon(artistName, albumName))
{
AmazonECS service = new AmazonECSQuery(accessKeyId, "");
byte[] returnArr = null;
ItemSearchRequest request = new ItemSearchRequest();
request.SearchIndex = "Music";
request.ResponseGroup = new List<String>(new String[] { "Images" });
request.Artist = artistName;
request.Title = albumName;
ItemSearchResponse response = service.ItemSearch(request);
if (response.Items.Count == 1)
{
DataList<Item> items = new DataList<Item>(response.Items[0].Item);
foreach (Item itm in items)
{
if (itm.MediumImage != null)
{
String url = itm.MediumImage.URL;
String extension = Static.GetFileExtension(itm.MediumImage.URL);
String md5Hash;
using (WebClient Client = new WebClient())
{
returnArr = Client.DownloadData(url);
md5Hash = new Hex(MD5Stream.GetHash(returnArr));
returnList.Add(new ImageInfo { Data = returnArr, Extension = extension, webUrl = url, md5Hash = md5Hash });
}
if (getOneImage)
break;
}
}
if (returnList.Count > 0)
calledAmazon(artistName, albumName, true);
Logging.Info(typeof(AmazonAssociatesImageProvider), String.Format("Amazon Search for {0} ({1}) {2} results", artistName, albumName, returnList.Count));
}
else if (response.Items.Count > 1)
Logging.Warn(typeof(AmazonAssociatesImageProvider), "More than one search result");
else
Logging.Warn(typeof(AmazonAssociatesImageProvider), String.Format("No search result ({0}, {1})", artistName, albumName));
}
else
{
Logging.Debug(typeof(AmazonAssociatesImageProvider), String.Format("Will not call Amazon, because of last calls: {0}, {1}, {2}", artistName, albumName, fileId));
}
return returnList;
}
catch (Exception e)
{
Logging.Error(typeof(AmazonAssociatesImageProvider), e);
calledAmazon(artistName, albumName, false);
return null;
}
}
/// <summary>
/// 筛选评论
/// </summary>
/// <param name="artId">大于零则筛选相关文章下的评论</param>
/// <param name="intCurPage">当前页</param>
/// <param name="btePerPage">每页总数</param>
/// <param name="selAll">是否筛选所有数据</param>
/// <returns>返回评论数据列表</returns>
public DataList<CommentItem> SelectComment(int artId, int intCurPage, int btePerPage, bool selAll)
{
DataList<CommentItem> list = new DataList<CommentItem>();
string where = string.Empty;
if (artId > 0) { where += string.Format(" AND [PostID] = {0}", artId); }
if (!selAll) { where += " AND [Verify] <> 0"; }
if (!string.IsNullOrEmpty(where)) { where = "[ID] > 0" + where; }
int rows = 0;
using (IDataReader reader = conn.ExecutePager("[Comment]", "[ID], [PostID], [Author], [Title], [Mail], [URL], [Content], [Reply], [IsTB], [Publish], [Verify]", where, "[Publish]", "DESC", intCurPage, btePerPage, ref rows))
{
while (reader.Read())
{
CommentItem item = new CommentItem();
item.ID = reader.GetInt32(0);
item.PostID = reader.GetInt32(1);
item.Author = reader.GetString(2);
item.Title = reader.GetString(3);
item.Mail = reader.GetString(4);
item.URL = reader.GetString(5);
item.Content = reader.GetString(6);
item.Reply = reader.GetString(7);
item.Trackback = reader.GetInt32(8) == 0 ? false : true;
item.Publish = reader.GetDateTime(9);
item.Verify = reader.GetInt32(10) == 0 ? false : true;
list.Add(item);
}
}
list.Number = rows;
return list;
}
/// <summary>
/// 选择用户
/// </summary>
/// <param name="intCurPage">当前页码</param>
/// <param name="btePerPage">每页数量</param>
/// <returns>返回页面数据列表</returns>
public DataList<UserItem> SelectUser(int intCurPage, int btePerPage)
{
DataList<UserItem> list = new DataList<UserItem>();
int rows = 0;
using (IDataReader reader = conn.ExecutePager("[User]", "[ID], [UserID], [Password], [Name], [LastIP], [LastTime], [Locked]", null, null, null, intCurPage, btePerPage, ref rows))
{
while (reader.Read())
{
UserItem item = new UserItem();
item.ID = reader.GetInt32(0);
item.UserID = reader.GetString(1);
item.Password = reader.GetString(2);
item.Name = reader.GetString(3);
item.LastIP = reader.GetString(4);
item.LastTime = reader.GetDateTime(5);
item.Locked = reader.GetInt32(6) == 0 ? false : true;
list.Add(item);
}
}
list.Number = rows;
return list;
}
public static DataList<string> GetFolders(String[] folders)
{
DataList<String> returnList = new DataList<string>();
foreach (String folder in folders)
{
if (Directory.Exists(folder))
{
returnList.Add(folder);
returnList.Import(GetFolders(Directory.GetDirectories(folder)));
}
}
return returnList;
}
public static DataList<String> GetFiles(String[] droppedObjects)
{
DataList<String> returnList = new DataList<string>();
DataList<String> sortedList = new DataList<String>(droppedObjects);
sortedList.Sort(
delegate(String s1, String s2)
{
return s1.CompareTo(s2);
});
droppedObjects = sortedList.ToArray();
foreach (String s in droppedObjects)
if (File.Exists(s))
returnList.Add(s);
else if (Directory.Exists(s))
{
DataList<String> subElements = new DataList<string>();
subElements.Import(Directory.GetFiles(s));
subElements.Import(Directory.GetDirectories(s));
returnList.Import(GetFiles(subElements.ToArray()));
}
return returnList;
}
/// <summary>
/// 筛选引用通告记录
/// </summary>
/// <param name="intCurPage">当前页码</param>
/// <param name="btePerPage">分页大小</param>
/// <returns>返回引用通告记录数据列表</returns>
public DataList<TrackbackLogItem> SelectTrackbackLog(int intCurPage, int btePerPage)
{
DataList<TrackbackLogItem> list = new DataList<TrackbackLogItem>();
int rows = 0;
using (IDataReader reader = conn.ExecutePager("[TrackbackLog]", "[ID], [Error], [Message], [URL], [Publish]", null, "[Publish]", "DESC", intCurPage, btePerPage, ref rows))
{
while (reader.Read())
{
TrackbackLogItem item = new TrackbackLogItem();
item.ID = reader.GetInt32(0);
item.Error = reader.GetInt32(1) == 0 ? false : true;
item.Message = reader.GetString(2);
item.URL = reader.GetString(3);
item.Publish = reader.GetDateTime(4);
list.Add(item);
}
}
list.Number = rows;
return list;
}
/// <summary>
/// 筛选附件记录
/// </summary>
/// <param name="intCurPage">当前页码</param>
/// <param name="btePerPage">分页大小</param>
/// <returns>返回附件记录记录数据列表</returns>
public DataList<AttachmentItem> SelectAttachment(int intCurPage, int btePerPage)
{
DataList<AttachmentItem> list = new DataList<AttachmentItem>();
int rows = 0;
using (IDataReader reader = conn.ExecutePager("[Attach]", "[ID], [Name], [Path], [Type], [Size], [Publish]", null, "[ID]", "DESC", intCurPage, btePerPage, ref rows))
{
while (reader.Read())
{
AttachmentItem item = new AttachmentItem();
item.ID = reader.GetInt32(0);
item.Name = reader.GetString(1);
item.Path = reader.GetString(2);
item.Type = reader.GetString(3);
item.Size = reader.GetInt32(4);
item.Publish = reader.GetDateTime(5);
list.Add(item);
}
}
list.Number = rows;
return list;
}
/// <summary>
/// 选择链接
/// </summary>
/// <param name="intCurPage">当前页码</param>
/// <param name="btePerPage">分页大小</param>
/// <param name="home">是否是首页链接</param>
/// <param name="selAll">是否选择所有数据</param>
/// <returns>返回页面数据列表</returns>
public DataList<FellowItem> SelectFellow(int intCurPage, int btePerPage, bool home, bool selAll)
{
DataList<FellowItem> list = new DataList<FellowItem>();
string sqlWhere = string.Empty;
if (home) { sqlWhere += " AND [Home] <> 0"; }
if (!selAll) { sqlWhere += " AND [Show] <> 0"; }
if (!string.IsNullOrEmpty(sqlWhere)) { sqlWhere = "[ID] > 0" + sqlWhere; }
int rows = 0;
using (IDataReader reader = conn.ExecutePager("[Fellow]", "[ID], [Name], [URL], [Explain], [Logo], [Style], [Sorting], [Home], [Show]", sqlWhere, "[Sorting]", "ASC", intCurPage, btePerPage, ref rows))
{
while (reader.Read())
{
FellowItem item = new FellowItem();
item.ID = reader.GetInt32(0);
item.Name = reader.GetString(1);
item.URL = reader.GetString(2);
item.Explain = reader.GetString(3);
item.Logo = reader.GetString(4);
item.Style = reader.GetString(5);
item.Sorting = reader.GetInt32(6);
item.Home = reader.GetInt32(7) == 0 ? false : true;
item.Show = reader.GetInt32(8) == 0 ? false : true;
list.Add(item);
}
}
list.Number = rows;
return list;
}
/// <summary>
/// 筛选自定义标签
/// </summary>
/// <param name="intCurPage">当前页码</param>
/// <param name="btePerPage">分页大小</param>
/// <param name="selAll">是否在所有数据里筛选</param>
/// <returns>返回自定义标签数据列表</returns>
public DataList<MyTagItem> SelectMyTag(int intCurPage, int btePerPage, bool selAll)
{
DataList<MyTagItem> list = new DataList<MyTagItem>();
string sqlWhere = selAll ? string.Empty : "[Show] <> 0";
int rows = 0;
using (IDataReader reader = conn.ExecutePager("[MyTag]", "[ID], [Key], [Intro], [Code], [Publish], [Priority], [Show]", sqlWhere, "[Priority]", "ASC", intCurPage, btePerPage, ref rows))
{
while (reader.Read())
{
MyTagItem item = new MyTagItem();
item.ID = reader.GetInt32(0);
item.Key = reader.GetString(1);
item.Intro = reader.GetString(2);
item.Code = reader.GetString(3);
item.Publish = reader.GetDateTime(4);
item.Priority = reader.GetInt32(5);
item.Show = reader.GetInt32(6) == 0 ? false : true;
list.Add(item);
}
}
list.Number = rows;
return list;
}
/// <summary>
/// 筛选分类
/// </summary>
/// <param name="nav">是否是导航，-1：默认，0：不是，1：是</param>
/// <param name="jump">是否是外链,-1：默认，0：不是，1：是</param>
/// <param name="selAll">是否筛选所有数据</param>
/// <returns>返回分类数据列表</returns>
public DataList<ColumnItem> SelectColumn(int nav, int jump, bool selAll)
{
DataList<ColumnItem> list = new DataList<ColumnItem>();
string where = selAll ? string.Empty : " AND [Show] <> 0";
switch (nav)
{
case 0: { where += " AND [IsNav] = 0"; break; }
case 1: { where += " AND [IsNav] <> 0"; break; }
}
switch (jump)
{
case 0: { where += " AND [IsJump] = 0"; break; }
case 1: { where += " AND [IsJump] <> 0"; break; }
}
list.Number = Convert.ToInt32(conn.ExecuteScalar(string.Format("SELECT COUNT([ID]) FROM [Column] WHERE [ID] > 0{0};", where)));
using (IDataReader reader = conn.ExecuteReader(string.Format("SELECT [ID], [Name], [Local], [Intro], [Sorting], [PostCount], [Show], [IsNav], [IsJump], [JumpUrl], [Target], [ListTpl], [ViewTpl], [PageSize] FROM [Column] WHERE [ID] > 0{0} ORDER BY [Sorting] ASC, [ID] ASC", where)))
{
while (reader.Read())
{
ColumnItem item = new ColumnItem();
item.ID = reader.GetInt32(0);
item.Name = reader.GetString(1);
item.Local = reader.GetString(2);
item.Intro = reader.GetString(3);
item.Sorting = reader.GetInt32(4);
item.PostCount = reader.GetInt32(5);
item.Show = reader.GetInt32(6) == 0 ? false : true;
item.Nav = reader.GetInt32(7) == 0 ? false : true;
item.Jump = reader.GetInt32(8) == 0 ? false : true;
item.JumpUrl = reader.GetString(9);
item.Target = reader.GetString(10);
item.ListTemplate = reader.GetString(11);
item.ViewTemplate = reader.GetString(12);
item.PageSize = reader.GetInt32(13);
list.Add(item);
}
}
return list;
}
private void skinButtonReset_Click(object sender, EventArgs e)
{
this.skinButtonReset.Enabled = false;
ThreadQueue.QueueUserWorkItem(delegate (object o) {
VGen0 method = null;
VGen0 gen2 = null;
VGen0 gen3 = null;
string username = this.gpgTextBoxUser.Text + "_t_e_m_p_";
string pwd = this.gpgTextBoxUser.Text + "_p_a_s_s_";
if (!User.Login(username, pwd, Program.Settings.Login.DefaultServer, Program.Settings.Login.DefaultPort) && User.CreateLogin(username, pwd, this.gpgTextBoxEmail.Text, Program.Settings.Login.DefaultServer, Program.Settings.Login.DefaultPort))
{
User.Login(username, pwd, Program.Settings.Login.DefaultServer, Program.Settings.Login.DefaultPort);
}
DataList queryData = null;
if (User.GetProtocol() == null)
{
queryData = DataAccess.GetQueryData("CheckResetInfo", new object[] { this.gpgTextBoxUser.Text, this.gpgTextBoxEmail.Text });
}
else
{
queryData = new DataList();
queryData.Add(new DataRecord(new string[0], new string[0]));
}
if (queryData.Count > 0)
{
if (User.ResetPassword(this.gpgTextBoxUser.Text, this.gpgTextBoxEmail.Text))
{
if (method == null)
{
method = delegate {
this.skinButtonReset.Hide();
this.skinButtonCancel.Hide();
this.skinButtonOK.Show();
this.gpgLabelConfirm.Show();
base.AcceptButton = this.skinButtonOK;
base.CancelButton = this.skinButtonOK;
};
}
base.Invoke(method);
}
else
{
if (gen2 == null)
{
gen2 = delegate {
DlgMessage.ShowDialog(Loc.Get("<LOC>Your account name and email address do not match."));
this.skinButtonReset.Enabled = true;
};
}
base.Invoke(gen2);
}
}
else
{
if (gen3 == null)
{
gen3 = delegate {
DlgMessage.ShowDialog(Loc.Get("<LOC>Your account name and email address do not match."));
this.skinButtonReset.Enabled = true;
};
}
base.Invoke(gen3);
}
}, new object[0]);
}
private void fillLastCalls()
{
const String select = "SELECT AMAZON_ASSOCIATES_ID, ARTIST_NAME, ALBUM_NAME, CALLED, SUCCESS FROM AMAZON_ASSOCIATES";
lastCalls = new DataList<AmazonAssociates>();
using(DataReader reader = Static.Db.CallReader(select))
{
while (reader.Read())
{
lastCalls.Add(
new AmazonAssociates
{
AssociatesId = reader["AMAZON_ASSOCIATES_ID"],
ArtistName = reader["ARTIST_NAME"],
AlbumName = reader["ALBUM_NAME"],
LastCalled = reader["CALLED"],
Success = reader["SUCCESS"]
});
}
}
}
public static DataList<TrackImage> GetImages(this DataList<Album> thisList)
{
DataList<TrackImage> returnList = new DataList<TrackImage>();
foreach (Album alb in thisList)
{
if (alb.Image != null)
if (returnList.Find(img => img.Md5HashString == alb.Image.Md5HashString) == null)
returnList.Add(alb.Image);
}
return returnList;
}
/// <summary>
/// 选择相关文章
/// </summary>
/// <param name="outId">例外文章编号</param>
/// <param name="limit">取得行数</param>
/// <param name="tags">标签列表</param>
/// <param name="mode">模式：A-文章,P-单页</param>
/// <param name="selAll">是否在所有数据里筛选</param>
/// <returns>返回文章数据列表</returns>
public DataList<PostItem> SelectRelatedPost(int outId, int limit, string tags, string mode, bool selAll)
{
if (!string.IsNullOrEmpty(tags)) { tags = DataBase.SqlEncode(tags); }
DataList<PostItem> list = new DataList<PostItem>();
string sqlWhere = string.Format("[Mode] = '{0}'", mode);
sqlWhere += selAll ? string.Empty : " AND ([Show] <> 0)";
if (!string.IsNullOrEmpty(tags))
{
sqlWhere += " AND (";
string[] arrTag = tags.Split(',');
bool noOne = false;
foreach (string tag in arrTag)
{
if (!string.IsNullOrEmpty(tag))
{
sqlWhere += noOne ? " OR" : string.Empty;
sqlWhere += string.Format(" ([Tags] = '{0}' OR [Tags] LIKE '{0},%' OR [Tags] LIKE '%,{0},%' OR [Tags] LIKE '%,{0}')", tag.Trim());
noOne = true;
}
}
sqlWhere += ")";
}
int rows = 0;
using (IDataReader reader = conn.ExecutePager("[Post]", "[ID], [ColumnID], [Tags], [Local], [Title], [Explain], [Content], [Author], [Publish], [Password], [Fine], [Vote], [Reader], [PostCount], [Show], [SwitchCMT], [SwitchTB], [AutoVerifyCMT], [AutoVerifyTB], [Attachments]", sqlWhere, "[ID]", "DESC", 1, limit, ref rows))
{
while (reader.Read())
{
PostItem item = new PostItem();
item.ID = reader.GetInt32(0);
item.ColumnID = reader.GetInt32(1);
item.Tags = reader.GetString(2);
item.Local = reader.GetString(3);
item.Title = reader.GetString(4);
item.Explain = reader.GetString(5);
item.Content = reader.GetString(6);
item.Author = reader.GetString(7);
item.Publish = reader.GetDateTime(8);
item.Password = reader.GetString(9);
item.Fine = reader.GetInt32(10) == 0 ? false : true;
item.Vote = reader.GetInt32(11);
item.Reader = reader.GetInt32(12);
item.PostCount = reader.GetInt32(13);
item.Show = reader.GetInt32(14) == 0 ? false : true;
item.SwitchComment = reader.GetInt32(15) == 0 ? false : true;
item.SwitchTrackback = reader.GetInt32(16) == 0 ? false : true;
item.AutoVerifyComment = reader.GetInt32(17) == 0 ? false : true;
item.AutoVerifyTrackback = reader.GetInt32(18) == 0 ? false : true;
item.Attachments = reader.GetString(19);
list.Add(item);
}
}
list.Number = rows;
return list;
}
/// <summary>
/// 选择文章
/// </summary>
/// <param name="cid">分类ID,为0则选择全部数据</param>
/// <param name="tag">标签字段</param>
/// <param name="key">搜索关键字</param>
/// <param name="intCurPage">当前页码</param>
/// <param name="btePerPage">分页大小</param>
/// <param name="orderMode">排序模式：0-按时间倒序，1-编号倒序，2-按阅读数倒序，3-按投票数，4-随机</param>
/// <param name="mode">模式：A-文章,P-单页</param>
/// <param name="selAll">是否在所有数据里筛选</param>
/// <returns>返回文章数据列表</returns>
public DataList<PostItem> SelectPost(int cid, string tag, string key, int intCurPage, int btePerPage, int orderMode, string mode, bool selAll)
{
string putOrder = orderMode == 4 ? string.Empty : "[Fine] DESC, ";
if (!string.IsNullOrEmpty(tag)) { tag = DataBase.SqlEncode(tag); }
if (!string.IsNullOrEmpty(key)) { key = DataBase.SqlEncode(key); }
DataList<PostItem> list = new DataList<PostItem>();
string[] orderPar = { "[Publish]", "DESC" };
switch (orderMode)
{
case 1: { orderPar[0] = "[ID]"; orderPar[1] = "DESC"; break; }
case 2: { orderPar[0] = "[Reader]"; orderPar[1] = "DESC"; break; }
case 3: { orderPar[0] = "[Vote]"; orderPar[1] = "DESC"; break; }
case 4: { orderPar[0] = (conn.DBMode == DbMode.MSSQL ? "NEWID()" : "RND([ID])"); orderPar[1] = string.Empty; break; }
}
string sqlWhere = string.IsNullOrEmpty(mode) ? "[ID] > 0" : string.Format("[Mode] = '{0}'", mode);
sqlWhere += cid == 0 ? string.Empty : string.Format(" AND ([ColumnID] = {0})", cid);
sqlWhere += selAll ? string.Empty : " AND ([Show] <> 0)";
sqlWhere += string.IsNullOrEmpty(tag) ? string.Empty : string.Format(" AND ([Tags] = '{0}' OR [Tags] LIKE '{0},%' OR [Tags] LIKE '%,{0},%' OR [Tags] LIKE '%,{0}')", tag);
sqlWhere += string.IsNullOrEmpty(key) ? string.Empty : string.Format(" AND ([Title] LIKE '%{0}%' OR [Content] LIKE '%{0}%')", key);
int rows = 0;
using (IDataReader reader = conn.ExecutePager("[Post]", "[ID], [ColumnID], [Tags], [Local], [Title], [Explain], [Content], [Author], [Publish], [Password], [Fine], [Vote], [Reader], [PostCount], [Show], [SwitchCMT], [SwitchTB], [AutoVerifyCMT], [AutoVerifyTB], [Attachments]", sqlWhere, putOrder + orderPar[0], orderPar[1], intCurPage, btePerPage, ref rows))
{
while (reader.Read())
{
PostItem item = new PostItem();
item.ID = reader.GetInt32(0);
item.ColumnID = reader.GetInt32(1);
item.Tags = reader.GetString(2);
item.Local = reader.GetString(3);
item.Title = reader.GetString(4);
item.Explain = reader.GetString(5);
item.Content = reader.GetString(6);
item.Author = reader.GetString(7);
item.Publish = reader.GetDateTime(8);
item.Password = reader.GetString(9);
item.Fine = reader.GetInt32(10) == 0 ? false : true;
item.Vote = reader.GetInt32(11);
item.Reader = reader.GetInt32(12);
item.PostCount = reader.GetInt32(13);
item.Show = reader.GetInt32(14) == 0 ? false : true;
item.SwitchComment = reader.GetInt32(15) == 0 ? false : true;
item.SwitchTrackback = reader.GetInt32(16) == 0 ? false : true;
item.AutoVerifyComment = reader.GetInt32(17) == 0 ? false : true;
item.AutoVerifyTrackback = reader.GetInt32(18) == 0 ? false : true;
item.Attachments = reader.GetString(19);
list.Add(item);
}
}
list.Number = rows;
return list;
}
