protected void Page_Load(object sender, EventArgs e) { SQL = "select wz_id,标题 from 文章表 where 文档类型='材料发现' "; dt = objConn.GetDataTable(SQL); SQL = "select wz_id,标题 from 文章表 where 文档类型='材料导购'"; dt1 = objConn.GetDataTable(SQL); SQL = "select wz_id,标题 from 文章表 where 文档类型='材料评测' "; dt2 = objConn.GetDataTable(SQL); SQL = "select wz_id,标题 from 文章表 where 文档类型='材料百科' "; dt3 = objConn.GetDataTable(SQL); }
protected void Button1_Click(object sender, EventArgs e) { DataConn objcon = new DataConn(); string SQL = "select dw_id,QQ号码,QQ_id,等级,yh_id,类型 from 用户表 where QQ号码='" + this.username.Value + "'"; DataTable dt_yh = new DataTable(); dt_yh = objcon.GetDataTable(SQL); if (dt_yh != null && dt_yh.Rows.Count > 0) { string yh_id = ""; yh_id = dt_yh.Rows[0]["yh_id"].ToString(); dj = dt_yh.Rows[0]["等级"].ToString(); QQ = dt_yh.Rows[0]["QQ号码"].ToString(); gys_id = dt_yh.Rows[0]["dw_id"].ToString(); string lx = dt_yh.Rows[0]["类型"].ToString(); Session["GYS_QQ_ID"] = dt_yh.Rows[0]["QQ_id"].ToString(); Session["GYS_YH_ID"] = yh_id;//蒋,11月07号添加 Session["QQ号码"] = QQ; Session["类型"] = lx; Session["dwid"] = gys_id; if (dj == "普通用户") { Response.Write("<script> window.opener.location.href='gyszym.aspx';window.close();</" + "script>"); } else { Response.Write("<script> window.opener.location.href='hyyhgl.aspx?QQ=" + this.username.Value + "&dw_id=" + gys_id + "';window.close();</" + "script>"); } } else { Response.Write("<script>alert('您的账号未注册!');</" + "script>"); } }
protected void Button1_Click(object sender, EventArgs e) { DataConn objcon = new DataConn(); string SQL = "select yh_id,QQ_id,等级, QQ号码 from 用户表 where QQ号码='" + this.username.Value + "'"; DataTable dt_yh = objcon.GetDataTable(SQL); if (dt_yh != null && dt_yh.Rows.Count > 0) { yh_id = dt_yh.Rows[0]["yh_id"].ToString(); dj=dt_yh.Rows[0]["等级"].ToString(); Session["CGS_QQ_ID"] = dt_yh.Rows[0]["QQ_id"].ToString(); Session["CGS_YH_ID"] = yh_id; //GYS_YH_ID if (dj == "普通用户") { Response.Write("<script> window.opener.location.href='cgsgl_2.aspx';window.close();</" + "script>"); } else { Response.Write("<script>window.opener.location.href='hyyhgl.aspx?QQ=" + this.username.Value + "';window.close();</" + "script>"); } } else { Response.Write("<script>alert('您的账号未注册!');</" + "script>"); } }
protected void Page_Load(object sender, EventArgs e) { HttpCookie QQ_id = Request.Cookies["QQ_id"]; if (QQ_id != null) { SQL = "select 姓名 from 用户表 where QQ_id='" + QQ_id.Value + "'"; dt_yh = objConn.GetDataTable(SQL); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { dt = objConn.GetDataTable("select distinct top 10 供应商 ,gys_id,单位类型 from 材料供应商信息表 where 是否启用=1 order by gys_id"); this.Items = new List <Manufacturer>(); for (int x = 0; x < dt.Rows.Count; x++) { DataRow dr = dt.Rows[x]; Manufacturer mf = new Manufacturer(); mf.Manufacturers = Convert.ToString(dr["供应商"]); mf.Type = Convert.ToString(dr["单位类型"]); mf.Gys_id = Convert.ToString(dr["gys_id"]); this.Items.Add(mf); } } }
protected void Page_Load(object sender, EventArgs e) { dt_cltp = objConn.GetDataTable("select 存放地址,材料名称,cl_id from 材料多媒体信息表 where 是否上头条='是' and 媒体类型 = '图片' and 大小='小' and cl_id in(select cl_id from 材料表 where 类型='主打')"); }
protected void Page_Load(object sender, EventArgs e) { //string constr = ConfigurationManager.ConnectionStrings["DBServerName"].ConnectionString; objConn = new DataConn(); dt = objConn.GetDataTable("select distinct top 10 品牌名称 ,pp_id from 品牌字典 where 是否启用=1 "); }
protected void Page_Load(object sender, EventArgs e) { dt = objConn.GetDataTable("select top 10 显示名,cl_id,材料编码,fl_id,分类编码 from 材料表 order by fl_id "); }
string strRunPage; //验证成功后要跳转的页面 #endregion Fields #region Methods protected void btnCheck_Click(object sender, ImageClickEventArgs e) { DataConn dc = new DataConn(); string QQ = Request.Form["user_qq"]; string gys_qq_id; string cgs_qq_id; string sql_Check_QQ; string sql_Update_QQ_id; string sql_GetData; string sql_Level; string sql_dwid; if (Request.Cookies["GYS_QQ_ID"]!=null) { gys_qq_id = Request.Cookies["GYS_QQ_ID"].Value.ToString(); sql_Check_QQ = "select * from 用户表 where QQ号码='" + QQ + "'"; sql_Update_QQ_id = "update 用户表 set QQ_id = '" + gys_qq_id + "',验证通过时间=getdate(),是否验证通过='通过' where QQ号码='" + QQ + "'"; sql_GetData = "select 供应商,地址,电话,主页,单位类型,联系人,联系人手机 from 材料供应商信息表 where gys_id=(select dw_id from 用户表 where QQ_id='" + gys_qq_id + "')"; sql_Level = "select 等级 from 用户表 where QQ_id='" + gys_qq_id + "'"; sql_dwid = "select dw_id from 用户表 where QQ_id='" + gys_qq_id + "'"; } else { cgs_qq_id = Request.Cookies["CGS_QQ_ID"].Value.ToString(); sql_Check_QQ = "select * from 用户表 where QQ号码='" + QQ + "'"; sql_Update_QQ_id = "update 用户表 set QQ_id = '" + cgs_qq_id + "',验证通过时间=getdate(),是否验证通过='通过' where QQ号码='" + QQ + "'"; sql_GetData = "select 单位名称,地址,电话,主页,单位类型,联系人,联系人手机 from 采购商基本信息 where cgs_id=(select dw_id from 用户表 where QQ_id='" + cgs_qq_id + "')"; sql_Level = "select 等级 from 用户表 where QQ_id='" + cgs_qq_id + "'"; sql_dwid = "select dw_id from 用户表 where QQ_id='" + cgs_qq_id + "'"; } if(dc.GetRowCount(sql_Check_QQ)>0) //判断QQ号是否存在,即是否已经注册 { //Response.Write("已经注册"); if (dc.RunSqlTransaction(sql_Update_QQ_id)) //已经注册,则写入QQ_id { //读取数据 dtGys = dc.GetDataTable(sql_GetData); if (Request.Cookies["GYS_QQ_ID"] != null) { for (int i = 0; i < dtGys.Rows.Count; i++) { DataRow dr = dtGys.Rows[i]; this.gys_name.Value = dr["供应商"].ToString(); this.gys_address.Value = dr["地址"].ToString(); this.gys_phone.Value = dr["电话"].ToString(); this.gys_homepage.Value = dr["主页"].ToString(); this.gslx.Value = dr["单位类型"].ToString(); this.user_name.Value = dr["联系人"].ToString(); this.user_phone.Value = dr["联系人手机"].ToString(); } } else { for (int i = 0; i < dtGys.Rows.Count; i++) { DataRow dr = dtGys.Rows[i]; this.gys_name.Value = dr["单位名称"].ToString(); this.gys_address.Value = dr["地址"].ToString(); this.gys_phone.Value = dr["电话"].ToString(); this.gys_homepage.Value = dr["主页"].ToString(); this.gslx.Value = dr["单位类型"].ToString(); this.user_name.Value = dr["联系人"].ToString(); this.user_phone.Value = dr["联系人手机"].ToString(); } } if (dc.DBLook(sql_Level) == "企业用户") { strRunPage = "hyyhgl.aspx"; } else if (dc.DBLook(sql_Level) == "普通用户") { string dwid = dc.DBLook(sql_dwid); if (Request.Cookies["GYS_QQ_ID"] != null) { strRunPage = "gyszym.aspx?dw_id=" + dwid; } else { strRunPage = "cgsgl_2.aspx?dw_id=" + dwid; } } Response.Write(@"<script>if(confirm('验证成功,是否现在登录?')==true) {window.location.href='" + strRunPage + "';}else{}</script>"); } } else { Response.Write(@"<script>if(confirm('此账户尚未注册,是否现在注册?')==true) {window.location.href='hyzcsf.aspx';}else{window.opener=null;window.open('','_self'); window.close();}</script>"); } }