datainsertandupdateanddelete.cs

来自「提供数据库访问 直接调用你的方法 根据需求 合理使用」· CS 代码 · 共 62 行

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;
namespace DBO
{
    public class DataInsertAndUpdateAndDelete
    {
        #region 执行增删改 操作的方法 SqlInsertAndUpdateAndDeleteRecord
        /// <summary>
        /// 执行增删改 操作的方法
        /// </summary>
        /// <param name="procName"></param>
        /// <param name="isProc"></param>
        /// <param name="objParm"></param>
        /// <returns></returns>
        public static int SqlInsertAndUpdateAndDeleteRecord(string procName, bool isProc,params SqlParameter[] objParm)//parms 表示可变参数 
        {
            string getDBO = ReadAppData.getDataOnwer;
            SqlCommand objCommand = new SqlCommand(getDBO + "." + procName, CreateConnection.ObjConnection);
            if (isProc == false)
            {
                objCommand.CommandText = procName;
            }
            if (isProc == true)
            {
                objCommand.CommandType = CommandType.StoredProcedure;
                objCommand.Parameters.AddRange(objParm);
            }
            return objCommand.ExecuteNonQuery();
        }
        #endregion

        #region 执行增删改 操作的方法 SqlInsertAndUpdateAndDeleteRecord
        /// <summary>
        /// 执行增删改 操作的方法
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public static int SqlInsertAndUpdateAndDeleteRecord(string sql)
        {
            SqlCommand objCommand = new SqlCommand(sql, CreateConnection.ObjConnection);
            return objCommand.ExecuteNonQuery();
        }
        #endregion

        #region  //通过DataAdapter 对象数据进行增删改查 SqlInsertAndUpdateAndDeleteRecord
        /// <summary>
        /// 通过DataAdapter 对象数据进行增删改查
        /// </summary>
        /// <param name="objAdapter"></param>
        /// <param name="objDataSet"></param>
        public static void SqlInsertAndUpdateAndDeleteRecord(SqlDataAdapter objAdapter, DataSet objDataSet)
        {
            SqlCommandBuilder objBuilder = new SqlCommandBuilder(objAdapter);
            objAdapter.Update(objDataSet);
        }
        #endregion
    }
}