public bool Add(Interwebsite.Model.Announcement model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Announcement(");
strSql.Append("AnnouncementName,AnnouncementInfo,Author,CreateTime,ModifyTime)");
strSql.Append(" values (");
strSql.Append("@AnnouncementName,@AnnouncementInfo,@Author,@CreateTime,@ModifyTime)");
SqlParameter[] parameters = {
new SqlParameter("@AnnouncementName", SqlDbType.NVarChar,100),
new SqlParameter("@AnnouncementInfo", SqlDbType.Text,16),
new SqlParameter("@Author", SqlDbType.NVarChar,20),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@ModifyTime", SqlDbType.DateTime)};
parameters[0].Value = model.AnnouncementName;
parameters[1].Value = model.AnnouncementInfo;
parameters[2].Value = model.Author;
parameters[3].Value = model.CreateTime;
parameters[4].Value = model.ModifyTime;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Interwebsite.Model.Attachment model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Attachment(");
strSql.Append("ID,AttachmentName,UploadName,UploadTime,AttachmentAddress)");
strSql.Append(" values (");
strSql.Append("@ID,@AttachmentName,@UploadName,@UploadTime,@AttachmentAddress)");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4),
new SqlParameter("@AttachmentName", SqlDbType.NVarChar,100),
new SqlParameter("@UploadName", SqlDbType.NVarChar,50),
new SqlParameter("@UploadTime", SqlDbType.DateTime),
new SqlParameter("@AttachmentAddress", SqlDbType.NVarChar,100)};
parameters[0].Value = model.ID;
parameters[1].Value = model.AttachmentName;
parameters[2].Value = model.UploadName;
parameters[3].Value = model.UploadTime;
parameters[4].Value = model.AttachmentAddress;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Interwebsite.Model.Project model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Project(");
strSql.Append("ProjectName,ProjectInfo,RecruitGuide,CreateTime,ModifyTime,Attachment)");
strSql.Append(" values (");
strSql.Append("@ProjectName,@ProjectInfo,@RecruitGuide,@CreateTime,@ModifyTime,@Attachment)");
SqlParameter[] parameters = {
new SqlParameter("@ProjectName", SqlDbType.NVarChar,50),
new SqlParameter("@ProjectInfo", SqlDbType.Text,16),
new SqlParameter("@RecruitGuide", SqlDbType.Text,16),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@ModifyTime", SqlDbType.DateTime),
new SqlParameter("@Attachment",SqlDbType.NVarChar,100)
};
parameters[0].Value = model.ProjectName;
parameters[1].Value = model.ProjectInfo;
parameters[2].Value = model.RecruitGuide;
parameters[3].Value = model.CreateTime;
parameters[4].Value = model.ModifyTime;
parameters[5].Value = model.Attachment;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Interwebsite.Model.School model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into School(");
strSql.Append("ID,SchoolName,Nation,Linkman,LinkAddress,Email,LinkPhone,SchoolInfo,CreateTime,ModifyTime)");
strSql.Append(" values (");
strSql.Append("@ID,@SchoolName,@Nation,@Linkman,@LinkAddress,@Email,@LinkPhone,@SchoolInfo,@CreateTime,@ModifyTime)");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4),
new SqlParameter("@SchoolName", SqlDbType.NVarChar,50),
new SqlParameter("@Nation", SqlDbType.NVarChar,50),
new SqlParameter("@Linkman", SqlDbType.NVarChar,50),
new SqlParameter("@LinkAddress", SqlDbType.NVarChar,100),
new SqlParameter("@Email", SqlDbType.NVarChar,50),
new SqlParameter("@LinkPhone", SqlDbType.Int,4),
new SqlParameter("@SchoolInfo", SqlDbType.NVarChar,2000),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@ModifyTime", SqlDbType.DateTime)};
parameters[0].Value = model.ID;
parameters[1].Value = model.SchoolName;
parameters[2].Value = model.Nation;
parameters[3].Value = model.Linkman;
parameters[4].Value = model.LinkAddress;
parameters[5].Value = model.Email;
parameters[6].Value = model.LinkPhone;
parameters[7].Value = model.SchoolInfo;
parameters[8].Value = model.CreateTime;
parameters[9].Value = model.ModifyTime;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <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 bool Update(Interwebsite.Model.Announcement model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Interwebsite.Model.Announcement model)
{
return dal.Add(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Interwebsite.Model.Project model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Interwebsite.Model.Project model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Interwebsite.Model.Attachment model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Interwebsite.Model.Attachment model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Interwebsite.Model.School model)
{
return dal.Add(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 bool Update(Interwebsite.Model.Project model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Project set ");
strSql.Append("ID=@ID,");
strSql.Append("ProjectName=@ProjectName,");
strSql.Append("ProjectInfo=@ProjectInfo,");
strSql.Append("RecruitGuide=@RecruitGuide,");
strSql.Append("CreateTime=@CreateTime,");
strSql.Append("ModifyTime=@ModifyTime");
strSql.Append(" where ");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4),
new SqlParameter("@ProjectName", SqlDbType.NVarChar,50),
new SqlParameter("@ProjectInfo", SqlDbType.NVarChar,2000),
new SqlParameter("@RecruitGuide", SqlDbType.NVarChar,2000),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@ModifyTime", SqlDbType.DateTime)};
parameters[0].Value = model.ID;
parameters[1].Value = model.ProjectName;
parameters[2].Value = model.ProjectInfo;
parameters[3].Value = model.RecruitGuide;
parameters[4].Value = model.CreateTime;
parameters[5].Value = model.ModifyTime;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool AddandUpdate(Interwebsite.Model.Student model)
{
return dal.AddandUpdate(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Interwebsite.Model.Student model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Interwebsite.Model.Attachment model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Attachment set ");
strSql.Append("ID=@ID,");
strSql.Append("AttachmentName=@AttachmentName,");
strSql.Append("UploadName=@UploadName,");
strSql.Append("UploadTime=@UploadTime,");
strSql.Append("AttachmentAddress=@AttachmentAddress");
strSql.Append(" where ");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4),
new SqlParameter("@AttachmentName", SqlDbType.NVarChar,100),
new SqlParameter("@UploadName", SqlDbType.NVarChar,50),
new SqlParameter("@UploadTime", SqlDbType.DateTime),
new SqlParameter("@AttachmentAddress", SqlDbType.NVarChar,100)};
parameters[0].Value = model.ID;
parameters[1].Value = model.AttachmentName;
parameters[2].Value = model.UploadName;
parameters[3].Value = model.UploadTime;
parameters[4].Value = model.AttachmentAddress;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Interwebsite.Model.Announcement model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Announcement set ");
strSql.Append("ID=@ID,");
strSql.Append("AnnouncementName=@AnnouncementName,");
strSql.Append("AnnouncementInfo=@AnnouncementInfo,");
strSql.Append("Author=@Author,");
strSql.Append("CreateTime=@CreateTime,");
strSql.Append("ModifyTime=@ModifyTime");
strSql.Append(" where ");
strSql.Append("ID='"+model.ID+"'");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4),
new SqlParameter("@AnnouncementName", SqlDbType.NVarChar,100),
new SqlParameter("@AnnouncementInfo", SqlDbType.Text,16),
new SqlParameter("@Author", SqlDbType.NVarChar,20),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@ModifyTime", SqlDbType.DateTime)};
parameters[0].Value = model.ID;
parameters[1].Value = model.AnnouncementName;
parameters[2].Value = model.AnnouncementInfo;
parameters[3].Value = model.Author;
parameters[4].Value = model.CreateTime;
parameters[5].Value = model.ModifyTime;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Interwebsite.Model.School model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update School set ");
strSql.Append("ID=@ID,");
strSql.Append("SchoolName=@SchoolName,");
strSql.Append("Nation=@Nation,");
strSql.Append("Linkman=@Linkman,");
strSql.Append("LinkAddress=@LinkAddress,");
strSql.Append("Email=@Email,");
strSql.Append("LinkPhone=@LinkPhone,");
strSql.Append("SchoolInfo=@SchoolInfo,");
strSql.Append("CreateTime=@CreateTime,");
strSql.Append("ModifyTime=@ModifyTime");
strSql.Append(" where ");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4),
new SqlParameter("@SchoolName", SqlDbType.NVarChar,50),
new SqlParameter("@Nation", SqlDbType.NVarChar,50),
new SqlParameter("@Linkman", SqlDbType.NVarChar,50),
new SqlParameter("@LinkAddress", SqlDbType.NVarChar,100),
new SqlParameter("@Email", SqlDbType.NVarChar,50),
new SqlParameter("@LinkPhone", SqlDbType.Int,4),
new SqlParameter("@SchoolInfo", SqlDbType.NVarChar,2000),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@ModifyTime", SqlDbType.DateTime)};
parameters[0].Value = model.ID;
parameters[1].Value = model.SchoolName;
parameters[2].Value = model.Nation;
parameters[3].Value = model.Linkman;
parameters[4].Value = model.LinkAddress;
parameters[5].Value = model.Email;
parameters[6].Value = model.LinkPhone;
parameters[7].Value = model.SchoolInfo;
parameters[8].Value = model.CreateTime;
parameters[9].Value = model.ModifyTime;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Interwebsite.Model.School model)
{
return dal.Update(model);
}
