private void uptonext()
{
cn.Open();
SqlCommand cmd1 = cn.CreateCommand();
cmd1.CommandType = CommandType.Text;
cmd1.CommandText = "select *from videos where id='" + Request.QueryString["id"] + "' ";
cmd1.ExecuteScalar();
DataSet ds1 = new DataSet();
SqlDataAdapter da1 = new SqlDataAdapter(cmd1);
da1.Fill(ds1);
SqlCommand cmd2 = cn.CreateCommand();
cmd2.CommandType = CommandType.Text;
cmd2.CommandText = "select *from videos where category like '%" + ds1.Tables[0].Rows[0]["category"].ToString() + "%'";
cmd2.ExecuteScalar();
DataSet ds2 = new DataSet();
SqlDataAdapter da2 = new SqlDataAdapter(cmd2);
da2.Fill(ds2);
Repeater3.DataSource = ds2;
Repeater3.DataBind();
cn.Close();
}
private void llenarvista()
{
Repeater3.DataSource = ord.Consultarordenesencuro();
Repeater3.DataBind();
Repeater4.DataSource = ord.Consultarordenescerradas();
Repeater4.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
//DataSet is an in-memory cache of data retrieved from a data source
//step 1: create Dataset with a GET method
DataSet datathriller = GetDataThriller();
DataSet datafiction = GetDataFiction();
DataSet datapaperbacks = GetDataPaperbacks();
DataSet datayoungreaders = GetDataYoungReaders();
DataSet datateens = GetDataTeens();
//DataSource is used to pull the data from the database and populate them
//step 8: pull data using DataSource
Repeater1.DataSource = datathriller;
Repeater2.DataSource = datafiction;
Repeater3.DataSource = datapaperbacks;
Repeater4.DataSource = datayoungreaders;
Repeater5.DataSource = datateens;
//step 9: bind the data to the repeater
Repeater1.DataBind();
Repeater2.DataBind();
Repeater3.DataBind();
Repeater4.DataBind();
Repeater5.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["pid"] != null)
{
Session["pid"] = null;
}
SqlDataAdapter adp = new SqlDataAdapter("select * from products order by newid()", ConfigurationManager.ConnectionStrings["cn"].ConnectionString);
DataSet ds = new DataSet();
adp.Fill(ds, 0, 9, "products");
Repeater1.DataSource = ds;
Repeater1.DataBind();
Repeater1.DataBind();
SqlDataAdapter adp2 = new SqlDataAdapter("select * from products order by newid()", ConfigurationManager.ConnectionStrings["cn"].ConnectionString);
DataSet ds2 = new DataSet();
adp2.Fill(ds2, 0, 4, "products");
Repeater2.DataSource = ds2;
Repeater2.DataBind();
SqlDataAdapter adp3 = new SqlDataAdapter("select * from products order by newid()", ConfigurationManager.ConnectionStrings["cn"].ConnectionString);
DataSet ds3 = new DataSet();
adp3.Fill(ds3, 0, 4, "products");
Repeater3.DataSource = ds3;
Repeater3.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
DataSetTableAdapters.TBLHAKKIMDATableAdapter dt = new DataSetTableAdapters.TBLHAKKIMDATableAdapter();
Repeater1.DataSource = dt.HakkimdaListele();
Repeater1.DataBind();
DataSetTableAdapters.TBLDENEYIMTableAdapter dtDeneyim = new DataSetTableAdapters.TBLDENEYIMTableAdapter();
Repeater2.DataSource = dtDeneyim.DeneyimListesi();
Repeater2.DataBind();
DataSetTableAdapters.TBLEGITIMTableAdapter dtEgitim = new DataSetTableAdapters.TBLEGITIMTableAdapter();
Repeater3.DataSource = dtEgitim.EgitimListesi();
Repeater3.DataBind();
DataSetTableAdapters.TBLHOBILERTableAdapter dtHobiler = new DataSetTableAdapters.TBLHOBILERTableAdapter();
Repeater5.DataSource = dtHobiler.HobilerListele();
Repeater5.DataBind();
DataSetTableAdapters.TBLODULLERTableAdapter dtOdul = new DataSetTableAdapters.TBLODULLERTableAdapter();
Repeater6.DataSource = dtOdul.OdulListesi();
Repeater6.DataBind();
DataSetTableAdapters.TBLYETENEKLERTableAdapter dtYetenek = new DataSetTableAdapters.TBLYETENEKLERTableAdapter();
Repeater4.DataSource = dtYetenek.YetenekListesi();
Repeater4.DataBind();
DataSetTableAdapters.TBLHAKKIMDATableAdapter dtFotograf = new DataSetTableAdapters.TBLHAKKIMDATableAdapter();
Repeater8.DataSource = dtFotograf.HakkimdaListele();
Repeater8.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Login())
{
if ((Request.QueryString["id1"] != null && Request.QueryString["id1"].Length != 0))
{
Repeater1.DataSource = DatabaseConnection.SecureCreateDataset("SELECT COMPANYNAME, EMAIL, SHIPMENTEMAIL, WAREHOUSEEMAIL FROM BASE_COMPANIES WHERE EMAIL<>'' AND ID=@ID", new DbSqlParameter("@ID", int.Parse(Request.QueryString["id1"]).ToString()));
}
if ((Request.QueryString["id2"] != null && Request.QueryString["id2"].Length != 0))
{
Repeater2.DataSource = DatabaseConnection.SecureCreateDataset("SELECT NAME, SURNAME, EMAIL FROM BASE_CONTACTS WHERE EMAIL<>'' AND ID=@ID", new DbSqlParameter("@ID", int.Parse(Request.QueryString["id2"]).ToString()));
}
if ((Request.QueryString["id3"] != null && Request.QueryString["id3"].Length != 0))
{
Repeater3.DataSource = DatabaseConnection.SecureCreateDataset("SELECT NAME, SURNAME, COMPANYNAME, EMAIL FROM CRM_LEADS WHERE EMAIL<>'' AND ID=@ID", new DbSqlParameter("@ID", int.Parse(Request.QueryString["id3"]).ToString()));
}
Repeater1.DataBind();
Repeater2.DataBind();
Repeater3.DataBind();
if (Repeater1.Items.Count == 0 && Repeater2.Items.Count == 0 && Repeater3.Items.Count == 0)
{
Info.Text = Root.rm.GetString("NoMail");
}
}
}
protected void dsCart_OnLoad(object sender, EventArgs e)
{
DataTable cart = Session["cart_items"] as DataTable;
Repeater3.DataSource = cart;
Repeater3.DataBind();
}
public void databind()
{
try
{
int c = 1;
string str = "select top 10 * from product where _special_offer=" + c + "";
DataSet ds = DB.dataSet(str);
Repeater4.DataSource = ds.Tables[0];
Repeater4.DataBind();
/*----------------- hot--------------*/
string str2 = @"select * from product where _id
in (select top 10 _product_id from orderdetail group by _product_id order by sum(_product_count) )";
DataSet ds2 = DB.dataSet(str2);
Repeater2.DataSource = ds2;
Repeater2.DataBind();
/*----------------- time--------------*/
string str3 = "select top 10 * from product order by _id desc";
DataSet ds3 = DB.dataSet(str3);
Repeater3.DataSource = ds3.Tables[0];
Repeater3.DataBind();
}
catch
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string cookiename = null;
try
{
//通过存入的cookie来判断是否登录过
FormsAuthenticationTicket ticke = null;
string user = Request.Cookies["user"].Value;
ticke = FormsAuthentication.Decrypt(user);
cookiename = ticke.Name;
lblogin.Text = "欢迎您!" + cookiename;
}
catch (Exception)
{
if (cookiename == null)
{
lblogin.Text = "还没登陆，请登录!";
}
}
//登录完成，右上角显示临时购物车
Repeater3.DataSource = BLL.UserBLL.CartList(cookiename);
Repeater3.DataBind();
//购物车数量
num = BLL.UserBLL.CountNum(cookiename);
//分类展示
Repeater1.DataSource = BLL.UserBLL.CategoryList();
Repeater1.DataBind();
}
}
public void SetSameFamous()
{
DataSet m_ds = AstroBiz.GetInstance().GetSameFamous(m_astro);
if (m_ds != null && m_ds.Tables.Count == 15)
{
SortedList m_star = PublicValue.GetAstroStar();
DataTable m_stars = new DataTable();
m_stars.Columns.Add("starname");
m_stars.Columns.Add("gong");
for (int i = 0; i < 10; i++)
{
DataRow m_dr = m_stars.NewRow();
m_dr["starname"] = m_star[i + 1];
m_dr["gong"] = m_astro.Stars[i].Gong;
m_stars.Rows.Add(m_dr);
}
for (int i = 5; m_star.Count > 5;)
{
m_star.RemoveAt(i);
}
ViewState["samefamous"] = m_ds;
Repeater1.DataSource = m_star;
Repeater1.DataBind();
Repeater3.DataSource = m_stars;
Repeater3.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
var bloglar = from s in db.TBLBLOCG.ToList()
orderby s.BLOGID descending
select s;
if (!IsPostBack)
{
lGetBlog();
}
var bloglarRight = (from s in db.TBLBLOCG
orderby s.BLOGID descending
select s).Take(5).ToList();
Repeater3.DataSource = bloglarRight;
Repeater3.DataBind();
var category = db.TBLCATEGORY.ToList();
Repeater2.DataSource = category;
Repeater2.DataBind();
var commRight = (from c in db.TBLCOMMENT
orderby c.CMTID descending
select c).Take(5).ToList();
RepSonComment.DataSource = commRight;
RepSonComment.DataBind();
}
private void bindApp()
{
DataView dvApp = Epoint.MisBizLogic2.DB.ExecuteDataView("select AppGuid,AppName from RG_Application order by OrderNum desc");
Repeater3.DataSource = dvApp;
Repeater3.DataBind();
}
protected void search_btn3_Click(object sender, EventArgs e)
{
string connStr = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
//string sql = "select no رقم_القائمة , CONVERT(DATE , date, 102) تاريخ ,type, work ملاحظة ,FORMAT([money], 'C', 'en-us') المبلغ ,FORMAT([money], 'N', 'en-us') from [e_work] where(CONVERT(DATE , date, 102) between '" + date1.Value + "' and '" + date2.Value + "') and type =N'" + cmbTypes.SelectedValue + "'";
string sql = "SELECT type , FORMAT(sum(money), 'C', 'en-us') AS المبلغ , FORMAT(sum(money), 'N', 'en-us') AS المبلغ1 FROM e_work where( [date] between '" + date1.Value + "' and '" + date2.Value + "') GROUP BY type";
SqlDataAdapter adap = new SqlDataAdapter(sql, conn);
DataTable dt = new DataTable();
adap.Fill(dt);
Repeater3.DataSource = dt;
Repeater3.DataBind();
double total = 0;
foreach (DataRow row in dt.Rows)
{
double x = Convert.ToDouble(row[1].ToString().Replace("$", ""));
total += x;
}
lblTotal3.Text = Math.Round(total, 2).ToString() + "$";
lblDateFrom3.Text = date1.Value;
lblDateTo3.Text = date2.Value;
report1.Visible = false;
report2.Visible = false;
report3.Visible = true;
}
public void llenarProyectos()
{
mod_gi.idGrupoInvestigacion = Session["IdGrupo_pag"].ToString();
DT_Grupo = mod_grupo.consultarProyectosAct(mod_gi);
Repeater3.DataSource = DT_Grupo;
Repeater3.DataBind();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
txtwuliao.Text = "";
txtFModel.Text = "";
string FNumber = txtFNumber_xx.Text;
string FName = txtFName_xx.Text;
string FModel = txtFModel_xx.Text;
decimal Amount = string.IsNullOrEmpty(txtAmount_xx.Text) ? 0 : Convert.ToDecimal(txtAmount_xx.Text);
decimal Price = Convert.ToDecimal(txtPrice_xx.Text);
decimal Total = string.IsNullOrEmpty(txtTotal_xx.Text) ? 0 : Convert.ToDecimal(txtTotal_xx.Text);
int FInterID = Convert.ToInt32(danju_no.Text);
if (Total > 0)
{
//新增物料
string sql = string.Format(@"insert into fahuodan_wl(FNumber,FName,FModel,Amount,Price,Total,FInterID)
VALUES('{0}','{1}','{2}',{3},{4},{5},{6})", FNumber, FName, FModel, Amount, Price, Total, FInterID);
SqlHelper1.ExecteNonQueryText(sql, null);
//Response.Write("<script>alert('物料添加成功！');location='javascript:history.go(-1);'</script>");
txtwuliao.Focus();
//查询物料显示在表3
sql = string.Format(@"select FName,FModel,Amount,Price,Total from fahuodan_wl where FInterID={0} order by Id desc", FInterID);
DataTable dt = SqlHelper1.getTable(sql, null);
Repeater3.DataSource = dt;
Repeater3.DataBind();
}
else
{
Response.Write("<script>alert('金额为零，请点击金额计算按钮！');location='javascript:history.go(-1);'</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
DataSet1TableAdapters.HAKKIMDATableAdapter dt = new DataSet1TableAdapters.HAKKIMDATableAdapter();
Repeater1.DataSource = dt.HakkımdaListele();
Repeater1.DataBind();
DataSet1TableAdapters.DENEYIMTableAdapter dt1 = new DataSet1TableAdapters.DENEYIMTableAdapter();
Repeater2.DataSource = dt1.DeneyimListele();
Repeater2.DataBind();
DataSet1TableAdapters.EGITIMTableAdapter dt2 = new DataSet1TableAdapters.EGITIMTableAdapter();
Repeater3.DataSource = dt2.EgitimListesi();
Repeater3.DataBind();
DataSet1TableAdapters.YETENEKLERTableAdapter dt3 = new DataSet1TableAdapters.YETENEKLERTableAdapter();
Repeater4.DataSource = dt3.YetenekListele();
Repeater4.DataBind();
DataSet1TableAdapters.HOBILERTableAdapter dt4 = new DataSet1TableAdapters.HOBILERTableAdapter();
Repeater5.DataSource = dt4.HobiListesi();
Repeater5.DataBind();
DataSet1TableAdapters.KONFERANSTableAdapter dt5 = new DataSet1TableAdapters.KONFERANSTableAdapter();
Repeater6.DataSource = dt5.KonferansListele();
Repeater6.DataBind();
}
public void RoomDataBind()
{
string constr = ConfigurationManager.ConnectionStrings["HotelConString"].ConnectionString;
SQLiteConnection con = new SQLiteConnection(constr);
con.Open();
string query = "select room.id,roomtype,info,charge,customer.name,customer.id as customerid from room,customer where room.customer_id=customer.id;";
SQLiteCommand cmd = new SQLiteCommand(query, con);
SQLiteDataAdapter sda = new SQLiteDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
Repeater1.DataSource = dt;
Repeater1.DataBind();
query = "select id,roomtype,info,charge from room where customer_id is NULL;";
SQLiteCommand cmd2 = new SQLiteCommand(query, con);
SQLiteDataAdapter sda2 = new SQLiteDataAdapter(cmd2);
DataTable dt2 = new DataTable();
sda2.Fill(dt2);
Repeater3.DataSource = dt2;
Repeater3.DataBind();
con.Close();
}
protected void OnUpdate(object sender, EventArgs e)
{
//Find the reference of the Repeater Item.
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int ID = int.Parse((item.FindControl("lblID") as Label).Text);
string subject = (item.FindControl("txtSubj") as TextBox).Text.Trim();
string homework = (item.FindControl("txtHomework") as TextBox).Text.Trim();
var checkHomework = (from c in db.Homeworks where c.ID.Equals(ID) select c).FirstOrDefault();
checkHomework.Subject = subject;
checkHomework.Homework1 = homework;
db.SubmitChanges();
Repeater1.DataBind();
Repeater2.DataBind();
Repeater3.DataBind();
Repeater4.DataBind();
Repeater5.DataBind();
Repeater6.DataBind();
Repeater7.DataBind();
Repeater8.DataBind();
Repeater8.DataBind();
Repeater9.DataBind();
Repeater10.DataBind();
Repeater11.DataBind();
Repeater12.DataBind();
Repeater13.DataBind();
Repeater14.DataBind();
Repeater15.DataBind();
}
protected void OnDelete(object sender, EventArgs e)
{
//Find the reference of the Repeater Item.
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
int ID = int.Parse((item.FindControl("lblID") as Label).Text);
var checkHomework = (from c in db.Homeworks where c.ID.Equals(ID) select c).FirstOrDefault();
db.Homeworks.DeleteOnSubmit(checkHomework);
db.SubmitChanges();
Repeater1.DataBind();
Repeater2.DataBind();
Repeater3.DataBind();
Repeater4.DataBind();
Repeater5.DataBind();
Repeater6.DataBind();
Repeater7.DataBind();
Repeater8.DataBind();
Repeater8.DataBind();
Repeater9.DataBind();
Repeater10.DataBind();
Repeater11.DataBind();
Repeater12.DataBind();
Repeater13.DataBind();
Repeater14.DataBind();
Repeater15.DataBind();
}
protected void bindElit()
{
DataTable dt = b_Ask.Sel("Elite=1", "ID desc", null);
Repeater3.DataSource = dt;
Repeater3.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (var db = new CstwebEntities())
{
var se1 = from it in db.news
where it.@class == 14
orderby it.time descending
select it;
Repeater1.DataSource = se1.Take(7).ToList();
var se2 = from it in db.news
where it.@class == 1
orderby it.time descending
select it;
Repeater2.DataSource = se2.Take(7).ToList();
var se3 = from it in db.news
where it.@class == 4
orderby it.time descending
select it;
Repeater3.DataSource = se3.Take(7).ToList();
Repeater1.DataBind();
Repeater2.DataBind();
Repeater3.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Label1.Text = Session["user"].ToString();
ArrayList names = new ArrayList {
"@user"
};
ArrayList values = new ArrayList {
Session["user"].ToString()
};
DataSet ds = Database.RunSP("sp_icons_selectSome", names, values);
Repeater1.DataSource = ds;
Repeater1.DataBind();
//Response.Write(Session["user"]);
ArrayList names1 = new ArrayList {
};
ArrayList values1 = new ArrayList {
};
//this is the table from the recommended sites
DataSet ds1 = Database.RunSP("sp_Rec_selectAll", names1, values1);
Repeater2.DataSource = ds1;
Repeater2.DataBind();
Repeater3.DataSource = ds1;
Repeater3.DataBind();
Repeater4.DataSource = ds1;
Repeater4.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
int id;
if (!int.TryParse(Request.QueryString["id"], out id))
{
Response.Redirect("~/MediaCenter.aspx");
}
Database db = new Database();
Lang lang = new Lang();
db.AddParameter("@lang", lang.getCurrentLang());
DataTable dt = db.ExecuteDataTable("select top(3) * from SocialEvent where lang=@lang Order by id desc");
Repeater2.DataSource = dt;
Repeater2.DataBind();
db.AddParameter("@lang", lang.getCurrentLang());
dt = db.ExecuteDataTable("select top(3) * from news where lang=@lang Order by id desc");
Repeater1.DataSource = dt;
Repeater1.DataBind();
db.AddParameter("@lang", lang.getCurrentLang());
db.AddParameter("@id", id);
dt = db.ExecuteDataTable("select * from news where lang=@lang and id=@id");
Repeater3.DataSource = dt;
Repeater3.DataBind();
if (dt.Rows.Count == 0)
{
Response.Redirect("~/MediaCenter.aspx");
}
}
}
/// <summary>
/// 工程项目考核汇总表
/// </summary>
private void Bindgcxmkhhzb()
{
string strsql = "select * from tunnel_newstype where IsDel=0 and parentid=21";
DataSet das = Tunnel.Data.DbHelperSQL.Query(strsql);
if (das.Tables[0].Rows.Count > 0)
{
Repeater10.DataSource = das;
Repeater10.DataBind();
Repeater10.Visible = true;
string strsql2 = "select top " + gettop(8 - das.Tables[0].Rows.Count) + " * from tunnel_index where typeid=21 and del=0 and IsDel=0 order by setdate desc ";
DataSet das2 = Tunnel.Data.DbHelperSQL.Query(strsql2);
Repeater3.DataSource = das2;
Repeater3.DataBind();
}
else
{
string strsql2 = "select top 8 * from tunnel_index where typeid=21 and del=0 and IsDel=0 order by setdate desc";
DataSet das2 = Tunnel.Data.DbHelperSQL.Query(strsql2);
Repeater3.DataSource = das2;
Repeater3.DataBind();
Repeater3.Visible = true;
Repeater10.Visible = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int CourseId = Convert.ToInt32(Request.Params["CourseId"]);
StuNum = new CourseManege().QueryStuNum(CourseId);
coursename.Text = (new CourseManege().queryCourseById(CourseId)).CourseName;
List <Model.Class> clalist = new CourseManege().queryClassByCourseId(CourseId);
string ClassId;
foreach (Model.Class Class in clalist)
{
ClassId = Class.ClassId;
ddlclass.Items.Add(ClassId);
}
List <Students> stulist = new StudentManage().queryStudentByCourseId(CourseId);
foreach (Students stu in stulist)
{
stu.KqNum = new KqManage().queryStuKqNum(stu.StuId, CourseId);
stu.HwNum = new HomeworkManage().queryStuHwNum(stu.StuId, CourseId);
}
Repeater1.DataSource = stulist;
Repeater1.DataBind();
List <Homework> HwList = new HomeworkManage().queryAllHKByTea(CourseId);
DataList2.DataSource = HwList;
DataList2.DataBind();
List <KQ> KqList = new KqManage().queryAllKq(CourseId);
Repeater2.DataSource = KqList;
Repeater2.DataBind();
List <JXGG> gglist = new GGManage().LookJXGG(CourseId);
Repeater3.DataSource = gglist;
Repeater3.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
string strQuery = "";
if (Request.QueryString["Id"] != null)
{
strQuery = Request.QueryString["Id"].ToString();
}
Call_Database ChapelDB = new Call_Database();
Repeater1.DataSource = ChapelDB.dbChapelBuilding;
Repeater1.DataBind();
Repeater2.DataSource = ChapelDB.dbHarmonyWall;
Repeater2.DataBind();
Repeater3.DataSource = ChapelDB.dbHopeWall;
Repeater3.DataBind();
Repeater4.DataSource = ChapelDB.dbFaithWall;
Repeater4.DataBind();
Repeater5.DataSource = ChapelDB.dbGraceWall;
Repeater5.DataBind();
Repeater6.DataSource = ChapelDB.dbPeaceWall;
Repeater6.DataBind();
Repeater7.DataSource = ChapelDB.dbChairsBenches;
Repeater7.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
DataSet1TableAdapters.HakkimdaTableAdapter dt = new DataSet1TableAdapters.HakkimdaTableAdapter();
Repeater1.DataSource = dt.HakkimdaListele();
Repeater1.DataBind();
DataSet1TableAdapters.DeneyimlerTableAdapter dt2 = new DataSet1TableAdapters.DeneyimlerTableAdapter();
Repeater2.DataSource = dt2.DeneyimListesi();
Repeater2.DataBind();
DataSet1TableAdapters.EgitimTableAdapter dt3 = new DataSet1TableAdapters.EgitimTableAdapter();
Repeater3.DataSource = dt3.EgitimListele();
Repeater3.DataBind();
DataSet1TableAdapters.OdullerimTableAdapter dt4 = new DataSet1TableAdapters.OdullerimTableAdapter();
Repeater4.DataSource = dt4.OdullerimListele();
Repeater4.DataBind();
DataSet1TableAdapters.HobilerimTableAdapter dt5 = new DataSet1TableAdapters.HobilerimTableAdapter();
Repeater5.DataSource = dt5.HobilerListele();
Repeater5.DataBind();
DataSet1TableAdapters.YeteneklerimTableAdapter dt6 = new DataSet1TableAdapters.YeteneklerimTableAdapter();
Repeater6.DataSource = dt6.YeteneklerimDoldur();
Repeater6.DataBind();
}
protected void LinkButton1_Command(object sender, CommandEventArgs e)
{
string cookiename = null;
try
{
//再用户添加购物车时，先判断用户有没有登录，如果没有登录则跳转至登录页面，再进行添加购物车操作
FormsAuthenticationTicket ticke = null;
string user = Request.Cookies["user"].Value;
ticke = FormsAuthentication.Decrypt(user);
cookiename = ticke.Name;
}
catch (Exception) {
Response.Redirect("account.aspx");
}
if (cookiename != null)
{
//有cookie则进行添加购物车操作
string id = e.CommandArgument.ToString();
DataTable data = BLL.UserBLL.QueryInfo(id);
string name = data.Rows[0]["Name"].ToString();
string newImage = "../" + data.Rows[0]["NewImage"];
decimal newPrice = Convert.ToDecimal(data.Rows[0]["Newprice"]);
BLL.UserBLL.AddToCart(newImage, name, newPrice, cookiename);
Repeater3.DataSource = BLL.UserBLL.CartList(cookiename);
Repeater3.DataBind();
num = BLL.UserBLL.CountNum(cookiename);
}
}
protected void Page_Load(object sender, EventArgs e)
{
DataSet1TableAdapters.TBLHAKKIMDATableAdapter dt = new DataSet1TableAdapters.TBLHAKKIMDATableAdapter();
Repeater1.DataSource = dt.HakkımdaListele();
Repeater1.DataBind();
DataSet1TableAdapters.TBLDENEYIMTableAdapter dt2 = new DataSet1TableAdapters.TBLDENEYIMTableAdapter();
Repeater2.DataSource = dt2.DeneyimListesi();
Repeater2.DataBind();
DataSet1TableAdapters.TBLEGITIMTableAdapter dt3 = new DataSet1TableAdapters.TBLEGITIMTableAdapter();
Repeater3.DataSource = dt3.EgitimListesi();
Repeater3.DataBind();
DataSet1TableAdapters.TBLYETENEKLERTableAdapter dt4 = new DataSet1TableAdapters.TBLYETENEKLERTableAdapter();
Repeater4.DataSource = dt4.YetenekListesi();
Repeater4.DataBind();
DataSet1TableAdapters.TBLHOBILERTableAdapter dt5 = new DataSet1TableAdapters.TBLHOBILERTableAdapter();
Repeater5.DataSource = dt5.HobiListesi();
Repeater5.DataBind();
DataSet1TableAdapters.TBLKULUPLERTableAdapter dt6 = new DataSet1TableAdapters.TBLKULUPLERTableAdapter();
Repeater6.DataSource = dt6.KuluplerListesi();
Repeater6.DataBind();
DataSet1TableAdapters.TBLHAKKIMDATableAdapter dt7 = new DataSet1TableAdapters.TBLHAKKIMDATableAdapter();
Repeater7.DataSource = dt7.HakkımdaListele();
Repeater7.DataBind();
}
private void worker_ListBoxInBlackListEvent(List <DataClassString4> listForShow)
{
if (RadioButtonList1.SelectedValue == "1")
{
Repeater3.DataSource = listForShow;
Repeater3.DataBind();
}
}