/// <summary>
/// ��SqlDataReader�а�ȫ��ȡ����
/// </summary>
/// <param name="reader">���ݶ�ȡ��SqlDataReader</param>
/// <param name="colname">����</param>
/// <returns>���е��ַ������ݣ����Ϊ�գ���System.String.Empty</returns>
public static string ValidateDataReader_S(SqlDataReader reader,string colname)
{
if(reader.GetValue(reader.GetOrdinal(colname))!=DBNull.Value)
return reader.GetString(reader.GetOrdinal(colname));
else
return System.String.Empty;
}
public static int ValidateDataReader_N(SqlDataReader reader,string colname)
{
if(reader.GetValue(reader.GetOrdinal(colname))!=DBNull.Value)
return reader.GetInt32(reader.GetOrdinal(colname));
else
return System.Int32.MinValue;
}
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;
}
public void PopulateVolunteer(SqlDataReader _dtr, Volunteer obj)
{
int columnIndex = 0;
columnIndex = _dtr.GetOrdinal(VolunteerDataMapper.CN_ID);
if (!_dtr.IsDBNull(columnIndex))
{
obj.ID = _dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(VolunteerDataMapper.CN_NAME);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Name = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(VolunteerDataMapper.CN_EMAIL);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Email = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(VolunteerDataMapper.CN_CV);
if (!_dtr.IsDBNull(columnIndex))
{
obj.CV = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(VolunteerDataMapper.CN_MESSAGE);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Message = _dtr.GetString((columnIndex));
}
}
public override void Map(SqlDataReader sqlDataReader)
{
this.Id = sqlDataReader.GetGuid(sqlDataReader.GetOrdinal("Id"));
this.Name = sqlDataReader.GetString(sqlDataReader.GetOrdinal("Name"));
this.Level = sqlDataReader.GetByte(sqlDataReader.GetOrdinal("Level"));
this.CountryId = sqlDataReader.GetGuid(sqlDataReader.GetOrdinal("CountryId"));
}
public static Request Map(SqlDataReader record)
{
if (record == null) throw new ArgumentNullException("record");
var request = new Request();
request.Id = (int) record["Id"];
request.RequesTime = (DateTime) record["RequetTime"];
if (record["CreatorId"].ToString() != string.Empty)
{
request.CreatorId = (int) record["CreatorId"];
}
request.PhoneNumber = (string) record["PhoneNumber"];
request.Status = (int) record["Status"];
request.StartPoint = (string) record["StartPoint"];
request.FinishPoint = (string) record["FinishPoint"];
request.OperatorId = record.IsDBNull(record.GetOrdinal("OperatorId")) == false
? (int)record["OperatorId"]
: default(int?);
request.DriverId = record.IsDBNull(record.GetOrdinal("DriverId")) == false
? (int?) record["DriverId"]
: default(int?);
request.Price = record.IsDBNull(record.GetOrdinal("Price")) == false
? (decimal?)record["Price"]
: default(decimal?);
request.Additional = record.IsDBNull(record.GetOrdinal("Additional")) == false
? (string)record["Additional"]
: default(string);
return request;
}
public void PopulateOrdinals(SqlDataReader reader)
{
ord_CustomerID = reader.GetOrdinal("CustomerID");
ord_FirstName = reader.GetOrdinal("FirstName");
ord_LastName = reader.GetOrdinal("LastName");
ord_Age = reader.GetOrdinal("Age");
ord_EmailAddress = reader.GetOrdinal("EmailAddress");
}
private object DeserializeQueuedEvent(SqlDataReader result)
{
var eventTypeIdColumnId = result.GetOrdinal("EventTypeId");
var eventDataColumnId = result.GetOrdinal("EventData");
result.Read();
var eventTypeId = result.GetSqlGuid(eventTypeIdColumnId).Value;
return this.serializationMethod.Deserialize(new XmlSerializedData(eventTypeId, result.GetSqlXml(eventDataColumnId).CreateReader()));
}
public LoginDB(System.Data.SqlClient.SqlDataReader reader)
{
this.reader = reader;
this.ID = reader.GetInt64(reader.GetOrdinal("Id"));
this.Login = reader.GetString(reader.GetOrdinal("Login"));
this.Senha = reader.GetString(reader.GetOrdinal("Senha"));
}
public Tarjeta(SqlDataReader reader)
{
this.codTarjeta = reader.IsDBNull(reader.GetOrdinal("codTarjeta")) ? null : (string)reader["codTarjeta"];
this.fecEmision = reader.IsDBNull(reader.GetOrdinal("fechaEmi")) ? null : (string)reader["fechaEmi"].ToString();
this.fecAnulado = reader.IsDBNull(reader.GetOrdinal("fechaAnu")) ? null : (string)reader["fechaAnu"].ToString();
this.estado = reader.IsDBNull(reader.GetOrdinal("estado")) ? -1 : (int)reader["estado"];
this.cliente = new Cliente(reader);
}
public void PopulateCategory(SqlDataReader _dtr, Category obj)
{
int columnIndex = 0;
columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_ID);
if (!_dtr.IsDBNull(columnIndex))
{
obj.ID = _dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_NAME);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Name = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_DESCRIPTION);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Description = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_TYPE);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Type = (TG.ExpressCMS.DataLayer.Enums.RootEnums.CategoryType)_dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_ATTRIBUTES);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Attributes = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_ISDELETED);
if (!_dtr.IsDBNull(columnIndex))
{
obj.IsDeleted = _dtr.GetBoolean((columnIndex));
}
columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_XSL_ID);
if (!_dtr.IsDBNull(columnIndex))
{
obj.XslID = _dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_image);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Image = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_LANGUAGE_ID);
if (!_dtr.IsDBNull(columnIndex))
{
obj.LanguageID = _dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_HASH);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Hash = _dtr.GetString((columnIndex));
}
}
private static void InitIndex(SqlDataReader reader)
{
if (NameIndex == -1)
{
object_idIndex = reader.GetOrdinal("object_id");
NameIndex = reader.GetOrdinal("Name");
ownerIndex = reader.GetOrdinal("owner");
typeIndex = reader.GetOrdinal("type");
}
}
public object GetUnoSQlValue(SqlDataReader rdb, string str)
{
if (rdb.IsDBNull(rdb.GetOrdinal(str)))
{
return null;
}
else
{
return rdb[(rdb.GetOrdinal(str))];
}
}
public virtual void AddItemsToListBySqlDataReader(System.Data.SqlClient.SqlDataReader reader)
{
DotNetNancy.Rules.RuleSet.DataAccess.DTO.RuleStatistic dto;
using (reader)
{
while (reader.Read())
{
dto = new DotNetNancy.Rules.RuleSet.DataAccess.DTO.RuleStatistic();
dto.RuleName =
_baseDatabase.resolveNullString(reader.GetOrdinal("RuleName"), reader);
dto.ReferenceID =
_baseDatabase.retrieveGuidFromDataReader(reader.GetOrdinal("ReferenceID"), reader);
dto.Result =
_baseDatabase.resolveNullBoolean(reader.GetOrdinal("Result"), reader);
dto.RuleStatisticID =
_baseDatabase.retrieveGuidFromDataReader(reader.GetOrdinal("RuleStatisticID"), reader);
dto.ApplicationID =
_baseDatabase.retrieveGuidFromDataReader(reader.GetOrdinal("ApplicationID"), reader);
dto.TypeID =
_baseDatabase.retrieveGuidFromDataReader(reader.GetOrdinal("TypeID"), reader);
dto.RuleID =
_baseDatabase.retrieveGuidFromDataReader(reader.GetOrdinal("RuleID"), reader);
dto.DateInserted =
_baseDatabase.resolveNullDateTime(reader.GetOrdinal("DateInserted"), reader);
this.Add(dto);
}
}
}
private Notification CreateNotification(SqlDataReader reader)
{
return new Notification
{
ID = reader.GetGuid(reader.GetOrdinal("NotificationID")),
LanguageCode = GetString(reader, "LanguageCode"),
Subject = GetString(reader, "Subject"),
TypeKey = GetString(reader, "TypeKey"),
Dispatched = reader.GetBoolean(reader.GetOrdinal("Dispatched")),
Parameter = new JavaScriptSerializer().Deserialize<Dictionary<string, string>>(
GetString(reader, "Parameter")
)
};
}
public override UserOperationVO ReadRecord(System.Data.SqlClient.SqlDataReader reader)
{
UserOperationVO result = new UserOperationVO();
result.Id = reader.GetInt32(reader.GetOrdinal(idColumnName));
int userId = reader.GetInt32(reader.GetOrdinal(userOperationUserId));
int operationId = reader.GetInt32(reader.GetOrdinal(userOperationOperationId));
result.User = firstTableDAO.GetItem(userId);
result.Operation = secondTableDAO.GetItem(operationId);
firstTableDAO.CloseConnection();
secondTableDAO.CloseConnection();
return(result);
}
public IProject Resolve(IProject project, SqlDataReader reader)
{
project.ProjectId = Convert.ToInt32(reader["projectId"]);
project.Name = Convert.ToString(reader["name"]);
project.StatusId = Convert.ToInt32(reader["statusId"]);
if(!reader.IsDBNull(reader.GetOrdinal("PlannedEndDate"))) project.PlannedEndDate = Convert.ToDateTime(reader["PlannedEndDate"]);
if (!reader.IsDBNull(reader.GetOrdinal("ActualEndDate"))) project.ActualEndDate = Convert.ToDateTime(reader["ActualEndDate"]);
if (!reader.IsDBNull(reader.GetOrdinal("PlannedStartDate"))) project.PlannedStartDate = Convert.ToDateTime(reader["PlannedStartDate"]);
if (!reader.IsDBNull(reader.GetOrdinal("ActualStartDate"))) project.ActualEndDate = Convert.ToDateTime(reader["ActualStartDate"]);
project.CompanyId = Convert.ToInt32(reader["companyId"]);
return project;
}
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 virtual void AddItemsToListBySqlDataReader(System.Data.SqlClient.SqlDataReader reader)
{
CodeSampleApplication.Dto.Purpose dto;
using (reader)
{
while (reader.Read())
{
dto = new CodeSampleApplication.Dto.Purpose();
dto.PurposeDescription =
_baseDatabase.resolveNullString(reader.GetOrdinal("PurposeDescription"), reader);
dto.PurposeID =
_baseDatabase.resolveNullInt32(reader.GetOrdinal("PurposeID"), reader);
this.Add(dto);
}
}
}
public void FillEvent(SqlDataReader dr, string statementDate, int pageNumber, string title, iTextSharp.text.Image imgLogo)
{
if (statementDate != null && statementDate.Length > 0) {
_statementDate = statementDate;
} else {
_statementDate = "";
}
_groName = dr.GetString(dr.GetOrdinal("GrowerName"));
_groAdr1 = dr.GetString(dr.GetOrdinal("GroAdr1"));
_groAdr2 = dr.GetString(dr.GetOrdinal("GroAdr2"));
_groCSZ = dr.GetString(dr.GetOrdinal("GroCSZ"));
_pageNumber = pageNumber;
_title = title;
_imgLogo = imgLogo;
}
public virtual void AddItemsToListBySqlDataReader(System.Data.SqlClient.SqlDataReader reader)
{
TestSprocGenerator.Data.SingleTable.Dto.Person dto;
using (reader)
{
while (reader.Read())
{
dto = new TestSprocGenerator.Data.SingleTable.Dto.Person();
dto.PersonFirstName =
_baseDatabase.resolveNullString(reader.GetOrdinal("PersonFirstName"), reader);
dto.PersonLastName =
_baseDatabase.resolveNullString(reader.GetOrdinal("PersonLastName"), reader);
dto.PersonMiddleInitials =
_baseDatabase.resolveNullString(reader.GetOrdinal("PersonMiddleInitials"), reader);
dto.Deleted =
_baseDatabase.resolveNullBoolean(reader.GetOrdinal("Deleted"), reader);
dto.InsertedDateTime =
_baseDatabase.resolveNullDateTime(reader.GetOrdinal("InsertedDateTime"), reader);
dto.ModifiedDateTime =
_baseDatabase.resolveNullDateTime(reader.GetOrdinal("ModifiedDateTime"), reader);
dto.PersonID =
_baseDatabase.retrieveGuidFromDataReader(reader.GetOrdinal("PersonID"), reader);
this.Add(dto);
}
}
}
public virtual void AddItemsToListBySqlDataReader(System.Data.SqlClient.SqlDataReader reader)
{
TestSprocGenerator.Data.SingleTable.Dto.Account dto;
using (reader)
{
while (reader.Read())
{
dto = new TestSprocGenerator.Data.SingleTable.Dto.Account();
dto.AccountCode =
_baseDatabase.resolveNullString(reader.GetOrdinal("AccountCode"), reader);
dto.AccountUsername =
_baseDatabase.resolveNullString(reader.GetOrdinal("AccountUsername"), reader);
dto.AccountPassword =
_baseDatabase.resolveNullString(reader.GetOrdinal("AccountPassword"), reader);
dto.Deleted =
_baseDatabase.resolveNullBoolean(reader.GetOrdinal("Deleted"), reader);
dto.InsertedDateTime =
_baseDatabase.resolveNullDateTime(reader.GetOrdinal("InsertedDateTime"), reader);
dto.ModifiedDateTime =
_baseDatabase.resolveNullDateTime(reader.GetOrdinal("ModifiedDateTime"), reader);
dto.AccountID =
_baseDatabase.retrieveGuidFromDataReader(reader.GetOrdinal("AccountID"), reader);
this.Add(dto);
}
}
}
public virtual void MapToEntity(SqlDataReader sqlDataReader)
{
var properties = this.GetType().GetProperties();
foreach (var property in properties)
{
int index = sqlDataReader.GetOrdinal(property.Name);
property.SetValue(this, sqlDataReader.GetValue(index));
}
}
private EventStream DeserializeEvents(Guid id, SqlDataReader result)
{
var lastVersion = 0;
var snapshotVersion = 0;
var eventTypeIdColumnId = result.GetOrdinal("EventTypeId");
var eventDataColumnId = result.GetOrdinal("EventData");
var versionColumnId = result.GetOrdinal("Version");
var snapshotVersionColumnId = result.GetOrdinal("SnapshotVersion");
var events = new List<object>();
while (result.Read())
{
var eventTypeId = result.GetSqlGuid(eventTypeIdColumnId).Value;
lastVersion = result.GetSqlInt32(versionColumnId).Value;
snapshotVersion = result.GetSqlInt32(snapshotVersionColumnId).Value;
events.Add(this.serializationMethod.Deserialize(new XmlSerializedData(eventTypeId, result.GetSqlXml(eventDataColumnId).CreateReader())));
}
return new EventStream(id, lastVersion, snapshotVersion, events);
}
private List<Subscription> ParseSubscription(SqlDataReader sqlDataReader)
{
List<Subscription> subList = new List<Subscription>();
int iSubscription_id = sqlDataReader.GetOrdinal("Subscription_id");
int iDomainUserName = sqlDataReader.GetOrdinal("DomainUserName");
int iReportPath = sqlDataReader.GetOrdinal("ReportPath");
int iReportArgs = sqlDataReader.GetOrdinal("ReportArgs");
while (sqlDataReader.Read())
{
Subscription sub = new Subscription()
{
Subscription_id = int.Parse(sqlDataReader[iSubscription_id].ToString()),
DomainUserName = sqlDataReader[iDomainUserName].ToString(),
ReportPath = sqlDataReader[iReportPath].ToString(),
ReportArgs = sqlDataReader[iReportArgs].ToString()
};
subList.Add(sub);
}
sqlDataReader.Close();
return subList;
}
public override IModel CreateModel(SqlDataReader dr)
{
StockLogAttach stocklogattach = new StockLogAttach();
int indexStockLogAttachId = dr.GetOrdinal("StockLogAttachId");
stocklogattach.StockLogAttachId = Convert.ToInt32(dr[indexStockLogAttachId]);
int indexStockLogId = dr.GetOrdinal("StockLogId");
if (dr["StockLogId"] != DBNull.Value)
{
stocklogattach.StockLogId = Convert.ToInt32(dr[indexStockLogId]);
}
int indexAttachId = dr.GetOrdinal("AttachId");
if (dr["AttachId"] != DBNull.Value)
{
stocklogattach.AttachId = Convert.ToInt32(dr[indexAttachId]);
}
return stocklogattach;
}
private bool GetDBBool(SqlDataReader reader, string columnName)
{
try
{
int ordinal = reader.GetOrdinal(columnName);
return reader.IsDBNull(ordinal) ? false : reader.GetBoolean(ordinal);
}
catch (IndexOutOfRangeException)
{
return false;
}
}
private DateTime GetDBDate(SqlDataReader reader, string columnName)
{
try
{
int ordinal = reader.GetOrdinal(columnName);
return reader.IsDBNull(ordinal) ? DateTime.MinValue : reader.GetDateTime(ordinal);
}
catch (IndexOutOfRangeException)
{
return DateTime.MinValue;
}
}
internal JamTeamData ReadData(SqlDataReader reader)
{
JamTeamData jamFoul = new JamTeamData();
jamFoul.JamID = reader.GetInt32(reader.GetOrdinal("JamID"));
jamFoul.TeamID = reader.GetInt32(reader.GetOrdinal("TeamID"));
jamFoul.BlockerBoxTime = reader.GetInt32(reader.GetOrdinal("BlockerBoxTime"));
jamFoul.JammerBoxTime = reader.GetInt32(reader.GetOrdinal("JammerBoxTime"));
jamFoul.OppBlockerBoxTime = reader.GetInt32(reader.GetOrdinal("OppBlockerBoxTime"));
jamFoul.OppJammerBoxTime = reader.GetInt32(reader.GetOrdinal("OppJammerBoxTime"));
jamFoul.PointDelta = reader.GetInt32(reader.GetOrdinal("PointDelta"));
return jamFoul;
}
private static IEnumerable<Account> ReadData(SqlDataReader rdr)
{
var lst = new List<Account>();
int ordAccountNo = rdr.GetOrdinal("AccountNo");
int ordCompany = rdr.GetOrdinal("Company");
int ordContact = rdr.GetOrdinal("Contact");
int ordContracted = rdr.GetOrdinal("Contracted");
int ordPurchased = rdr.GetOrdinal("Purchased");
if (rdr.HasRows)
{
while (rdr.Read())
{
lst.Add(
new Account
{
AccountNo = ((string)
ParameterUtils.SafeGetValue(rdr.GetValue(ordAccountNo), typeof (string),
Constants.InitializeString)),
Company = ((string)
ParameterUtils.SafeGetValue(rdr.GetValue(ordCompany), typeof (string),
Constants.InitializeString)),
Contact = ((string)
ParameterUtils.SafeGetValue(rdr.GetValue(ordContact), typeof (string),
Constants.InitializeString)),
Contracted = ((int)
ParameterUtils.SafeGetValue(rdr.GetValue(ordContracted), typeof (int),
Constants.InitializeInt)),
Purchased = ((int)
ParameterUtils.SafeGetValue(rdr.GetValue(ordPurchased), typeof (int),
Constants.InitializeInt))
});
}
}
return lst;
}
internal static LanguageURL GetLanguageURL(List<LanguageURL> LanguageURLs, SqlDataReader reader)
{
int colIndex = 0;
colIndex = reader.GetOrdinal(CN_LANGUAGE_URL_ID);
int value = reader.GetInt32(colIndex);
LanguageURL LanguageURL = LanguageURLs.Where(c => c.ID == value).FirstOrDefault();
if (LanguageURL == null)
{
LanguageURL = new LanguageURL();
LanguageURLs.Add(LanguageURL);
}
return LanguageURL;
}
public virtual void Map(SqlDataReader rdr)
{
var properties = this.GetType().GetProperties();
foreach (var property in properties)
{
int index = rdr.GetOrdinal(property.Name);
if (rdr.IsDBNull(index))
{
property.SetValue(this, null);
continue;
}
property.SetValue(this, rdr.GetValue(index));
}
}
public static void PopulateObjectFromReader(SqlDataReader reader, Account acc)
{
acc.AccountNumber = (int)reader["AccountNumber"];
acc.Type = (char)reader.GetString(reader.GetOrdinal("AccountType"))[0];
acc.AvailableBalance = (decimal)reader["AvailableBalance"];
acc.CustomerId = (int)reader["CustomerId"];
try
{
acc.LastUpdatedDate = Convert.ToDateTime(reader["LastUpdatedDate"]);
}
catch (Exception)
{
acc.LastUpdatedDate = null;
}
}
public static User Map(SqlDataReader record)
{
var user = new User
{
Id = (int)record["Id"],
UserName = (string)record["Name"],
LastName = (string)record["LastName"],
Login = (string)record["Login"],
PhoneNumber = (string)record["PhoneNumber"],
Email = (string)record["Email"],
Password = (string)record["Password"],
Role = (int)record["Role"],
Status = (int)record["Status"],
DriverStatus = record.IsDBNull(record.GetOrdinal("DriverStatus")) == false
? (int?)record["DriverStatus"]
: default(int?)
};
return user;
}
//初始化类型信息下拉列表
public void initComb()
{
try
{
cmdText = "select typename from Type";
cmd = new SqlCommand(cmdText, sc.getConn());
reader = cmd.ExecuteReader();
while (reader.Read())
{
combType.Items.Add(reader.GetString(reader.GetOrdinal("typename")));
}
reader.Dispose();
reader.Close();
cmd.Dispose();
}
catch (Exception ex)
{
MessageBox.Show("初始化类型信息错误：" + ex.Message);
}
}
