public List<News> News_GetByTop(string Top, string Where, string Order) { List<Data.News> list = new List<Data.News>(); using (SqlCommand dbCmd = new SqlCommand("sp_News_GetByTop", GetConnection())) { Data.News obj = new Data.News(); dbCmd.CommandType = CommandType.StoredProcedure; dbCmd.Parameters.Add(new SqlParameter("@Top", Top)); dbCmd.Parameters.Add(new SqlParameter("@Where", Where)); dbCmd.Parameters.Add(new SqlParameter("@Order", Order)); SqlDataReader dr = dbCmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { list.Add(obj.NewsIDataReader(dr)); } dr.Close(); //conn.Close(); } else { dr.Close(); } } return list; }
public News NewsIDataReader(IDataReader dr) { Data.News obj = new Data.News(); obj.Id = (dr["Id"] is DBNull) ? string.Empty : dr["Id"].ToString(); obj.Name = (dr["Name"] is DBNull) ? string.Empty : dr["Name"].ToString(); obj.Image = (dr["Image"] is DBNull) ? string.Empty : dr["Image"].ToString(); obj.File = (dr["File"] is DBNull) ? string.Empty : dr["File"].ToString(); obj.Content = (dr["Content"] is DBNull) ? string.Empty : dr["Content"].ToString(); obj.Detail = (dr["Detail"] is DBNull) ? string.Empty : dr["Detail"].ToString(); obj.Date = (dr["Date"] is DBNull) ? string.Empty : dr["Date"].ToString(); obj.Priority = (dr["Priority"] is DBNull) ? string.Empty : dr["Priority"].ToString(); obj.Index = (dr["Index"] is DBNull) ? string.Empty : dr["Index"].ToString(); obj.Views = (dr["Views"] is DBNull) ? string.Empty : dr["Views"].ToString(); obj.GroupNewsId = (dr["GroupNewsId"] is DBNull) ? string.Empty : dr["GroupNewsId"].ToString(); obj.GroupName = (dr["GroupName"] is DBNull) ? string.Empty : dr["GroupName"].ToString(); obj.LinkDemo = (dr["LinkDemo"] is DBNull) ? string.Empty : dr["LinkDemo"].ToString(); obj.Description = (dr["Description"] is DBNull) ? string.Empty : dr["Description"].ToString(); obj.Keyword = (dr["Keyword"] is DBNull) ? string.Empty : dr["Keyword"].ToString(); obj.Ord = (dr["Ord"] is DBNull) ? string.Empty : dr["Ord"].ToString(); obj.Active = (dr["Active"] is DBNull) ? string.Empty : dr["Active"].ToString(); return(obj); }
protected void Update_Click(object sender, EventArgs e) { if (Page.IsValid) { Data.News obj = new Data.News(); obj.Id = Id; obj.Name = txtName.Text; obj.Image = txtImage.Text; obj.File = ""; obj.Content = txtContent.Text; obj.Detail = fckDetail.Value; obj.Date = DateTimeClass.ConvertDateTime(txtDate.Text, "MM/dd/yyyy HH:mm:ss"); obj.Index = "0"; obj.Ord = txtOrd.Text != "" ? txtOrd.Text : "1"; obj.Active = chkActive.Checked ? "1" : "0"; obj.Position = ddlPosition.SelectedValue; obj.GroupNewsId = ddlGroupNews.SelectedValue; obj.GroupTagNews = StringClass.NameToTag(ddlGroupNews.SelectedItem.Text); obj.Description = ""; obj.Keyword = ""; obj.Views = "0"; obj.LinkDemo = ""; obj.Language = ddlLanguage.SelectedValue; if (Insert == true) { NewsService.News_Insert(obj); } else { NewsService.News_Update(obj); } BindGrid(where); pnView.Visible = true; pnUpdate.Visible = false; Insert = false; } }
public List<News> News_GetByAll() { List<Data.News> list = new List<Data.News>(); using (SqlCommand dbCmd = new SqlCommand("sp_News_GetByAll", GetConnection())) { Data.News obj = new Data.News(); dbCmd.CommandType = CommandType.StoredProcedure; SqlDataReader dr = dbCmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { list.Add(obj.NewsIDataReader(dr)); } dr.Close(); //conn.Close(); } else { dr.Close(); } } return list; }
protected void Update_Click(object sender, EventArgs e) { if (Page.IsValid){ Data.News obj = new Data.News(); obj.Id = Id; obj.Name = txtName.Text; obj.Tag = Common.StringClass.NameToTag(txtName.Text); obj.Image = txtImage.Text; obj.Content = txtContent.Text; obj.Detail = fckDetail.Value; obj.Date = DateTimeClass.ConvertDateTime(txtDate.Text, "MM/dd/yyyy HH:mm:ss"); obj.Title = txtTitle.Text; obj.Description = txtDescription.Text; obj.Keyword = txtKeyword.Text; obj.Priority = chkPriority.Checked ? "1" : "0"; obj.Index = chkIndex.Checked ? "1" : "0"; obj.Active = chkActive.Checked ? "1" : "0"; obj.Lang = Lang; obj.GroupNewsId = ddlGroupNews.SelectedValue; if (Insert == true){ NewsService.News_Insert(obj); } else{ NewsService.News_Update(obj); } BindGrid(); pnView.Visible = true; pnUpdate.Visible = false; Insert = false; } }
public List<News> News_Paging(string CurentPage, string PageSize) { List<Data.News> list = new List<Data.News>(); using (SqlCommand dbCmd = new SqlCommand("sp_News_Paging", GetConnection())) { Data.News obj = new Data.News(); dbCmd.CommandType = CommandType.StoredProcedure; dbCmd.Parameters.Add(new SqlParameter("@CurentPage", CurentPage)); dbCmd.Parameters.Add(new SqlParameter("@PageSize", PageSize)); SqlDataReader dr = dbCmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { list.Add(obj.NewsIDataReader(dr)); } dr.Close(); //conn.Close(); } else { dr.Close(); } } return list; }