//ajax
/*Admin/GetStudent
* 1、获取学生信息（参数为学号）
* 2、通过业务逻辑层UserManager-GetStudent获取学生信息
* 3、根据返回信息shengcJson字符串
* 4、返回Json*/
public ActionResult GetStudent(string id)
{
SBasic sbasic = new SBasic();
try
{
sbasic = new UserManager().GetStudent(id);
string json = "{";
json += "\"number\":\"" + sbasic.SNumber + "\",";
json += "\"name\":\"" + sbasic.SName + "\",";
json += "\"idnumber\":\"" + sbasic.SIDNumber + "\",";
json += "\"college\":\"" + sbasic.SCollege.CollegeName + "\",";
json += "\"major\":\"" + sbasic.SMajor.MajorName + "\",";
json += "\"enrollment\":\"" + Convert.ToDateTime(sbasic.SEnrollment).ToString("yyyy-MM-dd") + "\",";
json += "\"sex\":\"" + sbasic.SSex.Trim() + "\",";
json += "\"phone\":\"" + sbasic.SPhone + "\",";
json += "\"email\":\"" + sbasic.SEmail + "\",";
json += "\"birthday\":\"" + Convert.ToDateTime(sbasic.SBirthday).ToString("yyyy-MM-dd") + "\",";
json += "\"address\":\"" + sbasic.SAddress + "\"";
json += "}";
return(Content(json));
}
catch
{
return(Content("false"));
}
}
public void TestBasic()
{
const string s = @"<root>
<I>1</I>
<S>2</S>
<F>3</F>
<D>4</D>
</root>";
const string sUnordered = @"<root>
<D>4</D>
<I>1</I>
<F>3</F>
<S>2</S>
</root>";
var xml = new CXmlDeserializer();
SBasic foo = xml.DeserializeString <SBasic>(s);
Assert.AreEqual(1, foo.I);
Assert.AreEqual("2", foo.S);
Assert.AreEqual(3, foo.F, 0.0001);
Assert.AreEqual(4, foo.D, 0.0001);
foo = xml.DeserializeString <SBasic>(sUnordered);
Assert.AreEqual(1, foo.I);
Assert.AreEqual("2", foo.S);
Assert.AreEqual(3, foo.F, 0.0001);
Assert.AreEqual(4, foo.D, 0.0001);
}
public static SBasic <T> MakeAndExecutePostRequest <T>(string request_url, Dictionary <string, string> get_parameters, Dictionary <string, object> post_parameters)
{
var client = new RestClient(Configurations.client_url);
var request = new RestRequest(request_url, Method.POST);
if (get_parameters != null)
{
foreach (KeyValuePair <string, string> kvp in get_parameters)
{
request.AddParameter(kvp.Key, kvp.Value, ParameterType.UrlSegment);
}
}
if (post_parameters != null)
{
foreach (KeyValuePair <string, object> kvp in post_parameters)
{
request.AddParameter(kvp.Key, kvp.Value);
}
}
request.OnBeforeDeserialization = resp => { resp.ContentType = "application/json"; };
IRestResponse <SBasic <T> > response = client.Execute <SBasic <T> >(request);
SBasic <T> result = response.Data;
Last_Exception = GetPossibleError(response);
return(result);
}
//添加学生信息
public string AddStudent(SLogin slogin)
{
//1.sql语句
string sql = "insert into SBasic(SNumber,SName,SIDNumber,SCollege,SMajor,SEnrollment,SStatus,SSex,SPhone,SBirthday,SAddress,SPicAddress)"
+ " values(@SNumber,@SName,@SIDNumber,@SCollege,@SMajor,@SEnrollment,@SStatus,@SSex,@SPhone,@SBirthday,@SAddress,@SPicAddress)";
sql += " select @@identity";
//2.参数赋值
SBasic sbasic = new SBasic();
sbasic = slogin.SNumber;
College college = new College();
college = sbasic.SCollege;
Major major = new Major();
major = sbasic.SMajor;
Status status = new Status();
status = sbasic.SStatus;
State state = new State();
state = slogin.State;
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@SNumber", sbasic.SNumber),
new SqlParameter("@SName", sbasic.SName),
new SqlParameter("@SIDNumber", sbasic.SIDNumber),
new SqlParameter("@SCollege", college.CollegeId),
new SqlParameter("@SMajor", major.MajorId),
new SqlParameter("@SEnrollment", sbasic.SEnrollment),
new SqlParameter("@SStatus", status.StatusId),
new SqlParameter("@SSex", sbasic.SSex),
new SqlParameter("@SPhone", sbasic.SPhone),
new SqlParameter("@SBirthday", sbasic.SBirthday),
new SqlParameter("@SAddress", sbasic.SAddress),
new SqlParameter("@SPicAddress", sbasic.SPicAddress),
};
//3、执行sql语句
SqlHelper.ExecuteScalar(SqlHelper.ConnString, CommandType.Text, sql, para);
return(sbasic.SNumber);
}
//获取冻结用户信息
public List <SLogin> GetLocked()
{
List <SLogin> sloginlist = new List <SLogin>();
string sql = "select * from SLogin,SBasic where SLogin.SNumber=SBasic.SNumber and SLogin.State=0";
DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, sql);
if (ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
foreach (DataRow row in dt.Rows)
{
SLogin slogin = new SLogin();
SBasic sbasic = new SBasic();
sbasic.SNumber = (string)row["SNumber"];
slogin.SNumber = sbasic;
slogin.SPassword = (string)row["SName"];
/*此时spassword代表姓名数据*/
sloginlist.Add(slogin);
}
}
return(sloginlist);
}
//添加学生用户登录信息
public bool AddStudent(SLogin slogin)
{ //1.sql语句
string sql = "insert into SLogin(SNumber,SPassword,State,LastIP,LastTime)"
+ " values(@SNumber,@SPassword,@State,@LastIP,@LastTime)";
//2.参数赋值
SBasic sbasic = new SBasic();
sbasic = slogin.SNumber;
State state = new State();
state = slogin.State;
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@SNumber", sbasic.SNumber),
new SqlParameter("@SPassword", slogin.SPassword),
new SqlParameter("@State", state.StateId),
new SqlParameter("@LastIP", "192.168.1.1"),
new SqlParameter("@LastTime", "1900-01-01 08:00:00"),
};
//3、执行sql语句
return(Convert.ToInt32(SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, sql, para)) > 0);
}
//获取学生基本信息
public SBasic GetStudentBsaicBySNumber(string snumber)
{
//sql连接字符串
string sql = "select * from SBasic where SNumber=@snumber";
//参数赋值
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@snumber", snumber),
};
//执行sql
SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnString, CommandType.Text, sql, para);
SBasic sBasic = null;
if (reader.Read())
{
StatusService status = new StatusService();
CollegeService collegeService = new CollegeService();
MajorService majorService = new MajorService();
sBasic = new SBasic();
sBasic.SNumber = (string)reader["SNumber"];
sBasic.SName = (string)reader["SName"];
sBasic.SIDNumber = (string)reader["SIDNumber"];
sBasic.SCollege = collegeService.GetCollegeByCollegeId((string)reader["SCollege"]);
sBasic.SMajor = majorService.GetMajorByMajorId((string)reader["SMajor"]);
sBasic.SEnrollment = reader["SEnrollment"] != DBNull.Value ? (DateTime?)reader["SEnrollment"] : null;
sBasic.SStatus = status.GetStatusById((int)reader["SStatus"]);
sBasic.SSex = (string)reader["SSex"];
sBasic.SPhone = (string)reader["SPhone"];
sBasic.SEmail = reader["SEmail"].ToString();
sBasic.SBirthday = reader["SBirthday"] != DBNull.Value ? (DateTime?)reader["SBirthday"] : null;
sBasic.SAddress = (string)reader["SAddress"];
sBasic.SPicAddress = (string)reader["SPicAddress"];
}
return(sBasic);
}
/*Admin/AddStudent
* 1、获取学生信息（url参数）
* 2、利用UserManager-AddStudent添加学生并返回学号、
* 2、返回添加结果*/
public ActionResult AddStudent(string name, string phone, string idcard, string sex, DateTime birthday, string address, string college_id, string major_id)
{
DateTime datetime = new IPManager().GetDateTime();
string year = datetime.ToString("yyyy");
string date = datetime.ToString("yyyy-MM-dd");
string latestnumber = new UserManager().SelectTheLatestData(major_id, year);
string newnumber = "";
if (latestnumber == "0")
{
newnumber = year + major_id + "001";
}
else
{
string start = latestnumber.Substring(0, 8);
string end = latestnumber.Remove(0, 8);
newnumber = start + Convert.ToString(string.Format("{0:d3}", Convert.ToInt32(end) + 1));
}
string password = phone.Substring(3, 8);
SLogin slogin = new SLogin();
SBasic sbasic = new SBasic();
College college = new College();
college.CollegeId = college_id;
Major major = new Major();
major.MajorId = major_id;
Status status = new Status();
status.StatusId = 0;
State state = new State();
state.StateId = 1;
sbasic.SNumber = newnumber;
sbasic.SName = name;
sbasic.SIDNumber = idcard;
sbasic.SCollege = college;
sbasic.SMajor = major;
sbasic.SEnrollment = Convert.ToDateTime(date);
sbasic.SStatus = status;
sbasic.SSex = sex;
sbasic.SPhone = phone;
sbasic.SBirthday = birthday;
sbasic.SAddress = address;
sbasic.SPicAddress = "default";
slogin.SNumber = sbasic;
slogin.SPassword = password;
slogin.State = state;
if (new UserManager().AddStudent(slogin) == newnumber)
{
return(Content(newnumber));
}
else
{
return(Content("0"));
}
}
