/// <summary>
/// 分页获取按钮列表
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public static PagedList <Teachers> GetButtonList(TeacherSearchModel search)
{
string table = string.Empty, fields = string.Empty, orderby = string.Empty, where = string.Empty; //定义结构
fields = @" * "; //输出字段
table = @" Teachers "; //表或者视图
orderby = "CreateTime"; //排序信息
StringBuilder sb = new StringBuilder(); //构建where条件
sb.Append(" 1=1 ");
switch (search.LeaveDate)
{
case 1:
sb.Append(" and LeaveDate is null ");
break;
case 2:
sb.Append(" and LeaveDate <> '' ");
break;
}
if (!string.IsNullOrWhiteSpace(search.TeacherName))//按钮中文名称
{
sb.AppendFormat(" and name like '%{0}%' ", search.TeacherName);
}
//if (!string.IsNullOrWhiteSpace(search.BTN_Name_En))//城市
// sb.AppendFormat(" and BTN_Name_En like '%{0}%' ", search.BTN_Name_En);
where = sb.ToString();
int allcount = 0;
var list = CommonPage <Teachers> .GetPageList(
out allcount, table, fields : fields, where : where.Trim(),
orderby : orderby, pageindex : search.CurrentPage, pagesize : search.PageSize, connect : DBKeys.PRX);
return(new PagedList <Teachers>(list, search.CurrentPage, search.PageSize, allcount));
}
/// <summary>
/// 新增教师
/// </summary>
/// <returns></returns>
public JsonResult AddTeach()
{
AjaxStatusModel ajax = new AjaxStatusModel(); //功能操作类的返回类型都是AjaxStatusModel，数据放到AjaxStatusModel.data中，前台获取json后加载
ajax.status = EnumAjaxStatus.Error; //默认失败
ajax.msg = "新增失败！"; //前台获取，用于显示提示信息
var data = Request["data"]; //获取前台传递的数据，主要序列化
if (string.IsNullOrEmpty(data))
{
return(Json(ajax));
}
Teachers teacher = (Teachers)(JsonConvert.DeserializeObject(data.ToString(), typeof(Teachers)));
SYSAccount sys = (SYSAccount)(JsonConvert.DeserializeObject(data.ToString(), typeof(SYSAccount)));
if (string.IsNullOrEmpty(teacher.MobilePhone))
{
ajax.msg = "请输入教师手机号！";
return(Json(ajax));
}
TeacherSearchModel search = new TeacherSearchModel();
search.MobilePhone = teacher.MobilePhone;
int teas = TeacherData.GetTeachersList(search).Count();
if (teas > 0)//手机号重复了
{
ajax.msg = "手机号重复！";
return(Json(ajax));
}
RandomOperate operate = new RandomOperate();
teacher.CreateTime = DateTime.Now;
teacher.CreatorId = UserSession.userid;
teacher.ID = operate.GenerateCheckCode(36);
teacher.BindAccountID = teacher.MobilePhone;
sys.ACC_Account = teacher.MobilePhone;//用手机号作为登陆账号
sys.ACC_CreatedBy = UserSession.userid;
sys.ACC_CreatedOn = DateTime.Now;
sys.ACC_Password = operate.CreateMD5Hash("123");
sys.ACC_ComCode = teacher.ComCode;
if (!string.IsNullOrEmpty(TeacherData.AddTeachers(teacher, sys)))//注意时间类型，而且需要在前台把所有的值
{
ajax.msg = "新增成功！";
ajax.status = EnumAjaxStatus.Success;
}
return(Json(ajax));
}
/// <summary>
/// 分页获取教师列表
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public static PagedList <vw_Teachers> GetTeachersList(TeacherSearchModel search)
{
string table = string.Empty, fields = string.Empty, orderby = string.Empty, where = string.Empty; //定义结构
fields = @" * "; //输出字段
table = @" vw_Teachers "; //表或者视图
orderby = "CreateTime desc"; //排序信息
StringBuilder sb = new StringBuilder(); //构建where条件
sb.Append(" 1=1 ");
if (!string.IsNullOrWhiteSpace(search.ComCode))//校区
{
sb.AppendFormat(" and [ComCode] = '{0}' ", search.ComCode);
}
if (search.LeaveDate == 1)//离职
{
sb.AppendFormat(" and LeaveDate is null ", search.LeaveDate);
}
else if (search.LeaveDate == 2)
{
sb.AppendFormat(" and LeaveDate is not null ", search.LeaveDate);
}
if (!string.IsNullOrWhiteSpace(search.TeacherName))//是否在职
{
sb.AppendFormat(" and name like '%{0}%' ", search.TeacherName);
}
if (!string.IsNullOrWhiteSpace(search.MobilePhone))//手机号码
{
sb.AppendFormat(" and MobilePhone like '%{0}%' ", search.MobilePhone);
}
where = sb.ToString();
int allcount = 0;
var list = CommonPage <vw_Teachers> .GetPageList(
out allcount, table, fields : fields, where : where.Trim(),
orderby : orderby, pageindex : search.CurrentPage, pagesize : search.PageSize, connect : DBKeys.PRX);
return(new PagedList <vw_Teachers>(list, search.CurrentPage, search.PageSize, allcount));
}
/// <summary>
/// 教师列表查询
/// </summary>
public ActionResult Teacher(TeacherSearchModel search)
{
TeacherViewModel model = new TeacherViewModel(); //页面模型
model.search = search; //页面的搜索模型
model.search.PageSize = 15; //每页显示
model.search.CurrentPage = Convert.ToInt32(Request["pageindex"]) <= 0 ? 1 : Convert.ToInt32(Request["pageindex"]); //当前页
//按钮下拉项
List <CommonEntity> ButtonIL = CommonData.GetDictionaryList(4); //1是字典类型值,仅供测试参考
model.buttonIL = CommonData.Instance.GetBropDownListData(ButtonIL);
//分校下拉项
List <CommonEntity> ComCodeIL = CommonData.Get_SYS_Company_List();//分校
model.ComCodeIL = CommonData.Instance.GetBropDownListData(ComCodeIL);
//分校下拉项
List <CommonEntity> ComCodeIL1 = CommonData.Get_SYS_Company_COMP_Code(UserSession.comcode);//分校
model.search.ComCodeIL1 = CommonData.Instance.GetBropDownListData_Choice(ComCodeIL1);
//多沟选框
List <DataProvider.Data.CommonData.SYS_Role> SourceIL = CommonData.GetSYS_SystemRole_IS(0);
ViewData["SYS_Role"] = SourceIL;
if (UserSession.comcode != null && UserSession.comcode != "1")
{
search.ComCode = UserSession.comcode; //默认查询当前分校的人员
}
model.Teacherslist = TeacherData.GetTeachersList(search); //填充页面模型数据
return(View(model)); //返回页面模型
}
