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