private void button1_Click(object sender, EventArgs e)
{
Model.Student student = new Model.Student()
{
StuId = this.textBox1.Text.Trim(),
StuPsd = this.textBox2.Text.Trim()
};
Model.Student studentLogin = studentLogic.UserLogin(student);
if (studentLogin == null)
{
MessageBox.Show("账号或密码错误，请重新输入");
return;
}
else
{
this.DialogResult = DialogResult.OK;
//MessageBox.Show("登陆成功");
this.uid = student.StuId;
学生 a = new 学生(this.uid);//新窗体弹窗，旧的隐藏
this.Hide();
a.ShowDialog();
this.Show();
}
}
public Model.Student UserLogin(Model.Student student)
{
string sql = "select * from dbo.student where id=@id and psw=@psw";
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@id", student.StuId),
new SqlParameter("@psw", student.StuPsd)
};
try
{
SqlDataReader reader = SqlDbHelper.GetDataReader(sql, paras);
if (reader.Read())
{
student.StuId = reader["id"].ToString();
}
else
{
student = null;
}
reader.Close();
}
catch (Exception ex)
{
throw ex;
}
return(student);
}
/// <summary>
/// 序列化保存测试
/// </summary>
/// <param name="type"></param>
public static void SaveTest(JsonToolType type)
{
var path = Environment.CurrentDirectory + "\\json.txt";
if (File.Exists(path))
{
File.Delete(path);
}
int length = 100000;
List <Student> list = new List <Model.Student>();
for (var i = 0; i < length; i++)
{
Student student = new Model.Student();
student.ID = i;
student.Name = "Student" + i;
student.Mobile = i.ToString();
student.Address = "city" + i.ToString();
list.Add(student);
}
var date1 = DateTime.Now;
SaveJsonFile <Student>(list, path, type, 1000);
var date2 = DateTime.Now;
Console.WriteLine("序列化用时:{0}秒", (date2 - date1).TotalSeconds);
}
public object getByStuId(string stuId)
{
Student stu = null;
string selectSql = "SELECT * FROM t_student WHERE stuId=@stuId";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@stuId", stuId) };
DataSet ds = SQLServerDBUtil.query(selectSql, sqlParas);
if (ds.Tables[0].Rows.Count != 0)
{
stu = new Student();
stu.Id = ds.Tables[0].Rows[0][0].ToString();
stu.StuId = ds.Tables[0].Rows[0][1].ToString();
stu.Name = ds.Tables[0].Rows[0][2].ToString();
stu.Gender = ds.Tables[0].Rows[0][3].ToString();
stu.Birth = ds.Tables[0].Rows[0][4].ToString();
stu.Phone = ds.Tables[0].Rows[0][5].ToString();
stu.Address = ds.Tables[0].Rows[0][6].ToString();
stu.ClassID = ds.Tables[0].Rows[0][7].ToString();
stu.UserID = ds.Tables[0].Rows[0][8].ToString();
}
return stu;
}
public AddStudent(Student stu,StudentContext context)
{
InitializeComponent();
BindClassesComboxData();
this.stu = stu;
this.context = context;
}
public IHttpActionResult PutStudent(int id, Student student)
{
if (!ModelState.IsValid)
{
return BadRequest(ModelState);
}
if (id != student.StudentId)
{
return BadRequest();
}
db.Entry(student).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!StudentExists(id))
{
return NotFound();
}
else
{
throw;
}
}
return StatusCode(HttpStatusCode.NoContent);
}
//根据学员编号获取学员信息
//public Model.Student GetStudentBLL(string id)
//{
// return new DAL.StudentDAL().GetStudentDAL(" and [StudentID]='" + id + "'")[0];
//}
//添加新学员
public int InsertStudentBLL(Model.Student stu)
{
if (!new Rule.StudentRule().TestInsert(stu.StudentID))
{
return(-3);
}
return(new DAL.StudentDAL().InsertStudentDAL(stu));
}
public void Add(Student student)
{
this.OpenPage();
if (StudentsInCoursesPage.Instance.FindExistingStudentIncourseRowIndex(student) != int.MaxValue)
{
this.DeleteStudentInCourse(student);
}
this.UpdateForm(student);
}
public IHttpActionResult PostStudent(Student student)
{
if (!ModelState.IsValid)
{
return BadRequest(ModelState);
}
db.Students.Add(student);
db.SaveChanges();
return CreatedAtRoute("DefaultApi", new { id = student.StudentId }, student);
}
//更新学员信息
public int UpdateStudentDAL(Model.Student stu)
{
string sql = "Update [Student] set [State]=0";
if (!string.IsNullOrEmpty(stu.StudentName))
{
sql += ",[StudentName]='" + stu.StudentName + "'";
}
if (!string.IsNullOrEmpty(stu.Age.ToString()))
{
sql += ",[Age]='" + stu.Age + "'";
}
if (!string.IsNullOrEmpty(stu.Gender))
{
sql += ",[Gender]='" + stu.Gender + "'";
}
if (!string.IsNullOrEmpty(stu.dormitoryID.ToString()))
{
sql += ",[dormitoryID]='" + stu.dormitoryID + "'";
}
if (!string.IsNullOrEmpty(stu.Place))
{
sql += ",[Place]='" + stu.Place + "'";
}
if (!string.IsNullOrEmpty(stu.Accommodationtime.ToString()))
{
sql += ",[Accommodationtime]='" + stu.Accommodationtime + "'";
}
if (!string.IsNullOrEmpty(stu.leavetime.ToString()))
{
sql += ",[leavetime]='" + stu.leavetime + "'";
}
if (!string.IsNullOrEmpty(stu.Phone))
{
sql += ",[Phone]='" + stu.Phone + "'";
}
if (!string.IsNullOrEmpty(stu.Explains))
{
sql += ",[Explains]='" + stu.Explains + "'";
}
sql += " where [StudentID]='" + stu.StudentID + "'";
return(DBHelper.ExecQuery(sql));
}
private void btnAddStudent_Click(object sender, EventArgs e)
{
var stu = new Student();
var student = new AddStudent(stu,context);
if (student.ShowDialog() == DialogResult.OK)
{
context.Students.Add(stu);
context.SaveChanges();
ClearStudentsData();
}
}
/// <summary>
/// Register user with adding one to database
/// </summary>
/// <param name="name">Name of new user</param>
/// <param name="surname">Surname of new user</param>
/// <param name="zal">Student ticket number of new user</param>
/// <param name="username">Username of new user</param>
/// <param name="password">Password of new user</param>
/// <returns></returns>
public bool registerUser(ParamsForRegister values)
{
Model.Person person = new Model.Person {
Name = values.name, Surname = values.surname, Password = values.password, Photo = userPhoto, Username = values.username
};
Model.Student student = new Model.Student {
TicketNumber = long.Parse(values.ticket), ReportCard = long.Parse(values.zal), PersonID = values.username, GroupID = values.group
};
if (service.LoadLogInPersonAsync(values.username) == null)
{
service.CreatePersonAsync(person).Wait();
service.CreateStudentAsync(student).Wait();
return(true);
}
else
{
return(false);
}
}
// if (Info != null)
// {
// for (int index = 0; index < Info.Tables.Rows.Count; index++)
// {
// Model.Student element = new Model.Student();
// element.Id = Convert.ToInt32(Info.Tables.Rows[0]["student_id"].ToString());
// element.Name = Info.Tables[index].Rows[0]["student_name"].ToString();
// element.Gender = Info.Tables[index].Rows[0]["student_gender"].ToString();
// element.PhoneNumber = Convert.ToInt64(Info.Tables[index].Rows[0]["student_phone"].ToString());
// element.Marks = Convert.ToInt16(Info.Tables[index].Rows[0]["student_marks"].ToString());
// element.Address = Info.Tables[index].Rows[0]["student_address"].ToString();
// result.Add(element);
// }
// }
// return result;
//}
public Student GetStudentById(int Id)
{
var dbManager = new DBManager("connection");
var parameters = new List <IDbDataParameter>();
// parameters.Add(dbManager.CreateParameter("@Event", "SelectById", DbType.String));
parameters.Add(dbManager.CreateParameter("@Student_id", Id, DbType.Int32));
var Info = dbManager.GetDataTable("SelectById", CommandType.StoredProcedure, parameters.ToArray());
Student element = new Model.Student();
element.Id = Convert.ToInt32(Info.Rows[0]["student_id"].ToString());
element.Name = Info.Rows[0]["studentFirst_Name"].ToString();
element.Gender = Info.Rows[0]["student_Gender"].ToString();
element.PhoneNumber = Convert.ToInt64(Info.Rows[0]["studentMobile_Number"].ToString());
// element.Marks = Convert.ToInt16(Info.Rows[0]["student_marks"].ToString());
element.Address = Info.Rows[0]["student_Address"].ToString();
return(element);
}
public static void Main()
{
string message = "Hello!";
char[] substring = Operations.Subsequence(message.ToCharArray(), 2, 3);
Console.WriteLine(substring);
int[] array = new int[] { -1, 3, 2, 1 };
int[] subArray = Operations.Subsequence(array, 0, 2);
Console.WriteLine(string.Join(" ", subArray));
int[] fullArray = Operations.Subsequence(array, 0, 4);
Console.WriteLine(string.Join(" ", fullArray));
int[] emptyArray = Operations.Subsequence(array, 0, 0);
Console.WriteLine(string.Join(" ", emptyArray));
Console.WriteLine(Operations.ExtractEnding("I love C#", 2));
Console.WriteLine(Operations.ExtractEnding("Nakov", 4));
Console.WriteLine(Operations.ExtractEnding("beer", 4));
// Console.WriteLine(Operations.ExtractEnding("Hi", 100));
Console.WriteLine(Operations.CheckPrime(23));
Console.WriteLine(Operations.CheckPrime(33));
List<Exam> peterExams = new List<Exam>()
{
new SimpleMathExam(2),
new CSharpExam(55),
new CSharpExam(100),
new SimpleMathExam(1),
new CSharpExam(0),
};
Student peter = new Student("Peter", "Petrov", peterExams);
double peterAverageResult = peter.CalcAverageExamResultInPercents();
Console.WriteLine("Average results = {0:p0}", peterAverageResult);
}
private void frmNewStudent_Load(object sender, EventArgs e)
{
LoadCombos();
if (this.did > 0)
{
Model.Student degObj = DAL.StudentsDAL.GetStudentByID(this.did);
if (degObj != null)
{
lblStudentID.Text = degObj.StudentID.ToString();
txtName.Text = degObj.Name;
txtNIC.Text = degObj.NIC;
cmbGender.SelectedValue = degObj.Gender;
txtFavSports.Text = degObj.FavSports;
txtMobileNo.Text = degObj.MobileNo;
txtHomeNo.Text = degObj.HomeNo;
cmbDegree.SelectedValue = degObj.DegreeID;
txtCurrentSemesterNo.Text = degObj.CurrentSemesterNo.ToString();
} //End of If
} //end of outer if
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtName.Text.Trim() == "")
{
MessageBox.Show("Name can't be empty");
return;
}
Model.Student degObj = new Model.Student();
degObj.StudentID = this.did; //For New, this will be zero
degObj.Name = txtName.Text.Trim();
degObj.NIC = txtNIC.Text.Trim();
degObj.Gender = cmbGender.SelectedValue.ToString();
degObj.FavSports = txtFavSports.Text.Trim();
degObj.MobileNo = txtMobileNo.Text.Trim();
degObj.HomeNo = txtHomeNo.Text.Trim();
degObj.DegreeID = Convert.ToInt32(cmbDegree.SelectedValue);
degObj.CurrentSemesterNo = Convert.ToInt32(txtCurrentSemesterNo.Text.Trim());
int id = DAL.StudentsDAL.SaveStudent(degObj);
if (id > 0)
{
MessageBox.Show("Data has been saved");
lblStudentID.Text = "";
txtName.Text = "";
txtNIC.Text = "";
cmbGender.SelectedIndex = 0;
txtFavSports.Text = "";
txtMobileNo.Text = "";
txtHomeNo.Text = "";
cmbDegree.SelectedIndex = 0;
txtCurrentSemesterNo.Text = "";
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtName.Text.Trim() == "")
{
MessageBox.Show("Name can't be empty");
return;
}
Model.Student degObj = new Model.Student();
degObj.StudentID = this.did; //For New, this will be zero
degObj.Name = txtName.Text.Trim();
degObj.NIC = txtNIC.Text.Trim();
degObj.Gender = cmbGender.SelectedValue.ToString();
degObj.FavSports = txtFavSports.Text.Trim();
degObj.MobileNo = txtMobileNo.Text.Trim();
degObj.HomeNo = txtHomeNo.Text.Trim();
degObj.DegreeID = Convert.ToInt32(cmbDegree.SelectedValue);
degObj.CurrentSemesterNo = Convert.ToInt32(txtCurrentSemesterNo.Text.Trim());
int id = DAL.StudentsDAL.SaveStudent(degObj);
if (id > 0)
{
MessageBox.Show("Data has been saved");
lblStudentID.Text = "";
txtName.Text = "";
txtNIC.Text = "";
cmbGender.SelectedIndex = 0;
txtFavSports.Text = "";
txtMobileNo.Text = "";
txtHomeNo.Text = "";
cmbDegree.SelectedIndex = 0;
txtCurrentSemesterNo.Text = "";
}
}
public List <Model.Student> GetInfo()
{
List <Model.Student> result = new List <Model.Student>();
var dbManager = new DBManager("connection");
var parameters = new List <IDbDataParameter>();
// parameters.Add(dbManager.CreateParameter("@Event", "Select", DbType.String));
var Info = dbManager.GetDataTable("Select_Student", CommandType.StoredProcedure, parameters.ToArray());
for (int index = 0; index < Info.Rows.Count; index++)
{
Model.Student element = new Model.Student();
element.Id = Convert.ToInt32(Info.Rows[index]["student_id"].ToString());
element.Name = Info.Rows[index]["studentFirst_Name"].ToString();
element.Gender = Info.Rows[index]["student_Gender"].ToString();
element.PhoneNumber = Convert.ToInt64(Info.Rows[index]["studentMobile_Number"].ToString());
// element.Marks = Convert.ToInt16(Info.Rows[index]["student_marks"].ToString());
element.Address = Info.Rows[index]["student_Address"].ToString();
result.Add(element);
}
return(result);
}
public Model.Student UserLogin(Model.Student student)
{
return(studentDao.UserLogin(student));
}
//添加新学员
public int InsertStudentDAL(Model.Student stu)
{
return(DBHelper.ExecQuery("Insert into [Student] ([StudentName],[Age],[Gender],[dormitoryID],[Place],[Accommodationtime],[leavetime],[Phone],[Explains]) values('" + stu.StudentName + "','" + stu.Age + "','" + stu.Gender + "','" + stu.dormitoryID + "','" + stu.Place + "','" + stu.Accommodationtime + "','" + stu.leavetime + "','" + stu.Phone + "','" + stu.Explains + "')"));
}
public void DeleteStudentInCourse(Student student)
{
StudentsInCoursesPage.Instance.Browser.Manager.DialogMonitor.AddDialog(new ConfirmDialog(StudentsInCoursesPage.Instance.Browser, DialogButton.OK));
StudentsInCoursesPage.Instance.Browser.Manager.DialogMonitor.Start();
var rowForDeleteIndex = StudentsInCoursesPage.Instance.FindExistingStudentIncourseRowIndex(student);
var buttonToClick = StudentsInCoursesPage.Instance.GridPage.DeleteButton[rowForDeleteIndex];
buttonToClick.ScrollToVisible();
buttonToClick.Click();
}
//更新学员信息
public string UpdateStudentBLL(Model.Student stu)
{
return(Option(new DAL.StudentDAL().UpdateStudentDAL(stu), "更新"));
}
public Student GetUnenrolledStudent()
{
CoursesUnenrolledStudentsPage helpPage = new CoursesUnenrolledStudentsPage();
helpPage.Navigate();
helpPage.VerifyTitle();
Thread.Sleep(1000);
helpPage.Browser.RefreshDomTree();
string name = helpPage.GridPage.GridTable.Rows[0].Cells[2].InnerText;
string course = helpPage.GridPage.GridTable.Rows[0].Cells[1].InnerText;
Student student = new Student(name, course);
return student;
}
public void AssertNewUserInCourseIsCreated(Student user)
{
Thread.Sleep(2000);
StudentsInCoursesPageAsserter.AssertStudentInCourseIsEnrolled(StudentsInCoursesPage.Instance, user);
}
public void UpdateForm(Student student)
{
StudentsInCoursesPage.Instance.OpenStudentsInCourseForm();
StudentsInCoursesFormPage.Instance.FillData(student);
StudentsInCoursesFormPage.Instance.UpdateButton.MouseClick();
}
