/// <summary> /// 通过数据读取器生成实体类 /// </summary> /// <param name="rdr"></param> /// <returns></returns> private static StatMozillaEntity GetEntityFromrdr(NullableDataReader rdr) { StatMozillaEntity info = new StatMozillaEntity(); info.TMozilla = rdr.GetString("TMozilla"); info.TMozNum = rdr.GetInt32("TMozNum"); return(info); }
private static DeliverItemInfo DeliverItemFromrdr(NullableDataReader rdr) { DeliverItemInfo info = new DeliverItemInfo(); info.DeliverId = rdr.GetInt32("DeliverID"); info.OrderId = rdr.GetInt32("OrderID"); info.DeliverDate = rdr.GetDateTime("DeliverDate"); info.DeliverDirection = rdr.GetInt32("DeliverDirection"); info.HandlerName = rdr.GetString("HandlerName"); info.CourierId = rdr.GetInt32("CourierId"); info.ExpressNumber = rdr.GetString("ExpressNumber"); info.Inputer = rdr.GetString("Inputer"); info.Remark = rdr.GetString("Remark"); info.Received = rdr.GetBoolean("Received"); info.Memo = rdr.GetString("Memo"); return(info); }
/// <summary> /// 通过数据读取器生成实体类 /// </summary> /// <param name="rdr"></param> /// <returns></returns> private static SubscriptionItemsEntity GetEntityFromrdr(NullableDataReader rdr) { SubscriptionItemsEntity info = new SubscriptionItemsEntity(); info.Id = rdr.GetInt32("Id"); info.Name = rdr.GetString("Name"); return(info); }
/// <summary> /// 通过数据读取器生成实体类 /// </summary> /// <param name="rdr"></param> /// <returns></returns> private static StockOutEntity GetEntityFromrdr(NullableDataReader rdr) { StockOutEntity info = new StockOutEntity(); info.ID = rdr.GetInt32("ID"); info.Email = rdr.GetString("Email"); info.UserId = rdr.GetInt32("UserId"); info.Mobile = rdr.GetString("Mobile"); info.ProductId = rdr.GetInt32("ProductId"); info.OrderNum = rdr.GetInt32("OrderNum"); info.InputTime = rdr.GetNullableDateTime("InputTime"); info.IP = rdr.GetString("IP"); info.EmailStatus = rdr.GetInt32("EmailStatus"); info.MobileStatus = rdr.GetInt32("MobileStatus"); info.Property = rdr.GetString("Property"); return(info); }
/// <summary> /// 通过数据读取器生成实体类 /// </summary> /// <param name="rdr"></param> /// <returns></returns> private static MentionLogEntity GetEntityFromrdr(NullableDataReader rdr) { MentionLogEntity info = new MentionLogEntity(); info.ID = rdr.GetInt32("ID"); info.Applicant = rdr.GetString("Applicant"); info.ApplicationTime = rdr.GetNullableDateTime("ApplicationTime"); info.ApplicationAmount = rdr.GetDecimal("ApplicationAmount"); info.HandlingCharge = rdr.GetDecimal("HandlingCharge"); info.BankAccount = rdr.GetString("BankAccount"); info.MentionStatus = rdr.GetInt32("MentionStatus"); info.Operator = rdr.GetString("Operator"); info.OperatingTime = rdr.GetNullableDateTime("OperatingTime"); info.Remark = rdr.GetString("Remark"); info.LogTime = rdr.GetNullableDateTime("LogTime"); return(info); }
/// <summary> /// 通过数据读取器生成实体类 /// </summary> /// <param name="rdr"></param> /// <returns></returns> private static StatBrowserEntity GetEntityFromrdr(NullableDataReader rdr) { StatBrowserEntity info = new StatBrowserEntity(); info.TBrowser = rdr.GetString("TBrowser"); info.TBrwNum = rdr.GetInt32("TBrwNum"); return(info); }
/// <summary> /// 通过数据读取器生成实体类 /// </summary> /// <param name="rdr"></param> /// <returns></returns> private static MailListEntity GetEntityFromrdr(NullableDataReader rdr) { MailListEntity info = new MailListEntity(); info.ID = rdr.GetInt32("ID"); info.Email = rdr.GetString("Email"); return(info); }
/// <summary> /// 通过数据读取器生成实体类 /// </summary> /// <param name="rdr"></param> /// <returns></returns> private static StatKeywordEntity GetEntityFromrdr(NullableDataReader rdr) { StatKeywordEntity info = new StatKeywordEntity(); info.TKeyword = rdr.GetString("TKeyword"); info.TKeywordNum = rdr.GetInt32("TKeywordNum"); return(info); }
/// <summary> /// 通过数据读取器生成实体类 /// </summary> /// <param name="rdr"></param> /// <returns></returns> private static StatTimezoneEntity GetEntityFromrdr(NullableDataReader rdr) { StatTimezoneEntity info = new StatTimezoneEntity(); info.TTimezone = rdr.GetString("TTimezone"); info.TTimNum = rdr.GetInt32("TTimNum"); return(info); }
/// <summary> /// 通过数据读取器生成实体类 /// </summary> /// <param name="rdr"></param> /// <returns></returns> private static StatScreenEntity GetEntityFromrdr(NullableDataReader rdr) { StatScreenEntity info = new StatScreenEntity(); info.TScreen = rdr.GetString("TScreen"); info.TScrNum = rdr.GetInt32("TScrNum"); return(info); }
/// <summary> /// 通过数据读取器生成实体类 /// </summary> /// <param name="rdr"></param> /// <returns></returns> private static RolesPermissionsEntity GetEntityFromrdr(NullableDataReader rdr) { RolesPermissionsEntity info = new RolesPermissionsEntity(); info.RoleID = rdr.GetInt32("RoleID"); info.OperateCode = rdr.GetString("OperateCode"); return(info); }
public IList<SourceInfo> GetSourceTypeList() { string strSql = "SELECT Type FROM PE_Source GROUP BY Type"; IList<SourceInfo> list = new List<SourceInfo>(); using (NullableDataReader reader = DBHelper.ExecuteReaderSql(strSql)) { while (reader.Read()) { if (!string.IsNullOrEmpty(reader.GetString(0))) { SourceInfo item = new SourceInfo(reader.GetString(0)); list.Add(item); } } } return list; }
/// <summary> /// 通过数据读取器生成实体类 /// </summary> /// <param name="rdr"></param> /// <returns></returns> private static ComplaintsEntity GetEntityFromrdr(NullableDataReader rdr) { ComplaintsEntity info = new ComplaintsEntity(); info.CID = rdr.GetInt32("CID"); info.CNO = rdr.GetString("CNO"); info.CName = rdr.GetString("CName"); info.CType = rdr.GetInt32("CType"); info.CDType = rdr.GetInt32("CDType"); info.CContent = rdr.GetString("CContent"); info.CContact = rdr.GetString("CContact"); info.CTime = rdr.GetNullableDateTime("CTime"); info.CIP = rdr.GetString("CIP"); info.CState = rdr.GetInt32("CState"); info.CAdminID = rdr.GetInt32("CAdminID"); return(info); }
/// <summary> /// 通过数据读取器生成实体类 /// </summary> /// <param name="rdr"></param> /// <returns></returns> private static U_AwardLogEntity GetEntityFromrdr(NullableDataReader rdr) { U_AwardLogEntity info = new U_AwardLogEntity(); info.ID = rdr.GetInt32("ID"); info.GuestName = rdr.GetString("GuestName"); return(info); }
private static AdministratorInfo GetAdminInfoFromrdr(NullableDataReader rdr) { AdministratorInfo info = new AdministratorInfo(); info.AdminId = rdr.GetInt32("AdminId"); info.AdminName = rdr.GetString("AdminName"); info.AdminPassword = rdr.GetString("AdminPassword"); info.UserName = rdr.GetString("UserName"); info.EnableMultiLogOn = rdr.GetBoolean("EnableMultilogin"); info.RndPassword = rdr.GetString("RndPassword"); info.LogOnTimes = rdr.GetInt32("LoginTimes"); info.LastLogOnIP = rdr.GetString("LastLoginIp"); info.LastLogOnTime = rdr.GetNullableDateTime("LastLoginTime"); info.LastLogOffTime = rdr.GetNullableDateTime("LastLogoutTime"); info.LastModifyPasswordTime = rdr.GetNullableDateTime("LastModifyPasswordTime"); return(info); }
/// <summary> /// 通过数据读取器生成实体类 /// </summary> /// <param name="rdr"></param> /// <returns></returns> private static StatColorEntity GetEntityFromrdr(NullableDataReader rdr) { StatColorEntity info = new StatColorEntity(); info.TColor = rdr.GetString("TColor"); info.TColNum = rdr.GetInt32("TColNum"); return(info); }
/// <summary> /// 通过数据读取器生成实体类 /// </summary> /// <param name="rdr"></param> /// <returns></returns> private static StatWeburlEntity GetEntityFromrdr(NullableDataReader rdr) { StatWeburlEntity info = new StatWeburlEntity(); info.TWeburl = rdr.GetString("TWeburl"); info.TWebNum = rdr.GetInt32("TWebNum"); return(info); }
/// <summary> /// 通过数据读取器生成实体类 /// </summary> /// <param name="rdr"></param> /// <returns></returns> private static StatAddressEntity GetEntityFromrdr(NullableDataReader rdr) { StatAddressEntity info = new StatAddressEntity(); info.TAddress = rdr.GetString("TAddress"); info.TAddNum = rdr.GetInt32("TAddNum"); return(info); }
private static SaleCountInfo SaleCountInfoFromrdataReader(NullableDataReader dataReader, string infoType) { SaleCountInfo info = new SaleCountInfo(); info.ProductId = dataReader.GetInt32("ProductID"); info.ProductName = dataReader.GetString("ProductName"); info.Unit = dataReader.GetString("Unit"); info.TableName = dataReader.GetString("TableName"); if (infoType == "NoDeliver") { info.NoDeliverAmount = dataReader.GetInt32("NoDeliverAmount"); return(info); } info.TotalAmount = dataReader.GetInt32("tAmount"); info.SubTotal = dataReader.GetDecimal("tSubTotal"); return(info); }
/// <summary> /// 通过数据读取器生成实体类 /// </summary> /// <param name="rdr"></param> /// <returns></returns> private static StatIpEntity GetEntityFromrdr(NullableDataReader rdr) { StatIpEntity info = new StatIpEntity(); info.TIp = rdr.GetString("TIp"); info.TIpNum = rdr.GetInt32("TIpNum"); return(info); }
/// <summary> /// 通过数据读取器生成实体类 /// </summary> /// <param name="rdr"></param> /// <returns></returns> private static U_AwardEntity GetEntityFromrdr(NullableDataReader rdr) { U_AwardEntity info = new U_AwardEntity(); info.ID = rdr.GetInt32("ID"); info.Weight = rdr.GetDouble("Weight"); info.Number = rdr.GetString("Number"); return(info); }
/// <summary> /// 通过数据读取器生成实体类 /// </summary> /// <param name="rdr"></param> /// <returns></returns> private static ComplaintsTypeEntity GetEntityFromrdr(NullableDataReader rdr) { ComplaintsTypeEntity info = new ComplaintsTypeEntity(); info.CID = rdr.GetInt32("CID"); info.CDType = rdr.GetInt32("CDType"); info.CName = rdr.GetString("CName"); return(info); }
public AdminProfileInfo GetAdminProfile(string adminName) { AdminProfileInfo info = null; Parameters cmdParams = new Parameters(); cmdParams.AddInParameter("@AdminName", DbType.String, adminName); using (NullableDataReader reader = DBHelper.ExecuteReaderSql("SELECT * FROM PE_AdminProfile WHERE AdminName = @AdminName", cmdParams)) { if (reader.Read()) { info = this.adminProfileSer.DeserializeField(reader.GetString("PersonalSetting")); info.AdminName = reader.GetString("AdminName"); info.WebPartSetting = reader.GetString("WebPartSetting"); return(info); } return(new AdminProfileInfo(true)); } }
/// <summary> /// 通过数据读取器生成实体类 /// </summary> /// <param name="rdr"></param> /// <returns></returns> private static ContentPermissionEntity GetEntityFromrdr(NullableDataReader rdr) { ContentPermissionEntity info = new ContentPermissionEntity(); info.GeneralID = rdr.GetInt32("GeneralID"); info.PermissionType = rdr.GetInt32("PermissionType"); info.ArrGroupID = rdr.GetString("arrGroupID"); return(info); }
/// <summary> /// 通过数据读取器生成实体类 /// </summary> /// <param name="rdr"></param> /// <returns></returns> private static RemindItemEntity GetEntityFromrdr(NullableDataReader rdr) { RemindItemEntity info = new RemindItemEntity(); info.RemindID = rdr.GetInt32("RemindID"); info.Creater = rdr.GetString("Creater"); info.CreateTime = rdr.GetNullableDateTime("CreateTime"); info.RemindTime = rdr.GetNullableDateTime("RemindTime"); info.RelationType = rdr.GetString("RelationType"); info.RemindContent = rdr.GetString("RemindContent"); info.CorrelativeClient = rdr.GetInt32("CorrelativeClient"); info.CorrelativeContacter = rdr.GetString("CorrelativeContacter"); info.IsRemindByTips = rdr.GetBoolean("IsRemindByTips"); info.IsRemindByEmail = rdr.GetBoolean("IsRemindByEmail"); info.IsRemindBySms = rdr.GetBoolean("IsRemindBySms"); info.IsFinish = rdr.GetBoolean("IsFinish"); return(info); }
/// <summary> /// 通过数据读取器生成实体类 /// </summary> /// <param name="rdr"></param> /// <returns></returns> private static AdZoneEntity GetEntityFromrdr(NullableDataReader rdr) { AdZoneEntity info = new AdZoneEntity(); info.ZoneID = rdr.GetInt32("ZoneID"); info.ZoneName = rdr.GetString("ZoneName"); info.ZoneJSName = rdr.GetString("ZoneJSName"); info.ZoneIntro = rdr.GetString("ZoneIntro"); info.ZoneType = rdr.GetInt32("ZoneType"); info.IsDefaultSetting = rdr.GetBoolean("IsDefaultSetting"); info.ZoneSetting = rdr.GetString("ZoneSetting"); info.ZoneWidth = rdr.GetInt32("ZoneWidth"); info.ZoneHeight = rdr.GetInt32("ZoneHeight"); info.IsActive = rdr.GetBoolean("IsActive"); info.ShowType = rdr.GetInt32("ShowType"); info.UpdateTime = rdr.GetNullableDateTime("UpdateTime"); return(info); }
private static void DeliverChargeInfoFromrdr(DeliverChargeInfo deliverChargeInfo, NullableDataReader rdr) { deliverChargeInfo.ChargeMin = rdr.GetDecimal("Charge_Min"); deliverChargeInfo.WeightMin = rdr.GetDouble("Weight_Min"); deliverChargeInfo.ChargePerUnit = rdr.GetDecimal("ChargePerUnit"); deliverChargeInfo.WeightPerUnit = rdr.GetDouble("WeightPerUnit"); deliverChargeInfo.ChargeMax = rdr.GetDecimal("Charge_Max"); deliverChargeInfo.ArrArea = rdr.GetString("arrArea"); }
private static UserOrderCommonInfo GetUserOrderCommonInfo(NullableDataReader rdr) { UserOrderCommonInfo info = new UserOrderCommonInfo(); info.ProductId = rdr.GetInt32("ProductId"); info.TableName = rdr.GetString("TableName"); info.ProductName = rdr.GetString("ProductName"); info.Unit = rdr.GetString("Unit"); info.Amount = rdr.GetInt32("Amount"); info.BeginDate = rdr.GetDateTime("BeginDate"); info.Price = rdr.GetDecimal("Price"); info.TruePrice = rdr.GetDecimal("TruePrice"); info.ServiceTerm = rdr.GetInt32("ServiceTerm"); info.Remark = rdr.GetString("Remark"); info.ServiceTermUnit = (ServiceTermUnit)rdr.GetInt32("ServiceTermUnit"); info.OrderItemId = rdr.GetInt32("ItemId"); return(info); }
private static StatIPInfo StatIPInfoListFromrdr(NullableDataReader rdr) { StatIPInfo info = new StatIPInfo(); info.StartIP = rdr.GetDouble("StartIp"); info.EndIP = rdr.GetDouble("EndIp"); info.Address = rdr.GetString("Address"); return(info); }
private static ContentPermissionInfo ContentPermissionFromDataReader(NullableDataReader dr) { ContentPermissionInfo info = new ContentPermissionInfo(); info.GeneralId = dr.GetInt32("GeneralId"); info.PermissionType = dr.GetInt32("PermissionType"); info.ArrGroupId = dr.GetString("ArrGroupId"); return(info); }