//更新管理员信息 public int UpdateAdministrator(Model.Administrator admin) { string sql = "Update [Administrator] set [State]=0"; if (!string.IsNullOrEmpty(admin.APassword)) { sql += ",[APassword]='" + admin.APassword + "'"; } if (!string.IsNullOrEmpty(admin.AdminName)) { sql += ",[AdminName]='" + admin.AdminName + "'"; } if (!string.IsNullOrEmpty(admin.Account)) { sql += ",[Account]='" + admin.Account + "'"; } if (!string.IsNullOrEmpty(admin.Explains)) { sql += ",[Explains]='" + admin.Explains + "'"; } sql += " where [AdminID]='" + admin.AdminID + "'"; return(DBHelper.ExecQuery(sql)); }
//管理员信息集合,根据条件查询管理员信息 public List <Model.Administrator> GetAdministrator(string whereStr = null, int start = 1, int end = 10) { List <Model.Administrator> admin = new List <Model.Administrator>(); if (DBHelper.OpenConnection()) { SqlDataReader dr = DBHelper.ExecReader("select * from [Administrator] where [State]=0 " + whereStr); if (dr != null) { Model.Administrator ad = null; while (dr.Read()) { ad = new Administrator(); ad.Account = dr["Account"].ToString(); ad.AdminID = dr["AdminID"].ToString(); ad.AdminName = dr["AdminName"].ToString(); ad.APassword = dr["APassword"].ToString(); ad.Explains = dr["Explains"].ToString(); ad.State = (int)dr["State"]; admin.Add(ad); } dr.Close(); } DBHelper.CloseConnection(); } return(admin); }
//添加新用户 public int InsertAdminBLL(Model.Administrator admin) { if (!new Rule.AdministratorRule().TestInsert(admin.Account)) { return(-3); } admin.APassword = Encryption(admin.APassword); return(new DAL.AdministratorDAL().InsertAdministrator(admin)); }
private void InsertNow_Click_1(object sender, RoutedEventArgs e) { try { //names, lastName, secondLastName, address, phone, birthDate,gender,startDate,email if (txtname.Text != "" && txtlastname.Text != "" && txtAddress.Text != "" && txtPhone.Text != "" && txtBirth.Text != "" && txtGender.Text != "" && txtemail.Text != "" && txtposition.Text != "" && txtprofesion.Text != "" && txtspeciality.Text != "") { string second; if (txtsecondlastname.Text == null) { second = ""; } else { second = txtsecondlastname.Text; } ad = new Model.Administrator(txtname.Text, txtlastname.Text, txtsecondlastname.Text, txtAddress.Text, txtPhone.Text, txtBirth.SelectedDate.Value, txtGender.Text, txtstart.SelectedDate.Value, txtemail.Text, ubicationPoint.Latitude, ubicationPoint.Longitude, byte.Parse(idTown.ToString()), pathImagePortada, txtposition.Text, txtprofesion.Text, txtspeciality.Text); administratorImpl = new AdministratorImpl(); administratorImpl.InsertTransaction(ad); image = new BitmapImage(); image.BeginInit(); image.CacheOption = BitmapCacheOption.OnLoad; image.UriSource = new Uri(DBImplementation.pathImages + 0 + ".png"); image.EndInit(); imagesector.Source = image; pathImagePortada = null; MessageBox.Show("Administrator Inserted"); } else { MessageBox.Show("Don't leave data empty"); } } catch (Exception ex) { MessageBox.Show("Something happened \nCommunicate with the Suport department \[email protected]"); } }
//添加管理员信息 public int InsertAdministrator(Model.Administrator admin) { return(DBHelper.ExecQuery("Insert into [Administrator]([AdminName],[Account],[APassword]) values('" + admin.AdminName + "','" + admin.Account + "','" + admin.APassword + "')")); }