protected void registerbtn_Click(object sender, EventArgs e)
{
Interwebsite.Model.Student student = new Interwebsite.Model.Student();
student.Username = "******";
student.Password = "******";
student.FirstProject = Request["preferedprogram"];
student.SecondProject = Request["altprogram"];
student.Realname = Request["name"];
student.Sex = Request["gender"];
//student.IDCardNumber =int.Parse(Request["idno"]);
student.Birthday = DateTime.Parse(Request["birthdate"]);
student.Ethnic = Request["nationality"]; //名族
student.FamilyAddress = Request["city"]; //户籍所在地
//政治面貌
student.DomicileAddress = Request["adress"]; //联系地址
//student.Postalcode =int.Parse(Request["zipcode"]);
//student.QQNumber = int.Parse(Request["qq"]);
//student.PhoneNumber =int.Parse(Request["phone"]);
student.Email = Request["email"];
student.FamilyAddress = Request["famadress"];//家庭住址
student.GraduateSchool = Request["graduated"];
student.Major = Request["major"];
//student.GraduateTime = DateTime.Parse(Request["gradyear"]);
//student.EntranceTime = DateTime.Parse(Request["startyear"]);
student.EnglishLevel = Request["englishskill"];
//student.UndergraduateGPA = int.Parse(Request["gpa"]);
student.WorkExperience = Request["workexp"];
student.RewardsAndPunish = Request["rewardspunisment"];
student.CreateTime = DateTime.Now;
student.ModifyTime = DateTime.Now;
}
protected void registerbtn_Click(object sender, EventArgs e)
{
Interwebsite.Model.Student student = new Interwebsite.Model.Student();
student.Username = "******";
student.Password = "******";
student.FirstProject = Request["preferedprogram"];
student.SecondProject = Request["altprogram"];
student.Realname = Request["name"];
student.Sex = Request["gender"];
//student.IDCardNumber =int.Parse(Request["idno"]);
student.Birthday = DateTime.Parse(Request["birthdate"]);
student.Ethnic = Request["nationality"];//名族
student.FamilyAddress = Request["city"];//户籍所在地
//政治面貌
student.DomicileAddress = Request["adress"];//联系地址
//student.Postalcode =int.Parse(Request["zipcode"]);
//student.QQNumber = int.Parse(Request["qq"]);
//student.PhoneNumber =int.Parse(Request["phone"]);
student.Email = Request["email"];
student.FamilyAddress = Request["famadress"];//家庭住址
student.GraduateSchool = Request["graduated"];
student.Major = Request["major"];
//student.GraduateTime = DateTime.Parse(Request["gradyear"]);
//student.EntranceTime = DateTime.Parse(Request["startyear"]);
student.EnglishLevel = Request["englishskill"];
//student.UndergraduateGPA = int.Parse(Request["gpa"]);
student.WorkExperience = Request["workexp"];
student.RewardsAndPunish = Request["rewardspunisment"];
student.CreateTime = DateTime.Now;
student.ModifyTime = DateTime.Now;
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Interwebsite.Model.Student model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Student(");
strSql.Append("Username,Password,Realname,Sex,PhoneNumber,Email,CreateTime,ModifyTime)");
strSql.Append(" values (");
strSql.Append("@Username,@Password,@Realname,@Sex,@PhoneNumber,@Email,@CreateTime,@ModifyTime)");
SqlParameter[] parameters =
{
new SqlParameter("@Username", SqlDbType.NVarChar, 100),
new SqlParameter("@Password", SqlDbType.NVarChar, 100),
new SqlParameter("@Realname", SqlDbType.NVarChar, 50),
new SqlParameter("@Sex", SqlDbType.NVarChar, 20),
new SqlParameter("@PhoneNumber", SqlDbType.NVarChar, 15),
new SqlParameter("@Email", SqlDbType.NVarChar, 50),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@ModifyTime", SqlDbType.DateTime),
};
parameters[0].Value = model.Username;
parameters[1].Value = model.Password;
parameters[2].Value = model.Realname;
parameters[3].Value = model.Sex;
parameters[4].Value = model.PhoneNumber;
parameters[5].Value = model.Email;
parameters[6].Value = model.CreateTime;
parameters[7].Value = model.ModifyTime;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Interwebsite.Model.Student GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select top1 Username,Password,Realname,Sex,IDCardNumber,Birthday,Ethnic,DomicileAddress,Address,Postalcode,QQnumber,PhoneNumber,Email,FamilyAddress,CreateTime,ModifyTime,FirstProject,SecondProject,GraduateSchool,Major,GraduateTime,EntranceTime,EnglishLevel,UndergraduateGPA,WorkExperience,RewardsAndPunish from Student ");
strSql.Append(" where ");
SqlParameter[] parameters =
{
};
Interwebsite.Model.Student model = new Interwebsite.Model.Student();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Interwebsite.Model.Student GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select top1 Username,Password,Realname,Sex,IDCardNumber,Birthday,Ethnic,DomicileAddress,Address,Postalcode,QQnumber,PhoneNumber,Email,FamilyAddress,CreateTime,ModifyTime,FirstProject,SecondProject,GraduateSchool,Major,GraduateTime,EntranceTime,EnglishLevel,UndergraduateGPA,WorkExperience,RewardsAndPunish from Student ");
strSql.Append(" where ");
SqlParameter[] parameters = {
};
Interwebsite.Model.Student model = new Interwebsite.Model.Student();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Interwebsite.Model.Student DataRowToModel(DataRow row)
{
Interwebsite.Model.Student model=new Interwebsite.Model.Student();
if (row != null)
{
if(row["Username"]!=null)
{
model.Username=row["Username"].ToString();
}
if(row["Password"]!=null)
{
model.Password=row["Password"].ToString();
}
if(row["Realname"]!=null)
{
model.Realname=row["Realname"].ToString();
}
if(row["Sex"]!=null)
{
model.Sex=row["Sex"].ToString();
}
if(row["IDCardNumber"]!=null)
{
model.IDCardNumber=row["IDCardNumber"].ToString();
}
if(row["Birthday"]!=null && row["Birthday"].ToString()!="")
{
model.Birthday=DateTime.Parse(row["Birthday"].ToString());
}
if(row["Ethnic"]!=null)
{
model.Ethnic=row["Ethnic"].ToString();
}
if(row["DomicileAddress"]!=null)
{
model.DomicileAddress=row["DomicileAddress"].ToString();
}
if(row["Address"]!=null)
{
model.Address=row["Address"].ToString();
}
if(row["Postalcode"]!=null && row["Postalcode"].ToString()!="")
{
model.Postalcode=row["Postalcode"].ToString();
}
if(row["QQnumber"]!=null && row["QQnumber"].ToString()!="")
{
model.QQnumber=row["QQnumber"].ToString();
}
if(row["PhoneNumber"]!=null && row["PhoneNumber"].ToString()!="")
{
model.PhoneNumber=row["PhoneNumber"].ToString();
}
if(row["Email"]!=null)
{
model.Email=row["Email"].ToString();
}
if(row["FamilyAddress"]!=null)
{
model.FamilyAddress=row["FamilyAddress"].ToString();
}
if(row["CreateTime"]!=null && row["CreateTime"].ToString()!="")
{
model.CreateTime=DateTime.Parse(row["CreateTime"].ToString());
}
if(row["ModifyTime"]!=null && row["ModifyTime"].ToString()!="")
{
model.ModifyTime=DateTime.Parse(row["ModifyTime"].ToString());
}
if(row["FirstProject"]!=null)
{
model.FirstProject=row["FirstProject"].ToString();
}
if(row["SecondProject"]!=null)
{
model.SecondProject=row["SecondProject"].ToString();
}
if(row["GraduateSchool"]!=null)
{
model.GraduateSchool=row["GraduateSchool"].ToString();
}
if(row["Major"]!=null)
{
model.Major=row["Major"].ToString();
}
if(row["GraduateTime"]!=null && row["GraduateTime"].ToString()!="")
{
model.GraduateTime=DateTime.Parse(row["GraduateTime"].ToString());
}
if(row["EntranceTime"]!=null && row["EntranceTime"].ToString()!="")
{
model.EntranceTime=DateTime.Parse(row["EntranceTime"].ToString());
}
if(row["EnglishLevel"]!=null)
{
model.EnglishLevel=row["EnglishLevel"].ToString();
}
if(row["UndergraduateGPA"]!=null && row["UndergraduateGPA"].ToString()!="")
{
model.UndergraduateGPA=int.Parse(row["UndergraduateGPA"].ToString());
}
if(row["WorkExperience"]!=null)
{
model.WorkExperience=row["WorkExperience"].ToString();
}
if(row["RewardsAndPunish"]!=null)
{
model.RewardsAndPunish=row["RewardsAndPunish"].ToString();
}
}
return model;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool AddandUpdate(Interwebsite.Model.Student model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Student set ");
strSql.Append("Realname=@Realname,");
strSql.Append("Sex=@Sex,");
strSql.Append("IDCardNumber=@IDCardNumber,");
strSql.Append("Birthday=@Birthday,");
strSql.Append("Ethnic=@Ethnic,");
strSql.Append("DomicileAddress=@DomicileAddress,");
strSql.Append("Address=@Address,");
strSql.Append("Postalcode=@Postalcode,");
strSql.Append("QQnumber=@QQnumber,");
strSql.Append("PhoneNumber=@PhoneNumber,");
strSql.Append("Email=@Email,");
strSql.Append("FamilyAddress=@FamilyAddress,");
strSql.Append("ModifyTime=@ModifyTime,");
strSql.Append("FirstProject=@FirstProject,");
strSql.Append("SecondProject=@SecondProject,");
strSql.Append("GraduateSchool=@GraduateSchool,");
strSql.Append("Major=@Major,");
strSql.Append("GraduateTime=@GraduateTime,");
strSql.Append("EntranceTime=@EntranceTime,");
strSql.Append("EnglishLevel=@EnglishLevel,");
strSql.Append("UndergraduateGPA=@UndergraduateGPA,");
strSql.Append("WorkExperience=@WorkExperience,");
strSql.Append("RewardsAndPunish=@RewardsAndPunish");
strSql.Append("politic=@politic");
strSql.Append("famzipcode=@famzipcode");
strSql.Append(" where username=@username");
SqlParameter[] parameters =
{
new SqlParameter("@Realname", SqlDbType.NVarChar, 50),
new SqlParameter("@Sex", SqlDbType.NVarChar, 20),
new SqlParameter("@IDCardNumber", SqlDbType.NVarChar, 30),
new SqlParameter("@Birthday", SqlDbType.DateTime),
new SqlParameter("@Ethnic", SqlDbType.NVarChar, 30),
new SqlParameter("@DomicileAddress", SqlDbType.NVarChar, 100),
new SqlParameter("@Address", SqlDbType.NVarChar, 100),
new SqlParameter("@Postalcode", SqlDbType.NVarChar, 6),
new SqlParameter("@QQnumber", SqlDbType.NVarChar, 11),
new SqlParameter("@PhoneNumber", SqlDbType.NVarChar, 15),
new SqlParameter("@Email", SqlDbType.NVarChar, 50),
new SqlParameter("@FamilyAddress", SqlDbType.NVarChar, 100),
new SqlParameter("@ModifyTime", SqlDbType.DateTime),
new SqlParameter("@FirstProject", SqlDbType.NVarChar, 50),
new SqlParameter("@SecondProject", SqlDbType.NVarChar, 50),
new SqlParameter("@GraduateSchool", SqlDbType.NVarChar, 50),
new SqlParameter("@Major", SqlDbType.NVarChar, 50),
new SqlParameter("@GraduateTime", SqlDbType.DateTime),
new SqlParameter("@EntranceTime", SqlDbType.DateTime),
new SqlParameter("@EnglishLevel", SqlDbType.NVarChar, 50),
new SqlParameter("@UndergraduateGPA", SqlDbType.Decimal, 9),
new SqlParameter("@WorkExperience", SqlDbType.Text, 16),
new SqlParameter("@RewardsAndPunish", SqlDbType.Text, 16),
new SqlParameter("@username", SqlDbType.NVarChar, 50),
new SqlParameter("@politic", SqlDbType.NVarChar, 50),
new SqlParameter("@famzipcode", SqlDbType.NVarChar, 10),
};
parameters[0].Value = model.Realname;
parameters[1].Value = model.Sex;
parameters[2].Value = model.IDCardNumber;
parameters[3].Value = model.Birthday;
parameters[4].Value = model.Ethnic;
parameters[5].Value = model.DomicileAddress;
parameters[6].Value = model.Address;
parameters[7].Value = model.Postalcode;
parameters[8].Value = model.QQnumber;
parameters[9].Value = model.PhoneNumber;
parameters[10].Value = model.Email;
parameters[11].Value = model.FamilyAddress;
parameters[12].Value = model.ModifyTime;
parameters[13].Value = model.FirstProject;
parameters[14].Value = model.SecondProject;
parameters[15].Value = model.GraduateSchool;
parameters[16].Value = model.Major;
parameters[17].Value = model.GraduateTime;
parameters[18].Value = model.EntranceTime;
parameters[19].Value = model.EnglishLevel;
parameters[20].Value = model.UndergraduateGPA;
parameters[21].Value = model.WorkExperience;
parameters[22].Value = model.RewardsAndPunish;
parameters[23].Value = model.Username;
parameters[24].Value = model.politic;
parameters[25].Value = model.famzipcode;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Interwebsite.Model.Student DataRowToModel(DataRow row)
{
Interwebsite.Model.Student model = new Interwebsite.Model.Student();
if (row != null)
{
if (row["Username"] != null)
{
model.Username = row["Username"].ToString();
}
if (row["Password"] != null)
{
model.Password = row["Password"].ToString();
}
if (row["Realname"] != null)
{
model.Realname = row["Realname"].ToString();
}
if (row["Sex"] != null)
{
model.Sex = row["Sex"].ToString();
}
if (row["IDCardNumber"] != null)
{
model.IDCardNumber = row["IDCardNumber"].ToString();
}
if (row["Birthday"] != null && row["Birthday"].ToString() != "")
{
model.Birthday = DateTime.Parse(row["Birthday"].ToString());
}
if (row["Ethnic"] != null)
{
model.Ethnic = row["Ethnic"].ToString();
}
if (row["DomicileAddress"] != null)
{
model.DomicileAddress = row["DomicileAddress"].ToString();
}
if (row["Address"] != null)
{
model.Address = row["Address"].ToString();
}
if (row["Postalcode"] != null && row["Postalcode"].ToString() != "")
{
model.Postalcode = row["Postalcode"].ToString();
}
if (row["QQnumber"] != null && row["QQnumber"].ToString() != "")
{
model.QQnumber = row["QQnumber"].ToString();
}
if (row["PhoneNumber"] != null && row["PhoneNumber"].ToString() != "")
{
model.PhoneNumber = row["PhoneNumber"].ToString();
}
if (row["Email"] != null)
{
model.Email = row["Email"].ToString();
}
if (row["FamilyAddress"] != null)
{
model.FamilyAddress = row["FamilyAddress"].ToString();
}
if (row["CreateTime"] != null && row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
if (row["ModifyTime"] != null && row["ModifyTime"].ToString() != "")
{
model.ModifyTime = DateTime.Parse(row["ModifyTime"].ToString());
}
if (row["FirstProject"] != null)
{
model.FirstProject = row["FirstProject"].ToString();
}
if (row["SecondProject"] != null)
{
model.SecondProject = row["SecondProject"].ToString();
}
if (row["GraduateSchool"] != null)
{
model.GraduateSchool = row["GraduateSchool"].ToString();
}
if (row["Major"] != null)
{
model.Major = row["Major"].ToString();
}
if (row["GraduateTime"] != null && row["GraduateTime"].ToString() != "")
{
model.GraduateTime = DateTime.Parse(row["GraduateTime"].ToString());
}
if (row["EntranceTime"] != null && row["EntranceTime"].ToString() != "")
{
model.EntranceTime = DateTime.Parse(row["EntranceTime"].ToString());
}
if (row["EnglishLevel"] != null)
{
model.EnglishLevel = row["EnglishLevel"].ToString();
}
if (row["UndergraduateGPA"] != null && row["UndergraduateGPA"].ToString() != "")
{
model.UndergraduateGPA = int.Parse(row["UndergraduateGPA"].ToString());
}
if (row["WorkExperience"] != null)
{
model.WorkExperience = row["WorkExperience"].ToString();
}
if (row["RewardsAndPunish"] != null)
{
model.RewardsAndPunish = row["RewardsAndPunish"].ToString();
}
}
return(model);
}
