/// <summary>
/// 修改数据。必须传入Id
/// </summary>
public BaseResult UptUser(TStudentParam param)
{
if (param.Id == null)
{
return(new BaseResult(false, null, Msg.ParamError));
}
var model = new TStudent();
if (param.Name != null)
{
model.Name = param.Name;
}
if (param.IDNumber != null)
{
model.IDNumber = param.IDNumber;
}
if (param.MobilePhone != null)
{
model.MobilePhone = param.MobilePhone;
}
var count = TStudentRepository.Update(model, d => d.Id == param.Id);
//更新缓存
TStudentCache.DelUserModel(param.Id.Value);
return(new BaseResult(true));
}
private void Button1_Click(object sender, EventArgs e)
{
List <TStudent> Students = new List <TStudent>();
TStudent obj = new TStudent();
obj.FirstName = " ";
obj.MiddleName = " ";
obj.LastName = " ";
obj.EGN = " ";
Students.Add(obj);
var itemToRemove = (from st in Students
where st.FirstName == " "
select st).FirstOrDefault();
var R = Students.Where(st => st.FirstName == " ").FirstOrDefault();
var R2 = Students.FirstOrDefault(st => st.FirstName == " ");
if (itemToRemove != null)
{
Students.Remove(itemToRemove);
}
MessageBox.Show("OK!");
}
public async Task <IHttpActionResult> PutTStudent(TStudent tStudent)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Entry(tStudent).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TStudentExists(tStudent.StudentID))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public BTStudent(TStudent tStudent)
{
var config = new MapperConfiguration(cfg => cfg.CreateMap <TStudent, BTStudent>());
Mapper mapper = new Mapper(config);
BTStudent tBStudent = mapper.Map <BTStudent>(tStudent);
this.TeamId = tBStudent.TeamId;
this.StudentId = tBStudent.StudentId;
}
public async Task <IHttpActionResult> GetTStudent(int id)
{
TStudent tStudent = await db.TStudents.FindAsync(id);
if (tStudent == null)
{
return(NotFound());
}
return(Ok(tStudent));
}
public async Task <IHttpActionResult> PostTStudent(TStudent tStudent)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.TStudents.Add(tStudent);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = tStudent.StudentID }, tStudent));
}
static void Main(string[] args)
{
//
TStudent stud = new TStudent();
Console.WriteLine(stud.UserName.FullName());
Console.WriteLine(stud.UserName.ShortName());
Console.WriteLine(stud.Age.GetAgeWithDate());
stud.Age.Age = 20;
Console.WriteLine(stud.Age.GetAgeWithDate());
Console.WriteLine(stud.StudData.GetShortGroup());
Console.ReadLine();
}
public async Task <IHttpActionResult> DeleteTStudent(TStudent student)
{
TStudent tStudent = await db.TStudents.FindAsync(student.StudentID);
if (tStudent == null)
{
return(NotFound());
}
db.TStudents.Remove(tStudent);
await db.SaveChangesAsync();
return(Ok(tStudent));
}
public void LoadStudent()
{
List <TStudent> students = new List <TStudent>();
string error = string.Empty;
students = TStudent.LoadData(out error);
if (!string.IsNullOrEmpty(error))
{
MessageBox.Show("Грешка при зареждане на студент");
return;
}
cBoxElectiveSubjectStudent.DisplayMember = "FullName";
cBoxElectiveSubjectStudent.ValueMember = "ID";
cBoxElectiveSubjectStudent.DataSource = students;
}
public void LoadSTudentFirstName()
{
List <TStudent> students = new List <TStudent>();
string error = string.Empty;
students = TStudent.LoadData(out error);
if (!string.IsNullOrEmpty(error))
{
MessageBox.Show("Грешка при зареждане на Име");
return;
}
cbLecFirstName.DisplayMember = "FirstName";
cbLecFirstName.ValueMember = "ID";
cbLecFirstName.DataSource = students;
}
private void BtnNStudent_Click(object sender, EventArgs e)
{
string FirstName = txtBoxFirstName.Text;
string MiddleName = txtBoxMiddleName.Text;
string LastName = txtBoxLastName.Text;
string EGN = txtBoxEGN.Text;
TStudent obj = new TStudent();
obj.FirstName = FirstName;
obj.MiddleName = MiddleName;
obj.LastName = LastName;
obj.EGN = EGN;
buss.ListStudents.Add(obj);
var Student = buss.ListStudents.FirstOrDefault(st => st.LastName == "Ivanov");
}
/// <summary>
/// 新增数据。必须传入姓名Name，手机号MobilePhone，身份证号IDNumber
/// </summary>
public BaseResult AddUser(TStudentParam param)
{
if (string.IsNullOrWhiteSpace(param.Name) || string.IsNullOrWhiteSpace(param.MobilePhone) ||
string.IsNullOrWhiteSpace(param.IDNumber))
{
return(new BaseResult(false, null, "参数错误！"));
}
var model = new TStudent
{
Id = Guid.NewGuid(),
Name = param.Name,
IDNumber = param.IDNumber,
MobilePhone = param.MobilePhone,
CreateTime = DateTime.Now
};
var count = Db.Context.Insert <TStudent>(model);
return(new BaseResult(count > 0, count, count > 0 ? "" : "数据库受影响行数为0！"));
}
private void BtnFirstName_Click(object sender, EventArgs e)
{
string FirstName = txtBoxFirstName.Text;
string MiddleName = txtBoxMiddleName.Text;
string LastName = txtBoxLastName.Text;
string EGN = txtBoxEGN.Text;
TStudent student = new TStudent();
student.FirstName = FirstName;
student.MiddleName = MiddleName;
student.LastName = LastName;
student.EGN = EGN;
student.Save();
//buss.AddStudent(Firstname, MiddleName, LastName , EGN );
}
private List <TStudent> GetStudents(DataSet ds)
{
List <TStudent> list = new List <TStudent>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
TStudent ts = new TStudent();
ts.ID = Convert.ToInt32(dr[0].ToString());
ts.UserName = dr[1].ToString();
ts.NO = dr[2].ToString();
ts.CID = Convert.ToInt32(dr[3].ToString());
ts.Password = dr[4].ToString();
ts.Gender = dr[5].ToString();
ts.Phone = dr[6].ToString();
ts.Address = dr[7].ToString();
list.Add(ts);
}
return(list);
}
/// <summary>
/// 新增数据。必须传入姓名Name，手机号MobilePhone，身份证号IDNumber
/// </summary>
public BaseResult AddUser(TStudentParam param)
{
if (string.IsNullOrWhiteSpace(param.Name) || string.IsNullOrWhiteSpace(param.MobilePhone) ||
string.IsNullOrWhiteSpace(param.IDNumber))
{
return(new BaseResult(false, null, Msg.ParamError));
}
var model = new TStudent
{
Id = Guid.NewGuid(),
Name = param.Name,
IDNumber = param.IDNumber,
MobilePhone = param.MobilePhone,
CreateTime = DateTime.Now
};
var count = TStudentRepository.Insert(model);
//设置缓存
TStudentCache.SetUserModel(model);
return(new BaseResult(count > 0, count, count > 0 ? "" : Msg.Line0));
}
public static bool SetUserModel(TStudent model)
{
return(Set("GetUser" + model.Id, model));
}
