protected virtual IDbDataParameter AddParameter(IDbCommand cmd, string paramName, object value) { IDbDataParameter parameter; switch (paramName) { case "User_ID": parameter = _db.AddParameter(cmd, paramName, DbType.String, value); break; case "User_Name": parameter = _db.AddParameter(cmd, paramName, DbType.String, value); break; case "User_Pwd": parameter = _db.AddParameter(cmd, paramName, DbType.String, value); break; case "User_Email": parameter = _db.AddParameter(cmd, paramName, DbType.String, value); break; case "User_Address": parameter = _db.AddParameter(cmd, paramName, DbType.String, value); break; case "User_PhoneNum": parameter = _db.AddParameter(cmd, paramName, DbType.String, value); break; case "User_Im": parameter = _db.AddParameter(cmd, paramName, DbType.String, value); break; case "User_Website": parameter = _db.AddParameter(cmd, paramName, DbType.String, value); break; case "User_isActive": parameter = _db.AddParameter(cmd, paramName, DbType.Boolean, value); break; case "User_CreatedDate": parameter = _db.AddParameter(cmd, paramName, DbType.DateTime, value); break; case "User_ModifiedDate": parameter = _db.AddParameter(cmd, paramName, DbType.DateTime, value); break; default: throw new ArgumentException("Unknown parameter name (" + paramName + ")."); } return(parameter); }
public DataTable vc_Execute_Sql(String sSql) { IDbCommand cmd = _db.CreateCommand("vc_Execute_Sql", true); _db.AddParameter(cmd, "sSql", DbType.String, sSql); DataTable table = _db.CreateDataTable(cmd); return(table); }