//更新管理员信息
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 + "')"));
}
