public IList <TopicInfo> GetTopics()
{
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("select * from Vshop_Topics order by DisplaySequence asc,topicid desc");
IList <TopicInfo> result = null;
using (IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
result = ReaderConvert.ReaderToList <TopicInfo>(dataReader);
}
return(result);
}
public IList <NavigateInfo> GetAllNavigate(ClientType client, int supplierId)
{
DbCommand sqlStringCommand = this.database.GetSqlStringCommand(string.Format("select * from Ecshop_Banner where type=2 AND Client= {0} and supplierId={1} ORDER BY DisplaySequence ASC", (int)client, supplierId));
IList <NavigateInfo> result;
using (IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
result = ReaderConvert.ReaderToList <NavigateInfo>(dataReader);
}
return(result);
}
public IList <OneyuanTaoInfo> GetOneyuanTaoInfoByIdList(string[] ActivityIds)
{
ActivityIds = this.ChangeJoinStringArray(ActivityIds);
string query = "select * from Vshop_OneyuanTao_Detail where ActivityId in(" + string.Join(",", ActivityIds) + ")";
DbCommand sqlStringCommand = this.database.GetSqlStringCommand(query);
using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
{
return(ReaderConvert.ReaderToList <OneyuanTaoInfo>(reader));
}
}
public IList <Top50ParticipantInfo> GetTop50ParticipantList(DateTime PrizeTime, [Optional, DefaultParameterValue(50)] int topnum)
{
string query = "SELECT TOP " + topnum + " Pid,p.UserId,BuyTime,isnull(UserName,'SYSUSER') as UserName FROM Vshop_OneyuanTao_ParticipantMember p\r\n Left join aspnet_Members m on p.UserId=m.UserId where BuyTime<@PrizeTime and IsPay=1 order by Pid desc";
DbCommand sqlStringCommand = this.database.GetSqlStringCommand(query);
this.database.AddInParameter(sqlStringCommand, "PrizeTime", DbType.DateTime, PrizeTime);
using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
{
return(ReaderConvert.ReaderToList <Top50ParticipantInfo>(reader));
}
}
public IList <ActivitiesInfo> GetActivitiesInfo(string ActivitiesId)
{
IList <ActivitiesInfo> result = null;
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand(string.Format("SELECT * FROM Hishop_Activities WHERE ActivitiesId={0}", ActivitiesId));
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
result = ReaderConvert.ReaderToList <ActivitiesInfo>(dataReader);
}
return(result);
}
public IList <ProductTypeInfo> GetProductTypes()
{
IList <ProductTypeInfo> result = null;
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Ecshop_ProductTypes");
using (IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
result = ReaderConvert.ReaderToList <ProductTypeInfo>(dataReader);
}
return(result);
}
public IList <ElmentsInfo> GetElments(string HSElmentsName)
{
IList <ElmentsInfo> result = null;
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT HS_ELMENTS_ID, HS_ELMENTS_NAME, HS_ELMENTS_DESC FROM FND_HS_ELMENTS where HS_ELMENTS_NAME like '%" + DataHelper.CleanSearchString(HSElmentsName) + "%'");
using (IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
result = ReaderConvert.ReaderToList <ElmentsInfo>(dataReader);
}
return(result);
}
public IList <ElmentsInfo> GetElments()
{
IList <ElmentsInfo> result = null;
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT HS_ELMENTS_ID, HS_ELMENTS_NAME, HS_ELMENTS_DESC FROM FND_HS_ELMENTS");
using (IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
result = ReaderConvert.ReaderToList <ElmentsInfo>(dataReader);
}
return(result);
}
public IList <HSCodeInfo> GetHSCode(string HS_CODE)
{
IList <HSCodeInfo> result = null;
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM FND_HS_CODE where HS_CODE=@HS_CODE and VOIDED=0");
using (IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
result = ReaderConvert.ReaderToList <HSCodeInfo>(dataReader);
}
return(result);
}
public IList <ReplyKeyInfo> GetTopReplyInfos(int Type)
{
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Weibo_ReplyKeys where Type=" + Type + " ORDER BY id ASC");
IList <ReplyKeyInfo> result = null;
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
result = ReaderConvert.ReaderToList <ReplyKeyInfo>(dataReader);
}
return(result);
}
public IList <MenuInfo> GetMenusByParentId(int parentId, string wid)
{
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM vshop_Menu WHERE ParentMenuId = @ParentMenuId and wid=@wid ORDER BY DisplaySequence ASC");
this.database.AddInParameter(sqlStringCommand, "ParentMenuId", DbType.Int32, parentId);
this.database.AddInParameter(sqlStringCommand, "wid", DbType.String, wid);
using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
{
return(ReaderConvert.ReaderToList <MenuInfo>(reader));
}
}
public IList <MemberGradeInfo> GetMemberGrades()
{
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM aspnet_MemberGrades");
IList <MemberGradeInfo> result = null;
using (IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
result = ReaderConvert.ReaderToList <MemberGradeInfo>(dataReader);
}
return(result);
}
public IList <MenuInfo> GetTopFuwuMenus()
{
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM vshop_Menu_Fuwu WHERE ParentMenuId = 0 ORDER BY DisplaySequence ASC");
IList <MenuInfo> result = null;
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
result = ReaderConvert.ReaderToList <MenuInfo>(dataReader);
}
return(result);
}
public IList <MenuInfo> GetTopMenus()
{
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Weibo_Menu WHERE ParentMenuId = 0");
IList <MenuInfo> result = null;
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
result = ReaderConvert.ReaderToList <MenuInfo>(dataReader);
}
return(result);
}
public IList <DistributorGradeInfo> GetDistributorGradeInfos()
{
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM aspnet_DistributorGrade");
IList <DistributorGradeInfo> result = null;
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
result = ReaderConvert.ReaderToList <DistributorGradeInfo>(dataReader);
}
return(result);
}
public IList <SpecifyRegionGroup> GetSpecifyRegionGroups(int templateId)
{
IList <SpecifyRegionGroup> result = null;
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT g.*,r.RegionIds FROM Hishop_FreightTemplate_SpecifyRegionGroups g LEFT JOIN vw_Hishop_FreightTemplate_SpecifyRegions r on (g.GroupId=r.GroupId) where g.TemplateId =" + templateId);
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
result = ReaderConvert.ReaderToList <SpecifyRegionGroup>(dataReader);
}
return(result);
}
public IList <VoteInfo> GetVoteList()
{
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Hishop_Votes");
IList <VoteInfo> result = null;
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
result = ReaderConvert.ReaderToList <VoteInfo>(dataReader);
}
return(result);
}
public IList <MenuInfo> GetTopMenus(ClientType clientType)
{
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM vshop_Menu WHERE ParentMenuId = 0 AND Client = " + (int)clientType + " ORDER BY DisplaySequence ASC");
IList <MenuInfo> result = null;
using (IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
result = ReaderConvert.ReaderToList <MenuInfo>(dataReader);
}
return(result);
}
public List <CategoryQuery> GetHishop_Categories()
{
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("select * from Hishop_Categories");
List <CategoryQuery> list = new List <CategoryQuery>();
using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
{
list = (List <CategoryQuery>)ReaderConvert.ReaderToList <CategoryQuery>(reader);
}
return(list);
}
public List <CouponInfo> GetHishop_Coupons()
{
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("select * from Hishop_Coupons");
List <CouponInfo> list = new List <CouponInfo>();
using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
{
list = (List <CouponInfo>)ReaderConvert.ReaderToList <CouponInfo>(reader);
}
return(list);
}
public IList <MenuInfo> GetMenusByParentId(string wid, int parentId)
{
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM VShop_NavMenu WHERE wid=@wid and ParentMenuId = @ParentMenuId");
this.database.AddInParameter(sqlStringCommand, "wid", DbType.String, wid);
this.database.AddInParameter(sqlStringCommand, "ParentMenuId", DbType.Int32, parentId);
using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
{
return(ReaderConvert.ReaderToList <MenuInfo>(reader));
}
}
public IList <GamePrizeInfo> GetGamePrizeListsByGameId(int gameId)
{
string query = "Select * From [Hishop_PromotionGamePrizes] where GameId=@GameId ";
DbCommand sqlStringCommand = this._db.GetSqlStringCommand(query);
this._db.AddInParameter(sqlStringCommand, "@GameId", DbType.Int32, gameId);
using (IDataReader reader = this._db.ExecuteReader(sqlStringCommand))
{
return(ReaderConvert.ReaderToList <GamePrizeInfo>(reader));
}
}
public List <ProductReviewAndReplyQuery> SelectProduct()
{
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("select * from Hishop_Products");
List <ProductReviewAndReplyQuery> list = new List <ProductReviewAndReplyQuery>();
using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
{
list = (List <ProductReviewAndReplyQuery>)ReaderConvert.ReaderToList <ProductReviewAndReplyQuery>(reader);
}
return(list);
}
public List <AppRunImgInfo> GetAppRunImg()
{
List <AppRunImgInfo> list = null;
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Ecshop_AppRunImg");
using (IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
list = ReaderConvert.ReaderToList <AppRunImgInfo>(dataReader) as List <AppRunImgInfo>;
}
return(list);
}
public IList <FreightTemplate> GetFreightTemplates()
{
IList <FreightTemplate> result = null;
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Hishop_FreightTemplate_Templates order by TemplateId desc");
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
result = ReaderConvert.ReaderToList <FreightTemplate>(dataReader);
}
return(result);
}
public IList <ActivitySignUpInfo> GetActivitySignUpById(int activityId)
{
string query = "SELECT * FROM vshop_ActivitySignUp WHERE ActivityId = @ActivityId";
DbCommand sqlStringCommand = this.database.GetSqlStringCommand(query);
this.database.AddInParameter(sqlStringCommand, "ActivityId", DbType.Int32, activityId);
using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
{
return(ReaderConvert.ReaderToList <ActivitySignUpInfo>(reader));
}
}
public List <CategoryQuery> Getaspnet_ManagersClientUserId()
{
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("select * from aspnet_Managers where ClientUserId != 0");
List <CategoryQuery> list = new List <CategoryQuery>();
using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
{
list = (List <CategoryQuery>)ReaderConvert.ReaderToList <CategoryQuery>(reader);
}
return(list);
}
public IList <MenuInfo> GetFuwuMenusByParentId(int parentId)
{
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM vshop_Menu_Fuwu WHERE ParentMenuId = @ParentMenuId ORDER BY DisplaySequence ASC");
this.database.AddInParameter(sqlStringCommand, "ParentMenuId", System.Data.DbType.Int32, parentId);
IList <MenuInfo> result = null;
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
result = ReaderConvert.ReaderToList <MenuInfo>(dataReader);
}
return(result);
}
public IList <BannerInfo> GetAllBanners()
{
IList <BannerInfo> result = new List <BannerInfo>();
StringBuilder stringBuilder = new StringBuilder("select * from Hishop_Banner where type=1 ORDER BY DisplaySequence ASC");
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand(stringBuilder.ToString());
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
result = ReaderConvert.ReaderToList <BannerInfo>(dataReader);
}
return(result);
}
public IList <VoteItemInfo> GetVoteItems(long voteId)
{
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Hishop_VoteItems WHERE VoteId = @VoteId");
this.database.AddInParameter(sqlStringCommand, "VoteId", System.Data.DbType.Int64, voteId);
IList <VoteItemInfo> result = null;
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
result = ReaderConvert.ReaderToList <VoteItemInfo>(dataReader);
}
return(result);
}