/// <summary>
/// Retrieve list of UserLogin by query String.
/// <param name="query"></param>
/// </summary>
/// <returns>List of UserLogin</returns>
public UserLoginList GetByQuery(String query)
{
using (UserLoginDataAccess data = new UserLoginDataAccess(ClientContext))
{
return(data.GetByQuery(query));
}
}
/// <summary>
/// Retrieves Get Total Rows of UserLogin
/// </summary>
/// <returns>Int32 type object</returns>
public Int32 GetRowCount()
{
using (UserLoginDataAccess data = new UserLoginDataAccess(ClientContext))
{
return(data.GetRowCount());
}
}
/// <summary>
/// Retrieve list of UserLogin by PageRequest.
/// <param name="request"></param>
/// </summary>
/// <returns>List of UserLogin</returns>
public UserLoginList GetPaged(PagedRequest request)
{
using (UserLoginDataAccess data = new UserLoginDataAccess(ClientContext))
{
return(data.GetPaged(request));
}
}
/// <summary>
/// Retrieve list of UserLogin.
/// no parameters required to be passed in.
/// </summary>
/// <returns>List of UserLogin</returns>
public UserLoginList GetAll()
{
using (UserLoginDataAccess data = new UserLoginDataAccess(ClientContext))
{
return(data.GetAll());
}
}
/// <summary>
/// Retrieve UserLogin data using unique ID
/// </summary>
/// <param name="_Id"></param>
/// <returns>UserLogin Object</returns>
public UserLogin Get(Int32 _Id)
{
using (UserLoginDataAccess data = new UserLoginDataAccess(ClientContext))
{
return(data.Get(_Id));
}
}
protected void a_login_Click(object sender, EventArgs e)
{
string userName = txtAccount.Text;
string passWord = txtPwd.Text;
UserLoginDataAccess userLogin = new UserLoginDataAccess();
DataTable dt = userLogin.getUserLogin(userName, passWord);
if (dt.Rows.Count == 1)
{
Context.Session.Add(Common.CommonStr.USERID, dt.Rows[0]["MAS_ADMIN_ID"]);
Context.Session.Add(Common.CommonStr.USERNAME, dt.Rows[0]["MAS_ADMIN_NAME"]);
Context.Session.Add(Common.CommonStr.NICKNAME, dt.Rows[0]["MAS_ADMIN_NICKNAME"]);
HttpCookie cookie = new HttpCookie(Common.CommonStr.COOKIE);
cookie.Values.Add(Common.CommonStr.USERID, dt.Rows[0]["MAS_ADMIN_ID"].ToString());
cookie.Values.Add(Common.CommonStr.USERNAME, dt.Rows[0]["MAS_ADMIN_NAME"].ToString());
//cookie.Values.Add(Common.CommonStr.NICKNAME, context.Server.HtmlEncode(dt.Rows[0]["MAS_ADMIN_NICKNAME"].ToString()));
Context.Response.AppendCookie(cookie);
Response.Redirect("/DataUpdate.aspx");
}
else
{
Response.Write("<script>alert('用户名密码不正确！');</script>");
}
}
/// <summary>
/// Delete operation for UserLogin
/// <param name="_Id"></param>
/// <returns></returns>
private bool Delete(Int32 _Id)
{
using (UserLoginDataAccess data = new UserLoginDataAccess(ClientContext))
{
// return if code > 0
return(data.Delete(_Id) > 0);
}
}
/// <summary>
/// Retrieve list of UserLogin.
/// </summary>
/// <param name="fillChild"></param>
/// <returns>List of UserLogin</returns>
public UserLoginList GetAll(bool fillChild)
{
UserLoginList userLoginList = new UserLoginList();
using (UserLoginDataAccess data = new UserLoginDataAccess(ClientContext))
{
userLoginList = data.GetAll();
}
if (fillChild)
{
foreach (UserLogin userLoginObject in userLoginList)
{
FillUserLoginWithChilds(userLoginObject, fillChild);
}
}
return(userLoginList);
}
/// <summary>
/// Update base of UserLogin Object.
/// Data manipulation processing for: new, deleted, updated UserLogin
/// </summary>
/// <param name="userLoginObject"></param>
/// <returns></returns>
public bool UpdateBase(UserLogin userLoginObject)
{
// use of switch for different types of DML
switch (userLoginObject.RowState)
{
// insert new rows
case BaseBusinessEntity.RowStateEnum.NewRow:
return(Insert(userLoginObject));
// delete rows
case BaseBusinessEntity.RowStateEnum.DeletedRow:
return(Delete(userLoginObject.Id));
}
// update rows
using (UserLoginDataAccess data = new UserLoginDataAccess(ClientContext))
{
return(data.Update(userLoginObject) > 0);
}
}
/// <summary>
/// Insert new userLogin.
/// data manipulation for insertion of UserLogin
/// </summary>
/// <param name="userLoginObject"></param>
/// <returns></returns>
private bool Insert(UserLogin userLoginObject)
{
// new userLogin
using (UserLoginDataAccess data = new UserLoginDataAccess(ClientContext))
{
// insert to userLoginObject
Int32 _Id = data.Insert(userLoginObject);
// if successful, process
if (_Id > 0)
{
userLoginObject.Id = _Id;
return(true);
}
else
{
return(false);
}
}
}
