/// <summary>
/// 修改成绩
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnUpdateCj_Click(object sender, EventArgs e)
{
int k = this.groupBox1.Controls.Count;
List <ExaminationModel> list = new List <ExaminationModel>(k);
for (int i = 0; i < k; i++)
{
ExaminationModel exa = new ExaminationModel();
UserControl1 user = (UserControl1)groupBox1.Controls[i];
exa.SubjectsID = Convert.ToInt32(user.labSubjectName.Tag);
exa.ExamScore = int.Parse(user.txtExamination.Text.Trim());
exa.StudentID = int.Parse(this.labStuID.Text);
list.Add(exa);
}
int count = examin.UpdateExamination(k, list);
if (count == k)
{
MessageBox.Show("成绩修改成功");
BindGrade();
}
else
{
MessageBox.Show("成绩修改失败");
}
}
public async Task <object> AddPreDefinitionExamination([FromBody] ExaminationModel model)
{
try
{
var result = await _examinationContract.AddPreDefinitionExamination(_mapper.Map <ExaminationModel, ExaminationPOCO>(model));
return(JsonConvert.SerializeObject(result));
} catch (Exception ex)
{
return(false);
}
}
public async Task <bool> AddExamination([FromBody] ExaminationModel model)
{
var result = await _examinationContract.AddExamination(_mapper.Map <ExaminationModel, ExaminationPOCO>(model));
if (result)
{
return(true);
}
else
{
return(false);
}
}
public async Task <bool> AcceptPreDefinitionExamination([FromBody] ExaminationModel model)
{
try
{
if (await _examinationContract.AcceptPreDefinitionExamination(_mapper.Map <ExaminationModel, ExaminationPOCO>(model)))
{
;
}
{
//ms.SendEmail(mailModel);
return(true);
}
}
catch (Exception ex) { }
return(false);
}
public ActionResult SendOrder(ExaminationModel model)
{
ModelState.Remove("PostDate");
string captcha = AccountUtil.GetCaptcha();
if (!captcha.Equals(model.ConfirmationCode, StringComparison.OrdinalIgnoreCase))
{
ModelState.AddModelError("ConfirmationCode", "驗證碼錯誤");
if (model.QuestionSelects2 != null && model.QuestionSelects2.Count() > 0)
{
ModelState.Remove("Question2");
}
if (model.QuestionSelects3 != null && model.QuestionSelects3.Count() > 0)
{
ModelState.Remove("Question3");
}
if (model.QuestionSelects9 != null && model.QuestionSelects9.Count() > 0)
{
ModelState.Remove("Question9");
}
if (model.QuestionSelects10 != null && model.QuestionSelects10.Count() > 0)
{
ModelState.Remove("Question10");
}
}
else
{
if (model.IsValid())
{
model.Insert();
model.SendOrderOk = true;
}
}
if (model.SendOrderOk)
{
return(View("SendOrderOK"));
}
else
{
return(View("Index", model));
}
}
/// <summary>
/// 添加学生学科成绩
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAddCchengj_Click(object sender, EventArgs e)
{
//int count = groupBox1.Controls.Count;
//string score = "";
//for (int i = 0; i < count; i++)
//{
// UserControl1 user = (UserControl1)groupBox1.Controls[i];
// if (user.txtExamination.Text.Trim() == "")
// {
// score="0";
// }
// else
// {
// score = user.txtExamination.Text.Trim();
// }
// exammodel.StudentID = Convert.ToInt32(this.cmbName.SelectedValue);
// exammodel.SubjectsID =Convert.ToInt32( user.labSubjectName.Tag);
// exammodel.ExamScore =Convert.ToInt32( user.txtExamination.Text);
// examin.AddExamination(exammodel);
int k = this.groupBox1.Controls.Count;
List <ExaminationModel> list = new List <ExaminationModel>(k);
for (int i = 0; i < k; i++)
{
ExaminationModel exa = new ExaminationModel();
UserControl1 user = (UserControl1)groupBox1.Controls[i];
exa.SubjectsID = Convert.ToInt32(user.labSubjectName.Tag);
exa.ExamScore = int.Parse(user.txtExamination.Text.Trim());
exa.StudentID = int.Parse(this.labStuID.Text);
list.Add(exa);
}
int count = examin.AddExamination(k, list);
if (count == k)
{
BindGrade();
MessageBox.Show("成绩添加成功");
}
else
{
MessageBox.Show("成绩添加失败");
}
}
/// <summary>
/// Default constructor for a new patient window
/// </summary>
/// <param name="c">ClientModel object</param>
/// <param name="p">MainWindow object</param>
public PatientWindow(ClientModel c, MainWindow p)
{
InitializeComponent();
client = c;
mainWindow = p;
DataContext = client;
Title += " - " + client.FirstName + " " + client.LastName;
readOnlyPatientForm(true);
ExaminationModel examination = new ExaminationModel();
ExaminationList.AddRange(examination.GetHistory(client.ID));
MyDataGridHistory.ItemsSource = ExaminationList;
DateTime today = DateTime.Today;
AppointmentList.AddRange(appointment.FindAppointments(today.ToString("yyyy-MM-dd")));
MyDataGridPlan.ItemsSource = AppointmentList;
}
public void ExaminationDoubleClick(ExaminationModel examination)
{
eventBus.Publish(new SelectedExamination(examination.Id));
TryClose();
}
/// <summary>
/// 修改学生成绩业务方法
/// </summary>
/// <param name="model"></param>
//public void UpdateExamination(ExaminationModel model)
//{
// exam.UpdateExamination(model);
//}
/// <summary>
/// 查询某学生所有成绩
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public DataTable GetGreadByStudent(ExaminationModel model)
{
return(exam.GetGreadByStudent(model));
}
/// <summary>
/// 修改学生成绩
/// </summary>
/// <param name="model"></param>
//public void UpdateExamination(ExaminationModel model)
//{
// string sql = "update Examination set ExamScore=@0 where StudentID=@0";
// SqlHelper.ExNonQuery(sql,"修改成绩",model.StudentID);
//}
/// <summary>
/// 查询某学生所有成绩
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public DataTable GetGreadByStudent(ExaminationModel model)
{
string sql = "select * from Examination where StudentID=@0";
return(SqlHelper.GetDataTable(sql, model.StudentID));
}
/// <summary>
/// Method validates and adds a new examination record with up to 4 different eye tests
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAddSubmit_Click(object sender, RoutedEventArgs e)
{
ExaminationModel examination = new ExaminationModel();
DateTime today = DateTime.Now;
examination.Timestamp = today.ToString("yyyy-MM-dd hh:mm:ss");
examination.ClientID = client.ID;
bool vFlag = false;
if (txtSphRD.Text.Trim().Length +
txtCylRD.Text.Trim().Length +
txtAxRD.Text.Trim().Length +
txtPdRD.Text.Trim().Length > 0)
{
EyeTestModel eyeTestRD = new EyeTestModel();
eyeTestRD.ClientID = client.ID;
eyeTestRD.Eye = "R";
eyeTestRD.Vision = "D";
float parsedFloat;
int parsedInt;
eyeTestRD.Sph = float.TryParse(txtSphRD.Text, out parsedFloat) ? parsedFloat : 100;
eyeTestRD.Cyl = float.TryParse(txtCylRD.Text, out parsedFloat) ? parsedFloat : 100;
eyeTestRD.Ax = int.TryParse(txtAxRD.Text, out parsedInt) ? parsedInt : -1;
eyeTestRD.Pd = int.TryParse(txtPdRD.Text, out parsedInt) ? parsedInt : -1;
try
{
eyeTestRD.Validate();
examination.Tests.Add(eyeTestRD);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Błąd!", MessageBoxButton.OK, MessageBoxImage.Error);
vFlag = true;
}
}
if (txtSphLD.Text.Trim().Length +
txtCylLD.Text.Trim().Length +
txtAxLD.Text.Trim().Length +
txtPdLD.Text.Trim().Length > 0 && !vFlag)
{
EyeTestModel eyeTestLD = new EyeTestModel();
eyeTestLD.ClientID = client.ID;
eyeTestLD.Eye = "L";
eyeTestLD.Vision = "D";
float parsedFloat;
int parsedInt;
eyeTestLD.Sph = float.TryParse(txtSphLD.Text, out parsedFloat) ? parsedFloat : 100;
eyeTestLD.Cyl = float.TryParse(txtCylLD.Text, out parsedFloat) ? parsedFloat : 100;
eyeTestLD.Ax = int.TryParse(txtAxLD.Text, out parsedInt) ? parsedInt : -1;
eyeTestLD.Pd = int.TryParse(txtPdLD.Text, out parsedInt) ? parsedInt : -1;
try
{
eyeTestLD.Validate();
examination.Tests.Add(eyeTestLD);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Błąd!", MessageBoxButton.OK, MessageBoxImage.Error);
vFlag = true;
}
}
if (txtSphRN.Text.Trim().Length +
txtCylRN.Text.Trim().Length +
txtAxRN.Text.Trim().Length +
txtPdRN.Text.Trim().Length > 0 && !vFlag)
{
EyeTestModel eyeTestRN = new EyeTestModel();
eyeTestRN.ClientID = client.ID;
eyeTestRN.Eye = "R";
eyeTestRN.Vision = "N";
float parsedFloat;
int parsedInt;
eyeTestRN.Sph = float.TryParse(txtSphRN.Text, out parsedFloat) ? parsedFloat : 100;
eyeTestRN.Cyl = float.TryParse(txtCylRN.Text, out parsedFloat) ? parsedFloat : 100;
eyeTestRN.Ax = int.TryParse(txtAxRN.Text, out parsedInt) ? parsedInt : -1;
eyeTestRN.Pd = int.TryParse(txtPdRN.Text, out parsedInt) ? parsedInt : -1;
try
{
eyeTestRN.Validate();
examination.Tests.Add(eyeTestRN);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Błąd!", MessageBoxButton.OK, MessageBoxImage.Error);
vFlag = true;
}
}
if (txtSphLN.Text.Trim().Length +
txtCylLN.Text.Trim().Length +
txtAxLN.Text.Trim().Length +
txtPdLN.Text.Trim().Length > 0 && !vFlag)
{
EyeTestModel eyeTestLN = new EyeTestModel();
eyeTestLN.ClientID = client.ID;
eyeTestLN.Eye = "L";
eyeTestLN.Vision = "N";
float parsedFloat;
int parsedInt;
eyeTestLN.Sph = float.TryParse(txtSphLN.Text, out parsedFloat) ? parsedFloat : 100;
eyeTestLN.Cyl = float.TryParse(txtCylLN.Text, out parsedFloat) ? parsedFloat : 100;
eyeTestLN.Ax = int.TryParse(txtAxLN.Text, out parsedInt) ? parsedInt : -1;
eyeTestLN.Pd = int.TryParse(txtPdLN.Text, out parsedInt) ? parsedInt : -1;
try
{
eyeTestLN.Validate();
examination.Tests.Add(eyeTestLN);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Błąd!", MessageBoxButton.OK, MessageBoxImage.Error);
vFlag = true;
}
}
if (examination.Tests.Count > 0 & !vFlag)
{
try
{
int examinationID = examination.Add(client.ID);
examination.ID = examinationID;
foreach (EyeTestModel test in examination.Tests)
{
test.ExaminationID = examinationID;
test.Save();
}
ExaminationList.Add(examination);
ExaminationList.Reverse();
clearAddExaminationForm();
lblAddStatus.Content = "Dodano nowe badanie o ID " + examinationID;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Błąd!", MessageBoxButton.OK, MessageBoxImage.Error);
}
MyDataGridHistory.Items.Refresh();
}
}
public ActionResult Edit(ExaminationModel model, string cdts)
{
GetConditions(cdts);
model.Update();
return(RedirectToAction("AdminIndex", new { Page = model.Page, Cdts = cdts }));
}
public ActionResult Create(ExaminationModel model, string cdts)
{
GetConditions(cdts);
model.Insert();
return(View("AdminIndex"));
}
