/// <summary> /// 读取一条商品回复数据 /// </summary> /// <param name="id">商品回复的主键值</param> /// <param name="userID">用户ID</param> /// <returns>商品回复数据模型</returns> public ProductReplyInfo ReadProductReply(int id, int userID) { SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.NVarChar), new SqlParameter("@userID", SqlDbType.Int) }; parameters[0].Value = id; parameters[1].Value = userID; ProductReplyInfo productReply = new ProductReplyInfo(); using (SqlDataReader dr = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "ReadProductReply", parameters)) { if (dr.Read()) { productReply.ID = dr.GetInt32(0); productReply.ProductID = dr.GetInt32(1); productReply.CommentID = dr.GetInt32(2); productReply.Content = dr[3].ToString(); productReply.UserIP = dr[4].ToString(); productReply.PostDate = dr.GetDateTime(5); productReply.UserID = dr.GetInt32(6); productReply.UserName = dr[7].ToString(); } } return(productReply); }
/// <summary> /// 读取一条缺货登记数据 /// </summary> /// <param name="id">缺货登记的主键值</param> /// <param name="userID">用户ID</param> /// <returns>缺货登记数据模型</returns> public BookingProductInfo ReadBookingProduct(int id, int userID) { SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int), new SqlParameter("@userID", SqlDbType.Int) }; parameters[0].Value = id; parameters[1].Value = userID; BookingProductInfo bookingProduct = new BookingProductInfo(); using (SqlDataReader dr = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "ReadBookingProduct", parameters)) { if (dr.Read()) { bookingProduct.ID = dr.GetInt32(0); bookingProduct.ProductID = dr.GetInt32(1); bookingProduct.ProductName = dr[2].ToString(); bookingProduct.RelationUser = dr[3].ToString(); bookingProduct.Email = dr[4].ToString(); bookingProduct.Tel = dr[5].ToString(); bookingProduct.UserNote = dr[6].ToString(); bookingProduct.BookingDate = dr.GetDateTime(7); bookingProduct.BookingIP = dr[8].ToString(); bookingProduct.IsHandler = dr.GetInt32(9); bookingProduct.HandlerDate = dr.GetDateTime(10); bookingProduct.HandlerAdminID = dr.GetInt32(11); bookingProduct.HandlerAdminName = dr[12].ToString(); bookingProduct.HandlerNote = dr[13].ToString(); bookingProduct.UserID = dr.GetInt32(14); bookingProduct.UserName = dr[15].ToString(); } } return(bookingProduct); }
/// <summary> /// 读取符合要求的ID串 /// </summary> /// <param name="strID">缺货登记的主键值,以,号分隔</param> /// <param name="userID">用户ID</param> /// <returns>缺货登记的主键值,以,号分隔</returns> public string ReadBookingProductIDList(string strID, int userID) { string idList = string.Empty; SqlParameter[] parameters = { new SqlParameter("@strID", SqlDbType.NVarChar), new SqlParameter("@userID", SqlDbType.Int) }; parameters[0].Value = strID; parameters[1].Value = userID; using (SqlDataReader dr = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "ReadBookingProductIDList", parameters)) { while (dr.Read()) { if (idList == string.Empty) { idList = dr.GetInt32(0).ToString(); } else { idList += "," + dr.GetInt32(0).ToString(); } } } return(idList); }
/// <summary> /// /// </summary> /// <param name="voteRecord"></param> public VoteRecordInfo ReadVoteHistoryRecord(int voteID, string ip, string itemID) { SqlParameter[] parameters = { new SqlParameter("@voteID", SqlDbType.NVarChar), new SqlParameter("@ip", SqlDbType.NVarChar), new SqlParameter("@itemID", SqlDbType.NVarChar) }; parameters[0].Value = voteID; parameters[1].Value = ip; parameters[2].Value = itemID; VoteRecordInfo voteRecord = new VoteRecordInfo(); using (SqlDataReader dr = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "ReadVoteHistoryRecord", parameters)) { if (dr.Read()) { voteRecord.ID = dr.GetInt32(0); voteRecord.VoteID = dr[1].ToString(); voteRecord.ItemID = dr[2].ToString(); voteRecord.UserIP = dr[3].ToString(); voteRecord.AddDate = dr.GetDateTime(4); voteRecord.UserID = dr.GetInt32(5); voteRecord.UserName = dr[6].ToString(); } } return(voteRecord); }
/// <summary> /// 读取一条邮件发送记录数据 /// </summary> /// <param name="id">邮件发送记录的主键值</param> /// <returns>邮件发送记录数据模型</returns> public EmailSendRecordInfo ReadEmailSendRecord(int id) { SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int) }; parameters[0].Value = id; EmailSendRecordInfo emailSendRecord = new EmailSendRecordInfo(); using (SqlDataReader dr = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "ReadEmailSendRecord", parameters)) { if (dr.Read()) { emailSendRecord.ID = dr.GetInt32(0); emailSendRecord.Title = dr[1].ToString(); emailSendRecord.Content = dr[2].ToString(); emailSendRecord.IsSystem = dr.GetInt32(3); emailSendRecord.EmailList = dr[4].ToString(); emailSendRecord.OpenEmailList = dr[5].ToString(); emailSendRecord.IsStatisticsOpendEmail = dr.GetInt32(6); emailSendRecord.SendStatus = dr.GetInt32(7); emailSendRecord.Note = dr[8].ToString(); emailSendRecord.AddDate = dr.GetDateTime(9); emailSendRecord.SendDate = dr.GetDateTime(10); } } return(emailSendRecord); }
/// <summary> /// 获得地区所有数据列表 /// </summary> /// <returns>地区的所有数据列表</returns> public List <RegionInfo> ReadRegionAllList() { List <RegionInfo> regionList = new List <RegionInfo>(); using (SqlDataReader dr = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "ReadRegionAllList")) { PrepareRegionModel(dr, regionList); } return(regionList); }
/// <summary> /// 获得链接的所有数据列表 /// </summary> /// <returns>链接的所有数据列表</returns> public List <LinkInfo> ReadLinkAllList() { List <LinkInfo> linkList = new List <LinkInfo>(); using (SqlDataReader dr = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "ReadLinkAllList")) { PrepareLinkModel(dr, linkList); } return(linkList); }
/// <summary> /// 获得菜单所有数据列表 /// </summary> /// <returns>菜单的所有数据列表</returns> public List <MenuInfo> ReadMenuAllList() { List <MenuInfo> MenuList = new List <MenuInfo>(); using (SqlDataReader dr = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "ReadMenuAllList")) { PrepareMenuModel(dr, MenuList); } return(MenuList); }
/// <summary> /// 投过票的记录 /// </summary> /// <param name="VoteItemID">投票项目ID</param> /// <param name="IpAddress">投票IP</param> /// <returns></returns> public List <VoteRecordInfo> HasVotedList(int VoteItemID, string IpAddress) { List <VoteRecordInfo> voteRecordList = new List <VoteRecordInfo>(); SqlParameter[] sps = { new SqlParameter("@voteItemID", VoteItemID), new SqlParameter("@ipAddress", IpAddress) }; using (SqlDataReader dr = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "HasVoted", sps)) { PrepareVoteRecordModel(dr, voteRecordList); } return(voteRecordList); }
/// <summary> /// 是否投过票 /// </summary> /// <param name="VoteItemID">投票项目ID</param> /// <param name="IpAddress">投票IP</param> /// <returns></returns> public bool HasVoted(int VoteItemID, string IpAddress) { bool result = false; SqlParameter[] sps = { new SqlParameter("@voteItemID", VoteItemID), new SqlParameter("@ipAddress", IpAddress) }; SqlDataReader dr = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "HasVoted", sps); if (dr.HasRows) { result = true; } return(result); }
/// <summary> /// 按分类ID获得会员价格所有数据 /// </summary> /// <param name="productID">分类ID</param> /// <returns>会员价格数据列表</returns> public List <MemberPriceInfo> ReadMemberPriceByProduct(int productID) { SqlParameter[] parameters = { new SqlParameter("@productID", SqlDbType.Int) }; parameters[0].Value = productID; List <MemberPriceInfo> memberPriceList = new List <MemberPriceInfo>(); using (SqlDataReader dr = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "ReadMemberPriceByProduct", parameters)) { PrepareMemberPriceModel(dr, memberPriceList); } return(memberPriceList); }
/// <summary> /// 搜索缺货登记数据列表 /// </summary> /// <param name="bookingProductSearch">BookingProductSearchInfo模型变量</param> /// <returns>缺货登记数据列表</returns> public List <BookingProductInfo> SearchBookingProductList(BookingProductSearchInfo bookingProductSearch) { string condition = PrepareCondition(bookingProductSearch).ToString(); List <BookingProductInfo> bookingProductList = new List <BookingProductInfo>(); SqlParameter[] parameters = { new SqlParameter("@condition", SqlDbType.NVarChar) }; parameters[0].Value = condition; using (SqlDataReader dr = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "SearchBookingProductList", parameters)) { PrepareBookingProductModel(dr, bookingProductList); } return(bookingProductList); }
/// <summary> /// 搜索邮件发送记录数据列表 /// </summary> /// <param name="emailSendRecordSearch">EmailSendRecordSearchInfo模型变量</param> /// <returns>邮件发送记录数据列表</returns> public List <EmailSendRecordInfo> SearchEmailSendRecordList(EmailSendRecordSearchInfo emailSendRecordSearch) { string condition = PrepareCondition(emailSendRecordSearch).ToString(); List <EmailSendRecordInfo> emailSendRecordList = new List <EmailSendRecordInfo>(); SqlParameter[] parameters = { new SqlParameter("@condition", SqlDbType.NVarChar) }; parameters[0].Value = condition; using (SqlDataReader dr = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "SearchEmailSendRecordList", parameters)) { PrepareEmailSendRecordModel(dr, emailSendRecordList); } return(emailSendRecordList); }
/// <summary> /// 按分类ID和会员等级获得会员价格所有数据 /// </summary> /// <param name="strProductID">分类ID</param> /// <param name="gradeID">会员等级ID</param> /// <returns>会员价格数据列表</returns> public List <MemberPriceInfo> ReadMemberPriceByProductGrade(string strProductID, int gradeID) { SqlParameter[] parameters = { new SqlParameter("@strProductID", SqlDbType.NChar), new SqlParameter("@gradeID", SqlDbType.Int) }; parameters[0].Value = strProductID; parameters[1].Value = gradeID; List <MemberPriceInfo> memberPriceList = new List <MemberPriceInfo>(); using (SqlDataReader dr = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "ReadMemberPriceByProductGrade", parameters)) { PrepareMemberPriceModel(dr, memberPriceList); } return(memberPriceList); }
/// <summary> /// 根据ClassID读取上传上传文件 /// </summary> /// <param name="tableID">表ID</param> /// <param name="strClassID">strClassID</param> /// <returns>上传上传数据</returns> public List <UploadInfo> ReadUploadByClassID(int tableID, string strClassID) { SqlParameter[] parameters = { new SqlParameter("@tableID", SqlDbType.Int), new SqlParameter("@strClassID", SqlDbType.NVarChar) }; parameters[0].Value = tableID; parameters[1].Value = strClassID; List <UploadInfo> uploadList = new List <UploadInfo>(); using (SqlDataReader dr = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "ReadUploadByClassID", parameters)) { PrepareUploadModel(dr, uploadList); } return(uploadList); }
public List <VoteItemInfo> ReadVoteItemList(VoteItemSearchInfo voteItemSearch) { MssqlCondition mssqlCondition = new MssqlCondition(); PrepareCondition(mssqlCondition, voteItemSearch); List <VoteItemInfo> VoteItemList = new List <VoteItemInfo>(); SqlParameter[] parameters = { new SqlParameter("@condition", SqlDbType.NVarChar) }; parameters[0].Value = mssqlCondition.ToString() + " ORDER BY [OrderID] desc,[ID] desc"; using (SqlDataReader dr = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "SearchVoteItemList", parameters)) { PrepareVoteItemModel(dr, VoteItemList); } return(VoteItemList); }
/// <summary> /// 返回DataReader对像 /// </summary> /// <returns></returns> public override SqlDataReader ExecuteReader() { return(ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "ReadPageList", this.PrepareParameter())); }