/// <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)); }