/// <summary>
/// 增加一条数据
/// </summary>
public int Add(TFXK.Model.TestingPerson model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_TestingPerson(");
strSql.Append("UserName,UserNamePY,UserPassword,Sex,PhoneNumber,Mingzu,Birthday,Country,Address,HomeAddress,Contactor,ContactorShip,ContactorPhone,Status,CreateTime,IDNumber)");
strSql.Append(" values (");
strSql.Append("@UserName,@UserNamePY,@UserPassword,@Sex,@PhoneNumber,@Mingzu,@Birthday,@Country,@Address,@HomeAddress,@Contactor,@ContactorShip,@ContactorPhone,@Status,@CreateTime,@IDNumber)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@UserName", SqlDbType.VarChar, 120),
new SqlParameter("@UserNamePY", SqlDbType.VarChar, 120),
new SqlParameter("@UserPassword", 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("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@IDNumber", SqlDbType.VarChar, 120),
};
parameters[0].Value = model.UserName;
parameters[1].Value = model.UserNamePY;
parameters[2].Value = model.UserPassword;
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.CreateTime;
parameters[15].Value = model.IDNumber;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
public TFXK.Model.TestingPerson GetModelByPhone(string phoneNumber)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,UserName,UserNamePY,UserPassword,Sex,PhoneNumber,Mingzu,Birthday,Country,Address,HomeAddress,Contactor,ContactorShip,ContactorPhone,Status,CreateTime,IDNumber from tb_TestingPerson ");
strSql.Append(" where PhoneNumber=@PhoneNumber or UserName=@PhoneNumber");
SqlParameter[] parameters =
{
new SqlParameter("@PhoneNumber", SqlDbType.VarChar, 120)
};
parameters[0].Value = phoneNumber;
TFXK.Model.TestingPerson model = new TFXK.Model.TestingPerson();
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 TFXK.Model.TestingPerson DataRowToModel(DataRow row)
{
TFXK.Model.TestingPerson model = new TFXK.Model.TestingPerson();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["UserName"] != null)
{
model.UserName = row["UserName"].ToString();
}
if (row["UserNamePY"] != null)
{
model.UserNamePY = row["UserNamePY"].ToString();
}
if (row["UserPassword"] != null)
{
model.UserPassword = row["UserPassword"].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["CreateTime"] != null && row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
if (row["IDNumber"] != null)
{
model.IDNumber = row["IDNumber"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(TFXK.Model.TestingPerson model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_TestingPerson set ");
strSql.Append("UserName=@UserName,");
strSql.Append("UserNamePY=@UserNamePY,");
strSql.Append("UserPassword=@UserPassword,");
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("CreateTime=@CreateTime,");
strSql.Append("IDNumber=@IDNumber");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@UserName", SqlDbType.VarChar, 120),
new SqlParameter("@UserNamePY", SqlDbType.VarChar, 120),
new SqlParameter("@UserPassword", 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("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@IDNumber", SqlDbType.VarChar, 120),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.UserName;
parameters[1].Value = model.UserNamePY;
parameters[2].Value = model.UserPassword;
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.CreateTime;
parameters[15].Value = model.IDNumber;
parameters[16].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
