protected void btnDelete_Click(object sender, EventArgs e) { TPortalClass.JpCommon JpCommon = new TPortalClass.JpCommon(); TPortalClass.JpActivityusers JpActivityusers = new TPortalClass.JpActivityusers(); string ls_tip = "删除成功!"; for (int i = 0; i < rptList.Items.Count; i++) { string id = ((HiddenField)rptList.Items[i].FindControl("hidId")).Value; CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId"); if (cb.Checked) { JpActivityusers.id = int.Parse(id); JpActivityusers.Delete(); } } string pageUrl = JpCommon.CombUrlTxt("list_activityusers.aspx", "page={0}&rnd={1}", "" + this.txtPage.Text + "", "" + System.Guid.NewGuid().ToString() + ""); //写系统日志 string userip = Request.ServerVariables["HTTP_X_FORWARDED_FOR"]; if (userip == null || userip == "") { userip = Request.ServerVariables["REMOTE_ADDR"]; } JpCommon.WriteLog(userip, "删除", "批量删除广告记录", Session["uid"].ToString(), Session["uname"].ToString()); Response.Write("<script>alert('" + ls_tip + "');window.location='" + pageUrl + "';</script>"); }
private void RptBind() { if (this.Request.QueryString["page"] != null) this.page = int.Parse(this.Request.QueryString["page"].ToString()); else this.page = 1; this.txtKeywords.Text = this.keywords; txtPageNum.Text = this.pageSize.ToString(); txtPage.Text = this.page.ToString(); TPortalClass.JpActivityusers JpActivityusers = new TPortalClass.JpActivityusers(); TPortalClass.JpCommon JpCommon = new TPortalClass.JpCommon(); string ls_key = JpCommon.Filter(this.txtKeywords.Text.Trim()); DataTable dt = new DataTable(); string sql = ""; sql = " Select top 10 a.hy_bt,b.hy_name,b.hy_tel,b.hy_addtime,b.hy_ifsh,b.hy_id,b.id from hy_activity a,hy_activityusers b "; sql += " where 1=1 and b.hy_id=a.id and a.hy_bt like '%" + ls_key + "%' and a.id not in(select top 0 a.id "; sql += " from hy_activity a,hy_activityusers b where 1=1 and hy_bt like '%" + ls_key + "%' order by a.hy_sort desc,b.hy_sort desc ) "; sql += " order by a.hy_sort desc,b.hy_sort desc"; TPortalClass.DAO db = new TPortalClass.DAO(); dt = db.GetDataTable(sql); string sql_count = "Select count(*) as num from hy_activity a,hy_activityusers b"; sql_count += " where 1=1 and b.hy_id=a.id and a.hy_bt like '%" + ls_key + "%' "; DataTable dt_count = db.GetDataTable(sql_count); if (dt_count.Rows.Count > 0) { this.totalCount = Convert.ToInt32(dt_count.Rows[0]["num"].ToString()); } else { this.totalCount = 0; } rptList.DataSource = dt; rptList.DataBind(); string pageUrl = JpCommon.CombUrlTxt("list_activityusers.aspx", "page={0}&rnd={1}&keywords={2}", "__id__", "" + System.Guid.NewGuid().ToString() + "", "" + this.txtKeywords.Text + ""); PageContent.InnerHtml = JpCommon.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
private void DataPlay() { if (this.Request.QueryString["op"] != null) { this.txtop.Value = this.Request.QueryString["op"].ToString(); //新增还是修改 } if (this.Request.QueryString["id"] != null) { this.txtid.Value = this.Request.QueryString["id"].ToString(); //文档ID } TPortalClass.JpActivityusers JpActivityusers = new TPortalClass.JpActivityusers(); TPortalClass.JpActivity JpActivity = new TPortalClass.JpActivity(); //旧文档 if (this.txtop.Value == "modify") { DataTable dt = JpActivityusers.Getdocbyid(int.Parse(this.txtid.Value)); if (dt.Rows.Count > 0) { ddlhy_id.SelectedValue = dt.Rows[0]["hy_id"].ToString(); this.txthy_name.Text = dt.Rows[0]["hy_name"].ToString(); this.txthy_tel.Text = dt.Rows[0]["hy_tel"].ToString(); this.txthy_addtime.Text = Convert.ToDateTime(dt.Rows[0]["hy_addtime"].ToString()).ToString("yyyy-MM-dd"); } btnSubmit.Visible = true; ddlhy_id.Enabled = false; txthy_name.Enabled = false; txthy_tel.Enabled = false; txthy_addtime.Enabled = false; } else { // this.txthy_sort.Text = JpActivityusers.GetMaxSort(); } }
//保存 protected void btnSubmit_Click(object sender, EventArgs e) { if (this.Session["uid"] == null || this.Session["uid"].ToString() == "") { this.Response.Redirect("../login.aspx"); } string ls_tip = "保存成功!"; TPortalClass.JpActivityusers JpActivityusers = new TPortalClass.JpActivityusers(); TPortalClass.JpCommon JpCommon = new TPortalClass.JpCommon(); JpActivityusers.hy_name = txthy_name.Text.Trim(); JpActivityusers.hy_tel = txthy_tel.Text.Trim(); JpActivityusers.hy_addtime = txthy_addtime.Text.Trim(); JpActivityusers.hy_id = Convert.ToInt32(ddlhy_id.SelectedValue); JpActivityusers.hy_pwd = ""; JpActivityusers.hy_nc = ""; JpActivityusers.hy_mail = ""; JpActivityusers.hy_sex = ""; JpActivityusers.hy_addr = ""; JpActivityusers.hy_txzp = ""; JpActivityusers.hy_islock = ""; JpActivityusers.hy_ismailyz = ""; JpActivityusers.hy_issmrz = ""; JpActivityusers.hy_sfzpic = ""; JpActivityusers.hy_sfzcard = ""; JpActivityusers.hy_company = ""; JpActivityusers.hy_position = ""; JpActivityusers.hy_post = ""; JpActivityusers.hy_key = ""; JpActivityusers.hy_type = ""; JpActivityusers.hy_logo = ""; JpActivityusers.hy_sfxs = ""; JpActivityusers.hy_lev = ""; JpActivityusers.hy_pic = ""; JpActivityusers.hy_ifsh = 0; JpActivityusers.hy_sort = 1; if (this.txtop.Value == "add") { //写系统日志 string userip = Request.ServerVariables["HTTP_X_FORWARDED_FOR"]; if (userip == null || userip == "") { userip = Request.ServerVariables["REMOTE_ADDR"]; } JpCommon.WriteLog(userip, "新增", "新增广告链接记录[id:" + this.txtid.Value + "]", Session["uid"].ToString(), Session["uname"].ToString()); JpActivityusers.Insert(); } else { JpActivityusers.id = System.Int32.Parse(this.txtid.Value); //写系统日志 string userip = Request.ServerVariables["HTTP_X_FORWARDED_FOR"]; if (userip == null || userip == "") { userip = Request.ServerVariables["REMOTE_ADDR"]; } JpCommon.WriteLog(userip, "修改", "修改广告链接记录[id:" + this.txtid.Value + "]", Session["uid"].ToString(), Session["uname"].ToString()); JpActivityusers.Update(); } Response.Write("<script>alert('" + ls_tip + "');window.location='" + this.txturl.Value + "'</script>"); }
public string SignUpValidate(string pis_yzm, string pis_tel, string pis_name, string pis_activityid, string pis_code) { string pos_json = ""; string ls_yzm = ConfigurationManager.AppSettings["Yanzm"].ToString(); if (pis_tel != "" && pis_name != "" && pis_activityid != "" && pis_code != "" && pis_yzm == ls_yzm) { try { TPortalClass.JpVerifyCode JpVerifyCode = new TPortalClass.JpVerifyCode(); DataTable dt = JpVerifyCode.GetCodesByTel(pis_tel); if (dt.Rows.Count > 0) { if (pis_code == dt.Rows[0]["hy_code"].ToString()) { JpActivityusers JpActivityusers = new JpActivityusers(); DataTable dt_user = JpActivityusers.GetDocbyhyidAndactivityid(Convert.ToInt32(pis_activityid), pis_tel); if (dt_user.Rows.Count > 0) { //该用户已注册 pos_json = "{\"code\":\"2\"}"; } else { JpActivityusers.hy_addtime = System.DateTime.Now.ToString(); JpActivityusers.hy_id = Convert.ToInt32(pis_activityid); JpActivityusers.hy_name = pis_name; JpActivityusers.hy_tel = pis_tel; JpActivityusers.InsertSignUp(); //报名成功 pos_json = "{\"code\":\"0\"}"; } } else { //验证码错误 pos_json = "{\"code\":\"1\"}"; } } } catch { //系统错误 pos_json = "{\"code\":\"3\"}"; } finally { } } else { //非法调用 pos_json = "{\"code\":\"4\"}"; } return pos_json; }