protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["Businessid"] != "") { string selectsql = "select * from [Business_Index] where businessuid='" + Request.QueryString["Businessid"].ToString() + "'"; DataTable dt = DbHelperOleDb.Fill(selectsql); string selectsql1 = "select * from [Business_Suosuo] where businessuid='" + Request.QueryString["Businessid"].ToString() + "'"; DataTable dt1 = DbHelperOleDb.Fill(selectsql1); Jianjie = dt.Rows[0]["jianjie"].ToString(); Zhuying = dt.Rows[0]["zhuying"].ToString(); Biaoqian = dt.Rows[0]["biaoqian"].ToString(); Baiducodes = dt.Rows[0]["baiducodes"].ToString(); Shanghunneirong = dt.Rows[0]["shanghuneirong"].ToString(); Smallimage = dt.Rows[0]["bgimage"].ToString(); Bgimage = dt.Rows[0]["image"].ToString(); Businessmc = dt1.Rows[0]["Businessmc"].ToString(); Businessaddress1 = dt1.Rows[0]["Businessaddress"].ToString(); Tel = dt1.Rows[0]["tel"].ToString(); Xianshiyouhui = dt1.Rows[0]["xianshiyouhui"].ToString(); } else { Response.Redirect("../WebBusiness/Page_BusinessLogin.aspx"); } } }
private void Paging() { int pageSize = 5; object session = Session["Business_SuosuoCount"]; int sum = Convert.ToInt32(session) / pageSize + 1; object obj = Request.QueryString["page"]; int page = 0; if (obj != null) { if (!int.TryParse(obj.ToString(), out page)) { page = 1; } } else { page = 1; } if (page > sum) { page = 1; } string sql = "SELECT TOP " + pageSize + " * FROM (SELECT TOP " + pageSize * page + " * FROM Business_Suosuo ORDER BY id DESC) ORDER BY id asc"; DataTable dt = DbHelperOleDb.Fill(sql); repearter_shanghu.DataSource = dt; repearter_shanghu.DataBind(); }
protected void DropDownList_dizhi_SelectedIndexChanged1(object sender, EventArgs e) { string sql = "select * from [Domain_Address] where [SAddressid]='" + DropDownList_dizhi.SelectedValue + "'"; DataTable dt = DbHelperOleDb.Fill(sql); DropDownList2.DataSource = dt; DropDownList2.DataTextField = "AddressName"; DropDownList2.DataValueField = "Addressid"; DropDownList2.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string sql = "select top 10 * from [T_Preferential] where [shenhe]='已审核' order by [creatime] desc "; DataTable dt = DbHelperOleDb.Fill(sql); repeater1.DataSource = dt; repeater1.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { object session = Session["Business_SuosuoCount"]; if (session == null) { string sql = "select count(*) from [Business_Suosuo]"; Count = DB.FindString(sql); Session["Business_SuosuoCount"] = Count; } Paging(); object obj = Request.QueryString["page"]; if (!IsPostBack && obj == null) { if (Request.QueryString["BusinessGroup"] != null) { string sqlcount = "select count(*) from [Business_Suosuo] where [businessuid] in (select Businessuid from [Business_Info] where BusinessGroup='" + Request.QueryString["BusinessGroup"].ToString().Trim() + "') "; Count = DB.FindString(sqlcount); string sql = "select top 10 * from [Business_Suosuo] where [businessuid] in (select Businessuid from [Business_Info] where BusinessGroup='" + Request.QueryString["BusinessGroup"].ToString().Trim() + "') "; DataTable dt = DbHelperOleDb.Fill(sql); repearter_shanghu.DataSource = dt; repearter_shanghu.DataBind(); } if (Request.QueryString["BusinessAddress1"] != null) { string sqlcount = "select count(*) from [Business_Suosuo] where [businessuid] in (select Businessuid from [Business_Info] where BusinessAddress1='" + Request.QueryString["BusinessAddress1"].ToString().Trim() + "') "; Count = DB.FindString(sqlcount); string sql = "select top 10 * from [Business_Suosuo] where [businessuid] in (select Businessuid from [Business_Info] where BusinessAddress1='" + Request.QueryString["BusinessAddress1"].ToString().Trim() + "') "; DataTable dt = DbHelperOleDb.Fill(sql); repearter_shanghu.DataSource = dt; repearter_shanghu.DataBind(); } if (Request.QueryString["BusinessAddress2"] != null) { string sqlcount = "select count(*) from [Business_Suosuo] where [businessuid] in (select Businessuid from [Business_Info] where BusinessAddress2='" + Request.QueryString["BusinessAddress2"].ToString().Trim() + "') "; Count = DB.FindString(sqlcount); string sql = "select top 10 * from [Business_Suosuo] where [businessuid] in (select Businessuid from [Business_Info] where BusinessAddress2='" + Request.QueryString["BusinessAddress2"].ToString().Trim() + "') "; DataTable dt = DbHelperOleDb.Fill(sql); repearter_shanghu.DataSource = dt; repearter_shanghu.DataBind(); } if (Request.QueryString["BusinessGroup"] == null && Request.QueryString["BusinessAddress1"] == null && Request.QueryString["BusinessAddress2"] == null) { string sqlcount = "select count(*) from [Business_Suosuo]"; Count = DB.FindString(sqlcount); string sql = "select top 10 * from [Business_Suosuo] "; DataTable dt = DbHelperOleDb.Fill(sql); repearter_shanghu.DataSource = dt; repearter_shanghu.DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { //绑定是否显示优惠 if (!IsPostBack) { if (Session["uid"] != null) { string isxianshi = "SELECT * from [T_Preferential] where [Businessuid]='" + Session["uid"].ToString() + "'"; DataTable dtyh = DbHelperOleDb.Fill(isxianshi); DropDownList_yh.DataSource = dtyh; DropDownList_yh.DataValueField = "ptitle"; DropDownList_yh.DataTextField = "ptitle"; DropDownList_yh.DataBind(); Businessid = Session["uid"].ToString(); //this.Label_uid.Text = Session["uid"].ToString(); //查询表中是否有记录,有责update,无则添加 string sql = "select count(*) from [Business_Suosuo] where businessuid='" + Session["uid"].ToString() + "'"; string records = DB.FindString(sql); //Response.Write(records); // 添加 if (Convert.ToInt32(records) > 0) { string selectsql = "select * from [Business_Suosuo] where businessuid='" + Session["uid"].ToString() + "'"; DataTable dt = DbHelperOleDb.Fill(selectsql); TextBox_Businessmc.Text = dt.Rows[0]["Businessmc"].ToString(); //FileUpload_Image.FileName = dt.Rows[0]["Businessimg"].ToString(); TextBox_address.Text = dt.Rows[0]["Businessaddress"].ToString(); TextBox_tel.Text = dt.Rows[0]["tel"].ToString(); TextBox_jj.Text = dt.Rows[0]["jianjie"].ToString(); DropDownList_yh.Text = dt.Rows[0]["xianshiyouhui"].ToString(); } string sqlindex = "select count(*) from [Business_Index] where businessuid='" + Session["uid"].ToString() + "'"; string recordsindex = DB.FindString(sql); if (Convert.ToInt32(recordsindex) > 0) { string selectsql = "select * from [Business_Index] where businessuid='" + Session["uid"].ToString() + "'"; DataTable dt = DbHelperOleDb.Fill(selectsql); TextBox_jianjie.Text = dt.Rows[0]["jianjie"].ToString(); TextBox_zhuying.Text = dt.Rows[0]["zhuying"].ToString(); TextBox_biaoqian.Text = dt.Rows[0]["biaoqian"].ToString(); TextBox_baidu.Text = dt.Rows[0]["baiducodes"].ToString(); CKEditorControl1.Text = dt.Rows[0]["shanghuneirong"].ToString(); } } else { Response.Redirect("../WebBusiness/Page_BusinessLogin.aspx"); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["uid"] != null) { Businessid = Session["uid"].ToString(); Label_uid.Text = Session["uid"].ToString(); string sql = "select * from [T_Preferential] where [Businessuid]='" + Session["uid"].ToString() + "'"; DataTable dt = DbHelperOleDb.Fill(sql); GridView1.DataSource = dt; GridView1.DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["Meber_uid"] != null) { this.Label_uid.Text = Session["Meber_uid"].ToString(); string sql = "SELECT * FROM [Member_info] WHERE [Memberuid]='" + this.Label_uid.Text.Trim() + "'"; DataTable dt = DbHelperOleDb.Fill(sql); this.Label_Email.Text = dt.Rows[0]["Email"].ToString(); this.Label_Tel.Text = dt.Rows[0]["Mobile"].ToString(); this.Label_IP.Text = dt.Rows[0]["IP"].ToString(); this.Label_time.Text = dt.Rows[0]["createtime"].ToString(); } else { Response.Redirect("../WebMember/Page_MemberLogin.aspx"); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string sql = "select top 12 * from [Business_Info] where [shenhe]='已审核' order by [createtime] desc "; DataTable dt = DbHelperOleDb.Fill(sql); Repeater_BusinessNew.DataSource = dt; Repeater_BusinessNew.DataBind(); string sql1 = "select top 10 * from [T_Preferential] where [shenhe]='已审核' order by [creatime] desc "; DataTable dt1 = DbHelperOleDb.Fill(sql1); repeater_yh.DataSource = dt1; repeater_yh.DataBind(); string sql2 = "select top 10 * from [Member_info] order by [createtime] desc "; DataTable dt2 = DbHelperOleDb.Fill(sql2); Repeater2.DataSource = dt2; Repeater2.DataBind(); } }
/// <summary> /// 搜索事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Button1_Click(object sender, EventArgs e) { if (TextBox1.Text.Trim() != "") { DataTable dt = new DataTable(); string sql = "select * from [Business_Suosuo] where [Businessmc] like '%" + TextBox1.Text.Trim().Trim() + "%'"; dt = DbHelperOleDb.Fill(sql); if (dt.Rows.Count == 0) { string sql2 = "select * from [Business_Suosuo] where [Businessaddress] like '%" + TextBox1.Text.Trim().Trim() + "%'"; dt = DbHelperOleDb.Fill(sql2); } if (dt.Rows.Count == 0) { string sql3 = "select * from [Business_Suosuo] where [jianjie] like '%" + TextBox1.Text.Trim().Trim() + "%'"; dt = DbHelperOleDb.Fill(sql3); } repearter_shanghu.DataSource = dt; repearter_shanghu.DataBind(); } }