/// <summary>
/// Loads the entity from a <b>SqlDataReader</b> object.
/// </summary>
/// <param name="dr">The data reader to read from.</param>
/// <returns>Returns the number of columns read.</returns>
/// <remarks>
/// Always reads at the current cursor position, doesn't calls the <b>Read</b> function
/// on the <b>SqlDataReader</b> object. Reads data columns by their ordinal position in
/// the query and not by their names.
/// </remarks>
internal override int LoadFromDataReader(SqlDataReader dr)
{
int o = base.LoadFromDataReader(dr);
++o; // skip guid
this.workflowTypeName = dr.GetString(++o);
this.dateStarted = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o);
this.dateFinished = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o);
this.jobExecutionStatus = (JobExecutionState)dr.GetInt32(++o);
this.suspendTimeout = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o);
this.scheduleType = (ScheduleType)dr.GetInt32(++o);
this.scheduleTime = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o);
this.recurringPeriod = (RecurringPeriod)dr.GetInt32(++o);
this.recurringInterval = dr.GetInt32(++o);
this.recurringMask = dr.GetInt64(++o);
this.workflowInstanceId = dr.IsDBNull(++o) ? Guid.Empty : dr.GetGuid(o);
this.adminRequestTime = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o);
if (!dr.IsDBNull(++o))
{
XmlSerializer ser = new XmlSerializer(typeof(JobAdminRequestData));
StringReader sr = new StringReader(dr.GetString(o));
this.adminRequestData = (JobAdminRequestData)ser.Deserialize(sr);
}
else
{
this.adminRequestData = null;
}
this.adminRequestResult = dr.GetInt32(++o);
this.exceptionMessage = dr.IsDBNull(++o) ? null : dr.GetString(o);
return o;
}
protected override Exception ProcessSqlResult(SqlDataReader reader)
{
Exception nextResultSet = StoreUtilities.GetNextResultSet(base.InstancePersistenceCommand.Name, reader);
if (nextResultSet == null)
{
bool flag = !reader.IsDBNull(1);
TimeSpan? taskIntervalOverride = null;
bool flag2 = false;
if (flag)
{
DateTime dateTime = reader.GetDateTime(1);
DateTime time2 = reader.GetDateTime(2);
if (dateTime <= time2)
{
flag2 = true;
}
else
{
taskIntervalOverride = new TimeSpan?(dateTime.Subtract(time2));
}
}
if (flag2)
{
base.Store.UpdateEventStatus(true, InstancePersistenceEvent<HasRunnableWorkflowEvent>.Value);
return nextResultSet;
}
base.Store.UpdateEventStatus(false, InstancePersistenceEvent<HasRunnableWorkflowEvent>.Value);
base.StoreLock.InstanceDetectionTask.ResetTimer(false, taskIntervalOverride);
}
return nextResultSet;
}
/// <summary>
///
/// </summary>
public void Load(System.Data.SqlClient.SqlConnection connection)
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.Connection = connection;
cmd.CommandText = "SELECT appname, AccountID, deviceid, pushid, phonetype, status, createdatetime, PHONE_OS, PHONE_NAME, PHONE_MODEL, updatedatetime FROM MobileDeviceData WHERE ";
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
if (true == reader.Read())
{
_appname = reader.GetString(0);
_accountID = reader.GetString(1);
_deviceid = reader.GetString(2);
_pushid = reader.GetString(3);
_phonetype = reader.GetString(4);
_status = reader.GetBoolean(5);
_createdatetime = reader.GetDateTime(6);
_pHONE_OS = reader.GetString(7);
_pHONE_NAME = reader.GetString(8);
_pHONE_MODEL = reader.GetString(9);
_updatedatetime = reader.GetDateTime(10);
}
reader.Close();
}
}
/// <summary>
/// 数据转用户实体
/// </summary>
public static UserInfo DataToModel(SqlDataReader rdr)
{
UserInfo user = new UserInfo();
if (!rdr.IsDBNull(0)) user.UserID = rdr.GetInt32(0);
if (!rdr.IsDBNull(1)) user.UserName = rdr.GetString(1);
if (!rdr.IsDBNull(2)) user.UserPassword = rdr.GetString(2);
if (!rdr.IsDBNull(3)) user.UserNickName = rdr.GetString(3);
if (!rdr.IsDBNull(4)) user.UserImage = rdr.GetString(4);
if (!rdr.IsDBNull(5)) user.UserPhone = rdr.GetString(5);
if (!rdr.IsDBNull(6)) user.UserEmail = rdr.GetString(6);
if (!rdr.IsDBNull(7)) user.UserTheme = rdr.GetString(7);
if (!rdr.IsDBNull(8)) user.UserLevel = rdr.GetByte(8);
if (!rdr.IsDBNull(9)) user.UserFrom = rdr.GetString(9);
if (!rdr.IsDBNull(10)) user.ModifyDate = rdr.GetDateTime(10);
if (!rdr.IsDBNull(11)) user.CreateDate = rdr.GetDateTime(11);
if (!rdr.IsDBNull(12)) user.UserCity = rdr.GetString(12);
if (!rdr.IsDBNull(13)) user.UserMoney = rdr.GetDecimal(13);
if (!rdr.IsDBNull(14)) user.UserWorkDay = rdr.GetString(14);
if (!rdr.IsDBNull(15)) user.UserFunction = rdr.GetString(15);
if (!rdr.IsDBNull(16)) user.CategoryRate = rdr.GetInt32(16);
if (!rdr.IsDBNull(17)) user.Synchronize = rdr.GetByte(17);
if (!rdr.IsDBNull(18)) user.MoneyStart = rdr.GetDecimal(18);
if (!rdr.IsDBNull(19)) user.IsUpdate = rdr.GetByte(19);
return user;
}
/// <summary>
///
/// </summary>
public void Load(System.Data.SqlClient.SqlConnection connection)
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.Connection = connection;
cmd.CommandText = "SELECT logID, deviceid, phonetype, webservicenode, webservicemethod, webserviceparams, serverReturnData, sCreateDatetime, sRequestDatetime, webserviceparamsDecode, statuscode, ID, user_type, version FROM WebserviceLog WHERE ";
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
if (true == reader.Read())
{
_logID = reader.GetString(0);
_deviceid = reader.GetString(1);
_phonetype = reader.GetString(2);
_webservicenode = reader.GetString(3);
_webservicemethod = reader.GetString(4);
_webserviceparams = reader.GetString(5);
_serverReturnData = reader.GetString(6);
_sCreateDatetime = reader.GetDateTime(7);
_sRequestDatetime = reader.GetDateTime(8);
_webserviceparamsDecode = reader.GetString(9);
_statuscode = reader.GetInt32(10);
_iD = reader.GetString(11);
_user_type = reader.GetString(12);
_version = reader.GetString(13);
}
reader.Close();
}
}
/// <summary>
///
/// </summary>
public void Load(System.Data.SqlClient.SqlConnection connection)
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.Connection = connection;
cmd.CommandText = "SELECT GroupID, AccountID, Name, Description, Password, Startup, PWLastUpdateTime, PWType, CreateTime, dModifyTime, iFailTimes, dLockTime, cRoleID, AD_CheckFlag, cCallID, cPWD FROM SecurityUserAccount WHERE ";
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
if (true == reader.Read())
{
_groupID = reader.GetString(0);
_accountID = reader.GetString(1);
_name = reader.GetString(2);
_description = reader.GetString(3);
//_password = reader.GetString(4);
_password = (byte[])reader[4];
_startup = reader.GetBoolean(5);
_pWLastUpdateTime = reader.GetDateTime(6);
_pWType = reader.GetInt16(7);
_createTime = reader.GetDateTime(8);
_dModifyTime = reader.GetDateTime(9);
_iFailTimes = reader.GetInt16(10);
_dLockTime = reader.GetDateTime(11);
_cRoleID = reader.GetInt16(12);
_aD_CheckFlag = reader.GetBoolean(13);
_cCallID = reader.GetString(14);
_cPWD = reader.GetString(15);
}
reader.Close();
}
}
/// <summary>
///
/// </summary>
public void Load(System.Data.SqlClient.SqlConnection connection)
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.Connection = connection;
cmd.CommandText = "SELECT HAPPY_ID, CSTATUS, FILE_KIND, APPLY_TARGET, CKEY1, CKEY2, CKEY3, TITLE, URL, F_IDX, F_NAME, CORDER, LDATE, LUSER, SELECTALL, ISTESTER, ONLINE_TIME, OFFLINE_TIME FROM MIP_HAPPY WHERE HAPPY_ID=@HAPPY_ID_PARAM";
cmd.Parameters.AddWithValue("@HAPPY_ID_PARAM", _hAPPY_ID);
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
if (true == reader.Read())
{
_hAPPY_ID = reader.GetInt32(0);
_cSTATUS = reader.GetInt32(1);
_fILE_KIND = reader.GetInt32(2);
_aPPLY_TARGET = reader.GetInt32(3);
_cKEY1 = reader.GetString(4);
_cKEY2 = reader.GetString(5);
_cKEY3 = reader.GetString(6);
_tITLE = reader.GetString(7);
_uRL = reader.GetString(8);
_f_IDX = reader.GetInt32(9);
_f_NAME = reader.GetString(10);
_cORDER = reader.GetInt32(11);
_lDATE = reader.GetDateTime(12);
_lUSER = reader.GetString(13);
_sELECTALL = reader.GetInt32(14);
_iSTESTER = reader.GetInt32(15);
_oNLINE_TIME = reader.GetDateTime(16);
_oFFLINE_TIME = reader.GetDateTime(17);
}
reader.Close();
}
}
/// <summary>
///
/// </summary>
public void Load(System.Data.SqlClient.SqlConnection connection)
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.Connection = connection;
cmd.CommandText = "SELECT MIP_MSG_NO, MSG_TARGET, RESERVATION, ONLINE_TIME, OFFLINE_TIME, DOPUSH, MSG_KIND_1, MSG_KIND_2, MSG_TITLE, MSG_CONTENT, MSG_STATE, LDATE, LUSER, SELECTALL, PROCESSED, ISNEW FROM MIP_MSG_MAIN WHERE ";
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
if (true == reader.Read())
{
_mIP_MSG_NO = reader.GetInt32(0);
_mSG_TARGET = reader.GetString(1);
_rESERVATION = reader.GetString(2);
_oNLINE_TIME = reader.GetDateTime(3);
_oFFLINE_TIME = reader.GetDateTime(4);
_dOPUSH = reader.GetString(5);
_mSG_KIND_1 = reader.GetString(6);
_mSG_KIND_2 = reader.GetString(7);
_mSG_TITLE = reader.GetString(8);
_mSG_CONTENT = reader.GetString(9);
_mSG_STATE = reader.GetString(10);
_lDATE = reader.GetDateTime(11);
_lUSER = reader.GetString(12);
_sELECTALL = reader.GetInt32(13);
_pROCESSED = reader.GetInt32(14);
_iSNEW = reader.GetInt32(15);
}
reader.Close();
}
}
/// <summary>
///
/// </summary>
public void Load(System.Data.SqlClient.SqlConnection connection)
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.Connection = connection;
cmd.CommandText = "SELECT MIP_MSG_ID, MSG_NO, MSG_SOURCE, PCA_MSG_ID, ACCOUNTID, RESERVATION, ONLINE_TIME, OFFLINE_TIME, DOPUSH, MSG_KIND_1, MSG_KIND_2, MSG_TITLE, MSG_CONTENT, READ_STATE, READ_TIME, LDATE, REC_STA, PUSHED FROM MIP_MSG_DETAIL WHERE ";
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
if (true == reader.Read())
{
_mIP_MSG_ID = reader.GetInt32(0);
_mSG_NO = reader.GetInt32(1);
_mSG_SOURCE = reader.GetString(2);
_pCA_MSG_ID = reader.GetString(3);
_aCCOUNTID = reader.GetString(4);
_rESERVATION = reader.GetString(5);
_oNLINE_TIME = reader.GetDateTime(6);
_oFFLINE_TIME = reader.GetDateTime(7);
_dOPUSH = reader.GetString(8);
_mSG_KIND_1 = reader.GetString(9);
_mSG_KIND_2 = reader.GetString(10);
_mSG_TITLE = reader.GetString(11);
_mSG_CONTENT = reader.GetString(12);
_rEAD_STATE = reader.GetString(13);
_rEAD_TIME = reader.GetDateTime(14);
_lDATE = reader.GetDateTime(15);
_rEC_STA = reader.GetString(16);
_pUSHED = reader.GetInt32(17);
}
reader.Close();
}
}
///<summary></summary>
protected override void ReadExecuted(System.Data.SqlClient.SqlDataReader dr)
{
if (dr != null && !dr.IsClosed)
{
#region Read Each Field
if (!dr.IsDBNull(dr.GetOrdinal("Id")))
{
m_Current.Id = dr.GetInt32(dr.GetOrdinal("Id"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Title")))
{
m_Current.Title = dr.GetString(dr.GetOrdinal("Title"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Body")))
{
m_Current.Body = dr.GetString(dr.GetOrdinal("Body"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ShortDesc")))
{
m_Current.ShortDesc = dr.GetString(dr.GetOrdinal("ShortDesc"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Description")))
{
m_Current.Description = dr.GetString(dr.GetOrdinal("Description"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Meta")))
{
m_Current.Meta = dr.GetString(dr.GetOrdinal("Meta"));
}
if (!dr.IsDBNull(dr.GetOrdinal("UrlSlug")))
{
m_Current.UrlSlug = dr.GetString(dr.GetOrdinal("UrlSlug"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Published")))
{
m_Current.Published = dr.GetBoolean(dr.GetOrdinal("Published"));
}
if (!dr.IsDBNull(dr.GetOrdinal("PostedOn")))
{
m_Current.PostedOn = dr.GetDateTime(dr.GetOrdinal("PostedOn"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Modified")))
{
m_Current.Modified = dr.GetDateTime(dr.GetOrdinal("Modified"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Category")))
{
m_Current.Category = dr.GetString(dr.GetOrdinal("Category"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Enabled")))
{
m_Current.Enabled = dr.GetBoolean(dr.GetOrdinal("Enabled"));
}
#endregion
ExistsInDB = true;
Mode = EditMode.None;
SetOriginalValues();
}
}
private UsuarioEntity CrearUsuario(SqlDataReader cursor)
{
UsuarioEntity usuario = new UsuarioEntity();
usuario.Id = cursor.GetInt32(cursor.GetOrdinal("UsuarioID"));
usuario.Nombre = cursor.GetString(cursor.GetOrdinal("UsuarioNombre"));
usuario.Perfil =char.Parse( cursor.GetValue(cursor.GetOrdinal("UsuarioPerfil")).ToString());
usuario.Email = cursor.GetString(cursor.GetOrdinal("UsuarioEmail"));
usuario.Password = cursor.GetString(cursor.GetOrdinal("UsuarioPassword"));
usuario.Provincia = cursor.GetString(cursor.GetOrdinal("UsuarioProvincia"));
usuario.Ciudad = cursor.GetString(cursor.GetOrdinal("UsuarioCiudad"));
if (!cursor.IsDBNull(cursor.GetOrdinal("UsuarioFoto")))
usuario.Foto = cursor.GetString(cursor.GetOrdinal("UsuarioFoto"));
usuario.FechaRegistracion = cursor.GetDateTime(cursor.GetOrdinal("UsuarioFechaRegistracion"));
if (!cursor.IsDBNull(cursor.GetOrdinal("UsuarioFechaActualizacion")))
usuario.FechaActualizacion = cursor.GetDateTime(cursor.GetOrdinal("UsuarioFechaActualizacion"));
switch (usuario.Perfil)
{
case 'M': usuario.musico = new MusicoEntity();
usuario.musico.FechaNacimiento = cursor.GetDateTime(cursor.GetOrdinal("UsuarioFechaNacimiento"));
usuario.musico.Genero = cursor.GetString(cursor.GetOrdinal("UsuarioGenero"));
if (!cursor.IsDBNull(cursor.GetOrdinal("CuentaYoutube")))
usuario.musico.CuentaYoutube = cursor.GetString(cursor.GetOrdinal("CuentaYoutube"));
if (!cursor.IsDBNull(cursor.GetOrdinal("CuentaFacebook")))
usuario.musico.CuentaFacebook = cursor.GetString(cursor.GetOrdinal("CuentaFacebook"));
if (!cursor.IsDBNull(cursor.GetOrdinal("CuentaSoundCloud")))
usuario.musico.CuentaSoundCloud = cursor.GetString(cursor.GetOrdinal("CuentaSoundCloud"));
if (!cursor.IsDBNull(cursor.GetOrdinal("CuentaTwitter")))
usuario.musico.CuentaTwitter = cursor.GetString(cursor.GetOrdinal("CuentaTwitter"));
break;
default: usuario.lugar = new LugarEntity();
usuario.lugar.DirCalle = cursor.GetString(cursor.GetOrdinal("DirCalle"));
usuario.lugar.DirNumero = cursor.GetInt32(cursor.GetOrdinal("DirNro"));
if (!cursor.IsDBNull(cursor.GetOrdinal("HorarioDesde")))
usuario.lugar.HorarioDesde = cursor.GetString(cursor.GetOrdinal("HorarioDesde"));
if (!cursor.IsDBNull(cursor.GetOrdinal("HorarioHasta")))
usuario.lugar.HorarioHasta = cursor.GetString(cursor.GetOrdinal("HorarioHasta"));
break;
}
return usuario;
}
/// <summary>
///
/// </summary>
public void Load(System.Data.SqlClient.SqlConnection connection)
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.Connection = connection;
cmd.CommandText = "SELECT MAIL_ID, APP_TYPE, SOURCE, EMAIL_ADDR, MAINORCC, NOTETXT, LDATA, LUSER FROM MIP_EMAIL WHERE MAIL_ID=@MAIL_ID_PARAM";
cmd.Parameters.AddWithValue("@MAIL_ID_PARAM", _mAIL_ID);
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
if (true == reader.Read())
{
_mAIL_ID = reader.GetInt32(0);
_aPP_TYPE = reader.GetInt32(1);
_sOURCE = reader.GetString(2);
_eMAIL_ADDR = reader.GetString(3);
_mAINORCC = reader.GetInt32(4);
_nOTETXT = reader.GetString(5);
_lDATA = reader.GetDateTime(6);
_lUSER = reader.GetString(7);
}
reader.Close();
}
}
public RoadMap(string name )
{
mName = name;
mDatabase.connect();
mReader = mDatabase.executeread("SELECT Timestamp, Description, UserID FROM [dbo].[Roadmap] WHERE Name = '" + name + "'");
mReader.Read();
mTimeStamp = mReader.GetDateTime(0);
mDescription = mReader.GetString(1);
string UID = mReader.GetString(2);
mDatabase.close();
mDatabase.connect();
mReader = mDatabase.executeread("SELECT Name, Email, Password FROM [dbo].[User] WHERE ID = '" + UID + "'");
mReader.Read();
mUser = new User(mReader.GetString(0), UID, mReader.GetString(1), mReader.GetString(2));
mDatabase.close();
mTimeline = new TimeLine(mName);
//Get the StrategyPoints
mDatabase.connect();
mReader = mDatabase.executeread("SELECT Name, Description FROM [dbo].[StrategyPoint] WHERE RoadmapName = '" + name + "'");
while (mReader.Read())
{
StrategyPoint sp = new StrategyPoint(mReader.GetString(0), mReader.GetString(1));
mStrategyPoints.Add(sp);
}
mDatabase.close();
}
/// <summary>
/// 根据sqldatareader进行获取模型
/// </summary>
/// <param name="sdr"></param>
/// <returns></returns>
public T_Member GetModelBySDR(SqlDataReader sdr)
{
T_Member t_m = null;
if (sdr.Read())
{
t_m = new T_Member();
t_m.F_Id = sdr.GetInt32(0);
t_m.F_Email = sdr.GetString(1);
t_m.F_Password = sdr.GetString(2);
t_m.F_Sex = sdr.GetBoolean(3);
t_m.F_NickName = sdr.GetString(4);
t_m.F_Headpic = sdr.GetString(5);
t_m.F_SecurityPassWord = sdr.GetString(6);
t_m.F_Alipay = sdr.GetString(7);
t_m.F_Issues = sdr.GetString(8);
t_m.F_Answer = sdr.GetString(9);
t_m.F_InitPassWord = sdr.GetString(10);
t_m.F_Mobile = sdr.GetString(11);
t_m.F_QQ = sdr.GetString(12);
t_m.F_Level = sdr.GetInt32(13);
t_m.F_Gold = sdr.GetInt32(14);
t_m.F_Diamond = sdr.GetInt32(15);
t_m.F_VIP = sdr.GetBoolean(16);
t_m.F_KEY = sdr.GetString(17);
t_m.F_Status = sdr.GetInt32(18);
t_m.F_CreateDate = sdr.GetDateTime(19);
}
return t_m;
}
/// <summary>
/// find if specific stock symbol has been analysed in the same day. Find if stock record exist in the database
/// </summary>
/// <param name="symbol"></param>
/// <returns></returns>
public int IsStockAnalysedRecently(string symbol)
{
using (StockConn = new SqlConnection(Conn))
{
string cmdText = "SELECT TOP (1) [timeStamp] FROM [Stock].[dbo].[StockAnalysis] WHERE [symbol] = '" + symbol + "'";
StockConn.Open();
SqlCommand Cmd = new SqlCommand(cmdText, StockConn);
using (System.Data.SqlClient.SqlDataReader oReader = Cmd.ExecuteReader())
{
DateTime tmp = new DateTime(1, 1, 1, 1, 1, 1);
bool isExist = false;
while (oReader.Read())
{
tmp = oReader.GetDateTime(0);
isExist = true;
}
if (!isExist)
{
return(0);
}
var Now = DateTime.Now;
if (tmp.Year == Now.Year && tmp.Month == Now.Month && tmp.Day == Now.Day)
{
return(2);
}
else
{
return(1);
}
}
}
}
public int getComments(int id, out List<string> name, out List<DateTime> date, out List<string> comments)
{
name = new List<string>();
date = new List<DateTime>();
comments = new List<string>();
cmd.CommandText = "SELECT * FROM comment where id=" + id.ToString() + " ORDER BY comdate DESC";
try
{
SqlInit();
dr = cmd.ExecuteReader();
while (dr.Read())
{
name.Add(dr.GetString(1));
date.Add(dr.GetDateTime(2));
comments.Add(dr.GetString(3));
}
}
catch(SqlException e)
{
SqlExit();
return 666;
}
if (name.Count == 0)
{
SqlExit();
return 1;//no comments
}
SqlExit();
return 0;//success
}
public static NewMemberBalancePrediction Factory(SqlDataReader reader)
{
var newMemberId = reader.GetInt32(0);
var dependentId = reader.GetInt32(1);
var birthYear = reader.GetInt32(2);
var state = reader.GetString(3);
var lastCptCode = reader.GetString(4);
var cachedBalance = reader.GetString(5);
var recommendedBalance = reader.GetValue(6);
double d;
double.TryParse(recommendedBalance == null ? "0" : recommendedBalance.ToString(), out d);
var sufficientAmount = reader.GetInt32(7);
var serviceEnd = reader.GetDateTime(8);
return new NewMemberBalancePrediction
{
NewMemberId = newMemberId,
DependentId = dependentId,
BirthYear = birthYear,
State = state,
LastCptCode = lastCptCode,
CachedBalance = cachedBalance,
RecommendedBalance = Math.Round(d, 2),
SufficientAmount = sufficientAmount,
ServiceEnd = serviceEnd
};
}
/// <summary>
///
/// </summary>
public void Load(System.Data.SqlClient.SqlConnection connection)
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.Connection = connection;
cmd.CommandText = "SELECT RecordID, ModuleDesc, FunctionDesc, ActionDesc, FieldDesc, FieldBefore, FieldAfter, Name, AccountID, cDatetime, Top5 FROM SecurityUserAccount_OperateRecord WHERE ";
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
if (true == reader.Read())
{
_recordID = reader.GetString(0);
_moduleDesc = reader.GetString(1);
_functionDesc = reader.GetString(2);
_actionDesc = reader.GetString(3);
_fieldDesc = reader.GetString(4);
_fieldBefore = reader.GetString(5);
_fieldAfter = reader.GetString(6);
_name = reader.GetString(7);
_accountID = reader.GetString(8);
_cDatetime = reader.GetDateTime(9);
_top5 = reader.GetInt32(10);
}
reader.Close();
}
}
public static DateTime ValidateDataReader_T(SqlDataReader reader,string colname)
{
if(reader.GetValue(reader.GetOrdinal(colname))!=DBNull.Value)
return reader.GetDateTime(reader.GetOrdinal(colname));
else
return System.DateTime.MinValue;
}
/**
* Descripción: Obtiene el campo fecha de la tabla de forma segura (revisando si es null o no antes de leerlo)
* Recibe un SqlDataReader con el que se obtiene el campo y el índice de la columna a consultar
* Devuelve un valor DateTime dependiendo del resultado de la consulta. La fecha actual si el campo está nulo
*/
public static DateTime SafeGetDate(SqlDataReader reader, int colIndex)
{
if (!reader.IsDBNull(colIndex))
return reader.GetDateTime(colIndex);
else
return DateTime.Now;
}
public static StatsModel readRecord(SqlDataReader dr)
{
StatsModel currentRecord = new StatsModel();
currentRecord.id = dr["id"].ToString();
//reader.GetDateTime(reader.GetOrdinal("Timestamp"));
currentRecord.logtime = dr.GetDateTime(dr.GetOrdinal("logtime"));
currentRecord.is_interacting = Convert.ToBoolean(dr["is_interacting"]);
currentRecord.pcy = Convert.ToInt32(dr["pcy"]);
currentRecord.cpu = Convert.ToInt32(dr["cpu"]);
currentRecord.vss = Convert.ToInt32(dr["vss"]);
currentRecord.rss = Convert.ToInt32(dr["rss"]);
currentRecord.threads = Convert.ToInt32(dr["threads"]);
currentRecord.priority = Convert.ToInt32(dr["priority"]);
currentRecord.status = dr["status"].ToString();
currentRecord.bg_up_data = Convert.ToInt32(dr["bg_up_data"]) == -1 ? 0 : Convert.ToInt32(dr["bg_up_data"]); ;
currentRecord.bg_down_data = Convert.ToInt32(dr["bg_down_data"]) == -1 ? 0 : Convert.ToInt32(dr["bg_down_data"]); ;
currentRecord.fg_up_data = Convert.ToInt32(dr["fg_up_data"]) == -1 ? 0 : Convert.ToInt32(dr["fg_up_data"]);
currentRecord.fg_down_data = Convert.ToInt32(dr["fg_down_data"]) == -1 ? 0 : Convert.ToInt32(dr["fg_down_data"]); ;
currentRecord.bg_up_wifi = Convert.ToInt32(dr["bg_up_wifi"]) == -1 ? 0 : Convert.ToInt32(dr["bg_up_wifi"]); ;
currentRecord.bg_down_wifi = Convert.ToInt32(dr["bg_down_wifi"]) == -1 ? 0 : Convert.ToInt32(dr["bg_down_wifi"]); ;
currentRecord.fg_up_wifi = Convert.ToInt32(dr["fg_up_wifi"]) == -1 ? 0 : Convert.ToInt32(dr["fg_up_wifi"]); ;
currentRecord.fg_down_wifi = Convert.ToInt32(dr["fg_down_wifi"]) == -1 ? 0 : Convert.ToInt32(dr["fg_down_wifi"]); ;
//Console.WriteLine("Date Read: " + dt);
return currentRecord;
}
public List <Employee> GetEmployeeList()
{
List <Employee> employeeList = new List <Employee>();
Dao dao = new Dao();
string sqlStatement = "SELECT EmployeeID, EmployeeName, Gender, Position, StartDate, Address, PhoneNumber FROM Employee";
System.Data.SqlClient.SqlDataReader reader = dao.Get(sqlStatement);
if (reader == null)
{
return(null);
}
while (reader.Read())
{
int id = reader.GetInt32(0);
string name = reader.GetString(1);
bool gender = reader.GetBoolean(2);
string position = reader.GetString(3);
DateTime date = reader.GetDateTime(4);
string address = reader.GetString(5);
string phone = reader.GetString(6);
employeeList.Add(new Employee(id, name, gender, position, date, address, phone));
}
dao.Con.Close();
return(employeeList);
}
/// <summary>
///
/// </summary>
public void Load(System.Data.SqlClient.SqlConnection connection)
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.Connection = connection;
cmd.CommandText = "SELECT version, sqltype, file_desc, fileUploadOldName, fileUploadNewName, datetime, version_no, imageData FROM userUploadLog WHERE ";
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
if (true == reader.Read())
{
_version = reader.GetInt32(0);
_sqltype = reader.GetInt32(1);
_file_desc = reader.GetString(2);
_fileUploadOldName = reader.GetString(3);
_fileUploadNewName = reader.GetString(4);
_datetime = reader.GetDateTime(5);
_version_no = reader.GetString(6);
//_imageData = reader.GetBytes(7);
_imageData = (byte[])reader[7];
}
reader.Close();
}
}
/// <summary>
///
/// </summary>
public void Load(System.Data.SqlClient.SqlConnection connection)
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.Connection = connection;
cmd.CommandText = "SELECT FILE_INDEX, FILE_NEW_NAME, FILE_ORI_NAME, FILE_MD5, FILE_IMG, RECSTA, LDATE, LUSER FROM MIP_FILE_STORE WHERE FILE_INDEX=@FILE_INDEX_PARAM";
cmd.Parameters.AddWithValue("@FILE_INDEX_PARAM", _fILE_INDEX);
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
if (true == reader.Read())
{
_fILE_INDEX = reader.GetInt32(0);
_fILE_NEW_NAME = reader.GetString(1);
_fILE_ORI_NAME = reader.GetString(2);
_fILE_MD5 = reader.GetString(3);
//_fILE_IMG = reader.GetByte(4);
_fILE_IMG = (byte[])reader[4];
_rECSTA = reader.GetInt32(5);
_lDATE = reader.GetDateTime(6);
_lUSER = reader.GetString(7);
}
reader.Close();
}
}
private static TimeSpan GetTimeTolive(SqlDataReader dataReader)
{
if (dataReader.IsDBNull(TimeToLiveIndex))
{
return TimeSpan.MaxValue;
}
DateTime expireDateTime = dataReader.GetDateTime(TimeToLiveIndex);
if (dataReader.GetDateTime(TimeToLiveIndex) < DateTime.UtcNow)
{
return TimeSpan.Zero;
}
return TimeSpan.FromTicks(expireDateTime.Ticks - DateTime.UtcNow.Ticks);
}
/// <summary>
///
/// </summary>
public void Load(System.Data.SqlClient.SqlConnection connection)
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.Connection = connection;
cmd.CommandText = "SELECT ServiceID, sUrl, sNamespace, sClassname, APName, sDescription, sStatus, sCreateDatetime, ENCRYPTED FROM WebserviceData WHERE ";
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
if (true == reader.Read())
{
_serviceID = reader.GetString(0);
_sUrl = reader.GetString(1);
_sNamespace = reader.GetString(2);
_sClassname = reader.GetString(3);
_aPName = reader.GetString(4);
_sDescription = reader.GetString(5);
_sStatus = reader.GetBoolean(6);
_sCreateDatetime = reader.GetDateTime(7);
_eNCRYPTED = reader.GetBoolean(8);
}
reader.Close();
}
}
public TList_Empreendimento Select(TpBusca[] vBusca, Int32 vTop, string vNM_Campo)
{
bool podeFecharBco = false;
TList_Empreendimento lista = new TList_Empreendimento();
if (Banco_Dados == null)
{
this.CriarBanco_Dados(false);
podeFecharBco = true;
}
System.Data.SqlClient.SqlDataReader reader = this.ExecutarBusca(this.SqlCodeBusca(vBusca, vTop, vNM_Campo));
try
{
while (reader.Read())
{
TRegistro_Empreendimento reg = new TRegistro_Empreendimento();
if (!(reader.IsDBNull(reader.GetOrdinal("ID_Empreendimento"))))
{
reg.Id_empreendimento = reader.GetDecimal(reader.GetOrdinal("ID_Empreendimento"));
}
if (!(reader.IsDBNull(reader.GetOrdinal("CD_Empresa"))))
{
reg.Cd_empresa = reader.GetString(reader.GetOrdinal("CD_Empresa"));
}
if (!(reader.IsDBNull(reader.GetOrdinal("NM_Empresa"))))
{
reg.Nm_empresa = reader.GetString(reader.GetOrdinal("NM_Empresa"));
}
if (!reader.IsDBNull(reader.GetOrdinal("DS_Empreendimento")))
{
reg.Ds_empreendimento = reader.GetString(reader.GetOrdinal("DS_Empreendimento"));
}
if (!reader.IsDBNull(reader.GetOrdinal("DS_Observacao")))
{
reg.Ds_observacao = reader.GetString(reader.GetOrdinal("DS_Observacao"));
}
if (!reader.IsDBNull(reader.GetOrdinal("DT_IniEmpreendimento")))
{
reg.Dt_iniempreendimento = reader.GetDateTime(reader.GetOrdinal("DT_IniEmpreendimento"));
}
if (!(reader.IsDBNull(reader.GetOrdinal("ST_Registro"))))
{
reg.St_registro = reader.GetString(reader.GetOrdinal("ST_Registro"));
}
lista.Add(reg);
}
}
finally
{
reader.Close();
reader.Dispose();
if (podeFecharBco)
{
this.deletarBanco_Dados();
}
}
return(lista);
}
public Dictionary <Tuple <long, DateTime>, DERMSCommon.SCADACommon.MonthItem> ReadFromDayTable(string connectionString)
{
DERMSCommon.SCADACommon.MonthItem itemMonth = null;
Dictionary <Tuple <long, DateTime>, DERMSCommon.SCADACommon.MonthItem> monthItems = new Dictionary <Tuple <long, DateTime>, DERMSCommon.SCADACommon.MonthItem>();
Tuple <long, DateTime> key = null;
Tuple <long, DateTime> keyM = null;
Dictionary <Tuple <long, DateTime>, DERMSCommon.SCADACommon.DayItem> dayItemsData = new Dictionary <Tuple <long, DateTime>, DERMSCommon.SCADACommon.DayItem>();
using (System.Data.SqlClient.SqlConnection _con = new System.Data.SqlClient.SqlConnection(connectionString))
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("SELECT Timestamp, Gid, E, PMax, PMin, PAvg FROM dbo.Day", _con))
{
_con.Open();
using (System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader())
{
// Check is the reader has any rows at all before starting to read.
if (reader.HasRows)
{
// Read advances to the next row.
while (reader.Read())
{
DERMSCommon.SCADACommon.DayItem c = new DERMSCommon.SCADACommon.DayItem();
// To avoid unexpected bugs access columns by name.
try
{
c.E = reader.GetDouble(reader.GetOrdinal("E"));
c.PAvg = reader.GetDouble(reader.GetOrdinal("PAvg"));
c.PMax = reader.GetDouble(reader.GetOrdinal("PMax"));
c.PMin = reader.GetDouble(reader.GetOrdinal("PMin"));
c.Timestamp = reader.GetDateTime(reader.GetOrdinal("Timestamp"));
c.Gid = reader.GetInt64(reader.GetOrdinal("Gid"));
//c.P = reader.GetDouble(reader.GetOrdinal("P"));
key = new Tuple <long, DateTime>(c.Gid, c.Timestamp);
dayItemsData.Add(key, c);
}
catch (Exception e)
{ }
}
}
}
_con.Close();
}
}
foreach (var d in dayItemsData)
{
//itemDay = new DERMSCommon.SCADACommon.DayItem(d.Key.Item1, d.Key.Item2.Date.AddHours(d.Key.Item2.Hour), MinProductionPerHour(d.Key.Item2.Hour, d.Key.Item2.DayOfYear, collectItemsData), MaxProductionPerHour(d.Key.Item2.Hour, d.Key.Item2.DayOfYear, collectItemsData), AvgProductionPerHour(d.Key.Item2.Hour, d.Key.Item2.DayOfYear, collectItemsData), 0, 0);
itemMonth = new DERMSCommon.SCADACommon.MonthItem(d.Key.Item1, d.Key.Item2.Date, MinProductionPerDay(d.Key.Item2.DayOfYear, d.Key.Item2.Month, dayItemsData, d.Key.Item1), MaxProductionPerDay(d.Key.Item2.DayOfYear, d.Key.Item2.Month, dayItemsData, d.Key.Item1), AvgProductionPerDay(d.Key.Item2.DayOfYear, d.Key.Item2.Month, dayItemsData, d.Key.Item1), 0, d.Value.P);
keyM = new Tuple <long, DateTime>(itemMonth.Gid, itemMonth.Timestamp);
if (!monthItems.ContainsKey(keyM))
{
monthItems.Add(keyM, itemMonth);
}
}
return(monthItems);
}
protected override DomainObject LoadEntity(int Id, SqlDataReader res)
{
Ilan ilan = new Ilan(Id);
if (res.Read())
{
string kur = res.GetString(4);
int ilanFiyat = res.GetInt32(3);
DateTime basTarih = res.GetDateTime(1);
DateTime bitTarih = res.GetDateTime(2);
IlanSuresi _ilanSuresi = new IlanSuresi(basTarih,bitTarih);
Fiyat _ilanFiyat = new Fiyat(ilanFiyat,kur);
ilan.IlanAdi = res.GetString(5);
ilan.IlanFiyat = _ilanFiyat;
ilan.IlanSuresi = _ilanSuresi;
}
return ilan;
}
private Category FillCategory(SqlDataReader reader)
{
var author = new Category();
author.Id = reader.GetInt32(0);
author.Name = reader.GetString(1);
author.DateCreated = reader.GetDateTime(2);
return author;
}
/// <summary>
/// 数据转转账实体
/// </summary>
public static ZhuanZhangInfo DataToModel(SqlDataReader rdr)
{
ZhuanZhangInfo zhang = new ZhuanZhangInfo();
if (!rdr.IsDBNull(0)) zhang.ZhuanZhangID = rdr.GetInt32(0);
if (!rdr.IsDBNull(1)) zhang.ZhuanZhangFrom = rdr.GetInt32(1);
if (!rdr.IsDBNull(2)) zhang.ZhuanZhangTo = rdr.GetInt32(2);
if (!rdr.IsDBNull(3)) zhang.ZhuanZhangDate = rdr.GetDateTime(3);
if (!rdr.IsDBNull(4)) zhang.ZhuanZhangMoney = rdr.GetDecimal(4);
if (!rdr.IsDBNull(5)) zhang.ZhuanZhangLive = rdr.GetByte(5);
if (!rdr.IsDBNull(7)) zhang.Synchronize = rdr.GetByte(6);
if (!rdr.IsDBNull(6)) zhang.ModifyDate = rdr.GetDateTime(7);
if (!rdr.IsDBNull(7)) zhang.UserID = rdr.GetInt32(8);
if (!rdr.IsDBNull(7)) zhang.ZhuanZhangNote = rdr.GetString(9);
if (!rdr.IsDBNull(7)) zhang.ZZID = rdr.GetInt32(10);
return zhang;
}
public void PrepareListModel(SqlDataReader dr, List<TableBaseInfo> infoList)
{
while (dr.Read())
{
TableBaseInfo info = new TableBaseInfo();
info.ID = dr.GetInt32(0);
info.TableName = dr[1].ToString();
info.TableDescription = dr[2].ToString();
info.Fields = dr[3].ToString();
info.UserID = dr.GetInt32(4);
info.UserName = dr[5].ToString();
info.Status = dr.GetInt32(6);
info.AddTime = dr.GetDateTime(7);
info.UpdateTime = (dr[8] == DBNull.Value ? info.AddTime : dr.GetDateTime(8));
info.MySysTableID = dr.GetInt32(9);
infoList.Add(info);
}
}
/// <summary>
///
/// </summary>
public void Load(System.Data.SqlClient.SqlConnection connection)
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.Connection = connection;
cmd.CommandText = "SELECT MCID, GroupID, Model, MCNo, MaintainID, IPAddress, PU, LU, DevicePoint, SourceConnection, ATMBandWidth, SDGatewayID, BandWidth, MCAccountID, MCFunc, SystemOS, OpenTime, bPoint, DetailAddress, Maintain_Money, Maintain_Sys, Maintain_Fix, BuyCaseNo, BuyDate, OpenDate, InstallDate, Memo, LoginGorupID FROM MCData WHERE ";
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
if (true == reader.Read())
{
_mCID = reader.GetString(0);
_groupID = reader.GetString(1);
_model = reader.GetString(2);
_mCNo = reader.GetString(3);
_maintainID = reader.GetString(4);
_iPAddress = reader.GetString(5);
_pU = reader.GetString(6);
_lU = reader.GetString(7);
_devicePoint = reader.GetString(8);
_sourceConnection = reader.GetString(9);
_aTMBandWidth = reader.GetInt32(10);
_sDGatewayID = reader.GetString(11);
_bandWidth = reader.GetInt32(12);
_mCAccountID = reader.GetString(13);
_mCFunc = reader.GetInt16(14);
_systemOS = reader.GetInt16(15);
_openTime = reader.GetString(16);
_bPoint = reader.GetString(17);
_detailAddress = reader.GetString(18);
_maintain_Money = reader.GetString(19);
_maintain_Sys = reader.GetString(20);
_maintain_Fix = reader.GetString(21);
_buyCaseNo = reader.GetString(22);
_buyDate = reader.GetDateTime(23);
_openDate = reader.GetDateTime(24);
_installDate = reader.GetDateTime(25);
_memo = reader.GetString(26);
_loginGorupID = reader.GetString(27);
}
reader.Close();
}
}
protected void moreInfoStudentLinkBtn_Click(object sender, CommandEventArgs e)
{
String connectionString = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString;
System.Data.SqlClient.SqlConnection sql = new System.Data.SqlClient.SqlConnection(connectionString);
int rowIndex = Convert.ToInt32(((sender as LinkButton).NamingContainer as GridViewRow).RowIndex);
GridViewRow row = GridView1.Rows[rowIndex];
int applicationID = Convert.ToInt32(e.CommandArgument);
sql.Open();
System.Data.SqlClient.SqlCommand moreJobInfo = new System.Data.SqlClient.SqlCommand();
moreJobInfo.Connection = sql;
moreJobInfo.CommandText = "SELECT Student.FirstName + ' ' + Student.LastName, Student.StudentGPA, Student.StudentGraduationTrack, JobListing.JobTitle, JobListing.JobDescription, JobListing.JobType, JobListing.Location, JobListing.Deadline, JobListing.NumOfApplicants, Organization.OrganizationName, Organization.OrganizationDescription FROM Organization INNER JOIN JobListing ON Organization.OrganizationEntityID = JobListing.OrganizationID INNER JOIN ApplicationRequest ON JobListing.JobListingID = ApplicationRequest.JobListingID INNER JOIN Student ON ApplicationRequest.StudentEntityID = Student.StudentEntityID where ApplicationRequest.ApplicationID = " + applicationID;
System.Data.SqlClient.SqlDataReader reader = moreJobInfo.ExecuteReader();
while (reader.Read())
{
//set labels to db values
lblStudentName.Text = reader.GetString(0);
lblSudentGPA.Text = "GPA: " + reader.GetDouble(1).ToString();
// On track if statement
String status = reader.GetString(2);
if (status == "Y")
{
lblStudentStatus.Text = "Student on Track";
}
else
{
lblStudentStatus.Text = "Student not on Track";
}
lblOrgName.Text = "Organization Name: " + reader.GetString(9);
lblOrgDesc.Text = "Organization Description: " + reader.GetString(10);
lblJobTitle.Text = "Job Title: " + reader.GetString(3);
lblJobDesc.Text = "Job Description: " + reader.GetString(4);
lblJobLocation.Text = "Location: " + reader.GetString(6);
lblJobDeadline.Text = "Deadline: " + reader.GetDateTime(7).ToString();
lblNumberOfApplicants.Text = "Number Of Applicants: " + reader.GetInt32(8).ToString();
}
sql.Close();
Session["selectedapplicationID"] = applicationID.ToString();
ClientScript.RegisterStartupScript(this.GetType(), "Pop", "openEditSModal();", true);
}
} //gets int or defaults value to '0'
public DateTime GetDateTimeOrMinValue(System.Data.SqlClient.SqlDataReader r, int i)
{
DateTime rv = DateTime.MinValue;
if (!r.IsDBNull(i))
{
rv = r.GetDateTime(i);
}
return(rv);
} //gets the date or sets the minimum value
private string GetObjectValue(System.Data.SqlClient.SqlDataReader reader, int i)
{
string fieldType = reader.GetFieldType(i).ToString();
object FieldValue = null;;
if (fieldType.Contains("Int32"))
{
FieldValue = reader.GetInt32(i);
}
else if (fieldType.Contains("Int64"))
{
FieldValue = reader.GetInt64(i);
}
else if (fieldType.Contains("Decimal"))
{
FieldValue = reader.GetDecimal(i);
}
else if (fieldType.Contains("Double"))
{
FieldValue = reader.GetDouble(i);
}
else if (fieldType.Contains("DateTime"))
{
FieldValue = reader.GetDateTime(i);
}
else if (fieldType.Contains("String"))
{
FieldValue = reader.GetString(i);
}
else if (fieldType.Contains("Boolean"))
{
FieldValue = reader.GetBoolean(i);
}
else if (fieldType.Contains("Byte"))
{
FieldValue = reader.GetByte(i);
}
else if (fieldType.Contains("Guid"))
{
FieldValue = reader.GetGuid(i);
}
else
{
FieldValue = reader.GetString(i);
}
if (FieldValue != null)
{
return(FieldValue.ToString());
}
else
{
return("");
}
}
private Author FillAuthor(SqlDataReader reader)
{
var author = new Author();
author.Id = reader.GetInt32(0);
author.Name = reader.GetString(1);
author.Email = reader.GetString(2);
author.Password = reader.GetString(3);
author.IsActive = reader.GetBoolean(4);
author.DateCreated = reader.GetDateTime(5);
return author;
}
public TimeLine(string roadmapname)
{
mDatabase.connect();
mReader = mDatabase.executeread("SELECT ID, StartDate, EndDate FROM [dbo].[Timeline] WHERE RoadmapName = '" + roadmapname + "'");
mReader.Read();
mID = mReader.GetInt32(0);
mStartDate = mReader.GetDateTime(1);
mEndDate = mReader.GetDateTime(2);
mDatabase.close();
mDatabase.connect();
mReader = mDatabase.executeread("SELECT Name, XPlacement FROM [dbo].[TickMark] WHERE TimelineID = '" + mID + "'");
while (mReader.Read())
{
TickMark tick = new TickMark(mReader.GetString(0).ToString(), mReader.GetInt32(1));
mTicks.Add(tick);
}
mDatabase.close();
}
/// <summary>
/// 数据转查询实体
/// </summary>
public static UserQueryInfo DataToModel(SqlDataReader rdr)
{
UserQueryInfo query = new UserQueryInfo();
if (!rdr.IsDBNull(0)) query.UserQueryID = rdr.GetInt32(0);
if (!rdr.IsDBNull(1)) query.UserQueryName = rdr.GetString(1);
if (!rdr.IsDBNull(2)) query.UserQueryURL = rdr.GetString(2);
if (!rdr.IsDBNull(3)) query.UserQueryValue = rdr.GetString(3);
if (!rdr.IsDBNull(4)) query.UserQueryLive = rdr.GetByte(4);
if (!rdr.IsDBNull(5)) query.UserID = rdr.GetInt32(5);
if (!rdr.IsDBNull(6)) query.ModifyDate = rdr.GetDateTime(6);
return query;
}
private Post FillPost(SqlDataReader reader)
{
var post = new Post();
post.Id = reader.GetInt32(0);
post.Author = new Author();
post.Author.Id = reader.GetInt32(1);
post.Title = reader.GetValueOrDefault<string>(2);
post.Body = reader.GetValueOrDefault<string>(3);
post.IsPublished = reader.GetBoolean(4);
post.DateCreated = reader.GetDateTime(5);
return post;
}
private Comment FillComment(SqlDataReader reader)
{
var comment = new Comment();
comment.Id = reader.GetInt32(0);
comment.PostId = reader.GetInt32(1);
comment.Name = reader.GetString(2);
comment.Email = reader.GetValueOrDefault<string>(3);
comment.Url = reader.GetValueOrDefault<string>(4);
comment.Body = reader.GetString(5);
comment.Status = (CommentStatus)reader.GetInt32(6);
comment.DateCreated = reader.GetDateTime(7);
return comment;
}
/// <summary>
/// 数据转专题实体
/// </summary>
public static ZhuanTiInfo DataToModel(SqlDataReader rdr)
{
ZhuanTiInfo zhuanTi = new ZhuanTiInfo();
if (!rdr.IsDBNull(0)) zhuanTi.ZhuanTiID = rdr.GetInt32(0);
if (!rdr.IsDBNull(1)) zhuanTi.ZhuanTiName = rdr.GetString(1);
if (!rdr.IsDBNull(2)) zhuanTi.ZhuanTiImage = rdr.GetString(2);
if (!rdr.IsDBNull(3)) zhuanTi.UserID = rdr.GetInt32(3);
if (!rdr.IsDBNull(4)) zhuanTi.ZhuanTiLive = rdr.GetByte(4);
if (!rdr.IsDBNull(5)) zhuanTi.Synchronize = rdr.GetByte(5);
if (!rdr.IsDBNull(6)) zhuanTi.ModifyDate = rdr.GetDateTime(6);
if (!rdr.IsDBNull(7)) zhuanTi.ZTID = rdr.GetInt32(7);
return zhuanTi;
}
private Library ReadLibrary(SqlDataReader reader)
{
return new Library
{
MovieId = reader.GetInt32(0),
Title = reader.GetString(1),
ReleaseDate = reader.GetDateTime(2),
Description = reader.GetString(3),
GenresName = reader.GetString(4),
DirectorsFirstName = reader.GetString(5),
DirectorsLastName = reader.GetString(6),
LanguagesName = reader.GetString(7)
};
}
/// <summary>
///
/// </summary>
public void Load(System.Data.SqlClient.SqlConnection connection)
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.Connection = connection;
cmd.CommandText = "SELECT SecureKey, AccounID, LoginType, IPAddress, CreateDatetime, UsedDatetime, IsUsed FROM SecurityUserAccount_SecureKey WHERE ";
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
if (true == reader.Read())
{
_secureKey = reader.GetString(0);
_accounID = reader.GetString(1);
_loginType = reader.GetInt32(2);
_iPAddress = reader.GetString(3);
_createDatetime = reader.GetDateTime(4);
_usedDatetime = reader.GetDateTime(5);
_isUsed = reader.GetInt32(6);
}
reader.Close();
}
}
/// <summary>
/// 数据转第三方登录实体
/// </summary>
public static OAuthInfo DataToModel(SqlDataReader rdr)
{
OAuthInfo oauth = new OAuthInfo();
if (!rdr.IsDBNull(0)) oauth.OAuthID = rdr.GetInt32(0);
if (!rdr.IsDBNull(1)) oauth.OpenID = rdr.GetString(1);
if (!rdr.IsDBNull(2)) oauth.AccessToken = rdr.GetString(2);
if (!rdr.IsDBNull(3)) oauth.UserID = rdr.GetInt32(3);
if (!rdr.IsDBNull(4)) oauth.OldUserID = rdr.GetInt32(4);
if (!rdr.IsDBNull(5)) oauth.OAuthBound = rdr.GetByte(5);
if (!rdr.IsDBNull(6)) oauth.OAuthFrom = rdr.GetString(6);
if (!rdr.IsDBNull(7)) oauth.ModifyDate = rdr.GetDateTime(7);
return oauth;
}
public void Property(string key, SqlDataReader reader, int idx)
{
jsonWriter.WritePropertyName(key);
string typeName = reader.GetDataTypeName(idx);
if (reader.IsDBNull(idx))
jsonWriter.WriteNull();
else if (typeName == "decimal")
jsonWriter.WriteValue(reader.GetDecimal(idx));
else if (typeName == "datetime")
jsonWriter.WriteValue(reader.GetDateTime(idx));
else if (typeName == "varchar" || typeName == "nvarchar")
jsonWriter.WriteValue(reader.GetString(idx));
else
throw new Exception("Unknown data type " + typeName);
}
SqlJobMetrics build_sql_job_metric_from_reader(SqlDataReader reader)
{
var metric = new SqlJobMetrics();
metric.job_name = reader.GetString(0);
metric.message = reader.GetString(1);
var job_outcome_key = reader.GetByte(2);
metric.job_status = get_job_outcome_from_key(job_outcome_key);
metric.last_run = reader.GetDateTime(3);
metric.job_step = reader.GetInt16(4);
return metric;
}
protected override Exception ProcessSqlResult(SqlDataReader reader)
{
Exception exception = StoreUtilities.GetNextResultSet(base.InstancePersistenceCommand.Name, reader);
if (exception == null)
{
bool instancesExist = !reader.IsDBNull(1);
TimeSpan? timeTillNextPoll = null;
bool instancesReadyToRun = false;
if (instancesExist)
{
DateTime expirationTime = reader.GetDateTime(1);
DateTime utcNow = reader.GetDateTime(2);
if (expirationTime <= utcNow)
{
instancesReadyToRun = true;
}
else
{
timeTillNextPoll = expirationTime.Subtract(utcNow);
}
}
if (instancesReadyToRun)
{
base.Store.UpdateEventStatus(true, HasRunnableWorkflowEvent.Value);
}
else
{
base.Store.UpdateEventStatus(false, HasRunnableWorkflowEvent.Value);
base.StoreLock.InstanceDetectionTask.ResetTimer(false, timeTillNextPoll);
}
}
return exception;
}
public static string ParseDateAsString(System.Data.SqlClient.SqlDataReader rdr, int index)
{
DateTime data = DateTime.Now;
try
{
data = rdr.GetDateTime(index);
return(DateAsString(data));
}
catch (Exception ex)
{
data = DateTime.MinValue;
return(DateAsString(data));
}
}
public ArticleListInfo(SqlDataReader reader)
{
//Id, Guid, Template, Classes, Categorys, Title, ShortTitle,Thumbnail, Datetime, Editor,Hits
id = reader.GetInt32(0);
guid = reader.GetString(1);
templateId = reader.GetString(2);
classes = reader.GetString(3);
categories = reader.GetString(4);
title = reader.GetString(5);
shortTitle = reader.GetString(6);
thumbnail = reader.GetString(7);
datetime = reader.GetDateTime(8);
editor = reader.GetString(9);
hits = reader.GetInt32(10);
}
//Bold the dates that have events
public void boldEventDays()
{
sqlCmd = new SqlCommand("select event_begin as 'Event Begin' from event", sc);
sqlRdr = sqlCmd.ExecuteReader();
monthCalendar.RemoveAllBoldedDates();
while (sqlRdr.Read())
{
monthCalendar.AddBoldedDate(sqlRdr.GetDateTime(0));
}
monthCalendar.UpdateBoldedDates();
sqlRdr.Close();
}
public static DateTime ParseDateTime(System.Data.SqlClient.SqlDataReader rdr, int index)
{
DateTime data = DateTime.Now;
try
{
data = rdr.GetDateTime(index);
}
catch (Exception ex)
{
data = DateTime.MinValue;
ex.GetHashCode();
}
return(data);
}
//Does not load the fileData column
public override FileVO ReadRecord(System.Data.SqlClient.SqlDataReader reader)
{
FileVO result = new FileVO();
result.Id = reader.GetInt32(reader.GetOrdinal(idColumnName));
result.Name = reader[fileName].ToString();
DocumentDAO ddao = new DocumentDAO();
result.Document = ddao.GetItem(reader.GetInt32(reader.GetOrdinal(fileDocumentId)));
ddao.CloseConnection();
short valInt = reader.GetInt16(reader.GetOrdinal(fileType));
result.Type = (FileVO.FileType)valInt;
result.AdditionDateTime = reader.GetDateTime(reader.GetOrdinal(fileAdditionDate));
return(result);
}
public Paciente crearObjetoPaciente(SqlDataReader resultado)
{
Paciente paciente = new Paciente();
paciente.Id = resultado.GetInt32(0);
paciente.Nombre = resultado.GetString(1);
paciente.ApellidoPaterno = resultado.GetString(2);
paciente.ApellidoMaterno = resultado.GetString(3);
paciente.Dni = resultado.GetString(4);
paciente.Direccion = resultado.GetString(5);
paciente.Telefono = resultado.GetString(6);
paciente.Celular = resultado.GetString(7);
paciente.Sexo = resultado.GetString(8);
paciente.Correo = resultado.GetString(9);
paciente.FechaNacimiento = resultado.GetDateTime(10);
paciente.Estado = resultado.GetString(11);
return paciente;
}
public override LogEntryVO ReadRecord(System.Data.SqlClient.SqlDataReader reader)
{
LogEntryVO result = new LogEntryVO();
result.Id = reader.GetInt32(reader.GetOrdinal(idColumnName));
result.DateTime = reader.GetDateTime(reader.GetOrdinal(logEntryDateTime));
result.Description = reader[logEntryDescription].ToString();
int userId = reader.GetInt32(reader.GetOrdinal(logEntryUserId));
int operationId = reader.GetInt32(reader.GetOrdinal(logEntryOperationId));
result.User = firstTableDAO.GetItem(userId);
result.Operation = secondTableDAO.GetItem(operationId);
firstTableDAO.CloseConnection();
secondTableDAO.CloseConnection();
return(result);
}
public StockSummary ReadStockAnalysis(string symbol)
{
if (StockConn.ConnectionString == String.Empty)
{
StockConn = new SqlConnection(Conn);
}
string query = "SELECT * FROM [Stock].[dbo].[StockAnalysis] WHERE [symbol] = @symbol";
StockConn.Open();
SqlCommand cmd = new SqlCommand(query, StockConn);
cmd.Parameters.Add("@symbol", System.Data.SqlDbType.Char);
// set values to parameters from textboxes
cmd.Parameters["@symbol"].Value = symbol;
using (System.Data.SqlClient.SqlDataReader oReader = cmd.ExecuteReader())
{
StockSummary summary = new StockSummary();
summary.Symbol = symbol;
if (oReader.HasRows)
{
while (oReader.Read())
{
var parsed = JObject.Parse(oReader["patternData"].ToString());
var r = parsed["boundaries"].ToString();
r = r.Substring(1, r.Length - 2);
string[] r1 = r.Split(',');
double[] re = new double[4] {
double.Parse(r1[0]), double.Parse(r1[1]), double.Parse(r1[2]), double.Parse(r1[3])
};
summary.SerializedProperties = new Dictionary <string, object>();
summary.SerializedProperties.Add("boundaries", re);
summary.CacheData.Add("fail", false);
summary.LastUpdate = oReader.GetDateTime(8);
}
}
else
{
summary.CacheData.Add("fail", true);
}
StockConn.Close();
return(summary);
}
}
public Receipt GetReceiptByReceiptID(int id)
{
Receipt Receipt = null;
Dao dao = new Dao();
string sqlStatement = "SELECT EmployeeID, TableNumber, PrintDate, Total, AdditionalFee FROM Receipt WHERE ReceiptID='" + id + "'";
System.Data.SqlClient.SqlDataReader reader = dao.Get(sqlStatement);
if (reader.Read())
{
int emID = reader.GetInt32(0);
int tablenumber = reader.GetInt32(1);
DateTime date = reader.GetDateTime(2);
double total = (double)reader.GetDecimal(3);
double addFee = (double)reader.GetDecimal(4);
Receipt = new Receipt(id, emID, tablenumber, date, total, addFee);
}
dao.Con.Close();
return(Receipt);
}
public Payment GetPaymentByEmpID(int employeeID)
{
Payment payment = null;
Dao dao = new Dao();
string sqlStatement = "SELECT PaymentID, EmployeeID, PayDate, TotalFee, Detail FROM Payment WHERE EmployeeID='" + employeeID + "'";
System.Data.SqlClient.SqlDataReader reader = dao.Get(sqlStatement);
if (reader.Read())
{
int pID = reader.GetInt32(0);
int eID = reader.GetInt32(1);
DateTime pD = reader.GetDateTime(2);
decimal tF = reader.GetDecimal(3);
string de = reader.GetString(4);
payment = new Payment(pID, eID, pD, Decimal.ToDouble(tF), de);
}
dao.Con.Close();
return(payment);
}
/// <summary>
///
/// </summary>
public void Load(System.Data.SqlClient.SqlConnection connection)
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.Connection = connection;
cmd.CommandText = "SELECT PCAURS_ID, PCAGROUP_ID, LDATE, LUSER FROM MIP_PCAGROUP_PCAURS WHERE ";
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
if (true == reader.Read())
{
_pCAURS_ID = reader.GetString(0);
_pCAGROUP_ID = reader.GetString(1);
_lDATE = reader.GetDateTime(2);
_lUSER = reader.GetString(3);
}
reader.Close();
}
}
public Employee GetEmployeeByID(int id)
{
Employee employee = null;
Dao dao = new Dao();
string sqlStatement = "SELECT EmployeeName, Gender, Position, StartDate, Address, PhoneNumber FROM Employee WHERE EmployeeID='" + id + "'";
System.Data.SqlClient.SqlDataReader reader = dao.Get(sqlStatement);
if (reader.Read())
{
string name = reader.GetString(0);
bool gender = reader.GetBoolean(1);
string position = reader.GetString(2);
DateTime date = reader.GetDateTime(3);
string address = reader.GetString(4);
string phone = reader.GetString(5);
employee = new Employee(id, name, gender, position, date, address, phone);
}
dao.Con.Close();
return(employee);
}
