static void Main(string[] args)
{
using (DataSequence ds = new DataSequence())
{
ds.PushBack(3.14);
Console.WriteLine(ds);
ds.PushBack(2.71);
ds.PushBack(100);
Console.WriteLine(ds);
ds.PopBack();
Console.WriteLine(ds);
ds.PopBack();
ds.PopBack();
Console.WriteLine(ds);
try
{
ds.PopBack();
}
catch (Exception e)
{
}
}
Util.Pause();
}
List <DataSequence> getData(string fileName)
{
List <DataSequence> result = new List <DataSequence>();
string row = "";
using (StreamReader sr = new StreamReader(fileName))
{
for (int rowNumber = 0; null != ((row = sr.ReadLine())); rowNumber++)
{
if (rowNumber % 1000 == 0)
{
Console.WriteLine(rowNumber);
}
DataSequence sequence = new DataSequence();
sequence.Steps = new List <DataStep>();
for (int i = 0; i < row.Length; i++)
{
DataStep step = new DataStep(FieldLetterTranslator.traslateToField(row[i]), FieldLetterTranslator.traslateToField((i + 1 < row.Length) ? row[i + 1] : '$'));
if (step.Input != null && step.TargetOutput != null)
{
sequence.Steps.Add(step);
}
}
result.Add(sequence);
}
}
return(result);
}
protected DataInsertingEventArgs OnInserting(object data, string scope)
{
var args = new DataInsertingEventArgs(this.Name, DataDictionary <TEntity> .GetDataDictionary(data), scope);
//尝试递增注册的递增键值
DataSequence.Increments(this, (DataDictionary <TEntity>)args.Data);
this.OnInserting(args);
return(args);
}
static void Main(string[] args)
{
using (DataSequence dataSeq = new DataSequence())
{
dataSeq.PushBack(1.0);
dataSeq.PushBack(3.14);
dataSeq.PushBack(2.0);
foreach (double v in dataSeq)
{
Console.WriteLine(v);
}
dataSeq.PopBack();
foreach (double v in dataSeq)
{
Console.WriteLine(v);
}
dataSeq[0] = 2.71828;
Console.WriteLine(dataSeq[0]);
double[] data = dataSeq.GetData();
foreach (double v in data)
{
Console.WriteLine(v);
}
}
DataSequence dataSeq2 = new DataSequence(10);
Debug.Assert(dataSeq2.Size == 10);
try
{
dataSeq2[10] = 100.0;
}
catch (Exception e)
{
Console.WriteLine(e);
}
dataSeq2.PushBack(100.0);
UInt32 size = dataSeq2.Size;
for (UInt32 i = 0; i < size; ++i)
{
Console.WriteLine(dataSeq2[i]);
}
Util.Pause();
}
static List <DataSequence> GetSequences(NNValue[] inputs, NNValue[] outputs)
{
List <DataSequence> dataSequences = new List <DataSequence>();
for (int i = 0; i < inputs.Length; i++)
{
DataStep dataStep = new DataStep(inputs[i], outputs[i]);
DataSequence dataSequence = new DataSequence();
dataSequence.Steps.Add(dataStep);
dataSequences.Add(dataSequence);
}
return(dataSequences);
}
public int Insert(object data, string scope, object state)
{
if (data == null)
{
return(0);
}
//将当前插入数据实体对象转换成数据字典
var dictionary = DataDictionary <TEntity> .GetDataDictionary(data);
//尝试递增注册的递增键值
DataSequence.Increments(this, dictionary);
return(this.OnInsert(dictionary, scope, state));
}
public DataService(Zongsoft.Services.IServiceProvider serviceProvider)
{
if (serviceProvider == null)
{
throw new ArgumentNullException("serviceProvider");
}
_serviceProvider = serviceProvider;
_dataAccess = serviceProvider.ResolveRequired <IDataAccess>();
//获取当前数据搜索键
_searchKey = (DataSearchKeyAttribute)Attribute.GetCustomAttribute(this.GetType(), typeof(DataSearchKeyAttribute), true);
//注册数据递增键序列号
DataSequence.Register(this);
}
public int InsertMany(IEnumerable data, string scope, object state)
{
if (data == null)
{
return(0);
}
//将当前插入数据实体集合对象转换成数据字典集合
var dictionares = DataDictionary <TEntity> .GetDataDictionaries(data);
foreach (var dictionary in dictionares)
{
//尝试递增注册的递增键值
DataSequence.Increments(this, dictionary);
}
return(this.OnInsertMany(dictionares, scope, state));
}
private List <DataSequence> CreateSequences(string xFilename, string yFilename)
{
double[][] x = LoadCsv(xFilename);
double[][] y = LoadCsv(yFilename);
// Create sequences
List <DataSequence> sequences = new List <DataSequence>();
DataSequence ds = new DataSequence();
sequences.Add(ds);
ds.Steps = new List <DataStep>();
for (int i = 0; i < x.Length; ++i)
{
ds.Steps.Add(new DataStep(x[i], y[i]));
}
return(sequences);
}
/// <summary>
/// Sets the network statistics for a given direction for the current frame.
/// </summary>
/// <param name="frameData">The network statistics.</param>
/// <param name="direction">The direction of those statistics.</param>
public void SetFrameStats(NetFrameStats frameData, Direction direction)
{
// First we need to zero out the data before processing the _sparse_ data in the NetFrameStats.
foreach (var pair in Data)
{
pair.Value.Clear(nextFrameIndex, direction);
}
foreach (var pair in frameData.Messages)
{
if (!Data.TryGetValue(pair.Key, out var data))
{
data = new DataSequence(sequenceLength);
}
data.AddFrame(nextFrameIndex, pair.Value, direction);
Data[pair.Key] = data;
}
}
public static List <DataSequence> GetDataSequences(List <int[]> dataInp, List <int[]> dataOutp)
{
List <DataSequence> lds = new List <DataSequence>();
for (int i = 0; i < dataInp.Count; i++)
{
DataSequence sequence = new DataSequence();
sequence.Steps = new List <DataStep>();
for (int j = 0; j < dataInp[i].Length; j++)
{
DataStep ds = new DataStep(GetValue(dataInp[i][j], 11));
sequence.Steps.Add(ds);
}
for (int j = 0; j < dataOutp[i].Length; j++)
{
DataStep ds;
if (j == 0)
{
ds = new DataStep(GetValue(10, 11), GetValue(dataOutp[i][j]));
}
else
{
ds = new DataStep(GetValue(dataOutp[i][j - 1], 11), GetValue(dataOutp[i][j]));
}
sequence.Steps.Add(ds);
}
lds.Add(sequence);
}
return(lds);
}
private void recursiveCreateDataList(object dl, XElement el)
{
Data nd = new Data();
switch (el.Attribute("Type").Value)
{
case "structure":
nd = new Data();
DataSequence sd = new DataSequence();
sd.initValue();
nd.selectStructure(sd);
if (dl is List <Data> )
{
(dl as List <Data>).Add(nd);
}
else if (dl is Data)
{
if ((dl as Data).isStructureSelected())
{
(dl as Data).Structure.Value.Add(nd);
}
else
{
Logger.getLogger().LogError("Error: Invalid parent data type !");
}
}
else
{
Logger.getLogger().LogError("Error: Invalid parent data type !");
}
break;
case "boolean":
nd = new Data();
nd.selectBoolean(el.Attribute("Value").Value == "True" ? true : false);
if (el.Attribute("Desc") != null)
{
nd.Description = el.Attribute("Desc").Value;
}
if (dl is List <Data> )
{
(dl as List <Data>).Add(nd);
}
else if (dl is Data)
{
if ((dl as Data).isStructureSelected())
{
(dl as Data).Structure.Value.Add(nd);
}
else
{
Logger.getLogger().LogError("Error: Invalid parent data type !");
}
}
else
{
Logger.getLogger().LogError("Error: Invalid parent data type !");
}
break;
case "integer":
nd = new Data();
nd.selectInteger(Convert.ToInt32(el.Attribute("Value").Value));
if (el.Attribute("Desc") != null)
{
nd.Description = el.Attribute("Desc").Value;
}
if (dl is List <Data> )
{
(dl as List <Data>).Add(nd);
}
else if (dl is Data)
{
if ((dl as Data).isStructureSelected())
{
(dl as Data).Structure.Value.Add(nd);
}
else
{
Logger.getLogger().LogError("Error: Invalid parent data type !");
}
}
else
{
Logger.getLogger().LogError("Error: Invalid parent data type !");
}
break;
case "bit_string":
nd = new Data();
StringToDataConverter Converter = new StringToDataConverter();
BitString bs = Converter.ConvertToBitstring(el.Attribute("Value").Value);
if (el.Attribute("Desc") != null)
{
nd.Description = el.Attribute("Desc").Value;
}
if (bs != null)
{
nd.selectBitstring(bs);
}
else
{
nd.selectBitstring(new BitString(new byte[] { 0 }));
nd.Bitstring.TrailBitsCnt = 8;
}
if (dl is List <Data> )
{
(dl as List <Data>).Add(nd);
}
else if (dl is Data)
{
if ((dl as Data).isStructureSelected())
{
(dl as Data).Structure.Value.Add(nd);
}
else
{
Logger.getLogger().LogError("Error: Invalid parent data type !");
}
}
else
{
Logger.getLogger().LogError("Error: Invalid parent data type !");
}
break;
default:
break;
}
if (el.HasElements)
{
foreach (XElement ndcn in el.Elements())
{
recursiveCreateDataList(nd, ndcn);
}
}
}
private void recursiveCreateGvl(object dl, XElement el, List <string> nst)
{
Data nd = new Data();
switch (el.Attribute("Type").Value)
{
case "structure":
nd = new Data();
DataSequence sd = new DataSequence();
sd.initValue();
nd.selectStructure(sd);
if (dl is List <Data> )
{
(dl as List <Data>).Add(nd);
}
else if (dl is Data)
{
if ((dl as Data).isStructureSelected())
{
(dl as Data).Structure.Value.Add(nd);
}
else
{
Logger.getLogger().LogError("Error: Invalid parent data type !");
}
}
else
{
Logger.getLogger().LogError("Error: Invalid parent data type !");
}
break;
case "boolean":
nd = new Data();
nd.selectBoolean(el.Attribute("Value").Value == "True" ? true : false);
//nd.ValueChanged += new EventHandler(_ValueChanged);
if (el.Attribute("Desc") != null)
{
nd.Description = el.Attribute("Desc").Value;
}
if (dl is List <Data> )
{
(dl as List <Data>).Add(nd);
}
else if (dl is Data)
{
if ((dl as Data).isStructureSelected())
{
(dl as Data).Structure.Value.Add(nd);
}
else
{
Logger.getLogger().LogError("Error: Invalid parent data type !");
}
}
else
{
Logger.getLogger().LogError("Error: Invalid parent data type !");
}
break;
case "integer":
nd = new Data();
nd.selectInteger(Convert.ToInt32(el.Attribute("Value").Value));
//nd.ValueChanged += new EventHandler(_ValueChanged);
if (el.Attribute("Desc") != null)
{
nd.Description = el.Attribute("Desc").Value;
}
if (dl is List <Data> )
{
(dl as List <Data>).Add(nd);
}
else if (dl is Data)
{
if ((dl as Data).isStructureSelected())
{
(dl as Data).Structure.Value.Add(nd);
}
else
{
Logger.getLogger().LogError("Error: Invalid parent data type !");
}
}
else
{
Logger.getLogger().LogError("Error: Invalid parent data type !");
}
break;
/*
* case "float":
* nd = new Data();
* nd.selectFloatingpoint(new FloatingPoint(new byte[] { 0 }));
* nd.ValueChanged += new EventHandler(_ValueChanged);
* if (dl is List<Data>)
* (dl as List<Data>).Add(nd);
* else if (dl is Data)
* {
* if ((dl as Data).isStructureSelected())
* (dl as Data).Structure.Value.Add(nd);
* else
* MessageBox.Show("Error: Invalid parent data type !");
* }
* else
* MessageBox.Show("Error: Invalid parent data type !");
* break;
*/
case "bit_string":
nd = new Data();
StringToDataConverter Converter = new StringToDataConverter();
BitString bs = Converter.ConvertToBitstring(el.Attribute("Value").Value);
if (bs != null)
{
nd.selectBitstring(bs);
}
else
{
nd.selectBitstring(new BitString(new byte[] { 0 }));
nd.Bitstring.TrailBitsCnt = 8;
}
if (el.Attribute("Desc") != null)
{
nd.Description = el.Attribute("Desc").Value;
}
//nd.ValueChanged += new EventHandler(_ValueChanged);
if (dl is List <Data> )
{
(dl as List <Data>).Add(nd);
}
else if (dl is Data)
{
if ((dl as Data).isStructureSelected())
{
(dl as Data).Structure.Value.Add(nd);
}
else
{
Logger.getLogger().LogError("Error: Invalid parent data type !");
}
}
else
{
Logger.getLogger().LogError("Error: Invalid parent data type !");
}
break;
default:
if (!nst.Contains(el.Attribute("Type").Value))
{
nst.Add(el.Attribute("Type").Value);
}
break;
}
if (el.HasElements)
{
foreach (XElement ndcn in el.Elements())
{
recursiveCreateGvl(nd, ndcn, nst);
}
}
}
//Search Button
private void button2_Click(object sender, EventArgs e)
{
string tempMakeModelID = "[Make Model ID]";
string tempColorID = "[Color ID]";
string tempMile = "Mileage";
string tempPrice = "Price";
List <int> MakeModelIDsList = new List <int>();
int numofIDs = -1;
if (makeTxtBox.Text == "" && modelTxtBox.Text == "" && priceMinBox.Value == 0 && priceMaxBox.Value == 0 && colorTxtBox.Text == "" && carLotTxtBox.Text == "" && carMileage.Value == 0)
{
con = new SqlConnection(@"Data Source=(local)\SQLEXPRESS;Initial Catalog=Car Dealership;Integrated Security=True");
con.Open();
cmd = new SqlCommand("SELECT * FROM CarID", con);
//Working one
//SqlDataAdapter sqlDa = new SqlDataAdapter("SELECT * FROM CarID WHERE[Make Model ID] = " + "[Make Model ID]" + " AND [Color ID] = " + "[Color ID]" + " AND Mileage = " + tempMile + " AND Price = " + tempPrice + "", con);
SqlDataAdapter sqlDa = new SqlDataAdapter("SELECT * FROM CarID WHERE[Make Model ID]=[Make Model ID] and [Color ID]=[Color ID] and Mileage=Mileage and (Price = Price AND Price!=0)", con);
//SqlDataAdapter sqlDa = new SqlDataAdapter("SELECT * FROM CarID,LotCarID WHERE[Make Model ID] = " + "[Make Model ID]" + " AND [Color ID] = " + "[Color ID]" + " AND Mileage = " + tempMile + " AND Price = " + tempPrice + " AND CarID.[Car ID] = LotCarID.[Car ID]", con);
DataTable dtbl = new DataTable();
sqlDa.Fill(dtbl);
dataGridView1.DataSource = dtbl;
cmd.ExecuteNonQuery();
con.Close();
}
else if (makeTxtBox.Text != "" && modelTxtBox.Text == "")
{
con = new SqlConnection(@"Data Source=(local)\SQLEXPRESS;Initial Catalog=Car Dealership;Integrated Security=True");
con.Open();
//Getting all the MakeModel Ids based on selected Make
string Sql = "SELECT [Make Model ID] FROM MakeModelID WHERE([Make] = '" + makeTxtBox.Text + "')";
SqlCommand cmd = new SqlCommand(Sql, con);
SqlDataReader DR = cmd.ExecuteReader();
while (DR.Read())
{
MakeModelIDsList.Add(DR.GetInt32(0));
numofIDs++;
}
DR.Close();
///Getting ColorID
if (colorTxtBox.Text != "")
{
cmd = new SqlCommand("Select [Color ID] FROM ColorID WHERE ([Color] = '" + colorTxtBox.Text + "')", con);
tempColorID = cmd.ExecuteScalar().ToString();
}
else
{
tempColorID = "[Color ID]";
}
if (priceMaxBox.Value == 0)
{
priceMaxBox.Value = 1000000;
}
if (carMileage.Value == 0)
{
carMileage.Value = 1000000;
}
con.Close();
ArrayList sequence = new ArrayList();
try
{
int i = 0;
con = new SqlConnection();
con.ConnectionString = (@"Data Source=(local)\SQLEXPRESS;Initial Catalog=Car Dealership;Integrated Security=True");
cmd = new SqlCommand();
cmd.Connection = con;
con.Open();
while (i <= numofIDs)
{
// Working one
//cmd.CommandText = "SELECT* FROM CarID WHERE[Make Model ID] = " + MakeModelIDsList[i] + " AND[Color ID] = " + tempColorID + " AND(Mileage <= " + carMileage.Value + ") AND(Price BETWEEN " + priceMinBox.Value + " AND " + priceMaxBox.Value + ")";
cmd.CommandText = "SELECT * FROM CarID WHERE[Make Model ID] = " + MakeModelIDsList[i] + " AND[Color ID] = " + tempColorID + " AND(Mileage <= " + carMileage.Value + ") AND(Price BETWEEN " + priceMinBox.Value + " AND " + priceMaxBox.Value + " AND Price!=0)";
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
DataSequence d = new DataSequence();
d.ID = (int)reader[0];
d.MakeModelID = (int)reader[1];
d.VIN = (int)reader[2];
d.ColorID = (int)reader[3];
d.Mileage = (int)reader[4];
d.Price = (int)reader[5];
d.Picture = reader[6].ToString();
sequence.Add(d);
}
i++;
reader.Close();
}
dataGridView1.DataSource = sequence;
}
finally
{
con.Close();
}
}
else
{
con = new SqlConnection(@"Data Source=(local)\SQLEXPRESS;Initial Catalog=Car Dealership;Integrated Security=True");
con.Open();
//Getting Make Model ID
if (makeTxtBox.Text != "" && modelTxtBox.Text != "")
{
cmd = new SqlCommand("Select [Make Model ID] FROM MakeModelID WHERE ([Make] = '" + makeTxtBox.Text + "') AND ([Model] = '" + modelTxtBox.Text + "')", con);
tempMakeModelID = cmd.ExecuteScalar().ToString();
}
///Getting ColorID
if (colorTxtBox.Text != "")
{
cmd = new SqlCommand("Select [Color ID] FROM ColorID WHERE ([Color] = '" + colorTxtBox.Text + "')", con);
tempColorID = cmd.ExecuteScalar().ToString();
}
else
{
tempColorID = "[Color ID]";
}
if (priceMaxBox.Value == 0)
{
priceMaxBox.Value = 1000000;
}
if (carMileage.Value == 0)
{
carMileage.Value = 1000000;
}
cmd = new SqlCommand("SELECT * FROM CarID", con);
//SqlDataAdapter sqlDa = new SqlDataAdapter("SELECT * FROM CarID WHERE[Make Model ID] = " + tempMakeModelID + " AND [Color ID] = " + tempColorID + " AND (Mileage <= " + carMileage.Value + ") AND (Price BETWEEN " + priceMinBox.Value + " AND " + priceMaxBox.Value + ")", con);
SqlDataAdapter sqlDa = new SqlDataAdapter("SELECT * FROM CarID WHERE[Make Model ID] = " + tempMakeModelID + " AND [Color ID] = " + tempColorID + " AND (Mileage <= " + carMileage.Value + ") AND (Price BETWEEN " + priceMinBox.Value + " AND " + priceMaxBox.Value + " AND Price!=0)", con);
DataTable dtbl = new DataTable();
sqlDa.Fill(dtbl);
dataGridView1.DataSource = dtbl;
cmd.ExecuteNonQuery();
con.Close();
}
}
void OnAddDataClick(object sender, EventArgs e)
{
switch ((sender as ToolStripItem).Text)
{
case "Add Structure":
Data nd = new Data();
DataSequence sd = new DataSequence();
sd.initValue();
nd.selectStructure(sd);
if ((sender as ToolStripItem).Tag is List <Data> )
{
((sender as ToolStripItem).Tag as List <Data>).Add(nd);
}
else if (((sender as ToolStripItem).Tag is NodeGData))
{
if ((((sender as ToolStripItem).Tag as NodeGData).Tag is Data) && ((((sender as ToolStripItem).Tag as NodeGData).Tag as Data).isStructureSelected()))
{
(((sender as ToolStripItem).Tag as NodeGData).Tag as Data).Structure.Value.Add(nd);
}
else
{
MessageBox.Show("Error: Invalid parent data type !");
}
}
else
{
MessageBox.Show("Error: Invalid parent data type !");
}
break;
case "Add Boolean":
nd = new Data();
nd.selectBoolean(false);
nd.ValueChanged += new EventHandler(_ValueChanged);
if ((sender as ToolStripItem).Tag is List <Data> )
{
((sender as ToolStripItem).Tag as List <Data>).Add(nd);
}
else if (((sender as ToolStripItem).Tag is NodeGData))
{
if ((((sender as ToolStripItem).Tag as NodeGData).Tag is Data) && ((((sender as ToolStripItem).Tag as NodeGData).Tag as Data).isStructureSelected()))
{
(((sender as ToolStripItem).Tag as NodeGData).Tag as Data).Structure.Value.Add(nd);
}
else
{
MessageBox.Show("Error: Invalid parent data type !");
}
}
else
{
MessageBox.Show("Error: Invalid parent data type !");
}
break;
case "Add Integer":
nd = new Data();
nd.selectInteger(0);
nd.ValueChanged += new EventHandler(_ValueChanged);
if ((sender as ToolStripItem).Tag is List <Data> )
{
((sender as ToolStripItem).Tag as List <Data>).Add(nd);
}
else if (((sender as ToolStripItem).Tag is NodeGData))
{
if ((((sender as ToolStripItem).Tag as NodeGData).Tag is Data) && ((((sender as ToolStripItem).Tag as NodeGData).Tag as Data).isStructureSelected()))
{
(((sender as ToolStripItem).Tag as NodeGData).Tag as Data).Structure.Value.Add(nd);
}
else
{
MessageBox.Show("Error: Invalid parent data type !");
}
}
else
{
MessageBox.Show("Error: Invalid parent data type !");
}
break;
case "Add Float":
nd = new Data();
nd.selectFloatingpoint(new FloatingPoint(new byte[] { 0 }));
nd.ValueChanged += new EventHandler(_ValueChanged);
if ((sender as ToolStripItem).Tag is List <Data> )
{
((sender as ToolStripItem).Tag as List <Data>).Add(nd);
}
else if (((sender as ToolStripItem).Tag is NodeGData))
{
if ((((sender as ToolStripItem).Tag as NodeGData).Tag is Data) && ((((sender as ToolStripItem).Tag as NodeGData).Tag as Data).isStructureSelected()))
{
(((sender as ToolStripItem).Tag as NodeGData).Tag as Data).Structure.Value.Add(nd);
}
else
{
MessageBox.Show("Error: Invalid parent data type !");
}
}
else
{
MessageBox.Show("Error: Invalid parent data type !");
}
break;
case "Add Bitstring":
nd = new Data();
nd.selectBitstring(new BitString());
nd.ValueChanged += new EventHandler(_ValueChanged);
if ((sender as ToolStripItem).Tag is List <Data> )
{
((sender as ToolStripItem).Tag as List <Data>).Add(nd);
}
else if (((sender as ToolStripItem).Tag is NodeGData))
{
if ((((sender as ToolStripItem).Tag as NodeGData).Tag is Data) && ((((sender as ToolStripItem).Tag as NodeGData).Tag as Data).isStructureSelected()))
{
(((sender as ToolStripItem).Tag as NodeGData).Tag as Data).Structure.Value.Add(nd);
}
else
{
MessageBox.Show("Error: Invalid parent data type !");
}
}
else
{
MessageBox.Show("Error: Invalid parent data type !");
}
break;
case "Delete":
if (((sender as ToolStripItem).Tag is NodeGData))
{
listViewGoose_Clear();
if ((((sender as ToolStripItem).Tag as NodeGData).Tag is Data))
{
(((sender as ToolStripItem).Tag as NodeGData).Tag as Data).ValueChanged -= new EventHandler(_ValueChanged);
_dataList.Remove((((sender as ToolStripItem).Tag as NodeGData).Tag as Data));
}
}
break;
default:
break;
}
updateTree();
}
