public DocumentDbTests.Metadata.MyTrackedDoc Resolve(System.Data.Common.DbDataReader reader)
{
var id = reader.GetFieldValue <System.Guid>(0);
if (_identityMap.TryGetValue(id, out var existing))
{
return(existing);
}
DocumentDbTests.Metadata.MyTrackedDoc document;
document = _serializer.FromJson <DocumentDbTests.Metadata.MyTrackedDoc>(reader, 1);
if (!reader.IsDBNull(2))
{
var correlationId = reader.GetFieldValue <string>(2);
document.CorrelationId = correlationId;
}
if (!reader.IsDBNull(3))
{
var causationId = reader.GetFieldValue <string>(3);
document.CausationId = causationId;
}
if (!reader.IsDBNull(4))
{
var lastModifiedBy = reader.GetFieldValue <string>(4);
document.LastModifiedBy = lastModifiedBy;
}
_session.MarkAsDocumentLoaded(id, document);
_identityMap[id] = document;
StoreTracker(_session, document);
return(document);
}
public SignalProp getCurSigProp()
{
SignalProp prop = null;
String sql = " SELECT s.lampId, s.signalName, s.type, s.state, c.state as specState, direction, dir_to, s.ip FROM cursignal c LEFT JOIN signal s ON c.lampId=s.lampId AND c.type=1 ";
MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(sql, myConn);
System.Data.Common.DbDataReader reader = cmd.ExecuteReader();
try
{
if (reader.Read())
{
prop = new SignalProp();
prop.SignalID = reader.GetString(0).ToUpper();
prop.SignalName = DBStringToNormal(reader.GetString(1));
prop.Type = reader.IsDBNull(2)? (byte)0 : (byte)reader.GetInt16(2);
prop.State = reader.GetString(3);
prop.SpecState = reader.IsDBNull(4) ? (byte)0 : (byte)reader.GetInt16(4);
prop.DirFrom = reader.IsDBNull(5) ? (byte)0 : (byte)reader.GetInt16(5);
prop.DirTo = reader.IsDBNull(6) ? (byte)0 : (byte)reader.GetInt16(6);
prop.Ip = reader.GetString(7);
}
reader.Close();
}
catch (Exception e)
{
reader.Close();
Trace.TraceError("get cur signal prop " + e.StackTrace);
}
return(prop);
}
public override void ApplyReaderDataToEvent(System.Data.Common.DbDataReader reader, Marten.Events.IEvent e)
{
if (!reader.IsDBNull(3))
{
var sequence = reader.GetFieldValue <long>(3);
e.Sequence = sequence;
}
if (!reader.IsDBNull(4))
{
var id = reader.GetFieldValue <System.Guid>(4);
e.Id = id;
}
var streamId = reader.GetFieldValue <System.Guid>(5);
e.StreamId = streamId;
if (!reader.IsDBNull(6))
{
var version = reader.GetFieldValue <long>(6);
e.Version = version;
}
if (!reader.IsDBNull(7))
{
var timestamp = reader.GetFieldValue <System.DateTimeOffset>(7);
e.Timestamp = timestamp;
}
if (!reader.IsDBNull(8))
{
var tenantId = reader.GetFieldValue <string>(8);
e.TenantId = tenantId;
}
var isArchived = reader.GetFieldValue <bool>(9);
e.IsArchived = isArchived;
}
public static string SafeGetString(this System.Data.Common.DbDataReader reader, int colIndex)
{
if (!reader.IsDBNull(colIndex))
{
return(reader.GetString(colIndex));
}
return(string.Empty);
}
public static T Gr <T>(this System.Data.Common.DbDataReader Dr, int I)
{
if (Dr.IsDBNull(I))
{
return(default(T));
}
return((T)Dr.GetValue(I));
}
public static decimal GetDecValue(System.Data.Common.DbDataReader reader, int ordinal)
{
if (reader.IsDBNull(ordinal))
{
return(0);
}
else
{
return(reader.GetDecimal(ordinal));
}
}
public static int GetRefValue(System.Data.Common.DbDataReader reader, int ordinal)
{
if (reader.IsDBNull(ordinal))
{
return(0);
}
else
{
return(reader.GetInt32(ordinal));
}
}
public DocumentDbTests.Metadata.MyTrackedDoc Resolve(System.Data.Common.DbDataReader reader)
{
DocumentDbTests.Metadata.MyTrackedDoc document;
document = _serializer.FromJson <DocumentDbTests.Metadata.MyTrackedDoc>(reader, 0);
if (!reader.IsDBNull(1))
{
var correlationId = reader.GetFieldValue <string>(1);
document.CorrelationId = correlationId;
}
if (!reader.IsDBNull(2))
{
var causationId = reader.GetFieldValue <string>(2);
document.CausationId = causationId;
}
if (!reader.IsDBNull(3))
{
var lastModifiedBy = reader.GetFieldValue <string>(3);
document.LastModifiedBy = lastModifiedBy;
}
return(document);
}
public List <SignalPos> getPosList()
{
// position// position
List <SignalPos> posList = new List <SignalPos>();
String sql = "SELECT lampId, compass, dir, x, y FROM signalPos";
MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(sql, myConn);
System.Data.Common.DbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
SignalPos pos = new SignalPos();
pos.LampId = reader.GetString(0).Trim().ToUpper(); //.Replace('-', '_')
pos.Compass = reader.IsDBNull(1) ? 1 : reader.GetInt32(1);
pos.Dir = reader.IsDBNull(2) ? 1 : reader.GetInt32(2);
pos.X = reader.IsDBNull(3) ? 1 : reader.GetInt32(3);
pos.Y = reader.IsDBNull(4) ? 1 : reader.GetInt32(4);
posList.Add(pos);
}
reader.Close();
return(posList);
}
public List <SignalProp> getSignalList()
{
List <SignalProp> list = new List <SignalProp>();
String sql = " SELECT lampId, signalName, type, ip FROM signal WHERE type IN (1, 4, 5) ";
MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(sql, myConn);
System.Data.Common.DbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
SignalProp prop = new SignalProp();
prop.SignalID = reader.GetString(0).Trim().ToUpper(); //.Replace('-', '_')
prop.SignalName = DBStringToNormal(reader.GetString(1).Trim());
prop.Type = reader.IsDBNull(2) ? (byte)1 : (byte)reader.GetInt32(2);
prop.Ip = reader.IsDBNull(3) ? "" : reader.GetString(3).Trim();
list.Add(prop);
}
reader.Close();
return(list);
}
private static void QueryEmployee(Oracle.DataAccess.Client.OracleConnection conn)
{
string sql = "Select Emp_Id, Emp_No, Emp_Name, Mng_Id from Employee";
// Tạo một đối tượng Command.
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand();
// Liên hợp Command với Connection.
cmd.Connection = conn;
cmd.CommandText = sql;
using (System.Data.Common.DbDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
// Chỉ số (index) của cột Emp_ID trong câu lệnh SQL.
int empIdIndex = reader.GetOrdinal("Emp_Id"); // 0
long empId = Convert.ToInt64(reader.GetValue(0));
// Chỉ số của cột Emp_No là 1.
string empNo = reader.GetString(1);
int empNameIndex = reader.GetOrdinal("Emp_Name");// 2
string empName = reader.GetString(empNameIndex);
int mngIdIndex = reader.GetOrdinal("Mng_Id");
long?mngId = null;
if (!reader.IsDBNull(mngIdIndex))
{
mngId = Convert.ToInt64(reader.GetValue(mngIdIndex));
}
Console.WriteLine("--------------------");
Console.WriteLine("empIdIndex:" + empIdIndex);
Console.WriteLine("EmpId:" + empId);
Console.WriteLine("EmpNo:" + empNo);
Console.WriteLine("EmpName:" + empName);
Console.WriteLine("MngId:" + mngId);
}
}
}
}
public static string GetReaderValueString(System.Data.Common.DbDataReader reader, string name)
{
var ordinal = reader.GetOrdinal(name);
if (reader.IsDBNull(ordinal))
{
return(null);
}
try
{
return(reader.GetString(ordinal));
}
catch (Exception ex)
{
throw ex;
}
return(null);
}
private static Domain.IncomeGroupLimitGroup loadIncomeGroup(System.Data.Common.DbDataReader reader)
{
Domain.IncomeGroupLimitGroup income = new Domain.IncomeGroupLimitGroup();
income.Limitation = new List <Domain.IncomeGroupLimit>();
Domain.IncomeGroupLimit limit = null;
while (reader.Read())
{
var currentId = reader.GetGuid(0);
if (income.Id != currentId)
{
income.Id = currentId;
income.CompanyId = reader.GetGuid(1);
income.IncomeGroupId = reader.IsDBNull(2) ? (Guid?)null : reader.GetGuid(2);
income.Remark = reader.GetString(3);
income.Limitation = new List <Domain.IncomeGroupLimit>();
}
var currlimitId = reader.GetGuid(4);
if (!income.Limitation.Any(it => it.Id == currlimitId))
{
limit = new Domain.IncomeGroupLimit();
limit.Id = currlimitId;
limit.IncomeId = reader.GetGuid(5);
limit.Type = (Common.Enums.PeriodType)reader.GetByte(6);
limit.Price = reader.GetInt32(7);
limit.Airlines = reader.GetString(12);
limit.IsOwnerPolicy = reader.GetBoolean(13);
limit.Period = new List <Domain.IncomeGroupPeriod>();
income.Limitation.Add(limit);
}
Domain.IncomeGroupPeriod period = new Domain.IncomeGroupPeriod();
period.DeductId = reader.GetGuid(8);
period.StartPeriod = reader.GetDecimal(9);
period.EndPeriod = reader.GetDecimal(10);
period.Period = reader.GetDecimal(11);
limit.Period.Add(period);
}
return(income);
}
/// <summary>
/// Gets an int column.
/// </summary>
/// <param name="reader"></param>
/// <param name="ordinal"></param>
/// <returns></returns>
public static Int32?GetNInt32(this System.Data.Common.DbDataReader reader, int ordinal)
{
return(reader.IsDBNull(ordinal) ? (int?)null : reader.GetInt32(ordinal));
}
/// <summary>
/// Gets an int column. Slower then GetOrdinal + GetInt32
/// </summary>
/// <param name="reader"></param>
/// <param name="name"></param>
/// <returns></returns>
public static Int32?GetNInt32(this System.Data.Common.DbDataReader reader, string name)
{
int ordinal = reader.GetOrdinal(name);
return(reader.IsDBNull(ordinal) ? (int?)null : reader.GetInt32(ordinal));
}
/// <summary>
/// Gets a byte array column.
/// Use this for small byte array only, such as timestamps
///
/// Slower then GetOrdinal + GetByteArray(ordinal)
/// </summary>
/// <param name="reader"></param>
/// <param name="name">The name of the column</param>
/// <returns></returns>
public static byte[]? GetByteArray(this System.Data.Common.DbDataReader reader, string name)
{
int ordinal = reader.GetOrdinal(name);
return(reader.IsDBNull(ordinal) ? null : (byte[])reader.GetValue(ordinal));
}
/// <summary>
/// Gets a byte array column.
/// Use this for small byte array only, such as timestamps
/// </summary>
/// <param name="reader"></param>
/// <param name="ordinal"></param>
/// <returns></returns>
public static byte[]? GetByteArray(this System.Data.Common.DbDataReader reader, int ordinal)
{
return(reader.IsDBNull(ordinal) ? null : (byte[])reader.GetValue(ordinal));
}
/// <summary>
/// Gets a decimal column.
/// </summary>
/// <param name="reader"></param>
/// <param name="ordinal"></param>
/// <returns></returns>
public static decimal?GetNDecimal(this System.Data.Common.DbDataReader reader, int ordinal)
{
return(reader.IsDBNull(ordinal) ? (decimal?)null : reader.GetDecimal(ordinal));
}
/// <summary>
/// Gets a datetime column. Slower then GetOrdinal + GetDateTime
/// </summary>
/// <param name="reader"></param>
/// <param name="name"></param>
/// <returns></returns>
public static DateTime?GetNDateTime(this System.Data.Common.DbDataReader reader, string name)
{
int ordinal = reader.GetOrdinal(name);
return(reader.IsDBNull(ordinal) ? (DateTime?)null : reader.GetDateTime(ordinal));
}
/// <summary>
/// Gets a float column.
/// </summary>
/// <param name="reader">The db reader</param>
/// <param name="ordinal">The column number</param>
/// <returns></returns>
public static float?GetNFloat(this System.Data.Common.DbDataReader reader, int ordinal)
{
return(reader.IsDBNull(ordinal) ? (float?)null : reader.GetFloat(ordinal));
}
/// <summary>
/// Gets a float column. Slower then GetOrdinal + GetFloat
/// </summary>
/// <param name="reader"></param>
/// <param name="name"></param>
/// <returns></returns>
public static float?GetNFloat(this System.Data.Common.DbDataReader reader, string name)
{
int ordinal = reader.GetOrdinal(name);
return(reader.IsDBNull(ordinal) ? (float?)null : reader.GetFloat(ordinal));
}
/// <summary>
/// Gets a bool column.
/// </summary>
/// <param name="reader"></param>
/// <param name="ordinal">The column number</param>
/// <returns></returns>
public static bool?GetNBoolean(this System.Data.Common.DbDataReader reader, int ordinal)
{
return(reader.IsDBNull(ordinal) ? (bool?)null : reader.GetBoolean(ordinal));
}
/// <summary>
/// Gets a datetime column.
/// </summary>
/// <param name="reader"></param>
/// <param name="ordinal"></param>
/// <returns></returns>
public static DateTime?GetNDateTime(this System.Data.Common.DbDataReader reader, int ordinal)
{
return(reader.IsDBNull(ordinal) ? (DateTime?)null : reader.GetDateTime(ordinal));
}
/// <summary>
/// Gets a string column. Slower then GetOrdinal + GetString
/// </summary>
/// <param name="reader"></param>
/// <param name="name"></param>
/// <returns></returns>
public static string?GetNString(this System.Data.Common.DbDataReader reader, string name)
{
int ordinal = reader.GetOrdinal(name);
return(reader.IsDBNull(ordinal) ? null : reader.GetString(ordinal));
}
/// <summary>
/// Generate CSV formatted output for the given reader.
/// </summary>
public string Generate(System.Data.Common.DbDataReader reader)
{
var builder = new StringBuilder();
var schema = reader.GetSchemaTable();
var colcount = reader.FieldCount;
var nullable = new bool[colcount];
var datatype = new Type[colcount];
var typename = new string[colcount];
for (int c = 0; c < colcount; c++)
{
nullable[c] = true;
datatype[c] = reader.GetFieldType(c);
typename[c] = reader.GetDataTypeName(c);
if (c == 0)
{
if (this.Settings.AddLineNumbers)
{
if (this.Settings.QuotedStrings)
{
builder.Append(this.Settings.StringQuote);
}
builder.Append("Line");
if (this.Settings.QuotedStrings)
{
builder.Append(this.Settings.StringQuote);
}
builder.Append(this.Settings.FieldSeparator);
}
}
else
{
builder.Append(this.Settings.FieldSeparator);
}
if (this.Settings.QuotedStrings)
{
builder.Append(this.Settings.StringQuote);
}
builder.Append(reader.GetName(c));
if (this.Settings.QuotedStrings)
{
builder.Append(this.Settings.StringQuote);
}
}
builder.Append(this.Settings.LineSeparator);
var lineNumber = 0;
while (reader.Read())
{
lineNumber++;
for (int c = 0; c < colcount; c++)
{
if (c == 0)
{
if (this.Settings.AddLineNumbers)
{
builder.Append(lineNumber);
builder.Append(this.Settings.FieldSeparator);
}
}
else
{
builder.Append(this.Settings.FieldSeparator);
}
if (nullable[c] && reader.IsDBNull(c))
{
}
else
{
if (datatype[c] == typeof(String))
{
if (this.Settings.QuotedStrings)
{
builder.Append(this.Settings.StringQuote);
}
builder.Append(ToCsvableString(reader.GetString(c)));
if (this.Settings.QuotedStrings)
{
builder.Append(this.Settings.StringQuote);
}
}
else if (datatype[c] == typeof(DateTime))
{
builder.Append(reader.GetDateTime(c).ToString(this.Settings.DateTimeFormat, this.Settings.FormatProvider));
}
else if (datatype[c] == typeof(Boolean))
{
builder.Append(reader.GetBoolean(c) ? this.Settings.BooleanTrue : this.Settings.BooleanFalse);
}
else
{
builder.AppendFormat(this.Settings.FormatProvider, "{0}", reader.GetValue(c));
}
}
}
builder.Append(this.Settings.LineSeparator);
}
return(builder.ToString());
}
/// <summary>
/// Gets a decimal column. Slower then GetOrdinal + GetDecimal
/// </summary>
/// <param name="reader"></param>
/// <param name="name"></param>
/// <returns></returns>
public static decimal?GetNDecimal(this System.Data.Common.DbDataReader reader, string name)
{
int ordinal = reader.GetOrdinal(name);
return(reader.IsDBNull(ordinal) ? (decimal?)null : reader.GetDecimal(ordinal));
}
private String GetString(System.Data.Common.DbDataReader RS, String FiledName)
{
return(RS.IsDBNull(RS.GetOrdinal(FiledName)) ? "" : RS[FiledName].ToString());
}
/// <summary>
/// Gets a string column.
/// </summary>
/// <param name="reader"></param>
/// <param name="ordinal"></param>
/// <returns></returns>
public static string?GetNString(this System.Data.Common.DbDataReader reader, int ordinal)
{
return(reader.IsDBNull(ordinal) ? null : reader.GetString(ordinal));
}
/// <summary>
/// Gets a bool column. Slower then GetOrdinal + GetBool
/// </summary>
/// <param name="reader"></param>
/// <param name="name"></param>
/// <returns></returns>
public static bool?GetNBoolean(this System.Data.Common.DbDataReader reader, string name)
{
int ordinal = reader.GetOrdinal(name);
return(reader.IsDBNull(ordinal) ? (bool?)null : reader.GetBoolean(ordinal));
}
private int GetInt(System.Data.Common.DbDataReader RS, String FiledName)
{
int FieldID = RS.GetOrdinal(FiledName);
return(RS.IsDBNull(FieldID) ? 0 : RS.GetInt32(FieldID));
}