protected void Page_Load(object sender, EventArgs e)
{
loginService.HaveSuperAdminRight();
ReturnUrl = HttpUtility.UrlEncode(Request.RawUrl);
Type = string.IsNullOrEmpty(Request["type"]) ? EtlStateTypeOptions.None : (EtlStateTypeOptions)Convert.ToInt32(Request["type"]);
Keyword = Request["keyword"] == null ? string.Empty : Request["keyword"];
TEtlStatesService esService = new TEtlStatesService();
typeDict = esService.GetEtlStateTypes();
int pageIndex = string.IsNullOrEmpty(Request["page"]) ? 1 : Convert.ToInt32(Request["page"]);
int pageSize = string.IsNullOrEmpty(Request["pagesize"]) ? 15 : Convert.ToInt32(Request["pagesize"]);
int count = 0;
List <EtlState> list = esService.GetEtlStates(Type, Keyword, pageIndex, pageSize, ref count);
repeaData.DataSource = list;
repeaData.DataBind();
AspNetPager1.RecordCount = count;
AspNetPager1.PageSize = pageSize;
AspNetPager1.CurrentPageIndex = pageIndex;
ddlTypes.DataSource = esService.GetEtlStateTypes();
ddlTypes.DataTextField = "Value";
ddlTypes.DataValueField = "Key";
ddlTypes.DataBind();
ddlTypes.SelectedValue = ((int)Type).ToString();
}
/// <summary>
/// 获取指定分类的状态信息
/// </summary>
/// <param name="type"></param>
/// <param name="keyword"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="recordCount"></param>
/// <returns></returns>
public static List<EtlState> GetEtlStates(EtlStateTypeOptions type, string keyword, int pageIndex, int pageSize, ref int recordCount)
{
string where = " where `Type`=?Type";
if (!string.IsNullOrEmpty(keyword))
where += " and `Key` like '%" + keyword.Replace("'", "''") + "%'";
string cmdText = "select count(*) from EtlStates" + where;
MySqlParameter[] parameters = new MySqlParameter[] { new MySqlParameter("?Type", (int)type) };
object result = MySqlHelper.ExecuteScalar(DACommonHelper.ConnectionString, cmdText, parameters);
recordCount = Convert.ToInt32(result);
cmdText = "select `ID`,`Key`,`Value`,`Type`,`AddTime`,`Description` from EtlStates" + where + string.Format(" order by `Key` limit {0},{1}", (pageIndex - 1) * pageSize, pageSize);
List<EtlState> states = new List<EtlState>();
using (MySqlDataReader reader = MySqlHelper.ExecuteReader(DACommonHelper.ConnectionString, cmdText, parameters))
{
while (reader.Read())
{
states.Add(BindEtlState(reader));
}
}
return states;
}
/// <summary>
/// 获取指定分类的状态信息
/// </summary>
/// <param name="type"></param>
/// <param name="keyword"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="recordCount"></param>
/// <returns></returns>
public List <EtlState> GetEtlStates(EtlStateTypeOptions type, string keyword, int pageIndex, int pageSize, ref int recordCount)
{
return(DAEtlStatesHelper.GetEtlStates(type, keyword, pageIndex, pageSize, ref recordCount));
}
