public ResourceRecord(DbDataReader reader)
{
Page = reader.GetString(reader.GetOrdinal("resourcepage"));
CultureCode = reader.GetString(reader.GetOrdinal("culturecode"));
Key = reader.GetString(reader.GetOrdinal("resourcekey"));
Value = reader.GetString(reader.GetOrdinal("resourcevalue"));
}
protected override void MappingData(System.Data.Common.DbDataReader reader)
{
_id = (Guid)reader["PageId"];
_name = (string)reader["PageName"];
_title = (string)reader["PageTitle"];
if (!reader.IsDBNull(reader.GetOrdinal("PageLanguage")))
{
_language = (int)reader["PageLanguage"];
}
if (!reader.IsDBNull(reader.GetOrdinal("PageTemplate")))
{
_template = (int)reader["PageTemplate"];
}
}
protected Conversation GetCurrentConversation(DbDataReader reader)
{
int colID = reader.GetOrdinal("grupoid_grupo");
int colName = reader.GetOrdinal("nombre");
Conversation conversation = new Conversation();
if (!reader.IsDBNull(colID))
{
conversation.ID = reader.GetInt32(colID);
}
if (!reader.IsDBNull(colName))
{
conversation.Name = reader.GetString(colName);
}
return conversation;
}
/// <summary>
///
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
protected static string GetTableType(DbDataReader reader)
{
const string TABLE_TYPE = @"TABLE_TYPE";
var ordinal = reader.GetOrdinal(TABLE_TYPE);
var type = reader.GetString(ordinal);
return type;
}
/// <summary>
///
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
protected static string GetTableName(DbDataReader reader)
{
const string TABLE_NAME = @"TABLE_NAME";
var ordinal = reader.GetOrdinal(TABLE_NAME);
var name = reader.GetString(ordinal);
return name;
}
protected override void MappingData(System.Data.Common.DbDataReader reader)
{
if (!reader.IsDBNull(reader.GetOrdinal("VoteQuestionId")))
{
_id = (Guid)reader["VoteQuestionId"];
}
if (!reader.IsDBNull(reader.GetOrdinal("VoteQuestionName")))
{
_name = (string)reader["VoteQuestionName"];
}
if (!reader.IsDBNull(reader.GetOrdinal("SubDomainId")))
{
_SubDomainId = (Guid)reader["SubDomainId"];
}
if (!reader.IsDBNull(reader.GetOrdinal("IsActive")))
{
_isActive = (bool)reader["IsActive"];
}
}
protected override void MappingData(System.Data.Common.DbDataReader reader)
{
if (!reader.IsDBNull(reader.GetOrdinal("Id")))
{
Id = (Guid)reader["Id"];
}
if (!reader.IsDBNull(reader.GetOrdinal("Title")))
{
Title = (string)reader["Title"];
}
if (!reader.IsDBNull(reader.GetOrdinal("Path")))
{
Path = (string)reader["Path"];
}
if (!reader.IsDBNull(reader.GetOrdinal("CreationDate")))
{
CreationDate = (DateTime)reader["CreationDate"];
CreationDateString = string.Format("{0:dd/MM/yyyy}", (DateTime)reader["CreationDate"]);
}
if (!reader.IsDBNull(reader.GetOrdinal("Priority")))
{
Priority = (int)reader["Priority"];
}
if (!reader.IsDBNull(reader.GetOrdinal("FileExtension")))
{
FileExtension = (string)reader["FileExtension"];
}
}
static int GetOrdinal(IntPtr L)
{
try
{
ToLua.CheckArgsCount(L, 2);
System.Data.Common.DbDataReader obj = (System.Data.Common.DbDataReader)ToLua.CheckObject(L, 1, typeof(System.Data.Common.DbDataReader));
string arg0 = ToLua.CheckString(L, 2);
int o = obj.GetOrdinal(arg0);
LuaDLL.lua_pushinteger(L, o);
return(1);
}
catch (Exception e)
{
return(LuaDLL.toluaL_exception(L, e));
}
}
/// <summary>
/// 解析整行数据
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="reader"></param>
/// <returns></returns>
public static T GetRow <T>(this System.Data.Common.DbDataReader reader) where T : new()
{
var fields = typeof(T).GetFields();
T t = new T();
object boxT = t;
foreach (var item in fields)
{
var name = item.Name;
var attrs = item.GetCustomAttributes(typeof(ColNameAttribute), false);
if (attrs.Length > 0)
{
name = (attrs[0] as ColNameAttribute).ColName;
}
try
{
var ordinal = reader.GetOrdinal(name);
var valObj = reader.GetValue(ordinal);
object valTo;
if (valObj is DBNull)
{
if (!item.FieldType.IsValueType)
{
item.SetValue(boxT, null);
}
}
else
{
if (item.FieldType.IsEnum)
{
valTo = Convert.ChangeType(valObj, typeof(int));
}
else
{
valTo = Convert.ChangeType(valObj, item.FieldType);
}
item.SetValue(boxT, valTo);
}
}
catch (IndexOutOfRangeException) { }
}
return((T)boxT);
}
protected ProjectInfo_LH GetProjectInfo(DbDataReader reader)
{
ProjectInfo_LH row = new ProjectInfo_LH();
row.Id = Convert.ToInt32(reader.GetValue(reader.GetOrdinal(ProjectInfo_LH.C_id)));
row.Projname = Convert.ToString(reader.GetValue(reader.GetOrdinal(ProjectInfo_LH.C_projName)));
row.Xmdm = Convert.ToInt32(reader.GetValue(reader.GetOrdinal(ProjectInfo_LH.C_xmdm)));
row.Zjdm = Convert.ToInt32(reader.GetValue(reader.GetOrdinal(ProjectInfo_LH.C_zjdm)));
row.Zmdm = Convert.ToInt32(reader.GetValue(reader.GetOrdinal(ProjectInfo_LH.C_zmdm)));
row.Sc = Convert.ToChar(reader.GetValue(reader.GetOrdinal(ProjectInfo_LH.C_sc)));
return row;
}
protected override object GetValue(System.Data.Common.DbDataReader reader, PropertyInfo property)
{
var oracleReader = (reader as OracleDataReader);
int ord = reader.GetOrdinal(property.Name);
if (reader.IsDBNull(ord))
{
return(null);
}
if (oracleReader.GetFieldType(ord) == typeof(decimal))
{
return(GetDecimal(oracleReader, ord, property));
}
else
{
return(oracleReader[property.Name]);
}
}
public DataTable(DbDataReader reader)
{
this.fields = new List<string>();
this.data = new List<object[]>();
for (int i = 0; i < reader.FieldCount; i++)
{
fields.Add(reader.GetName(i));
}
while (reader.Read())
{
object[] values = new object[reader.FieldCount];
for (int i = 0; i < fields.Count; i++)
{
values[i] = reader.GetValue(reader.GetOrdinal(fields[i]));
}
data.Add(values);
}
}
private void mapValues(DbDataReader reader, object record)
{
foreach (var accessor in this.accessors) {
var index = reader.GetOrdinal(accessor.Name);
if (reader.IsDBNull(index)) {
continue;
}
if (accessor.PropertyType == typeof(string)) {
accessor.Set(record, reader.GetString(index));
} else if (accessor.PropertyType == typeof(int) || accessor.PropertyType == typeof(int?)) {
accessor.Set(record, reader.GetInt32(index));
} else if (accessor.PropertyType == typeof(long) || accessor.PropertyType == typeof(long?)) {
accessor.Set(record, reader.GetInt64(index));
} else if (accessor.PropertyType == typeof(DateTime) || accessor.PropertyType == typeof(DateTime?)) {
accessor.Set(record, reader.GetDateTime(index));
} else if (accessor.PropertyType == typeof(char) || accessor.PropertyType == typeof(char?)) {
accessor.Set(record, reader.GetChar(index));
}
}
}
//public override void Export2TradeTable(DbDataReader reader, IExportCallback callback, IExport2TradeTable tradeService)
//{
// if (reader == null)
// return;
// TradeTable tradeTable = new TradeTable();
// if (!tradeTable.Open())
// return;
// OrderRowService_LH lhService = new OrderRowService_LH(this.TheProject);
// TradeInfo_O32Service o32Service = new TradeInfo_O32Service(this.TheProject);
// if (!lhService.Open() || !o32Service.Open())
// {
// tradeTable.Close();
// lhService.Close();
// o32Service.Close();
// return;
// }
// // 特别说明：
// // 在加载结算明细表中的时候的时候需要从量化系统和O32系统中读取相关的数据进行比较，
// // 在读取其他系统数据的时候会出现两个问题：
// // 1、如果一次性把其他系统中的数据全部加载到内存，如果数据量过大，则会撑爆内存；
// // 2、如果在根据需要实时的从其他系统相关数据表中读取数据，效率太低，导入速度太慢了；
// // 3、所以采用一个折中的办法，设置一个临界值，如果大于该临界值，则采用实时加载的方法，否则一次性读取依赖数据；
// bool bufferAll_lh = false;
// bool bufferAll_o32 = false;
// List<OrderRow_LH> buffer_lh = null;
// List<TradeInfo_O32> buffer_o32 = null;
// List<OrderRow_LH> lhDataList = null;
// List<TradeInfo_O32> o32DataList = null;
// string securityId = string.Empty;
// lhService.SyncImportState2Local();
// if (lhService.TotalCount < this.MaxBufferSize)
// {
// bufferAll_lh = true;
// buffer_lh = lhService.GetTradeItems(EMarketType.ALL);
// }
// o32Service.SyncImportState2Local();
// if (o32Service.TotalCount < this.MaxBufferSize)
// {
// bufferAll_o32 = true;
// buffer_o32 = o32Service.GetTradeItems(EMarketType.ALL);
// }
// while (reader.Read())
// {
// if (this.TheProject.HasStop)
// {
// tradeService.ImportState = EImportStatus.Interrupt;
// break;
// }
// CilRow row = this.GetCilRow(reader);
// if (securityId != row.ZQDM)
// {
// securityId = row.ZQDM;
// if (bufferAll_lh)
// lhDataList = buffer_lh.Where(o => o.zqdm == securityId).ToList();
// else
// lhDataList = lhService.GetTradeItems(row.ZQDM, EMarketType.ALL);
// if (bufferAll_o32)
// o32DataList = buffer_o32.Where(o => o.VC_REPORT_CODE == securityId).ToList();
// else
// o32DataList = o32Service.GetTradeItems(row.ZQDM, EMarketType.ALL);
// }
// //EEntrustType entrustType = this.GetEntrustType(row);
// if (lhDataList.Count <= 0 && o32DataList.Count <= 0)
// {
// tradeTable.Add(this.GetTradeRow(row));
// callback.ValidIndex++;
// }
// callback.CurrentIndex++;
// }
// tradeTable.Close();
// lhService.Close();
// o32Service.Close();
//}
protected CilRow GetCilRow(DbDataReader reader)
{
CilRow row = new CilRow();
row.JJDM = this.GetString(reader.GetValue(reader.GetOrdinal(CilRow.C_JJDM)));
row.ZJLX = this.GetString(reader.GetValue(reader.GetOrdinal(CilRow.C_ZJLX)));
row.ZQZH = this.GetString(reader.GetValue(reader.GetOrdinal(CilRow.C_ZQZH)));
row.JYXW = this.GetString(reader.GetValue(reader.GetOrdinal(CilRow.C_JYXW)));
row.XWHY = this.GetString(reader.GetValue(reader.GetOrdinal(CilRow.C_XWHY)));
row.TKJE = this.GetString(reader.GetValue(reader.GetOrdinal(CilRow.C_TKJE)));
row.BKJE = this.GetString(reader.GetValue(reader.GetOrdinal(CilRow.C_BKJE)));
row.JSRQ = this.GetString(reader.GetValue(reader.GetOrdinal(CilRow.C_JSRQ)));
row.JYRQ = this.GetString(reader.GetValue(reader.GetOrdinal(CilRow.C_JYRQ)));
row.ZQDM = this.GetString(reader.GetValue(reader.GetOrdinal(CilRow.C_ZQDM)));
return row;
}
public TimeSpan? ReadTimeSpan(DbDataReader reader, string name)
{
int ordinal = reader.GetOrdinal(name);
return ReadTimeSpan(reader, ordinal);
}
public int? ReadInt(DbDataReader reader, string name)
{
int ordina = reader.GetOrdinal(name);
return ReadInt(reader, ordina);
}
public DateTime? ReadDateTime(DbDataReader reader, string name)
{
int ordinal = reader.GetOrdinal(name);
return ReadDateTime(reader, ordinal);
}
/// <summary>
///
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
private DeptInfo BuilderEntity(DbDataReader reader)
{
DeptInfo info = new DeptInfo();
info.DeptId = (reader.IsDBNull(reader.GetOrdinal("deptid"))) ? "" : reader["deptid"].ToString();
info.DeptName = (reader.IsDBNull(reader.GetOrdinal("deptname"))) ? "" : reader["deptname"].ToString();
info.ParentId = (reader.IsDBNull(reader.GetOrdinal("parentid"))) ? "" : reader["parentid"].ToString();
info.Remark = (reader.IsDBNull(reader.GetOrdinal("remark"))) ? "" : reader["remark"].ToString();
info.DeptType = (reader.IsDBNull(reader.GetOrdinal("DEPTTYPE"))) ? "" : reader["DEPTTYPE"].ToString();
return info;
}
private LogEntry ReadEntry(DbDataReader dataReader)
{
var entry = new LogEntry();
int idOrd = dataReader.GetOrdinal("ID");
entry.ID = dataReader.GetFieldValue<int>(idOrd);
int applicationOrd = dataReader.GetOrdinal("Application");
entry.Application = dataReader.IsDBNull(applicationOrd) ? null : dataReader.GetFieldValue<string>(applicationOrd);
int machineOrd = dataReader.GetOrdinal("MachineName");
entry.MachineName = dataReader.IsDBNull(machineOrd) ? null : dataReader.GetFieldValue<string>(machineOrd);
int timestampOrd = dataReader.GetOrdinal("TimeStamp");
entry.TimeStamp = dataReader.GetFieldValue<DateTime>(timestampOrd);
int threadOrd = dataReader.GetOrdinal("Thread");
entry.Thread = dataReader.IsDBNull(threadOrd) ? null : dataReader.GetFieldValue<string>(threadOrd);
int levelOrd = dataReader.GetOrdinal("Level");
entry.Level = dataReader.IsDBNull(levelOrd) ? null : dataReader.GetFieldValue<string>(levelOrd);
int loggerOrd = dataReader.GetOrdinal("Logger");
entry.Logger = dataReader.IsDBNull(loggerOrd) ? null : dataReader.GetFieldValue<string>(loggerOrd);
int messageOrd = dataReader.GetOrdinal("Message");
entry.Message = dataReader.IsDBNull(messageOrd) ? null : dataReader.GetFieldValue<string>(messageOrd);
int exceptionOrd = dataReader.GetOrdinal("Exception");
entry.Exception = dataReader.IsDBNull(exceptionOrd) ? null : dataReader.GetFieldValue<string>(exceptionOrd);
int ntUserOrd = dataReader.GetOrdinal("NTUser");
entry.NTUser = dataReader.IsDBNull(ntUserOrd) ? null : dataReader.GetFieldValue<string>(ntUserOrd);
return entry;
}
private int GetColumnOrdinal(UpdateTranslator translator, DbDataReader reader, string columnName)
{
int columnOrdinal;
try
{
columnOrdinal = reader.GetOrdinal(columnName);
}
catch (IndexOutOfRangeException)
{
throw EntityUtil.Update(System.Data.Entity.Strings.Update_MissingResultColumn(columnName), null,
this.GetStateEntries(translator));
}
return columnOrdinal;
}
/// <summary>
///
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
private DictInfo BuilderEntity(DbDataReader reader)
{
DictInfo info = new DictInfo();
info.Code = (reader.IsDBNull(reader.GetOrdinal("code"))) ? "" : reader["code"].ToString();
info.Name = (reader.IsDBNull(reader.GetOrdinal("name"))) ? "" : reader["name"].ToString();
info.Remark = (reader.IsDBNull(reader.GetOrdinal("remark"))) ? "" : reader["remark"].ToString();
info.Sort = (reader.IsDBNull(reader.GetOrdinal("sort"))) ? 0 : decimal.Parse(reader["sort"].ToString());
info.IsEnable = (reader.IsDBNull(reader.GetOrdinal("isenable"))) ? "" : reader["isenable"].ToString();
info.TypeCode = (reader.IsDBNull(reader.GetOrdinal("type"))) ? "" : reader["type"].ToString();
info.TypeName = (reader.IsDBNull(reader.GetOrdinal("typename"))) ? "" : reader["typename"].ToString();
return info;
}
/// <summary>
///
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
private DictTypeInfo BuilderDictType(DbDataReader reader)
{
DictTypeInfo info = new DictTypeInfo();
info.Code = (reader.IsDBNull(reader.GetOrdinal("code"))) ? "" : reader["code"].ToString();
info.Name = (reader.IsDBNull(reader.GetOrdinal("name"))) ? "" : reader["name"].ToString();
return info;
}
protected ChinaETFPchRedmRow GetChinaETFPchRedmListRow(DbDataReader reader)
{
ChinaETFPchRedmRow row = new ChinaETFPchRedmRow();
row.OBJECT_ID = this.GetString(reader.GetValue(reader.GetOrdinal(ChinaETFPchRedmRow.C_OBJECT_ID)));
row.S_INFO_WINDCODE = this.GetString(reader.GetValue(reader.GetOrdinal(ChinaETFPchRedmRow.C_S_INFO_WINDCODE)));
row.TRADE_DT = this.GetString(reader.GetValue(reader.GetOrdinal(ChinaETFPchRedmRow.C_TRADE_DT)));
row.F_INFO_CASHDIF = this.GetDouble(reader.GetValue(reader.GetOrdinal(ChinaETFPchRedmRow.C_F_INFO_CASHDIF)));
row.F_INFO_MINPRASET = this.GetDouble(reader.GetValue(reader.GetOrdinal(ChinaETFPchRedmRow.C_F_INFO_MINPRASET)));
row.F_INFO_ESTICASH = this.GetDouble(reader.GetValue(reader.GetOrdinal(ChinaETFPchRedmRow.C_F_INFO_ESTICASH)));
row.F_INFO_CASHSUBUPLIMIT = this.GetDouble(reader.GetValue(reader.GetOrdinal(ChinaETFPchRedmRow.C_F_INFO_CASHSUBUPLIMIT)));
row.F_INFO_MINPRUNITS = this.GetDouble(reader.GetValue(reader.GetOrdinal(ChinaETFPchRedmRow.C_F_INFO_MINPRUNITS)));
row.F_INFO_PRPERMIT = this.GetString(reader.GetValue(reader.GetOrdinal(ChinaETFPchRedmRow.C_F_INFO_PRPERMIT)));
row.F_INFO_CONNUM = this.GetDouble(reader.GetValue(reader.GetOrdinal(ChinaETFPchRedmRow.C_F_INFO_CONNUM)));
row.OPDATE = this.GetDateTime(reader.GetValue(reader.GetOrdinal(ChinaETFPchRedmRow.C_OPDATE)));
row.OPMODE = this.GetString(reader.GetValue(reader.GetOrdinal(ChinaETFPchRedmRow.C_OPMODE)));
return row;
}
public TradeInfo_O32 GetTradeInfo(DbDataReader reader)
{
TradeInfo_O32 row = new TradeInfo_O32();
//1-10
row.VC_STOCK_NAME = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_STOCK_NAME)));
row.VC_THIRD_REFF = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_THIRD_REFF)));
row.C_BUSIN_CLASS = this.GetChar(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_C_BUSIN_CLASS)));
row.L_ENTRUST_SERIAL_NO = this.GetLong(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_L_ENTRUST_SERIAL_NO)));
row.VC_DEAL_NO = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_DEAL_NO)));
row.L_DATE = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_L_DATE)));
row.L_FUND_ID = this.GetInt(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_L_FUND_ID)));
row.VC_COMBI_NO = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_COMBI_NO)));
row.VC_COMBI_NAME = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_COMBI_NAME)));
row.L_BUSINESS_TIME = this.GetInt(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_L_BUSINESS_TIME)));
// 11-20
row.C_ENTRUST_DIRECTION = this.GetChar(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_C_ENTRUST_DIRECTION)));
row.VC_REPORT_DIRECTION = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_REPORT_DIRECTION)));
row.VC_ENTRUSTDIR_NAME = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_ENTRUSTDIR_NAME)));
row.L_DEAL_AMOUNT = this.GetInt(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_L_DEAL_AMOUNT)));
row.EN_DEAL_PRICE = this.GetDouble(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_EN_DEAL_PRICE)));
row.EN_DEAL_BALANCE = this.GetDouble(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_EN_DEAL_BALANCE)));
row.VC_REPORT_CODE = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_REPORT_CODE)));
row.VC_STOCKHOLDER_ID = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_STOCKHOLDER_ID)));
row.VC_REPORT_SEAT = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_REPORT_SEAT)));
row.VC_OPERATOR_NAME = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_OPERATOR_NAME)));
// 21-30
row.VC_CURRENCY_NAME = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_CURRENCY_NAME)));
row.C_INVEST_TYPE = this.GetChar(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_C_INVEST_TYPE)));
row.VC_FUND_NAME = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_FUND_NAME)));
row.VC_CURRENCY_NO_BB = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_CURRENCY_NO_BB)));
row.EN_DEAL_BALANCE_BB = this.GetDouble(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_EN_DEAL_BALANCE_BB)));
row.EN_DEAL_RATIO = this.GetDouble(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_EN_DEAL_RATIO)));
row.VC_BROKER_NO = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_BROKER_NO)));
row.VC_BROKER_NAME = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_BROKER_NAME)));
row.VC_GROUPTYPE_NAME = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_GROUPTYPE_NAME)));
row.VC_GROUP_NAME = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_GROUP_NAME)));
// 31-41
row.VC_INTERNATIONAL_CODE = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_INTERNATIONAL_CODE)));
row.VC_RIC_CODE = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_RIC_CODE)));
row.VC_SEDOL_CODE = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_SEDOL_CODE)));
row.VC_CUSIP_CODE = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_CUSIP_CODE)));
row.VC_BLOOMBERG_CODE = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_BLOOMBERG_CODE)));
row.L_REPORT_SERIAL_NO = this.GetLong(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_L_REPORT_SERIAL_NO)));
row.C_MARKET_NO = this.GetChar(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_C_MARKET_NO)));
row.EN_FULL_BALANCE = this.GetDouble(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_EN_FULL_BALANCE)));
row.L_DIRECT_OPERATOR = this.GetInt(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_L_DIRECT_OPERATOR)));
row.L_DIRECT_INSTEAD_OPERATOR = this.GetInt(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_L_DIRECT_INSTEAD_OPERATOR)));
row.C_MARGINED_OUT = this.GetChar(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_C_MARGINED_OUT)));
return row;
}
public List <T> Fetch <T>(sql sql)
{
try {
System.Data.Common.DbDataReader reader = dbHelperInstance.GetReader(sql.GetSql());
List <T> list = new List <T>();
Type type = typeof(T);
if (type.IsPrimitive || type == typeof(string) || type == typeof(DateTime) || type.IsEnum)
{
while (reader.Read())
{
if (type.IsEnum)
{
list.Add((T)Enum.ToObject(type, reader.GetValue(0)));
}
else
{
list.Add((T)Convert.ChangeType(reader.GetValue(0), type));
}
}
}
else
{
while (reader.Read())
{
T result = Activator.CreateInstance <T>();
PropertyInfo[] properties = type.GetProperties();
foreach (PropertyInfo property in properties)
{
string columName = attributesHelper.GetColumnName(property);
if (property.PropertyType.IsEnum)
{
property.SetValue(result, Enum.ToObject(property.PropertyType, reader.GetValue(reader.GetOrdinal(columName))), null);
}
else
{
property.SetValue(result, Convert.ChangeType(reader.GetValue(reader.GetOrdinal(columName)), property.PropertyType), null);
}
}
list.Add(result);
}
}
return(list);
} catch {
throw;
} finally {
Close();
}
}
protected Message GetCurrentMessage(DbDataReader reader)
{
int colID = reader.GetOrdinal("id_mensaje");
int colSender = reader.GetOrdinal("id_usuario_emisor");
int colConversation = reader.GetOrdinal("id_grupo");
int colContent = reader.GetOrdinal("mensaje");
int colDate = reader.GetOrdinal("fecha");
int colType = reader.GetOrdinal("tipo");
Message message = new Message();
if (!reader.IsDBNull(colID))
{
message.ID = reader.GetInt32(colID);
}
if (!reader.IsDBNull(colSender))
{
message.Sender = reader.GetInt32(colSender);
}
if (!reader.IsDBNull(colConversation))
{
message.Conversation = reader.GetInt32(colConversation);
}
if (!reader.IsDBNull(colContent))
{
message.Content = reader.GetString(colContent);
}
if (!reader.IsDBNull(colDate))
{
message.Date = reader.GetDateTime(colDate);
}
if (!reader.IsDBNull(colType))
{
message.Type = reader.GetString(colType);
}
return message;
}
private int GetColumnOrdinal(UpdateTranslator translator, DbDataReader reader, string columnName)
{
int columnOrdinal;
try
{
columnOrdinal = reader.GetOrdinal(columnName);
}
catch (IndexOutOfRangeException)
{
throw new UpdateException(
Strings.Update_MissingResultColumn(columnName), null, GetStateEntries(translator).Cast<ObjectStateEntry>().Distinct());
}
return columnOrdinal;
}
protected Event GetCurrentEvent(DbDataReader reader)
{
int colID = reader.GetOrdinal("id_evento");
int colCreator = reader.GetOrdinal("id_usuario");
int colTitle = reader.GetOrdinal("nombre");
int colDescription = reader.GetOrdinal("descripcion");
int colIniDate = reader.GetOrdinal("fecha_ini");
int colFinDate = reader.GetOrdinal("fecha_end");
Event e = new Event();
if (!reader.IsDBNull(colID))
{
e.ID = reader.GetInt32(colID);
}
if (!reader.IsDBNull(colCreator))
{
e.Creator = reader.GetInt32(colCreator);
}
if (!reader.IsDBNull(colTitle))
{
e.Title = reader.GetString(colTitle);
}
if (!reader.IsDBNull(colDescription))
{
e.Description = reader.GetString(colDescription);
}
if (!reader.IsDBNull(colIniDate))
{
e.IniDate = reader.GetDateTime(colIniDate);
}
if (!reader.IsDBNull(colFinDate))
{
e.FinDate = reader.GetDateTime(colFinDate);
}
return e;
}
/// <summary>
/// Given a store datareader and a column name, try to find the column ordinal
/// in the datareader with the name of the column.
/// </summary>
/// <param name="storeDataReader"></param>
/// <param name="columnName"></param>
/// <param name="ordinal"></param>
/// <returns>true if found, false otherwise.</returns>
private static bool TryGetColumnOrdinalFromReader(DbDataReader storeDataReader, string columnName, out int ordinal)
{
if (0 == storeDataReader.FieldCount)
{
// If there are no fields, there can't be a match (this check avoids
// an InvalidOperationException on the call to GetOrdinal)
ordinal = default(int);
return false;
}
// Wrap ordinal lookup for the member so that we can throw a nice exception.
try
{
ordinal = storeDataReader.GetOrdinal(columnName);
return true;
}
catch (IndexOutOfRangeException)
{
// No column matching the column name found
ordinal = default(int);
return false;
}
}
public static T GetValueOrDefault <T>(this DbDataReader reader, string name)
{
var idx = reader.GetOrdinal(name);
return(reader.IsDBNull(idx) ? default : reader.GetFieldValue <T>(idx));
}
internal static List<OfferDetails> GetOfferDetailObject(DbDataReader reader)
{
OfferDetails hooOffer = null;
List<OfferDetails> allOffers = new List<OfferDetails>();
while (reader.Read())
{
hooOffer = new OfferDetails();
hooOffer.OfferId = reader.IsDBNull(reader.GetOrdinal("OfferId")) ? 0 : Convert.ToInt32(reader["OfferId"], CultureInfo.InvariantCulture);
hooOffer.OfferTitle = reader.IsDBNull(reader.GetOrdinal("OfferTitle")) ? string.Empty : Convert.ToString(reader["OfferTitle"], CultureInfo.InvariantCulture);
hooOffer.OfferDescription = reader.IsDBNull(reader.GetOrdinal("OfferDescription")) ? string.Empty : Convert.ToString(reader["OfferDescription"], CultureInfo.InvariantCulture);
hooOffer.ImageUrl = reader.IsDBNull(reader.GetOrdinal("OfferImageUrl")) ? string.Empty : Convert.ToString(reader["OfferImageUrl"], CultureInfo.InvariantCulture);
hooOffer.StartDate = reader.IsDBNull(reader.GetOrdinal("StartDate")) ? DateTime.Now : Convert.ToDateTime(reader["StartDate"], CultureInfo.InvariantCulture);
hooOffer.ExpireDate = reader.IsDBNull(reader.GetOrdinal("ExpireDate")) ? DateTime.Now : Convert.ToDateTime(reader["ExpireDate"], CultureInfo.InvariantCulture);
hooOffer.comments = reader.IsDBNull(reader.GetOrdinal("Comments")) ? string.Empty : Convert.ToString(reader["Comments"], CultureInfo.InvariantCulture);
hooOffer.Latitude = reader.IsDBNull(reader.GetOrdinal("Latitude")) ? 0 : Convert.ToDouble(reader["Latitude"], CultureInfo.InvariantCulture);
hooOffer.Longitude = reader.IsDBNull(reader.GetOrdinal("Longitude")) ? 0 : Convert.ToDouble(reader["Longitude"], CultureInfo.InvariantCulture);
hooOffer.City = reader.IsDBNull(reader.GetOrdinal("City")) ? string.Empty : Convert.ToString(reader["City"], CultureInfo.InvariantCulture);
hooOffer.OfferCategory = reader.IsDBNull(reader.GetOrdinal("OfferCategory")) ? string.Empty : Convert.ToString(reader["OfferCategory"], CultureInfo.InvariantCulture);
hooOffer.PromoCode = reader.IsDBNull(reader.GetOrdinal("PromoCode")) ? string.Empty : Convert.ToString(reader["PromoCode"], CultureInfo.InvariantCulture);
hooOffer.Ratings = reader.IsDBNull(reader.GetOrdinal("SumOfRating")) ? 0 : Convert.ToInt32(reader["SumOfRating"], CultureInfo.InvariantCulture);
hooOffer.Vendor = new Supplier();
hooOffer.Vendor.SupplierId = reader.IsDBNull(reader.GetOrdinal("SupplierId")) ? 0 : Convert.ToInt32(reader["SupplierId"], CultureInfo.InvariantCulture);
hooOffer.Vendor.SupplierName = reader.IsDBNull(reader.GetOrdinal("SupName")) ? string.Empty : Convert.ToString(reader["SupName"], CultureInfo.InvariantCulture);
hooOffer.Vendor.ContactNumber = reader.IsDBNull(reader.GetOrdinal("SupContactNumber")) ? string.Empty : Convert.ToString(reader["SupContactNumber"], CultureInfo.InvariantCulture);
hooOffer.Vendor.Email = reader.IsDBNull(reader.GetOrdinal("SupEmailId")) ? string.Empty : Convert.ToString(reader["SupEmailId"], CultureInfo.InvariantCulture);
hooOffer.Vendor.ImageUrl = ConfigurationManager.AppSettings["ImageFolder"].ToString();
hooOffer.Vendor.ImageUrl += reader.IsDBNull(reader.GetOrdinal("SupImageURL")) ? string.Empty : Convert.ToString(reader["SupImageURL"], CultureInfo.InvariantCulture);
hooOffer.Vendor.SupplierAddress = reader.IsDBNull(reader.GetOrdinal("SupAddress")) ? string.Empty : Convert.ToString(reader["SupAddress"], CultureInfo.InvariantCulture);
allOffers.Add(hooOffer);
}
reader.Close();
return allOffers;
}
private string ValueFromReader(DbDataReader reader, String field)
{
string val = null;
int col = reader.GetOrdinal(field);
if (col >=0)
{
if (!reader.IsDBNull(col)) val = reader.GetString(col);
}
return val;
}
public double? ReadDouble(DbDataReader reader, string name)
{
int ordina = reader.GetOrdinal(name);
return ReadDouble(reader, ordina);
}
protected BondFuturesEODPriceRow GetBondFuturesEODPriceRow(DbDataReader reader)
{
BondFuturesEODPriceRow row = new BondFuturesEODPriceRow();
row.OBJECT_ID = this.GetString(reader.GetValue(reader.GetOrdinal(BondFuturesEODPriceRow.C_OBJECT_ID)));
row.S_INFO_WINDCODE = this.GetString(reader.GetValue(reader.GetOrdinal(BondFuturesEODPriceRow.C_S_INFO_WINDCODE)));
row.TRADE_DT = this.GetString(reader.GetValue(reader.GetOrdinal(BondFuturesEODPriceRow.C_TRADE_DT)));
row.S_DQ_PRESETTLE = this.GetDouble(reader.GetValue(reader.GetOrdinal(BondFuturesEODPriceRow.C_S_DQ_PRESETTLE)));
row.S_DQ_OPEN = this.GetDouble(reader.GetValue(reader.GetOrdinal(BondFuturesEODPriceRow.C_S_DQ_OPEN)));
row.S_DQ_HIGH = this.GetDouble(reader.GetValue(reader.GetOrdinal(BondFuturesEODPriceRow.C_S_DQ_HIGH)));
row.S_DQ_LOW = this.GetDouble(reader.GetValue(reader.GetOrdinal(BondFuturesEODPriceRow.C_S_DQ_LOW)));
row.S_DQ_CLOSE = this.GetDouble(reader.GetValue(reader.GetOrdinal(BondFuturesEODPriceRow.C_S_DQ_CLOSE)));
row.S_DQ_SETTLE = this.GetDouble(reader.GetValue(reader.GetOrdinal(BondFuturesEODPriceRow.C_S_DQ_SETTLE)));
row.S_DQ_VOLUME = this.GetDouble(reader.GetValue(reader.GetOrdinal(BondFuturesEODPriceRow.C_S_DQ_VOLUME)));
row.S_DQ_AMOUNT = this.GetDouble(reader.GetValue(reader.GetOrdinal(BondFuturesEODPriceRow.C_S_DQ_AMOUNT)));
row.S_DQ_OI = this.GetDouble(reader.GetValue(reader.GetOrdinal(BondFuturesEODPriceRow.C_S_DQ_OI)));
row.S_DQ_CHANGE = this.GetDouble(reader.GetValue(reader.GetOrdinal(BondFuturesEODPriceRow.C_S_DQ_CHANGE)));
row.OPDATE = this.GetDateTime(reader.GetValue(reader.GetOrdinal(BondFuturesEODPriceRow.C_OPDATE)));
row.OPMODE = this.GetString(reader.GetValue(reader.GetOrdinal(BondFuturesEODPriceRow.C_OPMODE)));
return row;
}
public string ReadString(DbDataReader reader, string name)
{
int ordina = reader.GetOrdinal(name);
return ReadString(reader, ordina);
}
protected User GetCurrentUser(DbDataReader reader)
{
int colID = reader.GetOrdinal("id_usuario");
int colUsername = reader.GetOrdinal("username");
int colEmail = reader.GetOrdinal("email");
int colName = reader.GetOrdinal("nombre");
int colLastName1 = reader.GetOrdinal("primer_apellido");
int colLastName2 = reader.GetOrdinal("segundo_apellido");
User user = new User();
if (!reader.IsDBNull(colID))
{
user.ID = reader.GetInt32(colID);
}
if (!reader.IsDBNull(colUsername))
{
user.Username = reader.GetString(colUsername);
}
if (!reader.IsDBNull(colEmail))
{
user.Email = reader.GetString(colEmail);
}
if (!reader.IsDBNull(colName))
{
user.Name = reader.GetString(colName);
}
if (!reader.IsDBNull(colLastName1))
{
user.LastName1 = reader.GetString(colLastName1);
}
if (!reader.IsDBNull(colLastName2))
{
user.LastName2 = reader.GetString(colLastName2);
}
return user;
}
/// <summary>
/// 获取指定名字的列
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="reader"></param>
/// <param name="key"></param>
/// <returns></returns>
public static T Get <T>(this System.Data.Common.DbDataReader reader, string key)
{
var ordinal = reader.GetOrdinal(key);
return(reader.GetFieldValue <T>(ordinal));
}
/// <summary>
/// 获取指定名字的列
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="reader"></param>
/// <param name="key"></param>
/// <returns></returns>
public static async Task <T> GetAsync <T>(this System.Data.Common.DbDataReader reader, string key)
{
var ordinal = reader.GetOrdinal(key);
return(await reader.GetFieldValueAsync <T>(ordinal));
}
protected JsmxRow_SZ GetJsmxRow_SZ(DbDataReader reader)
{
JsmxRow_SZ row = new JsmxRow_SZ();
row.MXJSZH = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXJSZH)));
row.MXBFZH = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXBFZH)));
row.MXSJLX = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXSJLX)));
row.MXYWLB = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXYWLB)));
row.MXZQDM = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXZQDM)));
row.MXJYDY = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXJYDY)));
row.MXTGDY = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXTGDY)));
row.MXZQZH = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXZQZH)));
row.MXDDBH = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXDDBH)));
row.MXYYB = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXYYB)));
row.MXZXBH = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXZXBH)));
row.MXYWLSH = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXYWLSH)));
row.MXCJSL = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXCJSL)));
row.MXQSSL = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXQSSL)));
row.MXCJJG = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXCJJG)));
row.MXQSJG = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXQSJG)));
row.MXXYJY = this.GetChar(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXXYJY)));
row.MXPCBS = this.GetChar(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXPCBS)));
row.MXZQLB = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXZQLB)));
row.MXZQZL = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXZQZL)));
row.MXGFXZ = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXGFXZ)));
row.MXJSFS = this.GetChar(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXJSFS)));
row.MXHBDH = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXHBDH)));
row.MXQSBJ = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXQSBJ)));
row.MXYHS = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXYHS)));
row.MXJYJSF = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXJYJSF)));
row.MXJGGF = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXJGGF)));
row.MXGHF = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXGHF)));
row.MXJSF = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXJSF)));
row.MXSXF = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXSXF)));
row.MXQSYJ = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXQSYJ)));
row.MXQTFY = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXQTFY)));
row.MXZJJE = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXZJJE)));
row.MXSFJE = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXSFJE)));
row.MXCJRQ = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXCJRQ)));
row.MXQSRQ = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXQSRQ)));
row.MXJSRQ = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXJSRQ)));
row.MXFSRQ = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXFSRQ)));
row.MXQTRQ = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXQTRQ)));
row.MXSCDM = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXSCDM)));
row.MXJYFS = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXJYFS)));
row.MXZQDM2 = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXZQDM2)));
row.MXTGDY2 = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXTGDY2)));
row.MXDDBH2 = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXDDBH2)));
row.MXCWDH = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXCWDH)));
row.MXPPHM = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXPPHM)));
row.MXFJSM = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXFJSM)));
row.MXBYBZ = this.GetChar(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXBYBZ)));
return row;
}
public void Build(DbDataReader reader)
{
var tableSchema = reader.GetSchemaTable();
if (tableSchema == null)
{
return;
}
FetchTableColumnsName(tableSchema);
//reader.Read();
BuildHandle((colName, property) =>
{
var propertyType = property.PropertyType;
var exists = CurrentTableSchemaColumnsName.Find(s => String.Equals(s, colName, StringComparison.InvariantCultureIgnoreCase));
if (String.IsNullOrWhiteSpace(exists))
{
return false;
}
var index = reader.GetOrdinal(exists);
try
{
if (reader.IsDBNull(index))
{
return false;
}
var value = ChangeType(reader.GetValue(index), propertyType);
property.SetValue(this, value, null);
}
catch (Exception ex)
{
Error.ErrorCode = ErrorMapping.BUSINESS_FFFF;
Error.SimpleErrorDescription = ex.Message;
return false;
}
return true;
});
}
