/// <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;
}
}
