public int SelectExist(DatabaseAccessObject databaseAccessObject, string cmdText, params System.Data.SqlClient.SqlParameter[] parameterArray) { string parameterText = ""; using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(cmdText, databaseAccessObject.Connection)) { cmd.Transaction = databaseAccessObject.Transaction; if (parameterArray.Length != 0) { int parameterCount = 0; foreach (System.Data.SqlClient.SqlParameter parameter in parameterArray) { cmd.Parameters.Add(parameter); if (parameterCount != 0) { parameterText += ","; } parameterText += parameter.ParameterName + "(" + parameter.SqlDbType + ") = " + parameter.Value; parameterCount += 1; } } using (System.Data.SqlClient.SqlDataAdapter dataAdapter = new System.Data.SqlClient.SqlDataAdapter()) { DataTable data = new DataTable(); dataAdapter.SelectCommand = cmd; dataAdapter.Fill(data); return(data.Rows.Count); } } }
public int OperateData(DatabaseAccessObject databaseAccessObject, string cmdText, params System.Data.SqlClient.SqlParameter[] parameterArray) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(cmdText, databaseAccessObject.Connection)) { string parameterText = ""; cmd.Transaction = databaseAccessObject.Transaction; if (parameterArray.Length != 0) { int parameterCount = 0; foreach (System.Data.SqlClient.SqlParameter parameter in parameterArray) { cmd.Parameters.Add(parameter); if (parameterCount != 0) { parameterText += ","; } parameterText += parameter.ParameterName + "(" + parameter.SqlDbType + ") = " + parameter.Value; parameterCount += 1; } } int affectedRow = cmd.ExecuteNonQuery(); return(affectedRow); } }