//CRUD
public void Creating(RecordLine _cellBook)
{
using (connection = new OdbcConnection(connectionString))
{
try
{
connection.Open();
string query = "INSERT INTO PhoneBookTable(LastName, FirstName, MidleName, Phone, Email) " +
"VALUES(?, ?, ?, ?, ?)";
using (OdbcCommand creatingCellBook = new OdbcCommand(query, connection))
{
creatingCellBook.Parameters.Add("LastName", OdbcType.VarChar).Value = _cellBook.LastName;
creatingCellBook.Parameters.Add("FirstName", OdbcType.VarChar).Value = _cellBook.FirstName;
creatingCellBook.Parameters.Add("MidleName", OdbcType.VarChar).Value = _cellBook.MiddleName;
creatingCellBook.Parameters.Add("Phone", OdbcType.VarChar).Value = _cellBook.Phone;
creatingCellBook.Parameters.Add("Email", OdbcType.VarChar).Value = _cellBook.Email;
try { creatingCellBook.ExecuteNonQuery(); }
catch (OdbcException ex)
{
Debug.WriteLine(ex.Message + "\n\n" + "StackTrace[Creating() => ExecuteNonQuery()]: \n\n" + ex.StackTrace);
return;
}
}
}
catch (OdbcException ex)
{
Debug.WriteLine(ex.Message + "\n\n" + "StackTrace[Creating() => connection]: \n\n" + ex.StackTrace);
}
}
}
public void Updating(RecordLine _cellBook)
{
using (connection = new OdbcConnection(connectionString))
{
try
{
connection.Open();
string query = "UPDATE PhoneBookTable SET (LastName, FirstName, MidleName, Phone, Email) = " +
"(?, ?, ?, ?, ?) WHERE id = ?";
using (OdbcCommand updatingCellBook = new OdbcCommand(query, connection))
{
updatingCellBook.Parameters.Add("LastName", OdbcType.VarChar).Value = _cellBook.LastName;
updatingCellBook.Parameters.Add("FirstName", OdbcType.VarChar).Value = _cellBook.FirstName;
updatingCellBook.Parameters.Add("MidleName", OdbcType.VarChar).Value = _cellBook.MiddleName;
updatingCellBook.Parameters.Add("Phone", OdbcType.VarChar).Value = _cellBook.Phone;
updatingCellBook.Parameters.Add("Email", OdbcType.VarChar).Value = _cellBook.Email;
updatingCellBook.Parameters.Add("id", OdbcType.Int).Value = _cellBook.Id;
try { updatingCellBook.ExecuteNonQuery(); }
catch (OdbcException ex)
{
Debug.WriteLine(ex.Message + "\n\n" + "StackTrace[Updating() => ExecuteNonQuery()]: \n\n" + ex.StackTrace);
return;
}
}
}
catch (OdbcException ex)
{
Debug.WriteLine(ex.Message + "\n\n" + "StackTrac" +
"e[Updating() => connection]: \n\n" + ex.StackTrace);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
RecordLine tmpRecordLine = new RecordLine();
if (TryUpdateModel(tmpRecordLine, new FormValueProvider(ModelBindingExecutionContext)))
{
RecordLineRepository.GetRepository().Creating(tmpRecordLine);
Page.Response.Redirect(Page.Request.Url.ToString(), true);
}
}
}
public void WriteRecordLine(RecordLine line)
{
if (_state != State.Record)
{
throw new InvalidOperationException("Invalid in current state");
}
_writer.WriteLine(LineBegin);
foreach (var tuple in line.GetProperties())
{
_writer.WriteLine($"-{tuple.Key}: {tuple.Value}");
}
}
public static RecordSetView LoadRecordLine(RecordLine line, string directory)
{
if (line is RecordLineStream1D)
{
return(new RecordSetView((RecordLineStream1D)line, directory));
}
else if (line is RecordLineStream2D)
{
return(new RecordSetView((RecordLineStream2D)line, directory));
}
else
{
return(null);
}
}
private int FindAbsAdrLnNum(string hexAdr)
{
hexAdr = hexAdr.ToUpper();
if (hexAdr.Length == 4)
{
var lnCtr = 1;
foreach (var line in File.ReadLines(_hexFilename))
{
var record = new RecordLine(line);
if (record.AddressList.Contains(hexAdr))
{
return(lnCtr);
}
lnCtr++;
}
}
else if (hexAdr.Length == 8)
{
var extendedAddress = hexAdr.Substring(0, 4);
var lineAdr = hexAdr.Substring(4, 4);
var extAdrLine = GenerateHexLine(SpecialRecAdr, RecordType.ExtendedLinearAddress, extendedAddress);
var foundFlag = false;
var lnCtr = 1;
foreach (var line in File.ReadLines(_hexFilename))
{
if (line.ToUpper() == extAdrLine)
{
foundFlag = true;
}
if (foundFlag)
{
var record = new RecordLine(line);
if (record.AddressList.Contains(lineAdr))
{
return(lnCtr);
}
}
lnCtr++;
}
}
return(0);
}
public void AddRecordedFileToSet(RecordLine line)
{
lock (_setLock) {
if (_firstSetWrite)
{
BeginSetWrite();
_firstSetWrite = false;
}
_setWriter.BeginRecord();
_setWriter.WriteRecordLine(line);
_setWriter.EndRecord();
_writeCount++;
}
}
public IEnumerable <RecordLine> ReadingAll()
{
using (connection = new OdbcConnection(connectionString))
{
try
{
connection.Open();
string query = "SELECT * FROM phonebooktable ORDER BY id";
using (OdbcCommand readingCellBook = new OdbcCommand(query, connection))
{
try
{
List <RecordLine> cellsBook = new List <RecordLine>();
RecordLine tmp;
OdbcDataReader reader = readingCellBook.ExecuteReader(CommandBehavior.CloseConnection);
while (reader.Read() == true)
{
tmp = new RecordLine();
tmp.Id = reader.GetString(0);
tmp.LastName = reader.GetString(1);
tmp.FirstName = reader.GetString(2);
tmp.MiddleName = reader.GetString(3);
tmp.Phone = reader.GetString(4);
tmp.Email = reader.GetString(5);
cellsBook.Add(tmp);
}
return(cellsBook);
}
catch (OdbcException ex)
{
Debug.WriteLine(ex.Message + "\n\n" + "StackTrace[ReadingAll() => ExecuteReader()]: \n\n" + ex.StackTrace);
return(null);
}
}
}
catch (OdbcException ex)
{
Debug.WriteLine(ex.Message + "\n\n" + "StackTrace[ReadingAll() => connection]: \n\n" + ex.StackTrace);
return(null);
}
}
}
public RecordLine ReadingById(int _id)
{
using (connection = new OdbcConnection(connectionString))
{
try
{
connection.Open();
string query = "SELECT * FROM phonebooktable WHERE id = ?";
using (OdbcCommand readingCellBook = new OdbcCommand(query, connection))
{
readingCellBook.Parameters.Add("id", OdbcType.Int).Value = _id;
try
{
RecordLine tmpCellBook = new RecordLine();
OdbcDataReader reader = readingCellBook.ExecuteReader(CommandBehavior.CloseConnection);
reader.Read();
tmpCellBook.Id = reader.GetString(0);
tmpCellBook.LastName = reader.GetString(1);
tmpCellBook.FirstName = reader.GetString(2);
tmpCellBook.MiddleName = reader.GetString(3);
tmpCellBook.Phone = reader.GetString(4);
tmpCellBook.Email = reader.GetString(5);
return(tmpCellBook);
}
catch (OdbcException ex)
{
Debug.WriteLine(ex.Message + "\n\n" + "StackTrace[ReadingById() => ExecuteReader]: \n\n" + ex.StackTrace);
return(null);
}
}
}
catch (OdbcException ex)
{
Debug.WriteLine(ex.Message + "\n\n" + "StackTrac" +
"e[ReadingById() => connection]: \n\n" + ex.StackTrace);
return(null);
}
}
}
public void AddRecordedFileToSet(RecordLine line)
{
//
}
//void Test1(PLCCom);
static void Main(string[] args)
{
try
{
int LogicalStationNum = Convert.ToInt32(ConfigurationManager.AppSettings["LogicalStationNum"]);
Log.AddConsoleLogger(ConfigurationManager.AppSettings["LogFormatter"]);
Log.OpenLog("PLC-Console");
PLCCom com = new PLCCom(LogicalStationNum);
int ret = com.Open();
if (0 != ret)
{
throw new Exception("Open com fail.");
}
RecordLine line1 = new RecordLine("MD1", "D01001", "D01002");
Record record1_1 = new Record("D01012", "D01026");
Record record1_2 = new Record("D01032", "D01046");
RecordLine line2 = new RecordLine("MD2", "D01101", "D01102");
Record record2_1 = new Record("D01112", "D01126");
Record record2_2 = new Record("D01132", "D01146");
RecordLine line3 = new RecordLine("MD3", "D01201", "D01202");
Record record3_1 = new Record("D01212", "D01226");
Record record3_2 = new Record("D01232", "D01246");
RecordLine line4 = new RecordLine("MD4", "D01301", "D01302");
Record record4_1 = new Record("D01312", "D01326");
Record record4_2 = new Record("D01332", "D01346");
if (false)
{
Console.WriteLine("Test read mark.");
while (true)
{
short lineMark1 = CommUtil.GetDevice(line1.ReadMarkDevice, com);
if (lineMark1 != 0)
{
Console.WriteLine(String.Format("{2},{3} -- {0}'s read mark is set to {1}.", line1.PalletizerName, lineMark1, DateTime.Now, DateTime.Now.Millisecond));
}
short lineMark2 = CommUtil.GetDevice(line2.ReadMarkDevice, com);
if (lineMark2 != 0)
{
Console.WriteLine(String.Format("{2},{3} -- {0}'s read mark is set to {1}.", line2.PalletizerName, lineMark2, DateTime.Now, DateTime.Now.Millisecond));
}
short lineMark3 = CommUtil.GetDevice(line3.ReadMarkDevice, com);
if (lineMark3 != 0)
{
Console.WriteLine(String.Format("{2},{3} -- {0}'s read mark is set to {1}.", line3.PalletizerName, lineMark3, DateTime.Now, DateTime.Now.Millisecond));
}
short lineMark4 = CommUtil.GetDevice(line4.ReadMarkDevice, com);
if (lineMark4 != 0)
{
Console.WriteLine(String.Format("{2},{3} -- {0}'s read mark is set to {1}.", line4.PalletizerName, lineMark4, DateTime.Now, DateTime.Now.Millisecond));
}
}
}
else
{
while (true)
{
Console.Write("\nPush enter to write data.");
Console.ReadLine();
line1.SetPlateCode("11111111", com);
record1_1.SetBoxCode("1A0000000000000000000000000", com);
record1_1.SetAmount(11, com);
record1_2.SetBoxCode("1B0000000000000000000000000", com);
record1_2.SetAmount(12, com);
CommUtil.SetDevice(1, line1.ReadMarkDevice, com);
line2.SetPlateCode("22222222", com);
record2_1.SetBoxCode("2A0000000000000000000000000", com);
record2_1.SetAmount(21, com);
record2_2.SetBoxCode("2B0000000000000000000000000", com);
record2_2.SetAmount(22, com);
CommUtil.SetDevice(1, line2.ReadMarkDevice, com);
line3.SetPlateCode("33333333", com);
record3_1.SetBoxCode("3A0000000000000000000000000", com);
record3_1.SetAmount(31, com);
record3_2.SetBoxCode("3B0000000000000000000000000", com);
record3_2.SetAmount(32, com);
CommUtil.SetDevice(1, line3.ReadMarkDevice, com);
line4.SetPlateCode("44444444", com);
record4_1.SetBoxCode("4A0000000000000000000000000", com);
record4_1.SetAmount(41, com);
record4_2.SetBoxCode("4B0000000000000000000000000", com);
record4_2.SetAmount(42, com);
CommUtil.SetDevice(1, line4.ReadMarkDevice, com);
}
}
}
catch (System.Exception ex)
{
Console.WriteLine(ex.Message);
}
}
private RecordSetView(RecordLineStream2D line, string directory) : this()
{
_input = line;
_directory = directory;
}
private RecordSetView(Record set, string directory) : this()
{
_recording = set;
_input = null;
_directory = directory;
}
