/// <summary> /// 设置页面控件值 /// </summary> protected override void SetPageControlValue(BasicsPageDataModel Obj_DaModel) { DataModel daModel = new DataModel(); try { daModel = (DataModel)Obj_DaModel; } catch (Exception) { } txt_Name.Text = daModel.Name; txt_StartTime.Text = daModel.Time_Start; txt_EndTime.Text = daModel.Time_End; this.txt_LikeSelect.Text = daModel.LikeSelectValue; }
/// <summary> /// 获得 之前设置的条件 数信息 /// </summary> protected BasicsPageDataModel GetBeforeSetWhereDataModel() { string keyname = String.Format("{0}_model_value", Get_CT_Nav_Name()); BasicsPageDataModel model = Session[keyname] as BasicsPageDataModel; if (model != null) { return(model); } return(new BasicsPageDataModel()); }
/// <summary> /// 页面加载事件 /// </summary> protected void Page_Load(object sender, EventArgs e) { InitCreateBasicsComponentAndObject(out rptList, out txtPageNum, out PageContent, out BapdBLL); this.BapdModel = GetBeforeSetWhereDataModel(); this.page = GetPageSignNo(); this.pageSize = GetPageSize(this._default_page_size, Get_CTCookie_Page_Size_Name()); //每页数量 if (!Page.IsPostBack) { ChkAdminLevel(Get_CT_Nav_Name(), DTEnums.ActionEnum.View); //检查权限 InitPageComponentTemplateValues(); this.BapdModel = InitIsPostBackBasicsPageDataModel(this.BapdModel); SetPageControlValue(this.BapdModel); RptBind(GetSetSQLWhereLastValueString(this.BapdModel), GetSetSQLOrderByString()); } }
/// <summary> /// 组合字符串 /// </summary> protected override string CombSqlTxt(BasicsPageDataModel Obj_DaModel) { DataModel daModel = new DataModel(); try { daModel = (DataModel)Obj_DaModel; } catch (Exception) { } List <string> sqls = new List <string>(); if (!CheckData.IsStringNull(daModel.Name)) { sqls.Add(CreateSQL.WhereEqual(BLL_vismsg.ColName_name, daModel.Name)); } daModel.Time_Start = daModel.Time_Start.Replace("'", ""); if (!CheckData.IsStringNull(daModel.Time_Start)) { sqls.Add(CreateSQL.WhereBigThanEqual(BLL_vismsg.ColName_TimeAdd, daModel.Time_Start)); } daModel.Time_End = daModel.Time_End.Replace("'", ""); if (!CheckData.IsStringNull(daModel.Time_End)) { sqls.Add(CreateSQL.WhereSmallThanEqual(BLL_vismsg.ColName_TimeAdd, daModel.Time_End)); } if (!CheckData.IsStringNull(daModel.LikeSelectValue)) { string[] valArr = ConvertTool.ToArrayList(daModel.LikeSelectValue, ','); string likeSelString = CreateSQL.WhereLikeAllPropertyInfo(new Model.visitor_message(), valArr); if (!CheckData.IsStringNull(likeSelString)) { sqls.Add(likeSelString); } } string resultSQLStr = ConvertTool.ToString(sqls, CreateSQL.WHERE_AND); if (CheckData.IsStringNull(resultSQLStr.Trim())) { return(string.Empty); } return(CreateSQL.WHERE_AND + resultSQLStr); }
/// <summary> /// 传递页面查询参数值 /// </summary> protected virtual string GetSetSQLWhereLastValueString(BasicsPageDataModel Obj_DaModel) { StringBuilder SQLWhere = new StringBuilder(); SQLWhere.Append(" id >= 0 " + CombSqlTxt(Obj_DaModel)); Model.manager adminUserInfo = GetAdminInfo(); string string_usualManSqlWhere = UsualManagerSQLWhere(Obj_DaModel, adminUserInfo.id); if (!CheckData.IsStringNull(string_usualManSqlWhere) && adminUserInfo.role_id != 1) { SQLWhere.Append(string_usualManSqlWhere); } string string_superManSqlWhere = SuperManagerSQLWhere(Obj_DaModel); if (!CheckData.IsStringNull(string_superManSqlWhere) && adminUserInfo.role_id == 1) { SQLWhere.Append(string_superManSqlWhere); } return(SQLWhere.ToString()); }
/// <summary> /// 组合字符串 /// </summary> protected abstract string CombSqlTxt(BasicsPageDataModel Obj_DaModel);
/// <summary> /// 设置页面控件值 /// </summary> protected abstract void SetPageControlValue(BasicsPageDataModel Obj_DaModel);
/// <summary> /// 下拉控件选择触发事件 /// </summary> protected void DropDownList_SelectedIndexChanged(object sender, EventArgs e) { ChkAdminLevel(Get_CT_Nav_Name(), DTEnums.ActionEnum.View); //检查权限 this.BapdModel = GetPageControlValue(); RptBind(GetSetSQLWhereLastValueString(GetPageControlValue()), GetSetSQLOrderByString()); }
protected void ExecuteSearch() { ChkAdminLevel(Get_CT_Nav_Name(), DTEnums.ActionEnum.Show); //检查权限 this.BapdModel = GetPageControlValue(); Response.Redirect(GetAccessThisPageURLLink(Get_CT_ThisPage_Url(), this.BapdModel)); }
/// <summary> /// 超级管理员 的 额外查询条件 /// </summary> protected virtual string SuperManagerSQLWhere(BasicsPageDataModel Obj_DaModel) { return(String.Empty); }
/// <summary> /// 普通管理员 的 额外查询条件 /// </summary> /// <param name="ManagerID">既然是普通管理员,那就需要获得是哪一个管理员</param> protected virtual string UsualManagerSQLWhere(BasicsPageDataModel Obj_DaModel, int ManagerID) { return(String.Empty); }
/// <summary> /// 初始化回发基础页面数据模型 /// </summary> protected virtual BasicsPageDataModel InitIsPostBackBasicsPageDataModel(BasicsPageDataModel Obj_DaModel) { return(Obj_DaModel); }