public static ExecuteReader ( SqlConnection connection, CommandType commandType, string commandText ) : System.Data.SqlClient.SqlDataReader | ||
connection | SqlConnection | a valid SqlConnection |
commandType | CommandType | the CommandType (stored procedure, text, etc.) |
commandText | string | the stored procedure name or T-SQL command |
return | System.Data.SqlClient.SqlDataReader |
public IList<ReviewInfo> GetReview(ReviewType rt, int ID) { SqlHelper objSqlHelper = new SqlHelper(); List<ReviewInfo> reviews = new List<ReviewInfo>(); SqlParameter[] objParams = new SqlParameter[2]; objParams[0] = new SqlParameter("@reviewType", SqlDbType.Int, 4); objParams[1] = new SqlParameter("@ID", SqlDbType.Int, 4); objParams[0].Value = (int)rt; objParams[1].Value = ID; SqlDataReader reader = objSqlHelper.ExecuteReader("je_Reviews_GetReview", objParams); while (reader.Read()) { ReviewInfo item = new ReviewInfo(); item.ReviewID = reader.GetInt32(reader.GetOrdinal("ReviewID")); item.BookID = reader.GetInt32(reader.GetOrdinal("bookID")); item.PostIP = reader.GetString(reader.GetOrdinal("postIP")); item.PostTime = reader.GetDateTime(reader.GetOrdinal("postTime")); item.RateID = reader.GetInt32(reader.GetOrdinal("rate")); item.UserName = reader.GetString(reader.GetOrdinal("userName")); item.StatusID = reader.GetInt32(reader.GetOrdinal("status")); item.Content = reader.GetString(reader.GetOrdinal("content")); reviews.Add(item); } reader.Close(); return reviews; }
public AddressInfo GetAddressByID() { SqlHelper objSqlHelper = new SqlHelper(); SqlParameter[] objParams = new SqlParameter[1]; objParams[0] = new SqlParameter("@userName", SqlDbType.VarChar); objParams[0].Value = GetUserName(); SqlDataReader reader = objSqlHelper.ExecuteReader("je_Ad_GetAddressByID", objParams); AddressInfo item = new AddressInfo(); while (reader.Read()) { item.UserName = reader.GetString(reader.GetOrdinal("userName")); item.AddressName = reader.GetString(reader.GetOrdinal("addressName")); item.Address = reader.GetString(reader.GetOrdinal("address")); item.Post = reader.GetString(reader.GetOrdinal("Post")); item.Telephone = reader.GetString(reader.GetOrdinal("Telephone")); item.Province = reader.GetString(reader.GetOrdinal("Province")); item.City = reader.GetString(reader.GetOrdinal("City")); item.SendType = reader.GetInt32(reader.GetOrdinal("SendType")); item.PayType = reader.GetInt32(reader.GetOrdinal("PayType")); item.Name = reader.GetString(reader.GetOrdinal("Name")); item.Price = reader.GetDecimal(reader.GetOrdinal("Price")); item.Balance = reader.GetDecimal(reader.GetOrdinal("Balance")); } reader.Close(); return item; }
public IList<FriendLinkInfo> GetLinks(LinkItemType linkType) { SqlHelper objSqlHelper = new SqlHelper(); List<FriendLinkInfo> friendlinks = new List<FriendLinkInfo>(); SqlParameter[] objParams = new SqlParameter[1]; objParams[0] = new SqlParameter("@linkType", SqlDbType.Int, 4); objParams[0].Value = (int)linkType; SqlDataReader reader = objSqlHelper.ExecuteReader("je_Link_GetLinks", objParams); ; objParams[0].Value = (int)linkType; while (reader.Read()) { FriendLinkInfo item = new FriendLinkInfo(); item.LinkID = reader.GetInt32(reader.GetOrdinal("linkID")); item.LinkName = reader.GetString(reader.GetOrdinal("linkName")); item.LinkURL = reader.GetString(reader.GetOrdinal("linkURL")); item.LinkLogo = reader.GetString(reader.GetOrdinal("linkLogo")); item.LinkOrder = reader.GetInt32(reader.GetOrdinal("linkOrder")); item.IsMain = reader.GetBoolean(reader.GetOrdinal("linkMain")); item.IsArrow = reader.GetBoolean(reader.GetOrdinal("linkArrow")); friendlinks.Add(item); } reader.Close(); return friendlinks; }
public IList<AddressInfo> GetAddress(int userID) { SqlHelper objSqlHelper = new SqlHelper(); List<AddressInfo> Addresss = new List<AddressInfo>(); SqlParameter[] objParams = new SqlParameter[1]; objParams[0] = new SqlParameter("@userID", SqlDbType.Int, 4); objParams[0].Value = userID; SqlDataReader reader = objSqlHelper.ExecuteReader("je_Ad_GetAddress", objParams); while (reader.Read()) { AddressInfo item = new AddressInfo(); item.AddressID = reader.GetInt32(reader.GetOrdinal("addressID")); item.AddressName = reader.GetString(reader.GetOrdinal("addressName")); item.Address = reader.GetString(reader.GetOrdinal("address")); item.Post = reader.GetString(reader.GetOrdinal("Post")); item.Telephone = reader.GetString(reader.GetOrdinal("Telephone")); item.IsDefault = reader.GetBoolean(reader.GetOrdinal("isDefault")); item.Province = reader.GetString(reader.GetOrdinal("Province")); item.City = reader.GetString(reader.GetOrdinal("City")); item.SendType = reader.GetInt32(reader.GetOrdinal("SendType")); item.Name = reader.GetString(reader.GetOrdinal("Name")); Addresss.Add(item); } reader.Close(); return Addresss; }
public IList<CategoryInfo> GetCategory(CategoryType categoryType, int categoryID) { SqlHelper objSqlHelper = new SqlHelper(); List<CategoryInfo> categorys = new List<CategoryInfo>(); SqlParameter[] objParams = new SqlParameter[2]; objParams[0] = new SqlParameter("@categoryType", SqlDbType.Int, 4); objParams[1] = new SqlParameter("@categoryID", SqlDbType.Int, 4); objParams[0].Value = (int)categoryType; objParams[1].Value = categoryID; SqlDataReader reader = objSqlHelper.ExecuteReader("je_Cat_GetCategory", objParams); ; while (reader.Read()) { CategoryInfo item = new CategoryInfo(); item.CategoryID = reader.GetInt32(reader.GetOrdinal("categoryID")); item.CategoryName = reader.GetString(reader.GetOrdinal("categoryName")); item.ParentID = reader.GetInt32(reader.GetOrdinal("parentID")); item.IsMain = reader.GetBoolean(reader.GetOrdinal("IsMain")); categorys.Add(item); } reader.Close(); objSqlHelper.close(); return categorys; }
public BookInfo GetBookByID(int bookID) { SqlHelper objSqlHelper = new SqlHelper(); List<BookInfo> books = new List<BookInfo>(); SqlParameter[] objParams = new SqlParameter[1]; objParams[0] = new SqlParameter("@bookID", SqlDbType.Int, 4); objParams[0].Value = bookID; SqlDataReader reader = objSqlHelper.ExecuteReader("je_Book_GetBookByID", objParams); BookInfo item = new BookInfo(); while (reader.Read()) { //图书编号 item.BookID = reader.GetInt32(reader.GetOrdinal("BookID")); //图书名字,分类,价格,会员价格,大图,小图 item.BookName = reader.GetString(reader.GetOrdinal("BookName")); item.Category = reader.GetInt32(reader.GetOrdinal("bookCategory")); item.Price = reader.GetDecimal(reader.GetOrdinal("bookPrice")); item.MemberPrice = reader.GetDecimal(reader.GetOrdinal("bookMemberPrice")); item.BookPublish = reader.GetString(reader.GetOrdinal("BookPublish")); item.BookImage = reader.GetString(reader.GetOrdinal("BookImage")); item.BookSmallImage = reader.GetString(reader.GetOrdinal("bookSmallImage")); //是否发布,是否推荐,是否特价,是否热卖,是否允许评论,库存数量 item.IsRelease = reader.GetBoolean(reader.GetOrdinal("isRelease")); item.IsGood = reader.GetBoolean(reader.GetOrdinal("isGood")); item.IsCheap = reader.GetBoolean(reader.GetOrdinal("isCheap")); item.IsSaleGood = reader.GetBoolean(reader.GetOrdinal("isSaleGood")); item.ReviewEnable = reader.GetBoolean(reader.GetOrdinal("reviewEnable")); item.Stock = reader.GetInt32(reader.GetOrdinal("bookStock")); //图书简介,作者,出版时间,国际编号,出版社,页数,版次 item.SmallBookDec = reader.GetString(reader.GetOrdinal("smallBookDesc")); item.BookAuthor = reader.GetString(reader.GetOrdinal("bookAuthor")); item.PublishTime = reader.GetDateTime(reader.GetOrdinal("bookPublishTime")); item.BookISBN = reader.GetString(reader.GetOrdinal("bookISBN")); item.BookPublish = reader.GetString(reader.GetOrdinal("bookPublish")); item.BookPages = reader.GetInt32(reader.GetOrdinal("bookPages")); item.BookEditions = reader.GetString(reader.GetOrdinal("bookEditions")); //是否为期书,搜索关键字,加入时间,具体介绍 item.IsExpect = reader.GetBoolean(reader.GetOrdinal("isExpect")); item.SearchKey = reader.GetString(reader.GetOrdinal("searchKey")); item.BookDec = reader.GetString(reader.GetOrdinal("BookDec")); item.ReadCount = reader.GetInt32(reader.GetOrdinal("bookReadCount")); item.ReviewCount = reader.GetInt32(reader.GetOrdinal("bookCommentCount")); // item.TeacherID = reader.GetInt32(reader.GetOrdinal("TeacherID")); item.CatenaID = reader.GetInt32(reader.GetOrdinal("CatenaID")); item.Rate = reader.GetDecimal(reader.GetOrdinal("bookRate")); //折扣,团队折扣,团队价格 item.Rebate = reader.GetInt32(reader.GetOrdinal("Rebate")); item.VipRebate = reader.GetInt32(reader.GetOrdinal("VipRebate")); item.VipPrice = reader.GetDecimal(reader.GetOrdinal("VipPrice")); item.IsMain = reader.GetBoolean(reader.GetOrdinal("IsMain")); } reader.Close(); return item; }
/// <summary> /// 获取今日订单信息 /// </summary> /// <returns></returns> public IList<OrdersInfo> GetTodayOrders() { SqlHelper objSqlHelper = new SqlHelper(); List<OrdersInfo> orders = new List<OrdersInfo>(); SqlDataReader reader = objSqlHelper.ExecuteReader("je_Order_GetTodayOrders"); while (reader.Read()) { OrdersInfo item = GetOrdersByID(reader.GetInt64(reader.GetOrdinal("OrderID"))); orders.Add(item); } reader.Close(); return orders; }
public IList<EmailFormatInfo> GetEmailFormat() { SqlHelper objSqlHelper = new SqlHelper(); List<EmailFormatInfo> emails = new List<EmailFormatInfo>(); SqlDataReader reader = objSqlHelper.ExecuteReader("je_Email_GetEmailFormat"); while (reader.Read()) { EmailFormatInfo item =GetEmailFormatByID( reader.GetInt32(reader.GetOrdinal("ID"))); emails.Add(item); } reader.Close(); return emails; }
public List<string> GetAllName() { List<string> allName = new List<string>(); SqlHelper helper = new SqlHelper(); var Reader = helper.ExecuteReader("P_GetAllName"); while (Reader.Read()) { allName.Add(Reader["Name"].ToString()); } if (!Reader.IsClosed) Reader.Close(); return allName; }
public IList<PublishInfo> GetMainPublishs() { SqlHelper objSqlHelper = new SqlHelper(); List<PublishInfo> publishs = new List<PublishInfo>(); SqlDataReader reader = objSqlHelper.ExecuteReader("je_Pb_GetMainPublishs"); while (reader.Read()) { PublishInfo item = GetPublishByID(reader.GetInt32(reader.GetOrdinal("publishID"))); publishs.Add(item); } reader.Close(); return publishs; }
public IList<SendAreaInfo> GetSendArea() { SqlHelper objSqlHelper = new SqlHelper(); List<SendAreaInfo> sendAreas = new List<SendAreaInfo>(); SqlDataReader reader = objSqlHelper.ExecuteReader("je_Area_GetArea"); while (reader.Read()) { SendAreaInfo item = GetSendAreaByID(reader.GetInt32(reader.GetOrdinal("AreaID"))); sendAreas.Add(item); } reader.Close(); return sendAreas; }
public IList<PollInfo> GetPoll() { SqlHelper objSqlHelper = new SqlHelper(); List<PollInfo> pl = new List<PollInfo>(); SqlDataReader reader = objSqlHelper.ExecuteReader("je_Poll_GetPoll"); while (reader.Read()) { PollInfo item = GetPollByID(reader.GetInt32(reader.GetOrdinal("PollID"))); pl.Add(item); } reader.Close(); return pl; }
/// <summary> /// 获取下载排行 /// </summary> /// <returns></returns> public IList<DownLoadInfo> GetTopDownLoad() { SqlHelper objSqlHelper = new SqlHelper(); List<DownLoadInfo> downLoads = new List<DownLoadInfo>(); SqlDataReader reader = objSqlHelper.ExecuteReader("je_DL_GetTopDownLoad"); while (reader.Read()) { DownLoadInfo item = GetDownLoadByID(reader.GetInt32(reader.GetOrdinal("DownID"))); downLoads.Add(item); } reader.Close(); return downLoads; }
public IList<HelpClassInfo> GetMainHelpClass() { SqlHelper objSqlHelper = new SqlHelper(); List<HelpClassInfo> helpClass = new List<HelpClassInfo>(); SqlDataReader reader = objSqlHelper.ExecuteReader("je_HC_GetMainHelpClass"); while (reader.Read()) { HelpClassInfo item = GetHelpClassByID(reader.GetInt32(reader.GetOrdinal("ClassID"))); helpClass.Add(item); } reader.Close(); return helpClass; }
public IList<HelpInfo> GetHelp() { SqlHelper objSqlHelper = new SqlHelper(); List<HelpInfo> helps = new List<HelpInfo>(); SqlDataReader reader = objSqlHelper.ExecuteReader("je_Help_GetHelp"); while (reader.Read()) { HelpInfo item = GetHelpByID(reader.GetInt32(reader.GetOrdinal("helpID"))); helps.Add(item); } reader.Close(); return helps; }
public IList<OrdersInfo> GetYearOrders() { SqlHelper objSqlHelper = new SqlHelper(); List<OrdersInfo> orders = new List<OrdersInfo>(); SqlDataReader reader = objSqlHelper.ExecuteReader("je_Order_GetYearOrders"); while (reader.Read()) { OrdersInfo item = new OrdersInfo(); item.Year = reader.GetInt32(reader.GetOrdinal("OrderYear")); orders.Add(item); } reader.Close(); return orders; }
public IList<TeacherInfo> GetTeacher(int type) { SqlHelper objSqlHelper = new SqlHelper(); List<TeacherInfo> teachers = new List<TeacherInfo>(); SqlParameter[] objParams = new SqlParameter[1]; objParams[0] = new SqlParameter("@type", SqlDbType.Int, 4); objParams[0].Value = type; SqlDataReader reader = objSqlHelper.ExecuteReader("je_TE_GetTeacher", objParams); while (reader.Read()) { TeacherInfo item = GetTeacherByID(reader.GetInt32(reader.GetOrdinal("ID"))); teachers.Add(item); } return teachers; }
public SiteSettings GetSiteSettings(string applicationName) { SqlHelper objSqlHelper = new SqlHelper(); SqlParameter[] objParams = new SqlParameter[1]; objParams[0] = new SqlParameter("@applicationName", SqlDbType.VarChar, 100); objParams[0].Value = applicationName; SqlDataReader reader = objSqlHelper.ExecuteReader("je_Site_GetSiteSetting", objParams); SiteSettings settings = new SiteSettings(); while (reader.Read()) { settings = PopulateSiteSettingsFromIDataReader(reader); } reader.Close(); return settings; }
public IList<PollInfo> GetTopPoll(int type) { SqlHelper objSqlHelper = new SqlHelper(); SqlParameter[] objParams = new SqlParameter[1]; List<PollInfo> pl = new List<PollInfo>(); objParams[0] = new SqlParameter("@type", SqlDbType.Int, 4); objParams[0].Value = type; SqlDataReader reader = objSqlHelper.ExecuteReader("je_Poll_GetTopPoll", objParams); while (reader.Read()) { PollInfo item = GetPollByID(reader.GetInt32(reader.GetOrdinal("PollID"))); pl.Add(item); } reader.Close(); return pl; }
/// <summary> /// 获取分类下载文件列表 /// </summary> /// <returns></returns> public IList<DownLoadInfo> GetDownLoadByCat(int catID) { SqlHelper objSqlHelper = new SqlHelper(); SqlParameter[] objParams = new SqlParameter[1]; objParams[0] = new SqlParameter("@catID", SqlDbType.Int, 4); objParams[0].Value = catID; List<DownLoadInfo> downLoads = new List<DownLoadInfo>(); SqlDataReader reader = objSqlHelper.ExecuteReader("je_DL_GetDownLoadByCat", objParams); while (reader.Read()) { DownLoadInfo item = GetDownLoadByID(reader.GetInt32(reader.GetOrdinal("DownID"))); downLoads.Add(item); } reader.Close(); return downLoads; }
public IList<ImageBookInfo> GetImageBook(ImageBookType type) { SqlHelper objSqlHelper = new SqlHelper(); List<ImageBookInfo> imageBooks = new List<ImageBookInfo>(); SqlParameter[] objParams = new SqlParameter[1]; objParams[0] = new SqlParameter("@type", SqlDbType.Int, 4); objParams[0].Value = (int)type; SqlDataReader reader = objSqlHelper.ExecuteReader("je_IB_GetImageBook", objParams); while (reader.Read()) { ImageBookInfo item = GetImageBookByID(reader.GetInt32(reader.GetOrdinal("imageID"))); imageBooks.Add(item); } reader.Close(); return imageBooks; }
public IList<OrdersInfo> GetStatusOrders(int state) { SqlHelper objSqlHelper = new SqlHelper(); SqlParameter[] objParams = new SqlParameter[1]; objParams[0] = new SqlParameter("@state", SqlDbType.Int); objParams[0].Value = state; List<OrdersInfo> orders = new List<OrdersInfo>(); SqlDataReader reader = objSqlHelper.ExecuteReader("je_Order_GetStatusOrders",objParams); while (reader.Read()) { OrdersInfo item = GetOrdersByID(reader.GetInt64(reader.GetOrdinal("OrderID"))); orders.Add(item); } reader.Close(); return orders; }
public IList<TitleCssInfo> GetTitleCss() { SqlHelper objSqlHelper = new SqlHelper(); List<TitleCssInfo> tcs = new List<TitleCssInfo>(); SqlDataReader reader = objSqlHelper.ExecuteReader("je_Tc_GetTitleCss"); while (reader.Read()) { TitleCssInfo item = new TitleCssInfo(); item.TitleCssID = reader.GetInt32(reader.GetOrdinal("cssID")); item.TitleCssName = reader.GetString(reader.GetOrdinal("cssName")); item.TitleCssDec = reader.GetString(reader.GetOrdinal("cssDec")); item.AddDate = reader.GetDateTime(reader.GetOrdinal("addDate")); tcs.Add(item); } reader.Close(); return tcs; }
public IList<SendInfo> GetSend() { SqlHelper objSqlHelper = new SqlHelper(); List<SendInfo> sends = new List<SendInfo>(); SqlDataReader reader = objSqlHelper.ExecuteReader("je_Send_GetSend"); while (reader.Read()) { SendInfo item = new SendInfo(); item.SendID = reader.GetInt32(reader.GetOrdinal("sendID")); item.Name = reader.GetString(reader.GetOrdinal("Name")); item.Price = reader.GetDecimal(reader.GetOrdinal("Price")); item.Dec = reader.GetString(reader.GetOrdinal("Dec")); sends.Add(item); } reader.Close(); return sends; }
public IList<BookCatenaInfo> GetCatenas() { SqlHelper objSqlHelper = new SqlHelper(); List<BookCatenaInfo> catenas = new List<BookCatenaInfo>(); SqlDataReader reader = objSqlHelper.ExecuteReader("je_Ct_GetCatenas"); while (reader.Read()) { BookCatenaInfo item = new BookCatenaInfo(); item.CatenaID = reader.GetInt32(reader.GetOrdinal("catenaID")); item.CatenaName = reader.GetString(reader.GetOrdinal("catenaName")); item.CatenaDec = reader.GetString(reader.GetOrdinal("catenaDec")); item.AddDate = reader.GetDateTime(reader.GetOrdinal("addDate")); catenas.Add(item); } reader.Close(); return catenas; }
public IList<BookInfo> GetTopBook(int year,int month,int catID) { SqlHelper objSqlHelper = new SqlHelper(); List<BookInfo> books = new List<BookInfo>(); SqlParameter[] objParams = new SqlParameter[3]; objParams[0] = new SqlParameter("@year", SqlDbType.Int, 4); objParams[1] = new SqlParameter("@month", SqlDbType.Int, 4); objParams[2] = new SqlParameter("@catID", SqlDbType.Int, 4); SqlDataReader reader = objSqlHelper.ExecuteReader("je_Book_GetTopBook", objParams); while (reader.Read()) { BookInfo item = new BookInfo(); item = GetBookByID(reader.GetInt32(reader.GetOrdinal("BookID"))); books.Add(item); } reader.Close(); return books; }
public SendInfo GetSendByID(int sendID) { SqlHelper objSqlHelper = new SqlHelper(); SqlParameter[] objParams = new SqlParameter[1]; objParams[0] = new SqlParameter("@sendID", SqlDbType.Int, 4); objParams[0].Value = sendID; SqlDataReader reader = objSqlHelper.ExecuteReader("je_Send_GetSendByID", objParams); SendInfo item = new SendInfo(); while (reader.Read()) { item.SendID = reader.GetInt32(reader.GetOrdinal("sendID")); item.Name = reader.GetString(reader.GetOrdinal("Name")); item.Price = reader.GetDecimal(reader.GetOrdinal("Price")); item.Dec = reader.GetString(reader.GetOrdinal("Dec")); } reader.Close(); return item; }
public TitleCssInfo GetTitleCssByID(int titleCssID) { SqlHelper objSqlHelper = new SqlHelper(); SqlParameter[] objParams = new SqlParameter[1]; objParams[0] = new SqlParameter("@cssID", SqlDbType.Int, 4); objParams[0].Value = titleCssID; SqlDataReader reader = objSqlHelper.ExecuteReader("je_Tc_GetTitleCssByID", objParams); TitleCssInfo item = new TitleCssInfo(); while (reader.Read()) { item.TitleCssID = reader.GetInt32(reader.GetOrdinal("cssID")); item.TitleCssName = reader.GetString(reader.GetOrdinal("cssName")); item.TitleCssDec = reader.GetString(reader.GetOrdinal("cssDec")); item.AddDate = reader.GetDateTime(reader.GetOrdinal("addDate")); } reader.Close(); return item; }
public BookCatenaInfo GetCatenaByID(int catenaID) { SqlHelper objSqlHelper = new SqlHelper(); SqlParameter[] objParams = new SqlParameter[1]; objParams[0] = new SqlParameter("@catenaID", SqlDbType.Int, 4); objParams[0].Value = catenaID; SqlDataReader reader = objSqlHelper.ExecuteReader("je_Ct_GetCatenaByID", objParams); BookCatenaInfo item = new BookCatenaInfo(); while (reader.Read()) { item.CatenaID = reader.GetInt32(reader.GetOrdinal("catenaID")); item.CatenaName = reader.GetString(reader.GetOrdinal("catenaName")); item.CatenaDec = reader.GetString(reader.GetOrdinal("catenaDec")); item.AddDate = reader.GetDateTime(reader.GetOrdinal("addDate")); } reader.Close(); return item; }
public IList<BookInfo> GetIndexBook(ViewBookType type) { SqlHelper objSqlHelper = new SqlHelper(); List<BookInfo> books = new List<BookInfo>(); SqlParameter[] objParams = new SqlParameter[1]; objParams[0] = new SqlParameter("@type", SqlDbType.Int, 4); objParams[0].Value = (int)type; SqlDataReader reader = objSqlHelper.ExecuteReader("je_Book_GetIndexBook", objParams); while (reader.Read()) { BookInfo item = new BookInfo(); item = GetBookByID(reader.GetInt32(reader.GetOrdinal("BookID"))); books.Add(item); } reader.Close(); return books; }
public override IDataReader Forums_List(int PortalId, int ModuleId, int ForumGroupId, int ParentForumId, bool FillLastPost) { return((IDataReader)(SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "activeforums_Forums_List", ModuleId, ForumGroupId, ParentForumId, FillLastPost))); }
public override IDataReader Filters_List(int PortalId, int ModuleId, int PageIndex, int PageSize, string Sort, string SortColumn) { return((IDataReader)(SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "activeforums_Filters_List", PortalId, ModuleId, PageIndex, PageSize, Sort, SortColumn))); }
public override IDataReader Search_DotNetNuke(int moduleId) { return(SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "activeforums_Search_GetSearchItems", moduleId)); }
public override IDataReader Subscriptions_GetDigest(string SubscriptionType, DateTime StartDate) { return((IDataReader)(SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "activeforums_Subscriptions_DigestGet", SubscriptionType, StartDate))); }
public override IDataReader Security_GetByKey(string SecurityKey) { return(SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "activeforums_Security_GetByKey", SecurityKey)); }
public override IDataReader Security_GetByUser(int PortalId, int ForumId, int UserId, bool IsSuperUser) { return(SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "activeforums_Security_GetByUser", PortalId, ForumId, UserId, IsSuperUser)); }
public override IDataReader Filters_ListByType(int PortalId, int ModuleId, string FilterType) { return((IDataReader)(SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "activeforums_Filters_ListByType", PortalId, ModuleId, FilterType))); }
public override IDataReader Poll_GetResults(int TopicId) { return((IDataReader)(SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "activeforums_Poll_GetResults", TopicId))); }
public override IDataReader Groups_List(int ModuleId) { return((IDataReader)(SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "activeforums_Groups_List", ModuleId))); }
//获取一篇文章的所有的信息(包括所有的文章信息,评论,用户信息) public List <CVMissedPetComment> GetMissPetCommentPageList(string missPetID, int pageNumber, int NumberPerPage, out int howmanyPages) { List <CVMissedPetComment> commentList = new List <CVMissedPetComment>(); howmanyPages = 6; SqlParameter[] missPetParams = null; missPetParams = new SqlParameter[] { new SqlParameter("@MissID", SqlDbType.NVarChar, 32), new SqlParameter("@DescriptionLength", SqlDbType.Int), new SqlParameter("@PageNumber", SqlDbType.Int), new SqlParameter("@InfoPerPage", SqlDbType.Int), new SqlParameter("@HowManyInfo", SqlDbType.Int, 65535, ParameterDirection.Output, true, 0, 0, "", DataRowVersion.Default, 0), }; missPetParams[0].Value = missPetID; missPetParams[1].Value = CPetCareConfiguration.AriticleAllNum; missPetParams[2].Value = pageNumber; missPetParams[3].Value = NumberPerPage; try { using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "proGetMissCommentInfo", missPetParams)) { while (reader.Read()) { CVMissedPetComment missPet = new CVMissedPetComment(); missPet.MissID = reader["MissID"].ToString(); missPet.City = reader["City"].ToString(); missPet.Province = reader["Province"].ToString(); missPet.MissInfo = reader["MissInfo"].ToString(); missPet.MissTitle = reader["MissTitle"].ToString(); missPet.PetCategoryName = reader["PetCategoryName"].ToString(); missPet.PriorityScore = int.Parse(reader["PriorityScore"].ToString()); missPet.UserName = reader["UserName"].ToString(); missPet.PicLocation = reader["PicLocation"].ToString(); missPet.Portrait = reader["Portrait"].ToString(); missPet.LinkUrl = reader["LinkUrl"].ToString(); missPet.UserWeiBo = reader["UserWeiBo"].ToString(); missPet.Status = reader["Status"].ToString(); bool tempIsRecommand = true; missPet.IsRecommand = bool.TryParse(reader["IsRecommand"].ToString(), out tempIsRecommand) ? tempIsRecommand : true; bool tempIsEssence = true; missPet.IsEssence = bool.TryParse(reader["IsEssence"].ToString(), out tempIsEssence) ? tempIsEssence : true; DateTime tempLastEditTime = DateTime.Now; tempLastEditTime = DateTime.TryParse(reader["LastEditTime"].ToString(), out tempLastEditTime) ? tempLastEditTime : DateTime.Now; missPet.LastEditTime = tempLastEditTime.ToString("yyyy/MM/dd hh:mm:ss"); DateTime tempMissTime = DateTime.Now; tempMissTime = DateTime.TryParse(reader["MissTime"].ToString(), out tempMissTime) ? tempMissTime : DateTime.Now; missPet.MissTime = tempLastEditTime.ToString("yyyy/MM/dd hh:mm:ss"); missPet.IP = reader["IP"].ToString(); int tempFocusNum = 0; missPet.FocusNum = int.TryParse(reader["FocusNum"].ToString(), out tempFocusNum) ? tempFocusNum : 0; missPet.CommentContent = reader["CommentContent"].ToString(); missPet.CommentIP = reader["CommentIP"].ToString(); missPet.CommentUserName = reader["CommentUserName"].ToString(); missPet.CommentUserProtrait = reader["CommentUserProtrait"].ToString(); missPet.CommentUserLevel = reader["CommentUserLevel"].ToString(); missPet.CommentID = reader["CommentID"].ToString(); commentList.Add(missPet); } reader.Close(); reader.Dispose(); int tempHowmanyPages = 0; howmanyPages = int.TryParse(missPetParams[4].Value.ToString(), out tempHowmanyPages) ? tempHowmanyPages : 0; } } catch (Exception ex) { throw; } return(commentList); }
public override IDataReader Reply_Get(int PortalId, int ModuleId, int TopicId, int ReplyId) { return((IDataReader)(SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "activeforums_Reply_Get", PortalId, ModuleId, TopicId, ReplyId))); }
//获取所有的丢失宠物的文章列表,返回信息列表,分页的方式 public List <CVMissedPetInfo> GetAllMissedPetListPerPage(int pageNumber, int NumberPerPage, out int howmanyPages) { List <CVMissedPetInfo> MissedPetList = new List <CVMissedPetInfo>(); SqlParameter[] adoptPetParams = null; adoptPetParams = new SqlParameter[4]; adoptPetParams[0] = new SqlParameter("@DescriptionLength", SqlDbType.Int); adoptPetParams[1] = new SqlParameter("@PageNumber", SqlDbType.Int); adoptPetParams[2] = new SqlParameter("@InfoPerPage", SqlDbType.Int); adoptPetParams[0].Value = CPetCareConfiguration.ArticleBreviaryNum; adoptPetParams[1].Value = pageNumber; adoptPetParams[2].Value = NumberPerPage; SqlParameter parameter = new SqlParameter(); parameter.DbType = DbType.Int16; parameter.Direction = ParameterDirection.Output; parameter.ParameterName = "@HowManyInfo"; adoptPetParams[3] = parameter; try { using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "proGetMissedInfo", adoptPetParams)) { while (reader.Read()) { CVMissedPetInfo missedPet = new CVMissedPetInfo(); missedPet.MissID = reader["MissID"].ToString(); missedPet.City = reader["City"].ToString(); missedPet.Province = reader["Province"].ToString(); missedPet.MissInfo = reader["MissInfo"].ToString(); missedPet.MissTitle = reader["MissTitle"].ToString(); missedPet.PetCategoryName = reader["PetCategoryName"].ToString(); missedPet.PriorityScore = int.Parse(reader["PriorityScore"].ToString()); missedPet.UserName = reader["UserName"].ToString(); missedPet.PicLocation = reader["PicLocation"].ToString(); missedPet.Portrait = reader["Portrait"].ToString(); missedPet.LinkUrl = reader["LinkUrl"].ToString(); missedPet.UserWeiBo = reader["UserWeiBo"].ToString(); missedPet.Status = reader["Status"].ToString(); bool tempIsRecommand = true; missedPet.IsRecommand = bool.TryParse(reader["IsRecommand"].ToString(), out tempIsRecommand) ? tempIsRecommand : true; bool tempIsEssence = true; missedPet.IsEssence = bool.TryParse(reader["IsEssence"].ToString(), out tempIsEssence) ? tempIsEssence : true; DateTime tempLastEditTime = DateTime.Now; tempLastEditTime = DateTime.TryParse(reader["LastEditTime"].ToString(), out tempLastEditTime) ? tempLastEditTime : DateTime.Now; missedPet.LastEditTime = tempLastEditTime.ToString("yyyy/MM/dd hh:mm:ss"); DateTime tempMissTime = DateTime.Now; tempMissTime = DateTime.TryParse(reader["MissTime"].ToString(), out tempMissTime) ? tempMissTime : DateTime.Now; missedPet.MissTime = tempMissTime.ToString("yyyy/MM/dd hh:mm:ss"); missedPet.IP = reader["IP"].ToString(); int tempFocusNum = 0; missedPet.FocusNum = int.TryParse(reader["FocusNum"].ToString(), out tempFocusNum) ? tempFocusNum : 0; int tempCommentCount = 0; missedPet.CommentCount = int.TryParse(reader["CommentCount"].ToString(), out tempCommentCount) ? tempCommentCount : 0; MissedPetList.Add(missedPet); } reader.Close(); reader.Dispose(); int tempHowmanyPages = 0; howmanyPages = int.TryParse(adoptPetParams[3].Value.ToString(), out tempHowmanyPages) ? tempHowmanyPages : 0; } } catch (Exception ex) { throw; } return(MissedPetList); }
public override IDataReader Security_Get(int SecuredId, int ObjectId, int SecureType) { return(SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "activeforums_Security_Get", SecuredId, ObjectId, SecureType)); }
public override IDataReader Tags_List(int PortalId, int ModuleId, bool IsCategory, int PageIndex, int PageSize, string Sort, string SortColumn, int ForumId, int ForumGroupId) { return((IDataReader)(SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "activeforums_Tags_List", PortalId, ModuleId, IsCategory, PageIndex, PageSize, Sort, SortColumn, ForumId, ForumGroupId))); }
public override IDataReader Security_SearchObjects(int PortalId, string Search) { return(SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "activeforums_Security_SearchObjects", PortalId, Search)); }
public override IDataReader Templates_Get(int TemplateId, int PortalId, int ModuleId) { return((IDataReader)(SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "activeforums_Templates_Get", TemplateId, PortalId, ModuleId))); }
// KR - grabs all settings for caching public override System.Data.IDataReader Settings_ListAll(int ModuleId) { return(SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "activeforums_Settings_ListAll", ModuleId)); }
public override IDataReader Topics_Get(int PortalId, int ModuleId, int TopicId, int ForumId, int UserId, bool WithSecurity) { return((IDataReader)(SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "activeforums_Topics_Get", PortalId, ModuleId, TopicId, ForumId, UserId, WithSecurity))); }
public override IDataReader Subscriptions_GetSubscribers(int PortalId, int ForumId, int TopicId, int Mode) { return((IDataReader)(SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "activeforums_Subscriptions_Subscribers", PortalId, ForumId, TopicId, Mode))); }
public override IDataReader Topics_Replies(int TopicId) { return((IDataReader)(SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "activeforums_Topics_Replies", TopicId))); }
public override IDataReader Tags_Search(int PortalId, int ModuleId, string Search) { return((IDataReader)(SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "activeforums_Tags_Search", PortalId, ModuleId, Search))); }
public override IDataReader GetATI_Base(int ModuleId, int ItemId) { return((IDataReader)SqlHelper.ExecuteReader(ConnectionString, GetFullyQualifiedName("GetATI_Base"), ModuleId, ItemId)); }
public override IDataReader Templates_List(int PortalId, int ModuleId, int TemplateType, int RowIndex, int PageSize) { return((IDataReader)(SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "activeforums_Templates_List", PortalId, ModuleId, TemplateType, RowIndex, PageSize))); }
public override IDataReader GetATI_Previews(int ModuleId) { return((IDataReader)SqlHelper.ExecuteReader(ConnectionString, GetFullyQualifiedName("GetATI_Previews"), ModuleId)); }
public override IDataReader Topics_List(int ForumId, int PortalId, int ModuleId) { return((IDataReader)(SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "activeforums_Topics_List", ForumId, PortalId, ModuleId))); }
/// <summary></summary> protected override SqlDataReader executeReader(string spName, object[] paramValues) { return(SqlHelper.ExecuteReader(base.mConnection, spName, paramValues)); }
public override IDataReader Profiles_GetUsersOnline(int PortalId, int ModuleId, int Interval) { return((IDataReader)(SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "activeforums_UserProfiles_GetUsersOnline", PortalId, ModuleId, Interval))); }
protected void GvTenders_RowDataBound(object sender, GridViewRowEventArgs e) { TableCell cell; TableCell head; for (int i = 0; i < e.Row.Cells.Count; i++) { if (e.Row.RowType == DataControlRowType.Header) { head = e.Row.Cells[i]; if (i >= 3) { double Num; bool isNum = double.TryParse(head.Text.ToString().Trim(), out Num); if (isNum) { VendorIds.Add(head.Text.ToString().Trim()); query = "s3p_EBid_GetVendorNameById"; using (conn = new SqlConnection(connstring)) { using (cmd = new SqlCommand(query, conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@vendorid", Int32.Parse(head.Text.ToString().Trim())); conn.Open(); oReader = cmd.ExecuteReader(); if (oReader.HasRows) { while (oReader.Read()) { head.Attributes.Add("VendorId", head.Text); head.Text = oReader["VendorName"].ToString() + " (" + head.Text + ")"; } } } } } } } //CHANGE HEADER FROM VendorId To VendorName if (e.Row.RowType == DataControlRowType.DataRow) { e.Row.Cells[0].Width = new Unit("30px"); e.Row.Cells[1].Width = new Unit("220px"); e.Row.Cells[2].Width = new Unit("35px"); cell = e.Row.Cells[i]; if (i <= 2) { cell.BackColor = System.Drawing.Color.LightGray; cell.Font.Bold = true; } if (i == 1 && e.Row.Cells[0].Text != "0") { TextBox BidItemx = new TextBox(); BidItemx.ID = e.Row.Cells[0].Text.ToString(); BidItemx.Text = "0"; Label lblR = new Label(); lblR.Text = cell.Text.ToString(); BidItemx.Attributes.Add("class", e.Row.Cells[0].Text.ToString()); BidItemx.Attributes.Add("style", "display:none"); cell.Controls.Add(BidItemx); cell.Controls.Add(lblR); BidDetailNos.Add(e.Row.Cells[0].Text.ToString()); } //VendorId = valus[1]; char[] delimiterChars = { '(' }; string valu = GvTenders.HeaderRow.Cells[i].Text.Replace(")", ""); string[] valus = valu.Split(delimiterChars); if (i >= 3 && e.Row.Cells[1].Text == "Total") { e.Row.Cells[i].Attributes.Add("class", "total" + valus[1].ToString()); } if (i >= 3 && e.Row.Cells[1].Text == "SubTotal") { e.Row.Cells[i].Attributes.Add("class", "subtotal" + valus[1].ToString()); } string curr = ""; if (i >= 3 && e.Row.Cells[0].Text != "0") { //cell.Width = new Unit("140"); cell.Attributes.Add("style", "width:140px;"); HtmlInputRadioButton chk = new HtmlInputRadioButton(); chk.EnableViewState = true; chk.Value = e.Row.Cells[0].Text.ToString(); TextBox txtPrice = new TextBox(); char[] delimiterChars2 = { '|' }; string valu2 = cell.Text; string[] valus2 = valu2.Trim().Split(delimiterChars2); char[] delimiterChars3 = { ' ' }; string[] txtAmount = valus2[0].Trim().Split(delimiterChars3); Label lblR = new Label(); lblR.Attributes.Add("style", "font-weight:bold"); lblR.Text = cell.Text.ToString().Replace("| ", "<br> <span style='font-size:9px;font-style:italic;font-weight:normal'>").Replace("^", "</span>"); //SqlHelper.ExecuteNonQuery(connstring, CommandType.Text, sCommand); if (cell.Text.ToString().Trim() != " ") { string statusTender = ""; sCommand = "SELECT status FROM tblBidTenders WHERE BidDetailNo=" + e.Row.Cells[0].Text.ToString().Trim() + " AND VendorId=" + valus[1].Trim(); oReader = SqlHelper.ExecuteReader(connstring, CommandType.Text, sCommand); if (oReader.HasRows) { oReader.Read(); statusTender = oReader["Status"].ToString(); } oReader.Close(); //Response.Write(statusTender + "<br>"); if (statusTender == "2") { chk.Checked = true; } chk.ID = valus[1].Trim(); chk.Value = valus[1].Trim(); chk.Attributes.Add("onclick", "$('." + e.Row.Cells[0].Text.ToString().Trim() + "').val($(this).val())"); chk.Attributes.Add("class", valus[1].Trim()); if (txtAmount.Length > 1) { chk.Attributes.Add("Amount", txtAmount[1].ToString().Replace(",", "")); txtPrice.Text = txtAmount[1].ToString(); } txtPrice.ID = "amount" + valus[1].Trim(); txtPrice.Attributes.Add("style", "display:none"); cell.Controls.Add(chk); cell.Controls.Add(lblR); cell.Controls.Add(txtPrice); //cell.Text = "<input type='radio' id='" + e.Row.Cells[0].Text.ToString() + "' name='" + e.Row.Cells[0].Text.ToString() + "' value='" + valus[1].Trim() + "' > " + cell.Text; //cell.Text = cell.Text; } else { chk.Disabled = true; cell.Controls.Add(chk); //cell.Text = "<input type='radio' disabled='disabled' name='" + e.Row.Cells[0].Text.ToString() + "' value='" + valus[1].Trim() + "' > " + cell.Text; //cell.Text = cell.Text; } } else if (i >= 3) { //e.Row.Cells[0].Text = e.Row.Cells[1].Text; //e.Row.Cells[0].ColumnSpan = 3; //e.Row.Cells[1].Visible = false; //e.Row.Cells[2].Visible = false; Label lblCurr = new Label(); lblCurr.Text = ""; TextBox txtField = new TextBox(); txtField.EnableViewState = true; txtField.ID = valus[1].ToString(); txtField.Attributes.Add("style", "width:100px"); txtField.Text = cell.Text.ToString() != "" && cell.Text.ToString() != " " ? cell.Text.ToString() : "0"; txtField.Attributes.Add("onblur", "if($(this).val()=='' || $(this).val()==' '){ $(this).val('0.0') }"); txtField.Attributes.Add("class", valus[1].ToString()); if (e.Row.Cells[1].Text != "SubTotal" && e.Row.Cells[1].Text != "Total") { cell.Controls.Add(lblCurr); cell.Controls.Add(txtField); } else { cell.BackColor = Color.FromArgb(211, 211, 211); cell.Font.Bold = true; cell.Font.Size = 8; } } } } }
protected void Save_Click(object sender, EventArgs e) { //判断btn Button btn = (Button)sender; string s = btn.ID; string unitcode = null; string sdateStr = null; string edateStr = null; string FileName = ""; string FileVisualPathStr = ""; string UserName = this.Session["userid"].ToString(); string PathStr = null; string type = null; string ynxsstr = null; if (ynxs.Checked == true) { ynxsstr = "是"; if (string.IsNullOrEmpty(txtSdate.Text) | string.IsNullOrEmpty(txtEdate.Text) | string.IsNullOrEmpty(sxs.Text) | string.IsNullOrEmpty(sfz.Text) | string.IsNullOrEmpty(exs.Text) | string.IsNullOrEmpty(efz.Text)) { mydb.Alert("请选择开始日期或截止日期!"); return; } } else { ynxsstr = "否"; } if (ynxs.Checked == true) { sdateStr = txtSdate.Text + " " + sxs.SelectedValue + sfz.SelectedValue + "00"; edateStr = txtEdate.Text + " " + exs.SelectedValue + efz.SelectedValue + "00"; } else { sdateStr = ""; edateStr = ""; } //判断附件 if (!string.IsNullOrEmpty(fj.PostedFile.FileName.Trim())) { try { PathStr = fj.PostedFile.FileName; if (fj.PostedFile.ContentLength < 1024 * int.Parse(lblAttachSize.Text))//判断附件大小是否小于1024*附件最大值参数 { type = PathStr.Substring((PathStr.LastIndexOf(".") + 1)); if (!string.IsNullOrEmpty(fjname.Text.Trim())) { FileName = fjname.Text + "." + type; } else { FileName = System.IO.Path.GetFileName(fj.PostedFile.FileName); } //if (!System.IO.Directory.Exists((Server.MapPath("..\\..\\") + "Attach\\oa\\rw\\" + UserName))) //{ // System.IO.Directory.CreateDirectory((Server.MapPath("..\\..\\") + "Attach\\oa\\rw\\" + UserName)); //} Random TempNameInt = new Random(); string NewDocDirName = TempNameInt.Next(100000000).ToString(); if (!System.IO.Directory.Exists((Server.MapPath("..\\..\\") + "Attach\\oa\\rw\\" + UserName + "\\" + NewDocDirName))) { System.IO.Directory.CreateDirectory((Server.MapPath("..\\..\\") + "Attach\\oa\\rw\\" + UserName + "\\" + NewDocDirName)); } TempNameInt = null; fj.PostedFile.SaveAs((Server.MapPath("..\\..\\") + "Attach\\oa\\rw\\" + UserName + "\\" + NewDocDirName + "\\" + FileName)); FileVisualPathStr = "\\Attach\\oa\\rw\\" + UserName + "\\" + NewDocDirName + "\\"; } else { mydb.Alert("保存失败,附件大小不能超过 " + lblAttachSize.Text + " KB!"); } } catch (Exception ex) { throw ex; } } //任务单号 unitcode = DateTime.Now.Year.ToString("D2").Substring(0, 4) + DateTime.Now.Month.ToString("D2").Substring(0, 2) + DateTime.Now.Day.ToString("D2").Substring(0, 2); SqlDataReader datar = SqlHelper.ExecuteReader("select rwdh from OA_RWD01 where left(rwdh,8)='" + unitcode + "' order by rwdh desc"); if (datar.Read()) { unitcode = unitcode.Trim() + (Convert.ToInt32(datar["rwdh"].ToString().Substring(8, 3)) + 1).ToString("D3"); } else { unitcode = unitcode + "001"; } datar.Close(); int newID = (Int32)SqlHelper.ExecuteScalar("insert into OA_RWD01(source,rwdh,rwbt,rwnr,jjcd,rwxz,ynxs,ksrq,jzrq,rwzt,fbr,fbsj,fjmc,fjlj,jsdx,fblx,qtld,zrld,zrr,qtbm,zrbm) values('" + hkdb.GetStr(rwly.Text) + "','" + unitcode + "', '" + hkdb.GetStr(rwbt.Text) + "', '" + editor.Value + "', '" + jjcd.SelectedValue + "', '" + rwxz.SelectedValue + "', '" + ynxsstr + "', '" + sdateStr + "', '" + edateStr + "', '录入', '" + this.Session["userid"] + "', GETDATE(), '" + FileName + "', '" + FileVisualPathStr + "','" + hkdb.GetStr(jsdx.Text) + "','3','" + hkdb.GetStr(qtld.Text) + "','" + hkdb.GetStr(zrld.Text) + "','" + hkdb.GetStr(zrr.Text) + "','" + hkdb.GetStr(qtbm.Text) + "','" + hkdb.GetStr(zrbm.Text) + "')" + "SELECT CAST(scope_identity() AS int)"); int i = 0; for (i = 0; i < (jsdx.Text.Split(',')).Length; i++) { SqlHelper.ExecuteSql("insert into OA_RWD02(ssrwid,jsr,jszt) values('" + newID + "','" + jsdx.Text.Split(',')[i] + "','未接收')"); } //判断btn if (s == "SaveAddBtn") { ynxs.Checked = false; txtSdate.Text = ""; txtEdate.Text = ""; sxs.SelectedValue = ""; sfz.SelectedValue = ""; exs.SelectedValue = ""; efz.SelectedValue = ""; rwxz.SelectedValue = ""; fjname.Text = ""; rwbt.Text = ""; jjcd.SelectedValue = "中"; editor.Value = ""; mydb.Alert_Refresh("保存成功,请新增下一条记录!", "fbdbrw.aspx"); } else { mydb.Alert_Refresh_Close("保存成功!", "fbdbrw.aspx"); } }
public override IDataReader Filters_GetEmoticons(int ModuleID) { return((IDataReader)(SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "activeforums_Filters_GetEmoticons", ModuleID))); }