/// <summary> /// 验证用户登录信息 /// </summary> /// <param name="user">用户的登录信息</param> /// <returns>登录成功时返回一个非空的User类的对象,否则返回null</returns> public static User LoginAuthentication(User user) { // user.Password = PasswordEncryption(user.Password); ISQLHelper helper = new SqlServerHelper(); using (SqlConnection conn = helper.GetConnection()) { conn.Open(); string sql = "SELECT * FROM [dbo].[Users] WHERE Account = @Account AND Password = @Password"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Add("@Account", SqlDbType.VarChar); cmd.Parameters["@Account"].Value = user.Account; cmd.Parameters.Add("@Password", SqlDbType.VarChar); cmd.Parameters["@Password"].Value = user.Password; using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { System.Data.IDataRecord record = reader; user.UserName = record.GetString(2); return(user); } } } return(null); }
//Typically I have properties in here pointing to the Data.Model class protected override void Initialize(System.Data.IDataRecord dataRow) { _metaData = new Model.Metadata(); _metaData.Id = Convert.ToInt32(dataRow["Id"].ToString()); _metaData.Title = (dataRow["Title"].ToString()); _metaData.Sku = (dataRow["Sku"].ToString()); _metaData.IsLive = Convert.ToBoolean(dataRow["IsLive"].ToString()); }
public void addbody(System.Data.IDataRecord src_dbo_xliff_file, XmlNode tgt_file) { // Create "body" XmlNode new_body = Altova.Xml.XmlTreeOperations.AddElement(tgt_file, xliff_core_1_2_transitional_TypeInfo.binder.Members[xliff_core_1_2_transitional_TypeInfo._altova_mi_xlf_altova_fileType_altova_body]); loopdbo_xliff_Group_FileID(src_dbo_xliff_file, new_body); }
public void addgroup(System.Data.IDataRecord src_dbo_xliff_Group_FileID, XmlNode tgt_body) { // Create "group" XmlNode new_group = Altova.Xml.XmlTreeOperations.AddElement(tgt_body, xliff_core_1_2_transitional_TypeInfo.binder.Members[xliff_core_1_2_transitional_TypeInfo._altova_mi_xlf_altova_bodyType_altova_group]); loopGroupText(src_dbo_xliff_Group_FileID, new_group); loopdbo_xliff_TransID_GroupID(src_dbo_xliff_Group_FileID, new_group); }
public void addtrans_unit(System.Data.IDataRecord src_dbo_xliff_TransID_GroupID, XmlNode tgt_group) { // Create "trans-unit" XmlNode new_trans_unit = Altova.Xml.XmlTreeOperations.AddElement(tgt_group, xliff_core_1_2_transitional_TypeInfo.binder.Members[xliff_core_1_2_transitional_TypeInfo._altova_mi_xlf_altova_groupType_altova_trans_unit]); loopTransIDText(src_dbo_xliff_TransID_GroupID, new_trans_unit); loopdbo_xliff_Value_TransID(src_dbo_xliff_TransID_GroupID, new_trans_unit); loopdbo_xliff_Value_TransID2(src_dbo_xliff_TransID_GroupID, new_trans_unit); }
/// <summary> /// /// </summary> /// <typeparam name="T"></typeparam> /// <typeparam name="Instance"></typeparam> /// <param name="dataRecord"></param> /// <param name="memberName"></param> /// <returns></returns> public static T ReadingValueFromDataRecordTypeHandler <T, Instance>(System.Data.IDataRecord dataRecord, string memberName) { var attribute = TypeHandlerAttributeStorager <Instance> .Query(memberName); if (attribute == null) { return(default(T)); } return(attribute.OnDataReading <T>(dataRecord, memberName)); }
//this method is to check wheater column exists or not in data reader public static bool IsColumnExists(this System.Data.IDataRecord dr, string colName) { try { return(dr.GetOrdinal(colName) >= 0); } catch (Exception) { return(false); } }
public void addfile(System.Data.IDataRecord src_dbo_xliff_file, XmlNode tgt_xliff) { // Create "file" XmlNode new_file = Altova.Xml.XmlTreeOperations.AddElement(tgt_xliff, xliff_core_1_2_transitional_TypeInfo.binder.Members[xliff_core_1_2_transitional_TypeInfo._altova_mi_xlf_altova_xliffType_altova_file]); loopSourceLanguage(src_dbo_xliff_file, new_file); loopDataType(src_dbo_xliff_file, new_file); loopTargetLanguage(src_dbo_xliff_file, new_file); addheader(src_dbo_xliff_file, new_file); addbody(src_dbo_xliff_file, new_file); }
public void loopdbo_xliff_Value_TransID2(System.Data.IDataRecord src_dbo_xliff_TransID_GroupID, XmlNode tgt_trans_unit) { // loop "dbo.xliff_Value|TransID" ((System.Data.IDataParameter)m_Queryloopdbo_xliff_Value_TransID2.Parameters["0"]).Value = Altova.Db.DbTreeOperations.FindAttribute(src_dbo_xliff_TransID_GroupID, EPRTRcms_TypeInfo.binder.Members[EPRTRcms_TypeInfo._altova_mi_dbo_altova_xliff_TransID_altova_TransID]); using (Altova.Db.DbTreeOperations.MemberIterator en_dbo_xliff_Value_TransID = Altova.Db.DbTreeOperations.GetElements(src_dbo_xliff_TransID_GroupID, EPRTRcms_TypeInfo.binder.Members[EPRTRcms_TypeInfo._altova_mi_dbo_altova_xliff_TransID_altova_dbo_xliff_Value_TransID], m_Queryloopdbo_xliff_Value_TransID2)) { foreach (System.Data.IDataRecord cur_dbo_xliff_Value_TransID in en_dbo_xliff_Value_TransID) { loopTarget(cur_dbo_xliff_Value_TransID, tgt_trans_unit); } } }
public void loopdbo_xliff_Group_FileID(System.Data.IDataRecord src_dbo_xliff_file, XmlNode tgt_body) { // loop "dbo.xliff_Group|FileID" ((System.Data.IDataParameter)m_Queryloopdbo_xliff_Group_FileID.Parameters["0"]).Value = Altova.Db.DbTreeOperations.FindAttribute(src_dbo_xliff_file, EPRTRcms_TypeInfo.binder.Members[EPRTRcms_TypeInfo._altova_mi_dbo_altova_xliff_file_altova_FileID]); using (Altova.Db.DbTreeOperations.MemberIterator en_dbo_xliff_Group_FileID = Altova.Db.DbTreeOperations.GetElements(src_dbo_xliff_file, EPRTRcms_TypeInfo.binder.Members[EPRTRcms_TypeInfo._altova_mi_dbo_altova_xliff_file_altova_dbo_xliff_Group_FileID], m_Queryloopdbo_xliff_Group_FileID)) { foreach (System.Data.IDataRecord cur_dbo_xliff_Group_FileID in en_dbo_xliff_Group_FileID) { addgroup(cur_dbo_xliff_Group_FileID, tgt_body); } } }
protected TEntity Map <TEntity>(System.Data.IDataRecord record) { var objT = Activator.CreateInstance <TEntity>(); foreach (var property in typeof(TEntity).GetProperties()) { if (record.HasColumn(property.Name) && !record.IsDBNull(record.GetOrdinal(property.Name))) { property.SetValue(objT, record[property.Name]); } } return(objT); }
public static Int32 GetInt32(this System.Data.IDataRecord record, string fieldname, Int32 defaultIfNull) { object value = record[fieldname]; if (value is Int32) { return((Int32)value); } else { return(value == DBNull.Value ? defaultIfNull : Convert.ToInt32(value)); } }
public static string GetString(this System.Data.IDataRecord record, int index, string defaultIfNull) { object value = record[index]; if (value is string) { return((string)value); } else { return(value == DBNull.Value ? defaultIfNull : value.ToString()); } }
public void loopuid(System.Data.IDataRecord src_dbo_xliff_header_FileID, XmlNode tgt_header) { // loop "uid" object cur_uid = Altova.Db.DbTreeOperations.FindAttribute( src_dbo_xliff_header_FileID, EPRTRcms_TypeInfo.binder.Members[EPRTRcms_TypeInfo._altova_mi_dbo_altova_xliff_header_altova_uid]); if (Altova.Db.DbTreeOperations.Exists(cur_uid)) { m_var18_uid = cur_uid; m_var21_uid_string = Altova.Db.DbTreeOperations.CastToString(m_var18_uid, EPRTRcms_TypeInfo.binder.Members[EPRTRcms_TypeInfo._altova_mi_dbo_altova_xliff_header_altova_uid]); addnote(cur_uid, tgt_header); } }
public static DateTime GetDateTime(this System.Data.IDataRecord record, string fieldname) { object value = record[fieldname]; if (value is DateTime) { return((DateTime)value); } else { return((value == DBNull.Value) ? DateTime.MinValue : Convert.ToDateTime(value)); } }
public void loopTransIDText(System.Data.IDataRecord src_dbo_xliff_TransID_GroupID, XmlNode tgt_trans_unit) { // loop "TransIDText" object cur_TransIDText = Altova.Db.DbTreeOperations.FindAttribute( src_dbo_xliff_TransID_GroupID, EPRTRcms_TypeInfo.binder.Members[EPRTRcms_TypeInfo._altova_mi_dbo_altova_xliff_TransID_altova_TransIDText]); if (Altova.Db.DbTreeOperations.Exists(cur_TransIDText)) { m_var30_TransIDText = cur_TransIDText; m_var33_TransIDText_string = Altova.Db.DbTreeOperations.CastToString(m_var30_TransIDText, EPRTRcms_TypeInfo.binder.Members[EPRTRcms_TypeInfo._altova_mi_dbo_altova_xliff_TransID_altova_TransIDText]); addid2(cur_TransIDText, tgt_trans_unit); } }
public void loopTarget(System.Data.IDataRecord src_dbo_xliff_Value_TransID, XmlNode tgt_trans_unit) { // loop "Target" object cur_Target = Altova.Db.DbTreeOperations.FindAttribute( src_dbo_xliff_Value_TransID, EPRTRcms_TypeInfo.binder.Members[EPRTRcms_TypeInfo._altova_mi_dbo_altova_xliff_Value_altova_Target]); if (Altova.Db.DbTreeOperations.Exists(cur_Target)) { m_var42_Target = cur_Target; m_var45_Target_string = Altova.Db.DbTreeOperations.CastToString(m_var42_Target, EPRTRcms_TypeInfo.binder.Members[EPRTRcms_TypeInfo._altova_mi_dbo_altova_xliff_Value_altova_Target]); addtarget(cur_Target, tgt_trans_unit); } }
public void loopSource(System.Data.IDataRecord src_dbo_xliff_Value_TransID, XmlNode tgt_trans_unit) { // loop "Source" object cur_Source = Altova.Db.DbTreeOperations.FindAttribute( src_dbo_xliff_Value_TransID, EPRTRcms_TypeInfo.binder.Members[EPRTRcms_TypeInfo._altova_mi_dbo_altova_xliff_Value_altova_Source]); if (Altova.Db.DbTreeOperations.Exists(cur_Source)) { m_var36_Source = cur_Source; m_var39_Source_string = Altova.Db.DbTreeOperations.CastToString(m_var36_Source, EPRTRcms_TypeInfo.binder.Members[EPRTRcms_TypeInfo._altova_mi_dbo_altova_xliff_Value_altova_Source]); addsource(cur_Source, tgt_trans_unit); } }
public void loopGroupText(System.Data.IDataRecord src_dbo_xliff_Group_FileID, XmlNode tgt_group) { // loop "GroupText" object cur_GroupText = Altova.Db.DbTreeOperations.FindAttribute( src_dbo_xliff_Group_FileID, EPRTRcms_TypeInfo.binder.Members[EPRTRcms_TypeInfo._altova_mi_dbo_altova_xliff_Group_altova_GroupText]); if (Altova.Db.DbTreeOperations.Exists(cur_GroupText)) { m_var24_GroupText = cur_GroupText; m_var27_GroupText_string = Altova.Db.DbTreeOperations.CastToString(m_var24_GroupText, EPRTRcms_TypeInfo.binder.Members[EPRTRcms_TypeInfo._altova_mi_dbo_altova_xliff_Group_altova_GroupText]); addid(cur_GroupText, tgt_group); } }
public static bool GetBoolean(this System.Data.IDataRecord record, string fieldname, bool defaultIfNull) { object value = record[fieldname]; if (value is bool) { return((bool)value); } else { return(value == DBNull.Value ? defaultIfNull : Convert.ToBoolean(value)); } }
public static byte[] GetBytes(this System.Data.IDataRecord record, string fieldName) { int Index = record.GetOrdinal(fieldName); object Value = record[Index]; if (Value == DBNull.Value) { return(new byte[] { }); } else { return((byte[])Value); } }
public void loopDataType(System.Data.IDataRecord src_dbo_xliff_file, XmlNode tgt_file) { // loop "DataType" object cur_DataType = Altova.Db.DbTreeOperations.FindAttribute( src_dbo_xliff_file, EPRTRcms_TypeInfo.binder.Members[EPRTRcms_TypeInfo._altova_mi_dbo_altova_xliff_file_altova_DataType]); if (Altova.Db.DbTreeOperations.Exists(cur_DataType)) { m_var8_DataType = cur_DataType; m_var9_DataType_string = Altova.Db.DbTreeOperations.CastToString(m_var8_DataType, EPRTRcms_TypeInfo.binder.Members[EPRTRcms_TypeInfo._altova_mi_dbo_altova_xliff_file_altova_DataType]); m_var11_DataType_string_anySimpleType = Altova.CoreTypes.CastToString(m_var9_DataType_string); adddatatype(cur_DataType, tgt_file); } }
public static DateTime GetLocalDateTime(this System.Data.IDataRecord record, string fieldname) { object value = record[fieldname]; if (value is DateTime) { DateTime val = (DateTime)value; return(TimeZone.CurrentTimeZone.ToLocalTime(val)); } else { return((value == DBNull.Value) ? DateTime.MinValue : Convert.ToDateTime(value)); } }
public void loopTargetLanguage(System.Data.IDataRecord src_dbo_xliff_file, XmlNode tgt_file) { // loop "TargetLanguage" object cur_TargetLanguage = Altova.Db.DbTreeOperations.FindAttribute( src_dbo_xliff_file, EPRTRcms_TypeInfo.binder.Members[EPRTRcms_TypeInfo._altova_mi_dbo_altova_xliff_file_altova_TargetLanguage]); if (Altova.Db.DbTreeOperations.Exists(cur_TargetLanguage)) { m_var12_TargetLanguage = cur_TargetLanguage; m_var13_TargetLanguage_string = Altova.Db.DbTreeOperations.CastToString(m_var12_TargetLanguage, EPRTRcms_TypeInfo.binder.Members[EPRTRcms_TypeInfo._altova_mi_dbo_altova_xliff_file_altova_TargetLanguage]); m_var15_TargetLanguage_string_language = Altova.CoreTypes.CastToString(m_var13_TargetLanguage_string); addtarget_language(cur_TargetLanguage, tgt_file); } }
private static Type[] GetTypesFromReader(System.Data.IDataRecord rdr) { Type[] types = new Type[rdr.FieldCount]; for (int i = 0; i < rdr.FieldCount; i++) { types[i] = rdr.GetFieldType(i); var nnType = Nullable.GetUnderlyingType(types[i]); if (nnType != null) { types[i] = nnType; } } return(types); }
public VoteInfo PopulateVote(System.Data.IDataRecord reader) { VoteInfo voteInfo = new VoteInfo(); Type type = voteInfo.GetType(); for (int i = 0; i < reader.FieldCount; i++) { string name = reader.GetName(i); PropertyInfo property = type.GetProperty(name); if (property != null) { property.SetValue(voteInfo, reader[i], null); } } return(voteInfo); }
/// <summary> /// 根据ID查询雇员信息 /// </summary> /// <param name="key">查询ID</param> /// <returns></returns> dynamic IModelService.Get(dynamic key) { string id = key; try { using (SqlConnection conn = sqlHelper.GetConnection()) { conn.Open(); string sql = "SELECT * FROM [dbo].[EmployeeInfo] WHERE Id = @Id;"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Add("@Id", SqlDbType.NVarChar); cmd.Parameters["@Id"].Value = id; using (SqlDataReader reader = cmd.ExecuteReader()) { if (reader.Read()) { System.Data.IDataRecord record = reader; IFactory factory = FactoryService.GetFactory(record.GetString(4)); IEmployee emp = factory.Get(); emp.Id = int.Parse(record.GetString(0)); emp.Name = record.GetString(1); emp.Age = record.GetInt32(2); emp.Sex = record.GetString(6); return(emp); } else { return(null); } } } } catch (SqlException sqle) { throw sqle; } catch (Exception e) { throw e; } }
/// <summary> /// 获取所有雇员的信息 /// </summary> /// <returns></returns> public static List <IEmployee> GetEmployeeInfo() { using (SqlConnection conn = sqlHelper.GetConnection()) { conn.Open(); List <IEmployee> list = new List <IEmployee>(); string sql = "SELECT * FROM [dbo].[EmployeeInfo];"; SqlCommand cmd = new SqlCommand(sql, conn); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { System.Data.IDataRecord record = reader; IEmployee emp = null; if (record.GetString(4).Equals("Worker")) { emp = new WorkerFactory().Get(); } else if (record.GetString(4).Equals("Manager")) { emp = new ManagerFactory().Get(); } else { emp = new DriverFactory().Get(); } emp.Id = record.GetInt32(0); emp.Name = record.GetString(1); emp.Sex = record.GetString(2); emp.Age = record.GetInt32(3); list.Add(emp); } } conn.Dispose(); cmd.Dispose(); return(list); } }
public static string GetShortDate(this System.Data.IDataRecord record, string fieldname) { object value = record[fieldname]; DateTime?date; if (value is DateTime) { date = (DateTime)value; } else if (value == DBNull.Value) { date = null; } else { date = Convert.ToDateTime(value); } return(string.Format("{0:M/d/yyyy}", date)); }
/// <summary> /// 获取所有车辆信息 /// </summary> /// <returns></returns> public static List <Vehicle> GetAllVehcleInfo() { try { string sql = "SELECT * FROM [dbo].[Vehicle];"; using (SqlConnection conn = sqlHelper.GetConnection()) { conn.Open(); SqlCommand cmd = new SqlCommand(sql, conn); SqlDataReader reader = cmd.ExecuteReader(); List <Vehicle> list = new List <Vehicle>(); while (reader.Read()) { System.Data.IDataRecord record = reader; list.Add(new Vehicle() { License = record.GetString(0), Type = record.GetString(1), Height = float.Parse(record[2].ToString()), Weight = float.Parse(record[3].ToString()), Load = float.Parse(record[4].ToString()) }); } return(list); } } catch (SqlException sqle) { throw sqle; } catch (Exception e) { throw e; } }