//得到学生详细信息
public List <object> getUserCardInfoDetails(string userid)
{
Maticsoft.Model.学生证表 newinfo = new Maticsoft.Model.学生证表();
Maticsoft.BLL.学生证表 SQLOption = new Maticsoft.BLL.学生证表();
Maticsoft.Model.学生表 XueshengInfo = new Maticsoft.Model.学生表();
Maticsoft.BLL.学生表 SQLXueshengInfo = new Maticsoft.BLL.学生表();
if (SQLOption.Exists(userid))
{
newinfo = SQLOption.GetModel(userid); //得到学生证实体类
XueshengInfo = SQLXueshengInfo.GetModel(userid, ""); //得到学生信息
}
var data = new List <object>()
{
new { StuName = newinfo.姓名, StuSex = XueshengInfo.性别, StuBirth = XueshengInfo.生日,
StuInstitution = XueshengInfo.学院,
StuPro = XueshengInfo.专业,
StuClass = XueshengInfo.班级,
StuId = newinfo.学号,
StuFazhengTime = newinfo.发证日期,
StuYouxiaoTime = newinfo.效期,
Option = "测试", },
};
return(data);
}
//办证业务提交
public List <object> SubmitBanzheng(string userid)
{
Maticsoft.Model.申请表 newinfo = new Maticsoft.Model.申请表();
Maticsoft.BLL.申请表 SQLOption = new Maticsoft.BLL.申请表();
Maticsoft.Model.学生表 XueshengInfo = new Maticsoft.Model.学生表();
Maticsoft.BLL.学生表 SQLXueshengInfo = new Maticsoft.BLL.学生表();
Maticsoft.Model.学生证表 Cardinfo = new Maticsoft.Model.学生证表();
Maticsoft.BLL.学生证表 SQLCardOp = new Maticsoft.BLL.学生证表();
XueshengInfo = SQLXueshengInfo.GetModel(userid, "");
Cardinfo.姓名 = XueshengInfo.姓名;
Cardinfo.学号 = XueshengInfo.学号;
//生成随机数
long tick = DateTime.Now.Ticks;
Random ran = new Random((int)(tick & 0xffffffffL) | (int)(tick >> 32));
int iResult;
int iUp = 100000;
int iDown = 0;
iResult = ran.Next(iDown, iUp);
Cardinfo.学生证号 = "0020000021" + string.Format("{0:000000}", iResult);
Cardinfo.学校地址 = "沈阳";
Cardinfo.发证日期 = DateTime.Now;
Cardinfo.家庭地址 = "";
Cardinfo.效期 = DateTime.Now;
newinfo.学号 = userid;
newinfo.申请状态 = "未受理";
var data = new List <object>();
if (SQLOption.Add(newinfo) && SQLCardOp.Add(Cardinfo))
{
data = new List <object>()
{
new { success = "true", message = "受理成功", },
};
}
else
{
data = new List <object>()
{
new { success = "false", message = "受理失败", },
};
};
return(data);
}
//得到学生证基本信息
public List <object> getUserCardInfo(string userid)
{
Maticsoft.Model.学生证表 newinfo = new Maticsoft.Model.学生证表();
Maticsoft.BLL.学生证表 SQLOption = new Maticsoft.BLL.学生证表();
Maticsoft.Model.申请表 ShenqingInfo = new Maticsoft.Model.申请表();
Maticsoft.BLL.申请表 SQLSHENOption = new Maticsoft.BLL.申请表();
Maticsoft.Model.学生表 XueshengInfo = new Maticsoft.Model.学生表();
Maticsoft.BLL.学生表 SQLXueshengInfo = new Maticsoft.BLL.学生表();
var data = new List <object>();
if (SQLXueshengInfo.Exists(userid, ""))
{
newinfo = SQLOption.GetModel(userid); //得到实体类
ShenqingInfo = SQLSHENOption.GetModel(userid); //得到申请信息
XueshengInfo = SQLXueshengInfo.GetModel(userid, ""); //得到学生信息
}
if (newinfo == null || ShenqingInfo == null || XueshengInfo == null)
{
newinfo = new Maticsoft.Model.学生证表(); ShenqingInfo = new Maticsoft.Model.申请表();
//XueshengInfo = new Maticsoft.Model.学生表();
data = new List <object>()
{
new { CardId = newinfo.学生证号, StuId = newinfo.学号, Name = XueshengInfo.姓名, Status = ShenqingInfo.申请状态,
Option = "测试", },
};
}
data = new List <object>()
{
new { CardId = newinfo.学生证号, StuId = newinfo.学号, Name = XueshengInfo.姓名, Status = ShenqingInfo.申请状态,
Option = "测试", },
};
return(data);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.学生表 model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.学生表 model)
{
return(dal.Add(model));
}
//学生注册信息
public JObject SingupInfo(JObject info)
{
JObject reV = new JObject();
bool StuAdd = false;
bool SignUpExit = true;
Maticsoft.BLL.学生表 StuSQL = new Maticsoft.BLL.学生表();
Maticsoft.Model.学生表 newStu = new Maticsoft.Model.学生表();
Maticsoft.BLL.登录表 SignupSQL = new Maticsoft.BLL.登录表();
Maticsoft.Model.登录表 newSign = new Maticsoft.Model.登录表();
newStu.班级 = info["banji"].ToString();
newStu.生日 = DateTime.ParseExact(info["stuBirth"].ToString(), "yyyy-MM-dd", System.Globalization.CultureInfo.CurrentCulture);
newStu.性别 = info["stuGender"].ToString();
newStu.姓名 = info["stuName"].ToString();
newStu.学号 = info["stuId"].ToString();
newStu.学院 = info["xueyuan"].ToString();
newStu.专业 = info["zhuanye"].ToString();
newStu.邮箱 = info["stuEmail"].ToString();
newSign.账号 = info["stuId"].ToString();
newSign.密码 = info["stuPs"].ToString();
newSign.职务 = "学生";
SignupSQL.Add(newSign);
if (SignupSQL.Exists(newSign.账号))
{
if (!StuSQL.Exists(newStu.学号, newStu.邮箱))
{
StuAdd = StuSQL.Add(newStu); //添加学生信息状态
}
else
{
reV.Add("success", "false");
reV.Add("message", "学号已经注册");
return(reV);
}
}
else
{
SignUpExit = false; //登录表不存在信息
reV.Add("success", "false");
reV.Add("message", "学号尚未录入无法注册");
return(reV);
}
if (StuAdd)
{
reV.Add("success", "true");
reV.Add("message", "注册成功");
}
else
{
reV.Add("success", "false");
reV.Add("message", "注册失败");
}
return(reV);
}
