/// <summary> /// 由一行数据得到一个实体 /// </summary> /// <param name="dr">SqlDataReader对象</param> /// <returns>实体对象</returns> private Arc_Soft GetModel(SqlDataReader dr) { Arc_Soft model = new Arc_Soft(); model.AID = dbHelper.GetInt(dr["AID"]); return(model); }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">实体对象</param> /// <returns>返回影响行数</returns> public int Update(Arc_Soft model) { StringBuilder strSql = new StringBuilder(); strSql.Append("UPDATE " + tablePrefix + "Arc_Soft SET "); strSql.Append("AID=@AID"); strSql.Append(" WHERE AID=@AID"); SqlParameter[] cmdParms = { AddInParameter("@AID", SqlDbType.Int, 4, model.AID), AddInParameter("@AID", SqlDbType.Int, 4, model.AID) }; return(dbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), cmdParms)); }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="AID">编号ID</param> /// <returns>返回影响行数</returns> public int Add(Arc_Soft model) { StringBuilder strSql = new StringBuilder(); strSql.Append("INSERT INTO " + tablePrefix + "Arc_Soft("); strSql.Append("AID)"); strSql.Append(" VALUES ("); strSql.Append("@AID)"); SqlParameter[] cmdParms = { AddInParameter("@AID", SqlDbType.Int, 4, model.AID) }; return(dbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), cmdParms)); }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">实体对象</param> /// <returns>返回影响行数</returns> public int Update(Arc_Soft model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="model">实体对象</param> /// <returns>返回影响行数</returns> public int Add(Arc_Soft model) { return(dal.Add(model)); }