/// <summary>
/// 检测学院编号是否存在
/// </summary>
/// <param name="model">学院的实体对象</param>
public bool SeleColleges(CollegesModel model)
{
CollegesDAL College = new CollegesDAL();
bool b = College.SeleCollege(model);
return(b);
}
/// <summary>
/// 按照编号查询
/// </summary>
/// <param name="model">学院的实体对象</param>
/// <returns>DataTable数据表</returns>
public DataTable GetIDColleges(CollegesModel model)
{
CollegesDAL College = new CollegesDAL();
DataTable dt = College.GetIDColleges(model);
return(dt);
}
/// <summary>
/// 按编号查询学院信息
/// </summary>
/// <param name="model">学院的实体对象</param>
/// <returns>DataTable数据表</returns>
public DataTable GetIDColleges(CollegesModel model)
{
string sql = "select College_ID 学院编号,College_Name 学院名称 from Colleges where College_ID like @0";
DataTable dt = SqlHelper.GetDataTable(sql, model.College_ID);
return(dt);
}
/// <summary>
/// 检测学院是否存在的数据访问方法
/// </summary>
/// <param name="model">学院的实体对象</param>
/// <returns>是或否</returns>
public bool SeleCollege(CollegesModel model)
{
string sql = "select College_ID 学院编号,College_Name 学院名称 from Colleges where College_ID=@0";
SqlDataReader dr = SqlHelper.ExReader(sql, model.College_ID);
bool b = dr.Read();
dr.Close();
return(b);
}
private void btnyuanUpdate_Click(object sender, EventArgs e)
{
CollegesBLL college = new CollegesBLL();
CollegesModel model = new CollegesModel();
if (this.datayuan.SelectedRows.Count > 0)
{
string ID = this.datayuan.SelectedRows[0].Cells["学院编号"].Value.ToString();
string name = this.datayuan.SelectedRows[0].Cells["学院名称"].Value.ToString();
model.College_ID = ID;
model.College_Name = name;
college.UPColleges(model);
GetAllColleges();
}
}
public JsonResult GetCollege(string collegeId)
{
if (string.IsNullOrEmpty(collegeId))
{
return(null);
}
List <CollegesModel> CollegeList = new List <CollegesModel>();
CollegeList = (List <CollegesModel>)collegesService.GetCollegesList();
CollegesModel collegesModel = CollegeList.Find(x => (x.CollgId).Trim().Equals(collegeId.Trim()));
CollegeList.Clear();
CollegeList = null;
return(Json(new { data = collegesModel }, JsonRequestBehavior.AllowGet));
}
private void btnseleyuan_Click(object sender, EventArgs e)
{
CollegesBLL college = new CollegesBLL();
CollegesModel model = new CollegesModel();
if (this.cmdName.SelectedItem.ToString() == "按照编号")
{
model.College_ID = "%" + this.txtchaname.Text + "%";
DataTable dt = college.GetIDColleges(model);
datayuan.DataSource = dt;
}
else if (this.cmdName.SelectedItem.ToString() == "按照名称")
{
model.College_Name = "%" + this.txtchaname.Text + "%";
DataTable dt = college.GetNameColleges(model);
datayuan.DataSource = dt;
}
}
public JsonResult UpdateCollegeDetails(CollegesModel model)
{
object obj = new { Code = 500, message = string.Empty };
if (model != null)
{
HttpFileCollectionBase files = Request.Files;
//string path = AppDomain.CurrentDomain.BaseDirectory + "Uploads/";
//string filename = Path.GetFileName(Request.Files[i].FileName);
HttpPostedFileBase file = files[0];
string fname;
// Checking for Internet Explorer
if (Request.Browser.Browser.ToUpper() == "IE" || Request.Browser.Browser.ToUpper() == "INTERNETEXPLORER")
{
string[] testfiles = file.FileName.Split(new char[] { '\\' });
fname = testfiles[testfiles.Length - 1];
}
else
{
fname = model.CollegeName.Replace(" ", "_") + "_" + DateTime.Now.Ticks + "." + file.FileName.Split('.')[1];
}
model.Image = "//Uploads//CollegeImages//" + fname;
// Get the complete folder path and store the file inside it.
fname = Path.Combine(Server.MapPath("~/Uploads/CollegeImages/"), fname);
file.SaveAs(fname);
var data = collegesService.UpdateCollegeDetails(model);
if (data != null)
{
obj = new { Code = 200, message = "Updating the college is successful." };
}
}
else
{
obj = new { Code = 501, message = "Sorry ! Something went wrong, update is not done." };
}
return(Json(obj, JsonRequestBehavior.AllowGet));
}
public ActionResult AddCollegeDetails(CollegesModel colleges)
{
// Checking no of files injected in Request object
try
{
// Get all files from Request object
HttpFileCollectionBase files = Request.Files;
for (int i = 0; i < files.Count; i++)
{
//string path = AppDomain.CurrentDomain.BaseDirectory + "Uploads/";
//string filename = Path.GetFileName(Request.Files[i].FileName);
HttpPostedFileBase file = files[i];
string fname;
// Checking for Internet Explorer
if (Request.Browser.Browser.ToUpper() == "IE" || Request.Browser.Browser.ToUpper() == "INTERNETEXPLORER")
{
string[] testfiles = file.FileName.Split(new char[] { '\\' });
fname = testfiles[testfiles.Length - 1];
}
else
{
fname = colleges.CollegeName.Replace(" ", "_") + "_" + DateTime.Now.Ticks + "." + file.FileName.Split('.')[1];
}
colleges.Image = "//Uploads//CollegeImages//" + fname;
// Get the complete folder path and store the file inside it.
fname = Path.Combine(Server.MapPath("~/Uploads/CollegeImages/"), fname);
file.SaveAs(fname);
colleges.CreatedDate = DateTime.Now;
colleges.IsActive = true;
collegesService.SaveCollegeDetails(colleges);
}
}
catch (Exception ex)
{
return(Json("Error occurred. Error details: " + ex.Message));
}
// Returns message that successfully uploaded
return(Json("New College details are added successfully."));
}
private void btnAddyuan_Click(object sender, EventArgs e)
{
CollegesBLL college = new CollegesBLL();
CollegesModel model = new CollegesModel();
if (this.txtyuanbian.TextLength != 2)
{
MessageBox.Show("学院编号只能为两位");
this.txtyuanbian.Text = "";
return;
}
model.College_ID = this.txtyuanbian.Text;
bool b = college.SeleColleges(model);
if (b == true)
{
MessageBox.Show("编号已存在，请重新输入");
this.txtyuanbian.Text = "";
return;
}
if (string.IsNullOrEmpty(this.txtyuanbian.Text))
{
MessageBox.Show("学院编号不能为空");
return;
}
if (string.IsNullOrEmpty(this.txtyuanName.Text))
{
MessageBox.Show("学院名称不能为空");
return;
}
try
{
model.College_ID = this.txtyuanbian.Text;
}
catch
{
MessageBox.Show("学院编号重复");
this.txtyuanbian.Text = "";
}
model.College_Name = this.txtyuanName.Text;
college.AddColleges(model);
GetAllColleges();
}
private void btnyuandele_Click(object sender, EventArgs e)
{
CollegesBLL college = new CollegesBLL();
CollegesModel model = new CollegesModel();
if (this.datayuan.SelectedRows.Count > 0)
{
string ID = this.datayuan.SelectedRows[0].Cells["学院编号"].Value.ToString();
model.College_ID = ID;
try
{
college.DeleColleges(model);
GetAllColleges();
}
catch
{
MessageBox.Show("删除失败");
}
}
}
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
CollegesBLL college = new CollegesBLL();
CollegesModel model = new CollegesModel();
if (this.txtyuanbian.TextLength != 2)
{
MessageBox.Show("学院编号只能为两位");
this.txtyuanbian.Text = "";
return;
}
model.College_ID = this.txtyuanbian.Text;
bool b = college.SeleColleges(model);
if (b == true)
{
MessageBox.Show("编号已存在，请重新输入");
this.txtyuanbian.Text = "";
return;
}
}
/// <summary>
/// 根据学院名称和班主任名称模糊搜索班级信息
/// </summary>
/// <param name="specmodel">学院实体对象</param>
/// <param name="teamodel">班主任实体对象</param>
/// <returns>班级信息</returns>
public DataTable GetClassesByCollegeAndTeacher(CollegesModel collmodel, TeachersModel teamodel)
{
string sql = "select a.Classes_ID 班级编号,a.Classes_Name 班级名称,b.Speciality_Name 专业名称,d.College_Name 学院名称,Teacher_Name 班主任名称 from Classes a join Speciality b on a.Classes_Speciality=b.Speciality_ID join Teachers c on a.ClassHeadTeacher=c.Teacher_ID join Colleges d on b.Speciality_College=d.College_ID where d.College_Name like '%'+@0+'%' and c.Teacher_Name like '%'+@1+'%'";
return(SqlHelper.GetDataTable(sql, collmodel.College_Name, teamodel.Teacher_Name));
}
/// <summary>
/// 修改学院业务方法
/// </summary>
/// <param name="model">学院的实体对象</param>
public void UPColleges(CollegesModel model)
{
CollegesDAL College = new CollegesDAL();
College.UPCollege(model);
}
/// <summary>
/// 修改学院的数据访问方法
/// </summary>
/// <param name="model">学院的实体对象</param>
public void UPCollege(CollegesModel model)
{
string sql = "update Colleges set College_Name=@0 where College_ID=@1";
SqlHelper.ExNonQuery(sql, "修改学院信息", model.College_Name, model.College_ID);
}
/// <summary>
/// 删除学院的数据访问方法
/// </summary>
/// <param name="model">学院的实体对象</param>
public void DeleCollege(CollegesModel model)
{
string sql = "delete Colleges where College_ID=@0";
SqlHelper.ExNonQuery(sql, "删除学院", model.College_ID);
}
/// <summary>
/// 添加学院的数据访问方法
/// </summary>
/// <param name="model">学院的实体对象</param>
public void AddCollege(CollegesModel model)
{
string sql = "insert into Colleges values(@0,@1)";
SqlHelper.ExNonQuery(sql, "添加学院", model.College_ID, model.College_Name);
}
public object UpdateCollegeDetails(CollegesModel colleges)
{
return(collegesRepository.UpdateCollegeDetails(colleges));
}
public object SaveCollegeDetails(CollegesModel colleges)
{
return(collegesRepository.SaveCollegeDetails(colleges));
}
private void btnSelect_Click(object sender, EventArgs e)
{
string College = this.txtCollege.Text.Trim();
string Speciality = this.txtSpeciality.Text.Trim();
string Class = this.txtClasses.Text.Trim();
string Teachers = this.txtTeacher.Text.Trim();
if (string.IsNullOrEmpty(College) && string.IsNullOrEmpty(Speciality) && string.IsNullOrEmpty(Class) && string.IsNullOrEmpty(Teachers))
{
MessageBox.Show("请输入查询条件");
return;
}
DataTable dt = new DataTable();
if (string.IsNullOrEmpty(Teachers))
{
if (string.IsNullOrEmpty(Class) == false)//
{
ClassesModel clmodel = new ClassesModel();
clmodel.Classes_Name = Class;
dt = classes.GetClassesByClassName(clmodel);
}
else if (string.IsNullOrEmpty(Class) && string.IsNullOrEmpty(Speciality) == false)
{
SpecialityModel specmodel = new SpecialityModel();
specmodel.Speciality_Name = Speciality;
dt = classes.GetClassesBySpecialityName(specmodel);
}
else
{
CollegesModel collmodel = new CollegesModel();
collmodel.College_Name = College;
dt = classes.GetClassesByCollegeName(collmodel);
}
}
else
{
if (string.IsNullOrEmpty(Teachers) == false && string.IsNullOrEmpty(College) && string.IsNullOrEmpty(Speciality) && string.IsNullOrEmpty(Class))
{
TeachersModel teamodel = new TeachersModel();
teamodel.Teacher_Name = Teachers;
dt = classes.GetClassesByTeacherName(teamodel);
}
else if (string.IsNullOrEmpty(Teachers) == false && string.IsNullOrEmpty(Class) == false)
{
ClassesModel clmodel = new ClassesModel();
clmodel.Classes_Name = Class;
TeachersModel teamodel = new TeachersModel();
teamodel.Teacher_Name = Teachers;
dt = classes.GetClassesByClassAndTeacher(clmodel, teamodel);
}
else if (string.IsNullOrEmpty(Teachers) == false && string.IsNullOrEmpty(Class) && string.IsNullOrEmpty(Speciality) == false)
{
TeachersModel teamodel = new TeachersModel();
SpecialityModel specmodel = new SpecialityModel();
specmodel.Speciality_Name = Speciality;
teamodel.Teacher_Name = Teachers;
dt = classes.GetClassesBySpecialityAndTeacher(specmodel, teamodel);
}
else
{
CollegesModel collmodel = new CollegesModel();
collmodel.College_Name = College;
TeachersModel teamodel = new TeachersModel();
teamodel.Teacher_Name = Teachers;
dt = classes.GetClassesByCollegeAndTeacher(collmodel, teamodel);
}
}
this.dataGridView1.DataSource = dt;
}
/// <summary>
/// 删除学院业务方法
/// </summary>
/// <param name="model">学院的实体对象</param>
public void DeleColleges(CollegesModel model)
{
CollegesDAL College = new CollegesDAL();
College.DeleCollege(model);
}
/// <summary>
/// 根据学院名称模糊搜索班级信息
/// </summary>
/// <param name="model">班级实体对象</param>
/// <returns>班级信息</returns>
public DataTable GetClassesByCollegeName(CollegesModel model)
{
return(Class.GetClassesByCollegeName(model));
}
/// <summary>
/// 根据学院名称和班主任名称模糊搜索班级信息
/// </summary>
/// <param name="specmodel">学院实体对象</param>
/// <param name="teamodel">班主任实体对象</param>
/// <returns>班级信息</returns>
public DataTable GetClassesByCollegeAndTeacher(CollegesModel collmodel, TeachersModel teamodel)
{
return(Class.GetClassesByCollegeAndTeacher(collmodel, teamodel));
}
/// <summary>
/// 添加学院业务方法
/// </summary>
/// <param name="model">学院的实体对象</param>
public void AddColleges(CollegesModel model)
{
CollegesDAL College = new CollegesDAL();
College.AddCollege(model);
}
