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