public ClassesModel InsertOrUpdate(ClassesModel model)
{
if (model.Id > 0)
{
var _class = dbcontext.Classes.Find(model.Id);
if (_class != null)
{
var mappedClasses = mapper.Map <ClassesModel, Classes>(model, _class);
dbcontext.Classes.Update(mappedClasses);
dbcontext.SaveChanges();
return(model);
}
else
{
return(null);
}
}
else
{
var mappedClasses = mapper.Map <Classes>(model);
dbcontext.Classes.Add(mappedClasses);
dbcontext.SaveChanges();
return(model);
}
}
public HttpResponseMessage GetClasses()
{
CustomDataResponseModel customResponseModel = new CustomDataResponseModel();
try
{
ClassesModel objClassesModel = new ClassesModel();
List <ClassesModel> objList = new List <ClassesModel>();
objList = _iClasses.GetAll();
if (objList.Count > 0)
{
customResponseModel.type = "success";
customResponseModel.message = "";
customResponseModel.data = objList;
}
else
{
customResponseModel.type = "error";
customResponseModel.message = "No records found!";
customResponseModel.data = objList;
}
}
catch (Exception ex)
{
customResponseModel.type = "error";
customResponseModel.message = ex.Message;
customResponseModel.data = null;
return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, customResponseModel));
}
return(Request.CreateResponse(HttpStatusCode.OK, customResponseModel));
}
public async Task <IActionResult> Edit(int id, [Bind("Id,SchoolId,Name,Info")] ClassesModel classesModel)
{
if (id != classesModel.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(classesModel);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ClassesModelExists(classesModel.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["SchoolId"] = new SelectList(_context.Schools, "Id", "Id", classesModel.SchoolId);
return(View(classesModel));
}
protected override IUnitsModel GetModel()
{
IClassCollection collection = ProfilingViewModel.Application.ServiceContainer.Resolve <IClassCollection>();
ClassesModel model = new ClassesModel(collection);
return(model);
}
/// <summary>
/// 根据专业查询学生信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public DataTable GetStudentsBySpec(ClassesModel 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 b.Classes_Speciality=@0";
DataTable dt = SqlHelper.GetDataTable(sql, model.Classes_Speciality);
return(dt);
}
public int AddOrEditClasses(ClassesModel c, UserTokenModel curUser)
{
if (c.Id > 0)
{
goto editClass;
}
var ue = c.Adapt <Classes>();
ue.AddUserId = curUser.UserId;
ue.EditUserId = curUser.UserId;
ue.AddTime = DateTime.Now;
ue.EditTime = DateTime.Now;
db.Set <Classes>().Add(ue);
return(db.SaveChanges());
editClass:
var exist = db.Set <Classes>().Find(c.Id);
exist.ClassName = c.ClassName;
exist.ClassType = c.ClassType;
exist.EditTime = DateTime.Now;
exist.EditUserId = curUser.UserId;
exist.IsValid = c.IsValid;
db.Entry(exist).State = System.Data.Entity.EntityState.Modified;
return(db.SaveChanges());
}
public ActionResult DeleteConfirmed(int id)
{
ClassesModel classesModel = db.Class.Find(id);
db.Class.Remove(classesModel);
db.SaveChanges();
return(RedirectToAction("Index"));
}
/// <summary>
/// 检测班级编号
/// </summary>
/// <param name="model">班级的实体对象</param>
/// <returns>是否</returns>
public bool SeleClasses(ClassesModel model)
{
string sql = "select * from Classes where Classes_ID=@0";
SqlDataReader dr = SqlHelper.ExReader(sql, model.Classes_ID);
bool b = dr.Read();
dr.Close();
return(b);
}
public ActionResult Edit(int id)
{
@ViewBag.Main = "Updation";
@ViewBag.Sub = "Classes";
ClassesModel model = new ClassesModel();
model = _rep.Get(id);
return(View(model));
}
public ActionResult Edit([Bind(Include = "ClassId,ClassName")] ClassesModel classesModel)
{
if (ModelState.IsValid)
{
db.Entry(classesModel).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(classesModel));
}
private void benUPji_Click(object sender, EventArgs e)
{
ClassesBLL Class = new ClassesBLL();
ClassesModel model = new ClassesModel();
model.Classes_Name = this.txtjiname.Text;
model.ClassHeadTeacher = Convert.ToInt32(this.cmbbanname.SelectedValue);
model.Classes_ID = this.dataGridView1.SelectedRows[0].Cells["班级编号"].Value.ToString();
Class.UPClasses(model);
GetAllClass();
}
public ActionResult Create([Bind(Include = "ClassId,ClassName")] ClassesModel classesModel)
{
if (ModelState.IsValid)
{
db.Class.Add(classesModel);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(classesModel));
}
public async Task <IActionResult> Create(int SchoolId, [Bind("Id,Name,Info")] ClassesModel classesModel)
{
if (ModelState.IsValid)
{
classesModel.SchoolId = SchoolId;
_context.Add(classesModel);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(classesModel));
}
private void benDeleji_Click(object sender, EventArgs e)
{
ClassesBLL Class = new ClassesBLL();
ClassesModel model = new ClassesModel();
if (this.dataGridView1.SelectedRows.Count > 0)
{
model.Classes_ID = this.dataGridView1.SelectedRows[0].Cells["班级编号"].Value.ToString();
Class.DeleClasses(model);
GetAllClass();
}
}
public IActionResult add()
{
try
{
ClassesModel classesModel = new ClassesModel();
return(View(classesModel));
}
catch (Exception ex)
{
AlertHelper.setMessage(this, ex.Message, messageType.error);
return(RedirectToAction("index"));
}
}
// GET: Classes/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ClassesModel classesModel = db.Class.Find(id);
if (classesModel == null)
{
return(HttpNotFound());
}
return(View(classesModel));
}
/// <summary>
/// 在班级内按单科排名
/// </summary>
/// <param name="check">是否降序</param>
/// <param name="classmodel">班级实体对象</param>
/// <param name="submodel"></param>
/// <returns></returns>
public DataTable OrderBySingleClass(bool check, ClassesModel classmodel, SubjectsModel submodel)
{
string sql = "";
if (check == false)
{
sql = "select d.Classes_Name 班级名称,c.Subjects_Name 科目名称,b.StudentNum 学号,b.Student_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 where d.Classes_ID=@0 and c.Subjects_ID=@1 order by a.Examscore asc";
}
else
{
sql = "select d.Classes_Name 班级名称,c.Subjects_Name 科目名称,b.StudentNum 学号,b.Student_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 where d.Classes_ID=@0 and c.Subjects_ID=@1 order by a.Examscore desc";
}
return(SqlHelper.GetDataTable(sql, classmodel.Classes_ID, submodel.Subjects_ID));
}
/// <summary>
/// 生成听课安排
/// </summary>
/// <param name="sptlist"></param>
/// <param name="model"></param>
/// <param name="group"></param>
private void WritePlacement(List <SpareTimeModel> sptlist, ClassesModel model, string group)
{
ArrageModel arragemodel = new ArrageModel();
arragemodel.Cid = model.Cid;
arragemodel.SuperVisors = group.Substring(1);
arragemodel.Stauts = 0;
arragemodel.Pid = model.Cid.Trim() + sptlist[0].Week + sptlist[0].Day + sptlist[0].ClassNumber.ToString();
listarrage.Add(arragemodel);
model.CheckNumber++;
listmodfiyclass.Add(model);
foreach (SpareTimeModel spt in sptlist)
{
UpdateCheckCount(spt.Tid);
spt.Assign = 1;
}
listchange.AddRange(sptlist);
}
private void benAddji_Click(object sender, EventArgs e)
{
ClassesBLL Class = new ClassesBLL();
ClassesModel model = new ClassesModel();
model.Classes_ID = lblyy.Text + txtjibian.Text;
bool b = Class.SeleClasses(model);
if (b == true)
{
MessageBox.Show("该班级编号已经存在，请重新输入");
txtjibian.Text = "";
return;
}
model.Classes_Name = txtjiname.Text;
model.Classes_Speciality = cmbzhuan.SelectedValue.ToString();
model.ClassHeadTeacher = Convert.ToInt32(cmbbanname.SelectedValue);
Class.AddClasses(model);
GetAllClass();
}
public ActionResult Edit(ClassesModel model)
{
@ViewBag.Main = "Updation";
@ViewBag.Sub = "Classes";
if (ModelState.IsValid)
{
try
{
_rep.Edit(model);
model = new ClassesModel();
ModelState.Clear();
TempData["Message"] = "success";
TempData["SuccessMessage"] = MessageNaming.SuccessDataUpdate;
}
catch (Exception ex)
{
TempData["Message"] = "error";
TempData["ErrorMessage"] = ex.Message;
}
}
return(View(model));
}
public Tuple <List <ClassesModel>, int> Classes(ClassesModel model)
{
var where = new StringBuilder("1=1");
if (!string.IsNullOrWhiteSpace(model.KeyWord))
{
where.Append($" and u.ClassName like '%{model.KeyWord}%' ");
}
if (model.IsValid == true)
{
where.Append($" and u.IsValid=1 ");
}
var cols = @"select * ";
var sql = $@" from Classes u where {where} ";
var cntSql = $"select count(1) {sql} ";
var dataSql = $"{cols} {sql} order by u.EditTime desc OFFSET ({model.Skip}) ROW FETCH NEXT {model.PageSize} rows only ";
var cnt = db.Database.SqlQuery <int>(cntSql).First();
var data = db.Database.SqlQuery <ClassesModel>(dataSql).ToList();
return(new Tuple <List <ClassesModel>, int>(data, cnt));
}
public Task <ClassesModel> UpdateAsync(ClassesModel entity)
{
throw new NotImplementedException();
}
public ClassesModel Update(ClassesModel entity)
{
throw new NotImplementedException();
}
public void Delete(ClassesModel entity)
{
throw new NotImplementedException();
}
/// <summary>
/// 根据班级名称模糊搜索班级信息
/// </summary>
/// <param name="model">班级实体对象</param>
/// <returns>班级信息</returns>
public DataTable GetClassesByClassName(ClassesModel model)
{
return(Class.GetClassesByClassName(model));
}
public DataTable GetClassesBySpeciality(ClassesModel model)
{
DataTable dt = Class.GetClassesBySpeciality(model);
return(dt);
}
/// <summary>
/// 检测班级编号
/// </summary>
/// <returns>是否</returns>
public bool SeleClasses(ClassesModel model)
{
bool b = Class.SeleClasses(model);
return(b);
}
public Br <List <ClassesModel> > Classes(ClassesModel model)
{
var result = svc.Classes(model);
return(new Br <List <ClassesModel> >(result.Item1, extData: result.Item2));
}
public Br <int> AddOrEditClasses(ClassesModel c)
{
var result = svc.AddOrEditClasses(c, CurUser);
return(new Br <int>(result));
}
/// <summary>
/// 修改班级
/// </summary>
public void UPClasses(ClassesModel model)
{
Class.UPClasses(model);
}
