internal static Thread getThreadFromReader(System.Data.IDataReader rdr, Dictionary <string, bool> columnTable)
{
Thread thread = new Thread();
if (columnTable["THREAD_ID"])
{
thread.Id = Convert.ToInt32(rdr.GetDecimal(rdr.GetOrdinal("THREAD_ID")));
}
if (columnTable["SUBJECT"])
{
thread.Subject = rdr.GetString(rdr.GetOrdinal("SUBJECT"));
}
if (columnTable["TRIAGE_GROUP_ID"])
{
if (!rdr.IsDBNull(rdr.GetOrdinal("TRIAGE_GROUP_ID")))
{
thread.MailGroup = new TriageGroup()
{
Id = Convert.ToInt32(rdr.GetDecimal(rdr.GetOrdinal("TRIAGE_GROUP_ID")))
};
}
}
if (columnTable["MTOPLOCK"])
{
thread.Oplock = Convert.ToInt32(rdr.GetDecimal(rdr.GetOrdinal("MTOPLOCK")));
}
if (columnTable["CATEGORY_TYPE"])
{
thread.MessageCategoryType = (enums.MessageCategoryTypeEnum)Convert.ToInt32(rdr.GetDecimal(rdr.GetOrdinal("CATEGORY_TYPE")));
}
return(thread);
}
public AdmissionType LoadFromReader(System.Data.IDataReader rdr)
{
return(new AdmissionType()
{
Id = rdr.GetInt32(rdr.GetOrdinal("AdmissionTypeID")),
Name = rdr.GetString(rdr.GetOrdinal("Name"))
});
}
public DispositionCode LoadFromReader(System.Data.IDataReader rdr)
{
return(new DispositionCode()
{
Id = rdr.GetInt32(rdr.GetOrdinal("DispositionCodeID")),
Name = rdr.GetString(rdr.GetOrdinal("Name"))
});
}
public Payer LoadFromReader(System.Data.IDataReader rdr)
{
return(new Payer()
{
Id = rdr.GetInt32(rdr.GetOrdinal("PayerID")),
Name = rdr.GetString(rdr.GetOrdinal("Name"))
});
}
public PointOfOrigin LoadFromReader(System.Data.IDataReader rdr)
{
return(new PointOfOrigin()
{
Id = rdr.GetInt32(rdr.GetOrdinal("PointOfOriginID")),
Name = rdr.GetString(rdr.GetOrdinal("Name"))
});
}
public LectureCategoryItem MapRow(System.Data.IDataReader reader, int rowNum)
{
LectureCategoryItem lectureCategory = new LectureCategoryItem();
lectureCategory.Id = reader.GetInt32(reader.GetOrdinal("id"));
lectureCategory.Name = reader.GetString(reader.GetOrdinal("name"));
return(lectureCategory);
}
//public override BaseEntity FromReader(System.Data.Common.DbDataReader reader)
//{
// TestEntity entity = new TestEntity();
// entity.Id = reader.GetFieldValue<int>(reader.GetOrdinal("Id"));
// entity.Description = reader.GetFieldValue<string>(reader.GetOrdinal("Description"));
// return entity;
//}
public override TEntity ToEntity <TEntity>(System.Data.IDataReader reader)
{
TestEntity entity = new TestEntity();
entity.Id = reader.GetInt32(reader.GetOrdinal("Id"));
entity.Description = reader.GetString(reader.GetOrdinal("Description"));
return(entity as TEntity);
}
public Race LoadFromReader(System.Data.IDataReader rdr)
{
return(new Race()
{
Id = rdr.GetInt32(rdr.GetOrdinal("RaceID")),
Name = rdr.GetString(rdr.GetOrdinal("Name"))
});
}
public Sex LoadFromReader(System.Data.IDataReader rdr)
{
return(new Sex()
{
Id = rdr.GetInt32(rdr.GetOrdinal("SexID")),
Name = rdr.GetString(rdr.GetOrdinal("Name"))
});
}
public ScoreRequirementItem MapRow(System.Data.IDataReader reader, int rowNum)
{
ScoreRequirementItem scoreRequirement = new ScoreRequirementItem();
scoreRequirement.AccountId = reader.GetInt32(reader.GetOrdinal("accountId"));
scoreRequirement.Cutline = reader.GetInt32(reader.GetOrdinal("cutline"));
scoreRequirement.Id = reader.GetInt32(reader.GetOrdinal("id"));
return(scoreRequirement);
}
public SectionItem MapRow(System.Data.IDataReader reader, int rowNum)
{
SectionItem section = new SectionItem();
section.Id = reader.GetInt32(reader.GetOrdinal("id"));
section.LectureTypeId = reader.GetInt32(reader.GetOrdinal("lectureTypeId"));
section.Name = reader.GetString(reader.GetOrdinal("name"));
return(section);
}
/// <summary>
/// Returns the DataPoints based specified datapoint name substring.
/// </summary>
/// <param name="opcServerName">Datapoint server name</param>
/// <param name="DataPointNameSubstr"> Datapoint name substring to be queried</param>
/// <returns>Datapoints</returns>
public List <EtyDataLogDPTrend> GetDataPointByName(string opcServerName, string DataPointNameSubstr)
{
const string Function_Name = "GetDataPointByName";
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered");
List <EtyDataLogDPTrend> etyDPTrendList = new List <EtyDataLogDPTrend>();
string localSQL = "SELECT et.PKEY AS ENTITY_KEY,CONCAT(et.NAME,'.Value')as DP_NAME ,DP.DP_GRP_ID AS DP_GRP_ID FROM ENTITY et LEFT JOIN DATALOG_DP_TREND DP" +
" ON et.PKEY = DP.ENTITY_KEY WHERE TYPEKEY = (SELECT PKEY FROM ENTITYTYPE WHERE NAME = 'DataPoint')" +
" AND UPPER(et.NAME) LIKE '%" + DAOHelper.convertEscapeStringAndGB2312To8859P1(DataPointNameSubstr) + "%'";
string LocationClauseStr = DAOHelper.CheckLocationAndAddSQL(COLUMN_ENTITY_LOCATIONKEY);
if (LocationClauseStr.Length != 0)
{
localSQL += " AND" + LocationClauseStr;
}
localSQL += " ORDER BY DP_NAME ";
System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL);
if (drReader != null)
{
try
{
while (drReader.Read())
{
EtyDataLogDPTrend etyDPTrend = new EtyDataLogDPTrend();
if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_ENTITY_KEY)))
{
etyDPTrend.EntityKey = Convert.ToDouble(drReader[COLUMN_ENTITY_KEY]);
}
if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_NAME)))
{
etyDPTrend.OPCDataPointName = DAOHelper.convert8859P1ToGB2312(drReader[COLUMN_NAME].ToString());
}
if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_SAMPLE_GRP_ID)))
{
etyDPTrend.OPCSampleGrpId = Convert.ToDouble(drReader[COLUMN_SAMPLE_GRP_ID]);
}
etyDPTrendList.Add(etyDPTrend);
}
}
catch (System.Exception ex)
{
LogHelper.Error(CLASS_NAME, Function_Name, ex.ToString());
}
drReader.Close();
drReader.Dispose();
//SimpleDatabase.GetInstance().CloseCurrentSession();
}
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited");
return(etyDPTrendList);
}
internal static Folder getFolderFromReader(System.Data.IDataReader rdr, Dictionary <string, bool> columnTable)
{
Folder folder = new Folder();
if (columnTable["FOLDER_ID"])
{
int idIndex = rdr.GetOrdinal("FOLDER_ID");
if (!rdr.IsDBNull(idIndex))
{
folder.Id = Convert.ToInt32(rdr.GetDecimal(idIndex));
}
}
if (columnTable["USER_ID"])
{
int userIdIndex = rdr.GetOrdinal("USER_ID");
if (!rdr.IsDBNull(userIdIndex))
{
folder.Owner = new User()
{
Id = Convert.ToInt32(rdr.GetDecimal(userIdIndex))
};
}
}
if (columnTable["FOLDER_NAME"])
{
int nameIndex = rdr.GetOrdinal("FOLDER_NAME");
if (!rdr.IsDBNull(nameIndex))
{
folder.Name = rdr.GetString(nameIndex);
}
}
if (columnTable["FOLDOPLOCK"])
{
int oplockIndex = rdr.GetOrdinal("FOLDOPLOCK");
if (!rdr.IsDBNull(oplockIndex))
{
folder.Oplock = Convert.ToInt32(rdr.GetDecimal(oplockIndex));
}
}
// set up other folder properties
if (folder.Id <= 0)
{
folder.SystemFolder = true;
folder.Name = Enum.GetName(typeof(domain.sm.enums.SystemFolderEnum), folder.Id);
}
else if (folder.Id > 0) // all system folders have ID < 0
{
if (columnTable["FOLDACTIVE"])
{
folder.Active = rdr.GetDecimal(rdr.GetOrdinal("FOLDACTIVE")) == 1;
}
}
return(folder);
}
/// <summary>
/// Returns all the Root Data Nodes.
/// </summary>
/// <returns>Root Data Nodes</returns>
public List <EtyOPCDataNode> GetAllOPCDataNode(string serverRootName, string opcServerName)
{
const string Function_Name = "GetAllOPCDataNode";
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered");
List <EtyOPCDataNode> OPCDataNodeList = new List <EtyOPCDataNode>();
string localSQL = " SELECT KEYID,DT_NODE_NAME,DT_NODE_DESC " +
" FROM OPC_DT_NODE WHERE PKEYID IN (SELECT DISTINCT PKEY FROM ENTITY WHERE NAME = '" + serverRootName + "') AND DISABLE = 'N' AND DATA_PT_SERVER = '" + opcServerName
+ "' ORDER BY DT_NODE_NAME";
//sql for getting from entity table
/*string localSQL = " SELECT PKEY,NAME,DESCRIPTION" +
* " FROM ENTITY WHERE TYPEKEY = (SELECT PKEY FROM ENTITYTYPE WHERE NAME = 'DataNode')"+
* " AND PARENTKEY IN (SELECT DISTINCT PKEY FROM ENTITY WHERE TYPEKEY IN (SELECT PKEY FROM ENTITYTYPE WHERE NAME = 'SCADAROOT'))"+
* " ORDER BY NAME";*/
System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL);
if (drReader != null)
{
try
{
while (drReader.Read())
{
EtyOPCDataNode etyOPCDataNode = new EtyOPCDataNode();
if (!drReader.IsDBNull(drReader.GetOrdinal("KEYID")))
{
etyOPCDataNode.OPCDataNodeId = Convert.ToDouble(drReader["KEYID"]);
}
if (!drReader.IsDBNull(drReader.GetOrdinal("DT_NODE_NAME")))
{
etyOPCDataNode.OPCDataNodeName = DAOHelper.convert8859P1ToGB2312(drReader["DT_NODE_NAME"].ToString());
}
if (!drReader.IsDBNull(drReader.GetOrdinal("DT_NODE_DESC")))
{
etyOPCDataNode.OPCDataNodeDesc = DAOHelper.convert8859P1ToGB2312(drReader["DT_NODE_DESC"].ToString());
}
OPCDataNodeList.Add(etyOPCDataNode);
}
}
catch (System.Exception ex)
{
LogHelper.Error(CLASS_NAME, Function_Name, ex.ToString());
}
drReader.Close();
drReader.Dispose();
}
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited");
return(OPCDataNodeList);
}
public SectionRequirementItem MapRow(System.Data.IDataReader reader, int rowNum)
{
SectionRequirementItem sectionRequirement = new SectionRequirementItem();
sectionRequirement.Id = reader.GetInt32(reader.GetOrdinal("id"));
sectionRequirement.LectureTypeId = reader.GetInt32(reader.GetOrdinal("lectureTypeId"));
sectionRequirement.AccountId = reader.GetInt32(reader.GetOrdinal("accountId"));
sectionRequirement.Cutline = reader.GetInt32(reader.GetOrdinal("Cutline"));
return(sectionRequirement);
}
public AccountItem MapRow(System.Data.IDataReader reader, int rowNum)
{
AccountItem account = new AccountItem();
account.Id = reader.GetInt32(reader.GetOrdinal("id"));
account.Email = reader.GetString(reader.GetOrdinal("email"));
account.Password = reader.GetString(reader.GetOrdinal("password"));
account.State = reader.GetString(reader.GetOrdinal("state"));
return(account);
}
/// <summary>
/// Returns the DataPoints based on the filterstring for specified server name.
/// e.g. for filterstring can include substring datapoint name to search.
/// </summary>
/// <param name="opcServerName">datapoint server name</param>
/// <param name="filterString">Where clause query string</param>
/// <returns>Datapoints</returns>
public List <EtyDataLogDPTrend> GetOPCDataPoint(string opcServerName, string filterString)
{
const string Function_Name = "GetOPCDataPoint";
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered");
List <EtyDataLogDPTrend> etyDPTrendList = new List <EtyDataLogDPTrend>();
string localSQL = "SELECT et.PKEY AS ENTITY_KEY,CONCAT(et.NAME,'.Value') as DP_NAME ,DP.DP_GRP_ID as DP_GRP_ID FROM ENTITY et LEFT JOIN DATALOG_DP_TREND DP"
+ " ON et.PKEY = DP.ENTITY_KEY WHERE et.TYPEKEY = (SELECT PKEY FROM ENTITYTYPE WHERE NAME = 'DataPoint')";
if (filterString.Trim() != "")
{
localSQL += filterString;
}
localSQL += " ORDER BY DP_NAME ";
System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL);
if (drReader != null)
{
try
{
while (drReader.Read())
{
EtyDataLogDPTrend etyDPTrend = new EtyDataLogDPTrend();
if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_ENTITY_KEY)))
{
etyDPTrend.EntityKey = Convert.ToDouble(drReader[COLUMN_ENTITY_KEY]);
}
if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_NAME)))
{
etyDPTrend.OPCDataPointName = DAOHelper.convert8859P1ToGB2312(drReader[COLUMN_NAME].ToString());
}
if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_SAMPLE_GRP_ID)))
{
etyDPTrend.OPCSampleGrpId = Convert.ToDouble(drReader[COLUMN_SAMPLE_GRP_ID]);
}
etyDPTrendList.Add(etyDPTrend);
}
}
catch (System.Exception ex)
{
LogHelper.Error(CLASS_NAME, Function_Name, ex.ToString());
}
drReader.Close();
drReader.Dispose();
//SimpleDatabase.GetInstance().CloseCurrentSession();
}
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited");
return(etyDPTrendList);
}
/// <summary>
///
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
public static DocsPaSecurityItem NewItem(System.Data.IDataReader reader)
{
DocsPaSecurityItem item = new DocsPaSecurityItem();
item.IdPeople = reader.GetValue(reader.GetOrdinal("id_people")).ToString();
item.IdGroup = reader.GetValue(reader.GetOrdinal("id_group")).ToString();
item.CodiceRubrica = reader.GetValue(reader.GetOrdinal("codice_rubrica")).ToString();
item.AccessRights = reader.GetValue(reader.GetOrdinal("accessrights")).ToString();
item.TipoDiritto = reader.GetValue(reader.GetOrdinal("tipodiritto")).ToString();
return(item);
}
public LectureCategoryRequirementItem MapRow(System.Data.IDataReader reader, int rowNum)
{
LectureCategoryRequirementItem lectureCategoryRequirement = new LectureCategoryRequirementItem();
lectureCategoryRequirement.Id = reader.GetInt32(reader.GetOrdinal("id"));
lectureCategoryRequirement.AccountId = reader.GetInt32(reader.GetOrdinal("accountId"));
lectureCategoryRequirement.LectureCategoryId = reader.GetInt32(reader.GetOrdinal("lectureCategoryId"));
lectureCategoryRequirement.LectureCategoryName = reader.GetString(reader.GetOrdinal("lectureCategoryName"));
lectureCategoryRequirement.Cutline = reader.GetInt32(reader.GetOrdinal("cutline"));
return(lectureCategoryRequirement);
}
/// <summary>
///
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
public static SecurityItemInfo NewItem(System.Data.IDataReader reader)
{
SecurityItemInfo item = new SecurityItemInfo();
item.IdPeople = reader.GetValue(reader.GetOrdinal("id_people")).ToString();
item.IdGroup = reader.GetValue(reader.GetOrdinal("id_group")).ToString();
item.AccessRights = (SecurityAccessRightsEnum)
Enum.Parse(typeof(SecurityAccessRightsEnum), reader.GetValue(reader.GetOrdinal("accessrights")).ToString(), true);
item.TipoDiritto = reader.GetValue(reader.GetOrdinal("tipodiritto")).ToString();
return(item);
}
private static OrgTipoFunzione CreateTipoFunzione(System.Data.IDataReader reader)
{
OrgTipoFunzione retValue = new OrgTipoFunzione();
retValue.IDTipoFunzione = reader.GetValue(reader.GetOrdinal("ID")).ToString();
retValue.Codice = reader.GetValue(reader.GetOrdinal("CODICE")).ToString();
retValue.Descrizione = reader.GetValue(reader.GetOrdinal("DESCRIZIONE")).ToString();
retValue.IDAmministrazione = string.Empty;
return(retValue);
}
internal static Order Assembly(System.Data.IDataReader r)
{
Order order = new Order();
order.Id = Convert.ToInt32(r["id"]);
order.OrderNo = Convert.ToString(r["OrderNO"]);
order.LinkTel = Convert.ToString(r["LinkTel"]);
order.UserName = Convert.ToString(r["UserName"]);
//order.UserID = Convert.ToInt32(r["UserID"]);
order.HotelID = Convert.ToInt32(r["HotelID"]);
order.HotelName = Convert.ToString(r["HotelName"]);
order.RoomID = Convert.ToInt32(r["RoomID"]);
order.RoomName = Convert.ToString(r["RoomName"]);
//order.Request = Convert.ToString(r["demo"]);
order.RatePlanID = Convert.ToInt32(r["RatePlanID"]);
order.RatePlanName = Convert.ToString(r["RatePlanName"]);
order.RoomNum = Convert.ToInt32(r["yRoomNum"]);
order.ComeDate = Convert.ToDateTime(r["yinDate"]).ToString("yyyy-MM-dd");
order.LeaveDate = Convert.ToDateTime(r["youtDate"]).ToString("yyyy-MM-dd");
//order.OrderTime = Convert.ToDateTime(r["Ordertime"]).ToString("yyyy-MM-dd HH:mm:ss");
order.PayType = Convert.ToString(r["PayType"]);
//order.EarilyTime = r.IsDBNull(r.GetOrdinal("earilytime")) == true ? "" : Convert.ToString(r["earilytime"]);
order.LastTime = Convert.ToString(r["lastTime"]);
order.State = Convert.ToInt32(r["state"]);
//order.PriceStr = Convert.ToString(r["yPriceStr"]);
order.SumPrice = Convert.ToInt32(r["ySumPrice"]);
order.Remark = r.IsDBNull(r.GetOrdinal("Remark")) ? string.Empty : Convert.ToString(r["Remark"]);
//order.RoomCount = Convert.ToInt32(r["sRoomNum"]);
//order.InDate = Convert.ToDateTime(r["sinDate"]).ToString("yyyy-MM-dd");
//order.OutDate = Convert.ToDateTime(r["soutDate"]).ToString("yyyy-MM-dd");
//order.SPriceStr = Convert.ToString(r["sPriceStr"]);
order.OrderAmount = Convert.ToInt32(r["sSumPrice"]);
//order.LinkUserName = Convert.ToString(r["LinkUserName"]);
//order.Tel = Convert.ToString(r["Tel"]);
//order.PriceOrderWay = Convert.ToInt32(r["PriceOrderWay"]);
//order.StateName = Convert.ToString(r["StateTypeName"]);
order.WeiXinID = r.IsDBNull(r.GetOrdinal("WeiXinID")) ? string.Empty : Convert.ToString(r["WeiXinID"]);
order.UserWeiXinID = r.IsDBNull(r.GetOrdinal("UserWeiXinID")) ? string.Empty : Convert.ToString(r["UserWeiXinID"]);
//order.TradeNo = r.IsDBNull(r.GetOrdinal("tradeNo")) ? string.Empty : r["tradeNo"].ToString();
//order.TradeAlipayAmount = Convert.ToDecimal(r["aliPayAmount"]);
//order.TradeStatus = r.IsDBNull(r.GetOrdinal("tradeStatus")) ? string.Empty : r["tradeStatus"].ToString();
//order.AlipayTime = r.IsDBNull(r.GetOrdinal("aliPayTime")) ? string.Empty : Convert.ToDateTime(r["aliPayTime"].ToString()).ToString("yyyy-MM-dd HH:mm:ss");
//order.UnionUserNo = r.IsDBNull(r.GetOrdinal("unionUserNo")) ? string.Empty : r["unionUserNo"].ToString();
//order.StateName = PDS.Common.StatusMappingManage.GetShowStatus(order.State);
return(order);
}
public override object NullSafeGet(System.Data.IDataReader rs, string name)
{
int index = rs.GetOrdinal(name);
if (rs.IsDBNull(index))
{
if (log.IsDebugEnabled)
{
log.Debug("returning null as column: " + name);
}
return(NullValue); //this value is determined by the subclass.
}
else
{
object val = null;
try
{
val = Get(rs, index);
}
catch (System.InvalidCastException ice)
{
throw new ADOException(
"Could not cast the value in field " + name + " to the Type " + this.GetType().Name +
". Please check to make sure that the mapping is correct and that your DataProvider supports this Data Type.", ice);
}
if (log.IsDebugEnabled)
{
log.Debug("returning '" + ToString(val) + "' as column: " + name);
}
return(val);
}
}
private static ChiaveConfigurazione CreateChiaveConfigurazione(System.Data.IDataReader reader)
{
ChiaveConfigurazione retValue = new ChiaveConfigurazione();
retValue.IDChiave = reader.GetValue(reader.GetOrdinal("ID")).ToString();
retValue.IDAmministrazione = reader.GetValue(reader.GetOrdinal("ID_AMMINISTRAZIONE")).ToString();
retValue.Codice = reader.GetValue(reader.GetOrdinal("CODICE")).ToString();
retValue.Descrizione = reader.GetValue(reader.GetOrdinal("DESCRIZIONE")).ToString();
retValue.Valore = reader.GetValue(reader.GetOrdinal("VALORE")).ToString();
retValue.Visibile = reader.GetValue(reader.GetOrdinal("CHA_VIS")).ToString();
retValue.Modificabile = reader.GetValue(reader.GetOrdinal("CHA_MOD")).ToString();
retValue.TipoChiave = reader.GetValue(reader.GetOrdinal("TIPO")).ToString();
retValue.IsGlobale = reader.GetValue(reader.GetOrdinal("CHA_GLOBALE")).ToString();
retValue.IsConservazione = reader.GetValue(reader.GetOrdinal("CHA_CONSERVAZIONE")).ToString();
return(retValue);
}
public string GetLocationNameFromKey(double locationKey)
{
string Function_Name = "GetLocationNameFromKey";
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered");
string locationName = "";
string localSQL = "SELECT NAME FROM LOCATION WHERE PKEY = " + locationKey.ToString();
System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL);
try
{
if (drReader != null && drReader.Read())
{
if (!drReader.IsDBNull(drReader.GetOrdinal("NAME")))
{
locationName = DAOHelper.convert8859P1ToGB2312(drReader["NAME"].ToString());
}
}
}
catch (System.Exception ex)
{
LogHelper.Error(CLASS_NAME, Function_Name, ex.ToString());
}
if (drReader != null)
{
drReader.Close();
drReader.Dispose();
//SimpleDatabase.GetInstance().CloseCurrentSession();
}
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited");
return(locationName);
}
} // End Sub RetrieveFile
// http://stackoverflow.com/questions/2885335/clr-sql-assembly-get-the-bytestream
// http://stackoverflow.com/questions/891617/how-to-read-a-image-by-idatareader
// http://stackoverflow.com/questions/4103406/extracting-a-net-assembly-from-sql-server-2005
public static void RetrieveFile(System.Data.IDbCommand cmd, string columnName, string path)
{
using (System.Data.IDataReader reader = ExecuteReader(cmd, System.Data.CommandBehavior.SequentialAccess | System.Data.CommandBehavior.CloseConnection))
{
bool hasRows = reader.Read();
if (hasRows)
{
const int BUFFER_SIZE = 1024 * 1024 * 10; // 10 MB
byte[] buffer = new byte[BUFFER_SIZE];
int col = string.IsNullOrEmpty(columnName) ? 0 : reader.GetOrdinal(columnName);
int bytesRead = 0;
int offset = 0;
// Write the byte stream out to disk
using (System.IO.FileStream bytestream = new System.IO.FileStream(path, System.IO.FileMode.Create, System.IO.FileAccess.Write, System.IO.FileShare.None))
{
while ((bytesRead = (int)reader.GetBytes(col, offset, buffer, 0, BUFFER_SIZE)) > 0)
{
bytestream.Write(buffer, 0, bytesRead);
offset += bytesRead;
} // Whend
bytestream.Close();
} // End Using bytestream
} // End if (!hasRows)
reader.Close();
} // End Using reader
} // End Function RetrieveFile
private List <int> GetExternalConnectionIds()
{
List <int> conIds = new List <int>();
string sql = "SELECT SqlConnectionId FROM durados_ExternaInstance WITH(NOLOCK) INNER JOIN durados_SqlConnection WITH(NOLOCK) on durados_SqlConnection.Id = durados_ExternaInstance.SqlConnectionId";
using (System.Data.IDbConnection cnn = Durados.DataAccess.DataAccessObject.GetNewConnection(SqlProduct.SqlServer, Maps.Instance.ConnectionString))
{
using (DuradosCommand command = new DuradosCommand(GetSystemProduct()))
{
command.Connection = cnn;
command.CommandText = sql;
if (command.Connection.State == System.Data.ConnectionState.Closed)
{
try
{
command.Connection.Open();
}
catch (Exception ex)
{
Maps.Instance.DuradosMap.Logger.Log("AppFactory", null, "GetExternalInstanceConnection", null, 1, "No connection to main database");
throw new Exception("No connection to main database", ex);
}
}
System.Data.IDataReader reader = command.ExecuteReader();
while (reader.Read())
{
conIds.Add(reader.GetInt32(reader.GetOrdinal("SqlConnectionId")));
}
}
}
return(conIds);
}
public bool GetOPCDataPointByName(string dataPoint)
{
string Function_Name = "GetOPCDataPointByName";
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered");
string localSQL = "SELECT PKEY FROM DATALOG_DP_TREND WHERE DP_NAME = '" + dataPoint + "'";
System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL);
bool bFound = false;
try
{
if (drReader != null && drReader.Read())
{
if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_PKEY)))
{
bFound = true;
}
}
}
catch (System.Exception ex)
{
LogHelper.Error(CLASS_NAME, Function_Name, ex.ToString());
}
if (drReader != null)
{
drReader.Close();
drReader.Dispose();
}
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited");
return(bFound);
}
/// <summary>
///
/// </summary>
/// <param name="docNumber"></param>
/// <param name="versionId"></param>
/// <returns></returns>
public static int getVersionNumberById(string docNumber, string versionId)
{
// Reperimento del numero di versione
using (DocsPaDB.DBProvider dbProvider = new DocsPaDB.DBProvider())
{
// Query per reperire le versioni
string commandText = string.Format("SELECT version_id FROM versions WHERE docNumber = {0} order by version_id DESC", docNumber);
using (System.Data.IDataReader reader = dbProvider.ExecuteReader(commandText))
{
bool trovato = false;
int numVersione = 0;
while (reader.Read() || trovato)
{
numVersione++;
if (reader.GetString(reader.GetOrdinal("version_id")).Equals(versionId))
{
trovato = true;
}
return(numVersione);
}
}
return(-1);
}
}
public static long GetInt64(System.Data.IDataReader reader, string rowName, short defaultValue)
{
if (ColumnExists(reader, rowName))
{
return(GetInt64(reader, reader.GetOrdinal(rowName), defaultValue));
}
return(defaultValue);
}
