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