public List <UsersInfo> UsersInfo_Paging(string CurentPage, string PageSize) { List <DataAccess.UsersInfo> list = new List <DataAccess.UsersInfo>(); DataAccess.UsersInfo obj = new DataAccess.UsersInfo(); DbCommand cmd = db.GetStoredProcCommand("Users_SelectPage", CurentPage, PageSize); using (IDataReader dr = db.ExecuteReader(cmd)) { while (dr.Read()) { list.Add(obj.UsersInfoIDataReader(dr)); } dr.Close(); dr.Dispose(); } return(list); }
public List <UsersInfo> UsersInfo_GetByAll() { List <DataAccess.UsersInfo> list = new List <DataAccess.UsersInfo>(); DataAccess.UsersInfo obj = new DataAccess.UsersInfo(); DbCommand cmd = db.GetStoredProcCommand("Users_SelectAll"); using (IDataReader dr = db.ExecuteReader(cmd)) { while (dr.Read()) { list.Add(obj.UsersInfoIDataReader(dr)); } dr.Close(); dr.Dispose(); } return(list); }
public UsersInfo UsersInfoIDataReader(IDataReader dr) { DataAccess.UsersInfo obj = new DataAccess.UsersInfo(); obj.UserID = (dr["UserID"] is DBNull) ? string.Empty : dr["UserID"].ToString(); obj.UserName = (dr["UserName"] is DBNull) ? string.Empty : dr["UserName"].ToString(); obj.Password = (dr["Password"] is DBNull) ? string.Empty : dr["Password"].ToString(); obj.FullName = (dr["FullName"] is DBNull) ? string.Empty : dr["FullName"].ToString(); obj.Gender = (dr["Gender"] is DBNull) ? string.Empty : dr["Gender"].ToString(); obj.Avatar = (dr["Avatar"] is DBNull) ? string.Empty : dr["Avatar"].ToString(); obj.Birthday = (dr["Birthday"] is DBNull) ? string.Empty : dr["Birthday"].ToString(); obj.Email = (dr["Email"] is DBNull) ? string.Empty : dr["Email"].ToString(); obj.Address = (dr["Address"] is DBNull) ? string.Empty : dr["Address"].ToString(); obj.MobilePhone = (dr["MobilePhone"] is DBNull) ? string.Empty : dr["MobilePhone"].ToString(); obj.IdentityCard = (dr["IdentityCard"] is DBNull) ? string.Empty : dr["IdentityCard"].ToString(); obj.LastLoggedOn = (dr["LastLoggedOn"] is DBNull) ? string.Empty : dr["LastLoggedOn"].ToString(); obj.CreatedDate = (dr["CreatedDate"] is DBNull) ? string.Empty : dr["CreatedDate"].ToString(); obj.GroupID = (dr["GroupID"] is DBNull) ? string.Empty : dr["GroupID"].ToString(); obj.Level = (dr["Level"] is DBNull) ? string.Empty : dr["Level"].ToString(); obj.Active = (dr["Active"] is DBNull) ? string.Empty : dr["Active"].ToString(); obj.Ord = (dr["Ord"] is DBNull) ? string.Empty : dr["Ord"].ToString(); obj.Admin = (dr["Admin"] is DBNull) ? string.Empty : dr["Admin"].ToString(); return(obj); }
protected void Update_Click(object sender, EventArgs e) { if (Page.IsValid) { DataAccess.UsersInfo obj = new DataAccess.UsersInfo(); obj.UserID = Id; obj.FullName = txtName.Text; obj.UserName = txtUsername.Text; obj.Gender = rdGender.SelectedValue; obj.Avatar = txtAvatar.Text; obj.Birthday = cldBirthday.SelectedDate.ToString().Trim(); //obj.Birthday = cldBirthday.SelectedDate; obj.Email = txtEmail.Text; obj.Address = txtAddress.Text; obj.MobilePhone = txtPhoneNumber.Text; obj.GroupID = ddlGroupUser.SelectedValue; obj.Level = ddlGroupUser.SelectedValue; obj.Admin = txtAdmin.Text != "" ? txtAdmin.Text : "1"; obj.Ord = txtOrd.Text != "" ? txtOrd.Text : "1"; obj.Active = chkActive.Checked ? "1" : "0"; if (Insert == true) { obj.Password = md5(txtPassword.Text); //UsersService.UsersInfo_Insert(obj); } else { obj.Password = md5(txtPassword.Text != "" ? StringClass.Encrypt(txtPassword.Text) : Password); UsersService.UsersInfo_Update(obj); } BindGrid(); pnView.Visible = true; pnUpdate.Visible = false; Level = ""; Insert = false; } }