/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="UID">编号ID</param>
/// <returns>返回影响行数</returns>
public int Add(Userfields model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO " + tablePrefix + "Userfields(");
strSql.Append("UID,Realname,QQ,MSN,Skype,Phone,Mobilephone,Location,Adress,IDcard,Signature,Introduce,Website)");
strSql.Append(" VALUES (");
strSql.Append("@UID,@Realname,@QQ,@MSN,@Skype,@Phone,@Mobilephone,@Location,@Adress,@IDcard,@Signature,@Introduce,@Website)");
SqlParameter[] cmdParms =
{
AddInParameter("@UID", SqlDbType.Int, 4, model.UID),
AddInParameter("@Realname", SqlDbType.NVarChar, 50, model.Realname),
AddInParameter("@QQ", SqlDbType.VarChar, 50, model.QQ),
AddInParameter("@MSN", SqlDbType.VarChar, 50, model.MSN),
AddInParameter("@Skype", SqlDbType.VarChar, 50, model.Skype),
AddInParameter("@Phone", SqlDbType.Char, 16, model.Phone),
AddInParameter("@Mobilephone", SqlDbType.Char, 11, model.Mobilephone),
AddInParameter("@Location", SqlDbType.NVarChar, 50, model.Location),
AddInParameter("@Adress", SqlDbType.NVarChar, 200, model.Adress),
AddInParameter("@IDcard", SqlDbType.VarChar, 18, model.IDcard),
AddInParameter("@Signature", SqlDbType.NVarChar, 200, model.Signature),
AddInParameter("@Introduce", SqlDbType.NVarChar, 500, model.Introduce),
AddInParameter("@Website", SqlDbType.VarChar, 200, model.Website)
};
return(dbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), cmdParms));
}
/// <summary>
/// 由一行数据得到一个实体
/// </summary>
/// <param name="dr">SqlDataReader对象</param>
/// <returns>实体对象</returns>
private Userfields GetModel(SqlDataReader dr)
{
Userfields model = new Userfields();
model.UID = dbHelper.GetInt(dr["UID"]);
model.Realname = dbHelper.GetString(dr["Realname"]);
model.QQ = dbHelper.GetString(dr["QQ"]);
model.MSN = dbHelper.GetString(dr["MSN"]);
model.Skype = dbHelper.GetString(dr["Skype"]);
model.Phone = dbHelper.GetString(dr["Phone"]);
model.Mobilephone = dbHelper.GetString(dr["Mobilephone"]);
model.Location = dbHelper.GetString(dr["Location"]);
model.Adress = dbHelper.GetString(dr["Adress"]);
model.IDcard = dbHelper.GetString(dr["IDcard"]);
model.Signature = dbHelper.GetString(dr["Signature"]);
model.Introduce = dbHelper.GetString(dr["Introduce"]);
model.Website = dbHelper.GetString(dr["Website"]);
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model">实体对象</param>
/// <returns>返回影响行数</returns>
public int Update(Userfields model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE " + tablePrefix + "Userfields SET ");
strSql.Append("Realname=@Realname,");
strSql.Append("QQ=@QQ,");
strSql.Append("MSN=@MSN,");
strSql.Append("Skype=@Skype,");
strSql.Append("Phone=@Phone,");
strSql.Append("Mobilephone=@Mobilephone,");
strSql.Append("Location=@Location,");
strSql.Append("Adress=@Adress,");
strSql.Append("IDcard=@IDcard,");
strSql.Append("Signature=@Signature,");
strSql.Append("Introduce=@Introduce,");
strSql.Append("Website=@Website");
strSql.Append(" WHERE UID=@UID");
SqlParameter[] cmdParms =
{
AddInParameter("@Realname", SqlDbType.NVarChar, 50, model.Realname),
AddInParameter("@QQ", SqlDbType.VarChar, 50, model.QQ),
AddInParameter("@MSN", SqlDbType.VarChar, 50, model.MSN),
AddInParameter("@Skype", SqlDbType.VarChar, 50, model.Skype),
AddInParameter("@Phone", SqlDbType.Char, 16, model.Phone),
AddInParameter("@Mobilephone", SqlDbType.Char, 11, model.Mobilephone),
AddInParameter("@Location", SqlDbType.NVarChar, 50, model.Location),
AddInParameter("@Adress", SqlDbType.NVarChar, 200, model.Adress),
AddInParameter("@IDcard", SqlDbType.VarChar, 18, model.IDcard),
AddInParameter("@Signature", SqlDbType.NVarChar, 200, model.Signature),
AddInParameter("@Introduce", SqlDbType.NVarChar, 500, model.Introduce),
AddInParameter("@Website", SqlDbType.VarChar, 200, model.Website),
AddInParameter("@UID", SqlDbType.Int, 4, model.UID)
};
return(dbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), cmdParms));
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model">实体对象</param>
/// <returns>返回影响行数</returns>
public int Update(Userfields model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="model">实体对象</param>
/// <returns>返回影响行数</returns>
public int Add(Userfields model)
{
return(dal.Add(model));
}
