/// <summary>
/// 得到一个对象实体
/// </summary>
public TFXK.Model.TestingPersonExam GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,PersonID,UserName,UserNamePY,Sex,PhoneNumber,Mingzu,Birthday,Country,Address,HomeAddress,Contactor,ContactorShip,ContactorPhone,Status,TypeID,ClassID,ClassLevel,Heading,HaveMaxLevel,MaxLevelNo,CreateTime,PostNo,zhidao,ExamNumber,IDNumber from tb_TestingPersonExam ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
TFXK.Model.TestingPersonExam model = new TFXK.Model.TestingPersonExam();
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 int Add(TFXK.Model.TestingPersonExam model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_TestingPersonExam(");
strSql.Append("PersonID,UserName,UserNamePY,Sex,PhoneNumber,Mingzu,Birthday,Country,Address,HomeAddress,Contactor,ContactorShip,ContactorPhone,Status,TypeID,ClassID,ClassLevel,Heading,HaveMaxLevel,MaxLevelNo,CreateTime,postno,zhidao,ExamNumber,IDNumber)");
strSql.Append(" values (");
strSql.Append("@PersonID,@UserName,@UserNamePY,@Sex,@PhoneNumber,@Mingzu,@Birthday,@Country,@Address,@HomeAddress,@Contactor,@ContactorShip,@ContactorPhone,@Status,@TypeID,@ClassID,@ClassLevel,@Heading,@HaveMaxLevel,@MaxLevelNo,@CreateTime,@postno,@zhidao,@ExamNumber,@IDNumber)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@PersonID", SqlDbType.Int, 4),
new SqlParameter("@UserName", SqlDbType.VarChar, 120),
new SqlParameter("@UserNamePY", SqlDbType.VarChar, 120),
new SqlParameter("@Sex", SqlDbType.VarChar, 120),
new SqlParameter("@PhoneNumber", SqlDbType.VarChar, 120),
new SqlParameter("@Mingzu", SqlDbType.VarChar, 120),
new SqlParameter("@Birthday", SqlDbType.VarChar, 120),
new SqlParameter("@Country", SqlDbType.VarChar, 120),
new SqlParameter("@Address", SqlDbType.VarChar, 120),
new SqlParameter("@HomeAddress", SqlDbType.VarChar, 120),
new SqlParameter("@Contactor", SqlDbType.VarChar, 120),
new SqlParameter("@ContactorShip", SqlDbType.VarChar, 120),
new SqlParameter("@ContactorPhone", SqlDbType.VarChar, 120),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@TypeID", SqlDbType.Int, 4),
new SqlParameter("@ClassID", SqlDbType.VarChar, 120),
new SqlParameter("@ClassLevel", SqlDbType.VarChar, 50),
new SqlParameter("@Heading", SqlDbType.VarChar, 150),
new SqlParameter("@HaveMaxLevel", SqlDbType.VarChar, 50),
new SqlParameter("@MaxLevelNo", SqlDbType.VarChar, 100),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@postno", SqlDbType.VarChar, 100),
new SqlParameter("@zhidao", SqlDbType.VarChar, 50),
new SqlParameter("@ExamNumber", SqlDbType.VarChar, 50),
new SqlParameter("@IDNumber", SqlDbType.VarChar, 50),
};
parameters[0].Value = model.PersonID;
parameters[1].Value = model.UserName;
parameters[2].Value = model.UserNamePY;
parameters[3].Value = model.Sex;
parameters[4].Value = model.PhoneNumber;
parameters[5].Value = model.Mingzu;
parameters[6].Value = model.Birthday;
parameters[7].Value = model.Country;
parameters[8].Value = model.Address;
parameters[9].Value = model.HomeAddress;
parameters[10].Value = model.Contactor;
parameters[11].Value = model.ContactorShip;
parameters[12].Value = model.ContactorPhone;
parameters[13].Value = model.Status;
parameters[14].Value = model.TypeID;
parameters[15].Value = model.ClassID;
parameters[16].Value = model.ClassLevel;
parameters[17].Value = model.Heading;
parameters[18].Value = model.HaveMaxLevel;
parameters[19].Value = model.MaxLevelNo;
parameters[20].Value = model.CreateTime;
parameters[21].Value = model.PostNo;
parameters[22].Value = model.Zhidao;
parameters[23].Value = model.ExamNumber;
parameters[24].Value = model.IDNumber;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TFXK.Model.TestingPersonExam DataRowToModel(DataRow row)
{
TFXK.Model.TestingPersonExam model = new TFXK.Model.TestingPersonExam();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["PersonID"] != null && row["PersonID"].ToString() != "")
{
model.PersonID = int.Parse(row["PersonID"].ToString());
}
if (row["UserName"] != null)
{
model.UserName = row["UserName"].ToString();
}
if (row["UserNamePY"] != null)
{
model.UserNamePY = row["UserNamePY"].ToString();
}
if (row["Sex"] != null)
{
model.Sex = row["Sex"].ToString();
}
if (row["PhoneNumber"] != null)
{
model.PhoneNumber = row["PhoneNumber"].ToString();
}
if (row["Mingzu"] != null)
{
model.Mingzu = row["Mingzu"].ToString();
}
if (row["Birthday"] != null)
{
model.Birthday = row["Birthday"].ToString();
}
if (row["Country"] != null)
{
model.Country = row["Country"].ToString();
}
if (row["Address"] != null)
{
model.Address = row["Address"].ToString();
}
if (row["HomeAddress"] != null)
{
model.HomeAddress = row["HomeAddress"].ToString();
}
if (row["Contactor"] != null)
{
model.Contactor = row["Contactor"].ToString();
}
if (row["ContactorShip"] != null)
{
model.ContactorShip = row["ContactorShip"].ToString();
}
if (row["ContactorPhone"] != null)
{
model.ContactorPhone = row["ContactorPhone"].ToString();
}
if (row["Status"] != null && row["Status"].ToString() != "")
{
model.Status = int.Parse(row["Status"].ToString());
}
if (row["TypeID"] != null && row["TypeID"].ToString() != "")
{
model.TypeID = int.Parse(row["TypeID"].ToString());
}
if (row["ClassID"] != null && row["ClassID"].ToString() != "")
{
model.ClassID = row["ClassID"].ToString();
}
if (row["ClassLevel"] != null)
{
model.ClassLevel = row["ClassLevel"].ToString();
}
if (row["Heading"] != null)
{
model.Heading = row["Heading"].ToString();
}
if (row["HaveMaxLevel"] != null)
{
model.HaveMaxLevel = row["HaveMaxLevel"].ToString();
}
if (row["MaxLevelNo"] != null)
{
model.MaxLevelNo = row["MaxLevelNo"].ToString();
}
if (row["CreateTime"] != null && row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
if (row["PostNo"] != null)
{
model.PostNo = row["PostNo"].ToString();
}
if (row["zhidao"] != null)
{
model.Zhidao = row["zhidao"].ToString();
}
if (row["ExamNumber"] != null)
{
model.ExamNumber = row["ExamNumber"].ToString();
}
if (row["IDNumber"] != null)
{
model.IDNumber = row["IDNumber"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(TFXK.Model.TestingPersonExam model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_TestingPersonExam set ");
strSql.Append("PersonID=@PersonID,");
strSql.Append("UserName=@UserName,");
strSql.Append("UserNamePY=@UserNamePY,");
strSql.Append("Sex=@Sex,");
strSql.Append("PhoneNumber=@PhoneNumber,");
strSql.Append("Mingzu=@Mingzu,");
strSql.Append("Birthday=@Birthday,");
strSql.Append("Country=@Country,");
strSql.Append("Address=@Address,");
strSql.Append("HomeAddress=@HomeAddress,");
strSql.Append("Contactor=@Contactor,");
strSql.Append("ContactorShip=@ContactorShip,");
strSql.Append("ContactorPhone=@ContactorPhone,");
strSql.Append("Status=@Status,");
strSql.Append("TypeID=@TypeID,");
strSql.Append("ClassID=@ClassID,");
strSql.Append("ClassLevel=@ClassLevel,");
strSql.Append("Heading=@Heading,");
strSql.Append("HaveMaxLevel=@HaveMaxLevel,");
strSql.Append("MaxLevelNo=@MaxLevelNo,");
strSql.Append("CreateTime=@CreateTime,");
strSql.Append("PostNo=@PostNo,");
strSql.Append("zhidao=@zhidao,");
strSql.Append("ExamNumber=@ExamNumber,");
strSql.Append("IDNumber=@IDNumber");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@PersonID", SqlDbType.Int, 4),
new SqlParameter("@UserName", SqlDbType.VarChar, 120),
new SqlParameter("@UserNamePY", SqlDbType.VarChar, 120),
new SqlParameter("@Sex", SqlDbType.VarChar, 120),
new SqlParameter("@PhoneNumber", SqlDbType.VarChar, 120),
new SqlParameter("@Mingzu", SqlDbType.VarChar, 120),
new SqlParameter("@Birthday", SqlDbType.VarChar, 120),
new SqlParameter("@Country", SqlDbType.VarChar, 120),
new SqlParameter("@Address", SqlDbType.VarChar, 120),
new SqlParameter("@HomeAddress", SqlDbType.VarChar, 120),
new SqlParameter("@Contactor", SqlDbType.VarChar, 120),
new SqlParameter("@ContactorShip", SqlDbType.VarChar, 120),
new SqlParameter("@ContactorPhone", SqlDbType.VarChar, 120),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@TypeID", SqlDbType.Int, 4),
new SqlParameter("@ClassID", SqlDbType.VarChar, 120),
new SqlParameter("@ClassLevel", SqlDbType.VarChar, 50),
new SqlParameter("@Heading", SqlDbType.VarChar, 150),
new SqlParameter("@HaveMaxLevel", SqlDbType.VarChar, 50),
new SqlParameter("@MaxLevelNo", SqlDbType.VarChar, 100),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@PostNo", SqlDbType.VarChar, 100),
new SqlParameter("@zhidao", SqlDbType.VarChar, 50),
new SqlParameter("@ExamNumber", SqlDbType.VarChar, 50),
new SqlParameter("@IDNumber", SqlDbType.VarChar, 50),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.PersonID;
parameters[1].Value = model.UserName;
parameters[2].Value = model.UserNamePY;
parameters[3].Value = model.Sex;
parameters[4].Value = model.PhoneNumber;
parameters[5].Value = model.Mingzu;
parameters[6].Value = model.Birthday;
parameters[7].Value = model.Country;
parameters[8].Value = model.Address;
parameters[9].Value = model.HomeAddress;
parameters[10].Value = model.Contactor;
parameters[11].Value = model.ContactorShip;
parameters[12].Value = model.ContactorPhone;
parameters[13].Value = model.Status;
parameters[14].Value = model.TypeID;
parameters[15].Value = model.ClassID;
parameters[16].Value = model.ClassLevel;
parameters[17].Value = model.Heading;
parameters[18].Value = model.HaveMaxLevel;
parameters[19].Value = model.MaxLevelNo;
parameters[20].Value = model.CreateTime;
parameters[21].Value = model.PostNo;
parameters[22].Value = model.Zhidao;
parameters[23].Value = model.ExamNumber;
parameters[24].Value = model.IDNumber;
parameters[25].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}