protected override void OnLoad(EventArgs e) { base.OnLoad(e); if (IsPost) { switch (AjaxAction) { case "ExpertPage.save": SaveExpert(); break; } } else { if (Request["id"] != null) { CurrentExpert = Expert.Get(Request["id"].Trim()); } else if (Request.QueryString.ToString().Length == 32) { CurrentExpert = Expert.Get(Request.QueryString.ToString()); } if (CurrentExpert == null) { CurrentExpert = new Expert("",""); } } }
public static ArrayList List(string keywords, Pager pager) { /* ExpertList * @keywords varchar(50)='', @pageIndex int=1, @pageSize int=20, @sort int=0 */ //Id, Guid, Email,[Name] SqlParameter[] prams ={ Database.MakeInParam("@keywords",SqlDbType.VarChar,50,keywords), Database.MakeInParam("@pageIndex",SqlDbType.Int,pager.PageIndex), Database.MakeInParam("@pageSize",SqlDbType.Int,pager.PageSize), Database.MakeInParam("@sort",SqlDbType.Int,pager.SortNum) }; ArrayList list = new ArrayList(); SqlDataReader reader = null; try { reader = Database.ExecuteReader(CommandType.StoredProcedure, "ExpertList", prams); if (reader.Read()) { pager.RecordCount = reader.GetInt32(0); if (reader.NextResult()) { while (reader.Read()) { Expert exp = new Expert(); exp.id = reader.GetInt32(0); exp.guid = reader.GetString(1); exp.email = reader.GetString(2); exp.name = reader.GetString(3); list.Add(exp); } } } reader.Close(); } catch { throw; } finally { if (reader != null) { reader.Close(); } } return list; }
public static Expert Get(string guidOrEmail) { /* ExpertGet @id varchar(50) */ Expert expt = null; SqlDataReader reader = null; try { reader = Database.ExecuteReader(CommandType.StoredProcedure, "ExpertGet", new SqlParameter[] { Database.MakeInParam("@id", SqlDbType.VarChar, 50, guidOrEmail) }); if (reader.Read()) { expt = new Expert(); expt.id = reader.GetInt32(0); expt.guid = reader.GetString(1); expt.email = reader.GetString(2); expt.name = reader.GetString(3); } } catch { // } finally { if (reader != null) { reader.Close(); } } return expt; }
private void SaveExpert() { Response.Clear(); if (Request.Form["expId"] != null && Request.Form["expName"] != null && Request.Form["expEmail"] != null) { Expert exp = new Expert(Request.Form["expEmail"].Trim(), Request.Form["expName"].Trim()); exp.Save(Convert.ToInt32(Request.Form["expId"])); Response.Write(exp.Id); } Response.End(); }
protected ExpertPage() : base() { CurrentExpert = new Expert("", ""); }