public ActionResult GetAllSpeciality()
{
SpecialityModel S = new SpecialityModel();
DataTable dt = S.SelectAll();
return(View(dt));
}
/// <summary>
/// 根据学院查询学生信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public DataTable GetStudentsByCollege(SpecialityModel model)
{
string sql = "select a.*, e.College_Name,c.Speciality_Name,d.SpeYears_Name from Students a join Classes b on a.StudentClass=b.Classes_ID join Speciality c on b.Classes_Speciality=c.Speciality_ID join SpeYears d on c.Speciality_Years=d.SpeYears_ID join Colleges e on c.Speciality_College=e.College_ID where c.Speciality_College=@0";
DataTable dt = SqlHelper.GetDataTable(sql, model.Speciality_College);
return(dt);
}
public IActionResult GetSpeciality()
{
SpecialityModel newModel = new SpecialityModel();
newModel.newList = speciality.GetAll().ToList();
return(View("~/Views/EducationalDepartment/Speciality/Speciality.cshtml", newModel));
}
/// <summary>
/// 按照编号查询
/// </summary>
/// <param name="model">专业实体对象</param>
/// <returns>DataTable数据表</returns>
public DataTable GetIdSpeciality(SpecialityModel model)
{
string sql = "select Speciality_ID 专业编号,Speciality_Name 专业名称,College_Name 所属学院,SpeYears_Name 学制 from Speciality a join Colleges b on a.Speciality_College=b.College_ID join SpeYears c on a.Speciality_Years=SpeYears_ID where Speciality_ID like @0";
DataTable dt = SqlHelper.GetDataTable(sql, model.Speciality_ID);
return(dt);
}
public DataTable GetSpeyearbySpeciality(SpecialityModel model)
{
SpeYearsDAL SpeYear = new SpeYearsDAL();
DataTable dt = SpeYear.GetSpeyearbySpeciality(model);
return(dt);
}
/// <summary>
/// 检测专业编号
/// </summary>
/// <param name="model">专业的实体对象</param>
public bool SeleSpeciality(SpecialityModel model)
{
SpecialityDAL Speciality = new SpecialityDAL();
bool b = Speciality.SeleSpeciality(model);
return(b);
}
/// <summary>
/// 根据专业编号查询
/// </summary>
/// <param name="model">专业的实体对象</param>
/// <returns>DataTable数据表</returns>
public DataTable GetIdSpeciality(SpecialityModel model)
{
SpecialityDAL Speciality = new SpecialityDAL();
DataTable dt = Speciality.GetIdSpeciality(model);
return(dt);
}
/// <summary>
/// 根据专业查询学科
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public DataTable GetSubjectsBySpeciality(SpecialityModel model)
{
string sql = "select b.Subjects_ID,b.Subjects_Name from Sepc_Subjects a join Subjects b on a.Subjects_ID=b.Subjects_ID join Speciality c on a.Sepc_ID=Speciality_ID where c.Speciality_ID=@0";
DataTable dt = SqlHelper.GetDataTable(sql, model.Speciality_ID);
return(dt);
}
public IHttpActionResult Create([FromBody] SpecialityModel speciality)
{
u = credenciales.getUsuario();
c = credenciales.getUsuario();
var consulta = SpecialityData.Crear(speciality.Nombre, speciality.InstitucionId, u);
return(Ok(consulta));
}
public SpecialitiesViewModel()
{
this.context = new TimetableCourseProject();
context.Specialities.Load();
SpecialitiesDatabase = context.Specialities.Local;
Specialities = new ObservableCollection <Specialities>(SpecialitiesDatabase);
specialityModel = new SpecialityModel();
}
public ActionResult CreateSpeciality(FormCollection collection)
{
SpecialityModel S = new SpecialityModel();
S.SpName = collection["SpName"];
S.IsActive = (collection["IsActive"] == "true");
S.InsertSpeciality();
return(RedirectToAction("GetAllSpeciality"));
}
/// <summary>
/// 检测专业编号
/// </summary>
/// <param name="model">专业实体对象</param>
/// <returns>是 否</returns>
public bool SeleSpeciality(SpecialityModel model)
{
string sql = "select * from Speciality where Speciality_ID=@0";
SqlDataReader dr = SqlHelper.ExReader(sql, model.Speciality_ID);
bool b = dr.Read();
dr.Close();
return(b);
}
public IHttpActionResult Update(SpecialityModel speciality)
{
u = credenciales.getUsuario();
c = credenciales.getUsuario();
var consulta = SpecialityData.Actualizar(speciality.SpecialityId, speciality.Nombre, speciality.InstitucionId, u);
return(Ok(consulta));
}
public PagedList <SpecialityModel> GetAllSpecialitiesPaginated(int skip, int take, string order, string where)
{
var specialities = new List <SpecialityModel>();
var orderBy = string.IsNullOrEmpty(order) ? " order by created_on desc " : order;
var query = "select * from " + TABLE_NAME + " where is_active='y' " + where + orderBy + " limit " + take + " offset " + skip;
var rows = new DataAccessManager().ExecuteSelectQuery(query);
if (rows != null && rows.Count > 0)
{
foreach (DataRow r in rows)
{
var speciality = new SpecialityModel();
var props = typeof(SpecialityModel).GetProperties();
foreach (var prop in props)
{
var ignore = Attribute.IsDefined(prop, typeof(IgnoreSelect));
if (!ignore)
{
var attribute = prop.GetCustomAttributes(typeof(DisplayNameAttribute), true).Cast <DisplayNameAttribute>().Single();
string displayName = attribute.DisplayName;
var value = r[displayName];
var pType = prop.PropertyType;
object v = null;
if (pType == typeof(bool))
{
v = value.ToString() == "y";
}
else
{
v = value == null ? null : value;
}
var variable = prop.SetMethod;
if (!r.IsNull(displayName))
{
variable.Invoke(speciality, new object[] { v });
}
}
}
specialities.Add(speciality);
}
}
query = "select count(*) from " + TABLE_NAME + " sm where sm.is_active='y' " + where;
var totalCount = new DataAccessManager().ExecuteScalar(query);
var count = totalCount != null?int.Parse(totalCount.ToString()) : 0;
var result = new PagedList <SpecialityModel>()
{
TotalCount = count, Data = specialities
};
return(result);
}
private void cmbyuan_SelectedIndexChanged(object sender, EventArgs e)
{
SpecialityBLL Speciality = new SpecialityBLL();
SpecialityModel model = new SpecialityModel();
model.Speciality_ID = "%" + this.cmbyuan.SelectedValue.ToString() + "%";
cmbzhuan.DisplayMember = "专业名称";
cmbzhuan.ValueMember = "专业编号";
cmbzhuan.DataSource = Speciality.GetIdSpeciality(model);
}
public ActionResult AddSpeciality(SpecialityModel model)
{
if (ModelState.IsValid)
{
int record = CreateSpeciality(model.SpecialityName,
model.SpecialityEducation);
return(RedirectToAction("ViewSpecialities"));
}
return(View());
}
private void btnUPzhuan_Click(object sender, EventArgs e)
{
SpecialityBLL Speciality = new SpecialityBLL();
SpecialityModel model = new SpecialityModel();
model.Speciality_Name = txtzhuanName.Text;
model.Speciality_Years = Convert.ToInt32(cmdxuezhi.SelectedValue);
model.Speciality_ID = datazhuan.SelectedRows[0].Cells["专业编号"].Value.ToString();
Speciality.UPSpeciality(model);
GetAllSpeciality();
}
public static int CreateSpeciality(string specialityName, string specialityEducation)
{
SpecialityModel data = new SpecialityModel
{
SpecialityName = specialityName,
SpecialityEducation = specialityEducation
};
string sql = @"insert into dbo.Speciality (SpecialityName,SpecialityEducation) values(
@SpecialityName,@SpecialityEducation)";
return(SQLDataAccess.SaveData(sql, data));
}
private void SpecialityAdd_Method(object obj)
{
if (IsValid(ValidatesAddProperties, out AddErrors))
{
AddErrors += specialityModel.Add(SpecialityModel.getSpecialityObject(AddCode, AddShortName, AddFullName, AddShortFacultyName, AddQualification));
MessageBox.Show(AddErrors, "Результат добавления");
FilterSpecialities();
}
else
{
MessageBox.Show("Заполните поля корректно!", "Результат добавления");
}
}
protected void SubmitSpeciality(object sender, EventArgs e)
{
try
{
var speciality = new SpecialityModel();
speciality.Name = name.Value;
speciality.IsRare = chk_rare.Checked;
speciality.IsActive = true;
if (Request.Files.Count > 0)
{
var files = new List <string>();
for (var i = 0; i < Request.Files.Count; i++)
{
HttpPostedFile f = Request.Files[i];
if (f.ContentLength > 0)
{
var extension = Path.GetExtension(f.FileName);
var fileName = Guid.NewGuid().ToString() + "." + extension;
files.Add(fileName);
string pathToSave_100 = HttpContext.Current.Server.MapPath("~/photo/" + fileName);
f.SaveAs(pathToSave_100);
}
}
if (files.Count > 0)
{
speciality.Image = string.Join(" ", files);
}
}
speciality.Created = DateTime.UtcNow.AddHours(5).AddMinutes(30);
var sqlQuery = new Helper().GetInsertQuery <SpecialityModel>(speciality);
if (!string.IsNullOrWhiteSpace(speciality_id.Value))
{
speciality.Id = int.Parse(speciality_id.Value);
sqlQuery = new Helper().GetUpdateQuery <SpecialityModel>(speciality);
}
var dam = new DataAccessManager().ExecuteInsertUpdateQuery(sqlQuery);
if (dam)
{
Response.Redirect("Speciality", true);
}
}
catch (Exception ex)
{
action.Value = "Failed To Add Speciality!";
}
}
/// <summary>
/// 在专业内按单科排名
/// </summary>
/// <param name="check"></param>
/// <param name="classmodel"></param>
/// <param name="submodel"></param>
/// <returns></returns>
public DataTable OrderBySingleSpeciality(bool check, SpecialityModel spemodel, SubjectsModel submodel)
{
string sql = "";
if (check == false)
{
sql = "select b.Student_Name 学生姓名,b.StudentNum 学号,e.Speciality_Name 专业名称,c.Subjects_Name 科目名称,a.ExamScore 成绩 from Examination a join Students b on a.StudentID = b.Student_ID join Subjects c on a.SubjectsID = c.Subjects_ID join Classes d on b.StudentClass = d.Classes_ID join Speciality e on d.Classes_Speciality = e.Speciality_ID where Speciality_ID = @0 and c.Subjects_ID = @1 order by a.ExamScore asc";
}
else
{
sql = "select b.Student_Name 学生姓名,b.StudentNum 学号,e.Speciality_Name 专业名称,c.Subjects_Name 科目名称,a.ExamScore 成绩 from Examination a join Students b on a.StudentID = b.Student_ID join Subjects c on a.SubjectsID = c.Subjects_ID join Classes d on b.StudentClass = d.Classes_ID join Speciality e on d.Classes_Speciality = e.Speciality_ID where Speciality_ID = @0 and c.Subjects_ID = @1 order by a.ExamScore desc";
}
return(SqlHelper.GetDataTable(sql, spemodel.Speciality_ID, submodel.Subjects_ID));
}
private void btnDelezhuan_Click(object sender, EventArgs e)
{
SpecialityBLL Speciality = new SpecialityBLL();
SpecialityModel model = new SpecialityModel();
model.Speciality_ID = this.datazhuan.SelectedRows[0].Cells["专业编号"].Value.ToString();
try
{
Speciality.DeleSpeciality(model);
GetAllSpeciality();
}
catch
{
MessageBox.Show("删除失败");
}
}
private void button5_Click(object sender, EventArgs e)
{
SpecialityBLL Speciality = new SpecialityBLL();
SpecialityModel model = new SpecialityModel();
model.Speciality_ID = "%" + txtzhuanchaname.Text + "%";
model.Speciality_Name = "%" + txtzhuanchaname.Text + "%";
if (this.cmbchalei.SelectedIndex == 0)
{
datazhuan.DataSource = Speciality.GetIdSpeciality(model);
}
else
{
datazhuan.DataSource = Speciality.GetNameSpeciality(model);
}
}
public SpecialityModel GetSpecialityById(string id)
{
var speciality = new SpecialityModel();
var query = "select * from " + TABLE_NAME + " where is_active='y' and " + TABLE_ID + " ='" + id + "' order by created_on desc";
var rows = new DataAccessManager().ExecuteSelectQuery(query);
if (rows != null && rows.Count > 0)
{
var r = rows[0];
var props = typeof(SpecialityModel).GetProperties();
foreach (var prop in props)
{
var ignore = Attribute.IsDefined(prop, typeof(IgnoreUpdate));
if (!ignore)
{
var attribute = prop.GetCustomAttributes(typeof(DisplayNameAttribute), true).Cast <DisplayNameAttribute>().Single();
string displayName = attribute.DisplayName;
var value = r[displayName];
var pType = prop.PropertyType;
object v = null;
if (pType == typeof(bool))
{
v = value.ToString() == "y";
}
else
{
v = value == null ? null : value;
}
var variable = prop.SetMethod;
if (!r.IsNull(displayName))
{
variable.Invoke(speciality, new object[] { v });
}
}
}
}
return(speciality);
}
private void SpecialityRemove_Method(object obj)
{
if (editButtonContent.Equals("Изменить"))
{
if (IsValid(ValidatesChangeProperties, out ChangeErrors))
{
ChangeErrors = specialityModel.Remove(SpecialityModel.getSpecialityObject(changeCode, changeShortName, changeFullName, changeShortFacultyName, changeQualification));
MessageBox.Show(ChangeErrors, "Результат удаления");
FilterSpecialities();
}
else
{
MessageBox.Show("Заполните корректно поля!", "Результат удаления");
}
}
else
{
MessageBox.Show("Для удаления отмените операцию \"Изменение\" нажав на кнопку\"Отмена\"", "", MessageBoxButton.OK, MessageBoxImage.Exclamation);
}
}
public UniversityModel GetUniversityModel()
{
var model = new UniversityModel();
model.Name = _name;
foreach (var item in _files)
{
var sModel = new SpecialityModel {
Name = item.Key
};
var vals = _xlsParser.Parse(item.Value, 11);
sModel.AcceptNumber = vals[4][0];
var order = 0;
for (int i = 7; i < vals.Count; i++)
{
var fio = vals[i][1];
if (string.IsNullOrEmpty(fio))
{
continue;
}
var abit = new AbiturientModel
{
Order = ++order,
Fio = fio,
Ege = int.Parse(vals[i][2]),
IsImmidiate = !string.IsNullOrEmpty(vals[i][9]),
AnotherDirection = !string.IsNullOrEmpty(vals[i][10])
};
sModel.Abiturients.Add(abit);
}
model.Specialities.Add(sModel);
}
return(model);
}
private void SpecialityChange_Method(object obj)
{
if (editButtonContent.Equals("Изменить"))
{
if (IsValid(ValidatesChangeProperties, out ChangeErrors))
{
if (specialityModel.IsExist(SpecialityModel.getSpecialityObject(changeCode, changeShortName, changeFullName, changeShortFacultyName, changeQualification)))
{
EditButtonContent = "Сохранить";
CancelVisibility = Visibility.Visible;
changedSpeciality = SpecialityModel.getSpecialityObject(changeCode, changeShortName, changeFullName, changeShortFacultyName, changeQualification);
return;
}
else
{
MessageBox.Show("Изменяемого объекта не существует", "Результат изменения");
}
}
else
{
MessageBox.Show("Заполните корректно поля!", "Результат Изменения");
}
}
else if (editButtonContent.Equals("Сохранить"))
{
if (IsValid(ValidatesChangeProperties, out ChangeErrors))
{
ChangeErrors += specialityModel.Change(changedSpeciality, SpecialityModel.getSpecialityObject(changeCode, changeShortName, changeFullName, changeShortFacultyName, changeQualification));
MessageBox.Show(ChangeErrors, "Результат изменения");
EditButtonContent = "Изменить";
CancelVisibility = Visibility.Collapsed;
FilterSpecialities();
}
else
{
MessageBox.Show("Заполните корректно поля!", "Результат изменения");
}
}
}
private void btnAddzhuan_Click(object sender, EventArgs e)
{
SpecialityBLL Speciality = new SpecialityBLL();
SpecialityModel model = new SpecialityModel();
model.Speciality_ID = lblCollegeId.Text + this.txtzhuanbian.Text;
bool b = Speciality.SeleSpeciality(model);
if (b == true)
{
MessageBox.Show("编号已存在，请重新输入");
this.txtzhuanbian.Text = "";
return;
}
if (string.IsNullOrEmpty(this.txtzhuanbian.Text))
{
MessageBox.Show("专业编号不能为空");
return;
}
if (this.txtzhuanbian.Text.Length != 2)
{
MessageBox.Show("专业编号必须两位");
this.txtzhuanbian.Text = "";
return;
}
if (string.IsNullOrEmpty(this.txtzhuanName.Text))
{
MessageBox.Show("专业名称不能为空");
return;
}
model.Speciality_Name = this.txtzhuanName.Text;
model.Speciality_College = this.cmdyuanName.SelectedValue.ToString();
model.Speciality_Years = Convert.ToInt32(this.cmdxuezhi.SelectedValue);
Speciality.AddSpeciality(model);
GetAllSpeciality();
}
/// <summary>
/// 根据专业名称和班主任名称模糊搜索班级信息
/// </summary>
/// <param name="specmodel">专业实体对象</param>
/// <param name="teamodel">班主任实体对象</param>
/// <returns>班级信息</returns>
public DataTable GetClassesBySpecialityAndTeacher(SpecialityModel specmodel, TeachersModel teamodel)
{
return(Class.GetClassesBySpecialityAndTeacher(specmodel, teamodel));
}
/// <summary>
/// 根据专业名称模糊搜索班级信息
/// </summary>
/// <param name="model">专业实体对象</param>
/// <returns>班级信息</returns>
public DataTable GetClassesBySpecialityName(SpecialityModel model)
{
return(Class.GetClassesBySpecialityName(model));
}
