private static ClientInfo ClientFromrdr(NullableDataReader rdr) { ClientInfo info = new ClientInfo(); info.ClientId = rdr.GetInt32("ClientID"); info.ParentId = rdr.GetInt32("ParentID"); info.ClientNum = rdr.GetString("ClientNum"); info.ClientType = rdr.GetInt32("ClientType"); info.ClientName = rdr.GetString("ClientName"); info.ShortedForm = rdr.GetString("ShortedForm"); info.Area = rdr.GetInt32("Area"); info.ClientField = rdr.GetInt32("ClientField"); info.ValueLevel = rdr.GetInt32("ValueLevel"); info.CreditLevel = rdr.GetInt32("CreditLevel"); info.Importance = rdr.GetInt32("Importance"); info.ConnectionLevel = rdr.GetInt32("ConnectionLevel"); info.GroupId = rdr.GetInt32("GroupID"); info.SourceType = rdr.GetInt32("SourceType"); info.PhaseType = rdr.GetInt32("PhaseType"); info.Remark = rdr.GetString("Remark"); info.VisitTimes = rdr.GetInt32("VisitTimes"); info.ServiceTimes = rdr.GetInt32("ServiceTimes"); info.ComplainTimes = rdr.GetInt32("ComplainTimes"); info.LastVisitTime = rdr.GetDateTime("LastVisitTime"); info.LastServiceTime = rdr.GetDateTime("LastServiceTime"); info.LastComplainTime = rdr.GetDateTime("LastComplainTime"); info.CreateTime = rdr.GetDateTime("CreateTime"); info.UpdateTime = rdr.GetDateTime("UpdateTime"); info.Owner = rdr.GetString("Owner"); info.Balance = rdr.GetDecimal("Balance"); return(info); }
private static QuestionInfo GetInfoByReader(NullableDataReader rdr, bool getAll) { QuestionInfo info = new QuestionInfo(); info.Id = rdr.GetInt32("ID"); info.TypeId = rdr.GetInt32("TypeID"); info.TypeName = rdr.GetString("TypeName"); info.QuestionTitle = rdr.GetString("QuestionTitle"); info.QuestionCreateTime = rdr.GetDateTime("QuestionCreateTime"); info.QuestionCreator = rdr.GetString("QuestionCreator"); info.ReplyCreator = rdr.GetString("ReplyCreator"); info.ReplyTime = rdr.GetNullableDateTime("ReplyTime"); info.Score = rdr.GetInt32("Score"); info.IsPublic = rdr.GetBoolean("IsPublic"); info.IsReply = rdr.GetBoolean("IsReply"); info.IsSolved = rdr.GetBoolean("IsSolved"); if (getAll) { info.AntiVirus = rdr.GetString("AntiVirus"); info.ErrorCode = rdr.GetString("ErrorCode"); info.ErrorText = rdr.GetString("ErrorText"); info.FireWall = rdr.GetString("FireWall"); info.IP = rdr.GetString("IP"); info.ProductDBType = rdr.GetString("ProductDBType"); info.ProductVersion = rdr.GetString("ProductVersion"); info.QuestionContent = rdr.GetString("QuestionContent"); info.SystemType = rdr.GetString("SystemType"); info.Url = rdr.GetString("Url"); info.LastUpdateTime = rdr.GetDateTime("LastUpdateTime"); } return(info); }
private static CommentInfo CommentInfoCommonFromDataReader(NullableDataReader dr) { CommentInfo info = new CommentInfo(); info.CommentId = dr.GetInt32("CommentId"); info.Agree = dr.GetInt32("Agree"); info.CommentTitle = dr.GetString("CommentTitle"); info.Content = dr.GetString("Content"); info.GeneralId = dr.GetInt32("GeneralId"); info.IP = dr.GetString("IP"); info.IsElite = dr.GetBoolean("IsElite"); info.IsPrivate = dr.GetBoolean("IsPrivate"); info.Neutral = dr.GetInt32("Neutral"); info.Oppose = dr.GetInt32("Oppose"); info.Position = dr.GetInt32("Position"); info.Reply = dr.GetString("Reply"); info.ReplyAdmin = dr.GetString("ReplyAdmin"); info.ReplyDateTime = dr.GetDateTime("ReplyDateTime"); info.ReplyIsPrivate = dr.GetBoolean("ReplyIsPrivate"); info.Status = dr.GetBoolean("Status"); info.TopicId = dr.GetInt32("TopicId"); info.UpdateDateTime = dr.GetDateTime("UpdateDateTime"); info.UserName = dr.GetString("UserName"); info.NodeId = dr.GetInt32("NodeId"); info.Score = dr.GetInt32("Score"); info.Face = dr.GetString("Face"); info.ReplyUserName = dr.GetString("ReplyUserName"); return(info); }
private static AuthorInfo AuthorFromrdr(NullableDataReader rdr) { AuthorInfo info = new AuthorInfo(); info.Id = rdr.GetInt32("ID"); info.UserId = rdr.GetInt32("UserID"); info.Type = rdr.GetString("Type"); info.Name = rdr.GetString("Name"); info.Passed = rdr.GetBoolean("Passed"); info.OnTop = rdr.GetBoolean("onTop"); info.Elite = rdr.GetBoolean("IsElite"); info.Hits = rdr.GetInt32("Hits"); info.LastUseTime = rdr.GetDateTime("LastUseTime"); info.TemplateId = rdr.GetInt32("TemplateID"); info.Photo = rdr.GetString("Photo"); info.Intro = rdr.GetString("Intro"); info.Address = rdr.GetString("Address"); info.Tel = rdr.GetString("Tel"); info.Fax = rdr.GetString("Fax"); info.Mail = rdr.GetString("Mail"); info.Email = rdr.GetString("Email"); info.ZipCode = rdr.GetInt32("ZipCode"); info.HomePage = rdr.GetString("HomePage"); info.Imeeting = rdr.GetString("Im"); info.Sex = rdr.GetInt16("Sex"); info.BirthDay = rdr.GetDateTime("BirthDay"); info.Company = rdr.GetString("Company"); info.Department = rdr.GetString("Department"); return(info); }
private static ContacterInfo ContacterFromrdr(NullableDataReader rdr, int flag) { ContacterInfo info = new ContacterInfo(); info.ContacterId = rdr.GetInt32("ContacterID"); info.ClientId = rdr.GetInt32("ClientID"); info.UserName = rdr.GetString("UserName"); info.ParentId = rdr.GetInt32("ParentID"); info.UserType = (ContacterType)rdr.GetInt32("UserType"); info.TrueName = rdr.GetString("TrueName"); info.Sex = (UserSexType)rdr.GetInt32("Sex"); info.Title = rdr.GetString("Title"); info.Company = rdr.GetString("Company"); info.Department = rdr.GetString("Department"); info.Position = rdr.GetString("Position"); info.Operation = rdr.GetString("Operation"); info.CompanyAddress = rdr.GetString("CompanyAddress"); info.Email = rdr.GetString("Email"); info.Homepage = rdr.GetString("Homepage"); info.QQ = rdr.GetString("QQ"); info.Icq = rdr.GetString("ICQ"); info.Msn = rdr.GetString("MSN"); info.Yahoo = rdr.GetString("Yahoo"); info.UC = rdr.GetString("UC"); info.Aim = rdr.GetString("Aim"); info.OfficePhone = rdr.GetString("OfficePhone"); info.HomePhone = rdr.GetString("HomePhone"); info.Phs = rdr.GetString("PHS"); info.Fax = rdr.GetString("Fax"); info.Mobile = rdr.GetString("Mobile"); info.Country = rdr.GetString("Country"); info.Province = rdr.GetString("Province"); info.City = rdr.GetString("City"); info.Address = rdr.GetString("Address"); info.ZipCode = rdr.GetString("ZipCode"); info.NativePlace = rdr.GetString("NativePlace"); info.Nation = rdr.GetString("Nation"); info.Birthday = rdr.GetNullableDateTime("Birthday"); info.IdCard = rdr.GetString("IDCard"); info.Marriage = (UserMarriageType)rdr.GetInt32("Marriage"); info.Family = rdr.GetString("Family"); info.Income = rdr.GetInt32("Income"); info.Education = rdr.GetInt32("Education"); info.GraduateFrom = rdr.GetString("GraduateFrom"); info.InterestsOfLife = rdr.GetString("InterestsOfLife"); info.InterestsOfCulture = rdr.GetString("InterestsOfCulture"); info.InterestsOfAmusement = rdr.GetString("InterestsOfAmusement"); info.InterestsOfSport = rdr.GetString("InterestsOfSport"); info.InterestsOfOther = rdr.GetString("InterestsOfOther"); info.CreateTime = rdr.GetDateTime("CreateTime"); info.UpdateTime = rdr.GetDateTime("UpdateTime"); info.Owner = rdr.GetString("Owner"); if (flag == 1) { info.ShortedForm = rdr.GetString("ShortedForm"); } return(info); }
private static UserInfo UsersFromrdr(NullableDataReader rdr) { UserInfo info = new UserInfo(); info.UserId = rdr.GetInt32("UserID"); info.GroupId = rdr.GetInt32("GroupID"); info.CompanyId = rdr.GetInt32("CompanyID"); info.ClientId = rdr.GetInt32("ClientID"); info.UserType = (UserType)rdr.GetInt32("UserType"); info.UserName = rdr.GetString("UserName"); info.UserPassword = rdr.GetString("UserPassword"); info.LastPassword = rdr.GetString("LastPassword"); info.PayPassword = rdr.GetString("PayPassword"); info.Question = rdr.GetString("Question"); info.Answer = rdr.GetString("Answer"); info.Email = rdr.GetString("Email"); info.Sex = (UserSexType)rdr.GetInt32("Sex"); info.RegTime = rdr.GetDateTime("RegTime"); info.JoinTime = rdr.GetDateTime("JoinTime"); info.LogOnTimes = rdr.GetInt32("LoginTimes"); info.LastLogOnTime = rdr.GetNullableDateTime("LastLoginTime"); info.LastPresentTime = rdr.GetNullableDateTime("LastPresentTime"); info.LastLogOnIP = rdr.GetString("LastLoginIP"); info.LastPasswordChangedTime = rdr.GetNullableDateTime("LastPasswordChangedTime"); info.LastLockoutTime = rdr.GetNullableDateTime("LastLockoutTime"); info.FailedPasswordAttemptCount = rdr.GetInt32("FailedPasswordAttemptCount"); info.FirstFailedPasswordAttempTime = rdr.GetNullableDateTime("FirstFailedPasswordAttempTime"); info.FailedPasswordAnswerAttempCount = rdr.GetInt32("FailedPasswordAnswerAttempCount"); info.FirstFailedPasswordAnswerAttempTime = rdr.GetNullableDateTime("FirstFailedPasswordAnswerAttempTime"); info.Status = (UserStatus)rdr.GetInt32("Status"); info.CheckNum = rdr.GetString("CheckNum"); info.EnableResetPassword = rdr.GetBoolean("EnableResetPassword"); info.UserFace = rdr.GetString("UserFace"); info.FaceWidth = rdr.GetInt32("FaceWidth"); info.FaceHeight = rdr.GetInt32("FaceHeight"); info.Sign = rdr.GetString("Sign"); info.PrivacySetting = rdr.GetInt32("PrivacySetting"); info.Balance = rdr.GetDecimal("Balance"); info.UserPoint = rdr.GetInt32("UserPoint"); info.UserExp = rdr.GetInt32("UserExp"); info.ConsumeMoney = rdr.GetInt32("ConsumeMoney"); info.ConsumePoint = rdr.GetInt32("ConsumePoint"); info.ConsumeExp = rdr.GetInt32("ConsumeExp"); info.PostItems = rdr.GetInt32("PostItems"); info.PassedItems = rdr.GetInt32("PassedItems"); info.RejectItems = rdr.GetInt32("RejectItems"); info.DelItems = rdr.GetInt32("DelItems"); info.EndTime = rdr.GetNullableDateTime("EndTime"); info.IsInheritGroupRole = rdr.GetBoolean("IsInheritGroupRole"); info.UserSetting = rdr.GetString("UserSetting"); info.UserFriendGroup = rdr.GetString("UserFriendGroup"); info.UserTrueName = rdr.GetString("TrueName"); return(info); }
private static StatOnlineInfo StatOnlineInfoFromrdr(NullableDataReader rdr) { StatOnlineInfo info = new StatOnlineInfo(); info.Id = rdr.GetInt32("id"); info.UserIP = rdr.GetString("UserIP"); info.UserPage = rdr.GetString("UserPage"); info.UserAgent = rdr.GetString("UserAgent"); info.OnTime = rdr.GetDateTime("OnTime"); info.LastTime = rdr.GetDateTime("LastTime"); return(info); }
private static OrderFeedbackInfo GetOrderFeedbackInfoFromrdr(NullableDataReader rdr) { OrderFeedbackInfo info = new OrderFeedbackInfo(); info.Id = rdr.GetInt32("ID"); info.OrderId = rdr.GetInt32("OrderID"); info.UserName = rdr.GetString("UserName"); info.Content = rdr.GetString("Content"); info.WriteTime = rdr.GetDateTime("WriteTime"); info.ReplyName = rdr.GetString("ReplyName"); info.ReplyContent = rdr.GetString("ReplyContent"); info.ReplyTime = rdr.GetDateTime("ReplyTime"); return(info); }
public DataTable GetBillOfAgent(int startRowIndexId, int maxNumberRows, string userName) { Database database = DatabaseFactory.CreateDatabase(); DbCommand storedProcCommand = database.GetStoredProcCommand("PR_Accessories_BankroolItem_GetBill"); database.AddInParameter(storedProcCommand, "@StartRows", DbType.Int32, startRowIndexId); database.AddInParameter(storedProcCommand, "@PageSize", DbType.Int32, maxNumberRows); database.AddInParameter(storedProcCommand, "@SortColumn", DbType.String, "B.OrderID"); database.AddInParameter(storedProcCommand, "@StrColumn", DbType.String, "Max(O.OrderNum) AS tOrderNum, SUM(B.Money) AS tMoney, Max(B.DateAndTime) AS tDateAndTime, Max(B.Remark) AS tRemark"); database.AddInParameter(storedProcCommand, "@Sorts", DbType.String, "DESC"); database.AddInParameter(storedProcCommand, "@Filter", DbType.String, "B.UserName = '******' AND B.Status=1 "); database.AddInParameter(storedProcCommand, "@TableName", DbType.String, "PE_BankrollItem B LEFT JOIN PE_Orders O On B.OrderID = O.OrderID"); database.AddOutParameter(storedProcCommand, "@Total", DbType.Int32, maxNumberRows); DataTable table = new DataTable(); table.Columns.Add("DateAndTime", typeof(DateTime)); table.Columns.Add("OrderNum", typeof(string)); table.Columns.Add("Money", typeof(decimal)); table.Columns.Add("Remark", typeof(string)); using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(storedProcCommand))) { while (reader.Read()) { DataRow row = table.NewRow(); row["DateAndTime"] = reader.GetDateTime("tDateAndTime"); row["OrderNum"] = reader.GetString("tOrderNum"); row["Money"] = reader.GetDecimal("tMoney"); row["Remark"] = reader.GetString("tRemark"); table.Rows.Add(row); } } this.m_TotalOfBill = (int)database.GetParameterValue(storedProcCommand, "@Total"); return(table); }
public IList <ProductDetailInfo> GetProductsListByUserName(int startRowIndexId, int maxNumberRows, string userName) { Database database = DatabaseFactory.CreateDatabase(); DbCommand storedProcCommand = database.GetStoredProcCommand("PR_Common_GetList"); database.AddInParameter(storedProcCommand, "@StartRows", DbType.Int32, startRowIndexId); database.AddInParameter(storedProcCommand, "@PageSize", DbType.Int32, maxNumberRows); database.AddInParameter(storedProcCommand, "@SortColumn", DbType.String, "M.GeneralId"); database.AddInParameter(storedProcCommand, "@StrColumn", DbType.String, "N.NodeName, M.EliteLevel, M.CreateTime, M.UpdateTime, M.NodeId, M.GeneralId, M.ModelId, M.LinkType, P.*"); database.AddInParameter(storedProcCommand, "@Sorts", DbType.String, "DESC"); database.AddInParameter(storedProcCommand, "@TableName", DbType.String, "PE_CommonProduct P INNER JOIN (PE_CommonModel M RIGHT JOIN PE_Nodes N ON M.NodeID= N.NodeID) ON P.ProductID = M.ItemID AND P.TableName = M.TableName AND M.Status<>-3"); database.AddInParameter(storedProcCommand, "@Filter", DbType.String, "M.Inputer = '" + DBHelper.FilterBadChar(userName) + "'"); database.AddOutParameter(storedProcCommand, "@Total", DbType.Int32, maxNumberRows); IList <ProductDetailInfo> list = new List <ProductDetailInfo>(); using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(storedProcCommand))) { while (reader.Read()) { ProductDetailInfo productInfo = new ProductDetailInfo(); ProductFromrdr <ProductDetailInfo>(reader, productInfo); productInfo.EliteLevel = reader.GetInt32("EliteLevel"); productInfo.UpdateTime = new DateTime?(reader.GetDateTime("UpdateTime")); productInfo.CreateTime = reader.IsDBNull("CreateTime") ? productInfo.UpdateTime : new DateTime?(reader.GetDateTime("CreateTime")); productInfo.NodeName = reader.GetString("NodeName"); productInfo.NodeId = reader.GetInt32("NodeId"); productInfo.GeneralId = reader.GetInt32("GeneralId"); productInfo.ModelId = reader.GetInt32("ModelId"); productInfo.LinkType = reader.GetInt32("LinkType"); list.Add(productInfo); } } this.m_TotalOfProducts = (int)database.GetParameterValue(storedProcCommand, "@Total"); return(list); }
private static AdvertisementInfo AdvertisementFromrdr(NullableDataReader rdr) { AdvertisementInfo info = new AdvertisementInfo(); info.ADId = rdr.GetInt32("ADID"); info.UserId = rdr.GetInt32("UserID"); info.ADType = rdr.GetInt32("ADType"); info.ADName = rdr.GetString("ADName"); info.ImgUrl = rdr.GetString("ImgUrl"); info.ImgWidth = rdr.GetInt32("ImgWidth"); info.ImgHeight = rdr.GetInt32("ImgHeight"); info.FlashWmode = rdr.GetInt32("FlashWmode"); info.ADIntro = rdr.GetString("ADIntro"); info.LinkUrl = rdr.GetString("LinkUrl"); info.LinkTarget = rdr.GetInt32("LinkTarget"); info.LinkAlt = rdr.GetString("LinkAlt"); info.Priority = rdr.GetInt32("Priority"); info.Setting = rdr.GetString("Setting"); info.CountView = rdr.GetBoolean("CountView"); info.Views = rdr.GetInt32("Views"); info.CountClick = rdr.GetBoolean("CountClick"); info.Clicks = rdr.GetInt32("Clicks"); info.Passed = rdr.GetBoolean("Passed"); info.OverdueDate = rdr.GetDateTime("OverdueDate"); return(info); }
public ProductDetailInfo GetProductDetailInfoById(int id) { Parameters cmdParams = new Parameters(); cmdParams.AddInParameter("@ID", DbType.Int32, id); string strSql = "SELECT N.NodeName, M.EliteLevel, M.CreateTime, M.UpdateTime, M.NodeId, M.GeneralId, M.ModelId, M.LinkType, P.* \r\n FROM PE_CommonProduct P INNER JOIN (PE_CommonModel M RIGHT JOIN PE_Nodes N ON M.NodeID= N.NodeID) \r\n ON P.ProductID = M.ItemID WHERE M.GeneralID=@ID"; using (NullableDataReader reader = DBHelper.ExecuteReaderSql(strSql, cmdParams)) { if (reader.Read()) { ProductDetailInfo productInfo = new ProductDetailInfo(); ProductFromrdr <ProductDetailInfo>(reader, productInfo); productInfo.EliteLevel = reader.GetInt32("EliteLevel"); productInfo.UpdateTime = new DateTime?(reader.GetDateTime("UpdateTime")); productInfo.CreateTime = reader.GetNullableDateTime("CreateTime"); productInfo.NodeName = reader.GetString("NodeName"); productInfo.NodeId = reader.GetInt32("NodeId"); productInfo.GeneralId = reader.GetInt32("GeneralId"); productInfo.ModelId = reader.GetInt32("ModelId"); productInfo.LinkType = reader.GetInt32("LinkType"); return(productInfo); } return(new ProductDetailInfo()); } }
private static OrderItemInfo OrderItemFromrdr(NullableDataReader rdr) { OrderItemInfo info = new OrderItemInfo(); info.ItemId = rdr.GetInt32("ItemID"); info.OrderId = rdr.GetInt32("OrderID"); info.ProductId = rdr.GetInt32("ProductID"); info.TableName = rdr.GetString("TableName"); info.Property = rdr.GetString("Property"); info.SaleType = rdr.GetInt32("SaleType"); info.PriceMarket = rdr.GetDecimal("Price_Market"); info.Price = rdr.GetDecimal("Price"); info.TruePrice = rdr.GetDecimal("TruePrice"); info.Amount = rdr.GetInt32("Amount"); info.SubTotal = rdr.GetDecimal("SubTotal"); info.BeginDate = rdr.GetDateTime("BeginDate"); info.ServiceTerm = rdr.GetInt32("ServiceTerm"); info.Remark = rdr.GetString("Remark"); info.PresentMoney = rdr.GetDecimal("PresentMoney"); info.PresentPoint = rdr.GetInt32("PresentPoint"); info.PresentExp = rdr.GetInt32("PresentExp"); info.ServiceTermUnit = (ServiceTermUnit)rdr.GetInt32("ServiceTermUnit"); info.ProductCharacter = (ProductCharacter)rdr.GetInt32("ProductCharacter"); info.ProductName = rdr.GetString("ProductName"); info.Unit = rdr.GetString("Unit"); info.Weight = rdr.GetDouble("Weight"); return(info); }
private static ComplainItemInfo ComplainFromDataReader(NullableDataReader rdr) { ComplainItemInfo info = new ComplainItemInfo(); info.ItemId = rdr.GetInt32("ItemID"); info.ClientId = rdr.GetInt32("ClientID"); info.ContacterId = rdr.GetInt32("ContacterID"); info.ComplainMode = rdr.GetInt32("ComplainMode"); info.ComplainType = rdr.GetInt32("ComplainType"); info.ConfirmCaller = rdr.GetString("ConfirmCaller"); info.ConfirmFeedback = rdr.GetString("ConfirmFeedback"); info.ConfirmScore = rdr.GetInt32("ConfirmScore"); info.ConfirmTime = rdr.GetNullableDateTime("ConfirmTime"); info.Content = rdr.GetString("Content"); info.CurrentOwner = rdr.GetString("CurrentOwner"); info.DateAndTime = rdr.GetDateTime("DateAndTime"); info.EndTime = rdr.GetNullableDateTime("EndTime"); info.Feedback = rdr.GetString("Feedback"); info.FirstReceiver = rdr.GetString("FirstReceiver"); info.MagnitudeOfExigence = rdr.GetInt32("MagnitudeOfExigence"); info.Process = rdr.GetString("Process"); info.Processor = rdr.GetString("Processor"); info.Remark = rdr.GetString("Remark"); info.Result = rdr.GetString("Result"); info.ShortedForm = rdr.GetString("ShortedForm"); info.Status = rdr.GetInt32("Status"); info.Title = rdr.GetString("Title"); info.Defendant = rdr.GetString("Defendant"); return(info); }
private static ServiceInfo ServiceFromrdr(NullableDataReader rdr) { ServiceInfo info = new ServiceInfo(); info.ItemId = rdr.GetInt32("ItemId"); info.ClientId = rdr.GetInt32("ClientId"); info.ContacterId = rdr.GetInt32("ContacterId"); info.OrderId = rdr.GetInt32("OrderId"); info.ServiceTime = rdr.GetDateTime("ServiceTime"); info.ServiceType = rdr.GetString("ServiceType"); info.ServiceMode = rdr.GetString("ServiceMode"); info.ServiceTitle = rdr.GetString("ServiceTitle"); info.ServiceContent = rdr.GetString("ServiceContent"); info.ServiceResult = rdr.GetInt32("ServiceResult"); info.TakeTime = rdr.GetInt32("TakeTime"); info.Processor = rdr.GetString("Processor"); info.Inputer = rdr.GetString("Inputer"); info.Feedback = rdr.GetString("Feedback"); info.ConfirmTime = rdr.GetNullableDateTime("ConfirmTime"); info.ConfirmCaller = rdr.GetString("ConfirmCaller"); info.ConfirmScore = rdr.GetInt32("ConfirmScore"); info.ConfirmFeedback = rdr.GetString("ConfirmFeedback"); info.Remark = rdr.GetString("Remark"); info.ClientName = rdr.GetString("ClientName"); info.ShortedForm = rdr.GetString("ShortedForm"); return(info); }
private void Fill(out SolicitudesEFechasSolicitud oObj, NullableDataReader dr) { oObj = new SolicitudesEFechasSolicitud( dr.GetInt64("id_Beneficiario") , dr.GetInt16("codPrestacion") , dr.GetString("ApeNomCompleto") , dr.GetNullableString("cuip") == null ? "" : dr.GetString("cuip") , dr.GetString("DescripcionPrestacion") , dr.GetInt16("pais_PK") , dr.GetString("PaisDescCompleto") , dr.GetBoolean("Mercosur") , dr.GetString("referencia_exterior") , dr.GetString("ubicacion_Fisica") , dr.GetDateTime("fAMSolicitud") , dr.GetDateTime("fechaIngreso") ); }
private static OrderInfo OrderFromrdr(NullableDataReader rdr, string action) { OrderInfo info = new OrderInfo(); info.OrderId = rdr.GetInt32("OrderID"); info.OrderNum = rdr.GetString("OrderNum"); info.UserName = rdr.GetString("UserName"); info.ClientId = rdr.GetInt32("ClientID"); info.ClientName = rdr.GetString("ClientName"); info.MoneyTotal = rdr.GetDecimal("MoneyTotal"); info.NeedInvoice = rdr.GetBoolean("NeedInvoice"); info.Invoiced = rdr.GetBoolean("Invoiced"); info.Remark = rdr.GetString("Remark"); info.MoneyReceipt = rdr.GetDecimal("MoneyReceipt"); info.InputTime = rdr.GetDateTime("InputTime"); info.Status = (OrderStatus)rdr.GetInt32("Status"); info.DeliverStatus = (DeliverStatus)rdr.GetInt32("DeliverStatus"); if (string.IsNullOrEmpty(action)) { info.EnableDownload = rdr.GetBoolean("EnableDownload"); info.PresentMoney = rdr.GetDecimal("PresentMoney"); info.PresentPoint = rdr.GetInt32("PresentPoint"); info.PresentExp = rdr.GetInt32("PresentExp"); info.DiscountPayment = rdr.GetDouble("Discount_Payment"); info.ChargeDeliver = rdr.GetDecimal("Charge_Deliver"); } info.AgentName = rdr.GetString("AgentName"); info.Functionary = rdr.GetString("Functionary"); info.InvoiceContent = rdr.GetString("InvoiceContent"); info.BeginDate = rdr.GetDateTime("BeginDate"); info.ContacterName = rdr.GetString("ContacterName"); info.Address = rdr.GetString("Address"); info.ZipCode = rdr.GetString("ZipCode"); info.Mobile = rdr.GetString("Mobile"); info.Phone = rdr.GetString("Phone"); info.Email = rdr.GetString("Email"); info.PaymentType = rdr.GetInt32("PaymentType"); info.DeliverType = rdr.GetInt32("DeliverType"); info.Memo = rdr.GetString("Memo"); info.OutOfStockProject = (OutOfStockProject)rdr.GetInt32("OutOfStockProject"); info.OrderType = rdr.GetInt32("OrderType"); info.CouponId = rdr.GetInt32("CouponID"); info.DeliveryTime = rdr.GetString("DeliveryTime"); return(info); }
private static ShoppingCartInfo ShoppingCartFromrdr(NullableDataReader rdr, bool isDetail) { ShoppingCartInfo info = new ShoppingCartInfo(); info.UserName = rdr.GetString("UserName"); info.CartId = rdr.GetString("CartID"); info.ProductId = rdr.GetInt32("ProductID"); info.Quantity = rdr.GetInt32("Quantity"); info.IsPresent = rdr.GetBoolean("IsPresent"); info.UpdateTime = rdr.GetDateTime("UpdateTime"); info.TableName = rdr.GetString("TableName"); info.Property = rdr.GetString("Property"); info.InformResult = rdr.GetInt32("InformResult"); if (isDetail) { info.ProductInfomation.ProductName = rdr.GetString("ProductName"); info.ProductInfomation.ProductType = (ProductType)rdr.GetInt32("ProductType"); info.ProductInfomation.ProductPic = rdr.GetString("ProductPic"); info.ProductInfomation.ProductThumb = rdr.GetString("ProductThumb"); info.ProductInfomation.Unit = rdr.GetString("Unit"); info.ProductInfomation.ServiceTermUnit = (ServiceTermUnit)rdr.GetInt32("ServiceTermUnit"); info.ProductInfomation.ServiceTerm = rdr.GetInt32("ServiceTerm"); info.ProductInfomation.PriceInfo.Price = rdr.GetDecimal("Price"); info.ProductInfomation.PriceMarket = rdr.GetDecimal("Price_Market"); info.ProductInfomation.PriceInfo.PriceMember = rdr.GetDecimal("Price_Member"); info.ProductInfomation.PriceInfo.PriceAgent = rdr.GetDecimal("Price_Agent"); info.ProductInfomation.EnableWholesale = rdr.GetBoolean("EnableWholesale"); info.ProductInfomation.PriceInfo.PriceWholesale1 = rdr.GetDecimal("Price_Wholesale1"); info.ProductInfomation.PriceInfo.PriceWholesale2 = rdr.GetDecimal("Price_Wholesale2"); info.ProductInfomation.PriceInfo.PriceWholesale3 = rdr.GetDecimal("Price_Wholesale3"); info.ProductInfomation.PriceInfo.NumberWholesale1 = rdr.GetInt32("Number_Wholesale1"); info.ProductInfomation.PriceInfo.NumberWholesale2 = rdr.GetInt32("Number_Wholesale2"); info.ProductInfomation.PriceInfo.NumberWholesale3 = rdr.GetInt32("Number_Wholesale3"); info.ProductInfomation.PresentId = rdr.GetInt32("PresentID"); info.ProductInfomation.PresentNumber = rdr.GetInt32("PresentNumber"); info.ProductInfomation.PresentPoint = rdr.GetInt32("PresentPoint"); info.ProductInfomation.PresentExp = rdr.GetInt32("PresentExp"); info.ProductInfomation.PresentMoney = rdr.GetDecimal("PresentMoney"); info.ProductInfomation.StocksProject = (StocksProject)rdr.GetInt32("StocksProject"); info.ProductInfomation.SalePromotionType = rdr.GetInt32("SalePromotionType"); info.ProductInfomation.MinNumber = rdr.GetInt32("MinNumber"); info.ProductInfomation.Discount = rdr.GetDouble("Discount"); info.ProductInfomation.IncludeTax = (TaxRateType)rdr.GetInt32("IncludeTax"); info.ProductInfomation.TaxRate = rdr.GetDouble("TaxRate"); info.ProductInfomation.Properties = rdr.GetString("Properties"); info.ProductInfomation.Weight = rdr.GetDouble("Weight"); info.ProductInfomation.LimitNum = rdr.GetInt32("LimitNum"); info.ProductInfomation.EnableSingleSell = rdr.GetBoolean("EnableSingleSell"); info.ProductInfomation.DependentProducts = rdr.GetString("DependentProducts"); info.ProductInfomation.ProductKind = (ProductKind)rdr.GetInt32("ProductKind"); info.ProductInfomation.TableName = rdr.GetString("TableName"); info.ProductInfomation.ProductId = rdr.GetInt32("ProductID"); info.ProductInfomation.Stocks = rdr.GetInt32("Stocks"); info.ProductInfomation.OrderNum = rdr.GetInt32("OrderNum"); } return(info); }
public IList <QuestionInfo> GetQuestonsByUser(string userName, int startRowIndex, int maximumRows, int searchType, string keyword) { Database database = DatabaseFactory.CreateDatabase(); DbCommand storedProcCommand = database.GetStoredProcCommand("PR_Common_GetListBySortColumn"); database.AddInParameter(storedProcCommand, "@StartRows", DbType.Int32, startRowIndex); database.AddInParameter(storedProcCommand, "@PageSize", DbType.Int32, maximumRows); database.AddInParameter(storedProcCommand, "@PrimaryColumn", DbType.String, "ID"); database.AddInParameter(storedProcCommand, "@SortColumnDbType", DbType.String, "DateTime"); database.AddInParameter(storedProcCommand, "@SortColumn", DbType.String, "LastUpdateTime"); database.AddInParameter(storedProcCommand, "@StrColumn", DbType.String, "ID, QuestionTitle, LastUpdateTime, ReplyTime,ReplyCreator, IsReply, IsSolved"); database.AddInParameter(storedProcCommand, "@Sorts", DbType.String, "DESC"); database.AddInParameter(storedProcCommand, "@TableName", DbType.String, "PE_Question"); database.AddInParameter(storedProcCommand, "@Filter", DbType.String); database.AddOutParameter(storedProcCommand, "@Total", DbType.Int32, maximumRows); string str = " QuestionCreator = '" + DBHelper.FilterBadChar(userName) + "' "; switch (searchType) { case 1: str = str + " AND IsReply = 1 AND IsSolved = 0 "; storedProcCommand.Parameters["@SortColumn"].Value = "ReplyTime"; break; case 2: str = str + " AND IsSolved = 1 "; break; case 3: if (!string.IsNullOrEmpty(keyword)) { str = str + " AND QuestionTitle LIKE '%" + DBHelper.FilterBadChar(keyword) + "%' "; } break; } storedProcCommand.Parameters["@Filter"].Value = str; IList <QuestionInfo> list = new List <QuestionInfo>(); using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(storedProcCommand))) { while (reader.Read()) { QuestionInfo item = new QuestionInfo(); item.Id = reader.GetInt32("ID"); item.QuestionTitle = reader.GetString("QuestionTitle"); item.QuestionCreateTime = reader.GetDateTime("LastUpdateTime"); item.ReplyTime = reader.GetNullableDateTime("ReplyTime"); item.IsReply = reader.GetBoolean("IsReply"); item.IsSolved = reader.GetBoolean("IsSolved"); item.ReplyCreator = reader.GetString("ReplyCreator"); list.Add(item); } } this.m_TotalCount = (int)database.GetParameterValue(storedProcCommand, "@Total"); return(list); }
private static PresentProjectInfo PresentProjectFromrdr(NullableDataReader rdr) { PresentProjectInfo info = new PresentProjectInfo(); info.ProjectId = rdr.GetInt32("ProjectID"); info.ProjectName = rdr.GetString("ProjectName"); info.BeginDate = rdr.GetDateTime("BeginDate"); info.EndDate = rdr.GetDateTime("EndDate"); info.MinMoney = rdr.GetDecimal("MinMoney"); info.MaxMoney = rdr.GetDecimal("MaxMoney"); info.PresentContent = rdr.GetString("PresentContent"); info.Price = rdr.GetDecimal("Price"); info.PresentId = rdr.GetString("PresentID"); info.Cash = rdr.GetDecimal("Cash"); info.PresentExp = rdr.GetInt32("PresentExp"); info.PresentPoint = rdr.GetInt32("PresentPoint"); info.Disabled = rdr.GetBoolean("Disabled"); return(info); }
private void Fill(out Movimiento_Solicitud oObj, NullableDataReader dr) { Estado iEstado = new Estado(dr.GetInt32("cod_estado"), dr.GetString("descripcionEstado")); Sector iSector = new Sector(dr.GetInt32("cod_sector"), dr.GetString("descripcionSector")); oObj = new Movimiento_Solicitud(dr.GetDateTime("fecha_Movimiento") , iEstado , iSector , dr.GetNullableString("observaciones") == null ? "":dr.GetString("observaciones") ); }
private static SignInLogInfo SigninLogInfoFromDataReader(NullableDataReader dr) { SignInLogInfo info = new SignInLogInfo(); info.GeneralId = dr.GetInt32("GeneralId"); info.IP = dr.GetString("IP"); info.IsSignIn = dr.GetBoolean("IsSignin"); info.SignInTime = dr.GetDateTime("SigninTime"); info.UserName = dr.GetString("UserName"); return(info); }
private void Fill(out Devolucion oObj, NullableDataReader dr) { oObj = new Devolucion(dr.GetDateTime("fechaMovimiento"), dr.GetNullableString("destino") == null ? "" : dr.GetString("destino"), dr.GetNullableString("Observaciones") == null?"":dr.GetString("Observaciones"), dr.GetNullableString("Certificado") == null ? "" : dr.GetString("Certificado"), this.TraeFaltanteDevolucionXFechaMovimiento(dr.GetInt64("id_Beneficiario"), dr.GetInt16("codPrestacion"), dr.GetDateTime("fechaMovimiento").ToShortDateString()), dr.GetNullableDateTime("fechaNotificacion"), dr.GetNullableDateTime("fechaPresentacion") ); }
public bool ImportData(string zoneId, string importDatabase) { bool flag; Database db = DatabaseFactory.CreateDatabase(); StringBuilder builder = new StringBuilder(""); builder.Append(" SELECT ZoneID, ZoneName, ZoneJSName, ZoneIntro, ZoneType, DefaultSetting, ZoneSetting, ZoneWidth, ZoneHeight, ShowType, Active, UpdateTime FROM PE_AdZone "); OleDbConnection connection = new OleDbConnection("Provider = Microsoft.Jet.OleDb.4.0;Data Source = " + importDatabase); try { connection.Open(); builder.Append("Where ZoneID IN (" + zoneId + ") ORDER BY ZoneID"); OleDbCommand command = new OleDbCommand(builder.ToString(), connection); NullableDataReader reader = new NullableDataReader(command.ExecuteReader(CommandBehavior.CloseConnection)); while (reader.Read()) { ADZoneInfo adZoneInfo = new ADZoneInfo(); adZoneInfo.ZoneId = GetMaxADZoneId(); adZoneInfo.ZoneName = reader.GetString("ZoneName"); adZoneInfo.ZoneJSName = reader.GetString("ZoneJSName"); adZoneInfo.ZoneIntro = reader.GetString("ZoneIntro"); adZoneInfo.ZoneType = (ADZoneType)reader.GetInt32("ZoneType"); adZoneInfo.DefaultSetting = reader.GetBoolean("DefaultSetting"); adZoneInfo.Setting = reader.GetString("ZoneSetting"); adZoneInfo.ZoneWidth = reader.GetInt32("ZoneWidth"); adZoneInfo.ZoneHeight = reader.GetInt32("ZoneHeight"); adZoneInfo.ShowType = reader.GetInt32("ShowType"); adZoneInfo.Active = reader.GetBoolean("Active"); adZoneInfo.UpdateTime = reader.GetDateTime("UpdateTime"); DbCommand command2 = GetProcdbComm(db, "PR_Ad_ADZone_ADD", adZoneInfo); try { db.ExecuteNonQuery(command2); continue; } catch { reader.Close(); return(false); } } flag = true; } catch { flag = false; } finally { connection.Close(); } return(flag); }
private static DownloadErrorInfo DownloadErrorInfoFromrdr(NullableDataReader rdr) { DownloadErrorInfo info = new DownloadErrorInfo(); info.ErrorId = rdr.GetInt32("ErrorID"); info.InfoId = rdr.GetInt32("InfoID"); info.ErrorUrl = rdr.GetString("ErrorUrl"); info.ErrorTimes = rdr.GetInt32("ErrorTimes"); info.ErrorDate = rdr.GetDateTime("ErrorDate"); return(info); }
private static ReplyInfo GetInfobyReader(NullableDataReader rdr) { ReplyInfo info = new ReplyInfo(); info.Id = rdr.GetInt32("ID"); info.QuestionId = rdr.GetInt32("QuestionID"); info.ReplyCreator = rdr.GetString("ReplyCreator"); info.ReplyTime = rdr.GetDateTime("ReplyTime"); info.ReplyContent = rdr.GetString("ReplyContent"); return(info); }
private static SignInContentInfo SigninContentInfoFromDataReader(NullableDataReader dr) { SignInContentInfo info = new SignInContentInfo(); info.GeneralId = dr.GetInt32("GeneralId"); info.EndTime = dr.GetDateTime("EndTime"); info.Priority = dr.GetInt32("Priority"); info.SignInType = (SignInType)dr.GetInt32("SigninType"); info.Status = (SignInStatus)dr.GetInt32("Status"); info.Title = dr.GetString("Title"); return(info); }
private static InvoiceInfo InvoiceItemFromrdr(NullableDataReader rdr) { InvoiceInfo info = new InvoiceInfo(); info.InvoiceId = rdr.GetInt32("InvoiceID"); info.ClientId = rdr.GetInt32("ClientID"); info.UserName = rdr.GetString("UserName"); info.OrderId = rdr.GetInt32("OrderID"); info.InvoiceType = rdr.GetInt32("InvoiceType"); info.InvoiceNum = rdr.GetString("InvoiceNum"); info.InvoiceTitle = rdr.GetString("InvoiceTitle"); info.InvoiceContent = rdr.GetString("InvoiceContent"); info.InvoiceDate = rdr.GetDateTime("InvoiceDate"); info.TotalMoney = rdr.GetDecimal("TotalMoney"); info.Drawer = rdr.GetString("Drawer"); info.Inputer = rdr.GetString("Inputer"); info.InputTime = rdr.GetDateTime("InputTime"); info.OrderNum = rdr.GetString("OrderNum"); info.ClientName = rdr.GetString("ClientName"); return(info); }
private static CouponInfo GetCouponInfoFromrdataReader(NullableDataReader dataReader) { CouponInfo info = new CouponInfo(); info.BeginDate = dataReader.GetDateTime("BeginDate"); info.CouponCreateContent = dataReader.GetString("CouponCreateContent"); info.CouponCreateType = (CouponCreateType)dataReader.GetInt32("CouponCreateType"); info.CouponId = dataReader.GetInt32("CouponId"); info.CouponName = dataReader.GetString("CouponName"); info.EndDate = dataReader.GetDateTime("EndDate"); info.LimitNum = dataReader.GetInt32("LimitNum"); info.Money = dataReader.GetDecimal("Money"); info.OrderTotalMoney = dataReader.GetDecimal("OrderTotalMoney"); info.CouponNumPattern = dataReader.GetString("CouponNumPattern"); info.ProductLimitContent = dataReader.GetString("ProductLimitContent"); info.ProductLimitType = (ProductLimitType)dataReader.GetInt32("ProductLimitType"); info.State = dataReader.GetInt32("State"); info.UserGroup = dataReader.GetString("UserGroup"); info.UseEndDate = dataReader.GetDateTime("UseEndDate"); return(info); }
private static StockInfo StockFromrdr(NullableDataReader rdr) { StockInfo info = new StockInfo(); info.StockId = rdr.GetInt32("StockID"); info.StockNum = rdr.GetString("StockNum"); info.InputTime = rdr.GetDateTime("InputTime"); info.Inputer = rdr.GetString("Inputer"); info.StockType = (StockType)rdr.GetInt32("StockType"); info.Remark = rdr.GetString("Remark"); return(info); }