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