public ActionResult GetAllBanJikaishekecheng(int?page, int?limit)
{
int PageIndex = page ?? 1;
int PageSize = limit ?? 20;
int COUNT = bll2.GetAll().Count();
int Count;
List <BanJiKaiSheKeChengJiHuaBiao> list2;
if (Session["Teacher"] != null)
{
YuanGongBiao yuanGong = Session["Teacher"] as YuanGongBiao;
list2 = bll2.GetPage(PageIndex, PageSize, out Count, yuanGong.ID.ToString());
}
else
{
XueShengBiao xueSheng = Session["Student"] as XueShengBiao;
list2 = bll2.GetPage(PageIndex, PageSize, out Count, xueSheng.StudentClassID.Value);
}
var jsondata = new
{
code = 0,
msg = "成功",
count = Count,
data = list2
};
return(Json(jsondata, JsonRequestBehavior.AllowGet));
}
public int AddStuClass1(int ID, int BjID)
{
XueShengBiao xs = context.Set <XueShengBiao>().Where(p => p.ID == ID).OrderByDescending(p => p.ID).First();
BanJiBiao bj = context.Set <BanJiBiao>().Where(p => p.ID == BjID).First();
return(GetXsBj1(xs, bj));
}
//
////新增学生与班级关联表
#region 增加关联表 学生-班级
public int AddStuClass()
{
XueShengBiao xs = context.Set <XueShengBiao>().OrderByDescending(p => p.ID).First();
BanJiBiao bj = context.Set <BanJiBiao>().Where(p => p.ID == xs.StudentClassID).First();
return(GetXsBj(xs, bj));
}
// 修改时，提交
public ActionResult ZMEditAction(Student st)
{
XueShengBiao xs = new XueShengBiao();
xs.StudentName = st.StudentName;
xs.Age = st.Age;
xs.Address = st.Address;
xs.Phone = st.Phone;
xs.HomePhone = st.HomePhone;
xs.ID = st.XID;
if (st.Sex != true)
{
st.Sex = false;
}
xs.Sex = st.Sex;
int n = xsb.UpdateXS(xs);
if (n > 0)
{
return(Json(new { errorNo = "0", errorInfo = "执行修改成功" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { errorNo = "1", errorInfo = "执行错误，请检查重试" }, JsonRequestBehavior.AllowGet));
}
}
public int UpdateXueSheng(XueShengBiao stu)
{
context.Set <XueShengBiao>().Attach(stu);
context.Entry <XueShengBiao>(stu).State = EntityState.Modified;
context.SaveChanges();
return(1);
}
////增加操作
//增加学生时，做判断,判断学生添加所在班级是否满员
//添加学生时防止同时添加多条信息
public ActionResult ZMAddAction(Student st)
{
XueShengBiao xs = new XueShengBiao();
xs.StudentName = st.StudentName;
xs.Age = st.Age;
xs.Address = st.Address;
xs.Phone = st.Phone;
xs.HomePhone = st.HomePhone;
if (st.Sex != true)
{
st.Sex = false;
}
xs.Sex = st.Sex;
xs.MiMa = "123456";
xs.StudentClassID = Convert.ToInt16(st.BanJiMing);
int n = xsb.Add(xs);
if (n > 0)
{
return(Json(new { errorNo = "0", errorInfo = "执行成功" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { errorNo = "1", errorInfo = "执行错误，请检查重试" }, JsonRequestBehavior.AllowGet));
}
}
public bool StuAdd(List <Models.XueShengBiao> exceles)
{
bool error = false;
try
{
TransactionScope transaction = null;
//因为每个章节只能出现一次，所以new一个new匿名类
foreach (var item in exceles)
{
XueShengBiao xs = new XueShengBiao();
xs.Address = item.Address;
xs.Age = item.Age;
xs.HomePhone = item.HomePhone;
xs.MiMa = item.MiMa;
xs.Phone = item.Phone;
xs.StudentClassID = item.StudentClassID;
xs.Sex = item.Sex;
xs.StudentName = item.StudentName;
xs.ZhuangTai = item.ZhuangTai;
mbll.StuAdd(xs);
mbll.AddStuClass();
}
error = true;
}
catch (Exception ex)
{
error = false;
throw ex;
}
return(error);
}
public int Add(XueShengBiao xs)
{
int n = mbll.Add(xs);
mbll.AddStuClass();
return(n);
}
public int UpdateXS(XueShengBiao st)
{
List <SqlParameter> spls = new List <SqlParameter>();
string sql = "update XueShengBiao Set StudentName = @name,Age = @age,Address = @addr,Phone= @p1,HomePhone = @p2 ";
SqlParameter p1 = new SqlParameter("@name", st.StudentName);
SqlParameter p2 = new SqlParameter("@age", st.Age);
SqlParameter p3 = new SqlParameter("@addr", st.Address);
SqlParameter p4 = new SqlParameter("@p1", st.Phone);
SqlParameter p5 = new SqlParameter("@p2", st.HomePhone);
spls.Add(p1);
spls.Add(p2);
spls.Add(p3);
spls.Add(p4);
spls.Add(p5);
if (st.Sex != null)
{
sql += " ,Sex = @sex ";
SqlParameter p6 = new SqlParameter("@sex", st.Sex);
spls.Add(p6);
}
sql += "where ID = " + st.ID;
int n = context.Database.ExecuteSqlCommand(sql, spls.ToArray());
return(n);
}
public int TuiStu(int XID)
{
int n = mbll.TuiStu(XID);
XueShengBiao xs = mbll.GetOne(XID);
mbj.UpdateNum(xs, 1);
return(n);
}
public int StuAdd(XueShengBiao xs)
{
MBanJiBiaoDAL bj = new MBanJiBiaoDAL();
if (bj.UpdateNum(xs, 2) == 0)
{
return(0);
}
context.XueShengBiao.Add(xs);
return(context.SaveChanges());
}
public int Delete(XueShengBiao st)
{
MBanJiBiaoDAL bj = new MBanJiBiaoDAL();
if (bj.UpdateNum(st, 1) == 0)
{
return(0);
}
context.Set <XueShengBiao>().Attach(st);
context.Set <XueShengBiao>().Remove(st);
return(context.SaveChanges());
}
public int UpdateNum(XueShengBiao st, int i)
{
BanJiBiao bj = context1.Set <BanJiBiao>().Find(st.StudentClassID);
if (i == 1)
{
bj.BanJiRenShu = bj.BanJiRenShu - 1;
}
else
{
bj.BanJiRenShu = bj.BanJiRenShu + 1;
}
return(Update1(bj));
}
public int GetXsBj1(XueShengBiao xs, BanJiBiao bj)
{
XueShengYuBanJiDuiYingBiao xb = new XueShengYuBanJiDuiYingBiao
{
StudentID = xs.ID,
StudentName = xs.StudentName,
StudentClassID = bj.ID,
StudentClass = bj.BanJiMing,
StartTiem = bj.KaiBanShiJian
};
context.XueShengYuBanJiDuiYingBiao.Add(xb);
return(context.SaveChanges());
}
public void UpdateActionStu(XueShengBiao stu)
{
int n = bll4.UpdateXueSheng(stu);
if (n > 0)
{
Session["Student"] = stu;
Response.Write("<script>alert('学生信息修改成功');location.href='/YiCipaikedekebiaoxinxi/zhuye'</script>");
}
else
{
Response.Write("<script>alert('学生信息修改失败，请重试');location.href='/YiCipaikedekebiaoxinxi/zhuye'</script>");
}
}
public int HuanBan(string name, int bjID, int Xid, string YuanBanJiID)
{
XueShengBiao xs = mbll.GetOne(Xid);
string id = xs.StudentClassID.ToString();
mbj.UpdateNum(xs, 1);
mbll.XiuGaiShiJian(mbll.GetXueShengYuBanJiDuiYingBiao(Xid, Convert.ToInt32(YuanBanJiID)).ID);
int n = mbll.HuanBan(Xid, bjID);
mbll.AddStuClass1(Xid, bjID);
if (n > 0)
{
XueShengBiao xs1 = new XueShengBiao();
xs1.StudentClassID = bjID;
mbj.UpdateNum(xs1, 2);
}
return(n);
}
public Student GetOneInfo(object XID)
{
XueShengBiao xsb = context.Set <XueShengBiao>().Find(XID);
BanJiBiao bjb = context.Set <BanJiBiao>().Find(xsb.StudentClassID);
Student st = new Student
{
XID = xsb.ID,
StudentName = xsb.StudentName,
Address = xsb.Address,
Age = xsb.Age,
BanJiMing = bjb.BanJiMing,
HomePhone = xsb.HomePhone,
Phone = xsb.Phone,
Sex = xsb.Sex,
StudentClassID = xsb.StudentClassID,
JieDuanID = Convert.ToInt32(bjb.JieDuanID)
};
return(st);
}
public ActionResult LoginAction(string phone, string pwd, int peo)
{
// 0：教员 1：学生
YuanGongBiao user1 = null;
XueShengBiao user2 = null;
int i = 0;
if (peo == 0)
{
user1 = bll3.Login(phone, pwd);
Session.Add("Teacher", user1);
}
else if (peo == 1)
{
user2 = bll4.Login(phone, pwd);
Session.Add("Student", user2);
}
if (user1 != null || user2 != null)
{
i = 1;
}
return(Json(new { Count = 1 }, JsonRequestBehavior.AllowGet));
}
public IHttpActionResult LoginAction(/*[FromBody] Models.YuanGongBiao yuanGongBiao,*/ string Phone, string MiMA)
{
YuanGongBiao yuanGongBiao2 = new YuanGongBiao();
yuanGongBiao2.Phone = Phone;
yuanGongBiao2.MiMa = MiMA;
var Teacher = yuanGong.YuanGongBiao(yuanGongBiao2);
System.Web.HttpContext context = System.Web.HttpContext.Current;
string Name = "";
if (Teacher != null)
{
Name = "登录成功";
context.Session.Add("Teacher", Teacher);
return(Ok(Name));
}
else
{
XueShengBiao xueShengBiao = new XueShengBiao
{
MiMa = yuanGongBiao2.MiMa,
Phone = yuanGongBiao2.Phone
};
var Student = XueSheng.XueSheng(xueShengBiao);
if (Student != null)
{
Name = "登录成功";
context.Session.Add("Student", Student);
}
else
{
Name = "登录失败";
}
}
return(Ok(Name));
}
public int UpdateXS(XueShengBiao st)
{
return(mbll.UpdateXS(st));
}
/// <summary>
/// Add学员信息
/// </summary>
/// <param name="BanJiMing">班级名</param>
/// <param name="filePath">文件</param>
/// <returns></returns>
public ActionResult StuAddAction(string BanJiMing, string filePath)
{
int BanJiID = Convert.ToInt16(BanJiMing);
if (!string.IsNullOrEmpty(filePath))
{
try
{
string path = AppDomain.CurrentDomain.BaseDirectory + @"/upload";
//保存文件的真实文件名，和全路径;
string savepath = Server.MapPath("~/upload/" + filePath);//上传后的文件名
//判断是否存在此路径
if (!Directory.Exists(path))
{
//创建文件夹
Directory.CreateDirectory(path);
}
//创建一个WorkBook对象;
HSSFWorkbook hSSFWorkbook;
using (FileStream filel = new FileStream(savepath, FileMode.Open, FileAccess.Read))
{
hSSFWorkbook = new HSSFWorkbook(filel);
}
//获取工作簿的第一个工作表
var sheep = hSSFWorkbook.GetSheetAt(0);
//获取所有的行
System.Collections.IEnumerator rows = sheep.GetRowEnumerator();
//获取标题行
var headerRow = sheep.GetRow(0);
int cellCount = headerRow.LastCellNum;
List <XueShengBiao> stu = new List <XueShengBiao>();
for (int i = (sheep.FirstRowNum + 1); i < sheep.LastRowNum; i++)
{
var row = sheep.GetRow(i);
XueShengBiao stu1 = new XueShengBiao
{
StudentName = (row.GetCell(1).ToString()),
StudentClassID = BanJiID,
Sex = Convert.ToInt32(row.GetCell(2).ToString()) == 0 ? false : true,
Age = Convert.ToInt32(row.GetCell(3).ToString()),
MiMa = row.GetCell(4).ToString(),
Address = row.GetCell(5).ToString(),
Phone = row.GetCell(6).ToString(),
HomePhone = row.GetCell(7).ToString(),
ZhuangTai = 1
};
//把对象加入到集合
stu.Add(stu1);
}
bool error = xsb.StuAdd(stu);
if (error)
{
return(Json(new { errorNo = "0", errorInfo = "导入学员信息成功" }));
}
else
{
return(Json(new { errorNo = "1", errorInfo = "导入学员信息失败" }));
}
}
catch (Exception ex)
{
return(Json(new { errorNo = "1", errorInfo = ex.Message }));
throw ex;
}
}
else
{
return(Json(new { errorNo = "1", errorInfo = "无上传文件,操作错误" }, JsonRequestBehavior.AllowGet));
}
}
public int UpdateXueSheng(XueShengBiao stu)
{
return(dal.UpdateXueSheng(stu));
}