private void BindGrid2() { try { if (roleId > 0) { using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "M_ID,M_NAME,M_CODE,M_LEVEL", "[S_MENU]", "WHERE M_DISABLED=0", "ORDER BY M_ORDERPATH ASC")) { if (dt != null && dt.Rows.Count > 0) { purviewCodeData = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "MPC_NAME,MPC_CODE,M_ID", "S_MENU_PURVIEWCODE", "WHERE MPC_DISABLED=0", "ORDER BY MPC_ID ASC"); Grid2.DataSource = dt; Grid2.DataBind(); InitPermission(); } } } else { Alert.ShowInParent("参数错误!", String.Empty, ActiveWindow.GetHideReference()); } } catch (Exception ex) { logger.Error("S.R.MManage.BindGrid2():Exception", ex); Alert.ShowInParent("系统错误。"); } }
//页面数据加载 private void BindData() { try { StringBuilder condition = new StringBuilder(); if (string.IsNullOrEmpty(this.ttbSearchUser.Text)) { condition.Append(""); } else { condition.Append(" where CName like'%" + this.ttbSearchUser.Text + "%' "); } int recordCount = 0; using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "*", "[view_person]", condition.ToString(), "ORDER BY ID asc", Grid1.PageIndex + 1, Grid1.PageSize, out recordCount)) { Grid1.RecordCount = recordCount; Grid1.DataSource = dt; Grid1.DataBind(); } } catch (Exception ex) { logger.Error("X.MessageList.BindData():Exception", ex); Alert.ShowInParent("系统错误。"); } }
private void BindData() { try { StringBuilder condition = new StringBuilder("WHERE 1=1"); //去除用户为系统管理员 string name = StringHelper.ClearSqlStringExSpace(ttbSearchUser.Text.Trim()); if (name.Length > 0) { condition.AppendFormat(" AND (U_NAME like'%{0}%' OR U_REALNAME like'%{0}%')", name); } string orderExp = "ORDER BY " + Grid1.SortField + " " + Grid1.SortDirection; int recordCount = 0; using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "U_ID,U_NAME,U_REALNAME,U_DISABLED,U_EMAIL,U_MOBILE,U_TEL,U_PREVLOGINTIME,U_PREVLOGINIP", "[S_USER]", condition.ToString(), orderExp, Grid1.PageIndex + 1, Grid1.PageSize, out recordCount)) { Grid1.RecordCount = recordCount; Grid1.DataSource = dt; Grid1.DataBind(); } } catch (Exception ex) { logger.Error("S.U.Manage.BindData():Exception", ex); Alert.ShowInParent("系统错误。"); } }
private void BindData() { try { using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "M_ID,M_NAME,M_LEVEL,M_CODE,M_DISABLED", "[S_MENU]", String.Empty, "ORDER BY M_ORDERPATH ASC")) { Grid1.DataSource = dt; Grid1.DataBind(); } } catch (Exception ex) { logger.Error("S.M.Manage.BindData():Exception", ex); Alert.ShowInParent("系统错误。"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "M_ID,M_NAME,M_LEVEL", "[S_MENU]", "WHERE M_DISABLED=0", "ORDER BY M_ORDERPATH ASC")) { if (dt != null && dt.Rows.Count > 0) { ddlParentId.DataSource = dt; ddlParentId.DataTextField = "M_NAME"; ddlParentId.DataValueField = "M_ID"; ddlParentId.DataSimulateTreeLevelField = "M_LEVEL"; ddlParentId.DataBind(); } } ddlParentId.Items.Insert(0, new FineUI.ListItem("≡ 作为一级菜单 ≡", "0", true)); } }
private void BindRole() { try { using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "R_ID,R_NAME", "[S_ROLE]", String.Empty, "ORDER BY R_ORDERID ASC")) //去除系统管理员 { cblRole.DataTextField = "R_NAME"; cblRole.DataValueField = "R_ID"; cblRole.DataSource = dt; cblRole.DataBind(); } } catch (Exception ex) { logger.Error("S.U.SelectRole.BindRole():Exception", ex); Alert.ShowInParent("系统错误。"); } }
private void LoadInfo() { int id = RequestHelper.GetRequestInt("id", 0); if (id > 0) { UserModel model = new UserBLL().GetModelById(id); if (model != null) { labName.Text = HttpUtility.HtmlDecode(model.Name); labRealName.Text = HttpUtility.HtmlDecode(model.RealName); labEmail.Text = HttpUtility.HtmlDecode(model.Email); labMobile.Text = HttpUtility.HtmlDecode(model.Mobile); labPhone.Text = HttpUtility.HtmlDecode(model.Tel); imgShowStatus.Icon = model.Disabled ? Icon.Tick : Icon.BulletCross; StringBuilder sbText = new StringBuilder(); using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "R_NAME", "[S_ROLE_USER] a JOIN [S_ROLE] b ON b.R_ID=a.R_ID", "WHERE a.U_ID=" + id, "ORDER BY a.R_ID ASC")) { if (dt != null && dt.Rows.Count > 0) { foreach (DataRow role in dt.Rows) { sbText.AppendFormat("{0},", role["R_NAME"]); } labRole.Text = sbText.ToString().TrimEnd(','); } } labPT.Text = model.PrevLoginTime.HasValue ? model.PrevLoginTime.Value.ToString() : ""; labPIP.Text = HttpUtility.HtmlDecode(model.PrevLoginIP); labLT.Text = model.LastLoginTime.HasValue ? model.LastLoginTime.Value.ToString() : ""; labLIP.Text = HttpUtility.HtmlDecode(model.LastLoginIP); labLTS.Text = model.LoginTimes.ToString(); labCT.Text = model.CreateTime.Value.ToString(); } else { Alert.ShowInParent("读取数据失败!", String.Empty, ActiveWindow.GetHideReference()); } } else { Alert.ShowInParent("参数错误!", String.Empty, ActiveWindow.GetHideReference()); } }
/// <summary> /// 绑定数据 /// </summary> public void BindData() { try { StringBuilder condition = new StringBuilder(" where Type='BD' "); using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, " HelpInfo ", "[MS_HelpPage]", condition.ToString(), "")) { if (dt.Rows.Count > 0) { this.txtHelpInfo.Text = dt.Rows[0]["HelpInfo"].ToString(); } } } catch (Exception ex) { logger.Error("X.MessageList.BindData():Exception", ex); Alert.ShowInParent("系统错误。"); } }
//页面数据加载 private void BindData() { try { StringBuilder condition = new StringBuilder(""); int recordCount = 0; using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "*", "[view_statistics]", condition.ToString(), "ORDER BY ID asc", Grid1.PageIndex + 1, Grid1.PageSize, out recordCount)) { Grid1.RecordCount = recordCount; Grid1.DataSource = dt; Grid1.DataBind(); } } catch (Exception ex) { logger.Error("X.MessageList.BindData():Exception", ex); Alert.ShowInParent("系统错误。"); } }
/// <summary> /// 绑定最后一条数据 /// </summary> public void BindData() { try { StringBuilder condition = new StringBuilder(""); using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "top 1 *", "[MS_Edition]", condition.ToString(), "ORDER BY createdtime desc")) { if (dt.Rows.Count > 0) { this.txtNumber.Text = dt.Rows[0]["version"].ToString(); this.txtEdition.Text = dt.Rows[0]["edition"].ToString(); } } } catch (Exception ex) { logger.Error("X.MessageList.BindData():Exception", ex); Alert.ShowInParent("系统错误。"); } }
//页面数据加载 private void BindData() { try { StringBuilder condition = new StringBuilder(""); string id = RequestHelper.GetRequestString("id", ""); int recordCount = 0; condition.AppendFormat("where Title_ID='{0}'", id); using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "*", "[TB_Comment]", condition.ToString(), "ORDER BY createdtime desc", Grid1.PageIndex + 1, Grid1.PageSize, out recordCount)) { Grid1.RecordCount = recordCount; Grid1.DataSource = dt; Grid1.DataBind(); } } catch (Exception ex) { logger.Error("X.MessageList.BindData():Exception", ex); Alert.ShowInParent("系统错误。"); } }
private void BindData() { txtID.Text = "0"; txtCode.Text = String.Empty; txtName.Text = String.Empty; chkDisabled.Checked = false; try { int recordCount = 0; using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "MPC_ID,MPC_NAME,MPC_CODE,MPC_DISABLED,M_NAME,M_CODE", "[S_MENU_PURVIEWCODE] mpc JOIN [S_MENU] m ON m.M_ID=mpc.M_ID", "WHERE mpc.M_ID=" + mid, "ORDER BY MPC_ID ASC", Grid1.PageIndex + 1, Grid1.PageSize, out recordCount)) { Grid1.RecordCount = recordCount; Grid1.DataSource = dt; Grid1.DataBind(); } } catch (Exception ex) { logger.Error("S.M.PCManage.BindData():Exception", ex); Alert.ShowInParent("系统错误。"); } }
//页面数据加载 private void BindData() { try { id = RequestHelper.GetRequestString("id", ""); StringBuilder condition = new StringBuilder("where 1=1"); condition.AppendFormat(" and pageid='{0}' ", id); int recordCount = 0; using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "*", "[view_statistics_info]", condition.ToString(), " ORDER BY ID asc", Grid1.PageIndex + 1, Grid1.PageSize, out recordCount)) { Grid1.RecordCount = recordCount; Grid1.DataSource = dt; Grid1.DataBind(); } } catch (Exception ex) { logger.Error("X.MessageList.BindData():Exception", ex); Alert.ShowInParent("系统错误。"); } }
private void BindData() { try { StringBuilder condition = new StringBuilder("WHERE 1=1"); string key = StringHelper.ClearSqlStringExSpace(ttbSearchKey.Text.Trim()); if (key.Length > 0) { condition.AppendFormat(" AND [R_NAME] like '%{0}%'", key); } int recordCount = 0; using (DataTable dt = SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, "*", "[S_ROLE]", condition.ToString(), "ORDER BY R_ORDERID ASC", Grid1.PageIndex + 1, Grid1.PageSize, out recordCount)) { Grid1.RecordCount = recordCount; Grid1.DataSource = dt; Grid1.DataBind(); } } catch (Exception ex) { logger.Error("S.R.Manage.BindData():Exception", ex); Alert.ShowInParent("系统错误。"); } }
/// <summary> /// 根据报名id查询数据 /// </summary> /// <param name="mid">报名id</param> /// <param name="id">0参加1取消2全部</param> /// <param name="type">类型(-1所有取消的活动(赛事/培训),0、赛事1、培训2、约吧)</param> /// <returns></returns> public DataTable GetTableCancel(int mid, int id, int type, int page, int row, out int recordCount) { recordCount = 0; try { StringBuilder where = new StringBuilder(); // where.AppendFormat(" m_id ={0} and isactivaty={1}", mids, type); StringBuilder order = new StringBuilder(); order.AppendFormat(" order by App_Application.createtime desc"); StringBuilder cmdText = new StringBuilder(); StringBuilder cmdtable = new StringBuilder(); if (type == 2) { cmdtable.Append("App_Application left join View_About on App_Application.a_id=View_About.ab_id"); cmdText.Append("ap_id,ab_id,pic,AnOrangepic,IosOrangepic,title,View_About.address,number,View_About.sex,numberlimit,movement,begintime,specifictime"); where.Append("App_Application.m_id=" + mid + " and App_Application.state not in('-1') and App_Application.type=" + type + " "); } else { cmdtable.Append(" App_Application left join View_Activaty on App_Application.a_id=View_Activaty.a_id"); cmdText.Append("ap_id,View_Activaty.a_id,pic,App_Application.state,AnOrangepic,IosOrangepic,title,View_Activaty.address,movement,praise,eventname,isactivaty,App_Application.modifytime"); if (type == -1) { where.Append("App_Application.m_id=" + mid + " and App_Application.state in('2','3','4','5') and App_Application.type in('0','1') "); } else { if (id == 0) { where.Append("App_Application.m_id=" + mid + " and App_Application.state=1 and App_Application.type=" + type + " "); } else if (id == 1) { where.Append("App_Application.m_id=" + mid + " and App_Application.state in('2','3','4','5') and App_Application.type=" + type + " "); } else { where.Append("App_Application.m_id=" + mid + " and App_Application.state not in('-1','0') and App_Application.type=" + type + " "); } } } return(SqlPagerHelper.GetTableByCondition(DefaultConnection.ConnectionStringByDefaultDB, cmdText.ToString(), cmdtable.ToString(), where.ToString(), order.ToString(), page, row, out recordCount)); } catch (ArgumentNullException ex) { logger.Error("调用方法GetTableCancel发生ArgumentNullException", ex); } catch (SqlException ex) { logger.Error("调用方法GetTableCancel发生SqlException", ex); } catch (Exception ex) { logger.Error("调用方法GetTableCancel发生Exception", ex); } return(null); }